public.userpresencedatamonthly
Description
User presence data monthly (LTC)
Columns
| 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 |
|
|
|
Constraints
| userpresencedatamonthly_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| userpresencedatamonthly_pkey |
CREATE UNIQUE INDEX userpresencedatamonthly_pkey ON
public.userpresencedatamonthly USING btree (keyid) |