ddl · 7 lines · sha256 705282e92ca4476fapp/app-transaction-type-db2/ddl/TRNTYCAT.ddl

1	CREATE TABLE CARDDEMO.TRANSACTION_TYPE_CATEGORY
2	( TRC_TYPE_CODE CHAR(2) NOT NULL,
3	TRC_TYPE_CATEGORY CHAR(4) NOT NULL,
4	TRC_CAT_DATA VARCHAR(50) NOT NULL,
5	PRIMARY KEY(TRC_TYPE_CODE,TRC_TYPE_CATEGORY),
6	FOREIGN KEY TRC_TYPE_CODE (TRC_TYPE_CODE)
7	REFERENCES CARDDEMO.TRANSACTION_TYPE (TR_TYPE) ON DELETE RESTRICT);