week1
Tables (6)
Mission (미션)
- mission_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- title (Field) — VARCHAR(50)
- is_completed (Field2) — int
- user_id (Key2) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
- onboarding_id (Key22) — Foreign key → user.onboarding_id — NOT NULL
- Field3
onboarding (온보딩)
- onboarding_id (Key) — Primary key — NOT NULL
- Field
point (포인트)
- user_id (Key) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
- onboarding_id (Key2) — Foreign key → user.onboarding_id — NOT NULL
review (리뷰)
- Key — VARCHAR(10) — Primary key — NOT NULL
- mission_id (Key2) — VARCHAR(10) — Foreign key → Mission.mission_id — NOT NULL
- Field
- Field2
store (가게)
- store_id (Key) — Primary key — NOT NULL
- user_id (Key2) — VARCHAR(10) — Foreign key → user.user_id — NOT NULL
- onboarding_id (Key22) — Foreign key → user.onboarding_id — NOT NULL
user (사용자)
- user_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- onboarding_id (Key2) — Foreign key → onboarding.onboarding_id — NOT NULL
- username (Field) — VARCHAR(20)
- password (Field2) — VARCHAR(20)
- Field3 — VARCHAR(50)