jp.co.tis.gsp.tools.db.template.db2.createTable.ftl Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of gsp-dba-maven-plugin Show documentation

To automate the routine work of the DBA, it is a tool to be able to concentrate on the data modeling work.

There is a newer version: 5.0.0

<#-- DB2 create table template -->
CREATE TABLE <#if entity.schema?has_content>${entity.schema}.${entity.name} (
<#foreach column in entity.columnList>
  ${column.name} ${column.dataType}<#if column.length != 0>(${column.length}<#if column.scale != 0>,${column.scale})<#if column.isArray()> ARRAY<#if !column.isNullable()> NOT NULL<#if column.isAutoIncrement()> GENERATED ALWAYS AS IDENTITY<#if column.defaultValue?has_content> DEFAULT ${column.defaultValue}<#if column_has_next>,

);
<#if entity.label?has_content>COMMENT ON table <#if entity.schema?has_content>${entity.schema}.${entity.name} is '${entity.label}';
<#foreach column in entity.columnList>
<#if column.label?has_content>COMMENT ON column <#if entity.schema?has_content>${entity.schema}.${entity.name}.${column.name} is '${column.label}';