Table: pr_labor_line

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	pr_labor_line_key	decimal(15)
2.		pr_labor_line_descriptor_key	decimal(15)		pr_labor_line_descriptor	fk_pr_labor_line1
3.		pr_key	decimal(15)		purchase_requisition	fk_pr_labor_line2
4.		begin_date	datetime	('01/01/1900')
5.		end_date	datetime	('12/31/2099')
6.		hours	decimal(15,2)
7.		amount	decimal(18,2)
8.		internal_comments	varchar(2000)
9.		external_comments	varchar(2000)

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
pr_labor_line_descriptor_key	pr_labor_line_descriptor	pr_labor_line_descriptor_key	fk_pr_labor_line1
pr_key	purchase_requisition	pr_key	fk_pr_labor_line2

Referenced from
Table	Column	Foreign Key Name
pr_labor_line_attachment_ref	pr_labor_line_key	fk_pr_labor_line_att_ref2

Check Constraints
Name	Definition
cc_prl_line_begin_date	([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31')
cc_prl_line_end_date	([end_date]>='1900-01-01' AND [end_date]<='2099-12-31')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_pr_labor_line	true	pr_labor_line_key	Asc
idx_pr_labor_line2	true	pr_key	Asc
		pr_labor_line_descriptor_key
idx_pr_labor_line1	false	pr_labor_line_descriptor_key	Asc

Dependent Views
View Name
pr_labor_consol_all_view
pr_labor_consol_approved_view