System conversation usage statistics per minute
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| keyid | varchar(100) | false | Primary Key | |||
| rowdate | timestamp without time zone | true | Date/time for the minute slot | |||
| mediatype | varchar(50) | true | Media type e.g., voice, chat | |||
| originaldirection | varchar(50) | true | Original direction of segment | |||
| purpose | varchar(50) | true | Segment purpose - system or agent or external | |||
| segmenttype | varchar(50) | true | Segment type | |||
| liveinteractioncount | integer | true | Live interaction count for the minute | |||
| updated | timestamp without time zone | true | Date Row Updated (UTC) |
| Name | Type | Definition |
|---|---|---|
| systemcallusagedata_pkey | PRIMARY KEY | PRIMARY KEY (keyid) |
| Name | Definition |
|---|---|
| systemcallusagedata_pkey | CREATE UNIQUE INDEX systemcallusagedata_pkey ON public.systemcallusagedata USING btree (keyid) |