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