Pub
Tables (9)
Member (멤버)
- id (아이디) — varchar2(100) — Primary key — NOT NULL
- pw (비밀번호) — varchar2(100)
- name (이름) — varchar2(100)
- email (이메일) — varchar2(50)
- email_domain (이메일도메인) — varchar2(50)
- gender (성별) — varchar2(10)
- birth (생일) — varchar2(100)
- mem_phone1 (폰번호1) — varchar2(10)
- mem_phone2 (폰번호2) — varchar2(15)
- mem_phone3 (폰번호3) — varchar2(15)
- zipNo (우편번호) — varchar(50)
- roadAddrpart1 (주소1) — varchar2(500)
- roadAddrpart2 (주소2) — varchar2(500)
- addrDetail (상세주소) — varchar2(500)
- regdated (가입날짜) — date
- deldatede (탈퇴날짜) — date
- delcont (탈퇴사유) — varchar2(3000)
- state (회원상태) — number(10)
- overdue (연체기간) — dare
book_loan_info (대출정보)
- loan_date (대출날짜) — DATE
- return_date (반납날짜) — DATE
- state (상태) — NUMBER(2)
- id (아이디) — varchar2(100) — Foreign key → Member.id — NOT NULL
- e_no (전자책번호) — NUMBER(38) — Foreign key → ebook.e_no — NOT NULL
- return_date_ok (반납확인날짜) — DATE
ebook (전자책)
- e_no (전자책번호) — NUMBER(38) — Primary key — NOT NULL
- title (제목) — VARCHAR2(500)
- author (저자) — VARCHAR2(500)
- publisher (출판사) — VARCHAR2(500)
- publication_year (출판연도) — VARCHAR2(30)
- book_introduce (책소개) — VARCHAR2(3000)
- category (분류) — VARCHAR2(50)
- status (대출상태) — NUMBER(38)
- recommend (추천수) — NUMBER(38)
- isbn — VARCHAR2(100)
- imgurl (외부이미지주소) — VARCHAR2(3000)
email_code
- email (이메일) — VARCHAR2(100)
- code (인증코드) — VARCHAR2(50)
faqCategory (FAQ카테고리)
- categoryId (아이디) — NUMBER(38) — Primary key — NOT NULL
- categoryName (이름) — VARCHAR2(2000)
faqContent (FAQ)
- faqNo (번호) — NUMBER(38) — Primary key — NOT NULL
- Question (질문?) — VARCHAR2(4000)
- Answer (답변?) — VARCHAR2(4000)
- chkCId (Field4) — NUMBER(38)
- categoryId (아이디) — NUMBER(38) — Foreign key → faqCategory.categoryId — NOT NULL
gongji (공지)
- gongji_no (공지번호) — Primary key — NOT NULL
- gongji_name (작성자) — VARCHAR2(30)
- gongji_title (공지제목) — VARCHAR2(200)
- gongji_pwd (공지비번) — VARCHAR2(20)
- gongji_cont (공지내용) — VARCHAR2(3000)
- gongji_hit (조회수) — NUMBER(38)
- gongji_date (등록날짜) — DATE
recommend (추천)
- id (아이디) — varchar2(100) — Foreign key → Member.id — NOT NULL
- e_no (전자책번호) — NUMBER(38) — Foreign key → ebook.e_no — NOT NULL
reply (댓글)
- reply_no (댓글번호) — NUMBER(38) — Primary key — NOT NULL
- reply_cont (댓글내용) — VARCHAR2(3000)
- regdate (등록시간) — DATE
- editdate (수정시간) — DATE
- id (아이디) — varchar2(100) — Foreign key → Member.id — NOT NULL
- e_no (전자책번호) — NUMBER(38) — Foreign key → ebook.e_no — NOT NULL