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