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