survey

Tables (6)

Answer (응답 상세)

  • answer_id — INT — Primary key — NOT NULL
  • question_id — INT — Foreign key → Question.question_id — NOT NULL
  • answer_text
  • choice_id — INT — Foreign key → Choice.choice_id — NOT NULL
  • response_id — INT — Foreign key → Response.response_id — NOT NULL

Choice (선택지)

  • choice_id — INT — Primary key — NOT NULL
  • choice_text — VARCHAR(100)
  • question_id — INT — Foreign key → Question.question_id — NOT NULL

Question (질문)

  • question_id — INT — Primary key — NOT NULL
  • survey_id — INT — Foreign key → Survey.survey_id — NOT NULL
  • question_text — VARCHAR(100)
  • question_type — VARCHAR(20)

Response (응답)

  • response_id — INT — Primary key — NOT NULL
  • response_date — TIMESTAMP
  • survey_id — INT — Foreign key → Survey.survey_id — NOT NULL
  • user_id — INT — Foreign key → Survey.user_id — NOT NULL

Survey (설문조사)

  • survey_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • title — VARCHAR(20)
  • description — VARCHAR(100)
  • created_date — TIMESTAMP
  • expiration_date — TIMESTAMP

User (사용자)

  • user_id — INT — Primary key — NOT NULL
  • name — VARCHAR(20)
  • email — VARCHAR(100)
  • roler (role) — VARCHAR(20)
  • registration_date — TIMESTAMP