Introduction - If you have any usage issues, please Google them yourself
CREATE DOMAIN CODE_EQUIP AS CHAR(12) NOT NULL
CREATE DOMAIN CODE_MID AS CHAR(5) NOT NULL
CREATE DOMAIN CODE_PASSWORD AS CHAR(20) NOT NULL
CREATE DOMAIN CODE_PERSON AS CHAR(6) NOT NULL
CREATE DOMAIN CODE_SHORT AS CHAR(1) NOT NULL
CREATE DOMAIN CODE_SYSTEM AS CHAR(3) NOT NULL
CREATE DOMAIN CODE_TYPE AS CHAR(2) NOT NULL
CREATE DOMAIN CODE_WORKPLACE AS CHAR(8) NOT NULL
CREATE DOMAIN TEXT_LONG AS VARCHAR(200)
CREATE DOMAIN TEXT_MID AS VARCHAR(50)
CREATE DOMAIN TEXT_SHORT AS VARCHAR(20)
/* Table: ODB_EQUIP_FAILURE, Owner: ERDBA*/
CREATE TABLE ODB_EQUIP_FAILURE (ID INTEGER NOT NULL,
EQUIP CODE_EQUIP,
FIND_DATE TIMESTAMP NOT NULL,
DESCRIP TEXT_LONG,
MODE CODE_MID DEFAULT 00000 ,
CAUSE CODE_MID DEFAULT 00000 ,
CONSEQUENCE CODE_MID DEFAULT 00000 ,
RESULT CODE_SHORT DEFAULT 0 ,
END_DATE TIMESTAMP,
LAST_MODIFY TIMESTAMP NOT NULL,
PERSON CODE_PERSON,
REMARK TEXT_LONG,