core28Example.sdl

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

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

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

#include "core28Example_structs.h"
#include "core28Example_cat.h"

and compile the following generated source file(s):

core28Example_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)
);
create table history (
tid integer not null,
bid integer not null,
aid integer not null,
delta double not null,
tim timestamp not null,
filler char(10)
);