PetPal_Public

Tables (7)

Homes

  • home_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
  • home_nickname — varchar(10) — NOT NULL
  • home_created_at — timestamp — NOT NULL

Logs

  • log_id — BIGINT — Primary key — NOT NULL
  • event_type — VARCHAR(255)
  • log_created_at — timestamp — NOT NULL

Maps

  • map_id — BIGINT — Primary key — NOT NULL
  • home_id — BIGINT — Foreign key → Homes.home_id — NOT NULL
  • map_data — MEDIUMTEXT — NOT NULL
  • create_at — timestamp — NOT NULL

Notifications

  • notification_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → Users.user_id — NOT NULL
  • notification_content — VARCHAR(1024) — NOT NULL
  • notification_type — ENUM — NOT NULL
  • notification_created_at — timestamp — NOT NULL

Objects

  • object_id — BIGINT — Primary key — NOT NULL
  • home_id — BIGINT — Foreign key → Homes.home_id — NOT NULL
  • object_type — BIGINT — NOT NULL
  • cordinate — Point — NOT NULL
  • object_image — text — NOT NULL
  • created_at — timestamp — NOT NULL

Schedules

  • schedule_id — BIGINT — Primary key — NOT NULL
  • home_id — BIGINT — Foreign key → Homes.home_id — NOT NULL
  • schedule_start_time — DATETIME — NOT NULL
  • task_type — ENUM — NOT NULL
  • schedule_day — ENUM — NOT NULL
  • schedule_repeat — BOOLEAN — NOT NULL

Users

  • user_id — BIGINT — Primary key — NOT NULL
  • user_uuid — VARCHAR(36) — NOT NULL
  • user_email — VARCHAR(254) — NOT NULL
  • user_created_at — timestamp — NOT NULL
  • user_updated_at — timestamp — NOT NULL