Skip to content

public.access_grant

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false Primary identifier of the access grant (UUID).(DC2Type:uuid)
club_id uuid false public.club Associated club to which this access grant belongs.(DC2Type:uuid)
created_at timestamp(0) with time zone false Date and time when the access grant was created.(DC2Type:datetimetz_immutable)
entity_type varchar(255) false Type of entity being granted access, e.g., FACILITY_DOOR or RACKET_BOX.
code varchar(255) false The actual code used to authorize access, such as a door PIN or box code.
valid_from date false Start date from which this access grant is valid.(DC2Type:date_immutable)
valid_till date false End date until which this access grant remains valid.(DC2Type:date_immutable)
contentful_id varchar(64) false Identifier synced with Contentful CMS to track content entry.

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

er


Generated by tbls