Please enable JavaScript.
Coggle requires JavaScript to display documents.
Unit, Policy, Customer, FinancialInsLocation, CRO, CustomerFacility,…
Unit
UnitId(PK)
UnitName
CreatedBy
CreatedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
UnitEmail
Policy
CIFNO(FK)
PolicyNo
PolicyId(PK)
PolicyTypeId(FK)
PerilId(FK)
Amount
StartDate
ExpiryDate
BECC/BOD Number
EndorsementNumber
NatureofPolicy
CompanyId(FK)
Locations
CurrencyId(FK)
CreatedBy
CreatedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
Customer
CIFNo(PK)
UnitId(FK)
Status
Name
Address
CROID(FK)
AANo
CreatedBy
CreatedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
FinancialInsLocation
PolicyId(FK)
FinanceLocId(PK)
Amount
BankId(FK)
CurrencyId(FK)
Location
CreatedBy
CreatedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
CRO
CROId(PK)
Name
ContactNo
Email
UnitId(FK)
CreatedBy
CreatedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
CustomerFacility
CustomerFacilityId(PK)
FacilityId(FK)
CurrencyId(FK)
Amount
CIF(FK)
CreatedBy
EditedBy
CreatedDateTime
EditedDateTime
DeletedBy
DeletedDateTime
AmountInsured
InsuranceAmountId(PK)
PolicyId(FK)
PolicyTypeId(FK)
Amount
CreatedBy
CreatedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
DocumentUpload
DocId(PK)
PolicyId(FK)
Name
Link
UploadedBy
UploadedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
Insurance Company
CompanyId(PK)
CompanyName
CreatedBy
CreatedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
PerilsCovered
PerilId(PK)
Name
Createdby
CreatedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
FinancialInstitutes
BankId(PK)
BankName
CreatedBy
CreatedDateTime
DeletedBy
DeletedDateTime
EditedBy
EditedDateTime
Currency
CurrencyId(PK)
CurrencyCode
CreatedBy
CreateDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
FacilityType
FacilityId(PK)
Name
CreatedBy
CreatedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
PolicyType
PolicyType
PolicyTypeId(PK)
CreatedBy
CreatedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime
UserRole
RoleId(PK)
RoleName
CreatedBy
CreatedDateTime
EditedBy
EditedDateTime
Deletedby
DeletedDateTime
EmailList
EmailId(PK)
Email
CreatedBy
CreatedDateTime
EditedBy
EditedDateTime
DeletedBy
DeletedDateTime