LODGING_DETAIL |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| expense_data_key | decimal (15,0) | EXPENSE_DATA | fk_lodging_detail1 | |
| hotel | varchar (100) | YES | ||
| location | varchar (100) | YES | ||
| check_in_date | datetime | YES | ||
| nights_charged | int | YES | ||
| room_rate | decimal (15,3) | YES | ||
| tax | decimal (15,3) | YES | ||
| misc_charge | decimal (15,3) | YES | ||
| misc_desc | varchar (100) | YES | ||
Indexes on LODGING_DETAIL |
|
| Index Name | Column(s) |
|---|---|
| pk_lodging_detail | expense_data_key |