시장

테이블 (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