앙북스

테이블 (12)

공지사항 (ang_notice)

  • notice_num (Key) — varchar2(20) — 기본 키 — NOT NULL
  • id (Key2) — varchar2(30) — 외래 키 → 멤버.id — NOT NULL
  • title (Field) — varchar2(60)
  • content (Field2) — varchar2(2000)
  • hit (Field3) — number(7)
  • regist_date (Field4) — date
  • type (Field5) — varchar2(20)

관리자정보 (admin_info)

  • shop_name (Field)

대여내역 (ang_rental_book)

  • rental_num (Key) — varchar2(20) — 기본 키 — NOT NULL
  • book_num (Key2) — varchar2(20) — 외래 키 → 도서정보.book_num — NOT NULL
  • id (Key3) — varchar2(30) — 외래 키 → 멤버.id — NOT NULL
  • rental_date (Field) — date
  • scheduled date (Field4) — date
  • return_date (Field2) — date
  • late_cost (Field3) — number(10)

댓글 (ang_reply)

  • reply_num (Key) — varchar2(20) — 기본 키 — NOT NULL
  • id (Key2) — varchar2(30) — 외래 키 → 멤버.id — NOT NULL
  • event_num (Key3) — varchar2(20) — 외래 키 → 이벤트.event_num — NOT NULL
  • content (Field) — varchar2(500)
  • indent (Field3) — number(1)
  • group (Field4) — varchar2(20)
  • regist_date (Field2) — date
  • modify_date (Field5) — date

도서신청 (ang_request)

  • request_num (Key) — varchar2(20) — 기본 키 — NOT NULL
  • id (Key2) — varchar2(30) — 외래 키 → 멤버.id — NOT NULL
  • title (Field) — varchar2(60)
  • content (Field2) — varchar2(2000)
  • detail (Field3) — varchar2(100)
  • request_date (Field4) — date

도서정보 (ang_book)

  • book_num (Key) — varchar2(20) — 기본 키 — NOT NULL
  • cate_num (Key3) — varchar2(20) — 외래 키 → 카테고리2.cate_num — NOT NULL
  • cate_num (Key22) — varchar2(20) — 외래 키 → 카테고리2.cate_num — NOT NULL
  • title (Field) — varchar2(50)
  • writer (Field4) — varchar2(30)
  • supplier (Field5) — varchar2(30)
  • publisher (Field6) — varchar2(30)
  • supplydate (Field8) — date
  • status (Field2) — varchar2(30)

멤버 (ang_member)

  • id (Key) — varchar2(30) — 기본 키 — NOT NULL
  • pw (Field) — varchar2(30)
  • name (Field2) — varchar2(30)
  • phone (Field3) — varchar2(20)
  • gender (Field4) — number(1)
  • birth (Field5) — date
  • email (Field6) — varchar2(50)
  • address1 (Field7) — varchar2(5)
  • address2 (Field8) — varchar2(50)
  • address3 (Field9) — varchar2(50)
  • join_date (Field10) — date
  • remove_date (Field11) — date
  • interest (Field18) — varchar(10)
  • ang_level (Field12) — number(1)

이벤트 (ang_event)

  • event_num (Key) — varchar2(20) — 기본 키 — NOT NULL
  • title (Field) — varchar2(60)
  • content (Field2) — varchar2(2000)
  • thumnail (Field3) — varchar2(100)
  • detail (Field4) — varchar2(100)
  • start_date (Field5) — date
  • end_date (Field6) — date
  • regist_date (Field7) — date

책리뷰 (ang_book_review)

  • review_num (Key) — varchar2(20) — 기본 키 — NOT NULL
  • book_num (Key3) — varchar2(20) — 외래 키 → 도서정보.book_num — NOT NULL
  • id (Key2) — varchar2(30) — 외래 키 → 멤버.id — NOT NULL
  • title (Field) — varchar2(60)
  • content (Field2) — varchar2(2000)
  • photo (Field3) — varchar2(100)
  • ang_score (Field4) — number(2,1)
  • regist_date (Field5) — date
  • modify_date (Field6) — date

책하단정보 (ang_book_info)

  • book_num (Key) — varchar2(20) — 외래 키 → 도서정보.book_num — NOT NULL
  • content_comment (Field) — varchar2(4000)
  • writer_comment (Field2) — varchar2(4000)
  • index_comment (Field3) — varchar2(4000)
  • supplier_comment (Field4) — varchar2(4000)

카테고리1 (ang_cate1)

  • cate_num (Key) — varchar2(20) — 기본 키 — NOT NULL
  • cate_name (Field) — varchar2(30)

카테고리2 (ang_cate2)

  • cate_num (Key) — varchar2(20) — 기본 키 — NOT NULL
  • cate_num (Key2) — varchar2(20) — 외래 키 → 카테고리1.cate_num — NOT NULL
  • cate_name (Field) — varchar2(30)