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.PartyTrainingClassSessionPK; 008import com.echothree.model.data.training.common.pk.PartyTrainingClassSessionPagePK; 009import com.echothree.model.data.training.common.pk.PartyTrainingClassSessionQuestionPK; 010import com.echothree.model.data.training.common.pk.PartyTrainingClassSessionSectionPK; 011import com.echothree.model.data.training.common.pk.PartyTrainingClassSessionStatusPK; 012import com.echothree.model.jooq.server.KeyRegistry; 013import com.echothree.model.jooq.server.tables.training.PartyTrainingClassSessionPages.PartyTrainingClassSessionPagesPath; 014import com.echothree.model.jooq.server.tables.training.PartyTrainingClassSessionQuestions.PartyTrainingClassSessionQuestionsPath; 015import com.echothree.model.jooq.server.tables.training.PartyTrainingClassSessionSections.PartyTrainingClassSessionSectionsPath; 016import com.echothree.model.jooq.server.tables.training.PartyTrainingClassSessions.PartyTrainingClassSessionsPath; 017 018import java.util.Arrays; 019import java.util.Collection; 020import java.util.List; 021 022import org.jooq.Condition; 023import org.jooq.Converter; 024import org.jooq.Field; 025import org.jooq.ForeignKey; 026import org.jooq.Name; 027import org.jooq.PlainSQL; 028import org.jooq.QueryPart; 029import org.jooq.SQL; 030import org.jooq.Stringly; 031import org.jooq.Table; 032import org.jooq.TableField; 033import org.jooq.TableLike; 034import org.jooq.TableOptions; 035import org.jooq.UniqueKey; 036import org.jooq.impl.DSL; 037import org.jooq.impl.Internal; 038import org.jooq.impl.SQLDataType; 039import org.jooq.impl.TableImpl; 040 041 042/** 043 * This class is generated by jOOQ. 044 */ 045@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" }) 046public class PartyTrainingClassSessionStatuses extends TableImpl<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses> { 047 048 private static final long serialVersionUID = 1L; 049 050 /** 051 * The reference instance of <code>partytrainingclasssessionstatuses</code> 052 */ 053 public static final PartyTrainingClassSessionStatuses PartyTrainingClassSessionStatuses = new PartyTrainingClassSessionStatuses(); 054 055 /** 056 * The class holding records for this type 057 */ 058 @Override 059 public Class<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses> getRecordType() { 060 return com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses.class; 061 } 062 063 /** 064 * The column 065 * <code>partytrainingclasssessionstatuses.ptrnclssessst_partytrainingclasssessionstatusid</code>. 066 */ 067 public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses, PartyTrainingClassSessionStatusPK> PARTY_TRAINING_CLASS_SESSION_STATUS = createField(DSL.name("ptrnclssessst_partytrainingclasssessionstatusid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PartyTrainingClassSessionStatusPK.class, id -> new com.echothree.model.data.training.common.pk.PartyTrainingClassSessionStatusPK(id), primaryKey -> primaryKey.getEntityId())); 068 069 /** 070 * The column 071 * <code>partytrainingclasssessionstatuses.ptrnclssessst_ptrnclssess_partytrainingclasssessionid</code>. 072 */ 073 public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses, PartyTrainingClassSessionPK> PARTY_TRAINING_CLASS_SESSION = createField(DSL.name("ptrnclssessst_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())); 074 075 /** 076 * The column 077 * <code>partytrainingclasssessionstatuses.ptrnclssessst_partytrainingclasssessionsectionsequence</code>. 078 */ 079 public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses, Integer> PARTY_TRAINING_CLASS_SESSION_SECTION_SEQUENCE = createField(DSL.name("ptrnclssessst_partytrainingclasssessionsectionsequence"), SQLDataType.INTEGER.nullable(false), this, ""); 080 081 /** 082 * The column 083 * <code>partytrainingclasssessionstatuses.ptrnclssessst_partytrainingclasssessionpagesequence</code>. 084 */ 085 public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses, Integer> PARTY_TRAINING_CLASS_SESSION_PAGE_SEQUENCE = createField(DSL.name("ptrnclssessst_partytrainingclasssessionpagesequence"), SQLDataType.INTEGER.nullable(false), this, ""); 086 087 /** 088 * The column 089 * <code>partytrainingclasssessionstatuses.ptrnclssessst_lastpartytrainingclasssessionsectionid</code>. 090 */ 091 public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses, PartyTrainingClassSessionSectionPK> LAST_PARTY_TRAINING_CLASS_SESSION_SECTION = createField(DSL.name("ptrnclssessst_lastpartytrainingclasssessionsectionid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, PartyTrainingClassSessionSectionPK.class, id -> new com.echothree.model.data.training.common.pk.PartyTrainingClassSessionSectionPK(id), primaryKey -> primaryKey.getEntityId())); 092 093 /** 094 * The column 095 * <code>partytrainingclasssessionstatuses.ptrnclssessst_lastpartytrainingclasssessionpageid</code>. 096 */ 097 public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses, PartyTrainingClassSessionPagePK> LAST_PARTY_TRAINING_CLASS_SESSION_PAGE = createField(DSL.name("ptrnclssessst_lastpartytrainingclasssessionpageid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, PartyTrainingClassSessionPagePK.class, id -> new com.echothree.model.data.training.common.pk.PartyTrainingClassSessionPagePK(id), primaryKey -> primaryKey.getEntityId())); 098 099 /** 100 * The column 101 * <code>partytrainingclasssessionstatuses.ptrnclssessst_lastpartytrainingclasssessionquestionid</code>. 102 */ 103 public final TableField<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses, PartyTrainingClassSessionQuestionPK> LAST_PARTY_TRAINING_CLASS_SESSION_QUESTION = createField(DSL.name("ptrnclssessst_lastpartytrainingclasssessionquestionid"), SQLDataType.BIGINT, this, "", Converter.ofNullable(Long.class, PartyTrainingClassSessionQuestionPK.class, id -> new com.echothree.model.data.training.common.pk.PartyTrainingClassSessionQuestionPK(id), primaryKey -> primaryKey.getEntityId())); 104 105 private PartyTrainingClassSessionStatuses(Name alias, Table<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses> aliased) { 106 this(alias, aliased, (Field<?>[]) null, null); 107 } 108 109 private PartyTrainingClassSessionStatuses(Name alias, Table<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses> aliased, Field<?>[] parameters, Condition where) { 110 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 111 } 112 113 /** 114 * Create an aliased <code>partytrainingclasssessionstatuses</code> table 115 * reference 116 */ 117 public PartyTrainingClassSessionStatuses(String alias) { 118 this(DSL.name(alias), PartyTrainingClassSessionStatuses); 119 } 120 121 /** 122 * Create an aliased <code>partytrainingclasssessionstatuses</code> table 123 * reference 124 */ 125 public PartyTrainingClassSessionStatuses(Name alias) { 126 this(alias, PartyTrainingClassSessionStatuses); 127 } 128 129 /** 130 * Create a <code>partytrainingclasssessionstatuses</code> table reference 131 */ 132 public PartyTrainingClassSessionStatuses() { 133 this(DSL.name("partytrainingclasssessionstatuses"), null); 134 } 135 136 @Override 137 public UniqueKey<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses> getPrimaryKey() { 138 return KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_PK; 139 } 140 141 @Override 142 public List<UniqueKey<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses>> getUniqueKeys() { 143 return Arrays.asList(KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_LAST_PARTY_TRAINING_CLASS_SESSION_PAGE_UK, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_LAST_PARTY_TRAINING_CLASS_SESSION_QUESTION_UK, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_LAST_PARTY_TRAINING_CLASS_SESSION_SECTION_UK, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_PARTY_TRAINING_CLASS_SESSION_UK); 144 } 145 146 @Override 147 public List<ForeignKey<com.echothree.model.jooq.server.records.training.PartyTrainingClassSessionStatuses, ?>> getReferences() { 148 return Arrays.asList(KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_LAST_PARTY_TRAINING_CLASS_SESSION_PAGE_FK, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_LAST_PARTY_TRAINING_CLASS_SESSION_QUESTION_FK, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_LAST_PARTY_TRAINING_CLASS_SESSION_SECTION_FK, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_PARTY_TRAINING_CLASS_SESSION_FK); 149 } 150 151 private transient PartyTrainingClassSessionPagesPath _ptrnclssessst_lastpartytrainingclasssessionpageid_fk; 152 153 /** 154 * Get the implicit join path to the 155 * <code>partytrainingclasssessionpages</code> table. 156 */ 157 public PartyTrainingClassSessionPagesPath ptrnclssessst_lastpartytrainingclasssessionpageid_fk() { 158 if (_ptrnclssessst_lastpartytrainingclasssessionpageid_fk == null) 159 _ptrnclssessst_lastpartytrainingclasssessionpageid_fk = new PartyTrainingClassSessionPagesPath(this, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_LAST_PARTY_TRAINING_CLASS_SESSION_PAGE_FK, null); 160 161 return _ptrnclssessst_lastpartytrainingclasssessionpageid_fk; 162 } 163 164 private transient PartyTrainingClassSessionQuestionsPath _ptrnclssessst_lastpartytrainingclasssessionquestionid_fk; 165 166 /** 167 * Get the implicit join path to the 168 * <code>partytrainingclasssessionquestions</code> table. 169 */ 170 public PartyTrainingClassSessionQuestionsPath ptrnclssessst_lastpartytrainingclasssessionquestionid_fk() { 171 if (_ptrnclssessst_lastpartytrainingclasssessionquestionid_fk == null) 172 _ptrnclssessst_lastpartytrainingclasssessionquestionid_fk = new PartyTrainingClassSessionQuestionsPath(this, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_LAST_PARTY_TRAINING_CLASS_SESSION_QUESTION_FK, null); 173 174 return _ptrnclssessst_lastpartytrainingclasssessionquestionid_fk; 175 } 176 177 private transient PartyTrainingClassSessionSectionsPath _ptrnclssessst_lastpartytrainingclasssessionsectionid_fk; 178 179 /** 180 * Get the implicit join path to the 181 * <code>partytrainingclasssessionsections</code> table. 182 */ 183 public PartyTrainingClassSessionSectionsPath ptrnclssessst_lastpartytrainingclasssessionsectionid_fk() { 184 if (_ptrnclssessst_lastpartytrainingclasssessionsectionid_fk == null) 185 _ptrnclssessst_lastpartytrainingclasssessionsectionid_fk = new PartyTrainingClassSessionSectionsPath(this, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_LAST_PARTY_TRAINING_CLASS_SESSION_SECTION_FK, null); 186 187 return _ptrnclssessst_lastpartytrainingclasssessionsectionid_fk; 188 } 189 190 private transient PartyTrainingClassSessionsPath _ptrnclssessst_ptrnclssess_partytrainingclasssessionid_fk; 191 192 /** 193 * Get the implicit join path to the <code>partytrainingclasssessions</code> 194 * table. 195 */ 196 public PartyTrainingClassSessionsPath ptrnclssessst_ptrnclssess_partytrainingclasssessionid_fk() { 197 if (_ptrnclssessst_ptrnclssess_partytrainingclasssessionid_fk == null) 198 _ptrnclssessst_ptrnclssess_partytrainingclasssessionid_fk = new PartyTrainingClassSessionsPath(this, KeyRegistry.PARTY_TRAINING_CLASS_SESSION_STATUSES_PARTY_TRAINING_CLASS_SESSION_FK, null); 199 200 return _ptrnclssessst_ptrnclssess_partytrainingclasssessionid_fk; 201 } 202 203 @Override 204 public PartyTrainingClassSessionStatuses as(String alias) { 205 return new PartyTrainingClassSessionStatuses(DSL.name(alias), this); 206 } 207 208 @Override 209 public PartyTrainingClassSessionStatuses as(Name alias) { 210 return new PartyTrainingClassSessionStatuses(alias, this); 211 } 212 213 @Override 214 public PartyTrainingClassSessionStatuses as(Table<?> alias) { 215 return new PartyTrainingClassSessionStatuses(alias.getQualifiedName(), this); 216 } 217 218 /** 219 * Rename this table 220 */ 221 @Override 222 public PartyTrainingClassSessionStatuses rename(String name) { 223 return new PartyTrainingClassSessionStatuses(DSL.name(name), null); 224 } 225 226 /** 227 * Rename this table 228 */ 229 @Override 230 public PartyTrainingClassSessionStatuses rename(Name name) { 231 return new PartyTrainingClassSessionStatuses(name, null); 232 } 233 234 /** 235 * Rename this table 236 */ 237 @Override 238 public PartyTrainingClassSessionStatuses rename(Table<?> name) { 239 return new PartyTrainingClassSessionStatuses(name.getQualifiedName(), null); 240 } 241 242 /** 243 * Create an inline derived table from this table 244 */ 245 @Override 246 public PartyTrainingClassSessionStatuses where(Condition condition) { 247 return new PartyTrainingClassSessionStatuses(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 PartyTrainingClassSessionStatuses 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 PartyTrainingClassSessionStatuses 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 PartyTrainingClassSessionStatuses 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 PartyTrainingClassSessionStatuses 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 PartyTrainingClassSessionStatuses 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 PartyTrainingClassSessionStatuses 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 PartyTrainingClassSessionStatuses 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 PartyTrainingClassSessionStatuses 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 PartyTrainingClassSessionStatuses whereNotExists(TableLike<?> select) { 323 return where(DSL.notExists(select)); 324 } 325}