실습
테이블 (5)
Login
- user_id — varchar(50) — 기본 키 — NOT NULL
- Field (user_name) — varchar(50)
- Field2 (email) — varchar(100)
- Field (password) — varchar(255)
- Field (login_date) — timestamp
Untitled (Join)
- user_id — varchar(50) — 외래 키 → Login.user_id — NOT NULL
- Field (name) — varchar(50) — NOT NULL
- Field (gender) — bigint — NOT NULL
- Field (user_name) — varchar(50) — NOT NULL
- Field (password) — varchar(50) — NOT NULL
- Field (address_post) — varchar(50) — NOT NULL
- Field (address_room_number) — varchar(50) — NOT NULL
- Field
Untitled (food_preference)
- Key (user_id) — varchar(50) — 기본 키 — NOT NULL
- user_id (prefer_food) — varchar(50) — 외래 키 → Untitled.user_id — NOT NULL
missions
- mission_id (mission_name) — varchar(100) — 기본 키 — NOT NULL
- mission_id — bigint — 외래 키 → user_home_missions.mission_id — NOT NULL
- description — TEXT
- Field (status) — int — 1이면 성공, 0이면 실패
user_home_missions
- mission_id — bigint — 기본 키 — NOT NULL
- user_id — varchar(50) — 외래 키 → Login.user_id — NOT NULL
- status — VARCHAR(20)
- Field (success_num) — bigint
- Field (point) — bigint