moped_project_files

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
project_file_id serial 10 √ nextval('moped_project_files_project_file_id_seq'::regclass)
project_id int4 10 null
moped_project.project_id moped_project_files_project_id_fkeyC
file_key text 2147483647 √ null
file_name text 2147483647 null
file_description text 2147483647 √ null
file_size int4 10 null
file_permissions jsonb 2147483647 √ null
file_metadata jsonb 2147483647 √ null
api_response jsonb 2147483647 √ null
created_by_user_id int4 10 null
moped_users.user_id moped_project_files_created_by_fkeyR
created_at timestamptz 35,6 now()
is_scanned bool 1 false
is_deleted bool 1 false

Indicates soft deletion
file_type int4 10 0
moped_file_types.id moped_project_files_type_fkeyR
file_url text 2147483647 √ null
updated_at timestamptz 35,6 √ now()

Timestamp when the record was last updated
updated_by_user_id int4 10 √ null
moped_users.user_id updated_by_user_fkeyR

ID of the user who last updated the record

Indexes

Constraint Name Type Sort Column(s)
moped_project_files_pkey Primary key Asc project_file_id

Relationships

Close relationships within degrees of separation