koreait_test_erd
Tables (4)
auth_mst (회원)
- auth_code (회원코드) — PK, AI — Primary key — NOT NULL
- auth_name (회원이름) — NOT NULL
- auth_introduction (회원소개)
- create_date (생성일) — NOT NULL
- update_date (수정일) — NOT NULL
auth_writing (유저-글 연결)
- auth_code (회원코드) — PK, AI — Foreign key → auth_mst.auth_code — NOT NULL
- writing_code (글번호) — PK, AI — Foreign key → writing_mst.writing_code — NOT NULL
comment_mst (댓글)
- comment_code (댓글코드) — PK, AI — Primary key — NOT NULL
- comment_description (댓글내용) — NOT NULL
- create_date (생성일) — NOT NULL
- update_date (수정일) — NOT NULL
- writing_code (글번호) — PK, AI — NOT NULL
- writing_code (글번호2) — PK, AI — Foreign key → writing_mst.writing_code — NOT NULL
- auth_code (회원코드) — PK, AI — Foreign key → auth_mst.auth_code — NOT NULL
writing_mst (글)
- writing_code (글번호) — PK, AI — Primary key — NOT NULL
- writing_title (글제목) — NOT NULL
- writing_description (글내용)
- create_date (생성일) — NOT NULL
- update_date (수정일) — NOT NULL