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)