ournest

Tables (15)

appointment

  • appointment_id — INTEGER
  • doctor_id — INTEGER — NOT NULL
  • patient_id — INTEGER — NOT NULL
  • appointment_at — TIMESTAMP
  • status — VARCHAR(30)
  • medium — VARCHAR(30)
  • notes — VARCHAR(255)
  • created_at — TIMESTAMP

baby

  • baby_id — INTEGER
  • mother_id — INTEGER — NOT NULL
  • father_id — INTEGER
  • name — VARCHAR(100)
  • birth_date — DATE
  • gender — VARCHAR(10)
  • created_at — TIMESTAMP

baby_care_log

  • log_id — INTEGER
  • baby_id — INTEGER — NOT NULL
  • date — DATE
  • sleep_hours — DOUBLE
  • feeding_details — VARCHAR(255)
  • diaper_changes — INTEGER
  • weight — DOUBLE
  • vaccination — VARCHAR(255)
  • notes — VARCHAR(255)
  • created_at — TIMESTAMP

chat

  • chat_id — INTEGER
  • user_id — INTEGER — NOT NULL
  • chatbot_type — VARCHAR(50)
  • message — VARCHAR(255)
  • response — VARCHAR(255)
  • created_at — TIMESTAMP

content

  • content_id — INTEGER
  • title — VARCHAR(255)
  • slug — VARCHAR(255)
  • summary — VARCHAR(255)
  • body — VARCHAR(255)
  • category — VARCHAR(100)
  • image_url — VARCHAR(255)
  • created_by — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • is_featured — BOOLEAN

doctor

  • doctor_id — INTEGER
  • user_id — INTEGER — NOT NULL
  • specialization — VARCHAR(150)
  • license_number — VARCHAR(80)
  • verified — BOOLEAN
  • rating — DOUBLE
  • created_at — TIMESTAMP

doctor_metadata

  • metadata_id — INTEGER
  • doctor_id — INTEGER — NOT NULL
  • baby_id — INTEGER
  • weight — DOUBLE
  • vaccination — VARCHAR(255)
  • note — VARCHAR(255)
  • created_at — TIMESTAMP

doctor_review

  • review_id — INTEGER
  • appointment_id — INTEGER — NOT NULL
  • patient_id — INTEGER — NOT NULL
  • rating — INTEGER
  • comment — VARCHAR(255) — ARCHAR(255
  • created_at — TIMESTAMP

partner_invitation

  • invitation_id — INTEGER
  • mother_id — INTEGER — NOT NULL
  • partner_email — VARCHAR(150)
  • partner_user_id — INTEGER
  • token — VARCHAR(255)
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • accepted_at — TIMESTAMP

period_tracker

  • tracker_id — INTEGER
  • woman_id — INTEGER — NOT NULL
  • cycle_start — DATE
  • cycle_end — DATE
  • cycle_length — INTEGER
  • symptoms — VARCHAR(255)
  • notes — VARCHAR(255)
  • created_at — TIMESTAMP

pregnancy_tracker

  • tracker_id — INTEGER
  • mother_id — INTEGER — NOT NULL
  • doctor_id — INTEGER
  • is_pregnant — BOOLEAN
  • pregnancy_start_date — DATE
  • gestational_age_weeks — INTEGER
  • estimated_due_date — DATE
  • is_first_child — BOOLEAN
  • baby_size — VARCHAR(100)
  • tips — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

pregnancy_week_info

  • week_info_id — INTEGER
  • tracker_id — INTEGER — NOT NULL
  • week_number — INTEGER
  • summary — VARCHAR(255)
  • symptoms — VARCHAR(255)
  • fetal_development — VARCHAR(255)
  • doctor_notes — VARCHAR(255)
  • created_at — TIMESTAMP

profile

  • profile_id — INTEGER
  • user_id — INTEGER — NOT NULL
  • date_of_birth — DATE
  • phone — VARCHAR(30)
  • address — VARCHAR(255)
  • avatar_url — VARCHAR(255)
  • bio — VARCHAR(255)
  • created_at — TIMESTAMP

user_settings

  • user_id — INTEGER
  • language — VARCHAR(10)
  • app_mode — VARCHAR(20)
  • notifications_enabled — BOOLEAN
  • dark_mode — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • user_id — INTEGER
  • full_name — VARCHAR(100)
  • email — VARCHAR(100)
  • password — VARCHAR(255)
  • mobile — VARCHAR(20)
  • address — VARCHAR(200)
  • age — INTEGER
  • gender — VARCHAR(20)
  • role — VARCHAR(50)