public.activeqmembersdata
Description
Historical Active Membership of Queues
Columns
| keyid |
varchar(100) |
|
false |
|
|
Primary Key |
| queueid |
varchar(50) |
|
true |
|
|
|
| startdate |
timestamp without time zone |
|
true |
|
|
Start Time (UTC) |
| startdateltc |
timestamp without time zone |
|
true |
|
|
Start Time (LTC) |
| activemembers |
integer |
|
true |
|
|
Count of Active Members |
| memberusers |
integer |
|
true |
|
|
Count of Members |
| onqueueusers |
integer |
|
true |
|
|
Count of On-Queue Members |
| offqueueusers |
integer |
|
true |
|
|
Count of Off-Queue Members |
| updated |
timestamp without time zone |
|
true |
|
|
Date Updated |
Constraints
| activeqmembersdata_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Primary Key Constraint |
Indexes
| activeqmembersdata_pkey |
CREATE UNIQUE INDEX activeqmembersdata_pkey ON
public.activeqmembersdata USING btree (keyid) |