1차 프로젝트

테이블 (4)

Platform (Untitled)

  • platform_id (PK) — INT — 기본 키 — NOT NULL
  • platform_name (Field) — VARCHAR(100)
  • country (Field2) — VARCHAR(50)
  • url (Field3) — VARCHAR(200)

Product_Listing (Untitled2)

  • listing_id (PK) — INT — 기본 키 — NOT NULL
  • platform_id (FK) — INT — 기본 키 — NOT NULL
  • product_id (Key3) — INT — 기본 키 — NOT NULL
  • platform_id (PK2) — INT — 외래 키 → Platform.platform_id — NOT NULL
  • product_id (PK3) — INT — 외래 키 → product_id.product_id — NOT NULL
  • sale_price (Field) — DECIMAL(12,2)
  • stock_quantity (Field2) — INT
  • listing_status (Field3) — VARCHAR(20)
  • registered_date (Field5) — DATETIME

Stock_Status (Untitled3)

  • status_id (PK) — INT — 기본 키 — NOT NULL
  • listing_id (FK) — INT — 기본 키 — NOT NULL
  • product_id (PK3) — INT — 외래 키 → Product_Listing.product_id — NOT NULL
  • listing_id (PK2) — INT — 외래 키 → Product_Listing.listing_id — NOT NULL
  • platform_id (FK2) — INT — 외래 키 → Product_Listing.platform_id — NOT NULL
  • product_id (Key3) — INT — 외래 키 → Product_Listing.product_id — NOT NULL
  • platform_id (PK22) — INT — 외래 키 → Product_Listing.platform_id — NOT NULL
  • stock_status (Field) — VARCHAR(20)
  • updated_at (Field2) — DATETIME

product_id (product)

  • product_id (PK) — INT — 기본 키 — NOT NULL
  • sku (Field) — VARCHAR(100)
  • product_name (Field2) — VARCHAR(200)
  • category (Field3) — VARCHAR(100)
  • base_price (Field4) — DECIMAL(12,2)