| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| keyid | varchar(200) | false | ||||
| userid | varchar(50) | true | ||||
| startdate | timestamp without time zone | true | ||||
| startdateltc | timestamp without time zone | true | ||||
| enddate | timestamp without time zone | true | ||||
| enddateltc | timestamp without time zone | true | ||||
| totalhrs | numeric(20,2) | true | ||||
| breakhrs | numeric(20,2) | true | ||||
| updated | timestamp without time zone | true |
| Name | Type | Definition |
|---|---|---|
| hoursblockdata_pkey | PRIMARY KEY | PRIMARY KEY (keyid) |
| Name | Definition |
|---|---|
| hoursblockdata_pkey | CREATE UNIQUE INDEX hoursblockdata_pkey ON public.hoursblockdata USING btree (keyid) |
| hoursblockdataenddate | CREATE INDEX hoursblockdataenddate ON public.hoursblockdata USING btree (enddate) |
| hoursblockdatauserid | CREATE INDEX hoursblockdatauserid ON public.hoursblockdata USING btree (userid) |
| hoursblockedate | CREATE INDEX hoursblockedate ON public.hoursblockdata USING btree (startdate) |