book

Tables (6)

URI_info (Untitled4)

  • book_Link (Field) — varchar2
  • book_Cover (Field2) — varchar2
  • bookid (Key) — NUMBER — Foreign key → book_info.bookid — NOT NULL

author_info (Untitled3)

  • authorID (Key) — NUMBER — Primary key — NOT NULL
  • authorName (Key2) — varchar2 — NOT NULL
  • FieldauthorCopy (Field) — varchar2

book_info

  • bookid (Key) — NUMBER — Primary key — NOT NULL
  • title (Field) — varchar2
  • description (Field3) — varchar2
  • priceSales (Field4) — Number
  • target_type (Field5) — varchar2
  • pubDate (Field2) — DATE
  • isbn13 (Field6) — varchar2
  • categoryId (Key22) — varchar2 — Foreign key → category_info.categoryId — NOT NULL
  • publisherID (Key2) — varchar2 — Foreign key → publisher_info.publisherID — NOT NULL

book_join_author (Untitled)

  • bookid (Key2) — NUMBER — Foreign key → book_info.bookid — NOT NULL
  • authorID (Key) — NUMBER — Foreign key → author_info.authorID — NOT NULL

category_info (Untitled2)

  • categoryId (Key2) — NUMBER — Primary key — NOT NULL
  • category_big (Field) — varchar2
  • category_middle (Field2) — varchar2
  • category_small (Field3) — varchar2
  • db_category_name (Field4) — varchar2

publisher_info (Untitled5)

  • publisherID (Key) — NUMBER — Primary key — NOT NULL
  • publisher (Field) — varchar2