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


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


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