OpenGallery

Tables (6)

Applicants (답변 목록)

  • id (Key) — Primary key — NOT NULL
  • survey_id (설문지id) — Foreign key → Survey.id — NOT NULL
  • user_id (유저id) — Foreign key → User.id — NOT NULL
  • created_at (Field4)
  • updated_at (Field5)

Question (설문 문항)

  • id (Key) — Primary key — NOT NULL
  • survey_id (Key2) — Foreign key → Survey.id — NOT NULL
  • question_text (질문)
  • title (질문명)
  • description (설명)
  • Field5
  • Field6

Reply (선택)

  • id (Key) — Primary key — NOT NULL
  • survey_id (Key22) — Foreign key → Question.survey_id — NOT NULL
  • question_id (Key2) — Foreign key → Question.id — NOT NULL
  • number (선택지 번호)
  • value (선택지 값)

Results (결과)

  • id (Key) — Primary key — NOT NULL
  • survey_id (Key22) — Foreign key → Reply.survey_id — NOT NULL
  • question_id (Key23) — Foreign key → Reply.question_id — NOT NULL
  • user_id (Key3) — Foreign key → User.id — NOT NULL

Survey (설문지 테이블)

  • id (설문지id) — Primary key — NOT NULL
  • title (제목)
  • author (설문 생성자)
  • description (설명)
  • created_at (생성일)
  • updated_at (수정일)

User (유저)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • nickname (Field2)
  • pw (Field3)
  • created_at (Field4)
  • updated_at (Field5)