public.shrinkagedata

public.shrinkagedata

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(100) false
id varchar(50) true
startdate timestamp without time zone true
enddate timestamp without time zone true
activitycategory varchar(255) true
scheduledshrinkageseconds numeric(20,2) true
scheduledshrinkagepercent numeric(20,2) true
actualshrinkageseconds numeric(20,2) true
actualshrinkagepercent numeric(20,2) true
paidshrinkageseconds numeric(20,2) true
unpaidshrinkageseconds numeric(20,2) true
plannedshrinkageseconds numeric(20,2) true
unplannedshrinkageseconds numeric(20,2) true
updated timestamp without time zone true
businessunitids varchar(100) true

Constraints

Name Type Definition
shrinkagedata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
shrinkagedata_pkey CREATE UNIQUE INDEX shrinkagedata_pkey ON public.shrinkagedata USING btree (keyid)