4.1 Server Database 

• Module Table

•  Purpose:

stores the name of the module being uploaded by the end users and its related information

•     Fields:

        ID (Primary Key)
        Module Name
        Module Version
        Description
        AssemblyFile
        Class Name
        Zip File
        Created Date
        Created By
        Modified Date
        Modified By
        Is Deleted
        Is Collaborative
        Needs Authentication

•     Permissions Table

•     Purpose:

Stores the permissions name and its value related to specific module being uploaded

•  Fields:

        ID (Primary Key)
        Module ID (Foreign Key)
        Permission Name
        Permission Value

•  ModulePermission Table

• Purpose:

Stores the permission of the module assigned for particular role

• Fields:

    ID (Primary Key)
    Permission ID (Foreign Key)
    Role ID (Foreign Key)

• Page Table

• Purpose:

Stores the pages saved by the end users and its related information

•  Fields:

    ID (Primary Key)
    Page Title
    Description
    Is Public
    CreateDate
    Created By   
    Modified By
    IsDeleted
  

•  PageAllocation Table

•   Purpose:

Stores the pages assigned to specific user

• Fields:

        ID (Primary Key)
        Page ID (Foreign Key)
        User ID (Foreign Key)

•  Tabs Table

• Purpose:

    Stores the tabs and its attributes saved within particular page

• Fields:

ID (Primary Key)
Page ID (Foreign Key)
Tab Position
Tab Title
Description
Created Date
Created By
Modified Date
Modified By
Is Deleted

• PodLayout Table

• Purpose:

Stores the layout and attributes of pod saved in specific tab.

• Fields:

ID (Primary Key)
Tab ID (Foreign Key)
        Pod Title
        Pod Height
        Pod Width
        Pod Left
        Pod Top
        Icon File
        Module ID (Foreign Key)
Is Deleted
Created Date
        Created By
        Modified Date
        Modified By     
 

• UserInfo Table

• Purpose:

Stores the information specific to user registered to the system.

• Fields:

ID (Primary Key)
Display Name
Role ID (Foreign Key)
First Name
Last Name
Email
Password
Is Active
Is Deleted
Created Date
Created By
Modified Date
Modified By

• Role Table

• Purpose

    Stores the roles assigned to users when get registered to system.

• Fields

ID (Primary Key)
Role Name
Description
Created Date
Created By
Modified Date
Modified By
Is Deleted
Is Admin