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