public.headcountforecastdata

public.headcountforecastdata

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(100) false
businessunitid varchar(50) true
planninggroup varchar(50) true
scheduleid varchar(50) true
weekdate timestamp without time zone true
startdate timestamp without time zone true
startdateltc timestamp without time zone true
requiredperinterval numeric(20,2) true
requiredwithoutshrinkageperinterval numeric(20,2) true
updated timestamp without time zone true

Constraints

Name Type Definition
headcountforecastdata_key PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
headcountforecastdata_key CREATE UNIQUE INDEX headcountforecastdata_key ON public.headcountforecastdata USING btree (keyid)