pet

Tables (8)

hospital_worktimes

  • hospital_id — bigint
  • day_of_week — varchar(50)
  • open_time — time
  • close_time — time
  • break_start — time
  • break_end — time
  • reception_deadline — time
  • is_open — boolean
  • created_at — timestamp
  • updated_at — timestamp

hospitals

  • id — bigint
  • name — varchar(50)
  • address — varchar(100)
  • street_address — varchar(100)
  • phone_number — varchar(50)
  • information — text
  • latitude — decimal(9,6)
  • longitude — decimal(9,6)
  • url — varchar(100)
  • image — varchar(100)
  • created_at — timestamp
  • updated_at — timestamp

review_images

  • id — BIGINT
  • review_id — BIGINT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL

treatment_animal

  • id — bigint
  • hospital_id — bigint
  • animal_type — varchar(50)
  • created_at — timestamp
  • updated_at — timestamp

user_consents

  • user_id — bigint
  • location — boolean
  • marketing — boolean
  • camera — boolean
  • created_at — timestamp
  • updated_at — timestamp

user_reviews

  • id — bigint
  • hospital_id — bigint
  • user_id — bigint
  • visit_day — date
  • animal_type — varchar(50)
  • treatment_service — varchar(100)
  • detailed_review — text
  • overall_rating — TINYINT
  • facility_rating — TINYINT
  • expertise_rating — TINYINT
  • kindness_rating — TINYINT
  • total_price — bigint
  • detail_price — text
  • created_at — timestamp
  • updated_at — timestamp

user_settings

  • user_id — bigint
  • event_push — boolean
  • marketing_push — boolean
  • created_at — timestamp
  • updated_at — timestamp

users

  • id — INT
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • created_at — TIMESTAMP