JavajoProject
Tables (3)
board (게시판)
- boardnum (게시글번호) — int(11) — Primary key — NOT NULL
- id (아이디) — varchar(45) — Foreign key → userinfo.id — NOT NULL
- title (제목) — text
- contents (글내용) — text
- date (글작성시간) — datetime
- count (조회수) — int(11)
- status (글상태(삭제여부)) — int(11)
comment (댓글창)
- commentseq (댓글순서대로번호) — int(11) — Primary key — NOT NULL
- id (아이디) — varchar(45) — Foreign key → board.id — NOT NULL
- boardnum (게시글번호) — varchar(45) — Foreign key → board.boardnum — NOT NULL
- text (댓글내용) — text
- commenttime (댓글작성시간) — datetime
- replynum (원래댓글번호) — int(11)
- groupnum (댓글그룹번호) — int(11)
- ordernum (댓글순서) — int(11)
- status (댓글삭제여부) — int(11)
userinfo (고객정보)
- id (아이디) — varchar(45) — Primary key — NOT NULL
- pw (비밀번호) — varchar(45)
- name (이름) — varchar(45)
- tel (휴대전화) — varchar(45)
- email (이메일) — varchar(45)
- status (가입상태) — int(11)