System Designs
lenwin
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)
empIDUs ernameempIDUs ername nvarch ar(20)
PK nvarch ar(20)
PK
empIDempID intFK intFK
usernameusername char(1
0) char(1
0)
apiR equestUsernameapiR equestUsername nvarch ar(10)
PK nvarch ar(10)
PK
userRoleIDuserRoleID intint
authTokenauthToken intint
empIDUs ernameempIDUs ername nvarch ar(15)FK
PK nvarch ar(15)FK
PK
authorizationsauthorizations intint
rights ProfilesGranted rangerights ProfilesGranted range intint
userRoleIDuserRoleID int FK
PK int
FK
PK
roleNameroleName varcha
r(15) varcha
r(15)
createdAtcreatedAt dateti
me dateti
me
empIDUs ernameempIDUs ername int FK
PK int
FK
PK
thi rdPartyProductsthi rdPartyProducts nvarch ar(200
)
nvarch ar(200
)
analysisToolsCus tomanalysisToolsCus tom intint
requestTokenrequestToken nvarch ar(200
) PK
nvarch ar(200
) PK
googleanalyticsgoogleanalytics nvarch ar(200
)
nvarch ar(200
)
sqlPostGressqlPostGres nvarch ar(200
)
nvarch ar(200
)
empIDUs ernameempIDUs ername intPK intPK
hardDrivehardDrive intint
documentsdocuments intint
emailemail nvarch ar(15)
nvarch ar(15)
isContractor defaultisContractor default bit bit
employedDateemployedDate dateti
me dateti
me
pas swordpas sword nvarch ar(10)
nvarch ar(10)
accountType domainaccountType domain char(3
) char(3
)
userRoleIDuserRoleID intFK intFK
updatedAtupdatedAt dateti
me dateti
me
das hboardAppAuthdas hboardAppAuth intint
apiR equestUsernameapiR equestUsername intFK intFK
templates Customtemplates Custom intint
apiR equestUsernameapiR equestUsername 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
