하위

테이블 (11)

food_category

  • id — BIGINT
  • name — VARCHAR(15)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • Column4 — DATETIME(6)

member

  • id — BIGINT
  • name — VARCHAR(20)
  • gender — VARCHAR(10)
  • age — INT
  • address — VARCHAR(40)
  • status — VARCHAR(15)
  • space_address — VARCHAR(40)
  • inactive_date — DATETIME(6)
  • social_type — VARCHAR(10)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • email — VARCHAR(50)
  • point — INT

member_agree

  • id — BIGINT
  • member_id — BIGINT
  • terms_id — BIGINT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

member_mission

  • id — BIGINT
  • member_id — BIGINT
  • mission_id — BIGINT
  • status — VARCHAR(15)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

member_prefer

  • id — BIGINT
  • member_id — BIGINT
  • category_id — BIGINT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

mission

  • id — BIGINT
  • store_id — BIGINT
  • reward — INT
  • deadline — DATETIME(6)
  • mission_spec — TEXT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

region

  • id — BIGINT
  • name — VARCHAR(20)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

review

  • id — BIGINT
  • member_id — BIGINT
  • store_id — BIGINT
  • body — TEXT
  • score — FLOAT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

review_image

  • id — BIGINT
  • review_id — BIGINT
  • image_url — TEXT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

store

  • id — BIGINT
  • region_id — BIGINT
  • name — VARCHAR(50)
  • address — VARCHAR(50)
  • score — FLOAT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

terms

  • id — BIGINT
  • body — TEXT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • optional — BOOLEAN