yoursky_erd_v2
Tables (5)
Questionnaire (Question)
- Key (quest_id) — INT — Primary key — NOT NULL
- Key (survey_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (category) — VARCHAR(50)
- Field (quest_name) — VARCHAR(1000)
- Field (quest_mark) — BOOLEAN
- Field (regist_dt) — DATETIME
Untitled (Survey)
- Key (survey_id) — INT — Primary key — NOT NULL
- Field (survey_desc) — VARCHAR(1000)
- Field (survey_sort) — VARCHAR(10)
- Field (survey_name) — VARCHAR(200)
- Field (survey_week) — INT
- Field (regist_dt) — DATETIME
Untitled (QuestionAnswer)
- Key (anwser_id) — INT — Primary key — NOT NULL
- Key (quest_id) — INT — Foreign key → Questionnaire.Key — NOT NULL
- Key (survey_id) — INT — Foreign key → Questionnaire.Key — NOT NULL
- Field (key) — VARCHAR(100)
- Field (value) — INT
User
- Key (user_id) — INT — Primary key — NOT NULL
- Field (user_email) — VARCHAR(200)
- (user_type) — VARCHAR(100)
- Field (user_name) — VARCHAR(100)
- Field2 (user_birth_yyyy) — INT
- Field3 (user_birth_mm) — INT
- Field (user_birth_dd) — INT
- Field (user_gender) — VARCHAR(10)
- Field (regist_dt) — DATETIME
UserAnswer (UserScore)
- Key (score_id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → User.Key — NOT NULL
- Key (anwser_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (quest_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (survey_id) — INT — Foreign key → Untitled.Key — NOT NULL
- Field2 (regist_dt) — DATETIME