도서 대여 관리
테이블 (5)
Mission (user)
- mission_id (Key) — 기본 키 — NOT NULL
- store_id (Key2) — NOT NULL
- title (Key3) — NOT NULL
- content (Key4) — NOT NULL
- point (Key5) — NOT NULL
- mission_type (Key6) — NOT NULL
- is_active (Key7) — NOT NULL
Region (user)
- region_id (Key) — 기본 키 — NOT NULL
- name (Key2) — NOT NULL
- description (Key3) — NOT NULL
Store (user)
- stroe_id (Key) — 기본 키 — NOT NULL
- region_id (Key2) — NOT NULL
- name (Key3) — NOT NULL
- address (Key4) — NOT NULL
- description (Key5) — NOT NULL
User (user)
- user_id — 기본 키 — NOT NULL
- email — NOT NULL
- status (Key6) — NOT NULL
- created_at (Key5) — NOT NULL
- nickname (Key4) — NOT NULL
- password — NOT NULL
UserMission (user)
- user_mission_id (Key) — 기본 키 — NOT NULL
- mission_id (Key3) — NOT NULL
- status (Key4) — NOT NULL
- completed_at (Key5) — NOT NULL
- Field