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

Close relationships within degrees of separation