MERMAID

Tables (26)

appointments

  • appointment_id — INT
  • request_id — INT — NOT NULL
  • scheduled_time — DATETIME — NOT NULL
  • location_or_link — VARCHAR(500)
  • status — VARCHAR(20)
  • notes — TEXT

clients

  • client_id — INT
  • user_id — INT — NOT NULL
  • consultation_history — TEXT

contracts

  • contract_id — INT
  • proposal_id — INT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • terms — TEXT
  • status — VARCHAR(20)

dating_profiles

  • profile_id — INT
  • user_id — INT — NOT NULL
  • age — INT — NOT NULL
  • gender — VARCHAR(20) — NOT NULL
  • location — VARCHAR(255)
  • bio — TEXT
  • interests — TEXT
  • preferences — TEXT
  • created_at — TIMESTAMP

expertise

  • expertise_id — INT
  • professional_id — INT — NOT NULL
  • specialty — VARCHAR(100) — NOT NULL
  • certification — VARCHAR(255)

feedback

  • feedback_id — INT
  • interaction_id — INT — NOT NULL
  • rating — INT — NOT NULL
  • comment — TEXT — EX
  • submitted_at — TIMESTAMP

match_suggestions

  • suggestion_id — INT
  • score_id — INT — NOT NULL
  • target_user_id — INT — NOT NULL
  • confidence_level — DECIMAL(4, 2) — NOT NULL
  • explanation — TEXT
  • suggested_at — TIMESTAMP
  • viewed — BOOLEAN

matches

  • match_id — INT
  • user1_id — INT — NOT NULL
  • user2_id — INT — NOT NULL
  • matched_at — TIMESTAMP
  • is_active — BOOLEAN

matching_requests

  • request_id — INT
  • mentee_id — INT — NOT NULL
  • mentor_id — INT — NOT NULL
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • responded_at — TIMESTAMP

matching_scores

  • score_id — INT
  • user1_id — INT — NOT NULL
  • user2_id — INT — NOT NULL
  • compatibility_score — DECIMAL(5, 2) — NOT NULL
  • score_breakdown — TEXT
  • calculated_at — TIMESTAMP
  • algorithm_version — VARCHAR(50) — NOT NULL

mentee_profiles

  • mentee_id — INT
  • user_id — INT — NOT NULL
  • learning_goal — TEXT
  • current_level — VARCHAR(50)
  • preferred_schedule — VARCHAR(255)

mentor_profiles

  • mentor_id — INT
  • user_id — INT — NOT NULL
  • expertise_area — VARCHAR(100) — NOT NULL
  • years_of_experience — INT — NOT NULL
  • bio — TEXT
  • hourly_rate — DECIMAL(10, 2)
  • is_available — BOOLEAN

mentorships

  • mentorship_id — INT
  • request_id — INT — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • status — VARCHAR(20)

messages

  • message_id — INT
  • match_id — INT — NOT NULL
  • sender_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • sent_at — TIMESTAMP
  • is_read — BOOLEAN

photos

  • photo_id — INT
  • profile_id — INT — NOT NULL
  • photo_url — VARCHAR(500) — NOT NULL
  • is_primary — BOOLEAN
  • display_order — INT
  • uploaded_at — TIMESTAMP

professionals

  • professional_id — INT
  • user_id — INT — NOT NULL
  • profession_type — VARCHAR(50) — NOT NULL
  • license_number — VARCHAR(100) — NOT NULL
  • years_of_practice — INT — NOT NULL
  • consultation_fee — DECIMAL(10, 2)

proposals

  • proposal_id — INT
  • offering_id — INT — NOT NULL
  • need_id — INT — NOT NULL
  • proposal_text — TEXT — NOT NULL
  • quoted_price — DECIMAL(12, 2) — NOT NULL
  • status — VARCHAR(20)
  • submitted_at — TIMESTAMP

service_requests

  • request_id — INT
  • client_id — INT — NOT NULL
  • professional_id — INT
  • service_type — VARCHAR(100) — NOT NULL
  • urgency_level — VARCHAR(20)
  • description — TEXT — NOT NULL
  • preferred_date — DATETIME
  • created_at — TIMESTAMP

skill_needs

  • need_id — INT
  • seeker_id — INT — NOT NULL
  • required_skill — VARCHAR(100) — NOT NULL
  • project_duration — VARCHAR(50)
  • budget — DECIMAL(12, 2)
  • deadline — DATE
  • created_at — TIMESTAMP

skill_offerings

  • offering_id — INT
  • provider_id — INT — NOT NULL
  • skill_name — VARCHAR(100) — NOT NULL
  • proficiency_level — VARCHAR(20) — NOT NULL
  • rate — DECIMAL(10, 2)
  • is_available — BOOLEAN

skill_providers

  • provider_id — INT
  • user_id — INT — NOT NULL
  • provider_type — VARCHAR(50) — NOT NULL
  • rating — DECIMAL(3, 2)
  • completed_projects — INT

skill_seekers

  • seeker_id — INT
  • user_id — INT — NOT NULL
  • organization — VARCHAR(255)

swipes

  • swipe_id — INT
  • swiper_id — INT — NOT NULL
  • swiped_id — INT — NOT NULL
  • action — VARCHAR(20) — NOT NULL
  • swiped_at — TIMESTAMP

user_interactions

  • interaction_id — INT
  • initiator_id — INT — NOT NULL
  • recipient_id — INT — NOT NULL
  • interaction_type — VARCHAR(20) — NOT NULL
  • occurred_at — TIMESTAMP
  • metadata — TEXT

user_preferences

  • preference_id — INT
  • user_id — INT — NOT NULL
  • personality_traits — TEXT
  • values — TEXT
  • lifestyle — TEXT
  • matching_criteria — TEXT
  • updated_at — TIMESTAMP

users

  • user_id — INT — Primary key
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP