deliverydelegate
Tables (7)
delegator
- delegator_id (Key) — auto_increment — Primary key — NOT NULL
- game_id (Key2) — auto_increment — Foreign key → game.game_id — NOT NULL
- user_id (Key3) — auto_increment — Foreign key → user.user_id — NOT NULL
- ranking (Field) — int
- status (Field2) — varchar(20)
game
- game_id (Key) — auto_increment — Primary key — NOT NULL
- game_name (Field2) — varchar(20)
- population (Field3) — int
- landmark_xpos (Field4) — varchar(20)
- landmark_ypos (Field5) — varchar(20)
- game_main_text (Field) — text
- socket_room_name (Field6) — varchar
order
- order_id (Key2) — auto_increment — Primary key — NOT NULL
- delegator_id (Key) — auto_increment — Foreign key → delegator.delegator_id — NOT NULL
- store_name (Field) — varchar(100)
- mapx (Field2) — varchar(20)
- mapy (Field3) — varchar(20)
- detail (Field4) — varchar(100)
review
- review_id (Key) — auto_increment — Primary key — NOT NULL
- user_id (Key2) — auto_increment — Foreign key → user.user_id — NOT NULL
- store_id (Key3) — auto_increment — Foreign key → store.store_id — NOT NULL
- content — text
- image_path (Field) — varchar
- thumb_up (Field2) — number
store
- store_id (Key) — auto_increment — Primary key — NOT NULL
- store_xpos (Field) — varchar(20)
- store_ypos (Field2) — varchar(20)
- store_name (Field3) — varchar(20)
- store_address (Field4) — varchar(20)
thumb
- thumb_id (Key) — auto_increment — Primary key — NOT NULL
- review_id (Key2) — auto_increment — Foreign key → review.review_id — NOT NULL
- user_id — auto_increment — Foreign key → user.user_id — NOT NULL
- thumb_up (Field) — boolean
- thumb_count (Field2) — number
user
- user_id — auto_increment — Primary key — NOT NULL
- phone_number (Field) — varchar(20)
- password (Field6) — varchar(40)
- self_xpos (Field3) — varchar(20)
- slef_ypos (Field4) — varchar(10)
- nickname (Field2) — varchar
- coupon_count (Field5) — number
- penalty (Field7) — boolean
- penalty_date (Field8) — datetime