Project

Tables (3)

mvc_board

  • BID (아이디) — number(4,0) — Primary key — NOT NULL
  • BNAME (이름) — varchar2(20)
  • BTITLE (제목) — varchar2(100)
  • BCONTENT (내용) — varchar2(100)
  • BDATE (등록일) — date
  • BHIT (조회수) — number(4,0)
  • BGROUP (댓글그룹) — number(4,0)
  • BSTEP (댓글순서) — number(4,0)
  • BINDENT (댓글잇기) — number(4,0)

mvc_eventboard

  • ID (아이디) — number(4,0) — Primary key — NOT NULL
  • TITLE (제목) — varchar2(100)
  • CONTENT (내용) — varchar2(2000)
  • FILENAME1 (파일1) — varchar2(100)
  • FILENAME2 (파일2) — varchar2(100)
  • DATE1 (이벤트시작날짜) — varchar2(30)
  • DATE2 (이벤트종료날짜) — varchar2(30)

mvc_join

  • JID (아이디) — varchar2(30) — Primary key — NOT NULL
  • JNAME (이름) — varchar2(20)
  • JPW (패스워드) — varchar2(30)
  • JEMAIL (이메일) — varchar2(50)
  • JADDNUM (도로명or지번) — varchar2(20)
  • JADDRESS1 (주소1) — varchar2(100)
  • JADDRESS2 (주소2) — varchar2(100)
  • JTEL (전화번호) — varchar2(20)
  • JYEAR (년) — varchar2(10)
  • JMONTH (월) — varchar2(10)
  • JDATE (일) — varchar2(10)
  • JGENDER (성별) — varchar2(10)
  • JOIN_DATE (가입일) — varchar2(20)