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