APTI
Tables (6)
quesiton_order (질문 순서)
- survey_id (검사 id) — int — Foreign key → survey.id — NOT NULL
- question_id (질문 id) — int — Foreign key → questions.id — NOT NULL
- order (순서) — int
questions (질문)
- id — int — Primary key — NOT NULL
- content (질문 내용) — varchar
response (답변)
- user_id (답변자 id) — int — Foreign key → users.id — NOT NULL
- question_id (질문 id) — int — Foreign key → questions.id — NOT NULL
- survey_response_id (int) — int — Foreign key → survey_response.id — NOT NULL
- id (id2) — int — Foreign key → survey_response.id — NOT NULL
- id (id3) — int — Foreign key → survey_response.id — NOT NULL
- Field2
survey (검사)
- id — int — Primary key — NOT NULL
- name (설문이름) — varchar
- description (설문 상세) — varchar
survey_response (설문_응답)
- id (설문_응답_id) — int — Primary key — NOT NULL
- id (id2) — int — Foreign key → survey.id — NOT NULL
- id (id3) — int — Foreign key → users.id — NOT NULL
users (검사자)
- id — int — Primary key — NOT NULL
- name (이름) — varchar
- birthdate (생년월일) — varchar
- gender (성별) — varchar