nohsinsa_store

Tables (6)

Coupon (쿠폰)

  • id — Long — Primary key — NOT NULL
  • user_id — Long — Foreign key → User.id — NOT NULL
  • coupon_number — String
  • name — String
  • expiration_period — LocalDate
  • sale — Int
  • type — enum

Like Product (좋아요 상품)

  • id — Long — Primary key — NOT NULL
  • user_id — Long — Foreign key → User.id — NOT NULL
  • product_id — Long — Foreign key → Product.id — NOT NULL

Product (상품)

  • id — Long — Primary key — NOT NULL
  • product_number — String
  • product_name — String
  • brand_name — String
  • price — Int
  • like — Int
  • season — ENUM
  • gender — ENUM

Proudct Stock (상품 재고)

  • id — Long — Primary key — NOT NULL
  • product_id — Long — Foreign key → Product.id — NOT NULL
  • size — String
  • stock — Int

Shopping basket (장바구니)

  • id — Long — Primary key — NOT NULL
  • user_id — Long — Foreign key → User.id — NOT NULL
  • product_id — Long — Foreign key → Product.id — NOT NULL
  • quantity — Int

User (유저)

  • id — Long — Primary key — NOT NULL
  • login_id — String
  • password — String
  • email — String
  • name — String
  • grade — ENUM