core29Example.sdl

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

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

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

#include "core29Example_structs.h"
#include "core29Example_cat.h"

and compile the following generated source file(s):

core29Example_cat.c

Here follows the actual schema:

create table branches (
 bid integer not null,
 bbalance double not null,
 filler char(92),
 
 constraint branches_pk primary key (bid)
);
 
create table tellers (
 tid integer not null,
 bid integer not null,
 tbalance double not null,
 filler char(84),


 constraint tellers_pk primary key (tid),
 constraint tellers_fk foreign key (bid) references branches (bid)
);
 
create table accounts (
 aid integer not null,
 bid integer not null,
 abalance double not null,
 filler char(88),
 
 constraint accounts_pk primary key (aid),
 constraint accounts_fk foreign key (bid) references branches (bid)
);