test

Tables (5)

item_mst (상품)

    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