DROP TABLE IF EXISTS SNOMEDCORE(version);
CREATE TABLE SNOMEDCORE(version)
(
   SNOMED_CID         		VARCHAR(20) NOT NULL,
   SNOMED_FSN     		VARCHAR(500) NOT NULL,
   SNOMED_CONCEPT_STATUS        VARCHAR (30) NOT NULL,
   UMLS_CUI        		VARCHAR (10) NOT NULL,
   OCCURRENCE     		NUMBER,
   USAGE			NUMBER,
   FIRST_IN_SUBSET        	VARCHAR (20) NOT NULL,
   IS_RETIRED_FROM_SUBSET      	VARCHAR (10) NOT NULL,
   LAST_IN_SUBSET	     	VARCHAR (20),
   REPLACED_BY_SNOMED_CID     	VARCHAR (20)
   
  
)
;