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