ShoppingMall_erd
Tables (4)
Customer (Untitled2)
- custom_id (Key) — int — Primary key — NOT NULL
- TEL (Phone_num)
- email
- address
Delivery_info (Untitled4)
- Delivery_id (Key) — Primary key — NOT NULL
- custom_id (Key2) — int — Foreign key → Customer.custom_id — NOT NULL
- chase_no (Field)
- del_status (Field2)
- delivery_date_tobe (Field3)
Goods (Products)
- goods_id (product_id) — serial — Primary key — NOT NULL
- Delivery_id (Key) — Foreign key → Delivery_info.Delivery_id — NOT NULL
- custom_id (Key2) — int — Foreign key → Delivery_info.custom_id — NOT NULL
- title (name) — varchar(20)
- price — int — NOT NULL
- castegory (category) — varchar(20) — NOT NULL
- order_id — serial — NOT NULL
- User (user_id) — serial — NOT NULL
- inventory (amount) — int — NOT NULL
Order
- order_id — Primary key — NOT NULL
- goods_id (product_id) — serial — Foreign key → Goods.goods_id — NOT NULL
- custom_id (Key) — int — Foreign key → Customer.custom_id — NOT NULL
- Delivery_id (Key2) — Foreign key → Delivery_info.Delivery_id — NOT NULL
- custom_id (Key22) — int — Foreign key → Delivery_info.custom_id — NOT NULL
- Delivery_id (Key3) — Foreign key → Goods.Delivery_id — NOT NULL
- custom_id (Key23) — int — Foreign key → Goods.custom_id — NOT NULL
- order_date
- Order_quantity (order_amount) — int — NOT NULL
- Order_pricesum (total_price) — int — NOT NULL