Business Rules: Capturing the Most Elusive Information Asset - High-Performance Web Databases: Design, Development, and Deployment - page 120

Exhibit 8-3. Data definition language for a business rule database.

BUSINESS DOCUMENT

CREATE TABLE BUS_DOC
(DOC_ID INTEGER NOT NULL,

DOC_DESC_NM CHARACTER(30) NOT NULL,

DOC_ISSUE_DT DATE NOT NULL WITH DEFAULT,

PRIMARY KEY(DOC_ID));
CREATE UNIQUE INDEX XPKBUS_DOC
ON BUS_DOC
(DOC_ID ASC);

BUSINESS RULE TYPE

CREATE TABLE BUS_RL_TYP
(BUS_RL_TYP_CD SMALLINT NOT NULL,

BUS_RL_TYP_DESC CHARACTER(18) NOT NULL,

PRIMARY KEY(BUS_RL_TYP_CD));
CREATE UNIQUE INDEX XPKBUS_RL_TYP
ON BUS_RL_TYP
(BUS_RL_TYP_CD ASC);

PERSON

CREATE TABLE PERSON
(PERSON_ID INTEGER NOT NULL,

PERSON_LAST_NM CHAR(18) NOT NULL,

PERSON_FIRST_NM CHAR(18) NOT NULL,

PERSON_PHONE_NBR CHAR(18) NOT NULL,

PRIMARY KEY(PERSON_ID));
CREATE UNIQUE INDEX XPKPERSON
ON PERSON
(PERSON_ID ASC);

BUSINESS RULE STATUS

CREATE TABLE BUS_RT STATUS
(BUS_RL_STATUS_CD

SMALLINT NOT NULL,

BUS_RL_STATUS_DESC CHAR(18) NOT NULL,

PRIMARY KEY (BUS_RL STATUS_CD));
CREATE UNIQUE INDEX XPKBUS_RL STATUS
ON BUS_RL_STATUS
(BUS_RL_STATUS_CD ASC);

BUSINESS GUARDIAN TYPE

CREATE TABLE GUARDIAN_TYP
(GUARDIAN_TYP_CD SMALLINT NOT NULL,

GUARDIAN_TYP_T CHAR(L 8) NOT NULL,

PRIMARY KEY(GUARDIAN_TYP_CD));
CREATE UNIQUE INDEX XPKGUARDIAN_TYP
ON GUARDIAN_TYP
(GUARDIAN_TYP_CD);