Table: mileage_rate

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK mileage_rate_key decimal(15)      
2.   mileage_rate_set_key decimal(15)   mileage_rate_set fk_mileage_rate1
3.   begin_date datetime      
4.   rate decimal(15,4)      
Foreign Keys
Column References Foreign Key Name
Table Column
mileage_rate_set_key mileage_rate_set mileage_rate_set_key fk_mileage_rate1
Check Constraints
Name Definition
cc_mileage_rate_begin_date ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_mileage_rate true mileage_rate_key Asc