books

Tables (6)

Author

  • Author_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(50) — NOT NULL
  • country (Field2) — varchar(50) — NOT NULL

Book

  • book_id (Key) — bigint — Primary key — NOT NULL
  • Author_id (Key2) — bigint — Foreign key → Author.Author_id — NOT NULL
  • title (Field) — varchar(50) — NOT NULL
  • isbn (Field3) — varchar(100) — NOT NULL
  • stock (Field4) — int — NOT NULL
  • publisher (Field2) — varchar(50) — NOT NULL
  • published_at (Field5) — DATE — NOT NULL

Genre

  • genre_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(30) — NOT NULL
  • description (Field2) — TEXT

Rental

  • Rental_id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.user_id — NOT NULL
  • book_id (Key3) — bigint — Foreign key → Book.book_id — NOT NULL
  • rental_date (Field) — DATE — NOT NULL
  • deadline (Field2) — DATE — NOT NULL
  • return_date (Field3) — DATE

User

  • user_id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(50) — NOT NULL
  • email (Field2) — varchar(100) — NOT NULL
  • password (Field3) — varchar(100) — NOT NULL
  • phone (Field4) — varchar(20)
  • created_at (Field5) — DATE — NOT NULL

book-genre

  • Bbook-genre_id (Key) — bigint — Primary key — NOT NULL
  • book_id (Key2) — bigint — Foreign key → Book.book_id — NOT NULL
  • genre_id (Key3) — bigint — Foreign key → Genre.genre_id — NOT NULL