tables Documentation

Introduction

This documentation provides a comprehensive breakdown of the tables used in the system. These tables are the foundational components of the application, facilitating efficient management of individuals, their areas of expertise, affiliations, and professional contributions.

The relationships between these tables are carefully designed to provide a seamless integration of data. This flow ensures that various aspects of an individual's profile, such as their skills, achievements, and affiliations, are interconnected and manageable.

Note: The diagram below is a high-level representation of how each table is designed and how they relate to one another. It illustrates the data structure and the logical connections between tables, which enable a cohesive and scalable system.

For adding or managing data, the Admin Interface offers an intuitive view where you can easily select and drop relationships like tags, roles, and areas of expertise without manual effort. This streamlined approach saves time and minimizes errors when updating or associating data across tables.

Flow Diagram

The flow diagram below demonstrates the relationships and processes involved in managing people-related data:

graph TD A[Create Tag] --> B[Add People Record] B --> C[Link Research Interests] B --> D[Add Social Links] D --> Z[Add People Social] B --> E[Specify Areas of Expertise] B --> F[Add Qualifications] B --> G[Add Memberships] B --> H[Assign Role Badges] B --> I[Link Key Initiatives] B --> J[Link Research Areas] J --> K[Save People Information]

The diagram illustrates the process of creating a new people record and associating it with various attributes.

A description of each data is given below:

Tag

The Tag is used to categorize individuals based on shared characteristics, enabling better filtering and organization.

Fields: name, created_at, updated_at
Example:

{
    "name": "Developer",
    "created_at": "2025-01-01T12:00:00Z",
    "updated_at": "2025-01-02T14:00:00Z"
}

People

The People table represents an individual in the system, storing personal and professional details.

Fields: title, full_name, association, image, slug, tags, created_at, updated_at
Example:

{
    "title": "Dr.",
    "full_name": "John Doe",
    "association": "eHealthHub",
    "image": "/images/profiles/john_doe.png",
    "slug": "john-doe",
    "tags": ["Developer", "Researcher"],
    "created_at": "2025-01-01T12:00:00Z",
    "updated_at": "2025-01-02T14:00:00Z"
}

Research Interest

The Research Interest table links individuals to topics they are passionate about.

Fields: name, created_at, updated_at
Example:

{
    "name": "Artificial Intelligence",
    "created_at": "2025-01-01T12:00:00Z",
    "updated_at": "2025-01-01T12:00:00Z"
}

Area of Expertise

The Area of Expertise table highlights fields where individuals excel.

Fields: name, created_at, updated_at
Example:

{
    "name": "Machine Learning",
    "created_at": "2025-01-01T12:00:00Z",
    "updated_at": "2025-01-01T12:00:00Z"
}

Role Badge

The Role Badge table assigns visual identifiers for roles or achievements.

Fields: name, created_at, updated_at
Example:

{
    "name": "Team Leader",
    "created_at": "2025-01-01T12:00:00Z",
    "updated_at": "2025-01-01T12:00:00Z"
}

Key Initiatives

The Key Initiatives table tracks major projects or campaigns individuals are involved in.

Fields: title, url, created_at, updated_at
Example:

{
    "title": "AI for Healthcare",
    "url": "https://example.com/ai-healthcare",
    "created_at": "2025-01-01T12:00:00Z",
    "updated_at": "2025-01-01T12:00:00Z"
}

Qualification

The Qualification table tracks certifications or educational achievements.

Fields: title, created_at, updated_at
Example:

{
    "title": "PhD in Computer Science",
    "created_at": "2025-01-01T12:00:00Z",
    "updated_at": "2025-01-01T12:00:00Z"
}

Membership

The Membership table tracks affiliations with organizations or societies.

Fields: title, created_at, updated_at
Example:

{
    "title": "IEEE Member",
    "created_at": "2025-01-01T12:00:00Z",
    "updated_at": "2025-01-01T12:00:00Z"
}

People Information

The People Information table integrates related data to form a complete profile.

Fields: people, about_user, institution, research_interests, areas_of_expertise, key_initiatives, key_research_areas, qualifications, memberships, role_badge
Example:

{
    "people": "John Doe",
    "about_user": "AI researcher with a focus on healthcare solutions.",
    "institution": "eHealthHub",
    "research_interests": ["Artificial Intelligence"],
    "areas_of_expertise": ["Machine Learning"],
    "key_initiatives": ["AI for Healthcare"],
    "qualifications": ["PhD in Computer Science"],
    "memberships": ["IEEE Member"],
    "role_badge": ["Team Leader"]
}