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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.urbanarray.org/sustainable-empowerment-asset-management-system/developers/seams-app-requirements/seams-low-code-overview/technical-overview.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.