001/* 002 * This file is generated by jOOQ. 003 */ 004package com.echothree.model.jooq.server.tables.payment; 005 006 007import com.echothree.model.data.payment.common.pk.PaymentProcessorActionTypePK; 008import com.echothree.model.data.payment.common.pk.PaymentProcessorPK; 009import com.echothree.model.data.payment.common.pk.PaymentProcessorResultCodePK; 010import com.echothree.model.data.payment.common.pk.PaymentProcessorTransactionDetailPK; 011import com.echothree.model.data.payment.common.pk.PaymentProcessorTransactionPK; 012import com.echothree.model.jooq.server.KeyRegistry; 013import com.echothree.model.jooq.server.tables.payment.PaymentProcessorActionTypes.PaymentProcessorActionTypesPath; 014import com.echothree.model.jooq.server.tables.payment.PaymentProcessorResultCodes.PaymentProcessorResultCodesPath; 015import com.echothree.model.jooq.server.tables.payment.PaymentProcessorTransactions.PaymentProcessorTransactionsPath; 016import com.echothree.model.jooq.server.tables.payment.PaymentProcessors.PaymentProcessorsPath; 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.InverseForeignKey; 027import org.jooq.Name; 028import org.jooq.Path; 029import org.jooq.PlainSQL; 030import org.jooq.QueryPart; 031import org.jooq.Record; 032import org.jooq.SQL; 033import org.jooq.Stringly; 034import org.jooq.Table; 035import org.jooq.TableField; 036import org.jooq.TableLike; 037import org.jooq.TableOptions; 038import org.jooq.UniqueKey; 039import org.jooq.impl.DSL; 040import org.jooq.impl.Internal; 041import org.jooq.impl.SQLDataType; 042import org.jooq.impl.TableImpl; 043 044 045/** 046 * This class is generated by jOOQ. 047 */ 048@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" }) 049public class PaymentProcessorTransactionDetails extends TableImpl<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails> { 050 051 private static final long serialVersionUID = 1L; 052 053 /** 054 * The reference instance of <code>paymentprocessortransactiondetails</code> 055 */ 056 public static final PaymentProcessorTransactionDetails PaymentProcessorTransactionDetails = new PaymentProcessorTransactionDetails(); 057 058 /** 059 * The class holding records for this type 060 */ 061 @Override 062 public Class<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails> getRecordType() { 063 return com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails.class; 064 } 065 066 /** 067 * The column 068 * <code>paymentprocessortransactiondetails.pprctrxdt_paymentprocessortransactiondetailid</code>. 069 */ 070 public final TableField<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails, PaymentProcessorTransactionDetailPK> PAYMENT_PROCESSOR_TRANSACTION_DETAIL = createField(DSL.name("pprctrxdt_paymentprocessortransactiondetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PaymentProcessorTransactionDetailPK.class, id -> new com.echothree.model.data.payment.common.pk.PaymentProcessorTransactionDetailPK(id), primaryKey -> primaryKey.getEntityId())); 071 072 /** 073 * The column 074 * <code>paymentprocessortransactiondetails.pprctrxdt_pprctrx_paymentprocessortransactionid</code>. 075 */ 076 public final TableField<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails, PaymentProcessorTransactionPK> PAYMENT_PROCESSOR_TRANSACTION = createField(DSL.name("pprctrxdt_pprctrx_paymentprocessortransactionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PaymentProcessorTransactionPK.class, id -> new com.echothree.model.data.payment.common.pk.PaymentProcessorTransactionPK(id), primaryKey -> primaryKey.getEntityId())); 077 078 /** 079 * The column 080 * <code>paymentprocessortransactiondetails.pprctrxdt_paymentprocessortransactionname</code>. 081 */ 082 public final TableField<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails, String> PAYMENT_PROCESSOR_TRANSACTION_NAME = createField(DSL.name("pprctrxdt_paymentprocessortransactionname"), SQLDataType.VARCHAR(40).nullable(false), this, ""); 083 084 /** 085 * The column 086 * <code>paymentprocessortransactiondetails.pprctrxdt_pprc_paymentprocessorid</code>. 087 */ 088 public final TableField<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails, PaymentProcessorPK> PAYMENT_PROCESSOR = createField(DSL.name("pprctrxdt_pprc_paymentprocessorid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PaymentProcessorPK.class, id -> new com.echothree.model.data.payment.common.pk.PaymentProcessorPK(id), primaryKey -> primaryKey.getEntityId())); 089 090 /** 091 * The column 092 * <code>paymentprocessortransactiondetails.pprctrxdt_pprcacttyp_paymentprocessoractiontypeid</code>. 093 */ 094 public final TableField<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails, PaymentProcessorActionTypePK> PAYMENT_PROCESSOR_ACTION_TYPE = createField(DSL.name("pprctrxdt_pprcacttyp_paymentprocessoractiontypeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PaymentProcessorActionTypePK.class, id -> new com.echothree.model.data.payment.common.pk.PaymentProcessorActionTypePK(id), primaryKey -> primaryKey.getEntityId())); 095 096 /** 097 * The column 098 * <code>paymentprocessortransactiondetails.pprctrxdt_pprcrc_paymentprocessorresultcodeid</code>. 099 */ 100 public final TableField<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails, PaymentProcessorResultCodePK> PAYMENT_PROCESSOR_RESULT_CODE = createField(DSL.name("pprctrxdt_pprcrc_paymentprocessorresultcodeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, PaymentProcessorResultCodePK.class, id -> new com.echothree.model.data.payment.common.pk.PaymentProcessorResultCodePK(id), primaryKey -> primaryKey.getEntityId())); 101 102 /** 103 * The column 104 * <code>paymentprocessortransactiondetails.pprctrxdt_fromtime</code>. 105 */ 106 public final TableField<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails, Long> FROM_TIME = createField(DSL.name("pprctrxdt_fromtime"), SQLDataType.BIGINT.nullable(false), this, ""); 107 108 /** 109 * The column 110 * <code>paymentprocessortransactiondetails.pprctrxdt_thrutime</code>. 111 */ 112 public final TableField<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails, Long> THRU_TIME = createField(DSL.name("pprctrxdt_thrutime"), SQLDataType.BIGINT.nullable(false), this, ""); 113 114 private PaymentProcessorTransactionDetails(Name alias, Table<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails> aliased) { 115 this(alias, aliased, (Field<?>[]) null, null); 116 } 117 118 private PaymentProcessorTransactionDetails(Name alias, Table<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails> aliased, Field<?>[] parameters, Condition where) { 119 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 120 } 121 122 /** 123 * Create an aliased <code>paymentprocessortransactiondetails</code> table 124 * reference 125 */ 126 public PaymentProcessorTransactionDetails(String alias) { 127 this(DSL.name(alias), PaymentProcessorTransactionDetails); 128 } 129 130 /** 131 * Create an aliased <code>paymentprocessortransactiondetails</code> table 132 * reference 133 */ 134 public PaymentProcessorTransactionDetails(Name alias) { 135 this(alias, PaymentProcessorTransactionDetails); 136 } 137 138 /** 139 * Create a <code>paymentprocessortransactiondetails</code> table reference 140 */ 141 public PaymentProcessorTransactionDetails() { 142 this(DSL.name("paymentprocessortransactiondetails"), null); 143 } 144 145 public <O extends Record> PaymentProcessorTransactionDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails> parentPath) { 146 super(path, childPath, parentPath, PaymentProcessorTransactionDetails); 147 } 148 149 /** 150 * A subtype implementing {@link Path} for simplified path-based joins. 151 */ 152 public static class PaymentProcessorTransactionDetailsPath extends PaymentProcessorTransactionDetails implements Path<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails> { 153 154 private static final long serialVersionUID = 1L; 155 public <O extends Record> PaymentProcessorTransactionDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails> parentPath) { 156 super(path, childPath, parentPath); 157 } 158 private PaymentProcessorTransactionDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails> aliased) { 159 super(alias, aliased); 160 } 161 162 @Override 163 public PaymentProcessorTransactionDetailsPath as(String alias) { 164 return new PaymentProcessorTransactionDetailsPath(DSL.name(alias), this); 165 } 166 167 @Override 168 public PaymentProcessorTransactionDetailsPath as(Name alias) { 169 return new PaymentProcessorTransactionDetailsPath(alias, this); 170 } 171 172 @Override 173 public PaymentProcessorTransactionDetailsPath as(Table<?> alias) { 174 return new PaymentProcessorTransactionDetailsPath(alias.getQualifiedName(), this); 175 } 176 } 177 178 @Override 179 public UniqueKey<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails> getPrimaryKey() { 180 return KeyRegistry.PAYMENT_PROCESSOR_TRANSACTION_DETAILS_PK; 181 } 182 183 @Override 184 public List<UniqueKey<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails>> getUniqueKeys() { 185 return Arrays.asList(KeyRegistry.PAYMENT_PROCESSOR_TRANSACTION_DETAILS_PAYMENT_PROCESSOR_TRANSACTION_AND_THRU_TIME_UK, KeyRegistry.PAYMENT_PROCESSOR_TRANSACTION_DETAILS_PAYMENT_PROCESSOR_TRANSACTION_NAME_AND_THRU_TIME_UK); 186 } 187 188 @Override 189 public List<ForeignKey<com.echothree.model.jooq.server.records.payment.PaymentProcessorTransactionDetails, ?>> getReferences() { 190 return Arrays.asList(KeyRegistry.PAYMENT_PROCESSOR_TRANSACTION_DETAILS_PAYMENT_PROCESSOR_FK, KeyRegistry.PAYMENT_PROCESSOR_TRANSACTION_DETAILS_PAYMENT_PROCESSOR_ACTION_TYPE_FK, KeyRegistry.PAYMENT_PROCESSOR_TRANSACTION_DETAILS_PAYMENT_PROCESSOR_RESULT_CODE_FK, KeyRegistry.PAYMENT_PROCESSOR_TRANSACTION_DETAILS_PAYMENT_PROCESSOR_TRANSACTION_FK); 191 } 192 193 private transient PaymentProcessorsPath _pprctrxdt_pprc_paymentprocessorid_fk; 194 195 /** 196 * Get the implicit join path to the <code>paymentprocessors</code> table. 197 */ 198 public PaymentProcessorsPath pprctrxdt_pprc_paymentprocessorid_fk() { 199 if (_pprctrxdt_pprc_paymentprocessorid_fk == null) 200 _pprctrxdt_pprc_paymentprocessorid_fk = new PaymentProcessorsPath(this, KeyRegistry.PAYMENT_PROCESSOR_TRANSACTION_DETAILS_PAYMENT_PROCESSOR_FK, null); 201 202 return _pprctrxdt_pprc_paymentprocessorid_fk; 203 } 204 205 private transient PaymentProcessorActionTypesPath _pprctrxdt_pprcacttyp_paymentprocessoractiontypeid_fk; 206 207 /** 208 * Get the implicit join path to the 209 * <code>paymentprocessoractiontypes</code> table. 210 */ 211 public PaymentProcessorActionTypesPath pprctrxdt_pprcacttyp_paymentprocessoractiontypeid_fk() { 212 if (_pprctrxdt_pprcacttyp_paymentprocessoractiontypeid_fk == null) 213 _pprctrxdt_pprcacttyp_paymentprocessoractiontypeid_fk = new PaymentProcessorActionTypesPath(this, KeyRegistry.PAYMENT_PROCESSOR_TRANSACTION_DETAILS_PAYMENT_PROCESSOR_ACTION_TYPE_FK, null); 214 215 return _pprctrxdt_pprcacttyp_paymentprocessoractiontypeid_fk; 216 } 217 218 private transient PaymentProcessorResultCodesPath _pprctrxdt_pprcrc_paymentprocessorresultcodeid_fk; 219 220 /** 221 * Get the implicit join path to the 222 * <code>paymentprocessorresultcodes</code> table. 223 */ 224 public PaymentProcessorResultCodesPath pprctrxdt_pprcrc_paymentprocessorresultcodeid_fk() { 225 if (_pprctrxdt_pprcrc_paymentprocessorresultcodeid_fk == null) 226 _pprctrxdt_pprcrc_paymentprocessorresultcodeid_fk = new PaymentProcessorResultCodesPath(this, KeyRegistry.PAYMENT_PROCESSOR_TRANSACTION_DETAILS_PAYMENT_PROCESSOR_RESULT_CODE_FK, null); 227 228 return _pprctrxdt_pprcrc_paymentprocessorresultcodeid_fk; 229 } 230 231 private transient PaymentProcessorTransactionsPath _pprctrxdt_pprctrx_paymentprocessortransactionid_fk; 232 233 /** 234 * Get the implicit join path to the 235 * <code>paymentprocessortransactions</code> table. 236 */ 237 public PaymentProcessorTransactionsPath pprctrxdt_pprctrx_paymentprocessortransactionid_fk() { 238 if (_pprctrxdt_pprctrx_paymentprocessortransactionid_fk == null) 239 _pprctrxdt_pprctrx_paymentprocessortransactionid_fk = new PaymentProcessorTransactionsPath(this, KeyRegistry.PAYMENT_PROCESSOR_TRANSACTION_DETAILS_PAYMENT_PROCESSOR_TRANSACTION_FK, null); 240 241 return _pprctrxdt_pprctrx_paymentprocessortransactionid_fk; 242 } 243 244 @Override 245 public PaymentProcessorTransactionDetails as(String alias) { 246 return new PaymentProcessorTransactionDetails(DSL.name(alias), this); 247 } 248 249 @Override 250 public PaymentProcessorTransactionDetails as(Name alias) { 251 return new PaymentProcessorTransactionDetails(alias, this); 252 } 253 254 @Override 255 public PaymentProcessorTransactionDetails as(Table<?> alias) { 256 return new PaymentProcessorTransactionDetails(alias.getQualifiedName(), this); 257 } 258 259 /** 260 * Rename this table 261 */ 262 @Override 263 public PaymentProcessorTransactionDetails rename(String name) { 264 return new PaymentProcessorTransactionDetails(DSL.name(name), null); 265 } 266 267 /** 268 * Rename this table 269 */ 270 @Override 271 public PaymentProcessorTransactionDetails rename(Name name) { 272 return new PaymentProcessorTransactionDetails(name, null); 273 } 274 275 /** 276 * Rename this table 277 */ 278 @Override 279 public PaymentProcessorTransactionDetails rename(Table<?> name) { 280 return new PaymentProcessorTransactionDetails(name.getQualifiedName(), null); 281 } 282 283 /** 284 * Create an inline derived table from this table 285 */ 286 @Override 287 public PaymentProcessorTransactionDetails where(Condition condition) { 288 return new PaymentProcessorTransactionDetails(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 289 } 290 291 /** 292 * Create an inline derived table from this table 293 */ 294 @Override 295 public PaymentProcessorTransactionDetails where(Collection<? extends Condition> conditions) { 296 return where(DSL.and(conditions)); 297 } 298 299 /** 300 * Create an inline derived table from this table 301 */ 302 @Override 303 public PaymentProcessorTransactionDetails where(Condition... conditions) { 304 return where(DSL.and(conditions)); 305 } 306 307 /** 308 * Create an inline derived table from this table 309 */ 310 @Override 311 public PaymentProcessorTransactionDetails where(Field<Boolean> condition) { 312 return where(DSL.condition(condition)); 313 } 314 315 /** 316 * Create an inline derived table from this table 317 */ 318 @Override 319 @PlainSQL 320 public PaymentProcessorTransactionDetails where(SQL condition) { 321 return where(DSL.condition(condition)); 322 } 323 324 /** 325 * Create an inline derived table from this table 326 */ 327 @Override 328 @PlainSQL 329 public PaymentProcessorTransactionDetails where(@Stringly.SQL String condition) { 330 return where(DSL.condition(condition)); 331 } 332 333 /** 334 * Create an inline derived table from this table 335 */ 336 @Override 337 @PlainSQL 338 public PaymentProcessorTransactionDetails where(@Stringly.SQL String condition, Object... binds) { 339 return where(DSL.condition(condition, binds)); 340 } 341 342 /** 343 * Create an inline derived table from this table 344 */ 345 @Override 346 @PlainSQL 347 public PaymentProcessorTransactionDetails where(@Stringly.SQL String condition, QueryPart... parts) { 348 return where(DSL.condition(condition, parts)); 349 } 350 351 /** 352 * Create an inline derived table from this table 353 */ 354 @Override 355 public PaymentProcessorTransactionDetails whereExists(TableLike<?> select) { 356 return where(DSL.exists(select)); 357 } 358 359 /** 360 * Create an inline derived table from this table 361 */ 362 @Override 363 public PaymentProcessorTransactionDetails whereNotExists(TableLike<?> select) { 364 return where(DSL.notExists(select)); 365 } 366}