public.service_term¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | (DC2Type:uuid) | |||
| terms_of_service_id | uuid | false | public.terms_of_service | (DC2Type:uuid) | ||
| action | varchar(255) | false | ||||
| applicable_phases | text | false | (DC2Type:simple_array) | |||
| due_fee_amount | bigint | true | ||||
| due_fee_currency | varchar(3) | true | ||||
| applicable_kinds | text | false | (DC2Type:simple_array) | |||
| type | 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) | ||
| is_action_allowed | boolean | false | false | |||
| applicable_roles | text | false | (DC2Type:simple_array) | |||
| legacy_type | varchar(255) | NULL::character varying | true |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_6b4c5361a5debc29 | FOREIGN KEY | FOREIGN KEY (terms_of_service_id) REFERENCES terms_of_service(id) |
| service_term_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| service_term_pkey | CREATE UNIQUE INDEX service_term_pkey ON public.service_term USING btree (id) |
| idx_6b4c5361a5debc29 | CREATE INDEX idx_6b4c5361a5debc29 ON public.service_term USING btree (terms_of_service_id) |
Relations¶
Generated by tbls