如有表c_serviceentity,c_circuit,c_portNameTypeNullableDefaultComments----------------------------------------------------------------------------IDNUMBER(19)SERVICETYPE_I...
如有表
c_serviceentity
,c_circuit
,c_port
Name Type Nullable Default Comments
----------------- ------------- -------- ------- -------------------------------
ID NUMBER(19)
SERVICETYPE_ID NUMBER(19) Y ????ID
SERVICE_ID NUMBER(19) Y ??ID
ABSTRACTENTITY_ID NUMBER(19) Y ????ID
ENTITY_ID NUMBER(19) Y ??ID
SEQUENCE NUMBER(10) Y ??
TYPE VARCHAR2(100) Y ??
ENTITYTYPE_ID NUMBER(19) Y ??????
STATUS NUMBER(18) Y ?????
1???
2????
3????
4???
ISDIRECT NUMBER(18) Y ???????
ISHISTORY NUMBER Y
ISCOPY NUMBER Y
当ABSTRACTENTITY_ID=108时与c_circuit 联立查询关联字段id
当ABSTRACTENTITY_ID=105时与c_port 联立查询关联字段id
展开