| Field | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| expense_id | int(11) | No | ||||
| date_filed | date | No | 0000-00-00 | |||
| date_approved | date | No | 0000-00-00 | |||
| period_start | date | No | 0000-00-00 | |||
| period_end | date | No | 0000-00-00 | |||
| reason | varchar(255) | No | ||||
| type | enum('Meal', 'Mileage', 'Other') | No | Meal | |||
| amount | double | No | 0 | |||
| miles | int(11) | No | 0 | |||
| employee | int(11) | No | 0 | |||
| approved_by | int(11) | No | 0 |
| Field | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| user_id | int(11) | No | ||||
| username | varchar(50) | No | ||||
| password | varchar(50) | No | ||||
| first_name | varchar(100) | No | ||||
| last_name | varchar(100) | No | ||||
| type | enum('user', 'admin') | No | user |