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)