purchaseERD

Tables (3)

items (Untitled)

  • id — bigInteger — Primary key — NOT NULL
  • name — varchar(120)
  • price — Integer
  • stock — Integer
  • info — varchar(300)
  • status — enum
  • category — varchar(150)

orders (Untitled2)

  • id — biginteger — Primary key — NOT NULL
  • order_number — varchar(250)
  • total_price — biginteger
  • status — enum
  • created_at — timestamp
  • user_id — biginteger
  • Field

users (CopyOfUntitled)

  • id — bigInteger — Primary key — NOT NULL
  • name — varchar(120)
  • phone_number — varchar(120)
  • email — varchar(200)
  • password — varchar(300)
  • point_balance — BigInteger
  • grade — enum