reservation


Columns

Column Type Size Nulls Auto Default Children Parents Comments
reservation_id int8 19 √ null
version int4 10 0
created_by text 2147483647 √ null
modified_by text 2147483647 √ null
deleted_by text 2147483647 √ null
created_at timestamptz 35,6 now()
modified_at timestamptz 35,6 now()
deleted_at timestamptz 35,6 √ null
exam_event_id int8 19 null
exam_event.exam_event_id fk_reservation_exam_event R
person_id int8 19 null
person.person_id fk_reservation_person R
expires_at timestamptz 35,6 null
renewed_at timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
reservation_pkey Primary key Asc reservation_id
uk_reservation_exam_event_person Must be unique Asc/Asc exam_event_id + person_id

Relationships

Close relationships within degrees of separation