Description
Audit Table for Queue Membership changes
Columns
| keyid |
varchar(500) |
|
false |
|
|
Primary Key |
| queueid |
varchar(50) |
|
true |
|
|
Queue GUID |
| userid |
varchar(50) |
|
true |
|
|
User GUID |
| addorremove |
varchar(10) |
|
true |
|
|
Action to Add or Remove |
| datemodified |
timestamp without time zone |
|
true |
|
|
Date Modified (UTC) |
| datemodifiedltc |
timestamp without time zone |
|
true |
|
|
Date Modified (LTC) |
| modifiedby |
varchar(50) |
|
true |
|
|
Modified By GUID |
| updated |
timestamp without time zone |
|
true |
|
|
Date Row Updated (UTC) |
| activeorinactive |
varchar(20) |
|
true |
|
|
Action to make active or inactive |
Constraints
| queueauditdata_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| queueauditdata_pkey |
CREATE UNIQUE INDEX queueauditdata_pkey ON public.queueauditdata
USING btree (keyid) |