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)