스위프
테이블 (5)
SWYP_Chip
- chip_id — INT — 기본 키 — NOT NULL
- chip_name — ENUM('judgment', 'observation', 'listening', 'communication', 'friendliness', 'execution', 'perseverance') — NOT NULL
SWYP_Question
- question_id — INT — 기본 키 — NOT NULL
- question_type — ENUM('STRENGTH', 'WEAKNESS', 'BOTH') — NOT NULL
- question_target — ENUM('TEAM', 'FRIEND') — NOT NULL
- question_title — VARCHAR(255) — NOT NULL
- question_created_at — TIMESTAMP
- is_used — BOOLEAN
- user_id — INT — 외래 키 → SWYP_User.user_id — NOT NULL
SWYP_Response
- response_id — INT — 기본 키 — NOT NULL
- user_id — INT
- question_id — INT
- response_title — VARCHAR(255) — NOT NULL
- response_responder — VARCHAR(255) — NOT NULL
- question_id (question_id2) — INT — 외래 키 → SWYP_Question.question_id — NOT NULL
SWYP_Review
- review_id — INT — 기본 키 — NOT NULL
- review_type — ENUM('strength', 'weakness') — NOT NULL
- review_description — TEXT
- user_id — INT — 외래 키 → SWYP_User.user_id — NOT NULL
- response_id — INT — 외래 키 → SWYP_Response.response_id — NOT NULL
- question_id — INT — 외래 키 → SWYP_Question.question_id — NOT NULL
- chip_id — INT — 외래 키 → SWYP_Chip.chip_id — NOT NULL
SWYP_User
- user_id — INT — 기본 키 — NOT NULL
- user_email — VARCHAR(255) — NOT NULL
- user_nickname — VARCHAR(255) — NOT NULL
- user_login_type — ENUM('KAKAO', 'GOOGLE') — NOT NULL