一、实现原理
在FTPC服务端(EJB)中有一个对象引用模块来验证对象是否被其他对象引用,通过该模块来校验被引用的对象能否进行删除、修改操作,从而保证数据的引用完整性。这样通过应用层实现引用完整性约束,可以不依赖于数据库通过外键实现引用完整性约束。
1、关于FTPC引用模块校验实现原理,主要是通过表结构中字段来统计是否存在引用的对象来判断。校验各个对象是否被引用,会查询各自相关的表中是否存在引用,基本引用关系如下:
Access Privilege:
Application:只会在List和Parameter中被引用
Area:AREA_AREA、SITE_AREA
Bill of Materials:WORK_ORDER_ITEMS、CONSUMPTION_PLAN
CarrierClass:
Data Collection Set:
Data Dictionary:
Equipment:EQUIPMENT_CLASS_EQUIP、WORK_CENTER_EQUIPMENT、WC_RS_EQUIP_REL
EquipmentClass:
Location:LOCATION
Part:PART_CLASS_PART、BOM_PART_LIST、PROCESS_BOM_ITEM
User Group:ACCESS_PRIVILEGE_GROUP、APPLICATION_ITEM
······
2、AT Row引用,引用关系表:APP_TABLE、APP_TABLE_COLUMN
3、Parameter引用,引用关系表为:PARAMETER。
4、List对象引用其他构建时对象,引用关系表为:DS_LIST、DS_LIST_ITEM。
二、引用对象详细关系
一旦存在子对象被父对象引用,则对子对象的删除、修改操作将被影响,但可以删除父对象,删除父对象的时候也将删除父对象与子对象的引用关系。
Parent Object | Child Object |
Access Privilege | User Group |
Application | All Process Designer objects |
Area | Area, Location, Production Line, Storage Zone, Work Instruction, Work Schedule |
Bill of Materials | Part, Work Instruction |
CarrierClass | Carrier |
Data Collection Set | Work Instruction |
Data Dictionary | Message |
Equipment | Location, Resource Route, Work Instruction, Work Schedule |
EquipmentClass | Equipment |
Location | Location |
Part | Bill of Materials, Account, CarrierClass, Work Instruction |
PartClass | Part |
Process Bill of Materials | Part, Work Instruction |
Production Line | Carrier, Location, Production Queue, Resource Route, Storage Unit, Work Center, Work Instruction, Work Schedule |
Production Queue | Location, Work Instruction |
Report Data Definition | Message |
Report Design | Report Data Definition |
Resource Condition | Data Collection Set, Form, Image, Work Instruction |
Resource Route | Form, Work Instruction |
Route | Form, Production Line, Route Operation, Work Instruction |
Route Operation | Checklist Definition, Data Collection Set, Form, Image, Work Instruction |
Site | Area, Location, Work Instruction, Work Schedule |
Station | Form, Location, Work Center, Work Instruction |
Storage Unit | Location and PartClass |
Storage Zone | Carrier, Location, Storage Unit |
Test Definition | List, Work Instruction |
User | Form, Shift |
User Group | Shift |
Work Center | Carrier, Equipment, Location, Resource Route, Storage Unit, Work Instruction, Work Schedule |