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)
  • ...

Untitled3

    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)
    • ... (..)