Table: attachment

Previous: assignment_display

Unanet Data Model

Next: attachment_reference

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	attachment_key	decimal(15)
2.		attachment_name	varchar(255)
3.		attachment_data	image
4.		attachment_mime_type	varchar(255)
5.		attachment_length	decimal(15)

Referenced from

Table	Column	Foreign Key Name
attachment_reference	attachment_key	fk_attachment_reference1
bank_account	attachment_key	fk_bank_account3
customer_attachment	attachment_key	fk_customer_attachment2
expense_report_attachment	attachment_key	fk_expense_report_attachment2
fin_document_attachment	attachment_key	fk_fin_document_attachment2
image_setup	attachment_key	fk_image_setup1
note_comment_attachment	attachment_key	fk_note_comment_attachment2
person	po_signature_key	fk_person17
project_note_attachment	attachment_key	fk_project_note_attachment2

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_attachment	true	attachment_key	Asc