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