5959

Tables (8)

AUTHORS (CopyOfsearches2)

  • id — BIGINT — Primary key — NOT NULL — PK
  • author (user_id) — VARCHAR(50)
  • created_at (Field) — DATETIME
  • modified_at (Field2) — DATETIME

BOOKAUTHORS (CopyOfCopyOfreviews)

  • id — BIGINT — Primary key — NOT NULL — PK
  • book_id (id2) — BIGINT — Foreign key → BOOKS.id — NOT NULL — PK
  • author_id (id3) — BIGINT — Foreign key → AUTHORS.id — NOT NULL — PK
  • role (created_at) — VARCHAR(20) — NOT NULL

BOOKS (CopyOfusers)

  • id — BIGINT — Primary key — NOT NULL — PK
  • publisher (nickname) — VARCHAR(50) — UK
  • isbn (email) — VARCHAR(20) — UK
  • category (user_role) — VARCHAR(20) — UK
  • title (name) — VARCHAR(50)
  • publication_date (password) — DATETIME
  • created_at — DATETIME
  • modified_at — DATETIME

LIBRARIES (CopyOfsearches)

  • id — BIGINT — Primary key — NOT NULL — PK
  • user_id (id2) — BIGINT — Foreign key → USERS.id — NOT NULL — FK
  • created_at (Field) — DATETIME
  • modified_at (Field2) — DATETIME

LIBRARYBOOKS (CopyOfreviews)

  • id — BIGINT — Primary key — NOT NULL — PK
  • library_id (id3) — BIGINT — Foreign key → LIBRARIES.id — NOT NULL — FK
  • book_id (id2) — BIGINT — Foreign key → BOOKS.id — NOT NULL — FK
  • added_at (created_at) — DATETIME — NOT NULL

REVIEWS (reviews)

  • id — BIGINT — Primary key — NOT NULL — PK
  • user_id (id2) — BIGINT — Foreign key → USERS.id — NOT NULL — FK
  • book_id (id3) — BIGINT — Foreign key → BOOKS.id — NOT NULL — FK
  • content — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • modified_at — DATETIME — NOT NULL

SEARCHES (searches)

  • id — BIGINT — Primary key — NOT NULL — PK
  • user_id (id2) — BIGINT — Foreign key → USERS.id — NOT NULL — FK
  • created_at (Field) — DATETIME
  • modified_at (Field2) — DATETIME

USERS (users)

  • id — BIGINT — Primary key — NOT NULL — PK
  • nickname — VARCHAR(30) — UK
  • email — VARCHAR(50) — UK
  • user_role — VARCHAR(20) — UK
  • name — VARCHAR(30)
  • password — VARCHAR(255)
  • created_at — DATETIME
  • modified_at — DATETIME