TEST
Tables (5)
hearts
- heart_id — INT
- sender_id — INT — NOT NULL
- receiver_id — INT — NOT NULL
- created_at — TIMESTAMP
invites
- invite_id — INT
- sender_id — INT — NOT NULL
- receiver_id — INT — NOT NULL
- status — ENUM('대기', '수락', '거절')
- sent_at — TIMESTAMP
- review_enabled — BOOLEAN
reviews
- review_id — INT
- invite_id — INT — NOT NULL
- rating — TINYINT
- review_text — TEXT
- created_at — TIMESTAMP
user_reviews
- user_review_id — INT
- user_id — INT — NOT NULL
- review_id — INT — NOT NULL
users
- user_id — INT
- role — ENUM('견주', '도그워커') — NOT NULL
- id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- photo — VARCHAR(255)
- sniff_score — DECIMAL(5, 2)
- introduction — TEXT
- location — POINT
- timetable — JSON
- created_at — TIMESTAMP