JavaMall
Tables (4)
customer
- user_id — VARCHAR(50) — Primary key — NOT NULL
- user_pwd — VARCHAR(255) — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- reg_date — VARCHAR(20)
goods
- goods_id — VARCHAR(50) — Primary key — NOT NULL
- goods_name — VARCHAR(100) — NOT NULL
- goods_price — INT — NOT NULL
- stock — INT — NOT NULL
- reg_date — VARCHAR(20)
order_line
- order_line_id — INT — Primary key — NOT NULL
- order_id — INT — Foreign key → orders.order_id — NOT NULL
- goods_id — VARCHAR(50) — Foreign key → goods.goods_id — NOT NULL
- unit_price — INT — NOT NULL
- qty — INT — NOT NULL
- amount — INT — NOT NULL
orders
- order_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(50) — Foreign key → customer.user_id — NOT NULL
- order_date — VARCHAR(20)
- address — VARCHAR(255)
- total_amount — INT — NOT NULL