toy_ERDs_POTATO_JM
Tables (4)
Choices
- PK_CHOICES_ID — VARCHAR(255) — Primary key — NOT NULL
- PK_QUESTION_ID — VARCHAR(255) — Foreign key → Question_RECURSIVE.PK_QUESTION_ID — NOT NULL
- CHOICE_TEXT — VARCHAR(255)
- IS_CORRECT — BOOLEAN
Question_RECURSIVE
- PK_QUESTION_ID — VARCHAR(255) — Primary key — NOT NULL
- QUESTION — VARCHAR(255)
- SCORE — INT
- FK_QUESTION_ANSWER_ID — VARCHAR(255) — Foreign key → Question_RECURSIVE.PK_QUESTION_ID
Respondents
- RESPONDENT_ID — VARCHAR(255) — Primary key — NOT NULL
- RESPONDENT_NAME — VARCHAR(255)
Respondents_Question
- RESPONDENT_ID — VARCHAR(255) — Foreign key → Respondents.RESPONDENT_ID — NOT NULL
- PK_QUESTION_ID — VARCHAR(255) — Foreign key → Question_RECURSIVE.PK_QUESTION_ID — NOT NULL