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