ERD

Tables (5)

Category (Untitled2)

  • CategoryId (Key) — Primary key — NOT NULL
  • CompanyId (Key2) — Foreign key → Company.CompanyId — NOT NULL
  • CategoryName (Field)
  • Is_Active (Field2)

Company (Untitled)

  • CompanyId (Key) — Primary key — NOT NULL
  • CompanyName (Field)

Module (Untitled3)

  • ModuleId (Key) — Primary key — NOT NULL
  • CategoryId (Key2) — Foreign key → Category.CategoryId — NOT NULL
  • CompanyId (Key22) — Foreign key → Category.CompanyId — NOT NULL
  • ModuleName (Field)
  • Is_Active (Field2)

SuccessOrFail (Untitled5)

  • SuccessOfFailId (Key) — Primary key — NOT NULL
  • SuccessOrFailOrStop (Field)

WorkLog (Untitled4)

  • WorkLogId (Key) — Primary key — NOT NULL
  • ModuleId (Key2) — Foreign key → Module.ModuleId — NOT NULL
  • CategoryId (Key22) — Foreign key → Module.CategoryId — NOT NULL
  • CompanyId (Key222) — Foreign key → Module.CompanyId — NOT NULL
  • SuccessOfFailId (Key3) — Foreign key → SuccessOrFail.SuccessOfFailId — NOT NULL
  • StartTime (Field)
  • EndTime (Field2)
  • Log (Field3)