files


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID bigserial 19 nextval('"files_ID_seq"'::regclass)
creator int4 10 null
users.ID FK_files_creator N

The object creator

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

record int8 19 null
records.ID FK_files_record C
comment int8 19 null
comments.ID FK_files_comment C
filename text 2147483647 ''::text
mimetype text 2147483647 'application/octet-stream'::text
size int4 10 0
binfile int4 10 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_files_ID Primary key Asc ID
FK_files_comment Performance Asc comment
FK_files_record Performance Asc record

Relationships