erd 미션
테이블 (6)
member (Untitled)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field2) — varchar(20)
- phone_num (Field)
- nickname (Field3)
- status (Field6) — varchar
- inactive (Field7)
- create_at (Field4) — datetime(6)
- update_at (Field5) — datetime(6)
- password (Field8)
- email (Field9) — varchar(50)
member_mission (Untitled3)
- id (Key) — bigint — 기본 키 — NOT NULL
- datetime_at (Field2) — datetimr(6)
- update_at (Field3) — datetime(6)
- status (Field) — varchar(50)
- mission_id (Key2) — bigint — 외래 키 → mission.id — NOT NULL
- member_id (Key3) — bigint — 외래 키 → member.id — NOT NULL
member_preference (Untitled5)
- id (Key) — bigint — 기본 키 — NOT NULL
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
- member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
- preference_id (Key3) — bigint — 외래 키 → preference.id — NOT NULL
mission (Untitled8)
- id (Key) — bigint — 기본 키 — NOT NULL
- body (Field7) — varvhar(100)
- updated_at (Field4) — datetime(6)
- created_at (Field3) — datetime(6)
- region (Field) — varchar(100)
preference (Untitled7)
- id (Key) — bigint — 기본 키 — NOT NULL
- type (Field) — varchar(20) — NOT NULL
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
reveiw (Untitled2)
- id (Key) — bigint — 기본 키 — NOT NULL
- content (Field) — text
- mission_id (Key2) — bigint — 외래 키 → mission.id — NOT NULL
- updated_at (Field2) — datetime(6)
- created_at (Field3) — datetime(6)
- member_id (Key3) — bigint — 외래 키 → member.id — NOT NULL