public.club_price_list¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | (DC2Type:uuid) | |||
| assigned_club_id | uuid | false | public.club | (DC2Type:uuid) | ||
| created_at | date | false | (DC2Type:date_immutable) | |||
| valid_from | date | false | (DC2Type:date_immutable) | |||
| pricing | json | false | ||||
| contentful_id | varchar(64) | false | ||||
| fallback_price_per_hour_amount | bigint | false | ||||
| fallback_price_per_hour_currency | character(3) | false | (DC2Type:currency) | |||
| is_active | boolean | false | false | |||
| title | varchar(255) | NULL::character varying | true |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_705c444f6b81b2bd | FOREIGN KEY | FOREIGN KEY (assigned_club_id) REFERENCES club(id) |
| club_price_list_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| club_price_list_pkey | CREATE UNIQUE INDEX club_price_list_pkey ON public.club_price_list USING btree (id) |
| idx_705c444f6b81b2bd | CREATE INDEX idx_705c444f6b81b2bd ON public.club_price_list USING btree (assigned_club_id) |
| uniq_705c444fd756ce8c | CREATE UNIQUE INDEX uniq_705c444fd756ce8c ON public.club_price_list USING btree (contentful_id) |
Relations¶
Generated by tbls