노드 과제 피드백 적용

테이블 (10)

food_preference

  • id — BIGINT
  • food_name — VARCHAR(50) — NOT NULL

location_history

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

member

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • social_type — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • gender — VARCHAR(10)
  • birthdate — DATE
  • address — VARCHAR(255)
  • mission_completion_rate — INT
  • status — VARCHAR(15) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

member_agreement

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • terms_id — BIGINT — NOT NULL
  • is_agreed — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

member_mission

  • id — BIGINT
  • mission_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • completed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

member_preference

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • food_id — BIGINT — NOT NULL

mission

  • id — BIGINT
  • restaurant_id — BIGINT — NOT NULL
  • point — INT — NOT NULL
  • price_threshold — INT — NOT NULL
  • auth_code — VARCHAR(10) — NOT NULL
  • status — VARCHAR(15) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

notification

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • content — TEXT
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

point_history

  • id — BIGINT
  • member_id — BIGINT — NOT NULL
  • amount — INT — NOT NULL
  • reason — VARCHAR(255)
  • created_at — DATETIME(6) — NOT NULL

restaurant

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • type — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • status — VARCHAR(15) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL