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

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


import com.thmodel.jooq.Indexes;
import com.thmodel.jooq.Keys;
import com.thmodel.jooq.Thmodel;
import com.thmodel.jooq.tables.records.MemberinfoRecord;

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

import javax.annotation.Generated;

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 Memberinfo extends TableImpl<MemberinfoRecord> {

    private static final long serialVersionUID = -1965956397;

    /**
     * The reference instance of <code>thmodel.memberinfo</code>
     */
    public static final Memberinfo MEMBERINFO = new Memberinfo();

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

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

    /**
     * The column <code>thmodel.memberinfo.MembType</code>.
     */
    public final TableField<MemberinfoRecord, Integer> MEMBTYPE = createField("MembType", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.memberinfo.MembClass</code>.
     */
    public final TableField<MemberinfoRecord, Integer> MEMBCLASS = createField("MembClass", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.memberinfo.QRCode</code>.
     */
    public final TableField<MemberinfoRecord, String> QRCODE = createField("QRCode", org.jooq.impl.SQLDataType.VARCHAR(40), this, "");

    /**
     * The column <code>thmodel.memberinfo.Tel</code>.
     */
    public final TableField<MemberinfoRecord, String> TEL = createField("Tel", org.jooq.impl.SQLDataType.VARCHAR(20), this, "");

    /**
     * The column <code>thmodel.memberinfo.Pass</code>.
     */
    public final TableField<MemberinfoRecord, String> PASS = createField("Pass", org.jooq.impl.SQLDataType.VARCHAR(20), this, "");

    /**
     * The column <code>thmodel.memberinfo.PayPass</code>.
     */
    public final TableField<MemberinfoRecord, String> PAYPASS = createField("PayPass", org.jooq.impl.SQLDataType.VARCHAR(20), this, "");

    /**
     * The column <code>thmodel.memberinfo.Pet</code>.
     */
    public final TableField<MemberinfoRecord, String> PET = createField("Pet", org.jooq.impl.SQLDataType.VARCHAR(50), this, "");

    /**
     * The column <code>thmodel.memberinfo.hPhoto</code>.
     */
    public final TableField<MemberinfoRecord, String> HPHOTO = createField("hPhoto", org.jooq.impl.SQLDataType.VARCHAR(250), this, "");

    /**
     * The column <code>thmodel.memberinfo.Photo</code>.
     */
    public final TableField<MemberinfoRecord, String> PHOTO = createField("Photo", org.jooq.impl.SQLDataType.VARCHAR(250), this, "");

    /**
     * The column <code>thmodel.memberinfo.Area</code>.
     */
    public final TableField<MemberinfoRecord, Integer> AREA = createField("Area", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.memberinfo.Age</code>.
     */
    public final TableField<MemberinfoRecord, String> AGE = createField("Age", org.jooq.impl.SQLDataType.VARCHAR(10), this, "");

    /**
     * The column <code>thmodel.memberinfo.ID</code>.
     */
    public final TableField<MemberinfoRecord, String> ID = createField("ID", org.jooq.impl.SQLDataType.VARCHAR(20), this, "");

    /**
     * The column <code>thmodel.memberinfo.IsLive</code>.
     */
    public final TableField<MemberinfoRecord, Integer> ISLIVE = createField("IsLive", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.memberinfo.MDate</code>.
     */
    public final TableField<MemberinfoRecord, Timestamp> MDATE = createField("MDate", org.jooq.impl.SQLDataType.TIMESTAMP, this, "");

    /**
     * The column <code>thmodel.memberinfo.token</code>.
     */
    public final TableField<MemberinfoRecord, String> TOKEN = createField("token", org.jooq.impl.SQLDataType.VARCHAR(200), this, "");

    /**
     * The column <code>thmodel.memberinfo.acc</code>.
     */
    public final TableField<MemberinfoRecord, Integer> ACC = createField("acc", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.memberinfo.LastSign</code>.
     */
    public final TableField<MemberinfoRecord, Timestamp> LASTSIGN = createField("LastSign", org.jooq.impl.SQLDataType.TIMESTAMP, this, "");

    /**
     * The column <code>thmodel.memberinfo.SignDays</code>.
     */
    public final TableField<MemberinfoRecord, Integer> SIGNDAYS = createField("SignDays", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.memberinfo.IntroducerPK</code>.
     */
    public final TableField<MemberinfoRecord, Integer> INTRODUCERPK = createField("IntroducerPK", org.jooq.impl.SQLDataType.INTEGER, this, "");

    /**
     * The column <code>thmodel.memberinfo.identify</code>.
     */
    public final TableField<MemberinfoRecord, String> IDENTIFY = createField("identify", org.jooq.impl.SQLDataType.VARCHAR(10), this, "");

    /**
     * The column <code>thmodel.memberinfo.ID_A</code>.
     */
    public final TableField<MemberinfoRecord, String> ID_A = createField("ID_A", org.jooq.impl.SQLDataType.VARCHAR(250), this, "");

    /**
     * The column <code>thmodel.memberinfo.ID_B</code>.
     */
    public final TableField<MemberinfoRecord, String> ID_B = createField("ID_B", org.jooq.impl.SQLDataType.VARCHAR(250), this, "");

    /**
     * The column <code>thmodel.memberinfo.ID_C</code>.
     */
    public final TableField<MemberinfoRecord, String> ID_C = createField("ID_C", org.jooq.impl.SQLDataType.VARCHAR(250), this, "");

    /**
     * The column <code>thmodel.memberinfo.WID</code>.
     */
    public final TableField<MemberinfoRecord, String> WID = createField("WID", org.jooq.impl.SQLDataType.VARCHAR(30), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_A</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_A = createField("coin_A", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_IR</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_IR = createField("coin_IR", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_IV</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_IV = createField("coin_IV", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_IS</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_IS = createField("coin_IS", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_IRR</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_IRR = createField("coin_IRR", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_IVV</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_IVV = createField("coin_IVV", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_ISS</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_ISS = createField("coin_ISS", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_ILL</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_ILL = createField("coin_ILL", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_I</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_I = createField("coin_I", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_OR</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_OR = createField("coin_OR", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_OV</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_OV = createField("coin_OV", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_OS</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_OS = createField("coin_OS", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_OM</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_OM = createField("coin_OM", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_O</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_O = createField("coin_O", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_OI</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_OI = createField("coin_OI", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_OP</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_OP = createField("coin_OP", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.Phone</code>.
     */
    public final TableField<MemberinfoRecord, String> PHONE = createField("Phone", org.jooq.impl.SQLDataType.VARCHAR(15), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_IRRR</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_IRRR = createField("coin_IRRR", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_IRRRM</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_IRRRM = createField("coin_IRRRM", org.jooq.impl.SQLDataType.DECIMAL(18, 4), this, "");

    /**
     * The column <code>thmodel.memberinfo.income_ratio_gift</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> INCOME_RATIO_GIFT = createField("income_ratio_gift", org.jooq.impl.SQLDataType.DECIMAL(18, 4).defaultValue(org.jooq.impl.DSL.inline("100.0000", org.jooq.impl.SQLDataType.DECIMAL)), this, "");

    /**
     * The column <code>thmodel.memberinfo.income_ratio_video</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> INCOME_RATIO_VIDEO = createField("income_ratio_video", org.jooq.impl.SQLDataType.DECIMAL(18, 4).defaultValue(org.jooq.impl.DSL.inline("50.0000", org.jooq.impl.SQLDataType.DECIMAL)), this, "");

    /**
     * The column <code>thmodel.memberinfo.income_ratio_service</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> INCOME_RATIO_SERVICE = createField("income_ratio_service", org.jooq.impl.SQLDataType.DECIMAL(18, 4).defaultValue(org.jooq.impl.DSL.inline("70.0000", org.jooq.impl.SQLDataType.DECIMAL)), this, "");

    /**
     * The column <code>thmodel.memberinfo.share_ratio_gift</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> SHARE_RATIO_GIFT = createField("share_ratio_gift", org.jooq.impl.SQLDataType.DECIMAL(18, 4).defaultValue(org.jooq.impl.DSL.inline("0.0000", org.jooq.impl.SQLDataType.DECIMAL)), this, "");

    /**
     * The column <code>thmodel.memberinfo.share_ratio_video</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> SHARE_RATIO_VIDEO = createField("share_ratio_video", org.jooq.impl.SQLDataType.DECIMAL(18, 4).defaultValue(org.jooq.impl.DSL.inline("10.0000", org.jooq.impl.SQLDataType.DECIMAL)), this, "");

    /**
     * The column <code>thmodel.memberinfo.share_ratio_service</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> SHARE_RATIO_SERVICE = createField("share_ratio_service", org.jooq.impl.SQLDataType.DECIMAL(18, 4).defaultValue(org.jooq.impl.DSL.inline("10.0000", org.jooq.impl.SQLDataType.DECIMAL)), this, "");

    /**
     * The column <code>thmodel.memberinfo.broker_ratio_git</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> BROKER_RATIO_GIT = createField("broker_ratio_git", org.jooq.impl.SQLDataType.DECIMAL(18, 4).defaultValue(org.jooq.impl.DSL.inline("0.0000", org.jooq.impl.SQLDataType.DECIMAL)), this, "");

    /**
     * The column <code>thmodel.memberinfo.broker_ratio_video</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> BROKER_RATIO_VIDEO = createField("broker_ratio_video", org.jooq.impl.SQLDataType.DECIMAL(18, 4).defaultValue(org.jooq.impl.DSL.inline("10.0000", org.jooq.impl.SQLDataType.DECIMAL)), this, "");

    /**
     * The column <code>thmodel.memberinfo.broker_ratio_service</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> BROKER_RATIO_SERVICE = createField("broker_ratio_service", org.jooq.impl.SQLDataType.DECIMAL(18, 4).defaultValue(org.jooq.impl.DSL.inline("10.0000", org.jooq.impl.SQLDataType.DECIMAL)), this, "");

    /**
     * The column <code>thmodel.memberinfo.coin_share</code>.
     */
    public final TableField<MemberinfoRecord, BigDecimal> COIN_SHARE = createField("coin_share", org.jooq.impl.SQLDataType.DECIMAL(18, 4).defaultValue(org.jooq.impl.DSL.inline("0.0000", org.jooq.impl.SQLDataType.DECIMAL)), this, "");

    /**
     * The column <code>thmodel.memberinfo.can_chat</code>.
     */
    public final TableField<MemberinfoRecord, Integer> CAN_CHAT = createField("can_chat", org.jooq.impl.SQLDataType.INTEGER.defaultValue(org.jooq.impl.DSL.inline("0", org.jooq.impl.SQLDataType.INTEGER)), this, "");

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

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

    /**
     * Create an aliased <code>thmodel.memberinfo</code> table reference
     */
    public Memberinfo(Name alias) {
        this(alias, MEMBERINFO);
    }

    private Memberinfo(Name alias, Table<MemberinfoRecord> aliased) {
        this(alias, aliased, null);
    }

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

    public <O extends Record> Memberinfo(Table<O> child, ForeignKey<O, MemberinfoRecord> key) {
        super(child, key, MEMBERINFO);
    }

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

    /**
     * {@inheritDoc}
     */
    @Override
    public List<Index> getIndexes() {
        return Arrays.<Index>asList(Indexes.MEMBERINFO_INDEX_1, Indexes.MEMBERINFO_INDEX_2, Indexes.MEMBERINFO_INDEX_3, Indexes.MEMBERINFO_INDEX_4, Indexes.MEMBERINFO_INDEX_5, Indexes.MEMBERINFO_PRIMARY);
    }

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

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

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

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

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

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

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