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