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