CREATE TABLE APP_CORD_TRFM
(

APP_CORD_TRFM_S	CHAR VARYING (19)	NOT NULL PRIMARY KEY,
COORDINATE_TRFM_ID	CHAR VARYING (40)	NOT NULL REFERENCES COORDINATE_TRFM (COORDINATE_TRFM_ID),
DESCRIPTION	CHAR VARYING (255)	,
EDGE_S	CHAR VARYING (19)	,
EDGE_T	CHAR VARYING (16)	,
FACE_S	CHAR VARYING (19)	,
FACE_T	CHAR VARYING (16)	,
SOURCE	CHAR VARYING (40)	NOT NULL REFERENCES R_SOURCE (R_SOURCE_NAME),
SOURCE_CORD_SYS	CHAR VARYING (40)	NOT NULL REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID),
SOURCE_REFERENCE_S	CHAR VARYING (19)	REFERENCES R_SOURCE_REF (R_SOURCE_REF_S),
STATUS	CHAR VARYING (11)	,
TARGET_CORD_SYS	CHAR VARYING (40)	NOT NULL REFERENCES COORDINATE_SYS (COORDINATE_SYS_ID),
VERSION	CHAR VARYING (40)	REFERENCES R_EPCNT_VERSION (NAME)

)
ALTER TABLE APP_CORD_TRFM ADD (CONSTRAINT UNIQUE (source_cord_sys, target_cord_sys, coordinate_trfm_id))