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