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