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