erDiagram
AGENT {
string id PK
string rcUsername "RC username, np. maya"
int hierarchyLevel "0=Human,1=Exec,2=Manager,3=Specialist"
string supervisorAgentId "RC username przełożonego"
string canOrderAgents "CSV: lista agentów"
int totalOrdersReceived
int totalOrdersCompleted
float avgResolutionRating "średnia 1-5"
}
AGENT_ORDER {
string id PK
string orderRef "ORD-XXXXX"
string status "CREATED/RECEIVED/IN_PROGRESS/RESOLVED/REVIEWED/BLOCKED/ESCALATED/CANCELLED/OVERDUE"
string priority "CRITICAL/HIGH/NORMAL/LOW"
string supervisorAgentId "kto wydał"
string subordinateAgentId "kto otrzymał"
string orderTitle
string orderDescription
datetime deadline
string resolutionDescription
int resolutionRating "1-5"
string resolutionNotes
string blockerDescription
string escalatedToAgentId
datetime receivedAt
datetime startedAt
datetime resolvedAt
datetime reviewedAt
string publishedToChannel
boolean humanApproved
string relatedAgentTaskId
string rcMessageId
}
AGENT ||--o{ AGENT_ORDER : "supervises (supervisorAgentId)"
AGENT ||--o{ AGENT_ORDER : "executes (subordinateAgentId)"