Source code

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.InventoryAdjustmentTypePK;
008import com.echothree.model.data.inventory.common.pk.InventoryBucketTypePK;
009import com.echothree.model.data.inventory.common.pk.InventoryDispositionAdjustmentDetailPK;
010import com.echothree.model.data.inventory.common.pk.InventoryDispositionAdjustmentPK;
011import com.echothree.model.data.inventory.common.pk.InventoryDispositionPK;
012import com.echothree.model.jooq.server.KeyRegistry;
013import com.echothree.model.jooq.server.tables.inventory.InventoryAdjustmentTypes.InventoryAdjustmentTypesPath;
014import com.echothree.model.jooq.server.tables.inventory.InventoryBucketTypes.InventoryBucketTypesPath;
015import com.echothree.model.jooq.server.tables.inventory.InventoryDispositionAdjustments.InventoryDispositionAdjustmentsPath;
016import com.echothree.model.jooq.server.tables.inventory.InventoryDispositions.InventoryDispositionsPath;
017
018import java.util.Arrays;
019import java.util.Collection;
020import java.util.List;
021
022import org.jooq.Condition;
023import org.jooq.Converter;
024import org.jooq.Field;
025import org.jooq.ForeignKey;
026import org.jooq.InverseForeignKey;
027import org.jooq.Name;
028import org.jooq.Path;
029import org.jooq.PlainSQL;
030import org.jooq.QueryPart;
031import org.jooq.Record;
032import org.jooq.SQL;
033import org.jooq.Stringly;
034import org.jooq.Table;
035import org.jooq.TableField;
036import org.jooq.TableLike;
037import org.jooq.TableOptions;
038import org.jooq.UniqueKey;
039import org.jooq.impl.DSL;
040import org.jooq.impl.Internal;
041import org.jooq.impl.SQLDataType;
042import org.jooq.impl.TableImpl;
043
044
045/**
046 * This class is generated by jOOQ.
047 */
048@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" })
049public class InventoryDispositionAdjustmentDetails extends TableImpl<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails> {
050
051    private static final long serialVersionUID = 1L;
052
053    /**
054     * The reference instance of
055     * <code>inventorydispositionadjustmentdetails</code>
056     */
057    public static final InventoryDispositionAdjustmentDetails InventoryDispositionAdjustmentDetails = new InventoryDispositionAdjustmentDetails();
058
059    /**
060     * The class holding records for this type
061     */
062    @Override
063    public Class<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails> getRecordType() {
064        return com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails.class;
065    }
066
067    /**
068     * The column
069     * <code>inventorydispositionadjustmentdetails.invdspadjdt_inventorydispositionadjustmentdetailid</code>.
070     */
071    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails, InventoryDispositionAdjustmentDetailPK> INVENTORY_DISPOSITION_ADJUSTMENT_DETAIL = createField(DSL.name("invdspadjdt_inventorydispositionadjustmentdetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, InventoryDispositionAdjustmentDetailPK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryDispositionAdjustmentDetailPK(id), primaryKey -> primaryKey.getEntityId()));
072
073    /**
074     * The column
075     * <code>inventorydispositionadjustmentdetails.invdspadjdt_invdspadj_inventorydispositionadjustmentid</code>.
076     */
077    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails, InventoryDispositionAdjustmentPK> INVENTORY_DISPOSITION_ADJUSTMENT = createField(DSL.name("invdspadjdt_invdspadj_inventorydispositionadjustmentid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, InventoryDispositionAdjustmentPK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryDispositionAdjustmentPK(id), primaryKey -> primaryKey.getEntityId()));
078
079    /**
080     * The column
081     * <code>inventorydispositionadjustmentdetails.invdspadjdt_invdsp_inventorydispositionid</code>.
082     */
083    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails, InventoryDispositionPK> INVENTORY_DISPOSITION = createField(DSL.name("invdspadjdt_invdsp_inventorydispositionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, InventoryDispositionPK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryDispositionPK(id), primaryKey -> primaryKey.getEntityId()));
084
085    /**
086     * The column
087     * <code>inventorydispositionadjustmentdetails.invdspadjdt_inventorydispositionadjustmentname</code>.
088     */
089    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails, String> INVENTORY_DISPOSITION_ADJUSTMENT_NAME = createField(DSL.name("invdspadjdt_inventorydispositionadjustmentname"), SQLDataType.VARCHAR(40).nullable(false), this, "");
090
091    /**
092     * The column
093     * <code>inventorydispositionadjustmentdetails.invdspadjdt_invadjtyp_inventoryadjustmenttypeid</code>.
094     */
095    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails, InventoryAdjustmentTypePK> INVENTORY_ADJUSTMENT_TYPE = createField(DSL.name("invdspadjdt_invadjtyp_inventoryadjustmenttypeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, InventoryAdjustmentTypePK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryAdjustmentTypePK(id), primaryKey -> primaryKey.getEntityId()));
096
097    /**
098     * The column
099     * <code>inventorydispositionadjustmentdetails.invdspadjdt_invbckttyp_inventorybuckettypeid</code>.
100     */
101    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails, InventoryBucketTypePK> INVENTORY_BUCKET_TYPE = createField(DSL.name("invdspadjdt_invbckttyp_inventorybuckettypeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, InventoryBucketTypePK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryBucketTypePK(id), primaryKey -> primaryKey.getEntityId()));
102
103    /**
104     * The column
105     * <code>inventorydispositionadjustmentdetails.invdspadjdt_isdefault</code>.
106     */
107    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails, Boolean> IS_DEFAULT = createField(DSL.name("invdspadjdt_isdefault"), SQLDataType.BIT.nullable(false), this, "");
108
109    /**
110     * The column
111     * <code>inventorydispositionadjustmentdetails.invdspadjdt_sortorder</code>.
112     */
113    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails, Integer> SORT_ORDER = createField(DSL.name("invdspadjdt_sortorder"), SQLDataType.INTEGER.nullable(false), this, "");
114
115    /**
116     * The column
117     * <code>inventorydispositionadjustmentdetails.invdspadjdt_fromtime</code>.
118     */
119    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails, Long> FROM_TIME = createField(DSL.name("invdspadjdt_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
120
121    /**
122     * The column
123     * <code>inventorydispositionadjustmentdetails.invdspadjdt_thrutime</code>.
124     */
125    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails, Long> THRU_TIME = createField(DSL.name("invdspadjdt_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
126
127    private InventoryDispositionAdjustmentDetails(Name alias, Table<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails> aliased) {
128        this(alias, aliased, (Field<?>[]) null, null);
129    }
130
131    private InventoryDispositionAdjustmentDetails(Name alias, Table<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails> aliased, Field<?>[] parameters, Condition where) {
132        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
133    }
134
135    /**
136     * Create an aliased <code>inventorydispositionadjustmentdetails</code>
137     * table reference
138     */
139    public InventoryDispositionAdjustmentDetails(String alias) {
140        this(DSL.name(alias), InventoryDispositionAdjustmentDetails);
141    }
142
143    /**
144     * Create an aliased <code>inventorydispositionadjustmentdetails</code>
145     * table reference
146     */
147    public InventoryDispositionAdjustmentDetails(Name alias) {
148        this(alias, InventoryDispositionAdjustmentDetails);
149    }
150
151    /**
152     * Create a <code>inventorydispositionadjustmentdetails</code> table
153     * reference
154     */
155    public InventoryDispositionAdjustmentDetails() {
156        this(DSL.name("inventorydispositionadjustmentdetails"), null);
157    }
158
159    public <O extends Record> InventoryDispositionAdjustmentDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails> parentPath) {
160        super(path, childPath, parentPath, InventoryDispositionAdjustmentDetails);
161    }
162
163    /**
164     * A subtype implementing {@link Path} for simplified path-based joins.
165     */
166    public static class InventoryDispositionAdjustmentDetailsPath extends InventoryDispositionAdjustmentDetails implements Path<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails> {
167
168        private static final long serialVersionUID = 1L;
169        public <O extends Record> InventoryDispositionAdjustmentDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails> parentPath) {
170            super(path, childPath, parentPath);
171        }
172        private InventoryDispositionAdjustmentDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails> aliased) {
173            super(alias, aliased);
174        }
175
176        @Override
177        public InventoryDispositionAdjustmentDetailsPath as(String alias) {
178            return new InventoryDispositionAdjustmentDetailsPath(DSL.name(alias), this);
179        }
180
181        @Override
182        public InventoryDispositionAdjustmentDetailsPath as(Name alias) {
183            return new InventoryDispositionAdjustmentDetailsPath(alias, this);
184        }
185
186        @Override
187        public InventoryDispositionAdjustmentDetailsPath as(Table<?> alias) {
188            return new InventoryDispositionAdjustmentDetailsPath(alias.getQualifiedName(), this);
189        }
190    }
191
192    @Override
193    public UniqueKey<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails> getPrimaryKey() {
194        return KeyRegistry.INVENTORY_DISPOSITION_ADJUSTMENT_DETAILS_PK;
195    }
196
197    @Override
198    public List<UniqueKey<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails>> getUniqueKeys() {
199        return Arrays.asList(KeyRegistry.INVENTORY_DISPOSITION_ADJUSTMENT_DETAILS_INVENTORY_DISPOSITION_ADJUSTMENT_AND_THRU_TIME_UK, KeyRegistry.INVENTORY_DISPOSITION_ADJUSTMENT_DETAILS_INVENTORY_DISPOSITION_AND_INVENTORY_DISPOSITION_ADJUSTMENT_NAME_AND_THRU_TIME_UK);
200    }
201
202    @Override
203    public List<ForeignKey<com.echothree.model.jooq.server.records.inventory.InventoryDispositionAdjustmentDetails, ?>> getReferences() {
204        return Arrays.asList(KeyRegistry.INVENTORY_DISPOSITION_ADJUSTMENT_DETAILS_INVENTORY_ADJUSTMENT_TYPE_FK, KeyRegistry.INVENTORY_DISPOSITION_ADJUSTMENT_DETAILS_INVENTORY_BUCKET_TYPE_FK, KeyRegistry.INVENTORY_DISPOSITION_ADJUSTMENT_DETAILS_INVENTORY_DISPOSITION_FK, KeyRegistry.INVENTORY_DISPOSITION_ADJUSTMENT_DETAILS_INVENTORY_DISPOSITION_ADJUSTMENT_FK);
205    }
206
207    private transient InventoryAdjustmentTypesPath _invdspadjdt_invadjtyp_inventoryadjustmenttypeid_fk;
208
209    /**
210     * Get the implicit join path to the <code>inventoryadjustmenttypes</code>
211     * table.
212     */
213    public InventoryAdjustmentTypesPath invdspadjdt_invadjtyp_inventoryadjustmenttypeid_fk() {
214        if (_invdspadjdt_invadjtyp_inventoryadjustmenttypeid_fk == null)
215            _invdspadjdt_invadjtyp_inventoryadjustmenttypeid_fk = new InventoryAdjustmentTypesPath(this, KeyRegistry.INVENTORY_DISPOSITION_ADJUSTMENT_DETAILS_INVENTORY_ADJUSTMENT_TYPE_FK, null);
216
217        return _invdspadjdt_invadjtyp_inventoryadjustmenttypeid_fk;
218    }
219
220    private transient InventoryBucketTypesPath _invdspadjdt_invbckttyp_inventorybuckettypeid_fk;
221
222    /**
223     * Get the implicit join path to the <code>inventorybuckettypes</code>
224     * table.
225     */
226    public InventoryBucketTypesPath invdspadjdt_invbckttyp_inventorybuckettypeid_fk() {
227        if (_invdspadjdt_invbckttyp_inventorybuckettypeid_fk == null)
228            _invdspadjdt_invbckttyp_inventorybuckettypeid_fk = new InventoryBucketTypesPath(this, KeyRegistry.INVENTORY_DISPOSITION_ADJUSTMENT_DETAILS_INVENTORY_BUCKET_TYPE_FK, null);
229
230        return _invdspadjdt_invbckttyp_inventorybuckettypeid_fk;
231    }
232
233    private transient InventoryDispositionsPath _invdspadjdt_invdsp_inventorydispositionid_fk;
234
235    /**
236     * Get the implicit join path to the <code>inventorydispositions</code>
237     * table.
238     */
239    public InventoryDispositionsPath invdspadjdt_invdsp_inventorydispositionid_fk() {
240        if (_invdspadjdt_invdsp_inventorydispositionid_fk == null)
241            _invdspadjdt_invdsp_inventorydispositionid_fk = new InventoryDispositionsPath(this, KeyRegistry.INVENTORY_DISPOSITION_ADJUSTMENT_DETAILS_INVENTORY_DISPOSITION_FK, null);
242
243        return _invdspadjdt_invdsp_inventorydispositionid_fk;
244    }
245
246    private transient InventoryDispositionAdjustmentsPath _invdspadjdt_invdspadj_inventorydispositionadjustmentid_fk;
247
248    /**
249     * Get the implicit join path to the
250     * <code>inventorydispositionadjustments</code> table.
251     */
252    public InventoryDispositionAdjustmentsPath invdspadjdt_invdspadj_inventorydispositionadjustmentid_fk() {
253        if (_invdspadjdt_invdspadj_inventorydispositionadjustmentid_fk == null)
254            _invdspadjdt_invdspadj_inventorydispositionadjustmentid_fk = new InventoryDispositionAdjustmentsPath(this, KeyRegistry.INVENTORY_DISPOSITION_ADJUSTMENT_DETAILS_INVENTORY_DISPOSITION_ADJUSTMENT_FK, null);
255
256        return _invdspadjdt_invdspadj_inventorydispositionadjustmentid_fk;
257    }
258
259    @Override
260    public InventoryDispositionAdjustmentDetails as(String alias) {
261        return new InventoryDispositionAdjustmentDetails(DSL.name(alias), this);
262    }
263
264    @Override
265    public InventoryDispositionAdjustmentDetails as(Name alias) {
266        return new InventoryDispositionAdjustmentDetails(alias, this);
267    }
268
269    @Override
270    public InventoryDispositionAdjustmentDetails as(Table<?> alias) {
271        return new InventoryDispositionAdjustmentDetails(alias.getQualifiedName(), this);
272    }
273
274    /**
275     * Rename this table
276     */
277    @Override
278    public InventoryDispositionAdjustmentDetails rename(String name) {
279        return new InventoryDispositionAdjustmentDetails(DSL.name(name), null);
280    }
281
282    /**
283     * Rename this table
284     */
285    @Override
286    public InventoryDispositionAdjustmentDetails rename(Name name) {
287        return new InventoryDispositionAdjustmentDetails(name, null);
288    }
289
290    /**
291     * Rename this table
292     */
293    @Override
294    public InventoryDispositionAdjustmentDetails rename(Table<?> name) {
295        return new InventoryDispositionAdjustmentDetails(name.getQualifiedName(), null);
296    }
297
298    /**
299     * Create an inline derived table from this table
300     */
301    @Override
302    public InventoryDispositionAdjustmentDetails where(Condition condition) {
303        return new InventoryDispositionAdjustmentDetails(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
304    }
305
306    /**
307     * Create an inline derived table from this table
308     */
309    @Override
310    public InventoryDispositionAdjustmentDetails where(Collection<? extends Condition> conditions) {
311        return where(DSL.and(conditions));
312    }
313
314    /**
315     * Create an inline derived table from this table
316     */
317    @Override
318    public InventoryDispositionAdjustmentDetails where(Condition... conditions) {
319        return where(DSL.and(conditions));
320    }
321
322    /**
323     * Create an inline derived table from this table
324     */
325    @Override
326    public InventoryDispositionAdjustmentDetails where(Field<Boolean> condition) {
327        return where(DSL.condition(condition));
328    }
329
330    /**
331     * Create an inline derived table from this table
332     */
333    @Override
334    @PlainSQL
335    public InventoryDispositionAdjustmentDetails where(SQL condition) {
336        return where(DSL.condition(condition));
337    }
338
339    /**
340     * Create an inline derived table from this table
341     */
342    @Override
343    @PlainSQL
344    public InventoryDispositionAdjustmentDetails where(@Stringly.SQL String condition) {
345        return where(DSL.condition(condition));
346    }
347
348    /**
349     * Create an inline derived table from this table
350     */
351    @Override
352    @PlainSQL
353    public InventoryDispositionAdjustmentDetails where(@Stringly.SQL String condition, Object... binds) {
354        return where(DSL.condition(condition, binds));
355    }
356
357    /**
358     * Create an inline derived table from this table
359     */
360    @Override
361    @PlainSQL
362    public InventoryDispositionAdjustmentDetails where(@Stringly.SQL String condition, QueryPart... parts) {
363        return where(DSL.condition(condition, parts));
364    }
365
366    /**
367     * Create an inline derived table from this table
368     */
369    @Override
370    public InventoryDispositionAdjustmentDetails whereExists(TableLike<?> select) {
371        return where(DSL.exists(select));
372    }
373
374    /**
375     * Create an inline derived table from this table
376     */
377    @Override
378    public InventoryDispositionAdjustmentDetails whereNotExists(TableLike<?> select) {
379        return where(DSL.notExists(select));
380    }
381}