{"source":{"server":"glodc_schema"},"position":{"snapshot_pending_tx":"06000700022d4200:745615706510","snapshot_scn":"745676004823","snapshot":true,"scn":"745676004823","snapshot_completed":false},"databaseName":"GLODCP","schemaName":"LOOKUP","ddl":"\n  CREATE TABLE \"LOOKUP\".\"BRANCH_TEST_LIMITED\" \n   (\t\"BRANCH_ID_NO\" NUMBER(10,0) NOT NULL ENABLE, \n\t\"COMPANY_ID_NO\" NUMBER(2,0) NOT NULL ENABLE, \n\t\"COUNTRY_CODE\" VARCHAR2(3) NOT NULL ENABLE, \n\t\"TRANSPORT_HUB_CODE\" VARCHAR2(3), \n\t\"LOGISTIC_OPEN_DATE\" DATE NOT NULL ENABLE, \n\t\"LOGISTIC_CLOSE_DATE\" DATE, \n\t\"TRD_OPEN_DATE\" DATE NOT NULL ENABLE, \n\t\"TRD_CLOSE_DATE\" DATE, \n\t\"BRANCH_CODE\" VARCHAR2(7) NOT NULL ENABLE, \n\t\"TRANSPORT_DROP_CODE\" VARCHAR2(4), \n\t\"TRANSPORT_ROUTE_CODE\" VARCHAR2(4), \n\t\"BRANCH_EMAIL\" VARCHAR2(100), \n\t\"BRANCH_FAX\" VARCHAR2(30), \n\t\"BRANCH_MGR_CELLPHONE\" VARCHAR2(30), \n\t\"BRANCH_TELEPHONE\" VARCHAR2(30), \n\t\"BRANCH_MGR_NAME\" VARCHAR2(50), \n\t\"BRANCH_NAME\" VARCHAR2(50) NOT NULL ENABLE, \n\t\"IS_BLOCKED_IND\" CHAR(1) NOT NULL ENABLE, \n\t\"LAST_UPDATE_DATETIME\" DATE NOT NULL ENABLE, \n\t\"USERNAME\" VARCHAR2(15) NOT NULL ENABLE, \n\t CONSTRAINT \"PK_BRANCH_TEST_KEY\" PRIMARY KEY (\"BRANCH_ID_NO\") ENABLE, \n\t SUPPLEMENTAL LOG DATA (ALL) COLUMNS\n   ) ;","tableChanges":[{"type":"CREATE","id":"\"GLODCP\".\"LOOKUP\".\"BRANCH_TEST_LIMITED\"","table":{"defaultCharsetName":null,"primaryKeyColumnNames":["BRANCH_ID_NO"],"columns":[{"name":"BRANCH_ID_NO","jdbcType":2,"typeName":"NUMBER","typeExpression":"NUMBER","charsetName":null,"length":10,"scale":0,"position":1,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"COMPANY_ID_NO","jdbcType":2,"typeName":"NUMBER","typeExpression":"NUMBER","charsetName":null,"length":2,"scale":0,"position":2,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"COUNTRY_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":3,"position":3,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"TRANSPORT_HUB_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":3,"position":4,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"LOGISTIC_OPEN_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":5,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"LOGISTIC_CLOSE_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":6,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"TRD_OPEN_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":7,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"TRD_CLOSE_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":8,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":7,"position":9,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"TRANSPORT_DROP_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":4,"position":10,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"TRANSPORT_ROUTE_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":4,"position":11,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_EMAIL","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":100,"position":12,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_FAX","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":30,"position":13,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_MGR_CELLPHONE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":30,"position":14,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_TELEPHONE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":30,"position":15,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_MGR_NAME","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":50,"position":16,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_NAME","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":50,"position":17,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"IS_BLOCKED_IND","jdbcType":1,"typeName":"CHAR","typeExpression":"CHAR","charsetName":null,"length":1,"position":18,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"LAST_UPDATE_DATETIME","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":19,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"USERNAME","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":15,"position":20,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]}]},"comment":null}]}
{"source":{"server":"glodc_schema"},"position":{"snapshot_pending_tx":"06000700022d4200:745615706510","snapshot_scn":"745676004823","snapshot":true,"scn":"745676004823","snapshot_completed":false},"databaseName":"GLODCP","schemaName":"DEBEZIUM","ddl":"\n  CREATE TABLE \"DEBEZIUM\".\"DEBEZIUM_SIGNAL\" \n   (\t\"ID\" VARCHAR2(42), \n\t\"TYPE\" VARCHAR2(32) NOT NULL ENABLE, \n\t\"DATA\" VARCHAR2(2048), \n\t PRIMARY KEY (\"ID\") ENABLE, \n\t SUPPLEMENTAL LOG DATA (ALL) COLUMNS\n   ) ;","tableChanges":[{"type":"CREATE","id":"\"GLODCP\".\"DEBEZIUM\".\"DEBEZIUM_SIGNAL\"","table":{"defaultCharsetName":null,"primaryKeyColumnNames":["ID"],"columns":[{"name":"ID","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":42,"position":1,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"TYPE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":32,"position":2,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"DATA","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":2048,"position":3,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]}]},"comment":null}]}
{"source":{"server":"glodc_schema"},"position":{"commit_scn":"745676107829","transaction_id":null,"incremental_snapshot_maximum_key":"aced000570","snapshot_pending_tx":"06000700022d4200:745615706510","snapshot_scn":"745676004823","incremental_snapshot_collections":"GLODCP.DEBEZIUM.BRANCH_TEST_LIMITED_ONE","incremental_snapshot_primary_key":"aced000570","scn":"745676107828"},"databaseName":"dbname","schemaName":"DEBEZIUM","tableChanges":[{"type":"CREATE","id":"\"GLODCP\".\"DEBEZIUM\".\"BRANCH_TEST_LIMITED_ONE\"","table":{"defaultCharsetName":null,"primaryKeyColumnNames":[],"columns":[{"name":"BRANCH_ID_NO","jdbcType":2,"typeName":"NUMBER","typeExpression":"NUMBER","charsetName":null,"length":10,"scale":0,"position":1,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"COMPANY_ID_NO","jdbcType":2,"typeName":"NUMBER","typeExpression":"NUMBER","charsetName":null,"length":2,"scale":0,"position":2,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"COUNTRY_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":3,"position":3,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"TRANSPORT_HUB_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":3,"position":4,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"LOGISTIC_OPEN_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":5,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"LOGISTIC_CLOSE_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":6,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"TRD_OPEN_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":7,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"TRD_CLOSE_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":8,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":7,"position":9,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"TRANSPORT_DROP_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":4,"position":10,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"TRANSPORT_ROUTE_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":4,"position":11,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_EMAIL","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":100,"position":12,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_FAX","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":30,"position":13,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_MGR_CELLPHONE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":30,"position":14,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_TELEPHONE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":30,"position":15,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_MGR_NAME","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":50,"position":16,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_NAME","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":50,"position":17,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"IS_BLOCKED_IND","jdbcType":1,"typeName":"CHAR","typeExpression":"CHAR","charsetName":null,"length":1,"position":18,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"LAST_UPDATE_DATETIME","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":19,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"USERNAME","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":15,"position":20,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]}]},"comment":null}]}
{"source":{"server":"glodc_schema"},"position":{"commit_scn":"745676169531","transaction_id":null,"incremental_snapshot_maximum_key":"aced000570","snapshot_pending_tx":"06000700022d4200:745615706510","snapshot_scn":"745676004823","incremental_snapshot_collections":"GLODCP.LOOKUP.BRANCH_TEST_DUPLICATE","incremental_snapshot_primary_key":"aced000570","scn":"745676169530"},"databaseName":"dbname","schemaName":"LOOKUP","tableChanges":[{"type":"CREATE","id":"\"GLODCP\".\"LOOKUP\".\"BRANCH_TEST_DUPLICATE\"","table":{"defaultCharsetName":null,"primaryKeyColumnNames":["BRANCH_ID_NO"],"columns":[{"name":"BRANCH_ID_NO","jdbcType":2,"typeName":"NUMBER","typeExpression":"NUMBER","charsetName":null,"length":10,"scale":0,"position":1,"optional":false,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":false,"enumValues":[]},{"name":"COMPANY_ID_NO","jdbcType":2,"typeName":"NUMBER","typeExpression":"NUMBER","charsetName":null,"length":2,"scale":0,"position":2,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"COUNTRY_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":3,"position":3,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"TRANSPORT_HUB_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":3,"position":4,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"LOGISTIC_OPEN_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":5,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"LOGISTIC_CLOSE_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":6,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"TRD_OPEN_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":7,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"TRD_CLOSE_DATE","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":8,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":7,"position":9,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"TRANSPORT_DROP_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":4,"position":10,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"TRANSPORT_ROUTE_CODE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":4,"position":11,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_EMAIL","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":100,"position":12,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_FAX","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":30,"position":13,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_MGR_CELLPHONE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":30,"position":14,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_TELEPHONE","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":30,"position":15,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_MGR_NAME","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":50,"position":16,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"BRANCH_NAME","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":50,"position":17,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"IS_BLOCKED_IND","jdbcType":1,"typeName":"CHAR","typeExpression":"CHAR","charsetName":null,"length":1,"position":18,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"LAST_UPDATE_DATETIME","jdbcType":93,"typeName":"DATE","typeExpression":"DATE","charsetName":null,"position":19,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]},{"name":"USERNAME","jdbcType":12,"typeName":"VARCHAR2","typeExpression":"VARCHAR2","charsetName":null,"length":15,"position":20,"optional":true,"autoIncremented":false,"generated":false,"comment":null,"hasDefaultValue":true,"enumValues":[]}]},"comment":null}]}