SBYN_CHILD_OBJECT (Understanding Sun Master Index Processing (Repository))

Understanding Sun Master Index Processing (Repository)

SBYN_`CHILD_OBJECT`

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, including any standardized or phonetic fields.

The differences in data types between Oracle and SQL Server are noted in Table 6. The Oracle type is on the first line, and the SQL Server type is on the second.

Table 6 SBYN_CHILD_OBJECT and SBYN_CHILD_OBJECTSBR Table Description


Column Name	Data Type	Column Description
`OBJECT_NAME`ID	VARCHAR2(20) Varchar(20)	The unique ID for the parent object associated with the child object in the system record.
`CHILD_OBJECT`ID	VARCHAR2(20) Varchar(20)	The unique ID for each record in the table. This column cannot be null.
`FIELD_NAME`	Varies	The name of each field in the child object. A database column is created for each field, and the data type depends on the type specified in the Object Definition file.