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