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