Table: fp_revenue_schedule

Previous: fleet

Unanet Data Model

Next: funding_cap_adjustment

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	fp_revenue_schedule_key	decimal(15)
2.		fixed_price_key	decimal(15)		fixed_price	fk_fp_revenue_schedule1
3.		post_history_key	decimal(15)		post_history	fk_fp_revenue_schedule2
4.		rev_date	datetime
5.		amount	decimal(18,2)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
fixed_price_key	fixed_price	fixed_price_key	fk_fp_revenue_schedule1
post_history_key	post_history	post_history_key	fk_fp_revenue_schedule2

Check Constraints

Name	Definition
cc_fprs_rev_date	([rev_date]>='1900-01-01' AND [rev_date]<='2099-12-31')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_fp_revenue_schedule	true	fp_revenue_schedule_key	Asc
idx_fp_revenue_schedule1	false	fixed_price_key	Asc
idx_fp_revenue_schedule2	false	post_history_key	Asc