ageblooming

Tables (6)

Babysitter Matches (babysitter_matches)

  • Match ID (match_id) — INT(?) — Primary key — NOT NULL
  • Match Date (match_date) — DATE()
  • Status (status) — VARCHAR(255) — NOT NULL — Pending Confirmed Declined
  • Field

Babysitters (babysitters)

  • Babysitter ID (babysitter_id) — INT(?) — Primary key — NOT NULL
  • Babysitter Name (babysitter_name) — VARCHAR(255)
  • Babysitter Age (babysitter_age) — INT(3)
  • Babysitter Gender (babysitter_gender) — CHAR(1)
  • Babysitter Contact (babysitter_contact) — INT(11)
  • Babysitter Email (babysitter_email) — VARCHAR(255)
  • Babysitter Career (babysitter_carrer) — INT(2)

Caregivers (caregivers)

  • Caregiver ID (caregiver_id) — INT(?) — Primary key — NOT NULL
  • Caregiver Name (caregiver_name) — VARCHAR(255)
  • Caregiver Age (caregiver_age) — INT(3)
  • Caregiver Gender (caregiver_gender) — CHAR(1)
  • Caregiver Contact (caregiver_contact) — INT(11)
  • Caregiver Email (caregiver_email) — VARCHAR(255)
  • Caregiver Career (caregiver_carrer) — INT(2)

Eldercare Matches (eldercare_matches)

  • Match ID (match_id) — INT(?) — Primary key — NOT NULL
  • Match Date (match_date) — DATE()
  • Status (status) — VARCHAR(255) — NOT NULL — Pending Confirmed Declined
  • Field

Elders (elders)

  • Elder Id (elder_id) — INT(?) — Primary key — NOT NULL
  • Elder Name (elder_name) — VARCHAR(255)
  • Elder Age (elder_age) — INT(3)
  • Elder Gender (elder_gender) — CHAR(1)
  • Elder Contact (elder_contact) — INT(11)
  • Elder Email (elder_email) — VARCHAR(255)

Parents (parents)

  • Parent Id (parent_id) — INT(?) — Primary key — NOT NULL
  • Parent Name (parent_name) — VARCHAR(255)
  • Parent Age (parent_age) — INT(3)
  • Parent Gender (parent_gender) — CHAR(1)
  • Parent Contact (parent_contact) — INT(11)
  • Parent Email (parent_email) — VARCHAR(255)