mate
Tables (4)
Copy Of RESERVATION (ROUTE)
- Key (id) — int — Primary key — NOT NULL
- Field (cost) — double — NOT NULL
- Field (departure) — varchar(255) — NOT NULL
- Field (arrival) — datetime — NOT NULL
- Field (hour) — int — NOT NULL
- Field (minute) — int — NOT NULL
- Field (method) — varchar(255) — NOT NULL
- Field (descriprion) — varchar(255)
RESERVATION
- Key (id) — int — Primary key — NOT NULL
- Key (method_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (email) — varchar(255) — NOT NULL
- Field (reserve_date) — datetime — NOT NULL
- Field (status) — int — NOT NULL
- Field (cancel_date) — datetime
Untitled (METHOD)
- Key (id) — inrt — Primary key — NOT NULL
- Field (departure) — varchar(255) — NOT NULL
- Field2 (arrival) — varchar(255) — NOT NULL
Untitled (METHOD_ROUTE)
- Key (id) — int — Primary key — NOT NULL
- Key (method_id) — inrt — Foreign key → Untitled.Key — NOT NULL
- Key (route_id) — int — Foreign key → Copy Of RESERVATION.Key — NOT NULL