erd

Tables (6)

Answer Set (응답 세트)

  • id (Key2) — int — Primary key — NOT NULL
  • question set id (Key) — int — Foreign key → Question Set.id — NOT NULL

Option Answer (질문에 대한 응답)

  • id (Key) — int — Primary key — NOT NULL
  • activeOption (Field)
  • answerSetId (Key2) — int — Foreign key → Answer Set.id — NOT NULL
  • questionId (Key22) — int — Foreign key → Questions.id — NOT NULL
  • optionId (Key3) — int — Foreign key → Options.id — NOT NULL

Options (객관식 응답)

  • id (Key) — int — Primary key — NOT NULL
  • question_id (Key2) — int — Foreign key → Questions.id — NOT NULL

Question Set (질문 세트)

  • id (Key) — int — Primary key — NOT NULL
  • type (Field)

Question Set Ownership (질문 세트 소유권)

  • id (Key) — int — Primary key — NOT NULL
  • companyId (Field) — int
  • hqId (Field2) — int
  • question Set Id (Key2) — int — Foreign key → Question Set.id — NOT NULL

Questions (질문)

  • id (Key2) — int — Primary key — NOT NULL
  • question set id (Key) — int — Foreign key → Question Set.id — NOT NULL