MYSQL

image.png

User

column id user_id username password name email created_at updated_at
조건 PK unique unique unique
자료형 BIGINT VARCHAR(36) VARCHAR(50) VARCHAR(255) VARCHAR(50) VARCHAR(100) DATETIME DATETIME
기타 UUID

Product

column id name artist_name year condition price stock
조건 PK
자료형 BIGINT VARCHAR(255) VARCHAR(255) INT VARCHAR(50) BIGINT INT
기타
column seller_id sale_start_at is_limited thumbnail_path created_at updated_at
조건
자료형 VARCHR(36) DATETIME BOOL VARCHAR(255) DATETIME DATETIME
기타 UUID + filename

Order

column id order_id status user_id product_id quantity total_price created_at
조건 PK unique enum
자료형 BIGINT VARCHAR(36) VARCHAR(50) VARCHAR(36) BIGINT INT BIGINT DATETIME
기타 UUID

Redis

Session token

session_token+{uid}

JWT_refresh_token TTL

Limited Product token

stock:product:{id}

Product.stock

price:product:{id}

Product.price

openAt:product:{id}

Product.sale_start_at