시장
테이블 (8)
CUSTOMER (Untitled7)
- customerId (Key) — int(20) — 기본 키 — NOT NULL
- name (Field) — char(20)
- brithday (Field2) — date
- phone (Field3) — int(20)
- address (Field4) — longtext
- sex (Field6) — CHAR(10)
- marketId (Key2) — CHAR(30) — 외래 키 → TRADITIONAL MARKET.marketId — NOT NULL
ITEM (Untitled3)
- itemId (Key) — CHAR(30) — 기본 키 — NOT NULL
- itemName (Field) — CHAR(30)
- itemType (Field2) — CHAR(20)
- unit (Field3) — char(20)
- price (Field4) — int(10)
- origin (Field5) — CHAR(20)
MANAGER (Untitled4)
- managerName (Field) — CHAR(30)
- phone (Field2) — INT(20)
- marketId (Key) — CHAR(30) — 외래 키 → TRADITIONAL MARKET.marketId — NOT NULL
OWNER (Untitled5)
- ownerName (Field) — CHAR(30)
- phone (Field2) — int(20)
- shopNum (Key) — CHAR(30) — 외래 키 → SHOP.shopId — NOT NULL
RATING (Untitled8)
- rating (Field) — char(10)
- customerId (Key) — int(20) — 외래 키 → CUSTOMER.customerId — NOT NULL
- shopId (Key2) — CHAR(30) — 외래 키 → SHOP.shopId — NOT NULL
SELLING (Untitled6)
- itemId (Key) — CHAR(30) — 외래 키 → ITEM.itemId — NOT NULL
- shopId (Key2) — CHAR(30) — 외래 키 → SHOP.shopId — NOT NULL
- quantity (Field3) — int(10)
- sold (Field) — int(10)
SHOP (Untitled2)
- shopId (Key) — CHAR(30) — 기본 키 — NOT NULL
- location (Field) — CHAR(30)
- phone (Field2) — int(20)
- shopName (Field3) — CHAR(30)
- operatingTime (Field4) — longtext
- type (Field5) — CHAR(20)
- marketId (Key2) — CHAR(30) — 외래 키 → TRADITIONAL MARKET.marketId — NOT NULL
TRADITIONAL MARKET (Untitled)
- marketId (Key) — CHAR(30) — 기본 키 — NOT NULL
- address (Field) — longtext
- marketName (Field2) — CHAR(20)
- openDay (Field3) — CHAR(10)
- description (Field5) — longtext