Index

public.file_uploads

Description

Stores metadata regarding files uploaded to the server by users or exercise services.

Columns

Name Type Default Nullable Children Parents Comment
created_at timestamp with time zone now() false Timestamp when the record was created.
deleted_at timestamp with time zone true Timestamp when the record was deleted. If null, the record is not deleted.
id uuid uuid_generate_v4() false public.certificate_configurations public.certificate_fonts A unique, stable identifier for the record.
mime varchar(255) false The mime type of the uploaded file.
name varchar(255) false The name of the uploaded file.
path varchar(255) false The path to the uploaded file.
updated_at timestamp with time zone now() false Timestamp when the record was last updated. The field is updated automatically by the set_timestamp trigger.
uploaded_by_user uuid true public.users The id of the user who uploaded the file. Null for uploads from other sources, such as exercise services.

Constraints

Name Type Definition
file_uploads_pkey PRIMARY KEY PRIMARY KEY (id)
file_uploads_uploaded_by_user_fkey FOREIGN KEY FOREIGN KEY (uploaded_by_user) REFERENCES users(id)

Indexes

Name Definition
file_uploads_pkey CREATE UNIQUE INDEX file_uploads_pkey ON public.file_uploads USING btree (id)

Relations

er

Generated by tbls