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