### Bill (2953 rows)
| Column | Type | Null? | Key |
|:--|:--|:--|:--|
| id | CHAR(5) | NOT NULL | PK |
| arrived | DATETIME | NOT NULL |  |
| finished | DATETIME | NULL |  |
| departed | DATETIME | NULL |  |
| status | VARCHAR(8) | NOT NULL |  |
| rack | VARCHAR(3) | NOT NULL |  |
| unit | INT | NOT NULL |  |
| payment | DECIMAL(10,2) | NOT NULL |  |
| Customer_id | CHAR(5) | NOT NULL | FK to Customer.id |
| Employee_id | CHAR(5) | NOT NULL | FK to Employee.id |
| Service_id | VARCHAR(5) | NOT NULL | FK to Service.id |
| Outlet_id | CHAR(3) | NULL | FK to Outlet.id |

### Outlet (3 rows)
| Column | Type | Null? | Key |
|:--|:--|:--|:--|
| id | CHAR(3) | NOT NULL | PK |
| name | VARCHAR(50) | NOT NULL |  |
| address | VARCHAR(200) | NOT NULL |  |
| phone | VARCHAR(30) | NOT NULL |  |
| opened | DATE | NOT NULL |  |

### Service (12 rows)
| Column | Type | Null? | Key |
|:--|:--|:--|:--|
| id | VARCHAR(5) | NOT NULL | PK |
| description | VARCHAR(50) | NOT NULL |  |
| price | DECIMAL(7,2) | NOT NULL |  |

