Pet
Tables (5)
Device (device)
- DEVICENO (DeviceNo) — number — Primary key — NOT NULL
- UserNo (userNo) — number — Foreign key → User.UserNo — NOT NULL
- SERIALNO (SerialNo) — var(30) — NOT NULL
- NAME (name)
- AGE (age)
- SPECIES (species)
- WEIGHT (weight)
FEED (feed)
- FEEDNO (feedno) — Primary key — NOT NULL
- NAME
- MANUFACTURER (manufacturer)
- PERCAL (percal)
- FORSPE (forspe)
LOGDATA (logdata)
- LOGNO (logno) — Primary key — NOT NULL
- DEVICENO (DeviceNo) — number — Foreign key → Device.DEVICENO — NOT NULL
- TIME (time)
- REMAIN (remain)
SettingTable (settingtable)
- TIMENO (timeno) — Primary key — NOT NULL
- DEVICENO (DeviceNo) — number — Foreign key → Device.DEVICENO — NOT NULL
- TIME (time)
- AMOUNT (amount)
User (user)
- UserNo (userNo) — number — Primary key — NOT NULL
- ID (id) — var(30) — NOT NULL
- PASSWORD (pw) — var(16) — NOT NULL
- EMAIL (email) — NOT NULL
- Name (name)