sad
Tables (7)
Author (Untitled2)
- id (Key2) — Integer — Primary key — NOT NULL
- name (Field) — Char
- imgUrl (Field2) — Char
- bornDate (Field3) — Char
- region (Field4) — Char
- description (Field5) — Text
- pk (Key) — Integer — Foreign key → Book.id — NOT NULL
- pk (Key32) — Integer — Foreign key → Book.pk — NOT NULL
- pk (Key33) — Integer — Foreign key → Book.pk — NOT NULL
Book (Untitled6)
- id (Key) — Integer — Primary key — NOT NULL
- pk (Key3) — Integer — Foreign key → MainCategory.id — NOT NULL
- pk (Key32) — Integer — Foreign key → DetailCategory.pk — NOT NULL
- pk (Key33) — Integer — Foreign key → SubCategory.pk — NOT NULL
- isbn (Field) — Integer
- title (Field2) — Char
- description (Field3) — Text
- priceStandard (Field4) — Char
- coverSmallUrl (Field5) — Char
- coverLargeUrl (Field6) — Char
- publisher (Field7) — Char
- translator (Field8) — Char
- author (Field9) — Char
- pubDate (Field10) — Char
- contents (Field11) — Text
- like_user (Field12) — Integer
- mainCategory (Field13) — Integer
- subCategory (Field14) — Integer
- detailCategory (Field15) — Integer
- publisherReview (Field16) — Text
- r_cnt (Field17) — Integer
- r_score (Field18) — Integer
- Field19
DetailCategory (Untitled5)
- pk (Key3) — Integer — Foreign key → SubCategory.pk — NOT NULL
- name (Field) — Char
- sub (Field2) — Integer
MainCategory (Untitled3)
- id (Key) — Integer — Primary key — NOT NULL
- name (Field) — Char
Review (Untitled7)
- id (Key3) — Primary key — NOT NULL
- pk (Key2) — Integer — Foreign key → Book.id — NOT NULL
- pk (Key) — Integer — Foreign key → User.id — NOT NULL
- content (Field) — Char
- score (Field2) — Integer
- book (Field3) — Integer
- spoiler (Field4) — Boolean
- like_user (Field5) — Integer
- user (Field6) — Integer
- created_at (Field7) — DateTime
- updated_at (Field8) — DateTime
SubCategory (Untitled4)
- pk (Key3) — Integer — Foreign key → MainCategory.id — NOT NULL
- name (Field) — Char
- main (Field2) — Integer
- book_category (Field3) — Text
User (Untitled)
- id (Key) — Integer — Primary key — NOT NULL
- username (Field) — Char
- email (Field2) — Text
- gender (Field3) — Char
- age (Field4) — Integer
- pk (Key3) — Integer — Foreign key → Book.pk — NOT NULL
- pk (Key32) — Integer — Foreign key → SubCategory.pk — NOT NULL
- pk (Key322) — Integer — Foreign key → Book.pk — NOT NULL
- pk (Key33) — Integer — Foreign key → Book.pk — NOT NULL