Table: lodging_allowable_detail

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	expense_data_key	decimal(15)		expense_data	fk_lodging_allowable_detail1
2.		country_state_name	varchar(45)
3.		city_county_name	varchar(45)
4.		rate	decimal(15,3)	((0.000))
5.		prorated_rate	decimal(15,3)	((0.000))
6.		special_situation	char(1)	('N')
7.		check_in_date	datetime
8.		nights_charged	int
9.		daily_room_rate	decimal(15,3)	((0.000))
10.		daily_room_tax	decimal(15,3)	((0.000))
11.		overage	decimal(15,3)	((0.000))

Foreign Keys
Column	References		Foreign Key Name
Column	Table	Column	Foreign Key Name
expense_data_key	expense_data	expense_data_key	fk_lodging_allowable_detail1

Check Constraints
Name	Definition
cc_lad_check_in_date	([check_in_date]>='1900-01-01' AND [check_in_date]<='2099-12-31')
cc_lad_special_situation	([special_situation]='N' OR [special_situation]='Y')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_lodging_allowable_detail	true	expense_data_key	Asc