q
Tables (6)
Contents
- content_id — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- description — text
- category — varchar(50)
- mbti_strength — varchar(50)
ContestEntry
- contestEntry_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- entry_date — timestamp
- entry_rank — int
Diagnosis
- diagnosis_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- mbti_id — bigint — Foreign key → MBTI.mbti_id — NOT NULL
- diagnosis_date — date — NOT NULL
- result — text
Feedback
- feedback_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → User.user_id — NOT NULL
- content_id — bigint — Foreign key → Contents.content_id — NOT NULL
- feedback_type — varchar(50)
- feedback_date — date — NOT NULL
MBTI
- mbti_id — bigint — Primary key — NOT NULL
- type — varchar(10) — NOT NULL
- description — varchar(255)
User
- user_id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- email — varchar(100) — NOT NULL
- mbti_id — bigint — Foreign key → MBTI.mbti_id