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