Skip to content

public.event_term

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false Unique identifier for the event term(DC2Type:uuid)
action varchar(255) false Action type (e.g., OWNER_CANCELS_EVENT_REGISTRATION, ADMIN_CANCELS_EVENT_REGISTRATION_FULL_REFUND)
applicable_from timestamp(0) with time zone NULL::timestamp with time zone true Start date/time from which this term is applicable(DC2Type:datetimetz_immutable)
applicable_till timestamp(0) with time zone NULL::timestamp with time zone true End date/time until which this term is applicable(DC2Type:datetimetz_immutable)
type varchar(255) false Type of term or fee structure
legacy_type varchar(255) NULL::character varying true Legacy type identifier for backward compatibility
due_fee_amount bigint false Due fee amount in smallest currency unit (e.g., cents)
due_fee_currency varchar(3) false Currency code for the due fee (ISO 4217 format)
is_action_allowed boolean false Indicates whether the action is allowed under this term
event_registration_id uuid false public.event_registration Reference to the event registration this term applies to(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

er


Generated by tbls