Table: air_detail

Previous: adp_setup Unanet Data Model Next: alternate
Columns
  Column Name Data Type Default
Value		 References
Table		 Foreign Key
Name
1. PK expense_data_key decimal(15)   expense_data fk_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
expense_data_key expense_data expense_data_key fk_air_detail1
Check Constraints
Name Definition
cc_air_detail_departure_date ([departure_date]>='1900-01-01' AND [departure_date]<='2099-12-31')
cc_air_detail_return_date ([return_date]>='1900-01-01' AND [return_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_air_detail true expense_data_key Asc