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