files


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int8 19 √ null

File ID
creator int4 10 √ null
users.ID fk_files_creator N

Creator user ID (defaults to authenticated user on creation)
creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)
record int8 19 √ null
records.ID fk_files_record C

Record ID (**dependency**); is mutually exclusive to comment (either one is required)
comment int8 19 √ null
comments.ID fk_files_comment C

Comment ID (**dependency**); is mutually exclusive to record (either one is required)
binfile int4 10 √ null
filename text 2147483647 ''::text

Filename
mimetype text 2147483647 'application/octet-stream'::text

MIME type (RFC 2045) (Pattern: ^[a-z]+/[^ \t\v\r\n]+$)
size int4 10 0

Size in bytes

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_files Primary key Asc ID
fk_files_comment Performance Asc comment
fk_files_record Performance Asc record
s_files Performance Asc filename

Relationships

Close relationships within degrees of separation