CREATE TABLE PRIME_MERIDIAN
(

DESCRIPTION	CHAR VARYING (255)	,
EFFECTIVE_DATE	DATE	,
GREENWICH_LONG	FLOAT	NOT NULL,
GREENWICH_LONG_U	CHAR VARYING (15)	NOT NULL REFERENCES R_UOM (ACRONYM),
PRIME_MERIDIAN_ID	CHAR VARYING (40)	NOT NULL,
PRIME_MERIDIAN_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 PRIME_MERIDIAN ADD (CONSTRAINT UNIQUE (prime_meridian_id))