UMC 0week

테이블 (9)

가게 (store)

  • store_id (Key) — INT — 기본 키 — NOT NULL
  • location_id (Key2) — INT — 외래 키 → 지역.location_id — NOT NULL
  • name (Field) — VARCHAR(10)
  • manager_number (Field2) — INT
  • address (Field3) — VARCHAR(100)
  • created_at (Field4) — Date
  • updated_at (Field5) — Date

리뷰 (Review)

  • review_id (Key2) — INT — 기본 키 — NOT NULL
  • member_id (PK) — INT — 외래 키 → 유저.member_id — NOT NULL
  • store_id (Key) — INT — 외래 키 → 가게.store_id — NOT NULL
  • location_id (Key22) — INT — 외래 키 → 가게.location_id — NOT NULL
  • star (Field) — FLOAT
  • review_content (Field2) — VARCHAR(100)
  • review_photo (Field5) — VARCHAR(100)
  • created_at (Field3) — Date
  • updated_at (Field4) — Date

리뷰 답글 (Review_reply)

  • reply_id (Key) — INT — 기본 키 — NOT NULL
  • review_id (Key2) — INT — 외래 키 → 리뷰.review_id — NOT NULL
  • location_id (Key22) — INT — 외래 키 → 리뷰.location_id — NOT NULL
  • reply_content (Field) — VARCHAR(100)
  • created_at (Field2) — Date
  • updated_at (Field3) — Date

미션 (Mission)

  • mission_id (Key) — INT — 기본 키 — NOT NULL
  • store_id (Key2) — INT — 외래 키 → 가게.store_id — NOT NULL
  • deadline (Field) — Date
  • title (Field2) — VARCHAR(10)
  • reward_point (Field3) — INT
  • reward_description (Field4) — VARCHAR(100)
  • created_at (Field5) — Date
  • updated_at (Field6) — Date

유저 (user)

  • member_id (PK) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(50)
  • gender (Field2) — ENUM('M','F','N')
  • birth_date (Field3) — Date
  • address (Field4) — VARCHAR(100)
  • email (Field5) — VARCHAR(100)
  • point (Field6) — INT
  • created_at (Field7) — Date
  • updated_at (Field8) — Date

유저 미션 (user_mission)

  • member_id (PK) — INT — 외래 키 → 유저.member_id — NOT NULL
  • mission_id (Key) — INT — 외래 키 → 미션.mission_id — NOT NULL
  • is_complete (Field) — bit
  • created_at (Field3) — Date
  • updated_at (Field4) — Date

유저 선호 음식 (user_food)

  • user_food_id (Key) — INT — 기본 키 — NOT NULL
  • member_id (FK1) — INT — 외래 키 → 유저.member_id — NOT NULL
  • category_id (FK2) — INT — 외래 키 → 음식.category_id — NOT NULL
  • created_at (Field) — Date
  • updated_at (Field2) — Date

음식 (food)

  • category_id (PK) — INT — 기본 키 — NOT NULL
  • category_name (Field) — VARCHAR(50)
  • created_at (Field2) — Date
  • updated_at (Field3) — Date

지역 (location)

  • location_id (Key) — INT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR(10)