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