document

590 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
document_id uuid 2147483647 uuid_generate_v1()
file.document_id file_document_id_foreign C
task_document.document_id task_document_document_id_foreign R
name varchar 255 null
valid_until date 13 √ null
type text 2147483647 √ null
thumbnail_url varchar 255 √ null
notes varchar 255 √ null
farm_id uuid 2147483647 √ null
farm.farm_id document_farm_id_foreign C
deleted bool 1 √ false
created_by_user_id varchar 255 √ null
users.user_id document_created_by_user_id_foreign R
updated_by_user_id varchar 255 √ null
users.user_id document_updated_by_user_id_foreign R
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
no_expiration bool 1 √ false
archived bool 1 false

Indexes

Constraint Name Type Sort Column(s)
document_pkey Primary key Asc document_id

Relationships

Close relationships within degrees of separation