001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.inventory;
005
006
007import com.echothree.model.data.inventory.common.pk.InventoryCostingPoolPK;
008import com.echothree.model.data.inventory.common.pk.InventoryCostingPoolStatusPK;
009import com.echothree.model.jooq.server.KeyRegistry;
010import com.echothree.model.jooq.server.tables.inventory.InventoryCostingPools.InventoryCostingPoolsPath;
011
012import java.util.Arrays;
013import java.util.Collection;
014import java.util.List;
015
016import org.jooq.Condition;
017import org.jooq.Converter;
018import org.jooq.Field;
019import org.jooq.ForeignKey;
020import org.jooq.Name;
021import org.jooq.PlainSQL;
022import org.jooq.QueryPart;
023import org.jooq.SQL;
024import org.jooq.Stringly;
025import org.jooq.Table;
026import org.jooq.TableField;
027import org.jooq.TableLike;
028import org.jooq.TableOptions;
029import org.jooq.UniqueKey;
030import org.jooq.impl.DSL;
031import org.jooq.impl.Internal;
032import org.jooq.impl.SQLDataType;
033import org.jooq.impl.TableImpl;
034
035
036/**
037 * This class is generated by jOOQ.
038 */
039@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" })
040public class InventoryCostingPoolStatuses extends TableImpl<com.echothree.model.jooq.server.records.inventory.InventoryCostingPoolStatuses> {
041
042    private static final long serialVersionUID = 1L;
043
044    /**
045     * The reference instance of <code>inventorycostingpoolstatuses</code>
046     */
047    public static final InventoryCostingPoolStatuses InventoryCostingPoolStatuses = new InventoryCostingPoolStatuses();
048
049    /**
050     * The class holding records for this type
051     */
052    @Override
053    public Class<com.echothree.model.jooq.server.records.inventory.InventoryCostingPoolStatuses> getRecordType() {
054        return com.echothree.model.jooq.server.records.inventory.InventoryCostingPoolStatuses.class;
055    }
056
057    /**
058     * The column
059     * <code>inventorycostingpoolstatuses.invcplst_inventorylayerstatusid</code>.
060     */
061    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryCostingPoolStatuses, InventoryCostingPoolStatusPK> INVENTORY_LAYER_STATUS = createField(DSL.name("invcplst_inventorylayerstatusid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, InventoryCostingPoolStatusPK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryCostingPoolStatusPK(id), primaryKey -> primaryKey.getEntityId()));
062
063    /**
064     * The column
065     * <code>inventorycostingpoolstatuses.invcplst_invcpl_inventorycostingpoolid</code>.
066     */
067    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryCostingPoolStatuses, InventoryCostingPoolPK> INVENTORY_COSTING_POOL = createField(DSL.name("invcplst_invcpl_inventorycostingpoolid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, InventoryCostingPoolPK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryCostingPoolPK(id), primaryKey -> primaryKey.getEntityId()));
068
069    /**
070     * The column
071     * <code>inventorycostingpoolstatuses.invcplst_inventorylayersequence</code>.
072     */
073    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryCostingPoolStatuses, Integer> INVENTORY_LAYER_SEQUENCE = createField(DSL.name("invcplst_inventorylayersequence"), SQLDataType.INTEGER.nullable(false), this, "");
074
075    private InventoryCostingPoolStatuses(Name alias, Table<com.echothree.model.jooq.server.records.inventory.InventoryCostingPoolStatuses> aliased) {
076        this(alias, aliased, (Field<?>[]) null, null);
077    }
078
079    private InventoryCostingPoolStatuses(Name alias, Table<com.echothree.model.jooq.server.records.inventory.InventoryCostingPoolStatuses> aliased, Field<?>[] parameters, Condition where) {
080        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
081    }
082
083    /**
084     * Create an aliased <code>inventorycostingpoolstatuses</code> table
085     * reference
086     */
087    public InventoryCostingPoolStatuses(String alias) {
088        this(DSL.name(alias), InventoryCostingPoolStatuses);
089    }
090
091    /**
092     * Create an aliased <code>inventorycostingpoolstatuses</code> table
093     * reference
094     */
095    public InventoryCostingPoolStatuses(Name alias) {
096        this(alias, InventoryCostingPoolStatuses);
097    }
098
099    /**
100     * Create a <code>inventorycostingpoolstatuses</code> table reference
101     */
102    public InventoryCostingPoolStatuses() {
103        this(DSL.name("inventorycostingpoolstatuses"), null);
104    }
105
106    @Override
107    public UniqueKey<com.echothree.model.jooq.server.records.inventory.InventoryCostingPoolStatuses> getPrimaryKey() {
108        return KeyRegistry.INVENTORY_COSTING_POOL_STATUSES_PK;
109    }
110
111    @Override
112    public List<UniqueKey<com.echothree.model.jooq.server.records.inventory.InventoryCostingPoolStatuses>> getUniqueKeys() {
113        return Arrays.asList(KeyRegistry.INVENTORY_COSTING_POOL_STATUSES_INVENTORY_COSTING_POOL_UK);
114    }
115
116    @Override
117    public List<ForeignKey<com.echothree.model.jooq.server.records.inventory.InventoryCostingPoolStatuses, ?>> getReferences() {
118        return Arrays.asList(KeyRegistry.INVENTORY_COSTING_POOL_STATUSES_INVENTORY_COSTING_POOL_FK);
119    }
120
121    private transient InventoryCostingPoolsPath _invcplst_invcpl_inventorycostingpoolid_fk;
122
123    /**
124     * Get the implicit join path to the <code>inventorycostingpools</code>
125     * table.
126     */
127    public InventoryCostingPoolsPath invcplst_invcpl_inventorycostingpoolid_fk() {
128        if (_invcplst_invcpl_inventorycostingpoolid_fk == null)
129            _invcplst_invcpl_inventorycostingpoolid_fk = new InventoryCostingPoolsPath(this, KeyRegistry.INVENTORY_COSTING_POOL_STATUSES_INVENTORY_COSTING_POOL_FK, null);
130
131        return _invcplst_invcpl_inventorycostingpoolid_fk;
132    }
133
134    @Override
135    public InventoryCostingPoolStatuses as(String alias) {
136        return new InventoryCostingPoolStatuses(DSL.name(alias), this);
137    }
138
139    @Override
140    public InventoryCostingPoolStatuses as(Name alias) {
141        return new InventoryCostingPoolStatuses(alias, this);
142    }
143
144    @Override
145    public InventoryCostingPoolStatuses as(Table<?> alias) {
146        return new InventoryCostingPoolStatuses(alias.getQualifiedName(), this);
147    }
148
149    /**
150     * Rename this table
151     */
152    @Override
153    public InventoryCostingPoolStatuses rename(String name) {
154        return new InventoryCostingPoolStatuses(DSL.name(name), null);
155    }
156
157    /**
158     * Rename this table
159     */
160    @Override
161    public InventoryCostingPoolStatuses rename(Name name) {
162        return new InventoryCostingPoolStatuses(name, null);
163    }
164
165    /**
166     * Rename this table
167     */
168    @Override
169    public InventoryCostingPoolStatuses rename(Table<?> name) {
170        return new InventoryCostingPoolStatuses(name.getQualifiedName(), null);
171    }
172
173    /**
174     * Create an inline derived table from this table
175     */
176    @Override
177    public InventoryCostingPoolStatuses where(Condition condition) {
178        return new InventoryCostingPoolStatuses(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
179    }
180
181    /**
182     * Create an inline derived table from this table
183     */
184    @Override
185    public InventoryCostingPoolStatuses where(Collection<? extends Condition> conditions) {
186        return where(DSL.and(conditions));
187    }
188
189    /**
190     * Create an inline derived table from this table
191     */
192    @Override
193    public InventoryCostingPoolStatuses where(Condition... conditions) {
194        return where(DSL.and(conditions));
195    }
196
197    /**
198     * Create an inline derived table from this table
199     */
200    @Override
201    public InventoryCostingPoolStatuses where(Field<Boolean> condition) {
202        return where(DSL.condition(condition));
203    }
204
205    /**
206     * Create an inline derived table from this table
207     */
208    @Override
209    @PlainSQL
210    public InventoryCostingPoolStatuses where(SQL condition) {
211        return where(DSL.condition(condition));
212    }
213
214    /**
215     * Create an inline derived table from this table
216     */
217    @Override
218    @PlainSQL
219    public InventoryCostingPoolStatuses where(@Stringly.SQL String condition) {
220        return where(DSL.condition(condition));
221    }
222
223    /**
224     * Create an inline derived table from this table
225     */
226    @Override
227    @PlainSQL
228    public InventoryCostingPoolStatuses where(@Stringly.SQL String condition, Object... binds) {
229        return where(DSL.condition(condition, binds));
230    }
231
232    /**
233     * Create an inline derived table from this table
234     */
235    @Override
236    @PlainSQL
237    public InventoryCostingPoolStatuses where(@Stringly.SQL String condition, QueryPart... parts) {
238        return where(DSL.condition(condition, parts));
239    }
240
241    /**
242     * Create an inline derived table from this table
243     */
244    @Override
245    public InventoryCostingPoolStatuses whereExists(TableLike<?> select) {
246        return where(DSL.exists(select));
247    }
248
249    /**
250     * Create an inline derived table from this table
251     */
252    @Override
253    public InventoryCostingPoolStatuses whereNotExists(TableLike<?> select) {
254        return where(DSL.notExists(select));
255    }
256}