Coflyr · backend model review

Independent backend tables

Applied to the local backend database · EntityRelations consolidation and zero foreign keys verified.

424registered model tables
993relationship rules
0foreign keys in all tables
1table in review
423tables awaiting review

EntityRelations defines the rules. EntityLinks manages the connections. Every table keeps its own records; existing lookup fields remain available for current screens and APIs.

Review one table at a time: TimeRequirements.
Its 63 reviewed fields and nine row roles are preserved. This review checks relationship ownership and meaning. Other tables remain pending.

Open TimeRequirements field decisions · Full field catalog

All backend model tables

Inspect any table below. The active review remains TimeRequirements until its review is completed through the backend.

TableStatusFieldsOutgoing linksIncoming links

Custom relationship rules

These 21 rules share the same EntityRelations table. Their existing graph connections and entity names are preserved.

Show custom rules (21)
RuleSourceTargetCardinality
Parent of
BusinessPartnerHierarchy		BusinessPartnerBusinessPartnerOneToMany
Related business partner
BusinessPartnerToBusinessPartner		BusinessPartnerBusinessPartnerManyToMany
Has capability
BusinessPartnerToCapability		BusinessPartners.BusinessPartnersBusinessPartners.BusinessPartnerCapabilitiesOneToMany
Has address
BusinessPartnerToContactAddress		BusinessPartners.BusinessPartnersBusinessPartners.ContactAddressesOneToMany
Parent of
ContactAddressHierarchy		ContactAddressContactAddressOneToMany
Child action type
DefectActionTypeParent		Administration.DefectReferenceValuesAdministration.DefectReferenceValuesOneToMany
Has ATA chapter
PartToAta		Parts.PartMasterAdministration.AtaManyToOne
Has commodity code
PartToCommodityCode		Parts.PartMasterMasterData.CommodityCodeManyToOne
Priced in
PartToCurrency		Parts.PartMasterMasterData.CurrenciesManyToOne
Has customs end use
PartToCustomsEndUse		Parts.PartMasterMasterData.CustomsEndUsesManyToOne
Has customs unit
PartToCustomsMeasurementUnit		Parts.PartMasterMasterData.MeasureUnitsOneToMany
Has UN number
PartToDangerousGoodsUnNumber		Parts.PartMasterDangerousGoods.DangerousGoodsReferencesManyToOne
Has external unit
PartToExternalMeasurementUnit		Parts.PartMasterMasterData.MeasureUnitsOneToMany
Has fixed asset code
PartToFixedAssetType		Parts.PartMasterMasterData.FATypeManyToOne
Has hazard class
PartToHazardClass		Parts.PartMasterDangerousGoods.DangerousGoodsReferencesManyToOne
Has internal unit
PartToInternalMeasurementUnit		Parts.PartMasterMasterData.MeasureUnitsOneToMany
Has manufacturer
PartToManufacturerBusinessPartner		Parts.PartMasterBusinessPartners.BusinessPartnersManyToMany
Has material type
PartToMaterialType		Parts.PartMasterMasterData.MaterialTypeOneToMany
Measured in
PartToMeasurementUnit		Parts.PartMasterMasterData.MeasureUnitsOneToMany
Has packing group
PartToPackingGroup		Parts.PartMasterDangerousGoods.DangerousGoodsReferencesManyToOne
Revision of
PartToRevisionOf		Parts.PartMasterParts.PartMasterManyToOne