Table: imported_air_detail

Previous: image_setup Unanet Data Model Next: imported_credit_card_expense
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_air_detail1
2.   to_location varchar(100)      
3.   departure_date datetime      
4.   from_location varchar(100)      
5.   return_date datetime      
6.   ticket_number varchar(50)      
Foreign Keys
Column References Foreign Key Name
Table Column
imported_expense_data_key imported_expense_data imported_expense_data_key fk_imported_air_detail1
Check Constraints
Name Definition
cc_iad_departure_date ([departure_date]>='1900-01-01' AND [departure_date]<='2099-12-31')
cc_iad_return_date ([return_date]>='1900-01-01' AND [return_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_imported_air_detail true imported_expense_data_key Asc