6
Tables (10)
Author
- name — VARCHAR(100) — Primary key
- address — VARCHAR(200)
- url — VARCHAR(200)
Book
- isbn — VARCHAR(20) — Primary key
- title — VARCHAR(100)
- year — INTEGER
- price — FLOAT
- name — VARCHAR(100) — Foreign key → Author.name
- name (name2) — VARCHAR(100) — Foreign key → Publisher.name
Customer
- email — VARCHAR(100) — Primary key
- name — VARCHAR(100)
- address — VARCHAR(200)
- phone — VARCHAR(20)
Format (has_format)
- format_id — INTEGER — Primary key
- video_id (video_id2) — INTEGER — Foreign key → Video.video_id
- type — VARCHAR(20)
- price — FLOAT
Publisher
- name — VARCHAR(100) — Primary key
- address — VARCHAR(200)
- phone — VARCHAR(20)
- url — VARCHAR(200)
Shopping_Basket
- basket_id — INTEGER — Primary key
- email — VARCHAR(100) — Foreign key → Customer.email
- isbn — VARCHAR(20) — Foreign key → Book.isbn
- video_id — INTEGER — Foreign key → Video.video_id
Video
- video_id — INTEGER — Primary key
- title — VARCHAR(100)
- year — INTEGER
Warehouse
- code — INTEGER — Primary key
- address — VARCHAR(200)
- phone — VARCHAR(20)
- isbn — VARCHAR(20) — Foreign key → Book.isbn
contains_book
- basket_id — INTEGER
- book_id — INTEGER
- number — INTEGER
contains_video
- basket_id — INTEGER
- format_id — INTEGER
- number — INTEGER