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