| 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 |
|
|
Record ID (**dependency**); is mutually exclusive to comment (either one is required) |
|
int8 |
19 |
√ |
|
null |
|
|
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 |
