thmodelMgr/src/main/java/jooq/tables/Modelinfo.java

/*
 * This file is generated by jOOQ.
 */
package jooq.tables;


import java.math.BigDecimal;
import java.sql.Timestamp;
import java.util.Arrays;
import java.util.List;

import javax.annotation.Generated;

import jooq.Indexes;
import jooq.Keys;
import jooq.Thmodel;
import jooq.tables.records.ModelinfoRecord;

import org.jooq.Field;
import org.jooq.ForeignKey;
import org.jooq.Identity;
import org.jooq.Index;
import org.jooq.Name;
import org.jooq.Record;
import org.jooq.Schema;
import org.jooq.Table;
import org.jooq.TableField;
import org.jooq.UniqueKey;
import org.jooq.impl.DSL;
import org.jooq.impl.TableImpl;


/**
 * This class is generated by jOOQ.
 */
@Generated(
    value = {
        "http://www.jooq.org",
        "jOOQ version:3.11.5"
    },
    comments = "This class is generated by jOOQ"
)
@SuppressWarnings({ "all", "unchecked", "rawtypes" })
public class Modelinfo extends TableImpl<ModelinfoRecord> {

    private static final long serialVersionUID = 2054950098;

    /**
     * The reference instance of <code>thmodel.modelinfo</code>
     */
    public static final Modelinfo MODELINFO = new Modelinfo();

    /**
     * The class holding records for this type
     */
    @Override
    public Class<ModelinfoRecord> getRecordType() {
        return ModelinfoRecord.class;
    }

    /**
     * The column <code>thmodel.modelinfo.PK</code>.
     */
    public final TableField<ModelinfoRecord, Integer> PK = createField("PK", org.jooq.impl.SQLDataType.INTEGER.nullable(false).identity(true), this, "");

    /**
     * The column <code>thmodel.modelinfo.MemberPK</code>.
     */
    public final TableField<ModelinfoRecord, Integer> MEMBERPK = createField("MemberPK", org.jooq.impl.SQLDataType.INTEGER.nullable(false), this, "");

    /**
     * The column <code>thmodel.modelinfo.nominate</code>.
     */
    public final TableField<ModelinfoRecord, Integer> NOMINATE = createField("nominate", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.Name</code>.
     */
    public final TableField<ModelinfoRecord, String> NAME = createField("Name", org.jooq.impl.SQLDataType.VARCHAR(30), this, "");

    /**
     * The column <code>thmodel.modelinfo.Sex</code>.
     */
    public final TableField<ModelinfoRecord, Integer> SEX = createField("Sex", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.hei</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> HEI = createField("hei", org.jooq.impl.SQLDataType.DECIMAL(5, 2), this, "");

    /**
     * The column <code>thmodel.modelinfo.wei</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> WEI = createField("wei", org.jooq.impl.SQLDataType.DECIMAL(5, 2), this, "");

    /**
     * The column <code>thmodel.modelinfo.wai</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> WAI = createField("wai", org.jooq.impl.SQLDataType.DECIMAL(5, 2), this, "");

    /**
     * The column <code>thmodel.modelinfo.bust</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> BUST = createField("bust", org.jooq.impl.SQLDataType.DECIMAL(5, 2), this, "");

    /**
     * The column <code>thmodel.modelinfo.hip</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> HIP = createField("hip", org.jooq.impl.SQLDataType.DECIMAL(5, 2), this, "");

    /**
     * The column <code>thmodel.modelinfo.shoe</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> SHOE = createField("shoe", org.jooq.impl.SQLDataType.DECIMAL(5, 2), this, "");

    /**
     * The column <code>thmodel.modelinfo.eye</code>.
     */
    public final TableField<ModelinfoRecord, Integer> EYE = createField("eye", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.hair</code>.
     */
    public final TableField<ModelinfoRecord, Integer> HAIR = createField("hair", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.addr</code>.
     */
    public final TableField<ModelinfoRecord, String> ADDR = createField("addr", org.jooq.impl.SQLDataType.VARCHAR(60), this, "");

    /**
     * The column <code>thmodel.modelinfo.BrokePK</code>.
     */
    public final TableField<ModelinfoRecord, Integer> BROKEPK = createField("BrokePK", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.BMemberPK</code>.
     */
    public final TableField<ModelinfoRecord, Integer> BMEMBERPK = createField("BMemberPK", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.Stage</code>.
     */
    public final TableField<ModelinfoRecord, String> STAGE = createField("Stage", org.jooq.impl.SQLDataType.VARCHAR(100), this, "");

    /**
     * The column <code>thmodel.modelinfo.Star</code>.
     */
    public final TableField<ModelinfoRecord, Integer> STAR = createField("Star", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.FCount</code>.
     */
    public final TableField<ModelinfoRecord, Integer> FCOUNT = createField("FCount", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.LName</code>.
     */
    public final TableField<ModelinfoRecord, String> LNAME = createField("LName", org.jooq.impl.SQLDataType.VARCHAR(100), this, "");

    /**
     * The column <code>thmodel.modelinfo.UCount</code>.
     */
    public final TableField<ModelinfoRecord, Integer> UCOUNT = createField("UCount", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.DCount</code>.
     */
    public final TableField<ModelinfoRecord, Integer> DCOUNT = createField("DCount", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.VPrice</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> VPRICE = createField("VPrice", org.jooq.impl.SQLDataType.DECIMAL(18, 4).defaultValue(org.jooq.impl.DSL.inline("6.0000", org.jooq.impl.SQLDataType.DECIMAL)), this, "");

    /**
     * The column <code>thmodel.modelinfo.Is_A</code>.
     */
    public final TableField<ModelinfoRecord, Integer> IS_A = createField("Is_A", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_R</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_R = createField("ratio_R", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_V</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_V = createField("ratio_V", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_S</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_S = createField("ratio_S", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_RB</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_RB = createField("ratio_RB", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_VB</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_VB = createField("ratio_VB", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_SB</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_SB = createField("ratio_SB", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.Is_V</code>.
     */
    public final TableField<ModelinfoRecord, Integer> IS_V = createField("Is_V", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.CardPK</code>.
     */
    public final TableField<ModelinfoRecord, Integer> CARDPK = createField("CardPK", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.modelinfo.Rdate</code>.
     */
    public final TableField<ModelinfoRecord, Timestamp> RDATE = createField("Rdate", org.jooq.impl.SQLDataType.TIMESTAMP, this, "");

    /**
     * The column <code>thmodel.modelinfo.occupation</code>.
     */
    public final TableField<ModelinfoRecord, String> OCCUPATION = createField("occupation", org.jooq.impl.SQLDataType.VARCHAR(100), this, "");

    /**
     * The column <code>thmodel.modelinfo.IsOrder</code>.
     */
    public final TableField<ModelinfoRecord, Integer> ISORDER = createField("IsOrder", org.jooq.impl.SQLDataType.INTEGER.defaultValue(org.jooq.impl.DSL.inline("0", org.jooq.impl.SQLDataType.INTEGER)), this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_RR</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_RR = createField("ratio_RR", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_VR</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_VR = createField("ratio_VR", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_SR</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_SR = createField("ratio_SR", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_RRM</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_RRM = createField("ratio_RRM", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_VRM</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_VRM = createField("ratio_VRM", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.ratio_SRM</code>.
     */
    public final TableField<ModelinfoRecord, BigDecimal> RATIO_SRM = createField("ratio_SRM", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.modelinfo.HasRed</code>.
     */
    public final TableField<ModelinfoRecord, Integer> HASRED = createField("HasRed", org.jooq.impl.SQLDataType.INTEGER.defaultValue(org.jooq.impl.DSL.inline("0", org.jooq.impl.SQLDataType.INTEGER)), this, "");

    /**
     * The column <code>thmodel.modelinfo.sort</code>.
     */
    public final TableField<ModelinfoRecord, Integer> SORT = createField("sort", org.jooq.impl.SQLDataType.INTEGER.defaultValue(org.jooq.impl.DSL.inline("0", org.jooq.impl.SQLDataType.INTEGER)), this, "");

    /**
     * The column <code>thmodel.modelinfo.hobby</code>.
     */
    public final TableField<ModelinfoRecord, String> HOBBY = createField("hobby", org.jooq.impl.SQLDataType.VARCHAR(255), this, "");

    /**
     * The column <code>thmodel.modelinfo.college</code>.
     */
    public final TableField<ModelinfoRecord, String> COLLEGE = createField("college", org.jooq.impl.SQLDataType.VARCHAR(255), this, "");

    /**
     * The column <code>thmodel.modelinfo.constellation</code>.
     */
    public final TableField<ModelinfoRecord, String> CONSTELLATION = createField("constellation", org.jooq.impl.SQLDataType.VARCHAR(255), this, "");

    /**
     * Create a <code>thmodel.modelinfo</code> table reference
     */
    public Modelinfo() {
        this(DSL.name("modelinfo"), null);
    }

    /**
     * Create an aliased <code>thmodel.modelinfo</code> table reference
     */
    public Modelinfo(String alias) {
        this(DSL.name(alias), MODELINFO);
    }

    /**
     * Create an aliased <code>thmodel.modelinfo</code> table reference
     */
    public Modelinfo(Name alias) {
        this(alias, MODELINFO);
    }

    private Modelinfo(Name alias, Table<ModelinfoRecord> aliased) {
        this(alias, aliased, null);
    }

    private Modelinfo(Name alias, Table<ModelinfoRecord> aliased, Field<?>[] parameters) {
        super(alias, null, aliased, parameters, DSL.comment(""));
    }

    public <O extends Record> Modelinfo(Table<O> child, ForeignKey<O, ModelinfoRecord> key) {
        super(child, key, MODELINFO);
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public Schema getSchema() {
        return Thmodel.THMODEL;
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public List<Index> getIndexes() {
        return Arrays.<Index>asList(Indexes.MODELINFO_INDEX_1, Indexes.MODELINFO_INDEX_2, Indexes.MODELINFO_INDEX_3, Indexes.MODELINFO_PRIMARY);
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public Identity<ModelinfoRecord, Integer> getIdentity() {
        return Keys.IDENTITY_MODELINFO;
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public UniqueKey<ModelinfoRecord> getPrimaryKey() {
        return Keys.KEY_MODELINFO_PRIMARY;
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public List<UniqueKey<ModelinfoRecord>> getKeys() {
        return Arrays.<UniqueKey<ModelinfoRecord>>asList(Keys.KEY_MODELINFO_PRIMARY);
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public Modelinfo as(String alias) {
        return new Modelinfo(DSL.name(alias), this);
    }

    /**
     * {@inheritDoc}
     */
    @Override
    public Modelinfo as(Name alias) {
        return new Modelinfo(alias, this);
    }

    /**
     * Rename this table
     */
    @Override
    public Modelinfo rename(String name) {
        return new Modelinfo(DSL.name(name), null);
    }

    /**
     * Rename this table
     */
    @Override
    public Modelinfo rename(Name name) {
        return new Modelinfo(name, null);
    }
}