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