goodpoopee

Tables (12)

BlackListDeviceToken (blacklist_device_tokens)

  • ID (id) — INT(11) — Primary key — NOT NULL — PK
  • Token (token) — String(500) — NOT NULL
  • Created Date (created_date) — TIMESTAMP — NOT NULL
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL

BlackListUserToken (blacklist_user_tokens)

  • ID (id) — INT(11) — Primary key — NOT NULL — PK
  • Token (token) — String(500) — NOT NULL
  • Created Date (created_date) — TIMESTAMP — NOT NULL
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL

Daily Statistics (daily_stat)

  • Date (date) — DATE — Primary key — NOT NULL — PK
  • Pet id (pet_id) — INT(11) — Foreign key → Pet.Pet id — NOT NULL — PK
  • User id (user_id) — INT(11) — Foreign key → Pet.User id — NOT NULL — not PK
  • Count (count) — INT(11) — NOT NULL
  • Success (success) — INT(11) — NOT NULL
  • Ratio (ratio) — INT(11) — NOT NULL
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL
  • Created date (created_date) — TIMESTAMP — NOT NULL

Monthly Statistics (monthly_stat)

  • Date (date) — DATE — Primary key — NOT NULL — PK, Only use first day of month
  • Pet id (pet_id) — INT(11) — Foreign key → Pet.Pet id — NOT NULL — PK
  • User id (user_id) — INT(11) — Foreign key → Pet.User id — NOT NULL — not PK
  • Count (count) — INT(11) — NOT NULL
  • Success (success) — INT(11) — NOT NULL
  • Progress (progress) — FLOAT(10) — NOT NULL — 0~100
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL
  • Created date (created_date) — TIMESTAMP — NOT NULL

Pad (pad)

  • Pad id (id) — INT(11) — Primary key — NOT NULL — PK, AutoIncrement
  • Ppcam id (ppcam_id) — INT(11) — Foreign key → Ppcam.Ppcam id — NOT NULL
  • User id (user_id) — INT(11) — Foreign key → Ppcam.User id — NOT NULL
  • Left Up (lu) — INT(11) — NOT NULL
  • Left Down (ld) — INT(11) — NOT NULL
  • Right Up (ru) — INT(11) — NOT NULL
  • Right Down (rd) — INT(11) — NOT NULL
  • Created date (created_date) — TIMESTAMP — NOT NULL
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL

Pet (pet)

  • Pet id (pet_id) — INT(11) — Primary key — NOT NULL — PK, AutoIncrement
  • User id (user_id) — INT(11) — Foreign key → User.User id — NOT NULL
  • Pet name (name) — VARCHAR(255) — NOT NULL
  • Breed (breed) — VARCHAR(255) — NOT NULL
  • Gender (gender) — VARCHAR(255) — NOT NULL
  • Birth (birth) — TIMESTAMP
  • Adoption (adoption) — TIMESTAMP
  • Created date (created_date) — TIMESTAMP — NOT NULL
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL

Pet record (pet_record)

  • Timestamp (timestamp) — TIMESTAMP — Primary key — NOT NULL — PK
  • Pet id (pet_id) — INT(11) — Foreign key → Pet.Pet id — NOT NULL — PK
  • User id (user_id) — INT(11) — Foreign key → Pet.User id — NOT NULL — not PK
  • Result (result) — VARCHAR(255) — NOT NULL — Success or Fail
  • Image UUID (image_uuid) — VARCHAR(255) — NOT NULL
  • Created date (created_date) — TIMESTAMP — NOT NULL
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL

Ppcam (ppcam)

  • Ppcam id (id) — INT(11) — Primary key — NOT NULL — PK, AutoIncrement
  • User id (user_id) — INT(11) — Foreign key → User.User id — NOT NULL
  • Serial Num (serial_num) — VARCHAR(255) — NOT NULL
  • IP address (ip_address) — VARCHAR(255) — NOT NULL
  • Created date (created_date) — TIMESTAMP — NOT NULL
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL

Ppcam serial numbers (ppcam_serial_nums)

  • Serial num (serial_num) — VARCHAR(255) — Primary key — NOT NULL — ex: PC1K1210101
  • Production (produciton) — TINYINT(1) — NOT NULL — ex: 1 TRUE, 0 FALSE
  • Sold (sold) — TINYINT(1) — NOT NULL — ex: 1 TRUE, 0 FALSE
  • Created datec (created_date) — TIMESTAMP — NOT NULL
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL

Ppsnack (ppsnack)

  • Ppsnack (id) — INT(11) — Primary key — NOT NULL — PK, AutoIncrement
  • Ppcam id (ppcam_id) — INT(11) — Foreign key → Ppcam.Ppcam id — NOT NULL — PK, AutoIncrement
  • User id (user_id) — INT(11) — Foreign key → Ppcam.User id — NOT NULL
  • Serial Num (serial_num) — VARCHAR(255) — NOT NULL
  • feedback_ratio — FLOAT(10) — NOT NULL — default = 1.0
  • Creataed date (created_date) — TIMESTAMP — NOT NULL
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL

Ppsnack serial numbers (ppsnack_serial_nums)

  • Serial num (serial_num) — VARCHAR(255) — Primary key — NOT NULL — ex: PC1K1210101
  • Production (produciton) — TINYINT(1) — NOT NULL — ex: 1 TRUE, 0 FALSE
  • Sold (sold) — TINYINT(1) — NOT NULL — ex: 1 TRUE, 0 FALSE
  • Created datec (created_date) — TIMESTAMP — NOT NULL
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL

User (user)

  • User id (id) — INT(11) — Primary key — NOT NULL — PK
  • Email (email) — VARCHAR(100) — NOT NULL
  • First name (first_name) — VARCHAR(255) — NOT NULL
  • Last name (last_name) — VARCHAR(255) — NOT NULL
  • Hashed password (hashed_password) — VARCHAR(255) — NOT NULL
  • Created date (created_date) — TIMESTAMP — NOT NULL
  • Last modified date (last_modified_date) — TIMESTAMP — NOT NULL