Hanaro
Tables (9)
Cart (Card)
- id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → User.id — NOT NULL
- created_at — LocalDateTime
- updated_at — LocalDateTime
CartItem
- id — Long — Foreign key → Cart.id — NOT NULL
- product_id — Long — Foreign key → Item.id — NOT NULL
- quantity — Integer
FileUpload (Untitled7)
- id — Long — Primary key — NOT NULL
- product_id — Long — Foreign key → Item.id — NOT NULL
- file_name — String
- original_name — String
- file_path — String
- create_at — LocalDateTime
- uploaded_at — LocalDateTime
Item
- id — Long — Primary key — NOT NULL
- name — String
- description — String
- price — Integer
- stock — Integer
- created_at — LocalDateTime
- updated_at — LocalDateTime
Order
- id — Long — Primary key — NOT NULL
- user_id — Long — Foreign key → User.id — NOT NULL
- updated_at — LocaleDateTime
- created_at — LocaleDateTime
- total_price — Integer
- status — Enum
OrderItem
- id — Long — Primary key — NOT NULL
- order_id — Long — Foreign key → Order.id — NOT NULL
- product_id — Long — Foreign key → Item.id — NOT NULL
- quantity — Integer
- price — Integer
SalesStats
- id — Long — Primary key — NOT NULL
- statdt — LocalDateTime
- total_amt — Integer
- total_item_cnt — Integer
- total_unique_user — Integer
- create_at — LocalDateTime
- update_at — LocalDateTime
SalesStatsItem (Untitled)
- id — Long — Primary key — NOT NULL
- stat_id — Long — Foreign key → SalesStats.id — NOT NULL
- statdt — LocalDateTime
- cnt — Integer
- total_cnt — Integer
- user_cnt — Integer
User
- id — Long — Primary key — NOT NULL
- name — String
- email — String
- password — String
- role — Enum