precheckin_legal_acceptance

0 rows


Description

Audit trail of terms/privacy acceptance captured on the guest pre-checkin form, written by rpc.precheckin_legal_accept.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('precheckin_legal_acceptance_id_seq'::regclass)
booking_id int4 10 null
booking.id precheckin_legal_acceptance_booking_id_fkey R
guest_id int4 10 √ null
guest.id precheckin_legal_acceptance_guest_id_fkey R
doc_type varchar 20 null
lang_code varchar 5 null
precheckin_language.lang_code Implied Constraint R
version varchar 10 null
is_accepted bool 1 true
ip_address varchar 45 √ null
create_at timestamp 29,6 √ CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
precheckin_legal_acceptance_pkey Primary key Asc id

Check Constraints

Constraint Name Constraint
precheckin_legal_acceptance_doc_type_check ((doc_type)::text = ANY ((ARRAY['terms'::character varying, 'privacy'::character varying])::text[]))

Relationships

Close relationships within degrees of separation