| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| AgentARN | varchar(255) | false | ||||
| Timestamp | timestamp without time zone | false | ||||
| UserName | varchar(255) | true | ||||
| Queue | varchar(255) | true | ||||
| RoutingProfile | varchar(255) | true | ||||
| Status | varchar(255) | true | ||||
| Channel | varchar(255) | true | ||||
| ContactId | varchar(255) | true | ||||
| InitiationMethod | varchar(255) | true | ||||
| ContactState | varchar(255) | true | ||||
| db_last_updated | timestamp without time zone | true | ||||
| UserShortName | varchar | true |
| Name | Type | Definition |
|---|---|---|
| pk_agentstatushistory | PRIMARY KEY | PRIMARY KEY (“AgentARN”, “Timestamp”) |
| Name | Definition |
|---|---|
| pk_agentstatushistory | CREATE UNIQUE INDEX pk_agentstatushistory ON contactcentredb.agentstatushistory USING btree (“AgentARN”, “Timestamp”) |
Generated by tbls