Table: po_attachment_reference

Previous: planned_time

Unanet Data Model

Next: po_cust_approval_status

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	attachment_reference_key	decimal(15)		attachment_reference	fk_po_attachment_reference2
2.		orig_po_key	decimal(15)		purchase_order	fk_po_attachment_reference1
3.		email_with_po	char(1)	('N')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
attachment_reference_key	attachment_reference	attachment_reference_key	fk_po_attachment_reference2
orig_po_key	purchase_order	po_key	fk_po_attachment_reference1

Check Constraints

Name	Definition
cc_po_attachment_reference	([email_with_po]='N' OR [email_with_po]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_po_attachment_reference	true	attachment_reference_key	Asc
idx_po_attachment_reference	false	orig_po_key	Asc