Blog
Tables (3)
Users (2)
- id (계정생성ID) — int — Primary key — NOT NULL
- username (UserID) — varchar
- password (PW) — varchar
- role (사용자 권한) — varchar
blog (1)
- id (게시판 생성ID) — int — Primary key — NOT NULL
- id (계정생성ID) — int — Foreign key → Users.id — NOT NULL
- username (UserID) — varchar
- password (PW) — varchar
- title (제목) — varchar
- contents (내용) — varchar
- create_at (생성일시) — datetime
- modified_at (수정일시) — datetime
comment (.)
- id (댓글 생성ID) — int — Primary key — NOT NULL
- id (게시판 생성ID) — int — Foreign key → blog.id — NOT NULL
- username (UserID) — varchar
- contents (내용) — varchar
- create_at (생성일시) — datetime
- modified_at (수정일시) — datetime