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