SJSeed

Tables (6)

Collection (도감)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (memberId) — Long — Foreign key → Member.Key — NOT NULL
  • Field (complete) — float

Member (사용자)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (year) — int
  • Field (loginId) — varchar
  • Field (password) — varchar
  • Field (phonenumber) — char(11)
  • Field (coin) — int
  • Field (attendedDays) — int
  • Field (premium) — bool
  • Field (lastAttendDate) — date
  • Field (consecutiveAttendDays) — int

Piece (식물 조각)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (speciesId) — Long — Foreign key → PlantSpecies.Key — NOT NULL
  • Key (collectionId) — Long — Foreign key → Collection.Key — NOT NULL
  • Key (memberId) — Long — Foreign key → Collection.Key — NOT NULL
  • Field (date) — date

Plant (식물)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (speciesId) — Long — Foreign key → PlantSpecies.Key — NOT NULL
  • Key (memberId) — Long — Foreign key → Member.Key — NOT NULL
  • Field (name) — varchar
  • Field (temperature) — float
  • Field (humidity) — float
  • Field (soilWater) — float
  • Field (wateredDate) — Date
  • Field (broughtDate) — Date
  • Field (diseased) — bool
  • Field (plantId) — varchar

PlantSpecies (식물 종류)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — varchar
  • Field (properTemp) — varchar
  • Field (properHum) — varchar
  • Field (process) — varchar
  • Field (period) — int
  • Field (description) — TEXT
  • Field (code) — varchar
  • Field (water) — varchar
  • Field (rarity) — int

Treatment (진료 기록)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (memberId) — Long — Foreign key → Member.Key — NOT NULL
  • Key (plantId) — Long — Foreign key → Plant.Key — NOT NULL
  • Key (speciesId) — Long — Foreign key → Plant.Key — NOT NULL
  • Field (date) — datetime
  • Field (disease) — varchar
  • Field (symptoms) — TEXT
  • Field (cause) — TEXT
  • Field (cure) — TEXT