Tutorial File Layout
The Tutorial uses the following four data files and six indices:
Data File
|
Symbolic Index Name
|
Key Segment(s)
|
Unique
|
custmast.dat
|
cm_custnumb_idx
|
cm_custnumb
|
yes
|
itemmast.dat
|
im_itemnumb_idx
|
im_itemnumb
|
yes
|
custordr.dat
|
co_ordrnumb_idx
|
co_ordrnumb
|
yes
|
custordr.dat
|
co_custnumb_idx
|
co_custnumb
|
no
|
ordritem.dat
|
oi_ordrnumb_idx
|
oi_ordrnumb, oi_seqnumb
|
yes
|
ordritem.dat
|
oi_itemnumb_idx
|
oi_itemnumb
|
no
|
Note: The unique column indicates if the index accepts duplicate data values.
custmast.dat, the Customer Master File, contains the table CUSTOMERS made up of the fields shown below:
Symbolic Name
|
Field Description
|
Field Type
|
Field Length
|
cm_custnumb
|
Customer number
|
CT_STRING
|
5
|
cm_custzipc
|
Customer zip code
|
CT_STRING
|
10
|
cm_custstat
|
Customer state
|
CT_STRING
|
3
|
cm_custratg
|
Customer rating
|
CT_STRING
|
2
|
cm_custname
|
Customer name
|
CT_STRING
|
48
|
cm_custadrs
|
Customer address
|
CT_STRING
|
48
|
cm_custcity
|
Customer city
|
CT_STRING
|
48
|
itemmast.dat, the Item Master File, contains the table ITEMS made up of the fields shown below:
Symbolic Name
|
Field Description
|
Field Type
|
Field Length
|
im_itemwght
|
Item weight
|
CT_INT4
|
4
|
im_itempric
|
Item price
|
CT_MONEY
|
4
|
im_itemnumb
|
Item number
|
CT_STRING
|
6
|
im_itemdesc
|
Item description
|
CT_STRING
|
48
|
custordr.dat, the Customer Order File, contains the table ORDERS made up of the fields shown below:
Symbolic Name
|
Field Description
|
Field Type
|
Field Length
|
_o_delflag
|
Order delete flag
|
CT_INT4
|
4
|
co_ordrdate
|
Order date
|
CT_DATE
|
4
|
co_promdate
|
Order promise date
|
CT_DATE
|
4
|
co_ordrnumb
|
Order number
|
CT_STRING
|
7
|
co_custnumb
|
Customer number
|
CT_STRING
|
5
|
ordritem.dat, the Order Item File, contains the table ORDER_DETAIL made up of the fields shown below:
Symbolic Name
|
Field Description
|
Field Type
|
Field Length
|
_i_delflag
|
Order item delete flag
|
CT_INT2
|
2
|
oi_seqnumb
|
Order item stock number
|
CT_INT2
|
2
|
oi_quantity
|
Order item quantity
|
CT_INT2
|
2
|
oi_ordrnumb
|
Order item number
|
CT_STRING
|
7
|
oi_itemnumb
|
Item number
|
CT_STRING
|
6
|
Note: The fields beginning with “_”, _o_delflag and _i_delflag, are hidden fields and will not be displayed. Developers looking for more information on other field options should refer to Section 1.5 Field Options in c-tree Driver Developer’s Guide.
|
