# 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.

<br>