| <* | |
| * Copyright 2001-2009 The Apache Software Foundation. | |
| * | |
| * Licensed under the Apache License, Version 2.0 (the "License"); | |
| * you may not use this file except in compliance with the License. | |
| * You may obtain a copy of the License at | |
| * | |
| * http://www.apache.org/licenses/LICENSE-2.0 | |
| * | |
| * Unless required by applicable law or agreed to in writing, software | |
| * distributed under the License is distributed on an "AS IS" BASIS, | |
| * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. | |
| * See the License for the specific language governing permissions and | |
| * limitations under the License. | |
| * | |
| */ | |
| create table j3_address ( | |
| id number(19,0) not null, | |
| sort_code varchar2(10 char), | |
| tmodel_key varchar2(255 char), | |
| use_type varchar2(255 char), | |
| address_id number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_address_line ( | |
| id number(19,0) not null, | |
| key_name varchar2(255 char), | |
| key_value varchar2(255 char), | |
| line varchar2(80 char) not null, | |
| address_id number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_auth_token ( | |
| auth_token varchar2(51 char) not null, | |
| authorized_name varchar2(255 char) not null, | |
| created timestamp not null, | |
| last_used timestamp not null, | |
| number_of_uses number(10,0) not null, | |
| token_state number(10,0) not null, | |
| primary key (auth_token) | |
| ); | |
| create table j3_binding_category_bag ( | |
| id number(19,0) not null, | |
| entity_key varchar2(255 char) not null, | |
| primary key (id), | |
| unique (entity_key) | |
| ); | |
| create table j3_binding_descr ( | |
| id number(19,0) not null, | |
| descr varchar2(1024 char) not null, | |
| lang_code varchar2(5 char), | |
| entity_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_binding_template ( | |
| access_point_type varchar2(255 char), | |
| access_point_url varchar2(4000 char), | |
| hosting_redirector varchar2(255 char), | |
| entity_key varchar2(255 char) not null, | |
| service_key varchar2(255 char) not null, | |
| primary key (entity_key) | |
| ); | |
| create table j3_business_category_bag ( | |
| id number(19,0) not null, | |
| entity_key varchar2(255 char) not null, | |
| primary key (id), | |
| unique (entity_key) | |
| ); | |
| create table j3_business_descr ( | |
| id number(19,0) not null, | |
| descr varchar2(1024 char) not null, | |
| lang_code varchar2(5 char), | |
| entity_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_business_entity ( | |
| entity_key varchar2(255 char) not null, | |
| primary key (entity_key) | |
| ); | |
| create table j3_business_identifier ( | |
| id number(19,0) not null, | |
| key_name varchar2(255 char), | |
| key_value varchar2(255 char) not null, | |
| tmodel_key_ref varchar2(255 char), | |
| entity_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_business_name ( | |
| id number(19,0) not null, | |
| lang_code varchar2(5 char), | |
| name varchar2(255 char) not null, | |
| entity_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_business_service ( | |
| entity_key varchar2(255 char) not null, | |
| business_key varchar2(255 char) not null, | |
| primary key (entity_key) | |
| ); | |
| create table j3_canonicalization_method ( | |
| id number(19,0) not null, | |
| algorithm varchar2(255 char), | |
| primary key (id) | |
| ); | |
| create table j3_category_bag ( | |
| id number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_clerk ( | |
| clerk_name varchar2(255 char) not null, | |
| cred varchar2(255 char), | |
| publisher_id varchar2(255 char) not null, | |
| node_name varchar2(255 char), | |
| primary key (clerk_name) | |
| ); | |
| create table j3_client_subscriptioninfo ( | |
| subscription_key varchar2(255 char) not null, | |
| last_notified timestamp, | |
| fromClerk_clerk_name varchar2(255 char), | |
| toClerk_clerk_name varchar2(255 char), | |
| primary key (subscription_key) | |
| ); | |
| create table j3_contact ( | |
| id number(19,0) not null, | |
| use_type varchar2(255 char), | |
| entity_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_contact_descr ( | |
| id number(19,0) not null, | |
| descr varchar2(1024 char) not null, | |
| lang_code varchar2(5 char), | |
| contact_id number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_discovery_url ( | |
| id number(19,0) not null, | |
| url varchar2(255 char) not null, | |
| use_type varchar2(255 char) not null, | |
| entity_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_email ( | |
| id number(19,0) not null, | |
| email_address varchar2(255 char) not null, | |
| use_type varchar2(255 char), | |
| contact_id number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_instance_details_descr ( | |
| id number(19,0) not null, | |
| descr varchar2(1024 char) not null, | |
| lang_code varchar2(5 char), | |
| tmodel_instance_info_id number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_instance_details_doc_descr ( | |
| id number(19,0) not null, | |
| descr varchar2(1024 char) not null, | |
| lang_code varchar2(5 char), | |
| tmodel_instance_info_id number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_key_data_value ( | |
| id number(19,0) not null, | |
| key_data_name varchar2(255 char), | |
| key_data_type varchar2(255 char), | |
| key_data_value blob, | |
| key_data_value_string clob, | |
| key_data_value_key number(19,0), | |
| key_info_key number(19,0), | |
| primary key (id) | |
| ); | |
| create table j3_key_info ( | |
| id number(19,0) not null, | |
| xml_id varchar2(255 char), | |
| primary key (id) | |
| ); | |
| create table j3_keyed_reference ( | |
| id number(19,0) not null, | |
| key_name varchar2(255 char), | |
| key_value varchar2(255 char) not null, | |
| tmodel_key_ref varchar2(255 char), | |
| category_bag_id number(19,0), | |
| keyed_reference_group_id number(19,0), | |
| primary key (id) | |
| ); | |
| create table j3_keyed_reference_group ( | |
| id number(19,0) not null, | |
| tmodel_key varchar2(255 char), | |
| category_bag_id number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_node ( | |
| name varchar2(255 char) not null, | |
| custody_transfer_url varchar2(255 char) not null, | |
| factory_initial varchar2(255 char), | |
| factory_naming_provider varchar2(255 char), | |
| factory_url_pkgs varchar2(255 char), | |
| inquiry_url varchar2(255 char) not null, | |
| juddi_api_url varchar2(255 char), | |
| manager_name varchar2(255 char) not null, | |
| proxy_transport varchar2(255 char) not null, | |
| publish_url varchar2(255 char) not null, | |
| security_url varchar2(255 char) not null, | |
| subscription_url varchar2(255 char) not null, | |
| primary key (name) | |
| ); | |
| create table j3_object_type ( | |
| id number(19,0) not null, | |
| encoding varchar2(255 char), | |
| mime_type varchar2(255 char), | |
| xml_id varchar2(255 char), | |
| signature_key number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_object_type_content ( | |
| id number(19,0) not null, | |
| content blob, | |
| object_type_key number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_overview_doc ( | |
| id number(19,0) not null, | |
| overview_url varchar2(255 char), | |
| overview_url_use_type varchar2(255 char), | |
| entity_key varchar2(255 char), | |
| tomodel_instance_info_id number(19,0), | |
| primary key (id) | |
| ); | |
| create table j3_overview_doc_descr ( | |
| id number(19,0) not null, | |
| descr varchar2(1024 char) not null, | |
| lang_code varchar2(5 char), | |
| overview_doc_id number(19,0), | |
| primary key (id) | |
| ); | |
| create table j3_person_name ( | |
| id number(19,0) not null, | |
| lang_code varchar2(5 char), | |
| name varchar2(255 char) not null, | |
| contact_id number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_phone ( | |
| id number(19,0) not null, | |
| phone_number varchar2(50 char) not null, | |
| use_type varchar2(255 char), | |
| contact_id number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_publisher ( | |
| authorized_name varchar2(255 char) not null, | |
| email_address varchar2(255 char), | |
| is_admin varchar2(5 char), | |
| is_enabled varchar2(5 char), | |
| max_bindings_per_service number(10,0), | |
| max_businesses number(10,0), | |
| max_services_per_business number(10,0), | |
| max_tmodels number(10,0), | |
| publisher_name varchar2(255 char) not null, | |
| primary key (authorized_name) | |
| ); | |
| create table j3_publisher_assertion ( | |
| from_key varchar2(255 char) not null, | |
| to_key varchar2(255 char) not null, | |
| from_check varchar2(5 char) not null, | |
| key_name varchar2(255 char) not null, | |
| key_value varchar2(255 char) not null, | |
| tmodel_key varchar2(255 char) not null, | |
| to_check varchar2(5 char) not null, | |
| primary key (from_key, to_key) | |
| ); | |
| create table j3_reference ( | |
| id number(19,0) not null, | |
| digest_method varchar2(255 char), | |
| digest_value blob, | |
| type varchar2(255 char), | |
| uri varchar2(255 char), | |
| xml_id varchar2(255 char), | |
| signed_info_key number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_service_category_bag ( | |
| id number(19,0) not null, | |
| entity_key varchar2(255 char) not null, | |
| primary key (id), | |
| unique (entity_key) | |
| ); | |
| create table j3_service_descr ( | |
| id number(19,0) not null, | |
| descr varchar2(1024 char) not null, | |
| lang_code varchar2(5 char), | |
| entity_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_service_name ( | |
| id number(19,0) not null, | |
| lang_code varchar2(5 char), | |
| name varchar2(255 char) not null, | |
| entity_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_service_projection ( | |
| business_key varchar2(255 char) not null, | |
| service_key varchar2(255 char) not null, | |
| primary key (business_key, service_key) | |
| ); | |
| create table j3_signature ( | |
| id number(19,0) not null, | |
| xml_id varchar2(255 char), | |
| binding_template_key varchar2(255 char), | |
| business_key varchar2(255 char), | |
| business_service_key varchar2(255 char), | |
| key_info number(19,0) not null, | |
| publisher_key varchar2(255 char), | |
| signature_value number(19,0) not null, | |
| signed_info number(19,0) not null, | |
| tmodel_key varchar2(255 char), | |
| primary key (id) | |
| ); | |
| create table j3_signature_method ( | |
| id number(19,0) not null, | |
| algorithm varchar2(255 char), | |
| primary key (id) | |
| ); | |
| create table j3_signature_transform ( | |
| id number(19,0) not null, | |
| transform varchar2(255 char), | |
| reference_key number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_signature_transform_data_value ( | |
| id number(19,0) not null, | |
| content_bytes blob, | |
| content_type varchar2(255 char), | |
| signature_transform_key number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_signature_value ( | |
| id number(19,0) not null, | |
| value_bytes blob, | |
| xml_id varchar2(255 char), | |
| primary key (id) | |
| ); | |
| create table j3_signed_info ( | |
| id number(19,0) not null, | |
| xml_id varchar2(255 char), | |
| canonicalization_method number(19,0) not null, | |
| signature_method number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_subscription ( | |
| subscription_key varchar2(255 char) not null, | |
| authorized_name varchar2(255 char) not null, | |
| binding_key varchar2(255 char), | |
| brief number(1,0), | |
| create_date timestamp not null, | |
| expires_after timestamp, | |
| last_notified timestamp, | |
| max_entities number(10,0), | |
| notification_interval varchar2(255 char), | |
| subscription_filter clob not null, | |
| primary key (subscription_key) | |
| ); | |
| create table j3_subscription_chunk_token ( | |
| chunk_token varchar2(255 char) not null, | |
| data number(10,0) not null, | |
| end_point timestamp, | |
| expires_after timestamp not null, | |
| start_point timestamp, | |
| subscription_key varchar2(255 char) not null, | |
| primary key (chunk_token) | |
| ); | |
| create table j3_subscription_match ( | |
| id number(19,0) not null, | |
| entity_key varchar2(255 char) not null, | |
| subscription_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_tmodel ( | |
| deleted number(1,0), | |
| lang_code varchar2(5 char), | |
| name varchar2(255 char) not null, | |
| entity_key varchar2(255 char) not null, | |
| primary key (entity_key) | |
| ); | |
| create table j3_tmodel_category_bag ( | |
| id number(19,0) not null, | |
| entity_key varchar2(255 char) not null, | |
| primary key (id), | |
| unique (entity_key) | |
| ); | |
| create table j3_tmodel_descr ( | |
| id number(19,0) not null, | |
| descr varchar2(1024 char) not null, | |
| lang_code varchar2(5 char), | |
| entity_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_tmodel_identifier ( | |
| id number(19,0) not null, | |
| key_name varchar2(255 char), | |
| key_value varchar2(255 char) not null, | |
| tmodel_key_ref varchar2(255 char), | |
| entity_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_tmodel_instance_info ( | |
| id number(19,0) not null, | |
| instance_parms varchar2(512 char), | |
| tmodel_key varchar2(255 char) not null, | |
| entity_key varchar2(255 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_tmodel_instance_info_descr ( | |
| id number(19,0) not null, | |
| descr varchar2(1024 char) not null, | |
| lang_code varchar2(5 char), | |
| tmodel_instance_info_id number(19,0) not null, | |
| primary key (id) | |
| ); | |
| create table j3_transfer_token ( | |
| transfer_token varchar2(51 char) not null, | |
| expiration_date timestamp not null, | |
| primary key (transfer_token) | |
| ); | |
| create table j3_transfer_token_keys ( | |
| id number(19,0) not null, | |
| entity_key varchar2(255 char), | |
| transfer_token varchar2(51 char) not null, | |
| primary key (id) | |
| ); | |
| create table j3_uddi_entity ( | |
| entity_key varchar2(255 char) not null, | |
| authorized_name varchar2(255 char) not null, | |
| created timestamp, | |
| modified timestamp not null, | |
| modified_including_children timestamp, | |
| node_id varchar2(255 char), | |
| primary key (entity_key) | |
| ); | |
| alter table j3_address | |
| add constraint FKF83236BE75D860FB | |
| foreign key (address_id) | |
| references j3_contact; | |
| alter table j3_address_line | |
| add constraint FKC665B8D5F8B8D8CF | |
| foreign key (address_id) | |
| references j3_address; | |
| alter table j3_binding_category_bag | |
| add constraint FKCF34B2376A68D45A | |
| foreign key (id) | |
| references j3_category_bag; | |
| alter table j3_binding_category_bag | |
| add constraint FKCF34B237CFBD88B7 | |
| foreign key (entity_key) | |
| references j3_binding_template; | |
| alter table j3_binding_descr | |
| add constraint FK5EA60911CFBD88B7 | |
| foreign key (entity_key) | |
| references j3_binding_template; | |
| alter table j3_binding_template | |
| add constraint FKD044BD6A2E448F3F | |
| foreign key (service_key) | |
| references j3_business_service; | |
| alter table j3_binding_template | |
| add constraint FKD044BD6AD1823CA5 | |
| foreign key (entity_key) | |
| references j3_uddi_entity; | |
| alter table j3_business_category_bag | |
| add constraint FKD6D3ECB06A68D45A | |
| foreign key (id) | |
| references j3_category_bag; | |
| alter table j3_business_category_bag | |
| add constraint FKD6D3ECB0BEB92A91 | |
| foreign key (entity_key) | |
| references j3_business_entity; | |
| alter table j3_business_descr | |
| add constraint FK3A24B4B8BEB92A91 | |
| foreign key (entity_key) | |
| references j3_business_entity; | |
| alter table j3_business_entity | |
| add constraint FKCA61A0CD1823CA5 | |
| foreign key (entity_key) | |
| references j3_uddi_entity; | |
| alter table j3_business_identifier | |
| add constraint FKB0C7A652BEB92A91 | |
| foreign key (entity_key) | |
| references j3_business_entity; | |
| alter table j3_business_name | |
| add constraint FK43F526F4BEB92A91 | |
| foreign key (entity_key) | |
| references j3_business_entity; | |
| alter table j3_business_service | |
| add constraint FK5D4255ACD1823CA5 | |
| foreign key (entity_key) | |
| references j3_uddi_entity; | |
| alter table j3_business_service | |
| add constraint FK5D4255ACEF04CFEE | |
| foreign key (business_key) | |
| references j3_business_entity; | |
| alter table j3_clerk | |
| add constraint FK34DC7D9F6BB0F935 | |
| foreign key (node_name) | |
| references j3_node; | |
| alter table j3_client_subscriptioninfo | |
| add constraint FKDF04CC095BFC6733 | |
| foreign key (fromClerk_clerk_name) | |
| references j3_clerk; | |
| alter table j3_client_subscriptioninfo | |
| add constraint FKDF04CC09F3CE9C04 | |
| foreign key (toClerk_clerk_name) | |
| references j3_clerk; | |
| alter table j3_contact | |
| add constraint FK7551BEEABEB92A91 | |
| foreign key (entity_key) | |
| references j3_business_entity; | |
| alter table j3_contact_descr | |
| add constraint FK56CA9E6C2E3FD94F | |
| foreign key (contact_id) | |
| references j3_contact; | |
| alter table j3_discovery_url | |
| add constraint FKA042FDAABEB92A91 | |
| foreign key (entity_key) | |
| references j3_business_entity; | |
| alter table j3_email | |
| add constraint FK34F910E62E3FD94F | |
| foreign key (contact_id) | |
| references j3_contact; | |
| alter table j3_instance_details_descr | |
| add constraint FK3CC165902B115C6F | |
| foreign key (tmodel_instance_info_id) | |
| references j3_tmodel_instance_info; | |
| alter table j3_instance_details_doc_descr | |
| add constraint FK447324492B115C6F | |
| foreign key (tmodel_instance_info_id) | |
| references j3_tmodel_instance_info; | |
| alter table j3_key_data_value | |
| add constraint FK74B7E072843143EF | |
| foreign key (key_data_value_key) | |
| references j3_key_data_value; | |
| alter table j3_key_data_value | |
| add constraint FK74B7E07238C90470 | |
| foreign key (key_info_key) | |
| references j3_key_info; | |
| alter table j3_keyed_reference | |
| add constraint FK350C8454E075C8D7 | |
| foreign key (keyed_reference_group_id) | |
| references j3_keyed_reference_group; | |
| alter table j3_keyed_reference | |
| add constraint FK350C84541DB72652 | |
| foreign key (category_bag_id) | |
| references j3_category_bag; | |
| alter table j3_keyed_reference_group | |
| add constraint FKF6224ED41DB72652 | |
| foreign key (category_bag_id) | |
| references j3_category_bag; | |
| alter table j3_object_type | |
| add constraint FK98BBFA04BC6AD65 | |
| foreign key (signature_key) | |
| references j3_signature; | |
| alter table j3_object_type_content | |
| add constraint FK987A913E71FA643E | |
| foreign key (object_type_key) | |
| references j3_object_type; | |
| alter table j3_overview_doc | |
| add constraint FK5CD8D0E8C5BF8903 | |
| foreign key (entity_key) | |
| references j3_tmodel; | |
| alter table j3_overview_doc | |
| add constraint FK5CD8D0E8E8CE1B36 | |
| foreign key (tomodel_instance_info_id) | |
| references j3_tmodel_instance_info; | |
| alter table j3_overview_doc_descr | |
| add constraint FK36FB9EA9BDC711C | |
| foreign key (overview_doc_id) | |
| references j3_overview_doc; | |
| alter table j3_person_name | |
| add constraint FKCB7B8AFF2E3FD94F | |
| foreign key (contact_id) | |
| references j3_contact; | |
| alter table j3_phone | |
| add constraint FK359202B82E3FD94F | |
| foreign key (contact_id) | |
| references j3_contact; | |
| alter table j3_publisher_assertion | |
| add constraint FK8A102449E3544929 | |
| foreign key (to_key) | |
| references j3_business_entity; | |
| alter table j3_publisher_assertion | |
| add constraint FK8A102449CCEE22D8 | |
| foreign key (from_key) | |
| references j3_business_entity; | |
| alter table j3_reference | |
| add constraint FK493A4F951E480746 | |
| foreign key (signed_info_key) | |
| references j3_signed_info; | |
| alter table j3_service_category_bag | |
| add constraint FK185A68076A68D45A | |
| foreign key (id) | |
| references j3_category_bag; | |
| alter table j3_service_category_bag | |
| add constraint FK185A680748D0656D | |
| foreign key (entity_key) | |
| references j3_business_service; | |
| alter table j3_service_descr | |
| add constraint FKB6D63D4148D0656D | |
| foreign key (entity_key) | |
| references j3_business_service; | |
| alter table j3_service_name | |
| add constraint FKCC1BE94B48D0656D | |
| foreign key (entity_key) | |
| references j3_business_service; | |
| alter table j3_service_projection | |
| add constraint FK629F290F2E448F3F | |
| foreign key (service_key) | |
| references j3_business_service; | |
| alter table j3_service_projection | |
| add constraint FK629F290FEF04CFEE | |
| foreign key (business_key) | |
| references j3_business_entity; | |
| alter table j3_signature | |
| add constraint FKC05CA90256E87DED | |
| foreign key (publisher_key) | |
| references j3_publisher; | |
| alter table j3_signature | |
| add constraint FKC05CA90271CD8948 | |
| foreign key (binding_template_key) | |
| references j3_binding_template; | |
| alter table j3_signature | |
| add constraint FKC05CA90212F40D40 | |
| foreign key (business_service_key) | |
| references j3_business_service; | |
| alter table j3_signature | |
| add constraint FKC05CA9028ACE9A26 | |
| foreign key (signed_info) | |
| references j3_signed_info; | |
| alter table j3_signature | |
| add constraint FKC05CA9027CE6418E | |
| foreign key (signature_value) | |
| references j3_signature_value; | |
| alter table j3_signature | |
| add constraint FKC05CA9025793CF55 | |
| foreign key (tmodel_key) | |
| references j3_tmodel; | |
| alter table j3_signature | |
| add constraint FKC05CA902DA6C2DD0 | |
| foreign key (key_info) | |
| references j3_key_info; | |
| alter table j3_signature | |
| add constraint FKC05CA902EF04CFEE | |
| foreign key (business_key) | |
| references j3_business_entity; | |
| alter table j3_signature_transform | |
| add constraint FK726346F9256790B | |
| foreign key (reference_key) | |
| references j3_reference; | |
| alter table j3_signature_transform_data_value | |
| add constraint FK3242526C7B88B2A4 | |
| foreign key (signature_transform_key) | |
| references j3_signature_transform; | |
| alter table j3_signed_info | |
| add constraint FKD2E7E5BB877110CC | |
| foreign key (canonicalization_method) | |
| references j3_canonicalization_method; | |
| alter table j3_signed_info | |
| add constraint FKD2E7E5BB1A25896 | |
| foreign key (signature_method) | |
| references j3_signature_method; | |
| alter table j3_subscription_match | |
| add constraint FK5B9C2F19BEEE42E5 | |
| foreign key (subscription_key) | |
| references j3_subscription; | |
| alter table j3_tmodel | |
| add constraint FK83C8072BD1823CA5 | |
| foreign key (entity_key) | |
| references j3_uddi_entity; | |
| alter table j3_tmodel_category_bag | |
| add constraint FK7E0859DB6A68D45A | |
| foreign key (id) | |
| references j3_category_bag; | |
| alter table j3_tmodel_category_bag | |
| add constraint FK7E0859DBC5BF8903 | |
| foreign key (entity_key) | |
| references j3_tmodel; | |
| alter table j3_tmodel_descr | |
| add constraint FK63DFF1EDC5BF8903 | |
| foreign key (entity_key) | |
| references j3_tmodel; | |
| alter table j3_tmodel_identifier | |
| add constraint FKD5FB623DC5BF8903 | |
| foreign key (entity_key) | |
| references j3_tmodel; | |
| alter table j3_tmodel_instance_info | |
| add constraint FKDC6C9004CFBD88B7 | |
| foreign key (entity_key) | |
| references j3_binding_template; | |
| alter table j3_tmodel_instance_info_descr | |
| add constraint FKD826B4062B115C6F | |
| foreign key (tmodel_instance_info_id) | |
| references j3_tmodel_instance_info; | |
| alter table j3_transfer_token_keys | |
| add constraint FK8BBF49185ED9DD48 | |
| foreign key (transfer_token) | |
| references j3_transfer_token; | |
| create sequence hibernate_sequence; | |
| create sequence juddi_sequence; |