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