Itda

Tables (7)

Post (게시글)

  • p_id (아이디) — BIGINT — Primary key — NOT NULL
  • title (제목) — VARCHAR(255)
  • deseription (설명) — LONGTEXT
  • apply_period (모집마감일자) — VARCHAR(255)

Post_Major (게시글 전공)

  • p_id (아이디) — BIGINT — Foreign key → Post.p_id — NOT NULL
  • major (전공) — VARCHAR(255)

Post_Members (게시글 맴버)

  • p_id (게시글아이디) — BIGINT — Foreign key → Post.p_id — NOT NULL
  • u_id (유저 아이디) — BIGINT — Foreign key → User.u_id — NOT NULL

Post_Question_Answer (질문 응답)

  • qustion_number (질문 번호) — Integer — Foreign key → Post_Qustion.qustion_number
  • p_id (게시글 아이디) — BIGINT — Foreign key → Post_Qustion.p_id — NOT NULL
  • u_id (유저 아이디) — BIGINT — Foreign key → User.u_id — NOT NULL
  • objective_answer (답변 내용) — VARCHAR(255)

Post_Question_Select (질문 보기)

  • qustion_number (질문 번호) — Integer — Foreign key → Post_Qustion.qustion_number
  • p_id (게시글 아이디) — BIGINT — Foreign key → Post_Qustion.p_id — NOT NULL
  • answer_number (객관식 번호) — Integer
  • content (객관식 내용) — VARCHAR(255)

Post_Qustion (폼 질문)

  • qustion_number (질문 번호) — Integer — Primary key
  • p_id (게시글 아이디) — BIGINT — Foreign key → Post.p_id — NOT NULL
  • qustion_content (질문 내용) — VARCHAR(255)
  • answer_type (답변형식) — VARCHAR(255)
  • multiple (복수응답여부) — BOOLEAN
  • required (필수응답여부) — BOOLEAN

User (사용자)

  • u_id (아이디) — BIGINT — Primary key — NOT NULL
  • password (비밀번호) — VARCHAR(255)
  • email (이메일) — VARCHAR(255)
  • major (전공) — VARCHAR(255)
  • school (학교) — VARCHAR(255)
  • grade (학년) — VARCHAR(255)
  • user_id (유저아이디) — VARCHAR(255