text: /*L
    Copyright Duke Comprehensive Cancer Center
  
    Distributed under the OSI-approved BSD 3-Clause License.
    See http://ncip.github.com/catrip/LICENSE.txt for details.
  L*/
  
  --  ------------------------------------------- 
  --  Generated by Enterprise Architect Ver. 4.01
  --  Created On : Thursday, 07 September, 2006 
  --  DBMS       : Oracle 
  --  ------------------------------------------- 
  
  DROP TABLE ADDRESS CASCADE CONSTRAINTS;
  
  CREATE TABLE ADDRESS ( 
  	ID NUMBER(8) NOT NULL,
  	ADDRESS_1 VARCHAR2(255),
  	ADDRESS_2 VARCHAR2(255),
  	ZIPCODE VARCHAR2(20),
  	CITY VARCHAR2(100),
  	STATE VARCHAR2(50),
  	COUNTY VARCHAR2(50),
  	COUNTRY VARCHAR2(50)
  ) 
  ;
  
  ALTER TABLE ADDRESS ADD CONSTRAINT PK_ADDRESS 
  PRIMARY KEY (ID) ;