renew_ERD

Tables (21)

BADGE

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • image — VARCHAR(255)
  • required_points — INT — NOT NULL
  • type — VARCHAR(50)

CATEGORY

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)
  • icon — VARCHAR(255)
  • is_active — BOOLEAN — NOT NULL

INQUIRY

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • type — VARCHAR(50)

INQUIRY_RESPONSE

  • id — BIGINT
  • inquiry_id — BIGINT — Foreign key → INQUIRY.id — NOT NULL
  • admin_id — BIGINT — Foreign key → USER.id — NOT NULL
  • content — TEXT — NOT NULL
  • response_date — DATETIME — NOT NULL

LOG

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id
  • action_type — VARCHAR(100) — NOT NULL
  • timestamp — DATETIME — NOT NULL
  • ip_address — VARCHAR(45)
  • additional_data — TEXT

MENU

  • id — BIGINT
  • store_id — BIGINT — Foreign key → STORE.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10,2) — NOT NULL
  • is_available — BOOLEAN — NOT NULL
  • image_url — VARCHAR(255)

MISSION

  • id — BIGINT
  • store_id — BIGINT — Foreign key → STORE.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • reward_points — INT — NOT NULL
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • type — VARCHAR(50)
  • is_active — BOOLEAN — NOT NULL
  • difficulty_level — INT — NOT NULL

REGION

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • latitude — FLOAT
  • longitude — FLOAT

REVIEW

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • mission_id — BIGINT — Foreign key → MISSION.id
  • store_id — BIGINT — Foreign key → STORE.id — NOT NULL
  • rating — INT — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_verified — BOOLEAN — NOT NULL
  • helpful_count — INT — NOT NULL

REVIEW_IMAGE

  • id — BIGINT
  • review_id — BIGINT — Foreign key → REVIEW.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • display_order — INT — NOT NULL
  • uploaded_at — DATETIME — NOT NULL

REVIEW_REPLY

  • id — BIGINT
  • review_id — BIGINT — Foreign key → REVIEW.id — NOT NULL
  • owner_id — BIGINT — Foreign key → USER.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

STORE

  • id — BIGINT
  • region_id — BIGINT — Foreign key → REGION.id — NOT NULL
  • category_id — BIGINT — Foreign key → CATEGORY.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • address — VARCHAR(255) — NOT NULL
  • contact_number — VARCHAR(20)
  • latitude — FLOAT
  • longitude — FLOAT
  • business_hours — VARCHAR(255)
  • main_image — VARCHAR(255)
  • is_active — BOOLEAN — NOT NULL

STORE_IMAGE

  • id — BIGINT
  • store_id — BIGINT — Foreign key → STORE.id — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • caption — VARCHAR(255)
  • display_order — INT — NOT NULL
  • uploaded_at — DATETIME — NOT NULL

STORE_INFO

  • id — BIGINT
  • store_id — BIGINT — Foreign key → STORE.id — NOT NULL
  • detailed_description — TEXT
  • last_updated — DATETIME — NOT NULL

STORE_OWNER

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • store_id — BIGINT — Foreign key → STORE.id — NOT NULL
  • registered_date — DATETIME — NOT NULL
  • is_verified — BOOLEAN — NOT NULL
  • business_license_number — VARCHAR(50)

USER

  • id — BIGINT
  • username — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • last_login — DATETIME
  • is_active — BOOLEAN — NOT NULL
  • phone_number — VARCHAR(20)
  • social_login_type — VARCHAR(50)

USER_BADGE

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • badge_id — BIGINT — Foreign key → BADGE.id — NOT NULL
  • acquired_date — DATETIME — NOT NULL

USER_CATEGORY_PREFERENCE

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • category_id — BIGINT — Foreign key → CATEGORY.id — NOT NULL
  • created_at — DATETIME — NOT NULL

USER_MISSION

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • mission_id — BIGINT — Foreign key → MISSION.id — NOT NULL
  • assigned_date — DATETIME — NOT NULL
  • completed_date — DATETIME
  • status — VARCHAR(50) — NOT NULL
  • proof_image — VARCHAR(255)
  • admin_comment — TEXT

USER_POINT

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • amount — INT — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • mission_id — BIGINT — Foreign key → MISSION.id

USER_PROFILE

  • id — BIGINT
  • user_id — BIGINT — Foreign key → USER.id — NOT NULL
  • nickname — VARCHAR(100) — NOT NULL
  • profile_image — VARCHAR(255)
  • total_points — INT — NOT NULL
  • level — INT — NOT NULL
  • updated_at — DATETIME — NOT NULL