guest_document

334 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
guest.doc_id fk_guest_doc_id R
guest_id int4 10 null
guest.id fk_guest_document_id C
doc_type int2 5 null
doc_number text 2147483647 null
expire_date date 13 null
country_id int4 10 null
photo_file uuid 2147483647 null
files.id fk_guest_document_photo_file R
image_file uuid 2147483647 null
files.id fk_guest_document_image_file R
doc_data jsonb 2147483647 null
photo_url text 2147483647 null
image_url text 2147483647 null
photo_path text 2147483647 null
image_path text 2147483647 null
tag text 2147483647 null
signature_url text 2147483647 null
signature_path text 2147483647 null
nation_id int4 10 null
is_assigned bool 1 (guest_id IS NOT NULL)
url_updated_time timestamptz 35,6 CURRENT_TIMESTAMP
assign_time timestamp 29,6 CURRENT_TIMESTAMP
create_time timestamptz 35,6 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
pk_guest_document Primary key Asc id
idx_guest_document_guest_id Performance Asc guest_id
idx_guest_document_image_file Performance Asc image_file
idx_guest_document_photo_file Performance Asc photo_file

Relationships