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