brs-erd-pod

Tables (9)

BaseProduct (베이스 제품)

  • base_product_id (Key) — integer — Primary key — NOT NULL
  • name (Field) — varchar
  • price (Field2) — integer
  • created_at (Field3) — date

ImageReviewHistory (이미지 리뷰 내역)

  • image_review_history_id (Key) — integer — Primary key — NOT NULL
  • status (Field) — enum
  • reason (Field2) — varchar
  • created_at (Field3) — date
  • product_image_id (Key2) — id — Foreign key → ProductImage.product_image_id — NOT NULL

Option (옵션)

  • option_id (Key) — integer — Primary key — NOT NULL
  • base_product_id (Key2) — integer — Foreign key → BaseProduct.base_product_id — NOT NULL
  • option_value_id (Key4) — integer — Foreign key → OptionValue.option_value_id — NOT NULL

OptionType (옵션 유형)

  • option_type_id (Key) — integer — Primary key — NOT NULL
  • type (Field) — varchar

OptionValue (옵션 값)

  • option_value_id (Key) — integer — Primary key — NOT NULL
  • option_type_id (Key2) — integer — Foreign key → OptionType.option_type_id — NOT NULL
  • value (Field) — varchar

Product (상품)

  • product_id (Key) — integer — Primary key — NOT NULL
  • base_product_id (Key3) — integer — Foreign key → BaseProduct.base_product_id — NOT NULL
  • seller_id (Key2) — integer — Foreign key → Seller.seller_id — NOT NULL
  • title (Field) — varchar
  • current_status (Field3) — enum
  • created_at (Field2) — date

ProductImage (상품 이미지)

  • product_image_id (Key) — id — Primary key — NOT NULL
  • product_id (Key2) — integer — Foreign key → Product.product_id — NOT NULL
  • image_url (Field) — varchar
  • current_status (Field2) — enum
  • created_at (Field3) — date

ProductReviewHistory (CopyOf이미지 리뷰 내역)

  • product_review_history_id (Key) — integer — Primary key — NOT NULL
  • status (Field) — enum
  • reason (Field2) — varchar
  • created_at (Field3) — date
  • product_id (Key2) — integer — Foreign key → Product.product_id — NOT NULL

Seller (판매자)

  • seller_id (Key) — integer — Primary key — NOT NULL
  • name (Field) — varchar
  • password (Field2) — varchar
  • created_at (Field3) — date