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