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