on-line book store

Tables (10)

Book (Untitled2)

  • book-id (Key) — NOT NULL — Primary key — NOT NULL
  • book-title (Field) — NOT NULL
  • book-author (Field2) — NOT NULL
  • book-publisher (Field3) — NOT NULL
  • book-stock (Field4) — NOT NULL
  • book-short_description (Field5) — NULL

Customer (Untitled)

  • customer-id (Key) — NOT NULL — Primary key — NOT NULL
  • customer-password (Field2) — NOT NULL
  • custoner-name (Field) — NOT NULL
  • customer-age (Field3) — NOT NULL
  • customer-gender (Field4) — NOT NULL
  • customer-phoneNum (Field5) — NOT NULL
  • customer-address (Field6) — NOT NULL

Emlpoyee (Untitled3)

  • employ-id (Key) — NOT NULL — Primary key — NOT NULL
  • employ-name (Field) — NOT NULL
  • employ-title (Field2) — NOT NULL
  • employ-salary (Field3) — NOT NULL
  • employ-enterDate (Field4) — NOT NULL
  • employ-department (Field5) — NOT NULL

Order (Untitled5)

  • customer-id (Key) — NOT NULL — Foreign key → Customer.customer-id — NOT NULL
  • order-id (SK1) — NOT NULL — Foreign key → OrderList.order-id — NOT NULL

OrderList (Untitled4)

  • order-id (SK1) — NOT NULL — Primary key — NOT NULL
  • order-date (Field) — NOT NULL
  • order-quantity (Field2) — NOT NULL
  • order-process (Field3) — NOT NULL

Refund (Untitled8)

  • customer-id (Key) — NOT NULL — Foreign key → Customer.customer-id — NOT NULL
  • refundlist-id (Key2) — NOT NULL — Foreign key → RefundList.refundlist-id — NOT NULL

RefundList (Untitled7)

  • refundlist-id (Key) — NOT NULL — Primary key — NOT NULL
  • order-id (SK1) — NOT NULL — Foreign key → OrderList.order-id — NOT NULL
  • refundlist-total (Field) — NOT NULL

orderlist-book (Untitled9)

  • book-id (Key) — NOT NULL — Foreign key → Book.book-id — NOT NULL
  • order-id (SK1) — NOT NULL — Foreign key → OrderList.order-id — NOT NULL

orderlist-employee (Untitled6)

  • employ-id (Key) — NOT NULL — Foreign key → Emlpoyee.employ-id — NOT NULL
  • order-id (SK1) — NOT NULL — Foreign key → OrderList.order-id — NOT NULL

refundlist-employee (Untitled10)

  • employ-id (Key2) — NOT NULL — Foreign key → Emlpoyee.employ-id — NOT NULL
  • refundlist-id (Key3) — NOT NULL — Foreign key → RefundList.refundlist-id — NOT NULL