poll
Tables (6)
answer (개별답변)
- id (pk) — bigint — Primary key — NOT NULL
- response_id (pk3) — bigint — Foreign key → response.id — NOT NULL
- question_id (pk2) — bigint — Foreign key → question.id — NOT NULL
- questionType_id (fk2) — bigint — Foreign key → question.questionType_id — NOT NULL
- value (Field) — varchar
- value2 (Field2) — varchar
category (카테고리)
- id (pk) — bigint — Primary key — NOT NULL
- name (Field) — varchar
form (질문지)
- id (pk) — bigint — Primary key — NOT NULL
- category_id (fk) — bigint — Foreign key → category.id — NOT NULL
- name (Field) — varchar
- uploader (Field3) — varchar
- date (Field4) — date
- descript (Field2) — varchar
question (질문)
- id (pk) — bigint — Primary key — NOT NULL
- form_id (fk) — bigint — Foreign key → form.id — NOT NULL
- questionType_id (fk2) — bigint — Foreign key → questionType.id — NOT NULL
- text (Field) — varchar
questionType (질문타입)
- id (pk) — Primary key — NOT NULL
- name (Field)
response (답변지)
- id (pk) — bigint — Primary key — NOT NULL
- form_id (fk) — bigint — Foreign key → form.id — NOT NULL
- date (Field) — date