RGens/src/main/sql/db_schema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

create table Rules (
	ruleid serial,
	name varchar(255) not null,
	casecount int,
	primary key(id)
);

create index Rules_name on Rules(name);

create table RuleCases (
	ruleid serial,
	cse varchar(255) array
);

create index RuleCase_id on RuleCases(ruleid);