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