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