솔로 6

테이블 (7)

Item (Untitled4)

  • Item-ID (Key) — Int — 기본 키 — NOT NULL
  • Category-ID (Key2) — Int — 외래 키 → Item-Category.Category-ID — NOT NULL
  • Name (Field) — Str
  • Sell_price (Field2) — Int
  • Buy_price (Field3) — Int
  • Image_dir (Field4) — Str
  • IsInShop (Field5) — bool

Item-Category (Untitled3)

  • Category-ID (Key) — Int — 기본 키 — NOT NULL
  • Name (Field) — Str

Mission (Untitled2)

  • Mission-ID (Key) — Int — 기본 키 — NOT NULL
  • Mission-Category-ID (Key2) — Int — 외래 키 → Mission-category.Mission-Category-ID — NOT NULL
  • Name (Field3) — Str
  • Content (Field4) — Str

Mission-category (Untitled5)

  • Mission-Category-ID (Key) — Int — 기본 키 — NOT NULL
  • Name (Field) — Str

MyMission(User-Mission) (Untitled6)

  • MyMissionID (Key) — Int — 기본 키 — NOT NULL
  • USER-ID (Key2) — Str — 외래 키 → USER.USER-ID — NOT NULL
  • Mission-ID (Key3) — Int — 외래 키 → Mission.Mission-ID — NOT NULL
  • Mission-Category-ID (Key22) — Int — 외래 키 → Mission.Mission-Category-ID — NOT NULL
  • Item-ID (Key4) — Int — 외래 키 → Item.Item-ID — NOT NULL
  • Category-ID (Key23) — Int — 외래 키 → Item.Category-ID — NOT NULL
  • IsCleared (Field) — bool

USER (Untitled)

  • USER-ID (Key) — Str — 기본 키 — NOT NULL
  • Name (Field) — Str
  • Money (Field2) — Int
  • Theme (Field3) — Int

myItems(User-Item) (Untitled8)

  • myItemsID (Key) — Int — 기본 키 — NOT NULL
  • USER-ID (Key2) — Str — 외래 키 → USER.USER-ID — NOT NULL
  • Item-ID (Key3) — Int — 외래 키 → Item.Item-ID — NOT NULL
  • Category-ID (Key22) — Int — 외래 키 → Item.Category-ID — NOT NULL
  • IsInFarm (Field) — bool
  • location (Field2) — int