test

Tables (7)

Untitled2

    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