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