public.holiday_name¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | Unique identifier for the holiday name entry(DC2Type:uuid) | |||
| holiday_id | uuid | false | public.holiday | Reference to the holiday this name belongs to(DC2Type:uuid) | ||
| name | varchar(255) | false | Localized name of the holiday in the specified language | |||
| language_iso_code | varchar(10) | false | ISO language code (e.g., "en", "de", "fr") for the localized name |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_3dd5217f830a3ec0 | FOREIGN KEY | FOREIGN KEY (holiday_id) REFERENCES holiday(id) |
| holiday_name_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| holiday_name_pkey | CREATE UNIQUE INDEX holiday_name_pkey ON public.holiday_name USING btree (id) |
| idx_3dd5217f830a3ec0 | CREATE INDEX idx_3dd5217f830a3ec0 ON public.holiday_name USING btree (holiday_id) |
| uniq_3dd5217f830a3ec0e14fc64 | CREATE UNIQUE INDEX uniq_3dd5217f830a3ec0e14fc64 ON public.holiday_name USING btree (holiday_id, language_iso_code) |
Relations¶
Generated by tbls