/*
 * Copyright 2000-2013 Enonic AS
 * http://www.enonic.com/license
 */
package com.enonic.vertical.engine.dbmodel;

import com.enonic.esl.sql.model.Column;
import com.enonic.esl.sql.model.Constants;
import com.enonic.esl.sql.model.ForeignKeyColumn;
import com.enonic.esl.sql.model.Table;

public final class CategoryTable
    extends Table
{
    private static final CategoryTable Category = new CategoryTable( "tCategory", "category", "categories" );

    public Column cat_lKey = new Column( "cat_lKey", "@key", true, true, Constants.COLUMN_INTEGER, -1 );

    public ForeignKeyColumn cat_uni_lKey =
        new ForeignKeyColumn( "cat_uni_lKey", "@unitkey", false, false, Constants.COLUMN_INTEGER, null, "tUnit", "uni_lKey", false, -1 );

    public ForeignKeyColumn cat_cty_lKey =
        new ForeignKeyColumn( "cat_cty_lKey", "@contenttypekey", false, false, Constants.COLUMN_INTEGER, null, "tContentType", "cty_lKey",
                              false, -1 );

    public ForeignKeyColumn cat_cat_lSuper =
        new ForeignKeyColumn( "cat_cat_lSuper", "@supercategorykey", false, false, Constants.COLUMN_INTEGER, null, "tCategory", "cat_lKey",
                              false, -1 );

    public ForeignKeyColumn cat_usr_hOwner =
        new ForeignKeyColumn( "cat_usr_hOwner", "owner/@key", true, false, Constants.COLUMN_CHAR, null, "tUser", "usr_hKey", false, -1 );

    public Column cat_dteCreated = new Column( "cat_dteCreated", "@created", true, false, Constants.COLUMN_CREATED_TIMESTAMP, -1 );

    public Column cat_bDeleted = new Column( "cat_bDeleted", "@deleted", true, false, Constants.COLUMN_BOOLEAN, -1 );

    public Column cat_sName = new Column( "cat_sName", "@name", true, false, Constants.COLUMN_VARCHAR, 255 );

    public Column cat_sDescription = new Column( "cat_sDescription", "description", false, false, Constants.COLUMN_VARCHAR, 1024 );

    public ForeignKeyColumn cat_usr_hModifier =
        new ForeignKeyColumn( "cat_usr_hModifier", "modifier/@key", true, false, Constants.COLUMN_CHAR, null, "tUser", "usr_hKey", false,
                              -1 );

    public Column cat_dteTimestamp =
        new Column( "cat_dteTimestamp", "@timestamp", true, false, Constants.COLUMN_CURRENT_TIMESTAMP, -1 );

    public Column cat_bAutoApprove = new Column( "cat_bAutoApprove", "@autoApprove", true, false, Constants.COLUMN_BOOLEAN, -1 );

    private CategoryTable( String tableName, String elementName, String parentName )
    {
        super( tableName, elementName, parentName );
        addColumn( cat_lKey );
        addColumn( cat_uni_lKey );
        addColumn( cat_cty_lKey );
        addColumn( cat_cat_lSuper );
        addColumn( cat_usr_hOwner );
        addColumn( cat_dteCreated );
        addColumn( cat_bDeleted );
        addColumn( cat_sName );
        addColumn( cat_sDescription );
        addColumn( cat_usr_hModifier );
        addColumn( cat_dteTimestamp );
        addColumn( cat_bAutoApprove );
    }

    public static CategoryTable getInstance()
    {
        return Category;
    }

}