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