fsdf
Tables (5)
book
- book_id — INT — Primary key — NOT NULL
- book_title — VARCHAR(50) — NOT NULL
- book_author — VARCHAR(30) — NOT NULL
- book_stock — SAMLLINT — NOT NULL
- book_publisher — VARCHAR(20)
- book_price — INT — NOT NULL
customer
- customer_id — varchar(20) — Primary key — NOT NULL
- customer_password — varchar(20) — NOT NULL
- customer_last_name — varchar(2) — NOT NULL
- customer_first_name — varchar(3) — NOT NULL
- customer_road_name — varchar(20) — NOT NULL
- customer_detail_address — varchar(10)
- customer_postal_code — tinyint — NOT NULL
order
- order_number — INT — Primary key — NOT NULL
- customer_id — VARCHAR(20) — NOT NULL
- order_date — DATE — NOT NULL
- order_total — INT — NOT NULL
order_detail
- order_detail_id — INT — Primary key — NOT NULL
- order_number — INT — NOT NULL
- book_id — INT — NOT NULL
- order_date — SMALLINT — NOT NULL
refund
- refund_number — INT — Primary key — NOT NULL
- order_number — INT — NOT NULL
- refund_process — varchar(10) — NOT NULL
- refund_date — DATE — NOT NULL
- refund_reason — VARCHAR(50) — NOT NULL