GoodsPlatform

Tables (9)

cart_items (카트_아이템)

  • cartItemId (Key) — UUID — Primary key — NOT NULL
  • quantity (Field3) — Long
  • created_at (NOT NULL) — LocalDateTime
  • updated_at (Field2) — LocalDateTime
  • UserId (Key2) — UUID — Foreign key → users.UserId — NOT NULL
  • productId (Key3) — UUID — Foreign key → products.productId — NOT NULL

categories (카테고리)

  • categoryId (Key) — UUID — Primary key — NOT NULL
  • name (Field) — Varchar(100)

coupon (쿠폰)

  • couponId (Key) — UUID — Primary key — NOT NULL
  • couponCode (Field7) — Varchar(100)
  • created_at (NOT NULL) — LocalDateTime
  • updated_at (Field2) — LocalDateTime
  • expired_at (Field3) — LocalDateTime
  • discount_type (Field8) — Varchar(100)
  • discount_value (Field4) — Long
  • is_used (Field6) — Varchar(100)
  • UserId (Key2) — UUID — Foreign key → users.UserId — NOT NULL

jwts (토큰)

  • jwtId (key) — UUID — Primary key — NOT NULL
  • refresh_tokens (Field3) — VARCHAR(512)
  • created_at (Field4) — LocalDateTime
  • expired_at (Field5) — LocalDateTime
  • is_active (Field6) — Boolean
  • UserId (Key2) — UUID — Foreign key → users.UserId — NOT NULL

order_items (주문_아이템)

  • orderItemId (Key) — UUID — Primary key — NOT NULL
  • quantity (Field) — Long
  • price (Field2) — Long
  • productName (Field3) — Varchar(100)
  • totalPrice (Field4) — Long
  • OrderId (Key2) — UUID — Foreign key → orders.OrderId — NOT NULL
  • productId (Key3) — UUID — Foreign key → products.productId — NOT NULL

orders (주문)

  • OrderId (Key) — UUID — Primary key — NOT NULL
  • created_at (NOT NULL) — Varchar(100)
  • updated_at (Field2) — LocalDateTime
  • deleted_at (Field3) — LocalDateTime
  • address (Field6) — String
  • state (Field4) — Varchar(100)
  • totalPrice (Field5) — Long
  • UserId (Key3) — UUID — Foreign key → users.UserId — NOT NULL
  • couponId (Key2) — UUID — Foreign key → coupon.couponId — NOT NULL

payments (결제)

  • paymentId (Key) — UUID — Primary key — NOT NULL
  • created_at (Field1) — LocalDateTime
  • state (Field2) — Varchar(100)
  • amount (Field3) — Long
  • OrderId (Key2) — UUID — Foreign key → orders.OrderId — NOT NULL

products (제품)

  • productId (Key) — UUID — Primary key — NOT NULL
  • name (Field) — Varchar(100)
  • created_at (Field2) — LocalDateTime
  • updated_at (Field3) — LocalDateTime
  • deleted_at (Field8) — LocalDateTime
  • stockQuantity (Field4) — Long
  • state (Field5) — Varchar(100)
  • price (Field6) — Long
  • views (Field7) — Long
  • categoryId (Key2) — UUID — Foreign key → categories.categoryId — NOT NULL

users (유저)

  • UserId (key) — UUID — Primary key — NOT NULL
  • loginId (Field1) — Varchar(100)
  • username (Field) — Varchar(100)
  • email (Field2) — Varchar(100)
  • passwordHash (Field3) — Varchar(100)
  • role (Field4) — Varchar(64)
  • created_at (Field5) — LocalDateTime
  • address (Field6) — Varchar(512)
  • money (Field7) — Long