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)