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