CREATE TABLE BLOCK (
	ID	NUMBER	PRIMARY KEY,
	NAME	VARCHAR(64),
	URL	VARCHAR(1024),
	DATA	LONG,
	STORAGE_METHOD	CHAR(4),
	DTD	VARCHAR(64)
);
CREATE TABLE POSTAL1 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	CITY1_E	VARCHAR(128),
	CODE2_E	VARCHAR(128),
	COUNTRY1_E	VARCHAR(128),
	REGION1_E	VARCHAR(128),
	STREET1_E	VARCHAR(128)
);
CREATE TABLE FOREIGN_REN_EXP_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE SECTION2F_LIMIT_STATEMENT (
	ID NUMBER PRIMARY KEY,
	BLOCK NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E VARCHAR(128)
);
CREATE TABLE MARK_DESCRIPTION (
	ID NUMBER PRIMARY KEY,
	BLOCK NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E VARCHAR(128)
);
CREATE TABLE DISCLAIMER (
	ID NUMBER PRIMARY KEY,
	BLOCK NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E VARCHAR(128)
);
CREATE TABLE PUB_OPPOSITION_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE SERIAL_NUMBER1 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	FILING_DATE1_A	VARCHAR(128),
	SERIES_CODE_A	VARCHAR(128)
);
CREATE TABLE FOREIGN_REGISTRATION_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE FIRST_USE_COMMERCE_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE PSEUDO_MARK (
	ID NUMBER PRIMARY KEY,
	BLOCK NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E VARCHAR(128)
);
CREATE TABLE TTAX_DATA_GROUP (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	ENTRY_NUMBER_A	VARCHAR(128),
	TEXT_TYPE_A	VARCHAR(128)
);
CREATE TABLE FOREIGN_FILING_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RECORD_PRUS (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	AND_OTHERS_E	VARCHAR(128)
);
CREATE TABLE GOODS_SERVICES_TEXT (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	PRIME_CLASS_A	VARCHAR(128)
);
CREATE TABLE TRANSACTION_DATE1 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RENEWAL_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE CLASS_STATUS_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RECORD_GENV (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER
);
CREATE TABLE DEED_EFFECTIVE_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE KEY_ACTION (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CODE_A	VARCHAR(128)
);
CREATE TABLE RECORD_PROP (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER
);
CREATE TABLE PARTY_NAME (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	FIRST_NAME_A	VARCHAR(128),
	LAST_NAME_A	VARCHAR(128),
	MIDDLE_NAME_A	VARCHAR(128)
);
CREATE TABLE CONCURRENT_USE_STATEMENT (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE PUB_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE ENTRY_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE TTAB_STATUS (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CODE_A	VARCHAR(128)
);
CREATE TABLE BRIEF_CODE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CODE_A	VARCHAR(128)
);
CREATE TABLE RECORD_TTAX (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER
);
CREATE TABLE FOREIGN_EXPIRATION_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE LINING_STIPPLING_STATEMENT (
	ID NUMBER PRIMARY KEY,
	BLOCK NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E VARCHAR(128)
);
CREATE TABLE MARK_TRANSLATION (
	ID NUMBER PRIMARY KEY,
	BLOCK NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E VARCHAR(128)
);
CREATE TABLE PARTY_TYPE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	OWNER_CODE_A	VARCHAR(128)
);
CREATE TABLE ASGN_NAME (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	FIRST_NAME_A	VARCHAR(128),
	LAST_NAME_A	VARCHAR(128),
	MIDDLE_NAME_A	VARCHAR(128)
);
CREATE TABLE PROCEEDING_NUMBER (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	PROCEEDING_TYPE_A	VARCHAR(128)
);
CREATE TABLE PRIME_CLASS1 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CLASS_CODE_A	VARCHAR(128),
	CLASS_TYPE_A	VARCHAR(128)
);
CREATE TABLE NAME_DESCRIPTION (
	ID NUMBER PRIMARY KEY,
	BLOCK NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E VARCHAR(128)
);
CREATE TABLE US_CLASS (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CLASS_CODE_A	VARCHAR(128)
);
CREATE TABLE FILING_DATE2 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RECORD_OWNX (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	ATTORNEY_NAME_E	VARCHAR(128),
	DOMESTIC_REPRESENTATIVE_E	VARCHAR(128)
);
CREATE TABLE CANCELLATION_CODE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CODE_A	VARCHAR(128)
);
CREATE TABLE FOREIGN_COUNTRY_CODE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CODE_A	VARCHAR(128)
);
CREATE TABLE SIGNED_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE NAME (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	FIRST_NAME_A	VARCHAR(128),
	LAST_NAME_A	VARCHAR(128),
	MIDDLE_NAME_A	VARCHAR(128)
);
CREATE TABLE RECORD_PART (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	COMPOSED_OF_STATEMENT_E	VARCHAR(128),
	DBA_AKA_STATEMENT_E	VARCHAR(128),
	NAME_I	NUMBER REFERENCES NAME(ID),
	POSTAL1_I	NUMBER REFERENCES POSTAL1(ID)
);
CREATE TABLE MARK_DRAWING_CODE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	ILLUSTRATION_SPACE_A	VARCHAR(128),
	PHYSICAL_APPEARANCE_A	VARCHAR(128),
	SIZING_CODE_A	VARCHAR(128)
);
CREATE TABLE ENTITY_TYPE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CODE_A	VARCHAR(128)
);
CREATE TABLE REGISTRATION_DATE1 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE STATUS_CODE1 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CODE_A	VARCHAR(128)
);
CREATE TABLE APNR_DATA_GROUP (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	ENTRY_NUMBER_A	VARCHAR(128),
	FILING_DATE1_A	VARCHAR(128),
	REG_NUM_A	VARCHAR(128),
	SERIAL_NUMBER_A	VARCHAR(128)
);
CREATE TABLE ASGN_TYPE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	TYPE_A	VARCHAR(128)
);
CREATE TABLE CORRESPONDENCE_ADDRESS (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	NAME_I	NUMBER REFERENCES NAME(ID),
	POSTAL1_I	NUMBER REFERENCES POSTAL1(ID)
);
CREATE TABLE RECORD_PARC (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	ENTRY_NUMBER_A	VARCHAR(128),
	CORRESPONDENCE_ADDRESS_I	NUMBER REFERENCES CORRESPONDENCE_ADDRESS(ID)
);
CREATE TABLE DUE_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE APPH_DATA_GROUP (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	ENTRY_CODE_A	VARCHAR(128),
	ENTRY_NUMBER_A	VARCHAR(128),
	ENTRY_TYPE_A	VARCHAR(128),
	DUE_DATE_I	NUMBER REFERENCES DUE_DATE(ID),
	ENTRY_DATE_I	NUMBER REFERENCES ENTRY_DATE(ID)
);
CREATE TABLE FOREIGN_RENEWAL_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RECORD_FRGN (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	FLAG_FOREI_PRIOR_CLAIM_E	VARCHAR(128),
	FOREIGN_APP_NUMBER_E	VARCHAR(128),
	FOREIGN_COUNTRY_CODE_I	NUMBER REFERENCES FOREIGN_COUNTRY_CODE(ID),
	FOREIGN_EXPIRATION_DATE_I	NUMBER REFERENCES FOREIGN_EXPIRATION_DATE(ID),
	FOREIGN_FILING_DATE_I	NUMBER REFERENCES FOREIGN_FILING_DATE(ID),
	FOREIGN_REG_NUMBER_E	VARCHAR(128),
	FOREIGN_REGISTRATION_DATE_I	NUMBER REFERENCES FOREIGN_REGISTRATION_DATE(ID),
	FOREIGN_REN_EXP_DATE_I	NUMBER REFERENCES FOREIGN_REN_EXP_DATE(ID),
	FOREIGN_REN_NUMBER_E	VARCHAR(128),
	FOREIGN_RENEWAL_DATE_I	NUMBER REFERENCES FOREIGN_RENEWAL_DATE(ID)
);
CREATE TABLE IN_ANOTHER_FORM_STATEMENT (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	PRIME_CLASS_A	VARCHAR(128)
);
CREATE TABLE RECORDED_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RECORD_DEED (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	BRIEF_CODE_I	NUMBER REFERENCES BRIEF_CODE(ID),
	CORRESPONDENCE_ADDRESS_I	NUMBER REFERENCES CORRESPONDENCE_ADDRESS(ID),
	FRAME_NUMBER_E	VARCHAR(128),
	NUMBER_PAGES_E	VARCHAR(128),
	RECORDED_DATE_I	NUMBER REFERENCES RECORDED_DATE(ID),
	REEL_NUMBER_E	VARCHAR(128)
);
CREATE TABLE MARK_TYPE_CODE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CERTIFICATION_MARK_A	VARCHAR(128),
	COLLECTIVE_MEM_MARK_A	VARCHAR(128),
	COLLECTIVE_SERVICE_MARK_A	VARCHAR(128),
	COLLECTIVE_TRADEMARK_A	VARCHAR(128),
	SERVICE_MARK_A	VARCHAR(128),
	TRADEMARK_A	VARCHAR(128)
);
CREATE TABLE UNDEFINED_APPLICATION (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE ACKNOWLEDGED_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RECORD_ASGN (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	ACKNOWLEDGED_DATE_I	NUMBER REFERENCES ACKNOWLEDGED_DATE(ID),
	ASGN_NAME_I	NUMBER REFERENCES ASGN_NAME(ID),
	ASGN_TYPE_I	NUMBER REFERENCES ASGN_TYPE(ID),
	CITIZENSHIP_E	VARCHAR(128),
	COMPOSED_OF_STATEMENT_E	VARCHAR(128),
	DBA_AKA_STATEMENT_E	VARCHAR(128),
	ENTITY_STATEMENT_E	VARCHAR(128),
	ENTITY_TYPE_I	NUMBER REFERENCES ENTITY_TYPE(ID),
	POSTAL1_I	NUMBER REFERENCES POSTAL1(ID),
	SIGNED_DATE_I	NUMBER REFERENCES SIGNED_DATE(ID)
);
CREATE TABLE TRADEMARK_PROPS (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	TYPE_A	VARCHAR(128)
);
CREATE TABLE SUBMISSION_FRONT1 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	KEY_ACTION_I	NUMBER REFERENCES KEY_ACTION(ID),
	TRANSACTION_DATE1_I	NUMBER REFERENCES TRANSACTION_DATE1(ID)
);
CREATE TABLE ASSIGNMENT_DATA (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	RECORD_DEED_I	NUMBER REFERENCES RECORD_DEED(ID)
);
CREATE TABLE RECORD_OWNR (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	CITIZENSHIP_E	VARCHAR(128),
	COMPOSED_OF_STATEMENT_E	VARCHAR(128),
	CORRESPONDENCE_ADDRESS_I	NUMBER REFERENCES CORRESPONDENCE_ADDRESS(ID),
	DBA_AKA_STATEMENT_E	VARCHAR(128),
	ENTITY_STATEMENT_E	VARCHAR(128),
	ENTITY_TYPE_I	NUMBER REFERENCES ENTITY_TYPE(ID),
	NAME_CHANGE_TEXT_E	VARCHAR(128),
	PARTY_NAME_I	NUMBER REFERENCES PARTY_NAME(ID),
	PARTY_TYPE_I	NUMBER REFERENCES PARTY_TYPE(ID),
	POSTAL1_I	NUMBER REFERENCES POSTAL1(ID)
);
CREATE TABLE REMOTE_PROPS1 (
	ID NUMBER PRIMARY KEY,
	BLOCK NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E VARCHAR(128)
);
CREATE TABLE RECORD_APNR (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER
);
CREATE TABLE LAW_OFFICE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CODE_A	VARCHAR(128)
);
CREATE TABLE CANCELLATION_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE STATUS_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RECORD_TTAB (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	FILING_DATE2_I	NUMBER REFERENCES FILING_DATE2(ID),
	PROCEEDING_NUMBER_I	NUMBER REFERENCES PROCEEDING_NUMBER(ID),
	STATUS_DATE_I	NUMBER REFERENCES STATUS_DATE(ID),
	TTAB_STATUS_I	NUMBER REFERENCES TTAB_STATUS(ID)
);
CREATE TABLE ADV_PROCEEDING_DATA (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	RECORD_TTAB_I	NUMBER REFERENCES RECORD_TTAB(ID)
);
CREATE TABLE REGISTRATION_AMENDMENT (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE PRIOR_GROUP (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	RECORD_TYPE_A	VARCHAR(128),
	REL_NUM_A	VARCHAR(128)
);
CREATE TABLE DESIGN_SEARCH_CODE (
	ID NUMBER PRIMARY KEY,
	BLOCK NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E VARCHAR(128)
);
CREATE TABLE MARK_CERTIFICATION_STATEMENT (
	ID NUMBER PRIMARY KEY,
	BLOCK NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E VARCHAR(128)
);
CREATE TABLE CLASS_STATUS (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	STATUS_CODE_A	VARCHAR(128)
);
CREATE TABLE RECORD_DSGN (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER
);
CREATE TABLE CERTIFICATE_CORRECTION (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RECORD_DEEX (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	BRIEF_TEXT_E	VARCHAR(128),
	DEED_EFFECTIVE_DATE_I	NUMBER REFERENCES DEED_EFFECTIVE_DATE(ID),
	JURISDICTION_E	VARCHAR(128)
);
CREATE TABLE PROP_DATA_GROUP (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	FILING_DATE1_A	VARCHAR(128),
	REG_NUM_A	VARCHAR(128),
	SERIAL_NUMBER_A	VARCHAR(128)
);
CREATE TABLE AMEND_REGISTER_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RECORD_GENX (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	ACTUAL_MARK_E	VARCHAR(128),
	AMEND_REGISTER_DATE_I	NUMBER REFERENCES AMEND_REGISTER_DATE(ID),
	ATTORNEY_DOCKET_NUMBER_E	VARCHAR(128),
	CANCELLATION_CODE_I	NUMBER REFERENCES CANCELLATION_CODE(ID),
	CANCELLATION_DATE_I	NUMBER REFERENCES CANCELLATION_DATE(ID),
	FILING_DATE2_I	NUMBER REFERENCES FILING_DATE2(ID),
	FLAG_AMEND_PRINC_REGIS_E	VARCHAR(128),
	FLAG_AMEND_SUPP_REGISTER_E	VARCHAR(128),
	FLAG_CANCEL_PENDING_E	VARCHAR(128),
	FLAG_CHANGE_REGISTRATION_E	VARCHAR(128),
	FLAG_CONCURRENT_USE_E	VARCHAR(128),
	FLAG_CONCURRENT_USE_PROC_E	VARCHAR(128),
	FLAG_FOREI_PRIOR_CLAIM_E	VARCHAR(128),
	FLAG_INTENT_TO_USE_E	VARCHAR(128),
	FLAG_INTENT_TO_USE_CURRENT_E	VARCHAR(128),
	FLAG_INTERFERENCE_PENDING_E	VARCHAR(128),
	FLAG_OPPOSITION_PENDING_E	VARCHAR(128),
	FLAG_PUB_CONCURRENT_E	VARCHAR(128),
	FLAG_RENEWAL_FILED_E	VARCHAR(128),
	FLAG_REPUB_SECTION_12C_E	VARCHAR(128),
	FLAG_SECTION_15_ACK_E	VARCHAR(128),
	FLAG_SECTION_15_FILED_E	VARCHAR(128),
	FLAG_SECTION_2F_E	VARCHAR(128),
	FLAG_SECTION_2F_PART_E	VARCHAR(128),
	FLAG_SECTION_8_ACCEPT_E	VARCHAR(128),
	FLAG_SECTION_8_FILED_E	VARCHAR(128),
	FLAG_SECTI_8_PARTI_ACCEP_E	VARCHAR(128),
	FLAG_SUPP_REGISTER_E	VARCHAR(128),
	LAW_OFFICE_I	NUMBER REFERENCES LAW_OFFICE(ID),
	MARK_DRAWING_CODE_I	NUMBER REFERENCES MARK_DRAWING_CODE(ID),
	MARK_TYPE_CODE_I	NUMBER REFERENCES MARK_TYPE_CODE(ID),
	PUB_DATE_I	NUMBER REFERENCES PUB_DATE(ID),
	PUB_OPPOSITION_DATE_I	NUMBER REFERENCES PUB_OPPOSITION_DATE(ID),
	REGISTRATION_DATE1_I	NUMBER REFERENCES REGISTRATION_DATE1(ID),
	REGISTRATION_NUMBER_E	VARCHAR(128),
	RENEWAL_DATE_I	NUMBER REFERENCES RENEWAL_DATE(ID),
	SERIAL_NUMBER1_I	NUMBER REFERENCES SERIAL_NUMBER1(ID),
	STATUS_CODE1_I	NUMBER REFERENCES STATUS_CODE1(ID),
	STATUS_DATE_I	NUMBER REFERENCES STATUS_DATE(ID)
);
CREATE TABLE MARK_DATA (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	RECORD_GENX_I	NUMBER REFERENCES RECORD_GENX(ID)
);
CREATE TABLE SUBMISSION_DOCUMENT1 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	ADV_PROCEEDING_DATA_I	NUMBER REFERENCES ADV_PROCEEDING_DATA(ID),
	ASSIGNMENT_DATA_I	NUMBER REFERENCES ASSIGNMENT_DATA(ID),
	MARK_DATA_I	NUMBER REFERENCES MARK_DATA(ID)
);
CREATE TABLE DOC_SUBMISSION1 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	SUBMISSION_DOCUMENT1_I	NUMBER REFERENCES SUBMISSION_DOCUMENT1(ID),
	SUBMISSION_FRONT1_I	NUMBER REFERENCES SUBMISSION_FRONT1(ID)
);
CREATE TABLE DOC_PROPS1 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DOC_SUBMISSION1_I	NUMBER REFERENCES DOC_SUBMISSION1(ID)
);
CREATE TABLE TRADEMARK1 (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	NAME1_A	VARCHAR(128),
	SERIAL1_A	VARCHAR(128),
	DOC_PROPS1_I	NUMBER REFERENCES DOC_PROPS1(ID),
	TRADEMARK_PROPS_I	NUMBER REFERENCES TRADEMARK_PROPS(ID)
);
CREATE TABLE INTERNATIONAL_CLASS (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	CLASS_CODE_A	VARCHAR(128)
);
CREATE TABLE RESTRICT_CLAIM_REGISTRATION (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RECORD_APPH (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER
);
CREATE TABLE FIRST_USE_DATE (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	DATA_E	VARCHAR(128),
	DAY_A	VARCHAR(128),
	MONTH_A	VARCHAR(128),
	YEAR_A	VARCHAR(128)
);
CREATE TABLE RECORD_CLAS (
	ID	NUMBER PRIMARY KEY,
	BLOCK	NUMBER REFERENCES BLOCK(ID),
	PARENT	NUMBER,
	CLASS_STATUS_I	NUMBER REFERENCES CLASS_STATUS(ID),
	CLASS_STATUS_DATE_I	NUMBER REFERENCES CLASS_STATUS_DATE(ID),
	FIRST_USE_COMMERCE_DATE_I	NUMBER REFERENCES FIRST_USE_COMMERCE_DATE(ID),
	FIRST_USE_DATE_I	NUMBER REFERENCES FIRST_USE_DATE(ID),
	PRIME_CLASS1_I	NUMBER REFERENCES PRIME_CLASS1(ID)
);
CREATE TABLE ADV_PROCE_DATA_RECOR_APNR_JO (
	ADV_PROCEEDING_DATA_I	NUMBER REFERENCES ADV_PROCEEDING_DATA(ID),
	RECORD_APNR_I	NUMBER REFERENCES RECORD_APNR(ID)
);
CREATE TABLE ADV_PROCE_DATA_RECOR_APPH_JO (
	ADV_PROCEEDING_DATA_I	NUMBER REFERENCES ADV_PROCEEDING_DATA(ID),
	RECORD_APPH_I	NUMBER REFERENCES RECORD_APPH(ID)
);
CREATE TABLE ADV_PROCE_DATA_RECOR_PARC_JO (
	ADV_PROCEEDING_DATA_I	NUMBER REFERENCES ADV_PROCEEDING_DATA(ID),
	RECORD_PARC_I	NUMBER REFERENCES RECORD_PARC(ID)
);
CREATE TABLE ADV_PROCE_DATA_RECOR_PART_JO (
	ADV_PROCEEDING_DATA_I	NUMBER REFERENCES ADV_PROCEEDING_DATA(ID),
	RECORD_PART_I	NUMBER REFERENCES RECORD_PART(ID)
);
CREATE TABLE ADV_PROCE_DATA_RECOR_TTAX_JO (
	ADV_PROCEEDING_DATA_I	NUMBER REFERENCES ADV_PROCEEDING_DATA(ID),
	RECORD_TTAX_I	NUMBER REFERENCES RECORD_TTAX(ID)
);
CREATE TABLE ASSIG_DATA_RECOR_ASGN_JOIN (
	ASSIGNMENT_DATA_I	NUMBER REFERENCES ASSIGNMENT_DATA(ID),
	RECORD_ASGN_I	NUMBER REFERENCES RECORD_ASGN(ID)
);
CREATE TABLE ASSIG_DATA_RECOR_DEEX_JOIN (
	ASSIGNMENT_DATA_I	NUMBER REFERENCES ASSIGNMENT_DATA(ID),
	RECORD_DEEX_I	NUMBER REFERENCES RECORD_DEEX(ID)
);
CREATE TABLE ASSIG_DATA_RECOR_PROP_JOIN (
	ASSIGNMENT_DATA_I	NUMBER REFERENCES ASSIGNMENT_DATA(ID),
	RECORD_PROP_I	NUMBER REFERENCES RECORD_PROP(ID)
);
CREATE TABLE MARK_DATA_RECORD_CLAS_JOIN (
	MARK_DATA_I	NUMBER REFERENCES MARK_DATA(ID),
	RECORD_CLAS_I	NUMBER REFERENCES RECORD_CLAS(ID)
);
CREATE TABLE MARK_DATA_RECORD_DSGN_JOIN (
	MARK_DATA_I	NUMBER REFERENCES MARK_DATA(ID),
	RECORD_DSGN_I	NUMBER REFERENCES RECORD_DSGN(ID)
);
CREATE TABLE MARK_DATA_RECORD_FRGN_JOIN (
	MARK_DATA_I	NUMBER REFERENCES MARK_DATA(ID),
	RECORD_FRGN_I	NUMBER REFERENCES RECORD_FRGN(ID)
);
CREATE TABLE MARK_DATA_RECORD_GENV_JOIN (
	MARK_DATA_I	NUMBER REFERENCES MARK_DATA(ID),
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID)
);
CREATE TABLE MARK_DATA_RECORD_OWNR_JOIN (
	MARK_DATA_I	NUMBER REFERENCES MARK_DATA(ID),
	RECORD_OWNR_I	NUMBER REFERENCES RECORD_OWNR(ID)
);
CREATE TABLE MARK_DATA_RECORD_OWNX_JOIN (
	MARK_DATA_I	NUMBER REFERENCES MARK_DATA(ID),
	RECORD_OWNX_I	NUMBER REFERENCES RECORD_OWNX(ID)
);
CREATE TABLE MARK_DATA_RECORD_PRUS_JOIN (
	MARK_DATA_I	NUMBER REFERENCES MARK_DATA(ID),
	RECORD_PRUS_I	NUMBER REFERENCES RECORD_PRUS(ID)
);
CREATE TABLE RECOR_APNR_APNR_DATA_GROUP_J (
	RECORD_APNR_I	NUMBER REFERENCES RECORD_APNR(ID),
	APNR_DATA_GROUP_I	NUMBER REFERENCES APNR_DATA_GROUP(ID)
);
CREATE TABLE RECOR_APPH_APPH_DATA_GROUP_J (
	RECORD_APPH_I	NUMBER REFERENCES RECORD_APPH(ID),
	APPH_DATA_GROUP_I	NUMBER REFERENCES APPH_DATA_GROUP(ID)
);
CREATE TABLE RECOR_CLAS_INTER_CLASS_JOIN (
	RECORD_CLAS_I	NUMBER REFERENCES RECORD_CLAS(ID),
	INTERNATIONAL_CLASS_I	NUMBER REFERENCES INTERNATIONAL_CLASS(ID)
);
CREATE TABLE RECORD_CLAS_US_CLASS_JOIN (
	RECORD_CLAS_I	NUMBER REFERENCES RECORD_CLAS(ID),
	US_CLASS_I	NUMBER REFERENCES US_CLASS(ID)
);
CREATE TABLE RECOR_DSGN_DESIG_SEARC_CODE (
	RECORD_DSGN_I	NUMBER REFERENCES RECORD_DSGN(ID),
	DESIGN_SEARCH_CODE_I	NUMBER REFERENCES DESIGN_SEARCH_CODE(ID)
);
CREATE TABLE RECOR_GENV_CERTI_CORRE_JOIN (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	CERTIFICATE_CORRECTION_I	NUMBER REFERENCES CERTIFICATE_CORRECTION(ID)
);
CREATE TABLE RECOR_GENV_CONCU_USE_STATE_J (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	CONCURRENT_USE_STATEMENT_I	NUMBER REFERENCES CONCURRENT_USE_STATEMENT(ID)
);
CREATE TABLE RECORD_GENV_DISCLAIMER_JOIN (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	DISCLAIMER_I	NUMBER REFERENCES DISCLAIMER(ID)
);
CREATE TABLE RECOR_GENV_GOODS_SERVI_TEXT (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	GOODS_SERVICES_TEXT_I	NUMBER REFERENCES GOODS_SERVICES_TEXT(ID)
);
CREATE TABLE RECOR_GENV_IN_ANOTH_FORM_STA (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	IN_ANOTHER_FORM_STATEMENT_I	NUMBER REFERENCES IN_ANOTHER_FORM_STATEMENT(ID)
);
CREATE TABLE RECOR_GENV_LININ_STIPP_STATE (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	LINING_STIPPLING_STATEMENT_I	NUMBER REFERENCES LINING_STIPPLING_STATEMENT(ID)
);
CREATE TABLE RECOR_GENV_MARK_CERTI_STATE (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	MARK_CERTIFICATION_STATEMENT_I	NUMBER REFERENCES MARK_CERTIFICATION_STATEMENT(ID)
);
CREATE TABLE RECOR_GENV_MARK_DESCR_JOIN (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	MARK_DESCRIPTION_I	NUMBER REFERENCES MARK_DESCRIPTION(ID)
);
CREATE TABLE RECOR_GENV_MARK_TRANS_JOIN (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	MARK_TRANSLATION_I	NUMBER REFERENCES MARK_TRANSLATION(ID)
);
CREATE TABLE RECOR_GENV_NAME_DESCR_JOIN (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	NAME_DESCRIPTION_I	NUMBER REFERENCES NAME_DESCRIPTION(ID)
);
CREATE TABLE RECORD_GENV_PSEUDO_MARK_JOIN (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	PSEUDO_MARK_I	NUMBER REFERENCES PSEUDO_MARK(ID)
);
CREATE TABLE RECOR_GENV_REGIS_AMEND_JOIN (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	REGISTRATION_AMENDMENT_I	NUMBER REFERENCES REGISTRATION_AMENDMENT(ID)
);
CREATE TABLE RECOR_GENV_RESTR_CLAIM_REGIS (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	RESTRICT_CLAIM_REGISTRATION_I	NUMBER REFERENCES RESTRICT_CLAIM_REGISTRATION(ID)
);
CREATE TABLE RECOR_GENV_SECTI_LIMIT_STATE (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	SECTION2F_LIMIT_STATEMENT_I	NUMBER REFERENCES SECTION2F_LIMIT_STATEMENT(ID)
);
CREATE TABLE RECOR_GENV_UNDEF_APPLI_JOIN (
	RECORD_GENV_I	NUMBER REFERENCES RECORD_GENV(ID),
	UNDEFINED_APPLICATION_I	NUMBER REFERENCES UNDEFINED_APPLICATION(ID)
);
CREATE TABLE RECOR_PROP_PROP_DATA_GROUP_J (
	RECORD_PROP_I	NUMBER REFERENCES RECORD_PROP(ID),
	PROP_DATA_GROUP_I	NUMBER REFERENCES PROP_DATA_GROUP(ID)
);
CREATE TABLE RECORD_PRUS_PRIOR_GROUP_JOIN (
	RECORD_PRUS_I	NUMBER REFERENCES RECORD_PRUS(ID),
	PRIOR_GROUP_I	NUMBER REFERENCES PRIOR_GROUP(ID)
);
CREATE TABLE RECOR_TTAX_TTAX_DATA_GROUP_J (
	RECORD_TTAX_I	NUMBER REFERENCES RECORD_TTAX(ID),
	TTAX_DATA_GROUP_I	NUMBER REFERENCES TTAX_DATA_GROUP(ID)
);
CREATE TABLE TRADE_REMOT_PROPS_JOIN (
	TRADEMARK1_I	NUMBER REFERENCES TRADEMARK1(ID),
	REMOTE_PROPS1_I	NUMBER REFERENCES REMOTE_PROPS1(ID)
);