Description
Schedule Details Lookup Data
Columns
| keyid |
varchar(100) |
|
false |
|
|
|
| businessunitid |
varchar(50) |
|
true |
|
|
Schedule Business Unit GUID |
| scheduleid |
varchar(50) |
|
true |
|
|
|
| weekdate |
date |
|
true |
|
|
Schedule Week |
| weekcount |
bigint |
|
true |
|
|
Schedule Week Count |
| published |
bit(1) |
|
true |
|
|
Schedule Published ? |
| shorttermforecastid |
varchar(50) |
|
true |
|
|
Schedule Short Term Forecast GUID |
| modifiedby |
varchar(50) |
|
true |
|
|
Schedule Modified By GUID |
| genresultsfailed |
bit(1) |
|
true |
|
|
Schedule Results Failed ? |
| genresultsrunid |
varchar(50) |
|
true |
|
|
Schedule Results GUID |
| updated |
timestamp without time zone |
|
true |
|
|
Date Row Updated (UTC) |
| description |
varchar(400) |
|
true |
|
|
Schedule Description |
Constraints
| scheduledetails_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| scheduledetails_pkey |
CREATE UNIQUE INDEX scheduledetails_pkey ON public.scheduledetails
USING btree (keyid) |