B3

Tables (6)

bosses

  • boss_id — INT — Primary key — NOT NULL
  • user_name — VARCHAR(20)
  • nick_name — VARCHAR(30)
  • password — VARCHAR(60)
  • address — VARCHAR(50)
  • created_at — DATETIME
  • role — ENUM
  • state — INT
  • siDo — VARCHAR(200)
  • guGun — VARCHAR(200)
  • dongEupMyeon — VARCHAR(200)

chat_rooms

  • chat_room_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → bosses.boss_id — NOT NULL
  • user_id (user_id2) — INT — Foreign key → bosses.boss_id — NOT NULL
  • created_at — DATETIME

likes

  • like_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → bosses.boss_id — NOT NULL
  • restaurant_id — INT — Foreign key → restaurants.restaurant_id — NOT NULL
  • created_at — DATETIME

messages

  • Field — Primary key
  • chat_room_id — INT — Foreign key → chat_rooms.chat_room_id — NOT NULL
  • user_id (sender_id) — INT — Foreign key → bosses.boss_id — NOT NULL
  • content — TEXT
  • isRead — INT
  • created_at — DATETIME

photos

  • photo_id — INT — Primary key — NOT NULL
  • s3Key — VARCHAR(500)
  • s3Url — VARCHAR(500)
  • originalFileName — VARCHAR(500)
  • uploadDate — DATETIME

restaurants

  • restaurant_id — INT — Primary key — NOT NULL
  • boss_id — INT — Foreign key → bosses.boss_id — NOT NULL
  • photo_id — INT — Foreign key → photos.photo_id — NOT NULL
  • name — VARCHAR(30)
  • address — VARCHAR(50)
  • menu_name — VARCHAR(30)
  • price — INT
  • description — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME
  • state — INT
  • siDo — VARCHAR(200)
  • guGun — VARCHAR(200)
  • dongEupMyeon — VARCHAR(200)