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)