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.InventoryConditionPK;
008import com.echothree.model.data.inventory.common.pk.InventoryTransactionLineDestinationPK;
009import com.echothree.model.data.inventory.common.pk.InventoryTransactionLinePK;
010import com.echothree.model.data.party.common.pk.PartyPK;
011import com.echothree.model.data.uom.common.pk.UnitOfMeasureTypePK;
012import com.echothree.model.data.warehouse.common.pk.LocationPK;
013import com.echothree.model.jooq.server.KeyRegistry;
014import com.echothree.model.jooq.server.tables.inventory.InventoryConditions.InventoryConditionsPath;
015import com.echothree.model.jooq.server.tables.inventory.InventoryTransactionLines.InventoryTransactionLinesPath;
016import com.echothree.model.jooq.server.tables.party.Parties.PartiesPath;
017import com.echothree.model.jooq.server.tables.uom.UnitOfMeasureTypes.UnitOfMeasureTypesPath;
018import com.echothree.model.jooq.server.tables.warehouse.Locations.LocationsPath;
019
020import java.util.Arrays;
021import java.util.Collection;
022import java.util.List;
023
024import org.jooq.Condition;
025import org.jooq.Converter;
026import org.jooq.Field;
027import org.jooq.ForeignKey;
028import org.jooq.Name;
029import org.jooq.PlainSQL;
030import org.jooq.QueryPart;
031import org.jooq.SQL;
032import org.jooq.Stringly;
033import org.jooq.Table;
034import org.jooq.TableField;
035import org.jooq.TableLike;
036import org.jooq.TableOptions;
037import org.jooq.UniqueKey;
038import org.jooq.impl.DSL;
039import org.jooq.impl.Internal;
040import org.jooq.impl.SQLDataType;
041import org.jooq.impl.TableImpl;
042
043
044/**
045 * This class is generated by jOOQ.
046 */
047@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" })
048public class InventoryTransactionLineDestinations extends TableImpl<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations> {
049
050    private static final long serialVersionUID = 1L;
051
052    /**
053     * The reference instance of
054     * <code>inventorytransactionlinedestinations</code>
055     */
056    public static final InventoryTransactionLineDestinations InventoryTransactionLineDestinations = new InventoryTransactionLineDestinations();
057
058    /**
059     * The class holding records for this type
060     */
061    @Override
062    public Class<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations> getRecordType() {
063        return com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations.class;
064    }
065
066    /**
067     * The column
068     * <code>inventorytransactionlinedestinations.invtrxldn_inventorytransactionlinedestinationid</code>.
069     */
070    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations, InventoryTransactionLineDestinationPK> INVENTORY_TRANSACTION_LINE_DESTINATION = createField(DSL.name("invtrxldn_inventorytransactionlinedestinationid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, InventoryTransactionLineDestinationPK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryTransactionLineDestinationPK(id), primaryKey -> primaryKey.getEntityId()));
071
072    /**
073     * The column
074     * <code>inventorytransactionlinedestinations.invtrxldn_invtrxl_inventorytransactionlineid</code>.
075     */
076    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations, InventoryTransactionLinePK> INVENTORY_TRANSACTION_LINE = createField(DSL.name("invtrxldn_invtrxl_inventorytransactionlineid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, InventoryTransactionLinePK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryTransactionLinePK(id), primaryKey -> primaryKey.getEntityId()));
077
078    /**
079     * The column
080     * <code>inventorytransactionlinedestinations.invtrxldn_destinationownerpartyid</code>.
081     */
082    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations, PartyPK> DESTINATION_OWNER_PARTY = createField(DSL.name("invtrxldn_destinationownerpartyid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, PartyPK.class, id -> new com.echothree.model.data.party.common.pk.PartyPK(id), primaryKey -> primaryKey.getEntityId()));
083
084    /**
085     * The column
086     * <code>inventorytransactionlinedestinations.invtrxldn_destinationlocationid</code>.
087     */
088    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations, LocationPK> DESTINATION_LOCATION = createField(DSL.name("invtrxldn_destinationlocationid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, LocationPK.class, id -> new com.echothree.model.data.warehouse.common.pk.LocationPK(id), primaryKey -> primaryKey.getEntityId()));
089
090    /**
091     * The column
092     * <code>inventorytransactionlinedestinations.invtrxldn_destinationinventoryconditionid</code>.
093     */
094    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations, InventoryConditionPK> DESTINATION_INVENTORY_CONDITION = createField(DSL.name("invtrxldn_destinationinventoryconditionid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, InventoryConditionPK.class, id -> new com.echothree.model.data.inventory.common.pk.InventoryConditionPK(id), primaryKey -> primaryKey.getEntityId()));
095
096    /**
097     * The column
098     * <code>inventorytransactionlinedestinations.invtrxldn_destinationunitofmeasuretypeid</code>.
099     */
100    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations, UnitOfMeasureTypePK> DESTINATION_UNIT_OF_MEASURE_TYPE = createField(DSL.name("invtrxldn_destinationunitofmeasuretypeid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, UnitOfMeasureTypePK.class, id -> new com.echothree.model.data.uom.common.pk.UnitOfMeasureTypePK(id), primaryKey -> primaryKey.getEntityId()));
101
102    /**
103     * The column
104     * <code>inventorytransactionlinedestinations.invtrxldn_fromtime</code>.
105     */
106    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations, Long> FROM_TIME = createField(DSL.name("invtrxldn_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
107
108    /**
109     * The column
110     * <code>inventorytransactionlinedestinations.invtrxldn_thrutime</code>.
111     */
112    public final TableField<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations, Long> THRU_TIME = createField(DSL.name("invtrxldn_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
113
114    private InventoryTransactionLineDestinations(Name alias, Table<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations> aliased) {
115        this(alias, aliased, (Field<?>[]) null, null);
116    }
117
118    private InventoryTransactionLineDestinations(Name alias, Table<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations> aliased, Field<?>[] parameters, Condition where) {
119        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
120    }
121
122    /**
123     * Create an aliased <code>inventorytransactionlinedestinations</code> table
124     * reference
125     */
126    public InventoryTransactionLineDestinations(String alias) {
127        this(DSL.name(alias), InventoryTransactionLineDestinations);
128    }
129
130    /**
131     * Create an aliased <code>inventorytransactionlinedestinations</code> table
132     * reference
133     */
134    public InventoryTransactionLineDestinations(Name alias) {
135        this(alias, InventoryTransactionLineDestinations);
136    }
137
138    /**
139     * Create a <code>inventorytransactionlinedestinations</code> table
140     * reference
141     */
142    public InventoryTransactionLineDestinations() {
143        this(DSL.name("inventorytransactionlinedestinations"), null);
144    }
145
146    @Override
147    public UniqueKey<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations> getPrimaryKey() {
148        return KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_PK;
149    }
150
151    @Override
152    public List<UniqueKey<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations>> getUniqueKeys() {
153        return Arrays.asList(KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_INVENTORY_TRANSACTION_LINE_AND_THRU_TIME_UK);
154    }
155
156    @Override
157    public List<ForeignKey<com.echothree.model.jooq.server.records.inventory.InventoryTransactionLineDestinations, ?>> getReferences() {
158        return Arrays.asList(KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_DESTINATION_INVENTORY_CONDITION_FK, KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_DESTINATION_LOCATION_FK, KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_DESTINATION_OWNER_PARTY_FK, KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_DESTINATION_UNIT_OF_MEASURE_TYPE_FK, KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_INVENTORY_TRANSACTION_LINE_FK);
159    }
160
161    private transient InventoryConditionsPath _invtrxldn_destinationinventoryconditionid_fk;
162
163    /**
164     * Get the implicit join path to the <code>inventoryconditions</code> table.
165     */
166    public InventoryConditionsPath invtrxldn_destinationinventoryconditionid_fk() {
167        if (_invtrxldn_destinationinventoryconditionid_fk == null)
168            _invtrxldn_destinationinventoryconditionid_fk = new InventoryConditionsPath(this, KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_DESTINATION_INVENTORY_CONDITION_FK, null);
169
170        return _invtrxldn_destinationinventoryconditionid_fk;
171    }
172
173    private transient LocationsPath _invtrxldn_destinationlocationid_fk;
174
175    /**
176     * Get the implicit join path to the <code>locations</code> table.
177     */
178    public LocationsPath invtrxldn_destinationlocationid_fk() {
179        if (_invtrxldn_destinationlocationid_fk == null)
180            _invtrxldn_destinationlocationid_fk = new LocationsPath(this, KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_DESTINATION_LOCATION_FK, null);
181
182        return _invtrxldn_destinationlocationid_fk;
183    }
184
185    private transient PartiesPath _invtrxldn_destinationownerpartyid_fk;
186
187    /**
188     * Get the implicit join path to the <code>parties</code> table.
189     */
190    public PartiesPath invtrxldn_destinationownerpartyid_fk() {
191        if (_invtrxldn_destinationownerpartyid_fk == null)
192            _invtrxldn_destinationownerpartyid_fk = new PartiesPath(this, KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_DESTINATION_OWNER_PARTY_FK, null);
193
194        return _invtrxldn_destinationownerpartyid_fk;
195    }
196
197    private transient UnitOfMeasureTypesPath _invtrxldn_destinationunitofmeasuretypeid_fk;
198
199    /**
200     * Get the implicit join path to the <code>unitofmeasuretypes</code> table.
201     */
202    public UnitOfMeasureTypesPath invtrxldn_destinationunitofmeasuretypeid_fk() {
203        if (_invtrxldn_destinationunitofmeasuretypeid_fk == null)
204            _invtrxldn_destinationunitofmeasuretypeid_fk = new UnitOfMeasureTypesPath(this, KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_DESTINATION_UNIT_OF_MEASURE_TYPE_FK, null);
205
206        return _invtrxldn_destinationunitofmeasuretypeid_fk;
207    }
208
209    private transient InventoryTransactionLinesPath _invtrxldn_invtrxl_inventorytransactionlineid_fk;
210
211    /**
212     * Get the implicit join path to the <code>inventorytransactionlines</code>
213     * table.
214     */
215    public InventoryTransactionLinesPath invtrxldn_invtrxl_inventorytransactionlineid_fk() {
216        if (_invtrxldn_invtrxl_inventorytransactionlineid_fk == null)
217            _invtrxldn_invtrxl_inventorytransactionlineid_fk = new InventoryTransactionLinesPath(this, KeyRegistry.INVENTORY_TRANSACTION_LINE_DESTINATIONS_INVENTORY_TRANSACTION_LINE_FK, null);
218
219        return _invtrxldn_invtrxl_inventorytransactionlineid_fk;
220    }
221
222    @Override
223    public InventoryTransactionLineDestinations as(String alias) {
224        return new InventoryTransactionLineDestinations(DSL.name(alias), this);
225    }
226
227    @Override
228    public InventoryTransactionLineDestinations as(Name alias) {
229        return new InventoryTransactionLineDestinations(alias, this);
230    }
231
232    @Override
233    public InventoryTransactionLineDestinations as(Table<?> alias) {
234        return new InventoryTransactionLineDestinations(alias.getQualifiedName(), this);
235    }
236
237    /**
238     * Rename this table
239     */
240    @Override
241    public InventoryTransactionLineDestinations rename(String name) {
242        return new InventoryTransactionLineDestinations(DSL.name(name), null);
243    }
244
245    /**
246     * Rename this table
247     */
248    @Override
249    public InventoryTransactionLineDestinations rename(Name name) {
250        return new InventoryTransactionLineDestinations(name, null);
251    }
252
253    /**
254     * Rename this table
255     */
256    @Override
257    public InventoryTransactionLineDestinations rename(Table<?> name) {
258        return new InventoryTransactionLineDestinations(name.getQualifiedName(), null);
259    }
260
261    /**
262     * Create an inline derived table from this table
263     */
264    @Override
265    public InventoryTransactionLineDestinations where(Condition condition) {
266        return new InventoryTransactionLineDestinations(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
267    }
268
269    /**
270     * Create an inline derived table from this table
271     */
272    @Override
273    public InventoryTransactionLineDestinations where(Collection<? extends Condition> conditions) {
274        return where(DSL.and(conditions));
275    }
276
277    /**
278     * Create an inline derived table from this table
279     */
280    @Override
281    public InventoryTransactionLineDestinations where(Condition... conditions) {
282        return where(DSL.and(conditions));
283    }
284
285    /**
286     * Create an inline derived table from this table
287     */
288    @Override
289    public InventoryTransactionLineDestinations where(Field<Boolean> condition) {
290        return where(DSL.condition(condition));
291    }
292
293    /**
294     * Create an inline derived table from this table
295     */
296    @Override
297    @PlainSQL
298    public InventoryTransactionLineDestinations where(SQL condition) {
299        return where(DSL.condition(condition));
300    }
301
302    /**
303     * Create an inline derived table from this table
304     */
305    @Override
306    @PlainSQL
307    public InventoryTransactionLineDestinations where(@Stringly.SQL String condition) {
308        return where(DSL.condition(condition));
309    }
310
311    /**
312     * Create an inline derived table from this table
313     */
314    @Override
315    @PlainSQL
316    public InventoryTransactionLineDestinations where(@Stringly.SQL String condition, Object... binds) {
317        return where(DSL.condition(condition, binds));
318    }
319
320    /**
321     * Create an inline derived table from this table
322     */
323    @Override
324    @PlainSQL
325    public InventoryTransactionLineDestinations where(@Stringly.SQL String condition, QueryPart... parts) {
326        return where(DSL.condition(condition, parts));
327    }
328
329    /**
330     * Create an inline derived table from this table
331     */
332    @Override
333    public InventoryTransactionLineDestinations whereExists(TableLike<?> select) {
334        return where(DSL.exists(select));
335    }
336
337    /**
338     * Create an inline derived table from this table
339     */
340    @Override
341    public InventoryTransactionLineDestinations whereNotExists(TableLike<?> select) {
342        return where(DSL.notExists(select));
343    }
344}