test1
Tables (10)
care_assignment
- assignment_id — BIGINT
- client_id — BIGINT — NOT NULL
- caregiver_id — BIGINT — NOT NULL
- care_request_id — BIGINT — NOT NULL
- service_type_id — BIGINT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
- status — ENUM('ACTIVE','CHANGED','ENDED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
care_assignment_history
- history_id — BIGINT
- client_id — BIGINT — NOT NULL
- caregiver_id — BIGINT — NOT NULL
- care_request_id — BIGINT — NOT NULL
- service_type_id — BIGINT — NOT NULL
- assigned_from — DATE — NOT NULL
- assigned_to — DATE
- reason — VARCHAR(255)
- created_at — DATETIME — NOT NULL
care_request
- care_request_id — BIGINT
- client_id — BIGINT — NOT NULL
- service_type_id — BIGINT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE
- days_of_week — VARCHAR(20) — NOT NULL
- time_slot — ENUM('MORNING','AFTERNOON','EVENING','NIGHT') — NOT NULL
- required_gender — ENUM('ANY','MALE','FEMALE') — NOT NULL
- required_traits — VARCHAR(255)
- status — ENUM('PENDING','ACTIVE','PAUSED','ENDED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
caregiver_profile
- caregiver_id — BIGINT
- gender — ENUM('MALE', 'FEMALE', 'OTHER') — NOT NULL
- birth_date — DATE
- career_years — INT
- license_number — VARCHAR(50)
- specialty_tags — VARCHAR(255)
- preference_tags — VARCHAR(255)
- home_address — VARCHAR(255)
- home_lat — DECIMAL(10,7)
- home_lng — DECIMAL(10,7)
- note — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
caregiver_schedule
- schedule_id — BIGINT
- caregiver_id — BIGINT — NOT NULL
- date — DATE — NOT NULL
- time_slot — ENUM('MORNING', 'AFTERNOON', 'EVENING', 'NIGHT') — NOT NULL
- availability — ENUM('AVAILABLE', 'UNAVAILABLE', 'PREFERRED') — NOT NULL
- reason — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
client
- client_id — BIGINT
- name — VARCHAR(50) — NOT NULL
- gender — ENUM('MALE', 'FEMALE', 'OTHER') — NOT NULL
- birth_date — DATE
- phone — VARCHAR(20)
- family_contact — VARCHAR(50)
- care_level — ENUM('LEVEL1','LEVEL2','LEVEL3','LEVEL4','LEVEL5','OTHER')
- main_diagnosis — VARCHAR(255)
- traits_tags — VARCHAR(255)
- address — VARCHAR(255) — NOT NULL
- lat — DECIMAL(10,7)
- lng — DECIMAL(10,7)
- status — ENUM('ACTIVE','PAUSED','ENDED') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
matching_score_log
- matching_score_id — BIGINT
- care_request_id — BIGINT — NOT NULL
- caregiver_id — BIGINT — NOT NULL
- distance_km — DECIMAL(6,2)
- duration_min — INT
- availability_score — INT
- trait_score — INT
- gender_score — INT
- total_score — INT — NOT NULL
- meta_json — JSON
- calculated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
member
- member_id — BIGINT
- login_id — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- role — ENUM('ADMIN', 'MANAGER', 'COORDINATOR', 'CAREGIVER') — NOT NULL
- status — ENUM('ACTIVE', 'INACTIVE', 'RESIGNED') — NOT NULL
- hire_date — DATE
- resign_date — DATE
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
route_cache
- route_id — BIGINT
- from_lat — DECIMAL(10,7) — NOT NULL
- from_lng — DECIMAL(10,7) — NOT NULL
- to_lat — DECIMAL(10,7) — NOT NULL
- to_lng — DECIMAL(10,7) — NOT NULL
- distance_km — DECIMAL(6,2) — NOT NULL
- duration_min — INT — NOT NULL
- calculated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
service_type
- service_type_id — BIGINT
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- default_duration_min — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL