test
Tables (7)
author_board_relation (저자_게시글_연결테이블)
- author_code (저자코드) — INT — Foreign key → author_mst.author_code — NOT NULL
- board_code (글 번호) — INT — Foreign key → board_mst.board_code — NOT NULL
- create_date (작성일) — DATETIME — NOT NULL
- update_date (수정일) — DATETIME — NOT NULL
author_mst (저자)
- author_code (저자코드) — INT — Primary key — NOT NULL
- author_name (저자 이름) — VARCHAR(50) — NOT NULL
- author_description (저자 소개) — VARCHAR(100)
- create_date (작성일) — DATETIME — NOT NULL
- update_date (수정일) — DATETIME — NOT NULL
board_mst (게시글)
- board_code (글 번호) — INT — Primary key — NOT NULL
- board_title (글 제목) — VARCHAR(50) — NOT NULL
- board_desciption (글 내용) — VARCHAR(500) — NOT NULL
- create_date (작성일) — DATETIME — NOT NULL
- update_date (수정일) — DATETIME — NOT NULL
comment_mst (댓글)
- comment_code (댓글 번호) — INT — Primary key — NOT NULL
- comment_description (댓글 내용) — VARCHAR(500) — NOT NULL
- create_date (작성일) — DATETIME
- update_time (수정일) — DATETIME
- board_code (글 번호2) — INT — Foreign key → board_mst.board_code — NOT NULL
- author_code (저자코드) — INT — Foreign key → author_mst.author_code — NOT NULL
major_mst (전공)
- major_code (전공코드) — INT — Primary key — NOT NULL
- major_name (전공이름) — VARCHAR(50)) — Primary key — NOT NULL
- Field
school_mst (학교)
- school_code (학교번호) — Primary key — NOT NULL
- user_code (유저코드) — PK, AI — Foreign key → user_mst.user_code — NOT NULL
- user_on (유저상태) — 1. 휴먼임, 2.휴면아님 — Foreign key → user_mst.user_on — NOT NULL
- 학교이름 (Field)
user_mst (유저)
- user_code (유저코드) — INT — Primary key — NOT NULL
- user_on (유저상태) — INT — Primary key — NOT NULL
- user_name (유저이름) — VARCHAR(50)