text: -- begin DDCDI_CUSTOMER
  create table DDCDI_CUSTOMER (
      ID varchar(36) not null,
      VERSION integer not null,
      CREATE_TS timestamp,
      CREATED_BY varchar(50),
      UPDATE_TS timestamp,
      UPDATED_BY varchar(50),
      DELETE_TS timestamp,
      DELETED_BY varchar(50),
      --
      NAME varchar(255) not null,
      PRIORITY integer,
      FIRST_NAME varchar(255),
      DOCUMENT_NUMBER varchar(50) not null,
      DESCRIPTION longvarchar,
      --
      primary key (ID)
  )^
  -- end DDCDI_CUSTOMER
  -- begin DDCDI_ORDER
  create table DDCDI_ORDER (
      ID varchar(36) not null,
      VERSION integer not null,
      CREATE_TS timestamp,
      CREATED_BY varchar(50),
      UPDATE_TS timestamp,
      UPDATED_BY varchar(50),
      DELETE_TS timestamp,
      DELETED_BY varchar(50),
      --
      ORDER_ID varchar(255) not null,
      ORDER_DATE date not null,
      SHIPPING_DATE date,
      SHIPPING_MODE integer,
      CUSTOMER_ID varchar(36) not null,
      PRODUCT_ID varchar(36) not null,
      PRICE decimal(19, 2),
      QUANTITY double precision,
      TOTAL_PRICE decimal(19, 2),
      --
      primary key (ID)
  )^
  -- end DDCDI_ORDER
  -- begin DDCDI_MLB_PLAYER
  create table DDCDI_MLB_PLAYER (
      ID varchar(36) not null,
      VERSION integer not null,
      CREATE_TS timestamp,
      CREATED_BY varchar(50),
      UPDATE_TS timestamp,
      UPDATED_BY varchar(50),
      DELETE_TS timestamp,
      DELETED_BY varchar(50),
      --
      NAME varchar(255),
      TEAM_ID varchar(36),
      HEIGHT integer,
      WEIGHT integer,
      AGE double precision,
      BIRTHDAY date,
      LEFT_HANDED boolean,
      ANNUAL_SALARY decimal(19, 2),
      --
      primary key (ID)
  )^
  -- end DDCDI_MLB_PLAYER
  -- begin DDCDI_MLB_TEAM
  create table DDCDI_MLB_TEAM (
      ID varchar(36) not null,
      VERSION integer not null,
      CREATE_TS timestamp,
      CREATED_BY varchar(50),
      UPDATE_TS timestamp,
      UPDATED_BY varchar(50),
      DELETE_TS timestamp,
      DELETED_BY varchar(50),
      --
      NAME varchar(255) not null,
      STATE varchar(50),
      CODE varchar(255) not null,
      TELEPHONE integer,
      --
      primary key (ID)
  )^
  -- end DDCDI_MLB_TEAM
  -- begin DDCDI_PRODUCT
  create table DDCDI_PRODUCT (
      ID varchar(36) not null,
      VERSION integer not null,
      CREATE_TS timestamp,
      CREATED_BY varchar(50),
      UPDATE_TS timestamp,
      UPDATED_BY varchar(50),
      DELETE_TS timestamp,
      DELETED_BY varchar(50),
      --
      PRODUCT_ID varchar(255) not null,
      NAME varchar(255) not null,
      CATEGORY_ID varchar(36),
      --
      primary key (ID)
  )^
  -- end DDCDI_PRODUCT
  -- begin DDCDI_PRODUCT_CATEGORY
  create table DDCDI_PRODUCT_CATEGORY (
      ID varchar(36) not null,
      VERSION integer not null,
      CREATE_TS timestamp,
      CREATED_BY varchar(50),
      UPDATE_TS timestamp,
      UPDATED_BY varchar(50),
      DELETE_TS timestamp,
      DELETED_BY varchar(50),
      --
      NAME varchar(255) not null,
      CODE varchar(255) not null,
      PARENT_ID varchar(36),
      --
      primary key (ID)
  )^
  -- end DDCDI_PRODUCT_CATEGORY
  -- begin DDCDI_BASEBALL_STRENGTH
  create table DDCDI_BASEBALL_STRENGTH (
      ID varchar(36) not null,
      VERSION integer not null,
      CREATE_TS timestamp,
      CREATED_BY varchar(50),
      UPDATE_TS timestamp,
      UPDATED_BY varchar(50),
      DELETE_TS timestamp,
      DELETED_BY varchar(50),
      --
      NAME varchar(255) not null,
      CODE varchar(255) not null,
      SCORE integer not null,
      --
      primary key (ID)
  )^
  -- end DDCDI_BASEBALL_STRENGTH
  -- begin DDCDI_MLB_PLAYER_BASEBALL_STRENGTH_LINK
  create table DDCDI_MLB_PLAYER_BASEBALL_STRENGTH_LINK (
      BASEBALL_STRENGTH_ID varchar(36) not null,
      MLB_PLAYER_ID varchar(36) not null,
      primary key (BASEBALL_STRENGTH_ID, MLB_PLAYER_ID)
  )^
  -- end DDCDI_MLB_PLAYER_BASEBALL_STRENGTH_LINK
  
  
  
  -- begin DDCDI_ORDER
  alter table DDCDI_ORDER add constraint FK_DDCDI_ORDER_ON_CUSTOMER foreign key (CUSTOMER_ID) references DDCDI_CUSTOMER(ID)^
  alter table DDCDI_ORDER add constraint FK_DDCDI_ORDER_ON_PRODUCT foreign key (PRODUCT_ID) references DDCDI_PRODUCT(ID)^
  create index IDX_DDCDI_ORDER_ON_CUSTOMER on DDCDI_ORDER (CUSTOMER_ID)^
  create index IDX_DDCDI_ORDER_ON_PRODUCT on DDCDI_ORDER (PRODUCT_ID)^
  -- end DDCDI_ORDER
  -- begin DDCDI_MLB_PLAYER
  alter table DDCDI_MLB_PLAYER add constraint FK_DDCDI_MLB_PLAYER_ON_TEAM foreign key (TEAM_ID) references DDCDI_MLB_TEAM(ID)^
  create index IDX_DDCDI_MLB_PLAYER_ON_TEAM on DDCDI_MLB_PLAYER (TEAM_ID)^
  -- end DDCDI_MLB_PLAYER
  -- begin DDCDI_MLB_TEAM
  create unique index IDX_DDCDI_MLB_TEAM_UNQ on DDCDI_MLB_TEAM (CODE, DELETE_TS) ^
  -- end DDCDI_MLB_TEAM
  -- begin DDCDI_PRODUCT
  alter table DDCDI_PRODUCT add constraint FK_DDCDI_PRODUCT_ON_CATEGORY foreign key (CATEGORY_ID) references DDCDI_PRODUCT_CATEGORY(ID)^
  create unique index IDX_DDCDI_PRODUCT_UNIQ_PRODUCT_ID on DDCDI_PRODUCT (PRODUCT_ID) ^
  create index IDX_DDCDI_PRODUCT_ON_CATEGORY on DDCDI_PRODUCT (CATEGORY_ID)^
  -- end DDCDI_PRODUCT
  -- begin DDCDI_PRODUCT_CATEGORY
  alter table DDCDI_PRODUCT_CATEGORY add constraint FK_DDCDI_PRODUCT_CATEGORY_ON_PARENT foreign key (PARENT_ID) references DDCDI_PRODUCT_CATEGORY(ID)^
  create index IDX_DDCDI_PRODUCT_CATEGORY_ON_PARENT on DDCDI_PRODUCT_CATEGORY (PARENT_ID)^
  -- end DDCDI_PRODUCT_CATEGORY
  -- begin DDCDI_MLB_PLAYER_BASEBALL_STRENGTH_LINK
  alter table DDCDI_MLB_PLAYER_BASEBALL_STRENGTH_LINK add constraint FK_MLBPLABASSTR_ON_BASEBALL_STRENGTH foreign key (BASEBALL_STRENGTH_ID) references DDCDI_BASEBALL_STRENGTH(ID)^
  alter table DDCDI_MLB_PLAYER_BASEBALL_STRENGTH_LINK add constraint FK_MLBPLABASSTR_ON_MLB_PLAYER foreign key (MLB_PLAYER_ID) references DDCDI_MLB_PLAYER(ID)^
  -- end DDCDI_MLB_PLAYER_BASEBALL_STRENGTH_LINK
  