The sbyn_child_object tables (where child_object is the name of a child object in the object structure) store information about the child objects associated with a system record in the master index application. All tables storing child object information for system records contain the columns listed below. The remaining columns are defined by the fields you specify for each child object in the object structure definition file, including any standardized or phonetic fields.
The following table lists Oracle data types. For information about the differences in data types between database vendors, see Table 3.
Table 5 SBYN_CHILD_OBJECT and SBYN_CHILD_OBJECTSBR Table Description
Column Name |
Data Type |
Column Description |
---|---|---|
OBJECT_NAMEID |
VARCHAR2(20) |
The unique ID for the parent object associated with the child object in the system record. |
CHILD_OBJECTID |
VARCHAR2(20) |
The unique ID for each record in the table. This column cannot be null. |