HyeroMap

Tables (5)

Menu (menus)

  • menu_id (id) — PK — Primary key — NOT NULL
  • menu_name (name) — NOT NULL

Store (stores)

  • store_id (id) — PK — Primary key — NOT NULL
  • store_name (name) — NOT NULL
  • store_phone (phone) — NOT NULL
  • store_code (storeCode) — NOT NULL
  • address — NOT NULL
  • location — NOT NULL
  • discount_age (discountAge) — NOT NULL
  • discount_percent (discountPercent) — NULL
  • discount_amount (discountAmount) — NULL
  • discount_service (discountService) — NULL
  • discount_detail (discountDetail) — NULL
  • weekday_start (weekdayStart) — NOT NULL
  • weekday_end (weekdayEnd) — NOT NULL
  • saturday_start (saturdayStart) — NOT NULL
  • saturday_end (saturdayEnd) — NOT NULL
  • holiday_start (holidayStart) — NOT NULL
  • holiday_end (holidayEnd) — NOT NULL

StoreMenu (store_menus)

  • store_menu_id (id) — PK — Primary key — NOT NULL
  • store_id (store) — NOT NULL — Foreign key → Store.store_id — NOT NULL
  • menu_id (menu) — NOT NULL — Foreign key → Menu.menu_id — NOT NULL

User (users)

  • user_id (id) — PK — Primary key — NOT NULL
  • user_name (name) — NOT NULL
  • user_phone (phone) — UNIQUE
  • user_pw (password) — NOT NULL
  • created_at (createdAt) — NOT NULL
  • updated_at (updatedAt) — NOT NULL

UserFavoriteStore (user_favorite_stores)

  • favorited_id (id) — PK — Primary key — NOT NULL
  • user_id (user) — NOT NULL — Foreign key → User.user_id — NOT NULL
  • store_id (store) — NOT NULL — Foreign key → Store.store_id — NOT NULL
  • registered_at (registeredAt) — NOT NULL