Technical Overview

Databases

1.1 User Database

Table: User_Details

UserID (Primary Key)

FirstName

LastName

UserName

UserEmail

UserPassword (encrypted)

UserLocation

ProfilePicture

JoiningDate

Bio

Table: User_Skills

UserSkillID (Primary Key)

UserID (Foreign Key to User_Details)

SkillID (Foreign Key to Skills_Details)

SkillLevel

SkillAcquisitionDate

Table: User_Interests

UserInterestID (Primary Key)

UserID (Foreign Key to User_Details)

InterestArea

Table: User_Projects

UserProjectID (Primary Key)

UserID (Foreign Key to User_Details)

ProjectID (Foreign Key to Project_Details)

RoleInProject

JoiningDate

Table: User_Contribution

ContributionID (Primary Key)

UserID (Foreign Key to User_Details)

ProjectID (Foreign Key to Project_Details)

ContributionType (Article, Comment, Review, etc.)

ContributionContent

1.2 Skills Database

Table: Skills_Details

SkillID (Primary Key)

SkillName

SkillDescription

SkillCategory

SkillDemand

1.3 Resources Database

Table: Resource_Details

ResourceID (Primary Key)

ResourceName

ResourceType

ResourceDescription

ResourceOwnerID (Foreign Key to User_Details)

ResourceQuantity

ResourceLocation

Table: Resource_Allocation

AllocationID (Primary Key)

ResourceID (Foreign Key)

UserID (Foreign Key)

AllocationDate

ReturnDate

QuantityAllocated

1.4 Projects Database

Table: Project_Details

ProjectID (Primary Key)

ProjectName

ProjectDescription

ProjectStatus

ProjectStartDate

ProjectEndDate

ProjectLeader (Foreign Key to User_Details)

ProjectBudget

Table: Project_Resource_Allocation

AllocationID (Primary Key)

ProjectID (Foreign Key)

ResourceID (Foreign Key)

QuantityAllocated

AllocationDate

Table: Project_Participants

ParticipantID (Primary Key)

ProjectID (Foreign Key)

UserID (Foreign Key)

JoiningDate

RoleInProject

Table: Task_Details

TaskID (Primary Key)

TaskName

TaskDescription

TaskStatus

TaskStartDate

TaskEndDate

TaskPriority

ProjectID (Foreign Key to Project_Details)

TaskAssignee (Foreign Key to User_Details)

Table: Task_Assignments

AssignmentID (Primary Key)

TaskID (Foreign Key to Task_Details)

UserID (Foreign Key to User_Details)

AssignedDate

CompletionDate

Table: Project_Feedback

FeedbackID (Primary Key)

UserID (Foreign Key to User_Details)

ProjectID (Foreign Key to Project_Details)

Feedback

FeedbackDate

1.5 Knowledge Base Database

Table: Knowledge_Base

ArticleID (Primary Key)

ArticleTitle

ArticleContent

AuthorID (Foreign Key to User_Details)

ArticleDate

ArticleCategory

Table: Article_Comments

CommentID (Primary Key)

ArticleID (Foreign Key to Knowledge_Base)

UserID (Foreign Key to User_Details)

Comment

CommentDate

1.6 Initiative Frameworks Database

Table: Framework_Details

FrameworkID (Primary Key)

FrameworkTitle

FrameworkDescription

FrameworkSteps

FrameworkAuthor (Foreign Key to User_Details)

Table: Framework_Use

FrameworkUseID (Primary Key)

FrameworkID (Foreign Key)

ProjectID (Foreign Key to Project_Details)

UseDate

2. Applications

2.1 User Management App

This application handles user registration, login, profile management, skills and interest updates, and project participation.

2.2 Skills Inventory App

This application manages the skill inventory, updating and showcasing users' skills and interests, and allows for the creation of a merit-based resume system.

2.3 Resources Management App

This app manages the resources, including resource inventory, allocation, requests, and tracking.

2.4 Project Management App

This application manages the entire lifecycle of a project from creation to completion, including resource allocation, task management, participant roles, and project feedback. It also manages task assignments and completion.

2.5 Knowledge Base App

This application handles the creation, editing, categorization, and commenting on knowledge base articles.

2.6 Initiative Frameworks App

This application manages the creation, editing, and usage of initiative frameworks.