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