guest_signature

0 rows


Description

Signature per stay/transaction: register_id=register card, folio_item_id=folio payment, booking_id=pre-check-in/tablet before check-in.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
register_id int4 10 √ null
registration.id guest_signature_register_id_fkey C
folio_item_id int4 10 √ null
folio_items.item_id guest_signature_folio_item_id_fkey C
booking_id int4 10 √ null
booking.id guest_signature_booking_id_fkey C
guest_id int4 10 √ null
guest.id guest_signature_guest_id_fkey R
signature_url text 2147483647 √ null
signature_path text 2147483647 √ null
signed_time timestamptz 35,6 √ now()
signed_user text 2147483647 √ null
signature_type text 2147483647 √ CASE WHEN (register_id IS NOT NULL) THEN 'registration'::text WHEN (folio_item_id IS NOT NULL) THEN 'folio_item'::text WHEN (booking_id IS NOT NULL) THEN 'booking'::text ELSE NULL::text END

Indexes

Constraint Name Type Sort Column(s)
guest_signature_pkey Primary key Asc id
uq_guest_signature_book Must be unique Asc/Asc booking_id + guest_id
uq_guest_signature_folio Must be unique Asc/Asc folio_item_id + guest_id
uq_guest_signature_reg Must be unique Asc/Asc register_id + guest_id

Check Constraints

Constraint Name Constraint
ck_guest_signature_one_ref (num_nonnulls(register_id, folio_item_id, booking_id) = 1)

Relationships

Close relationships within degrees of separation