test
Tables (5)
post_mst (글)
- post_code (게시글코드) — INT — Primary key — NOT NULL
- post_name (게시글제목) — VARCHAR(50) — NOT NULL
- post (게시글내용) — VARCHAR(500) — NOT NULL
- create_date (작성일자) — DATETIME — NOT NULL
- update_date (수정일자) — DATETIME — NOT NULL
post_wirter_relation (글_작성자_연결)
- post_code (게시글코드) — INT — Foreign key → post_mst.post_code — NOT NULL
- writer_code (저자코드) — INT — Foreign key → wirter_mst.writer_code — NOT NULL
- create_date (작성일자) — DATETIME — NOT NULL
- update_date (수정일자) — DATETIME — NOT NULL
review_mst (댓글)
- review_code (댓글코드) — INT — Primary key — NOT NULL
- writer_code (저자코드) — INT — Foreign key → wirter_mst.writer_code — NOT NULL
- post_code (게시글코드) — INT — Foreign key → post_mst.post_code — NOT NULL
- review (내용) — VARCHAR(500)
- creat_date (작성일자) — DATETIME — NOT NULL
- update_date (수정일자) — DATETIME — NOT NULL
wirter_mst (작성자)
- writer_code (저자코드) — INT — Primary key — NOT NULL
- wirter_name (저자 이름) — VARCHAR(50) — NOT NULL
- wirter (저자 소개) — VARCHAR(500)
- create_date (작성일자) — DATETIME — NOT NULL
- update_date (수정일자) — DATETIME — NOT NULL