Sangju

Tables (5)

Inventory (inventory)

  • Id (_id) — ObjectId — Primary key — NOT NULL
  • SeedList (seedList) — int[]
  • ItemList (itemList) — int[]
  • MaxStorage (maxStorage) — int
  • FruitType (fruitType) — int[]
  • FruitCount (fruitCount) — int[]
  • FruitCondition (fruitCondition) — int[]
  • HarvestTime (harvestTime) — int[]

Lab (lab)

  • Id (_id) — ObjectId — Primary key — NOT NULL
  • GrowLevel (growLevel) — int[]
  • EquipLevel (equipLevel) — int[]
  • GrowUpgradeTime (growUpgradeTime) — int[]
  • EquipUpgradeTime (equipUpgradeTime) — int[]

Medium (medium)

  • Id (_id) — ObjectId — Primary key — NOT NULL
  • MediumLine (mediumLine) — int
  • Installed (installed) — bool
  • GrowScore (growScore) — int
  • GrowStatus (growStatus) — int
  • Time (time) — float
  • Humidity (humidity) — float
  • Nutrient (nutrient) — bool
  • Insect (insect) — bool

SmartFarm (smartFarm)

  • Id (_id) — ObjectId — Primary key — NOT NULL
  • Light (light) — int
  • CO2 (co2) — float
  • Temperature (temperature) — float
  • Medium (medium) — ObjectId[] — Foreign key → Medium.Id — NOT NULL

User (user)

  • Id (_id) — ObjectId — Primary key — NOT NULL
  • UserName (username) — String
  • Name (name) — String
  • Nickname (nickname) — String
  • Password (pw) — String
  • Level (lv) — int
  • Experience (exp) — int
  • Money (money) — int
  • Loan (loan) — int
  • SmartFarm (smartFarm) — ObjectId[] — Foreign key → SmartFarm.Id — NOT NULL
  • Inventory (inventory) — ObjectId — Foreign key → Inventory.Id — NOT NULL
  • Lab (lab) — ObjectId — Foreign key → Lab.Id — NOT NULL