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