DB2Factory.com 
Demo Database DDL

Copyright© 2000 The Object Group, Inc. All rights reserved

CREATE TABLE DEMO_ROLODEX
(
E_MAIL_ID             CHARACTER(30) NOT NULL,
LAST_NAME             CHARACTER(30),
FIRST_NAME            CHARACTER(30),
MIDDLE_INITIAL        CHARACTER(01),
ADDR_LINE_1           CHARACTER(30),
ADDR_LINE_2           CHARACTER(30),
ST_CD                 CHARACTER(2) NOT NULL,
ZIP_CD                CHARACTER(9) NOT NULL,
VOICE_NUMBER          CHARACTER(20),
FAX_NUMBER            CHARACTER(20),
RX_CRET_ID            CHARACTER(15) NOT NULL,
RX_CRET_TMSTMP        TIMESTAMP NOT NULL WITH DEFAULT,
RX_RVSD_ID            CHARACTER(15) NOT NULL,
RX_RVSD_TMSTMP        TIMESTAMP NOT NULL WITH DEFAULT,
PRIMARY KEY (E_MAIL_ID))
;

CREATE TABLE DEMO_COUNTRY_CODES
( CO_CD               CHARACTER(3) NOT NULL,
CO_DESC               CHARACTER(30),
CO_CRET_ID            CHARACTER(15) NOT NULL,
CO_CRET_TMSTMP        TIMESTAMP NOT NULL WITH DEFAULT,
CO_RVSD_ID            CHARACTER(15) NOT NULL,
CO_RVSD_TMSTMP        TIMESTAMP NOT NULL WITH DEFAULT,
PRIMARY KEY (CO_CD)
)
;

CREATE TABLE DEMO_STATE_CODES
(
ST_CD                 CHARACTER(2) NOT NULL,
ST_DESC               CHARACTER(30) NOT NULL,
CO_CD                 CHARACTER(3) NOT NULL,
ST_CRET_ID            CHARACTER(15) NOT NULL,
ST_CRET_TMSTMP        TIMESTAMP NOT NULL WITH DEFAULT,
ST_RVSD_ID            CHARACTER(15) NOT NULL,
ST_RVSD_TMSTMP        TIMESTAMP NOT NULL WITH DEFAULT,
PRIMARY KEY (ST_CD)
)
;

ALTER TABLE DEMO_STATE_CODES
FOREIGN KEY A0000001
( CO_CD )
REFERENCES DEMO_COUNTRY_CODES
ON DELETE RESTRICT
;

ALTER TABLE DEMO_ROLODEX
FOREIGN KEY A0000002
( ST_CD )
REFERENCES DEMO_STATE_CODES
ON DELETE RESTRICT
;