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