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)