Prompt company Web service

Prompt company web service for project management

Table of Contents

1. Project Configuration
2. Requirements
3. ER diagram
4. Sequence/Index
5. Development status

Screenshot

1. Project Configuration

2. Requirments

ID	Requirment's name
REQ-001	Register and Modify employee information
REQ-002	Search employee information(Manager)
REQ-003	Search for employee projects(Manager)
REQ-004	Project Management(Manager)
REQ-005	Search Project Duration(Manager)
REQ-006	Project Registration(PM)
REQ-007	Set project participation status
REQ-008	Project Staff Job Settings(PM)
REQ-009	Modifying project information(PM)
REQ-010	Revise project budget(Manager)

3. ER diagram

4. Sequence/Index

#Sequence

ID of all tables is generated using MySql sequence.

#Index

The columns used for the query create an index.

CREATE INDEX IDX_ENAME ON employee(emp_name);

Ref is used when searching with quality criteria when not primary key or unique (far better performance than full scan).

CREATE INDEX IDX_PERIOD ON project(proj_start_date, proj_end_date);

range is the same as index range scan of orcle.

5. Development status

• Implement permission isolation settings using passport-local.
  • Store userid in session using serializeUser function.
  • Set permission isolation by obtaining user information using the deserializeUser function.
• Encrypt password and save using Bcrypt.
• Implementation of pagination in case of increased staffing.

Screenshot