public.offeredforecastdata
Columns
| keyid |
varchar(150) |
|
false |
|
|
|
| businessunitid |
varchar(50) |
|
true |
|
|
|
| scheduleid |
varchar(50) |
|
true |
|
|
|
| planninggroup |
varchar(50) |
|
true |
|
|
|
| shorttermforecastid |
varchar(50) |
|
true |
|
|
|
| startdate |
timestamp without time zone |
|
true |
|
|
|
| startdateltc |
timestamp without time zone |
|
true |
|
|
|
| weekdate |
date |
|
true |
|
|
|
| week |
bigint |
|
true |
|
|
|
| avghandleperinterval |
numeric(20,2) |
|
true |
|
|
|
| offeredperinterval |
numeric(20,2) |
|
true |
|
|
|
| canuseforscheduling |
boolean |
|
true |
|
|
|
| updated |
timestamp without time zone |
|
true |
|
|
|
Constraints
| offeredforecastdata_pkey |
PRIMARY KEY |
PRIMARY KEY (keyid) |
Indexes
| offeredforecastdata_pkey |
CREATE UNIQUE INDEX offeredforecastdata_pkey ON
public.offeredforecastdata USING btree (keyid) |
| ix_offeredforecastdata_weekdate |
CREATE INDEX ix_offeredforecastdata_weekdate ON
public.offeredforecastdata USING btree (weekdate) |