public.holiday¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | public.holiday_name | (DC2Type:uuid) | ||
| created_at | timestamp(0) with time zone | false | (DC2Type:datetimetz_immutable) | |||
| start_date | date | false | (DC2Type:date_immutable) | |||
| end_date | date | false | (DC2Type:date_immutable) | |||
| is_nationwide | boolean | false | ||||
| open_holiday_id | uuid | false | (DC2Type:uuid) | |||
| name | varchar(255) | false | ||||
| country_iso_code | varchar(10) | false | ||||
| subdivisions | text | true | (DC2Type:simple_array) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| holiday_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| holiday_pkey | CREATE UNIQUE INDEX holiday_pkey ON public.holiday USING btree (id) |
Relations¶
Generated by tbls