## 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
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