core06.sdl

Schema for the core06Example_main.c example. Compile this schema using rdm-compile as follows:

rdm-compile --c-structs --lc-struct-members --catalog core06.sdl

and include the generated header file(s) as follows:

#include "core06_structs.h"
#include "core06_cat.h"

and compile the following generated source file(s):

core06_cat.c

Here follows the actual schema:

/*
 * EXAMPLE - Core04 for C 
 *
 * This is the DDL (Database Definition Language) for a database implementing
 * two one-to-many relationship using network model sets.  The database will 
 * implement the beginnings of an mp3 collection.  The one (owner) side
 * of the relationship is an artist records.  The many (member) side of the 
 * relationship is the album record.  There will be a second set where the one
 * side is the album record and the many side is a track record.
 
 * The artist name and album title will be index so they can be retrieved in
 * sorted order.  The index will also allow an application to preform an
 * efficient search on those fields.
 */
 
create table artist
(
    artistid rowid primary key,
    name char(100) key not null
);
 
create table album
(
    albumid rowid primary key,
    artistid rowid references artist(artistid),
    title char(100) key not null
);
 
create table track
(
    albumid rowid references album(albumid),
    title char(100) not null
);