종합커뮤니티사이트

테이블 (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