public.access_grant¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | (DC2Type:uuid) | |||
| club_id | uuid | false | public.club | (DC2Type:uuid) | ||
| created_at | timestamp(0) with time zone | false | (DC2Type:datetimetz_immutable) | |||
| entity_type | varchar(255) | false | ||||
| code | varchar(255) | false | ||||
| valid_from | date | false | (DC2Type:date_immutable) | |||
| valid_till | date | false | (DC2Type:date_immutable) | |||
| contentful_id | varchar(64) | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_20901a1f61190a32 | FOREIGN KEY | FOREIGN KEY (club_id) REFERENCES club(id) |
| access_grant_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| access_grant_pkey | CREATE UNIQUE INDEX access_grant_pkey ON public.access_grant USING btree (id) |
| idx_20901a1f61190a32 | CREATE INDEX idx_20901a1f61190a32 ON public.access_grant USING btree (club_id) |
| uniq_20901a1fd756ce8c | CREATE UNIQUE INDEX uniq_20901a1fd756ce8c ON public.access_grant USING btree (contentful_id) |
Relations¶
Generated by tbls