System Designs

profilelenwin
ERDiagramDashboardApp.zip

design_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