2차프로젝트

테이블 (3)

PLATFORM (Untitled2)

  • platform_id (PK) — INT — 기본 키 — NOT NULL
  • sales_id (PK2) — INT — 외래 키 → PLATFORM_SALES.sales_id — NOT NULL
  • product_id (FK) — INT — 외래 키 → PLATFORM_SALES.product_id — NOT NULL
  • platform_id (Key3) — INT — 외래 키 → PLATFORM_SALES.platform_id — NOT NULL
  • platform_name (Field) — VARCHAR(50)

PLATFORM_SALES (Untitled3)

  • sales_id (PK) — INT — 기본 키 — NOT NULL
  • product_id (FK) — INT — 기본 키 — NOT NULL
  • platform_id (Key3) — INT — 기본 키 — NOT NULL
  • selling_price (Field) — DECIMAL(10,2)
  • stock_quantity (Field2) — INT
  • safety_stock (Field3) — INT
  • sales_status (Field4) — VARCHAR(20)
  • updated_at (Field5) — DATETIME

PRODUCT (Untitled)

  • product_id (PK) — INT — 기본 키 — NOT NULL
  • sales_id (PK2) — INT — 외래 키 → PLATFORM_SALES.sales_id — NOT NULL
  • product_id (FK) — INT — 외래 키 → PLATFORM_SALES.product_id — NOT NULL
  • platform_id (Key3) — INT — 외래 키 → PLATFORM_SALES.platform_id — NOT NULL
  • product_name (Field) — VARCHAR(100)
  • category (Field2) — VARCHAR(50)
  • brand (Field3) — VARCHAR(50)