mbti명함

테이블 (3)

Profile

  • profile_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME

User

  • user_id — INT — 기본 키 — NOT NULL
  • id — VARCHAR(50)
  • my_mbti — CHAR(4)
  • nickname — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_date — DATETIME — NOT NULL
  • modified_date — DATETIME

Vote

  • vote_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → User.user_id — NOT NULL
  • voter_id — INT — 외래 키 → User.user_id — NOT NULL
  • vote_mbti — CHAR(4) — NOT NULL
  • comment — VARCHAR(100)
  • created_date — DATETIME — NOT NULL