CREATE TABLE GENERAL_ESRF_PT
(

DESCRIPTION	CHAR VARYING (255)	,
EMODEL_OBJECT_ID	CHAR VARYING (40)	,
GENERAL_ESRF_PT_S	CHAR VARYING (19)	NOT NULL PRIMARY KEY,
GEOLOGIC_FTR_S	CHAR VARYING (19)	,
GEOLOGIC_FTR_T	CHAR VARYING (16)	,
GEOSCIENCE_NTRP_S	CHAR VARYING (19)	REFERENCES GEOSCIENCE_NTRP (GEOSCIENCE_NTRP_S),
ROCK_FTR_PART_S	CHAR VARYING (19)	,
ROCK_FTR_PART_T	CHAR VARYING (16)	,
R_OTHER_ERTH_PT_KD	CHAR VARYING (40)	NOT NULL REFERENCES R_OTHER_ERTH_PT (R_OTHER_ERTH_PT_KD)

)