종합커뮤니티사이트
테이블 (4)
AnonymousPostPasswords
- PostID — INT
- Password — VARCHAR(255) — NOT NULL
Comments
- CommentID — INT
- PostID — INT
- UserID — INT
- Content — TEXT — NOT NULL
- CreatedDate — TIMESTAMP
- Password — VARCHAR(255)
Posts
- PostID — INT
- Title — VARCHAR(255) — NOT NULL
- Content — TEXT — NOT NULL
- Attachment — VARCHAR(255)
- CreatedDate — TIMESTAMP
- IsNotice — BOOLEAN
- IsSecret — BOOLEAN
- SecretPassword — VARCHAR(255)
Users
- UserID — INT
- Username — VARCHAR(50) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- UserType — ENUM('관리자', '회원', '익명') — NOT NULL