itda
Tables (4)
Answer (응답)
- answer_id (Key) — bigint — Primary key — NOT NULL
- question_id (Key2) — bigint — Foreign key → Question.question_id — NOT NULL
- option_id (Key3) — bigint — Foreign key → QuestionOption.option_id — NOT NULL
- user_id (Field) — varchar(255)
- text_answer (Field2) — varchar(255)
Post (게시물)
- post_id (Key) — bigint — Primary key — NOT NULL
- title (Field) — VARCHAR(255)
- description (Field2) — VARCHAR(255)
Question (질문 (신청 폼 내 질문))
- question_id (Key) — bigint — Primary key — NOT NULL
- post_id (Key2) — bigint — Foreign key → Post.post_id — NOT NULL
- question_number (Field) — Int
- question_content (Field2) — VARCHAR(255)
- answer_type (Field3) — VARCHAR(20) — ENUM 1. OBJECTIVE (객관식) 2. SUBJECTIVE (주관식)
- multiple (Field4) — boolean
QuestionOption (질문 보기)
- option_id (Key) — bigint — Primary key — NOT NULL
- question_id (Key2) — bigint — Foreign key → Question.question_id — NOT NULL
- answer_number (Field) — Int
- answer_content (Field2) — VARCHAR(255)