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