솔로 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