study_jsp4
Tables (3)
board (게시판)
- bno (게시판번호) — int — Primary key — NOT NULL
- title (제목) — varchar(100)
- writer (작성자) — varchar(100)
- regdate (작성일) — datetime
- content (내용) — text
- readcount (조회수) — int
- image (이미지경로) — text
comment (댓글)
- cno (댓글번호) — int — Primary key — NOT NULL
- bno (게시판번호) — int — Foreign key → board.bno — NOT NULL
- writer (작성자) — varchar(100)
- content (내용) — text
- regdate (작성일) — datetime
member (회원)
- id (아이디) — varchar(100 — Primary key — NOT NULL
- password (패스워드) — varchar(100)
- name (이름) — varchar(100)
- email (이메일) — varchar(100)
- phone (전화번호) — vharchar(11)
- regdate (가입일) — datetime
- lastlogin (마지막로그인) — datetime
- auth (관리자권한) — char(1)