Table: attachment_reference

Previous: attachment Unanet Data Model Next: bank_account
Columns
  Column Name Data Type Default
Value		 References
Table		 Foreign Key
Name
1. PK attachment_reference_key decimal(15)      
2.   attachment_key decimal(15)   attachment fk_attachment_reference1
3.   shared_document_key decimal(15)   shared_document fk_attachment_reference3
4.   attached_timestamp date(10)      
5.   attached_by decimal(15)   person fk_attachment_reference2
6.   description varchar(128)      
Foreign Keys
Column References Foreign Key Name
Table Column
attachment_key attachment attachment_key fk_attachment_reference1
attached_by person person_key fk_attachment_reference2
shared_document_key shared_document attachment_key fk_attachment_reference3
Referenced from
Table Column Foreign Key Name
po_attachment_reference attachment_reference_key fk_po_attachment_reference2
po_expense_line_attachment_ref po_attachment_reference_key fk_po_expense_line_att_ref1
po_item_line_attachment_ref po_attachment_reference_key fk_po_item_line_att_ref1
po_labor_line_attachment_ref po_attachment_reference_key fk_po_labor_line_att_ref1
po_summary_attachment_ref po_attachment_reference_key fk_po_summary_attachment_ref1
pr_attachment_reference attachment_reference_key fk_pr_attachment_reference2
pr_expense_line_attachment_ref pr_attachment_reference_key fk_pr_expense_line_att_ref1
pr_item_line_attachment_ref pr_attachment_reference_key fk_pr_item_line_att_ref1
pr_labor_line_attachment_ref pr_attachment_reference_key fk_pr_labor_line_att_ref1
pr_summary_attachment_ref pr_attachment_reference_key fk_pr_summary_attachment_ref1
Check Constraints
Name Definition
cc_attachment_reference ([shared_document_key] IS NULL AND [attachment_key] IS NOT NULL OR [shared_document_key] IS NOT NULL AND [attachment_key] IS NULL)
Indices
Index Name Unique Column Name Asc Or Desc
pk_attachment_reference true attachment_reference_key Asc
idx_attachment_reference_1 false attachment_key Asc
idx_attachment_reference_2 false attached_by Asc
idx_attachment_reference_3 false shared_document_key Asc