Table: mie_per_diem_detail

Previous: mie_allowable_detail

Unanet Data Model

Next: mileage_detail

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	expense_data_key	decimal(15)		expense_data	fk_mie_per_diem_detail1
2.		country_state_name	varchar(45)
3.		city_county_name	varchar(45)
4.		rate	decimal(15,3)
5.		first_day	char(1)	('N')
6.		last_day	char(1)	('N')
7.		breakfast_provided	char(1)	('N')
8.		lunch_provided	char(1)	('N')
9.		dinner_provided	char(1)	('N')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
expense_data_key	expense_data	expense_data_key	fk_mie_per_diem_detail1

Check Constraints

Name	Definition
cc_breakfast_provided	([breakfast_provided]='N' OR [breakfast_provided]='Y')
cc_dinner_provided	([dinner_provided]='N' OR [dinner_provided]='Y')
cc_first_day	([first_day]='N' OR [first_day]='Y')
cc_last_day	([last_day]='N' OR [last_day]='Y')
cc_lunch_provided	([lunch_provided]='N' OR [lunch_provided]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_mie_per_diem_detail	true	expense_data_key	Asc