public.actual_time_entries¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| bc_system_id | uuid | true | ||||
| day_id | bigint | false | public.daily_timesheets | |||
| end_time | time without time zone | false | ||||
| id | bigint | false | ||||
| start_time | time without time zone | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| actual_time_entries_day_id_3b76ae73_fk_daily_timesheets_id | FOREIGN KEY | FOREIGN KEY (day_id) REFERENCES daily_timesheets(id) DEFERRABLE INITIALLY DEFERRED |
| actual_time_entries_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| actual_time_entries_day_id_3b76ae73 | CREATE INDEX actual_time_entries_day_id_3b76ae73 ON public.actual_time_entries USING btree (day_id) |
| actual_time_entries_pkey | CREATE UNIQUE INDEX actual_time_entries_pkey ON public.actual_time_entries USING btree (id) |
Generated by tbls