myproject
Tables (3)
board (게시판)
- boardidx (글번호) — number — Primary key — NOT NULL
- title (제목) — varchar2(50)
- contents (내용) — varchar2(4000)
- useridx (회원번호) — number
- nicname (별명) — varchar2(15)
- boardpassword (글 비밀번호) — varchar2(100)
- boardregdate (작성일) — date
- readcnt (조회수) — number
reply (댓글)
- replyidx (댓글번호) — number — Primary key — NOT NULL
- boardidx (글번호) — number — Foreign key → board.boardidx — NOT NULL
- useridx (회원번호) — number
- nicname (별명) — varchar2(15)
- replypassword (댓글 비밀번호) — varchar2(100)
- replyregdate (댓글작성일) — date
user (회원)
- useridx (회원번호) — number — Primary key — NOT NULL
- username (아이디) — varchar2(16)
- password (비밀번호) — varchar2(100)
- name (이름) — varchar2(20)
- email (이메일) — varchar2(50)
- tel (전화번호) — varchar2(13)
- nicname (별명) — varchar2(15)
- auth (등급) — varchar2(20)
- regdate (가입일) — date