book-ranker
Tables (4)
book
- id — INT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- publisher — VARCHAR(255) — NOT NULL
- price — INT — NOT NULL
book_rank
- id — INT — Primary key — NOT NULL
- book_rank — INT — NOT NULL
- date_added — DATE — NOT NULL
- book_id — INT — Foreign key → book.id — NOT NULL
contribute
- id — INT — Primary key — NOT NULL
- book_role — VARCHAR(255) — NOT NULL
- person_id — INT — Foreign key → person.id — NOT NULL
- book_id — INT — Foreign key → book.id — NOT NULL
person
- id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL