care1

Tables (6)

tbl_animal

  • animal_id — INT — Primary key — NOT NULL
  • user_id — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
  • animal_nm — VARCHAR(100)
  • species — VARCHAR(100)
  • age — INT
  • crt_at — TIMESTAMP

tbl_env

  • env_id — INT — Primary key — NOT NULL
  • animal_id — INT — Foreign key → tbl_animal.animal_id — NOT NULL
  • temp — DECIMAL(5, 2)
  • humidity — DECIMAL(5, 2)
  • last_upd — TIMESTAMP

tbl_fw

  • fw_id — INT — Primary key — NOT NULL
  • animal_id — INT — Foreign key → tbl_animal.animal_id — NOT NULL
  • food_amt — DECIMAL(5, 2)
  • water_amt — DECIMAL(5, 2)
  • sched_time — TIMESTAMP
  • last_fed — TIMESTAMP

tbl_light

  • light_id — INT — Primary key — NOT NULL
  • animal_id — INT — Foreign key → tbl_animal.animal_id — NOT NULL
  • light_on_tm — TIME
  • light_off_tm — TIME
  • last_chg — TIMESTAMP

tbl_sched

  • sched_id — INT — Primary key — NOT NULL
  • animal_id — INT — Foreign key → tbl_animal.animal_id — NOT NULL
  • sched_type — VARCHAR(50)
  • sched_time — TIMESTAMP
  • status — VARCHAR(20)
  • crt_at — TIMESTAMP

user

  • user_id — VARCHAR(255) — Primary key — NOT NULL
  • user_name — VARCHAR(255)
  • user_email — VARCHAR(255)
  • user_password — VARCHAR(255)
  • user_created — TIMESTAMP
  • user_updated — TIMESTAMP