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)