UMC CH4 과제

테이블 (3)

location_mission (Untitled3)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • Key (Key3) — bigint — 외래 키 → member.Key — NOT NULL
  • Field

member (Untitled)

  • Key — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(10)
  • gender (Field2) — varchar(10)
  • birth (Field3) — date
  • address (Field4) — varchar(50)
  • favorite_food (Field5) — set
  • nickname (Field6) — varchar(20)
  • point (Field7) — int
  • status (Field8) — varchar(10)
  • inactive (Field9) — datetime(6)
  • created_at (Field10) — datetime(6)
  • updated_at (Field11) — datetime(6)

mission (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • location_mission_id (Key2) — 기본 키
  • location (Field)
  • Field2
  • Field3