public.daily_absents¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| daily_timesheet_id | bigint | false | public.daily_timesheets | |||
| id | bigint | false | ||||
| note | text | false | ||||
| reason | varchar(255) | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| daily_absents_daily_timesheet_id_d16e6dfc_fk_daily_tim | FOREIGN KEY | FOREIGN KEY (daily_timesheet_id) REFERENCES daily_timesheets(id) DEFERRABLE INITIALLY DEFERRED |
| daily_absents_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| daily_absents_daily_timesheet_id_d16e6dfc | CREATE INDEX daily_absents_daily_timesheet_id_d16e6dfc ON public.daily_absents USING btree (daily_timesheet_id) |
| daily_absents_pkey | CREATE UNIQUE INDEX daily_absents_pkey ON public.daily_absents USING btree (id) |
Generated by tbls