[케미진로] 질문지api

테이블 (4)

Questions (질문)

  • id (PK) — INTEGER — 기본 키 — NOT NULL
  • listQuestionsid (FK) — INTEGER — 외래 키 → QuestionsType.listQuestionsid — NOT NULL
  • title (Field) — STRING
  • images (Field2) — JSON
  • point (Field3) — INTEGER
  • type (Field4) — BOOLEAN
  • createdAt (Field5) — DATE
  • updatedAt (Field6) — DATE

QuestionsType (질문 타입)

  • id (PK) — INTEGER — 기본 키 — NOT NULL
  • listQuestionsid (FK) — INTEGER — 외래 키 → listQuestions.id — NOT NULL
  • title (Field) — STRING
  • option1 (Field2) — STRING
  • option2 (Field3) — STRING
  • createdAt (Field4) — DATE
  • updatedAt (Field5) — DATE

listQuestions (질문지)

  • id (PK) — INTEGER — 기본 키 — NOT NULL
  • title (Field) — STRING
  • image (Field2) — JSON
  • startDate (Field3) — DATE
  • endDate (Field4) — DATE
  • createdAt (Field5) — DATE
  • updatedAt (Field6) — DATE

school (학교정보)

  • id (Key) — 기본 키 — NOT NULL
  • link (Field)
  • adres (Field2)
  • schoolName (Field3)
  • region (Field4)
  • totalCount (Field5)
  • estType (Field6)
  • seq (Field7)