A final report which describes and documents your analysis and design efforts of the proposed solution. Your report must include at a minimum A brief description of the problem, functionality of your proposed information system solution, and the business
FAST ANSWERS_PHD
ERDiagramDashboardApp.zipdesign_Mockup1.pdf
Untitled
July 25 2022
Contents
1. Page 1
ERDiagramDashboardApp.pdf
RegisteredUsersRegisteredUsers UserLogInCredentialsUserLogInCredentials
ApiEntryPointApiEntryPoint
PermissionsPermissions
RolesRoles
DashboardAppDashboardApp
ThirdPartyApisTokensThirdPartyApisTokens
EnterpriseFilesystemEnterpriseFilesystem
empIDempID intPK intPK
nameFirstnameFirst nvarch ar(15)
nvarch ar(15)
nameLastnameLast nvarch ar(15)
nvarch ar(15)
empIDUsernameempIDUsername nvarch ar(20)
PK nvarch ar(20)
PK
empIDempID intFK intFK
usernameusername char(1
0) char(1
0)
apiRequestUsernameapiRequestUsername nvarch ar(10)
PK nvarch ar(10)
PK
userRoleIDuserRoleID intint
authTokenauthToken intint
empIDUsernameempIDUsername nvarch ar(15)FK
PK nvarch ar(15)FK
PK
authorizationsauthorizations intint
rightsProfilesGranted rangerightsProfilesGranted range intint
userRoleIDuserRoleID int FK
PK int
FK
PK
roleNameroleName varcha
r(15) varcha
r(15)
createdAtcreatedAt dateti
me dateti
me
empIDUsernameempIDUsername int FK
PK int
FK
PK
thirdPartyProductsthirdPartyProducts nvarch ar(200
)
nvarch ar(200
)
analysisToolsCustomanalysisToolsCustom intint
requestTokenrequestToken nvarch ar(200
) PK
nvarch ar(200
) PK
googleanalyticsgoogleanalytics nvarch ar(200
)
nvarch ar(200
)
sqlPostGressqlPostGres nvarch ar(200
)
nvarch ar(200
)
empIDUsernameempIDUsername intPK intPK
hardDrivehardDrive intint
documentsdocuments intint
emailemail nvarch ar(15)
nvarch ar(15)
isContractor defaultisContractor default bit bit
employedDateemployedDate dateti
me dateti
me
passwordpassword nvarch ar(10)
nvarch ar(10)
accountType domainaccountType domain char(3
) char(3
)
userRoleIDuserRoleID intFK intFK
updatedAtupdatedAt dateti
me dateti
me
dashboardAppAuthdashboardAppAuth intint
apiRequestUsernameapiRequestUsername intFK intFK
templatesCustomtemplatesCustom intint
apiRequestUsernameapiRequestUsername nvarch ar(200
) FK
nvarch ar(200
) FK
requestTokenrequestToken nvarca hr(200
) FK
nvarca hr(200
) FK
sqlLitesqlLite nvarch ar(200
)
nvarch ar(200
)
OracleOracle nvarch ar(200
)
nvarch ar(200
)
caliRalicaliRali nvarch ar(200
)
nvarch ar(200
)
keyMetrickeyMetric nvarch ar(200
)
nvarch ar(200
)
mySqlmySql nvarch ar(200
)
nvarch ar(200
)
sharedDocumentssharedDocuments intint
- 5452a416-8a8d-4e87-9328-a36f2ea69c37.vsdx
- Page-1
