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.InventoryTransactionPK;
008import com.echothree.model.data.inventory.common.pk.InventoryTransactionStatusPK;
009import com.echothree.model.jooq.server.KeyRegistry;
010import com.echothree.model.jooq.server.tables.inventory.InventoryTransactions.InventoryTransactionsPath;
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 InventoryTransactionStatuses extends TableImpl<com.echothree.model.jooq.server.records.inventory.InventoryTransactionStatuses> {
041
042    private static final long serialVersionUID = 1L;
043
044    /**
045     * The reference instance of <code>inventorytransactionstatuses</code>
046     */
047    public static final InventoryTransactionStatuses InventoryTransactionStatuses = new InventoryTransactionStatuses();
048
049    /**
050     * The class holding records for this type
051     */
052    @Override
053    public Class<com.echothree.model.jooq.server.records.inventory.InventoryTransactionStatuses> getRecordType() {
054        return com.echothree.model.jooq.server.records.inventory.InventoryTransactionStatuses.class;
055    }
056
057    /**
058     * The column
059     * <code>inventorytransactionstatuses.invtrxst_inventorytransactionstatusid</code>.
060     */
061    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryTransactionStatuses, InventoryTransactionStatusPK> INVENTORY_TRANSACTION_STATUS = createField(DSL.name("invtrxst_inventorytransactionstatusid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, InventoryTransactionStatusPK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryTransactionStatusPK(id), primaryKey -> primaryKey.getEntityId()));
062
063    /**
064     * The column
065     * <code>inventorytransactionstatuses.invtrxst_invtrx_inventorytransactionid</code>.
066     */
067    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryTransactionStatuses, InventoryTransactionPK> INVENTORY_TRANSACTION = createField(DSL.name("invtrxst_invtrx_inventorytransactionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, InventoryTransactionPK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryTransactionPK(id), primaryKey -> primaryKey.getEntityId()));
068
069    /**
070     * The column
071     * <code>inventorytransactionstatuses.invtrxst_inventorytransactionlinesequence</code>.
072     */
073    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryTransactionStatuses, Integer> INVENTORY_TRANSACTION_LINE_SEQUENCE = createField(DSL.name("invtrxst_inventorytransactionlinesequence"), SQLDataType.INTEGER.nullable(false), this, "");
074
075    private InventoryTransactionStatuses(Name alias, Table<com.echothree.model.jooq.server.records.inventory.InventoryTransactionStatuses> aliased) {
076        this(alias, aliased, (Field<?>[]) null, null);
077    }
078
079    private InventoryTransactionStatuses(Name alias, Table<com.echothree.model.jooq.server.records.inventory.InventoryTransactionStatuses> aliased, Field<?>[] parameters, Condition where) {
080        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
081    }
082
083    /**
084     * Create an aliased <code>inventorytransactionstatuses</code> table
085     * reference
086     */
087    public InventoryTransactionStatuses(String alias) {
088        this(DSL.name(alias), InventoryTransactionStatuses);
089    }
090
091    /**
092     * Create an aliased <code>inventorytransactionstatuses</code> table
093     * reference
094     */
095    public InventoryTransactionStatuses(Name alias) {
096        this(alias, InventoryTransactionStatuses);
097    }
098
099    /**
100     * Create a <code>inventorytransactionstatuses</code> table reference
101     */
102    public InventoryTransactionStatuses() {
103        this(DSL.name("inventorytransactionstatuses"), null);
104    }
105
106    @Override
107    public UniqueKey<com.echothree.model.jooq.server.records.inventory.InventoryTransactionStatuses> getPrimaryKey() {
108        return KeyRegistry.INVENTORY_TRANSACTION_STATUSES_PK;
109    }
110
111    @Override
112    public List<UniqueKey<com.echothree.model.jooq.server.records.inventory.InventoryTransactionStatuses>> getUniqueKeys() {
113        return Arrays.asList(KeyRegistry.INVENTORY_TRANSACTION_STATUSES_INVENTORY_TRANSACTION_UK);
114    }
115
116    @Override
117    public List<ForeignKey<com.echothree.model.jooq.server.records.inventory.InventoryTransactionStatuses, ?>> getReferences() {
118        return Arrays.asList(KeyRegistry.INVENTORY_TRANSACTION_STATUSES_INVENTORY_TRANSACTION_FK);
119    }
120
121    private transient InventoryTransactionsPath _invtrxst_invtrx_inventorytransactionid_fk;
122
123    /**
124     * Get the implicit join path to the <code>inventorytransactions</code>
125     * table.
126     */
127    public InventoryTransactionsPath invtrxst_invtrx_inventorytransactionid_fk() {
128        if (_invtrxst_invtrx_inventorytransactionid_fk == null)
129            _invtrxst_invtrx_inventorytransactionid_fk = new InventoryTransactionsPath(this, KeyRegistry.INVENTORY_TRANSACTION_STATUSES_INVENTORY_TRANSACTION_FK, null);
130
131        return _invtrxst_invtrx_inventorytransactionid_fk;
132    }
133
134    @Override
135    public InventoryTransactionStatuses as(String alias) {
136        return new InventoryTransactionStatuses(DSL.name(alias), this);
137    }
138
139    @Override
140    public InventoryTransactionStatuses as(Name alias) {
141        return new InventoryTransactionStatuses(alias, this);
142    }
143
144    @Override
145    public InventoryTransactionStatuses as(Table<?> alias) {
146        return new InventoryTransactionStatuses(alias.getQualifiedName(), this);
147    }
148
149    /**
150     * Rename this table
151     */
152    @Override
153    public InventoryTransactionStatuses rename(String name) {
154        return new InventoryTransactionStatuses(DSL.name(name), null);
155    }
156
157    /**
158     * Rename this table
159     */
160    @Override
161    public InventoryTransactionStatuses rename(Name name) {
162        return new InventoryTransactionStatuses(name, null);
163    }
164
165    /**
166     * Rename this table
167     */
168    @Override
169    public InventoryTransactionStatuses rename(Table<?> name) {
170        return new InventoryTransactionStatuses(name.getQualifiedName(), null);
171    }
172
173    /**
174     * Create an inline derived table from this table
175     */
176    @Override
177    public InventoryTransactionStatuses where(Condition condition) {
178        return new InventoryTransactionStatuses(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 InventoryTransactionStatuses 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 InventoryTransactionStatuses 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 InventoryTransactionStatuses 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 InventoryTransactionStatuses 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 InventoryTransactionStatuses 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 InventoryTransactionStatuses 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 InventoryTransactionStatuses 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 InventoryTransactionStatuses 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 InventoryTransactionStatuses whereNotExists(TableLike<?> select) {
254        return where(DSL.notExists(select));
255    }
256}