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