001/*
002 * This file is generated by jOOQ.
003 */
004package com.echothree.model.jooq.server.tables.user;
005
006
007import com.echothree.model.data.user.common.pk.UserVisitPK;
008import com.echothree.model.data.user.common.pk.UserVisitStatusPK;
009import com.echothree.model.jooq.server.KeyRegistry;
010import com.echothree.model.jooq.server.tables.user.UserVisits.UserVisitsPath;
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 UserVisitStatuses extends TableImpl<com.echothree.model.jooq.server.records.user.UserVisitStatuses> {
041
042    private static final long serialVersionUID = 1L;
043
044    /**
045     * The reference instance of <code>uservisitstatuses</code>
046     */
047    public static final UserVisitStatuses UserVisitStatuses = new UserVisitStatuses();
048
049    /**
050     * The class holding records for this type
051     */
052    @Override
053    public Class<com.echothree.model.jooq.server.records.user.UserVisitStatuses> getRecordType() {
054        return com.echothree.model.jooq.server.records.user.UserVisitStatuses.class;
055    }
056
057    /**
058     * The column <code>uservisitstatuses.uvisst_uservisitstatusid</code>.
059     */
060    public final TableField<com.echothree.model.jooq.server.records.user.UserVisitStatuses, UserVisitStatusPK> USER_VISIT_STATUS = createField(DSL.name("uvisst_uservisitstatusid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, UserVisitStatusPK.class, id -> new com.echothree.model.data.user.common.pk.UserVisitStatusPK(id), primaryKey -> primaryKey.getEntityId()));
061
062    /**
063     * The column <code>uservisitstatuses.uvisst_uvis_uservisitid</code>.
064     */
065    public final TableField<com.echothree.model.jooq.server.records.user.UserVisitStatuses, UserVisitPK> USER_VISIT = createField(DSL.name("uvisst_uvis_uservisitid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, UserVisitPK.class, id -> new com.echothree.model.data.user.common.pk.UserVisitPK(id), primaryKey -> primaryKey.getEntityId()));
066
067    /**
068     * The column
069     * <code>uservisitstatuses.uvisst_uservisitcommandsequence</code>.
070     */
071    public final TableField<com.echothree.model.jooq.server.records.user.UserVisitStatuses, Integer> USER_VISIT_COMMAND_SEQUENCE = createField(DSL.name("uvisst_uservisitcommandsequence"), SQLDataType.INTEGER.nullable(false), this, "");
072
073    /**
074     * The column
075     * <code>uservisitstatuses.uvisst_uservisitcachedsearchsequence</code>.
076     */
077    public final TableField<com.echothree.model.jooq.server.records.user.UserVisitStatuses, Integer> USER_VISIT_CACHED_SEARCH_SEQUENCE = createField(DSL.name("uvisst_uservisitcachedsearchsequence"), SQLDataType.INTEGER.nullable(false), this, "");
078
079    /**
080     * The column
081     * <code>uservisitstatuses.uvisst_uservisitcampaignsequence</code>.
082     */
083    public final TableField<com.echothree.model.jooq.server.records.user.UserVisitStatuses, Integer> USER_VISIT_CAMPAIGN_SEQUENCE = createField(DSL.name("uvisst_uservisitcampaignsequence"), SQLDataType.INTEGER.nullable(false), this, "");
084
085    /**
086     * The column <code>uservisitstatuses.uvisst_uservisittracksequence</code>.
087     */
088    public final TableField<com.echothree.model.jooq.server.records.user.UserVisitStatuses, Integer> USER_VISIT_TRACK_SEQUENCE = createField(DSL.name("uvisst_uservisittracksequence"), SQLDataType.INTEGER.nullable(false), this, "");
089
090    private UserVisitStatuses(Name alias, Table<com.echothree.model.jooq.server.records.user.UserVisitStatuses> aliased) {
091        this(alias, aliased, (Field<?>[]) null, null);
092    }
093
094    private UserVisitStatuses(Name alias, Table<com.echothree.model.jooq.server.records.user.UserVisitStatuses> aliased, Field<?>[] parameters, Condition where) {
095        super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where);
096    }
097
098    /**
099     * Create an aliased <code>uservisitstatuses</code> table reference
100     */
101    public UserVisitStatuses(String alias) {
102        this(DSL.name(alias), UserVisitStatuses);
103    }
104
105    /**
106     * Create an aliased <code>uservisitstatuses</code> table reference
107     */
108    public UserVisitStatuses(Name alias) {
109        this(alias, UserVisitStatuses);
110    }
111
112    /**
113     * Create a <code>uservisitstatuses</code> table reference
114     */
115    public UserVisitStatuses() {
116        this(DSL.name("uservisitstatuses"), null);
117    }
118
119    @Override
120    public UniqueKey<com.echothree.model.jooq.server.records.user.UserVisitStatuses> getPrimaryKey() {
121        return KeyRegistry.USER_VISIT_STATUSES_PK;
122    }
123
124    @Override
125    public List<UniqueKey<com.echothree.model.jooq.server.records.user.UserVisitStatuses>> getUniqueKeys() {
126        return Arrays.asList(KeyRegistry.USER_VISIT_STATUSES_USER_VISIT_UK);
127    }
128
129    @Override
130    public List<ForeignKey<com.echothree.model.jooq.server.records.user.UserVisitStatuses, ?>> getReferences() {
131        return Arrays.asList(KeyRegistry.USER_VISIT_STATUSES_USER_VISIT_FK);
132    }
133
134    private transient UserVisitsPath _uvisst_uvis_uservisitid_fk;
135
136    /**
137     * Get the implicit join path to the <code>uservisits</code> table.
138     */
139    public UserVisitsPath uvisst_uvis_uservisitid_fk() {
140        if (_uvisst_uvis_uservisitid_fk == null)
141            _uvisst_uvis_uservisitid_fk = new UserVisitsPath(this, KeyRegistry.USER_VISIT_STATUSES_USER_VISIT_FK, null);
142
143        return _uvisst_uvis_uservisitid_fk;
144    }
145
146    @Override
147    public UserVisitStatuses as(String alias) {
148        return new UserVisitStatuses(DSL.name(alias), this);
149    }
150
151    @Override
152    public UserVisitStatuses as(Name alias) {
153        return new UserVisitStatuses(alias, this);
154    }
155
156    @Override
157    public UserVisitStatuses as(Table<?> alias) {
158        return new UserVisitStatuses(alias.getQualifiedName(), this);
159    }
160
161    /**
162     * Rename this table
163     */
164    @Override
165    public UserVisitStatuses rename(String name) {
166        return new UserVisitStatuses(DSL.name(name), null);
167    }
168
169    /**
170     * Rename this table
171     */
172    @Override
173    public UserVisitStatuses rename(Name name) {
174        return new UserVisitStatuses(name, null);
175    }
176
177    /**
178     * Rename this table
179     */
180    @Override
181    public UserVisitStatuses rename(Table<?> name) {
182        return new UserVisitStatuses(name.getQualifiedName(), null);
183    }
184
185    /**
186     * Create an inline derived table from this table
187     */
188    @Override
189    public UserVisitStatuses where(Condition condition) {
190        return new UserVisitStatuses(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition));
191    }
192
193    /**
194     * Create an inline derived table from this table
195     */
196    @Override
197    public UserVisitStatuses where(Collection<? extends Condition> conditions) {
198        return where(DSL.and(conditions));
199    }
200
201    /**
202     * Create an inline derived table from this table
203     */
204    @Override
205    public UserVisitStatuses where(Condition... conditions) {
206        return where(DSL.and(conditions));
207    }
208
209    /**
210     * Create an inline derived table from this table
211     */
212    @Override
213    public UserVisitStatuses where(Field<Boolean> condition) {
214        return where(DSL.condition(condition));
215    }
216
217    /**
218     * Create an inline derived table from this table
219     */
220    @Override
221    @PlainSQL
222    public UserVisitStatuses where(SQL condition) {
223        return where(DSL.condition(condition));
224    }
225
226    /**
227     * Create an inline derived table from this table
228     */
229    @Override
230    @PlainSQL
231    public UserVisitStatuses where(@Stringly.SQL String condition) {
232        return where(DSL.condition(condition));
233    }
234
235    /**
236     * Create an inline derived table from this table
237     */
238    @Override
239    @PlainSQL
240    public UserVisitStatuses where(@Stringly.SQL String condition, Object... binds) {
241        return where(DSL.condition(condition, binds));
242    }
243
244    /**
245     * Create an inline derived table from this table
246     */
247    @Override
248    @PlainSQL
249    public UserVisitStatuses where(@Stringly.SQL String condition, QueryPart... parts) {
250        return where(DSL.condition(condition, parts));
251    }
252
253    /**
254     * Create an inline derived table from this table
255     */
256    @Override
257    public UserVisitStatuses whereExists(TableLike<?> select) {
258        return where(DSL.exists(select));
259    }
260
261    /**
262     * Create an inline derived table from this table
263     */
264    @Override
265    public UserVisitStatuses whereNotExists(TableLike<?> select) {
266        return where(DSL.notExists(select));
267    }
268}