## Licensed to the Apache Software Foundation (ASF) under one ## or more contributor license agreements. See the NOTICE file ## distributed with this work for additional information ## regarding copyright ownership. The ASF licenses this file ## to you 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. ## bookstore
Table Name OM Class Description
a A A table
b B B table
b2 B2 B2 table
r_ab RAb r_ab table
c C c table contains fk to ar_ab, a and b
d D  
nopk Nopk this table has no pk
MULTIPK_SELF_REFTABLE MultipkSelfReftable  
ifc_table IfcTable this table implements an interface
ifc_table2 IfcTable2 this table implements a local interface
INHERITANCE_TEST InheritanceTest Table to test inheritance
ext_schema ExtSchema  
extext_schema ExtextSchema  
torque.qualified_name QualifiedName  

a

A table

Name Type Size Default JavaName PK FK not null Description
a_id int     AId
X
 
X
 
name String 50 a_name Name
 
 
X
 
contactdata String 500   Contactdata
 
 
X
 
created_at java.util.Date 6 CURRENT_TIMESTAMP CreatedAt
 
 
X
 
updated_at java.util.Date 6   UpdatedAt
 
 
X
 
enum EnumEnum 50 x EnumEnum
 
 
 
 

b

B table

Name Type Size Default JavaName PK FK not null Description
b_id int     BId
X
 
X
 
name String 50   Name
 
 
X
 

b2

B2 table

Name Type Size Default JavaName PK FK not null Description
b2_id int     B2Id
X
 
X
 
b2_id_2 int     B2Id2
 
 
 
 
b2_name_1 String 50   B2Name1
 
 
X
 
b2_name_2 String 20   B2Name2
 
 
X
 
b2_name_3 String 10   B2Name3
 
 
X
 
b2_name_4 String 10   B2Name4
 
 
X
 

r_ab

r_ab table

Name Type Size Default JavaName PK FK not null Description
a_id (fk) int     AId
X
X
X
 
b_id (fk) int     BId
X
X
X
 
name String 50   Name
 
 
X
 

c

c table contains fk to ar_ab, a and b

Name Type Size Default JavaName PK FK not null Description
c_id int     CId
X
 
X
 
a_id (fk) (fk) int     AId
 
X
X
 
b_id (fk) (fk) int     BId
 
X
X
 
name String 50   Name
 
 
X
 

d

Name Type Size Default JavaName PK FK not null Description
d_id int     DId
X
 
X
 
name String 255   Name
 
 
X
 
b_id (fk) int     BId
X
X
X
 
a_id (fk) (fk) int     AId
X
X
X
 

nopk

this table has no pk

Name Type Size Default JavaName PK FK not null Description
intcol int     Intcol
 
 
 
 
name String 50   Name
 
 
 
 

MULTIPK_SELF_REFTABLE

Name Type Size Default JavaName PK FK not null Description
COL1 java.math.BigDecimal     Col1
X
 
X
 
COL2 java.math.BigDecimal     Col2
X
 
X
 
PARENT_COL1 (fk) java.math.BigDecimal     ParentCol1
 
X
X
 
PARENT_COL2 (fk) java.math.BigDecimal     ParentCol2
 
X
X
 

ifc_table

this table implements an interface

Name Type Size Default JavaName PK FK not null Description
id int     ID
X
 
X
 
name String 50   Name
 
 
 
 

ifc_table2

this table implements a local interface

Name Type Size Default JavaName PK FK not null Description
id int     ID
X
 
X
 
name String 50   Name
 
 
 
 

INHERITANCE_TEST

Table to test inheritance

Name Type Size Default JavaName PK FK not null Description
INHERITANCE_TEST int     InheritanceTest
X
 
X
 
CLASS_NAME String 1   ClassName
 
 
 
 
PAYLOAD_PARENT String 100   PayloadParent
 
 
X
 
PAYLOAD_B String 100   PayloadB
 
 
 
 
PAYLOAD_C String 100   PayloadC
 
 
 
 
PAYLOAD_D String 100   PayloadD
 
 
 
 

ext_schema

Name Type Size Default JavaName PK FK not null Description
ext_schema_id int     ExtSchemaId
X
 
X
 
ext_id (fk) int     ExtId
 
X
 
 
test int     Test
 
 
X
 

extext_schema

Name Type Size Default JavaName PK FK not null Description
extext_schema_id int     ExtextSchemaId
X
 
X
 
extext_id (fk) int     ExtextId
 
X
 
 
test int     Test
 
 
X
 

torque.qualified_name

Name Type Size Default JavaName PK FK not null Description
id int     Id
 
 
 
 
payload String 100   Payload