User presence data daily (LTC)
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| keyid | varchar(255) | false | ||||
| id | varchar(50) | true | ||||
| userid | varchar(50) | true | ||||
| startdate | timestamp without time zone | true | ||||
| timetype | varchar(50) | true | ||||
| systempresenceid | varchar(50) | true | ||||
| presenceid | varchar(50) | true | ||||
| presencetime | numeric(20,2) | true | ||||
| routingid | varchar(50) | true | ||||
| routingtime | numeric(20,2) | true | ||||
| updated | timestamp without time zone | true |
| Name | Type | Definition |
|---|---|---|
| userpresencedatadaily_pkey | PRIMARY KEY | PRIMARY KEY (keyid) |
| Name | Definition |
|---|---|
| userpresencedatadaily_pkey | CREATE UNIQUE INDEX userpresencedatadaily_pkey ON public.userpresencedatadaily USING btree (keyid) |
| userpresencedailydatatype | CREATE INDEX userpresencedailydatatype ON public.userpresencedatadaily USING btree (timetype) |
| userpresencedailystart | CREATE INDEX userpresencedailystart ON public.userpresencedatadaily USING btree (startdate) |
| userpresencedailyuser | CREATE INDEX userpresencedailyuser ON public.userpresencedatadaily USING btree (userid) |