JNC_DashBoard
Tables (5)
Category
- CategoryId (Key) — Primary key — NOT NULL
- CompanyId (Key2) — Foreign key → Company.CompanyId — NOT NULL
- CategoryLabel (Field)
Company
- CompanyId (Key) — Primary key — NOT NULL
- CompanyName (Field)
O_User
- UserID (Key) — 0 — Primary key — NOT NULL
- CompanyId (Key2) — Foreign key → Company.CompanyId — NOT NULL
- UserName (Field)
- UserEmail (Field2)
- UserPwd (Field3)
- APIKey (Field4)
P_User
- UserID (Key2) — Foreign key → O_User.UserID — NOT NULL
- CompanyId (Key22) — Foreign key → O_User.CompanyId — NOT NULL
- UserName (Field)
- UserEmail (Field2)
- UserPwd (Field3)
- UserRole (Field4)
RPAProject
- RPAProjectId (Key) — Primary key — NOT NULL
- CategoryId (Key2) — Foreign key → Category.CategoryId — NOT NULL
- CompanyId (Key22) — Foreign key → Category.CompanyId — NOT NULL
- RPAProjectName (Field)