CREATE TABLE R_OTHER_ERTH_PT
(

DESCRIPTION	CHAR VARYING (255)	,
R_OTHER_ERTH_PT_KD	CHAR VARYING (40)	NOT NULL,
R_OTHER_ERTH_PT_S	CHAR VARYING (19)	NOT NULL PRIMARY KEY,
SOURCE	CHAR VARYING (40)	NOT NULL REFERENCES R_SOURCE (R_SOURCE_NAME),
SOURCE_REFERENCE_S	CHAR VARYING (19)	REFERENCES R_SOURCE_REF (R_SOURCE_REF_S),
STATUS	CHAR VARYING (11)	,
VERSION	CHAR VARYING (40)	REFERENCES R_EPCNT_VERSION (NAME)

)
ALTER TABLE R_OTHER_ERTH_PT ADD (CONSTRAINT UNIQUE (r_other_erth_pt_kd))