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)