Table: pr_labor_line_attachment_ref

Previous: pr_labor_line

Unanet Data Model

Next: pr_labor_line_descriptor

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	pr_attachment_reference_key	decimal(15)		pr_summary_attachment_ref	fk_pr_labor_line_att_ref1, fk_pr_labor_line_att_ref4
2.	PK	pr_labor_line_key	decimal(15)		pr_labor_line	fk_pr_labor_line_att_ref2
3.		pr_key	decimal(15)		purchase_requisition	fk_pr_labor_line_att_ref4, fk_pr_labor_line_att_ref3

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
pr_attachment_reference_key	attachment_reference	attachment_reference_key	fk_pr_labor_line_att_ref1
pr_labor_line_key	pr_labor_line	pr_labor_line_key	fk_pr_labor_line_att_ref2
pr_attachment_reference_key	pr_summary_attachment_ref	pr_attachment_reference_key	fk_pr_labor_line_att_ref4
pr_key		pr_key
pr_key	purchase_requisition	pr_key	fk_pr_labor_line_att_ref3

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_pr_labor_line_att_ref	true	pr_attachment_reference_key	Asc
		pr_labor_line_key
idx_pr_labor_line_att_ref1	false	pr_labor_line_key	Asc
idx_pr_labor_line_att_ref2	false	pr_key	Asc