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