pousto
테이블 (8)
Brand (brands)
- brand_id (id) — 기본 키 — NOT NULL
- name
- created_at
- updated_at
Category (categories)
- category_id (categoryId) — 기본 키 — NOT NULL
- name
- created_at (createdAt) — timestamp
- updated_at (updatedAt) — timestamp
OrderDetail (order_details)
- id — 기본 키 — NOT NULL
- order_id (orderId) — 외래 키 → 주문.order_id — NOT NULL
- product_id (productId) — 외래 키 → Product.product_id — NOT NULL
- quantity
Product (products)
- product_id (id) — 기본 키 — NOT NULL
- brand_id (brandId) — 외래 키 → Brand.brand_id — NOT NULL
- category_id (categoryId) — 외래 키 → Category.category_id — NOT NULL
- price
- color
- title
- thumb_nail_image (thumbnailImage)
- created_at (createdAt)
- updated_at (updatedAt)
ProductImage (product_images)
- Key — 기본 키 — NOT NULL
- product_id (productId) — 외래 키 → Product.product_id — NOT NULL
- image_url (imageUrl)
ProductOption (product_options)
- product_option_id (id) — 기본 키 — NOT NULL
- product_id (productId) — 외래 키 → Product.product_id — NOT NULL
- size
- additional_price (additionalPrice)
유저 (User)
- user_Id (id) — 기본 키 — NOT NULL
- email
- name
- refresh_token (refreshToken)
- refresh_token_expires (refreshTokenExpires)
- address
- detail_Address (detailAddress)
- postal_code (postalCode)
- phone
주문 (Order)
- order_id (id) — 기본 키 — NOT NULL
- user_Id (userId) — 외래 키 → 유저.user_Id — NOT NULL
- address
- detail_address (detailAddress)
- postal_code (postalCode)
- phone
- total_price (totalPrice)