[케미진로] 질문지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)