public.event_template¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | public.club_event | Unique identifier of the event template.(DC2Type:uuid) | ||
| teaser_image_id | uuid | true | public.image | Reference to the teaser/preview image for this event template.(DC2Type:uuid) | ||
| contentful_id | varchar(64) | false | Unique Contentful CMS identifier for syncing event template content. | |||
| title | varchar(255) | false | Display title of the event template. | |||
| subtitle | varchar(255) | false | Short subtitle or tagline for the event template. | |||
| description | text | false | Detailed description of the event template. | |||
| is_active | boolean | false | false | Whether the event template is currently active and available for use. | ||
| stripe_product_id | varchar(64) | NULL::character varying | false | Stripe product identifier for payment processing and billing. |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_d18cf653f56f16cf | FOREIGN KEY | FOREIGN KEY (teaser_image_id) REFERENCES image(id) |
| event_template_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| event_template_pkey | CREATE UNIQUE INDEX event_template_pkey ON public.event_template USING btree (id) |
| uniq_d18cf653d756ce8c | CREATE UNIQUE INDEX uniq_d18cf653d756ce8c ON public.event_template USING btree (contentful_id) |
| uniq_d18cf653f56f16cf | CREATE UNIQUE INDEX uniq_d18cf653f56f16cf ON public.event_template USING btree (teaser_image_id) |
| uniq_d18cf6533e8ac0d2 | CREATE UNIQUE INDEX uniq_d18cf6533e8ac0d2 ON public.event_template USING btree (stripe_product_id) |
Relations¶
Generated by tbls