What follows is an example record from the OpenVMS/MANMAN-OMAR / ORACLE CODASYL DBMS schema.
The record hiearchy for this example is as follows:
MA_PFAMCOD A product family code from MA_PFAMREC.
(0ne-Many) MA_PLINCOD A product line code from MA_PLINREC.
(0ne-Many) MA_PRODNO A Product Number from MA_PRODREC.
CREATE TABLE [dbo].[MA_PRODREC](
[ begins eNVy Control Columns ]
[PLANT_CODE] [smallint] NULL, A user defined field which uniquely
identifies the database with which this table is associated.
[NVTIMESTAMP] [datetime] NULL, The OpenVMS timestamp of the last Codasyl DBMS and
Rdb synchronization for this record.
[AREA] [smallint] NULL, Area portion of the Codasyl DBMS DBKEY.
[PAGE] [int] NULL, Page portion of the Codasyl DBMS DBKEY.
[LINE] [smallint] NULL, Line portion of the Codasyl DBMS DBKEY.
[end eNVy Control Columns]
[Begin eNVy Table ]
[MA_PFAMCOD] [char](6) , Link column to the MA_PFAMREC
[MA_PLINCOD] [char](6) , Link column to the MA_PLINREC
[MA_PRODNO] [char](18) , Link column to the MA_PRODREC
[MA_GLPT] [char](6) , Link column to the MA_GLPTREC
[MA_PRPT] [char](6) , Link column to the MA_PRPTREC
[MA_PRODPRPT] [char](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_PRODGLPT] [char](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_PRODDESC] [char](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_PRODUOM] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_PRODWGT] [float] NULL,
[MA_PRODWGTUOM] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_PRODVOL] [float] NULL,
[MA_PRODVOLUOM] [char](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_PRODLST] [float] NULL,
[MA_PRODFUTLST] [float] NULL,
[MA_PRODMCST] [float] NULL,
[MA_PRODLCST] [float] NULL,
[MA_PRODOCST] [float] NULL,
[MA_PRODVOCST] [float] NULL,
[MA_PRODINVFLG] [smallint] NULL,
[MA_PRODCSTFLG] [smallint] NULL,
[MA_PRODTXFLG] [smallint] NULL,
[MA_PRODCOMFLG] [smallint] NULL,
[MA_PRODSOFLG] [smallint] NULL,
[MA_PRODSHPFLG] [smallint] NULL,
[MA_PRODPAKFLG] [smallint] NULL,
[MA_PRODINCMFLG] [smallint] NULL,
[MA_PRODSERFLG] [smallint] NULL,
[MA_PRODACTDAT] [int] NULL,
[MA_PRODTXCOD] [char](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_PRODTXPRC] [float] NULL,
[MA_PRODHISFLG] [smallint] NULL,
[MA_PRODOPT] [smallint] NULL,
[MA_PRODBLANKS] [char](14) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_PRODSPNCOD] [char](6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_PRODCOMMOD] [char](8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MA_PRODSPUNITFLG] [int] NULL,
[MA_PRODSPUNITCNV] [float] NULL
[end eNVy Table]
) ON [PRIMARY]