core04.sdl

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

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

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

#include "core04_structs.h"
#include "core04_cat.h"

and compile the following generated source file(s):

core04_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 reference 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.
*/
create table artist
(
artistid rowid primary key,
name char(100) not null
);
create table album
(
albumid rowid primary key,
artistid rowid not null references artist(artistid),
title char(100) not null
);
create table track
(
albumid rowid not null references album(albumid),
title char(100) not null
);