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