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):


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