test
Tables (6)
Animal (animal)
- Animal ID (animal_id) — INT — Primary key — NOT NULL
- AccessToken (access_token) — INT — Foreign key → User.AccessToken — NOT NULL
- Animal Name (animal_name) — VARCHAR(255)
- Animal Type (animal_type) — VARCHAR(255)
- Animal Age (animal_age) — INT
- ...
Animal Log (animal_log)
- Log Date (log_date) — DATETIME — Primary key — NOT NULL
- Animal ID (animal_id) — INT — Foreign key → Animal.Animal ID — NOT NULL
- AccessToken (access_token) — INT — Foreign key → Animal.AccessToken — NOT NULL
- ...
Animal files (animal_files)
- Animal ID (animal_id) — INT — Foreign key → Animal Log.Animal ID — NOT NULL
- AccessToken (access_token) — INT — Foreign key → Animal Log.AccessToken — NOT NULL
- Key — DATETIME — Foreign key → Animal Log.Log Date — NOT NULL
- Photo Image (photo_image) — VARCHAR(100)
- Brush Image (brush_image) — VARCHAR(100)
- Sound Record (sound_record) — VARCHAR(100)
- ...
User (user)
- AccessToken (access_token) — INT — Primary key — NOT NULL
- User ID (user_id) — INT
User Data (user_data)
- AccessToken (access_token) — INT — Foreign key → User.AccessToken — NOT NULL
- User Name (user_name) — VARCHAR(255)
- User Address (user_address) — VARCHAR(255)
- User Phone Number (user_phonenumber) — VARCHAR(255)
- ... (..)