SHOP

Tables (3)

BOOK

  • BOOK_NO — INT — Primary key — NOT NULL
  • BOOK_NAME — VARCHAR(100) — NOT NULL
  • BOOK_PUB — VARCHAR(20)
  • BOOK_PRICE — INT — NOT NULL

CONSUMER

  • CONSUMER_NO — INT — Primary key — NOT NULL
  • CONSUMER_NAME — VARCHAR(20) — NOT NULL
  • CONSUMER_EDDRESS — VARCHAR(100) — NOT NULL
  • CONSUMER_PHONE — VARCHAR(20) — NOT NULL

ORDERS

  • Key — INT — Primary key — NOT NULL
  • BOOK_NO — INT — Foreign key → BOOK.BOOK_NO — NOT NULL
  • CONSUMER_NO — INT — Foreign key → CONSUMER.CONSUMER_NO — NOT NULL
  • ORDER_DAY — DATE — NOT NULL
  • ORDER_PRICE — INT — NOT NULL