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