CREATE TABLE "TEST"."ADDRESS" 
   (	
    "ADDR_ID" NUMBER(10,0), 
	"ADDR_CLIENT_ID" NUMBER(10,0), 
	"ADDR_ADDRESS_LINE_1" VARCHAR2(150 CHAR), 
	"ADDR_ADDRESS_LINE_2" VARCHAR2(50 CHAR), 
	"ADDR_SUBURB" VARCHAR2(50 CHAR), 
	"ADDR_CITY" VARCHAR2(50 CHAR), 
	"ADDR_COUNTRY_ID" NUMBER(10,0), 
	"ADDR_ADDRESS_TYPE_CODE_ID" NUMBER(10,0), 
	"ADDR_PREV_ADDRESS_TYPE_CODE_ID" NUMBER(10,0), 
	"ADDR_POST_CODE" VARCHAR2(10 CHAR), 
	"ADDR_IS_PRIMARY" CHAR(1 CHAR) DEFAULT 'N', 
	"ADDR_STATE_ID" NUMBER(10,0), 
	"ADDR_IS_PRIMARY_TYPE" CHAR(1 CHAR) DEFAULT 'N', 
	"ADDR_ADDRESS_LINE_3" VARCHAR2(50 CHAR), 
	"ADDR_ADDRESS_LINE_4" VARCHAR2(50 CHAR), 
	"ADDR_LAST_UPDATED" TIMESTAMP (6), 
	"ADDR_LAST_UPDATED_BY" VARCHAR2(30 CHAR), 
	"ADDR_TIMESTAMP" NUMBER(20,0) DEFAULT 0, 
	"ADDR_CARE_OF" VARCHAR2(250 CHAR), 
	"ADDR_DPID" VARCHAR2(8 CHAR), 
	"ADDR_BARCODE" VARCHAR2(67 CHAR), 
	"ADDR_RDBMS_TX_ID" NUMBER(30,0)
   )