test
Tables (4)
comment_mst (댓글)
- comment_code (댓글코드) — INT — Primary key — NOT NULL
- user_code (작성자) — INT — NOT NULL
- comment_dtl (댓글 내용) — VARCHAR(50)
- creation_day (작성일) — DATETIME
- modifition day (수정일) — DATETIME
- writer_code (저자코드) — INT — Foreign key → writer_mst.writer_code — NOT NULL
- text_code (게시글코드) — PK — Foreign key → text_mst.text_code — NOT NULL
text_mst (글)
- text_code (게시글코드) — INT — Primary key — NOT NULL
- textuser_code (작성자) — VARCHAR(50) — NOT NULL
- text_dtl (글 내용) — VARCHAR(50)
- creation_day (작성일) — DATETIME
- modifition day (수정일) — DATETIME
- writer_code (저자코드) — INT — Foreign key → writer_mst.writer_code — NOT NULL
writer_mst (저자)
- writer_code (저자코드) — INT — Primary key — NOT NULL
- writer_intro (저자 소개) — VARCHAR(50)
- creation_day (작성일) — DATETIME
- modifition day (수정일) — DATETIME — NOT NULL
- writer_code (저자 이름) — VARCHAR(50) — NOT NULL
writer_text_relation (저자_게시글_연결테이블)
- writer_code (저자코드) — INT — Foreign key → writer_mst.writer_code — NOT NULL
- text_code (게시글코드) — PK — Foreign key → text_mst.text_code — NOT NULL
- creation_code (작성일) — DATETIME
- modifition_day (Field) — DATETIME