create table j3_address ( | |
id numeric(19,0) identity not null, | |
sort_code varchar(10) null, | |
tmodel_key varchar(255) null, | |
use_type varchar(255) null, | |
address_id numeric(19,0) not null, | |
primary key (id) | |
); | |
create table j3_address_line ( | |
id numeric(19,0) identity not null, | |
key_name varchar(255) null, | |
key_value varchar(255) null, | |
line varchar(80) not null, | |
address_id numeric(19,0) not null, | |
primary key (id) | |
); | |
create table j3_auth_token ( | |
auth_token varchar(51) not null, | |
authorized_name varchar(255) not null, | |
created datetime not null, | |
last_used datetime not null, | |
number_of_uses int not null, | |
token_state int not null, | |
primary key (auth_token) | |
); | |
create table j3_binding_category_bag ( | |
id numeric(19,0) not null, | |
entity_key varchar(255) not null, | |
primary key (id), | |
unique (entity_key) | |
); | |
create table j3_binding_descr ( | |
id numeric(19,0) identity not null, | |
descr varchar(1024) not null, | |
lang_code varchar(5) null, | |
entity_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_binding_template ( | |
access_point_type varchar(255) null, | |
access_point_url varchar(4000) null, | |
hosting_redirector varchar(255) null, | |
entity_key varchar(255) not null, | |
service_key varchar(255) not null, | |
primary key (entity_key) | |
); | |
create table j3_business_category_bag ( | |
id numeric(19,0) not null, | |
entity_key varchar(255) not null, | |
primary key (id), | |
unique (entity_key) | |
); | |
create table j3_business_descr ( | |
id numeric(19,0) identity not null, | |
descr varchar(1024) not null, | |
lang_code varchar(5) null, | |
entity_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_business_entity ( | |
entity_key varchar(255) not null, | |
primary key (entity_key) | |
); | |
create table j3_business_identifier ( | |
id numeric(19,0) identity not null, | |
key_name varchar(255) null, | |
key_value varchar(255) not null, | |
tmodel_key_ref varchar(255) null, | |
entity_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_business_name ( | |
id numeric(19,0) identity not null, | |
lang_code varchar(5) null, | |
name varchar(255) not null, | |
entity_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_business_service ( | |
entity_key varchar(255) not null, | |
business_key varchar(255) not null, | |
primary key (entity_key) | |
); | |
create table j3_category_bag ( | |
id numeric(19,0) identity not null, | |
primary key (id) | |
); | |
create table j3_clerk ( | |
clerk_name varchar(255) not null, | |
cred varchar(255) null, | |
publisher_id varchar(255) not null, | |
node_name varchar(255) null, | |
primary key (clerk_name) | |
); | |
create table j3_client_subscriptioninfo ( | |
subscription_key varchar(255) not null, | |
last_notified datetime null, | |
fromClerk_clerk_name varchar(255) null, | |
toClerk_clerk_name varchar(255) null, | |
primary key (subscription_key) | |
); | |
create table j3_contact ( | |
id numeric(19,0) identity not null, | |
use_type varchar(255) null, | |
entity_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_contact_descr ( | |
id numeric(19,0) identity not null, | |
descr varchar(1024) not null, | |
lang_code varchar(5) null, | |
contact_id numeric(19,0) not null, | |
primary key (id) | |
); | |
create table j3_discovery_url ( | |
id numeric(19,0) identity not null, | |
url varchar(255) not null, | |
use_type varchar(255) not null, | |
entity_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_email ( | |
id numeric(19,0) identity not null, | |
email_address varchar(255) not null, | |
use_type varchar(255) null, | |
contact_id numeric(19,0) not null, | |
primary key (id) | |
); | |
create table j3_instance_details_descr ( | |
id numeric(19,0) identity not null, | |
descr varchar(1024) not null, | |
lang_code varchar(5) null, | |
tmodel_instance_info_id numeric(19,0) not null, | |
primary key (id) | |
); | |
create table j3_instance_details_doc_descr ( | |
id numeric(19,0) identity not null, | |
descr varchar(1024) not null, | |
lang_code varchar(5) null, | |
tmodel_instance_info_id numeric(19,0) not null, | |
primary key (id) | |
); | |
create table j3_keyed_reference ( | |
id numeric(19,0) identity not null, | |
key_name varchar(255) null, | |
key_value varchar(255) not null, | |
tmodel_key_ref varchar(255) null, | |
category_bag_id numeric(19,0) null, | |
keyed_reference_group_id numeric(19,0) null, | |
primary key (id) | |
); | |
create table j3_keyed_reference_group ( | |
id numeric(19,0) identity not null, | |
tmodel_key varchar(255) null, | |
category_bag_id numeric(19,0) not null, | |
primary key (id) | |
); | |
create table j3_node ( | |
name varchar(255) not null, | |
custody_transfer_url varchar(255) not null, | |
factory_initial varchar(255) null, | |
factory_naming_provider varchar(255) null, | |
factory_url_pkgs varchar(255) null, | |
inquiry_url varchar(255) not null, | |
juddi_api_url varchar(255) null, | |
manager_name varchar(255) not null, | |
proxy_transport varchar(255) not null, | |
publish_url varchar(255) not null, | |
security_url varchar(255) not null, | |
subscription_url varchar(255) not null, | |
primary key (name) | |
); | |
create table j3_overview_doc ( | |
id numeric(19,0) identity not null, | |
overview_url varchar(255) null, | |
overview_url_use_type varchar(255) null, | |
entity_key varchar(255) null, | |
tomodel_instance_info_id numeric(19,0) null, | |
primary key (id) | |
); | |
create table j3_overview_doc_descr ( | |
id numeric(19,0) identity not null, | |
descr varchar(1024) not null, | |
lang_code varchar(5) null, | |
overview_doc_id numeric(19,0) null, | |
primary key (id) | |
); | |
create table j3_person_name ( | |
id numeric(19,0) identity not null, | |
lang_code varchar(5) null, | |
name varchar(255) not null, | |
contact_id numeric(19,0) not null, | |
primary key (id) | |
); | |
create table j3_phone ( | |
id numeric(19,0) identity not null, | |
phone_number varchar(50) not null, | |
use_type varchar(255) null, | |
contact_id numeric(19,0) not null, | |
primary key (id) | |
); | |
create table j3_publisher ( | |
authorized_name varchar(255) not null, | |
email_address varchar(255) null, | |
is_admin varchar(5) null, | |
is_enabled varchar(5) null, | |
max_bindings_per_service int null, | |
max_businesses int null, | |
max_services_per_business int null, | |
max_tmodels int null, | |
publisher_name varchar(255) not null, | |
primary key (authorized_name) | |
); | |
create table j3_publisher_assertion ( | |
from_key varchar(255) not null, | |
to_key varchar(255) not null, | |
from_check varchar(5) not null, | |
key_name varchar(255) not null, | |
key_value varchar(255) not null, | |
tmodel_key varchar(255) not null, | |
to_check varchar(5) not null, | |
primary key (from_key, to_key) | |
); | |
create table j3_service_category_bag ( | |
id numeric(19,0) not null, | |
entity_key varchar(255) not null, | |
primary key (id), | |
unique (entity_key) | |
); | |
create table j3_service_descr ( | |
id numeric(19,0) identity not null, | |
descr varchar(1024) not null, | |
lang_code varchar(5) null, | |
entity_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_service_name ( | |
id numeric(19,0) identity not null, | |
lang_code varchar(5) null, | |
name varchar(255) not null, | |
entity_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_service_projection ( | |
business_key varchar(255) not null, | |
service_key varchar(255) not null, | |
primary key (business_key, service_key) | |
); | |
create table j3_subscription ( | |
subscription_key varchar(255) not null, | |
authorized_name varchar(255) not null, | |
binding_key varchar(255) null, | |
brief tinyint null, | |
create_date datetime not null, | |
expires_after datetime null, | |
last_notified datetime null, | |
max_entities int null, | |
notification_interval varchar(255) null, | |
subscription_filter text not null, | |
primary key (subscription_key) | |
); | |
create table j3_subscription_chunk_token ( | |
chunk_token varchar(255) not null, | |
data int not null, | |
end_point datetime null, | |
expires_after datetime not null, | |
start_point datetime null, | |
subscription_key varchar(255) not null, | |
primary key (chunk_token) | |
); | |
create table j3_subscription_match ( | |
id numeric(19,0) identity not null, | |
entity_key varchar(255) not null, | |
subscription_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_tmodel ( | |
deleted tinyint null, | |
lang_code varchar(5) null, | |
name varchar(255) not null, | |
entity_key varchar(255) not null, | |
primary key (entity_key) | |
); | |
create table j3_tmodel_category_bag ( | |
id numeric(19,0) not null, | |
entity_key varchar(255) not null, | |
primary key (id), | |
unique (entity_key) | |
); | |
create table j3_tmodel_descr ( | |
id numeric(19,0) identity not null, | |
descr varchar(1024) not null, | |
lang_code varchar(5) null, | |
entity_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_tmodel_identifier ( | |
id numeric(19,0) identity not null, | |
key_name varchar(255) null, | |
key_value varchar(255) not null, | |
tmodel_key_ref varchar(255) null, | |
entity_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_tmodel_instance_info ( | |
id numeric(19,0) identity not null, | |
instance_parms varchar(512) null, | |
tmodel_key varchar(255) not null, | |
entity_key varchar(255) not null, | |
primary key (id) | |
); | |
create table j3_tmodel_instance_info_descr ( | |
id numeric(19,0) identity not null, | |
descr varchar(1024) not null, | |
lang_code varchar(5) null, | |
tmodel_instance_info_id numeric(19,0) not null, | |
primary key (id) | |
); | |
create table j3_transfer_token ( | |
transfer_token varchar(51) not null, | |
expiration_date datetime not null, | |
primary key (transfer_token) | |
); | |
create table j3_transfer_token_keys ( | |
id numeric(19,0) identity not null, | |
entity_key varchar(255) null, | |
transfer_token varchar(51) not null, | |
primary key (id) | |
); | |
create table j3_uddi_entity ( | |
entity_key varchar(255) not null, | |
authorized_name varchar(255) not null, | |
created datetime null, | |
modified datetime not null, | |
modified_including_children datetime null, | |
node_id varchar(255) null, | |
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_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_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_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_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; |