스위프

테이블 (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