G-OSK

Tables (12)

admin_mst (Untitled4)

  • total_sales (Field) — INT

commuter_day_price_mst (Untitled10)

  • product_id (Key) — INT — Primary key — NOT NULL
  • time (Field) — DATETIME
  • price (Field2) — INT
  • Field3
  • Field4

commuter_time_price_mst (Untitled5)

  • product_id (Key) — INT — Primary key — NOT NULL
  • time (Field2) — DATETIME
  • price (Field3) — INT
  • Field
  • Field4

group room_mst (Untitled7)

  • room_id (Field2) — INT
  • user_id (Field) — INT
  • time (Field3) — DATETIME
  • price (Field4) — INT
  • Field5
  • Field6

locker_mst (Untitled6)

  • locker_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — VARCHAR — Foreign key → user_mst.user_id — NOT NULL
  • time (Field3) — DATETIME
  • Field
  • Field2
  • Field4

locker_price_mst (Untitled11)

  • locker_id (Key) — INT — Primary key — NOT NULL
  • locker_id (Key2) — INT — Foreign key → locker_mst.locker_id — NOT NULL
  • time (Field) — DATETIME
  • price (Field2) — INT
  • Field3
  • Field4

oneday_price_mst (Untitled3)

  • product_id (Key) — INT — Primary key — NOT NULL
  • time (Field3) — DATETIME
  • price (Field) — INT
  • Field2
  • Field4

reserved_price_mst (Untitled9)

  • product_id (Key) — INT — Primary key — NOT NULL
  • time (Field) — DATETIME
  • price (Field2) — INT
  • Field3
  • Field4

reserved_seat_mst (Untitled12)

  • seat_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — VARCHAR — Foreign key → user_mst.user_id — NOT NULL
  • product_id (Key3) — INT — Foreign key → reserved_price_mst.product_id — NOT NULL
  • Field
  • Field2
  • Field3

role_mst (Untitled2)

  • role_id (Key) — VARCHAR — Foreign key → user_mst.user_id — NOT NULL
  • role (Field2) — VARCHAR
  • Field
  • Field3

seat_mst (Untitled8)

  • seat_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — VARCHAR — Foreign key → user_mst.user_id — NOT NULL
  • product_id (Key3) — INT — Foreign key → commuter_day_price_mst.product_id — NOT NULL
  • product_id (Key4) — INT — Foreign key → commuter_time_price_mst.product_id — NOT NULL
  • product_id (Key5) — INT — Foreign key → oneday_price_mst.product_id — NOT NULL
  • Field
  • Field2
  • Field3

user_mst (Untitled)

  • user_id (Key) — VARCHAR — Primary key — NOT NULL
  • role_id (Field) — INT
  • user_name (Field2) — VARCHAR
  • create_date (Field4) — DATETIME
  • update_date (Field5) — DATETIME
  • Field3
  • Field6