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