guest_document

319 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 N
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
pending_assignment bool 1 true
last_scan_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
uq_guest_document_identity Must be unique Asc/Asc doc_type + country_id

Relationships

Close relationships within degrees of separation