ZSP_BR_BINDINGS
This table is to store the bindings of a rule.
Details
-
Schema: FUSION
-
Object owner: ZSP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
ZSP_BR_BINDINGS_PK |
BINDING_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
BINDING_ID | NUMBER | 18 | Yes | the primary key for a binding that is generated by middletier sequence generator | |
RULE_ID | NUMBER | 18 | Yes | the id of the rule that this binding is for | |
IN_LHS_FLAG | VARCHAR2 | 1 | Yes | 1 iff if the binding is in the left-hand side of the rule, otherwise 0 | |
REQUIRED_FLAG | VARCHAR2 | 1 | Yes | 1 iff if the binding is required for this the rule, otherwise 0 | |
VISIBLE_FLAG | VARCHAR2 | 1 | Yes | 1 iff if the binding is visible for this the rule, otherwise 0 | |
POSITION | NUMBER | 3 | Yes | the 0-based position relative to the parent binding | |
PARENT_BINDING_ID | NUMBER | 18 | the id of the parent binding, if any | ||
BINDING_TYPE_NAME | VARCHAR2 | 80 | Yes | one of 'Entity', 'Function', 'Attribute', 'Boolean', 'Byte', 'Short', 'Integer', 'Long', 'Float', 'Double', 'String', 'BigDecimal', 'Date', 'Time', or 'Timestamp' | |
QUANTIFICATION_NAME | VARCHAR2 | 80 | one of 'ForEach', 'Some', or 'None' if it is an entity binding | ||
ENTITY_GUID | VARCHAR2 | 32 | The Guid of the entity that corresponds to this binding if the type is 'Entity'. | ||
ENTITY_ID | NUMBER | 18 | the id of the entity that corresponds to this binding if the type is 'Entity' | ||
ATTRIBUTE_GUID | VARCHAR2 | 32 | The Guid of the attribute that corresponds to this binding if the type is 'Attribute'. | ||
ATTRIBUTE_ID | NUMBER | 18 | the id of the attribute that corresponds to this binding if the type is 'Attribute' | ||
REFERENCE_BINDING_ID | NUMBER | 18 | the id of the reference binding, if any. RHS attribute bindings can make reference to a function, another binding or a constant | ||
ACTION_ID | NUMBER | 18 | the id of the action that corresponds to this binding if the type is 'Action' | ||
ACTION_ARG_ID | NUMBER | 18 | the id of the action argument that corresponds to this binding if the type is 'ActionArgument' | ||
INVERT_FUNCTION_FLAG | VARCHAR2 | 1 | 1 iff if the function binding should be inverted. the flag is null only if the binding is not a function binding | ||
FUNCTION_ID | NUMBER | 18 | the id of the function that corresponds to this binding if the type is 'Function' | ||
FUNCTION_ARG_ID | NUMBER | 18 | the id of the function argument that corresponds to this binding if the type is 'function argument' | ||
BINDING_VALUE | VARCHAR2 | 255 | the constant value for a binding | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
ZSP_BR_BINDINGS | zsp_br_entities_b | ENTITY_ID |
ZSP_BR_BINDINGS | zsp_entities | ENTITY_GUID |
ZSP_BR_BINDINGS | zsp_attributes | ATTRIBUTE_GUID |
ZSP_BR_BINDINGS | zsp_br_rules_b | RULE_ID |
ZSP_BR_BINDINGS | zsp_br_functions_b | FUNCTION_ID |
ZSP_BR_BINDINGS | zsp_br_actions | ACTION_ID |
ZSP_BR_BINDINGS | zsp_br_action_args | ACTION_ARG_ID |
ZSP_BR_BINDINGS | zsp_br_bindings | PARENT_BINDING_ID |
ZSP_BR_BINDINGS | zsp_br_attributes_b | ATTRIBUTE_ID |
ZSP_BR_BINDINGS | zsp_br_bindings | REFERENCE_BINDING_ID |
ZSP_BR_BINDINGS | zsp_br_function_args | FUNCTION_ARG_ID |
zsp_br_bindings | zsp_br_bindings | PARENT_BINDING_ID |
zsp_br_bindings | zsp_br_bindings | REFERENCE_BINDING_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
ZSP_BR_BINDINGS_N1 | Non Unique | FUSION_TS_TX_IDX | ENTITY_ID | |
ZSP_BR_BINDINGS_N2 | Non Unique | FUSION_TS_TX_IDX | RULE_ID | Obsolete |
ZSP_BR_BINDINGS_N3 | Non Unique | FUSION_TS_TX_IDX | FUNCTION_ID | |
ZSP_BR_BINDINGS_N4 | Non Unique | FUSION_TS_TX_IDX | ACTION_ID | |
ZSP_BR_BINDINGS_N5 | Non Unique | FUSION_TS_TX_IDX | ACTION_ARG_ID | |
ZSP_BR_BINDINGS_N6 | Non Unique | FUSION_TS_TX_IDX | PARENT_BINDING_ID | |
ZSP_BR_BINDINGS_N7 | Non Unique | FUSION_TS_TX_IDX | ATTRIBUTE_ID | |
ZSP_BR_BINDINGS_N8 | Non Unique | FUSION_TS_TX_IDX | REFERENCE_BINDING_ID | |
ZSP_BR_BINDINGS_N9 | Non Unique | FUSION_TS_TX_IDX | FUNCTION_ARG_ID | |
ZSP_BR_BINDINGS_PK | Unique | FUSION_TS_TX_IDX | BINDING_ID | |
ZSP_BR_BINDINGS_U1 | Unique | FUSION_TS_TX_IDX | RULE_ID, PARENT_BINDING_ID, POSITION, IN_LHS_FLAG |