agora

Tables (4)

CommentData (댓글관리)

  • UserID (닉네임) — varchar(40) — Primary key — NOT NULL
  • PostNumber (게시글넘버) — int(11)
  • Contents (댓글내용) — varchar(500)

PostData (게시글관리)

  • PostNumber (Key) — int(11) — Primary key — NOT NULL
  • Name (게시글제목) — varchar(50)
  • Contents (게시글내용) — varchar(20000)

UserData (유저관리)

  • UserID (닉네임) — varchar(40) — Primary key — NOT NULL
  • Password (비밀번호) — int(11)
  • Name (댓글내용) — varchar(500)
  • Gender (Field) — int(11)
  • BirthDate (생년월일) — date
  • JoinDate (가입일자) — date

VoteData (게시글 찬반관리)

  • UserID (닉네임) — varchar(40) — Primary key — NOT NULL
  • PostNumber (Key) — int(11) — Foreign key → PostData.PostNumber — NOT NULL
  • Contents (댓글내용) — varchar(500)