#	Column Name	Nullable	Data Type	Max Length	Description
1	attachment_id		bigint	0	The primary key of this table, which is also a bigserial field.
2	user_id		integer	0	Foreign key to the table office.users.
3	resource		text	0
4	resource_key		text	0
5	resource_id		bigint	0
6	original_file_name		text	0	The name given to the attached file, which is also a unique field
7	file_extension		character varying	12	The extension of the attached file.
8	file_path		text	0	The location of the file.
9	comment		character varying	96	Comment on the attachment.
10	added_on		timestamp with time zone	0	Time & date when the attachment was added.

Foreign Keys

#	Column Name	Key Name	References
2	user_id	attachments_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
attachments_pkey	postgres	btree	attachment_id
attachments_file_path_uix	postgres	btree	upper(file_path)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	attachment_id	nextval('core.attachments_attachment_id_seq'::regclass)
9	comment	''::character varying
10	added_on	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description