Description
Adherence Actual Activity Data
Columns
| keyid |
varchar(100) |
|
false |
|
|
Primary Key |
| userid |
varchar(50) |
|
true |
|
|
User GUID |
| startdate |
timestamp without time zone |
|
true |
|
|
Start Time (UTC) |
| startdateltc |
timestamp without time zone |
|
true |
|
|
Start Time (LTC) |
| enddateltc |
timestamp without time zone |
|
true |
|
|
End Time (LTC) |
| enddate |
timestamp without time zone |
|
true |
|
|
End Time (UTC) |
| durationsecs |
integer |
|
true |
|
|
Duration in Sec(s) |
| actualactivitycategory |
varchar(50) |
|
true |
|
|
Actual Activity Category |
| updated |
timestamp without time zone |
|
true |
|
|
Date Row Updated |
Constraints
| adherenceactdata_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| adherenceactdata_pkey |
CREATE UNIQUE INDEX adherenceactdata_pkey ON public.adherenceactdata
USING btree (keyid) |