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)