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