Table: imported_lodging_detail

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK imported_expense_data_key decimal(15)   imported_expense_data fk_imported_lodging_detail1
2.   hotel varchar(100)      
3.   location varchar(100)      
4.   check_in_date datetime      
5.   nights_charged int      
6.   daily_room_rate decimal(15,3)      
7.   daily_room_tax decimal(15,3)      
8.   misc_charge decimal(15,3)      
9.   misc_desc varchar(100)      
Foreign Keys
Column References Foreign Key Name
Table Column
imported_expense_data_key imported_expense_data imported_expense_data_key fk_imported_lodging_detail1
Check Constraints
Name Definition
cc_ild_check_in_date ([check_in_date]>='1900-01-01' AND [check_in_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_imported_lodging_detail true imported_expense_data_key Asc