Table: mileage_rate_set

Previous: mileage_rate

Unanet Data Model

Next: note_comment_attachment

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	mileage_rate_set_key	decimal(15)
2.		mileage_rate_set	varchar(25)
3.		description	varchar(128)
4.		unit	decimal(1)

Referenced from

Table	Column	Foreign Key Name
expense_type	mileage_rate_set_key	fk_expense_type2
mileage_rate	mileage_rate_set_key	fk_mileage_rate1

Check Constraints

Name	Definition
cc_mrs_unit	([unit]=(2) OR [unit]=(1))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_mileage_rate_set	true	mileage_rate_set_key	Asc