public.event_term¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | (DC2Type:uuid) | |||
| action | varchar(255) | false | ||||
| applicable_from | timestamp(0) with time zone | NULL::timestamp with time zone | true | (DC2Type:datetimetz_immutable) | ||
| applicable_till | timestamp(0) with time zone | NULL::timestamp with time zone | true | (DC2Type:datetimetz_immutable) | ||
| type | varchar(255) | false | ||||
| legacy_type | varchar(255) | NULL::character varying | true | |||
| due_fee_amount | bigint | false | ||||
| due_fee_currency | varchar(3) | false | ||||
| is_action_allowed | boolean | false | ||||
| event_registration_id | uuid | false | public.event_registration | (DC2Type:uuid) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_bac4ab264aeeeb73 | FOREIGN KEY | FOREIGN KEY (event_registration_id) REFERENCES event_registration(id) |
| event_term_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| event_term_pkey | CREATE UNIQUE INDEX event_term_pkey ON public.event_term USING btree (id) |
| idx_bac4ab264aeeeb73 | CREATE INDEX idx_bac4ab264aeeeb73 ON public.event_term USING btree (event_registration_id) |
Relations¶
Generated by tbls