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)