편의점
테이블 (5)
Logistics (Untitled)
- Logistics (Key) — PK — 기본 키 — NOT NULL
Product (Untitled3)
- Product_ID (Key) — PK — 기본 키 — NOT NULL
- Category_ID (Key3) — Integer — 외래 키 → Store.Store_ID — NOT NULL
- Store_ID (Key32) — Integer — 외래 키 → Store.Logistics — NOT NULL
- Product_Name (Field) — CharField
- Price (Field2) — Integer
Sales (Untitled4)
- Sales_ID (Key2) — PK — 기본 키 — NOT NULL
- Product_ID (Key) — Integer — 외래 키 → Product.Product_ID — NOT NULL
- Time (Field2) — Integer
Stock (Untitled5)
- Stock_ID (Key) — PK — 기본 키 — NOT NULL
- Logistics (Key3) — Integer — 외래 키 → Logistics.Logistics — NOT NULL
- Product_Name (Field) — CharField
- Price (Field2) — Integer
- Stock (Field3) — Integer
- Category (Field4) — CharField
Store (Untitled2)
- Store_ID (Key) — PK — 기본 키 — NOT NULL
- Location_ID — Integer — 외래 키 — NOT NULL
- Logistics (Key3) — Integer — 외래 키 → Stock.Logistics — NOT NULL
- Phone (Field2) — Integer
- Owner (Field3) — CharField