toy_ERDs -(branch) develop_OHJISU

Tables (3)

QUEST_ANSWER

  • CHILD_ID — VARCHAR(50) — Primary key — NOT NULL
  • NUMBER — DECIMAL(20,0)
  • CONTENTS — VARCHAR(255)
  • SCORE — DECIMAL(20,0)
  • PARENT_ID — VARCHAR(50) — Foreign key → QUEST_ANSWER.CHILD_ID — NOT NULL

USER_ANSWER

  • CHILD_ID — VARCHAR(50) — Foreign key → QUEST_ANSWER.CHILD_ID — NOT NULL
  • USER_INFO_ID — VARCHAR(50) — Foreign key → USER_INFO.USER_INFO_ID — NOT NULL

USER_INFO

  • USER_INFO_ID — VARCHAR(50) — Primary key — NOT NULL
  • NAME — VARCHAR(255)