BookShop

Tables (7)

address (Untitled4)

  • Key — Primary key — NOT NULL

book (Untitled)

  • book_code (Key) — VARCHAR(50) — Primary key — NOT NULL
  • book_title (Field) — VARCHAR(30)
  • book_author (Field2) — VARCHAR(20)
  • book_publisher (Field3) — VARCHAR(20)
  • book_price (Field4) — INT(10)
  • book_count (Field5) — INT(10)
  • Field6

delivery (CopyOfUntitled3)

  • delivery_code (Key) — VARCHAR(20) — Primary key — NOT NULL
  • order_id (Key2) — VARCHAR(20) — Foreign key → orders.order_id — NOT NULL
  • delivery_status (Field) — BOOLEAN(2)
  • Field2

genre (Untitled3)

  • genre_code (Key) — VARCHAR(20) — Primary key — NOT NULL
  • book_code (Key2) — VARCHAR(50) — Foreign key → book.book_code — NOT NULL

orderBooks (Untitled5)

  • order_book_id (Key) — VARCHAR(20) — Primary key — NOT NULL
  • order_id (Key2) — VARCHAR(20) — Foreign key → orders.order_id — NOT NULL
  • book_code (Key3) — VARCHAR(50) — Foreign key → book.book_code — NOT NULL
  • Field

orders (Untitled2)

  • order_id (Key) — VARCHAR(20) — Primary key — NOT NULL
  • user_email (Key2) — VARCHAR(20) — Foreign key → user.user_email — NOT NULL
  • Field

user (usertbl)

  • user_email (Key) — VARCHAR(20) — Primary key — NOT NULL
  • user_name (Field) — VARCHAR(10)
  • user_phone (Field5) — VARCHAR(20)
  • user_address (Field2) — ADDRESS