jp.co.tis.gsp.tools.db.template.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

CREATE TABLE ${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.defaultValue?has_content> DEFAULT ${column.defaultValue} <#if column_has_next>,

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

<#foreach column in entity.columnList>
<#if column.isAutoIncrement()>CREATE SEQUENCE ${column.generatorKeyName} increment by 1 start with 1;