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)