001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.selector;
005
006
007import com.echothree.model.data.item.common.pk.ItemDescriptionTypePK;
008import com.echothree.model.data.party.common.pk.LanguagePK;
009import com.echothree.model.data.selector.common.pk.SelectorNodeItemDescriptionPK;
010import com.echothree.model.data.selector.common.pk.SelectorNodePK;
011import com.echothree.model.jooq.server.KeyRegistry;
012import com.echothree.model.jooq.server.tables.item.ItemDescriptionTypes.ItemDescriptionTypesPath;
013import com.echothree.model.jooq.server.tables.party.Languages.LanguagesPath;
014import com.echothree.model.jooq.server.tables.selector.SelectorNodes.SelectorNodesPath;
015
016import java.util.Arrays;
017import java.util.Collection;
018import java.util.List;
019
020import org.jooq.Condition;
021import org.jooq.Converter;
022import org.jooq.Field;
023import org.jooq.ForeignKey;
024import org.jooq.Name;
025import org.jooq.PlainSQL;
026import org.jooq.QueryPart;
027import org.jooq.SQL;
028import org.jooq.Stringly;
029import org.jooq.Table;
030import org.jooq.TableField;
031import org.jooq.TableLike;
032import org.jooq.TableOptions;
033import org.jooq.UniqueKey;
034import org.jooq.impl.DSL;
035import org.jooq.impl.Internal;
036import org.jooq.impl.SQLDataType;
037import org.jooq.impl.TableImpl;
038
039
040/**
041 * This class is generated by jOOQ.
042 */
043@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" })
044public class SelectorNodeItemDescriptions extends TableImpl<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions> {
045
046    private static final long serialVersionUID = 1L;
047
048    /**
049     * The reference instance of <code>selectornodeitemdescriptions</code>
050     */
051    public static final SelectorNodeItemDescriptions SelectorNodeItemDescriptions = new SelectorNodeItemDescriptions();
052
053    /**
054     * The class holding records for this type
055     */
056    @Override
057    public Class<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions> getRecordType() {
058        return com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions.class;
059    }
060
061    /**
062     * The column
063     * <code>selectornodeitemdescriptions.slndid_selectornodeitemdescriptionid</code>.
064     */
065    public final TableField<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions, SelectorNodeItemDescriptionPK> SELECTOR_NODE_ITEM_DESCRIPTION = createField(DSL.name("slndid_selectornodeitemdescriptionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, SelectorNodeItemDescriptionPK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorNodeItemDescriptionPK(id), primaryKey -> primaryKey.getEntityId()));
066
067    /**
068     * The column
069     * <code>selectornodeitemdescriptions.slndid_slnd_selectornodeid</code>.
070     */
071    public final TableField<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions, SelectorNodePK> SELECTOR_NODE = createField(DSL.name("slndid_slnd_selectornodeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, SelectorNodePK.class, id -> new com.echothree.model.data.selector.common.pk.SelectorNodePK(id), primaryKey -> primaryKey.getEntityId()));
072
073    /**
074     * The column
075     * <code>selectornodeitemdescriptions.slndid_idt_itemdescriptiontypeid</code>.
076     */
077    public final TableField<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions, ItemDescriptionTypePK> ITEM_DESCRIPTION_TYPE = createField(DSL.name("slndid_idt_itemdescriptiontypeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ItemDescriptionTypePK.class, id -> new com.echothree.model.data.item.common.pk.ItemDescriptionTypePK(id), primaryKey -> primaryKey.getEntityId()));
078
079    /**
080     * The column
081     * <code>selectornodeitemdescriptions.slndid_lang_languageid</code>.
082     */
083    public final TableField<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions, LanguagePK> LANGUAGE = createField(DSL.name("slndid_lang_languageid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, LanguagePK.class, id -> new com.echothree.model.data.party.common.pk.LanguagePK(id), primaryKey -> primaryKey.getEntityId()));
084
085    /**
086     * The column <code>selectornodeitemdescriptions.slndid_fromtime</code>.
087     */
088    public final TableField<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions, Long> FROM_TIME = createField(DSL.name("slndid_fromtime"), SQLDataType.BIGINT.nullable(false), this, "");
089
090    /**
091     * The column <code>selectornodeitemdescriptions.slndid_thrutime</code>.
092     */
093    public final TableField<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions, Long> THRU_TIME = createField(DSL.name("slndid_thrutime"), SQLDataType.BIGINT.nullable(false), this, "");
094
095    private SelectorNodeItemDescriptions(Name alias, Table<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions> aliased) {
096        this(alias, aliased, (Field<?>[]) null, null);
097    }
098
099    private SelectorNodeItemDescriptions(Name alias, Table<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions> aliased, Field<?>[] parameters, Condition where) {
100        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
101    }
102
103    /**
104     * Create an aliased <code>selectornodeitemdescriptions</code> table
105     * reference
106     */
107    public SelectorNodeItemDescriptions(String alias) {
108        this(DSL.name(alias), SelectorNodeItemDescriptions);
109    }
110
111    /**
112     * Create an aliased <code>selectornodeitemdescriptions</code> table
113     * reference
114     */
115    public SelectorNodeItemDescriptions(Name alias) {
116        this(alias, SelectorNodeItemDescriptions);
117    }
118
119    /**
120     * Create a <code>selectornodeitemdescriptions</code> table reference
121     */
122    public SelectorNodeItemDescriptions() {
123        this(DSL.name("selectornodeitemdescriptions"), null);
124    }
125
126    @Override
127    public UniqueKey<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions> getPrimaryKey() {
128        return KeyRegistry.SELECTOR_NODE_ITEM_DESCRIPTIONS_PK;
129    }
130
131    @Override
132    public List<UniqueKey<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions>> getUniqueKeys() {
133        return Arrays.asList(KeyRegistry.SELECTOR_NODE_ITEM_DESCRIPTIONS_SELECTOR_NODE_AND_THRU_TIME_UK);
134    }
135
136    @Override
137    public List<ForeignKey<com.echothree.model.jooq.server.records.selector.SelectorNodeItemDescriptions, ?>> getReferences() {
138        return Arrays.asList(KeyRegistry.SELECTOR_NODE_ITEM_DESCRIPTIONS_ITEM_DESCRIPTION_TYPE_FK, KeyRegistry.SELECTOR_NODE_ITEM_DESCRIPTIONS_LANGUAGE_FK, KeyRegistry.SELECTOR_NODE_ITEM_DESCRIPTIONS_SELECTOR_NODE_FK);
139    }
140
141    private transient ItemDescriptionTypesPath _slndid_idt_itemdescriptiontypeid_fk;
142
143    /**
144     * Get the implicit join path to the <code>itemdescriptiontypes</code>
145     * table.
146     */
147    public ItemDescriptionTypesPath slndid_idt_itemdescriptiontypeid_fk() {
148        if (_slndid_idt_itemdescriptiontypeid_fk == null)
149            _slndid_idt_itemdescriptiontypeid_fk = new ItemDescriptionTypesPath(this, KeyRegistry.SELECTOR_NODE_ITEM_DESCRIPTIONS_ITEM_DESCRIPTION_TYPE_FK, null);
150
151        return _slndid_idt_itemdescriptiontypeid_fk;
152    }
153
154    private transient LanguagesPath _slndid_lang_languageid_fk;
155
156    /**
157     * Get the implicit join path to the <code>languages</code> table.
158     */
159    public LanguagesPath slndid_lang_languageid_fk() {
160        if (_slndid_lang_languageid_fk == null)
161            _slndid_lang_languageid_fk = new LanguagesPath(this, KeyRegistry.SELECTOR_NODE_ITEM_DESCRIPTIONS_LANGUAGE_FK, null);
162
163        return _slndid_lang_languageid_fk;
164    }
165
166    private transient SelectorNodesPath _slndid_slnd_selectornodeid_fk;
167
168    /**
169     * Get the implicit join path to the <code>selectornodes</code> table.
170     */
171    public SelectorNodesPath slndid_slnd_selectornodeid_fk() {
172        if (_slndid_slnd_selectornodeid_fk == null)
173            _slndid_slnd_selectornodeid_fk = new SelectorNodesPath(this, KeyRegistry.SELECTOR_NODE_ITEM_DESCRIPTIONS_SELECTOR_NODE_FK, null);
174
175        return _slndid_slnd_selectornodeid_fk;
176    }
177
178    @Override
179    public SelectorNodeItemDescriptions as(String alias) {
180        return new SelectorNodeItemDescriptions(DSL.name(alias), this);
181    }
182
183    @Override
184    public SelectorNodeItemDescriptions as(Name alias) {
185        return new SelectorNodeItemDescriptions(alias, this);
186    }
187
188    @Override
189    public SelectorNodeItemDescriptions as(Table<?> alias) {
190        return new SelectorNodeItemDescriptions(alias.getQualifiedName(), this);
191    }
192
193    /**
194     * Rename this table
195     */
196    @Override
197    public SelectorNodeItemDescriptions rename(String name) {
198        return new SelectorNodeItemDescriptions(DSL.name(name), null);
199    }
200
201    /**
202     * Rename this table
203     */
204    @Override
205    public SelectorNodeItemDescriptions rename(Name name) {
206        return new SelectorNodeItemDescriptions(name, null);
207    }
208
209    /**
210     * Rename this table
211     */
212    @Override
213    public SelectorNodeItemDescriptions rename(Table<?> name) {
214        return new SelectorNodeItemDescriptions(name.getQualifiedName(), null);
215    }
216
217    /**
218     * Create an inline derived table from this table
219     */
220    @Override
221    public SelectorNodeItemDescriptions where(Condition condition) {
222        return new SelectorNodeItemDescriptions(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
223    }
224
225    /**
226     * Create an inline derived table from this table
227     */
228    @Override
229    public SelectorNodeItemDescriptions where(Collection<? extends Condition> conditions) {
230        return where(DSL.and(conditions));
231    }
232
233    /**
234     * Create an inline derived table from this table
235     */
236    @Override
237    public SelectorNodeItemDescriptions where(Condition... conditions) {
238        return where(DSL.and(conditions));
239    }
240
241    /**
242     * Create an inline derived table from this table
243     */
244    @Override
245    public SelectorNodeItemDescriptions where(Field<Boolean> condition) {
246        return where(DSL.condition(condition));
247    }
248
249    /**
250     * Create an inline derived table from this table
251     */
252    @Override
253    @PlainSQL
254    public SelectorNodeItemDescriptions where(SQL condition) {
255        return where(DSL.condition(condition));
256    }
257
258    /**
259     * Create an inline derived table from this table
260     */
261    @Override
262    @PlainSQL
263    public SelectorNodeItemDescriptions where(@Stringly.SQL String condition) {
264        return where(DSL.condition(condition));
265    }
266
267    /**
268     * Create an inline derived table from this table
269     */
270    @Override
271    @PlainSQL
272    public SelectorNodeItemDescriptions where(@Stringly.SQL String condition, Object... binds) {
273        return where(DSL.condition(condition, binds));
274    }
275
276    /**
277     * Create an inline derived table from this table
278     */
279    @Override
280    @PlainSQL
281    public SelectorNodeItemDescriptions where(@Stringly.SQL String condition, QueryPart... parts) {
282        return where(DSL.condition(condition, parts));
283    }
284
285    /**
286     * Create an inline derived table from this table
287     */
288    @Override
289    public SelectorNodeItemDescriptions whereExists(TableLike<?> select) {
290        return where(DSL.exists(select));
291    }
292
293    /**
294     * Create an inline derived table from this table
295     */
296    @Override
297    public SelectorNodeItemDescriptions whereNotExists(TableLike<?> select) {
298        return where(DSL.notExists(select));
299    }
300}