public.timeoffdata

public.timeoffdata

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(100) false
userid varchar(50) true Agent GUID
buid varchar(50) true Business Unit GUID
scheduleid varchar(50) true Schedule GUID
businessunitdate timestamp without time zone true Business Unit Date (UTC)
length integer true Length of Time Off (Seconds)
description varchar(200) true Description of Time Off
activitycode varchar(50) true Activity Code GUID
paid bit(1) true Paid Time Off (True/False)
timeoffrequestid varchar(50) true Time Off Request GUID
isfulldayrequest bit(1) true Is Full Day Request (True/False)
updated timestamp without time zone true Date Row Updated (UTC)

Constraints

Name Type Definition
timeoffdata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
timeoffdata_pkey CREATE UNIQUE INDEX timeoffdata_pkey ON public.timeoffdata USING btree (keyid)