test
Tables (7)
comment_mst (댓글)
- comment_Id (댓글 번호) — INT — Primary key — NOT NULL
- comment_description (내용) — VARCHAR(100)
- create_date (작성일) — DATETIME
- update_date (수정일) — DATETIME
- user_id (아이디) — INT — Foreign key → user_mst.user_id — NOT NULL
- post_id (게시글 번호) — INT — Foreign key → post_mst.post_id — NOT NULL
post_mst (게시글)
- post_id (게시글 번호) — INT — Primary key — NOT NULL
- post_name (제목) — VARCHAR(50)
- post_description (본문) — VARCHAR(100)
- create_date (작성일) — DATETIME
- update_date (수정일) — DATETIME
school_mst (학교)
- school_code (학교번호) — Primary key — NOT NULL
- 학교이름 (Field)
user_board_relation (저자_게시글_연결테이블)
- user_id (아이디) — INT — Foreign key → user_mst.user_id — NOT NULL
- post_id (게시글 번호) — INT — Foreign key → post_mst.post_id — NOT NULL
- create_date (작성일) — DATETIME
- update_date (수정일) — DATETIME
user_mst (유저)
- user_code (유저코드) — PK, AI — Primary key — NOT NULL
- school_code (학교번호) — Foreign key → school_mst.school_code — NOT NULL
- user_name (유저이름)
- user_on (유저상태) — 1 휴먼 2 휴먼x
user_mst (Untitled)
- user_id (아이디) — INT — Primary key — NOT NULL
- user_name (이름) — VARCHAR(50)
- user_description (사용자 소개) — VARCHAR(100)
- create_date (작성일) — DATETIME
- update_date (수정일) — DATETIME