001/* 002 * This file is generated by jOOQ. 003 */ 004package com.echothree.model.jooq.server.tables.tax; 005 006 007import com.echothree.model.data.geo.common.pk.GeoCodePK; 008import com.echothree.model.data.tax.common.pk.TaxClassificationDetailPK; 009import com.echothree.model.data.tax.common.pk.TaxClassificationPK; 010import com.echothree.model.jooq.server.KeyRegistry; 011import com.echothree.model.jooq.server.tables.geo.GeoCodes.GeoCodesPath; 012import com.echothree.model.jooq.server.tables.tax.TaxClassifications.TaxClassificationsPath; 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 TaxClassificationDetails extends TableImpl<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails> { 046 047 private static final long serialVersionUID = 1L; 048 049 /** 050 * The reference instance of <code>taxclassificationdetails</code> 051 */ 052 public static final TaxClassificationDetails TaxClassificationDetails = new TaxClassificationDetails(); 053 054 /** 055 * The class holding records for this type 056 */ 057 @Override 058 public Class<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails> getRecordType() { 059 return com.echothree.model.jooq.server.records.tax.TaxClassificationDetails.class; 060 } 061 062 /** 063 * The column 064 * <code>taxclassificationdetails.txclsfndt_taxclassificationdetailid</code>. 065 */ 066 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails, TaxClassificationDetailPK> TAX_CLASSIFICATION_DETAIL = createField(DSL.name("txclsfndt_taxclassificationdetailid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, TaxClassificationDetailPK.class, id -> new com.echothree.model.data.tax.common.pk.TaxClassificationDetailPK(id), primaryKey -> primaryKey.getEntityId())); 067 068 /** 069 * The column 070 * <code>taxclassificationdetails.txclsfndt_txclsfn_taxclassificationid</code>. 071 */ 072 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails, TaxClassificationPK> TAX_CLASSIFICATION = createField(DSL.name("txclsfndt_txclsfn_taxclassificationid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, TaxClassificationPK.class, id -> new com.echothree.model.data.tax.common.pk.TaxClassificationPK(id), primaryKey -> primaryKey.getEntityId())); 073 074 /** 075 * The column 076 * <code>taxclassificationdetails.txclsfndt_countrygeocodeid</code>. 077 */ 078 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails, GeoCodePK> COUNTRY_GEO_CODE = createField(DSL.name("txclsfndt_countrygeocodeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, GeoCodePK.class, id -> new com.echothree.model.data.geo.common.pk.GeoCodePK(id), primaryKey -> primaryKey.getEntityId())); 079 080 /** 081 * The column 082 * <code>taxclassificationdetails.txclsfndt_taxclassificationname</code>. 083 */ 084 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails, String> TAX_CLASSIFICATION_NAME = createField(DSL.name("txclsfndt_taxclassificationname"), SQLDataType.VARCHAR(40).nullable(false), this, ""); 085 086 /** 087 * The column <code>taxclassificationdetails.txclsfndt_isdefault</code>. 088 */ 089 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails, Boolean> IS_DEFAULT = createField(DSL.name("txclsfndt_isdefault"), SQLDataType.BIT.nullable(false), this, ""); 090 091 /** 092 * The column <code>taxclassificationdetails.txclsfndt_sortorder</code>. 093 */ 094 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails, Integer> SORT_ORDER = createField(DSL.name("txclsfndt_sortorder"), SQLDataType.INTEGER.nullable(false), this, ""); 095 096 /** 097 * The column <code>taxclassificationdetails.txclsfndt_fromtime</code>. 098 */ 099 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails, Long> FROM_TIME = createField(DSL.name("txclsfndt_fromtime"), SQLDataType.BIGINT.nullable(false), this, ""); 100 101 /** 102 * The column <code>taxclassificationdetails.txclsfndt_thrutime</code>. 103 */ 104 public final TableField<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails, Long> THRU_TIME = createField(DSL.name("txclsfndt_thrutime"), SQLDataType.BIGINT.nullable(false), this, ""); 105 106 private TaxClassificationDetails(Name alias, Table<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails> aliased) { 107 this(alias, aliased, (Field<?>[]) null, null); 108 } 109 110 private TaxClassificationDetails(Name alias, Table<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails> aliased, Field<?>[] parameters, Condition where) { 111 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 112 } 113 114 /** 115 * Create an aliased <code>taxclassificationdetails</code> table reference 116 */ 117 public TaxClassificationDetails(String alias) { 118 this(DSL.name(alias), TaxClassificationDetails); 119 } 120 121 /** 122 * Create an aliased <code>taxclassificationdetails</code> table reference 123 */ 124 public TaxClassificationDetails(Name alias) { 125 this(alias, TaxClassificationDetails); 126 } 127 128 /** 129 * Create a <code>taxclassificationdetails</code> table reference 130 */ 131 public TaxClassificationDetails() { 132 this(DSL.name("taxclassificationdetails"), null); 133 } 134 135 public <O extends Record> TaxClassificationDetails(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.tax.TaxClassificationDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.tax.TaxClassificationDetails> parentPath) { 136 super(path, childPath, parentPath, TaxClassificationDetails); 137 } 138 139 /** 140 * A subtype implementing {@link Path} for simplified path-based joins. 141 */ 142 public static class TaxClassificationDetailsPath extends TaxClassificationDetails implements Path<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails> { 143 144 private static final long serialVersionUID = 1L; 145 public <O extends Record> TaxClassificationDetailsPath(Table<O> path, ForeignKey<O, com.echothree.model.jooq.server.records.tax.TaxClassificationDetails> childPath, InverseForeignKey<O, com.echothree.model.jooq.server.records.tax.TaxClassificationDetails> parentPath) { 146 super(path, childPath, parentPath); 147 } 148 private TaxClassificationDetailsPath(Name alias, Table<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails> aliased) { 149 super(alias, aliased); 150 } 151 152 @Override 153 public TaxClassificationDetailsPath as(String alias) { 154 return new TaxClassificationDetailsPath(DSL.name(alias), this); 155 } 156 157 @Override 158 public TaxClassificationDetailsPath as(Name alias) { 159 return new TaxClassificationDetailsPath(alias, this); 160 } 161 162 @Override 163 public TaxClassificationDetailsPath as(Table<?> alias) { 164 return new TaxClassificationDetailsPath(alias.getQualifiedName(), this); 165 } 166 } 167 168 @Override 169 public UniqueKey<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails> getPrimaryKey() { 170 return KeyRegistry.TAX_CLASSIFICATION_DETAILS_PK; 171 } 172 173 @Override 174 public List<UniqueKey<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails>> getUniqueKeys() { 175 return Arrays.asList(KeyRegistry.TAX_CLASSIFICATION_DETAILS_TAX_CLASSIFICATION_AND_THRU_TIME_UK, KeyRegistry.TAX_CLASSIFICATION_DETAILS_COUNTRY_GEO_CODE_AND_TAX_CLASSIFICATION_NAME_AND_THRU_TIME_UK); 176 } 177 178 @Override 179 public List<ForeignKey<com.echothree.model.jooq.server.records.tax.TaxClassificationDetails, ?>> getReferences() { 180 return Arrays.asList(KeyRegistry.TAX_CLASSIFICATION_DETAILS_COUNTRY_GEO_CODE_FK, KeyRegistry.TAX_CLASSIFICATION_DETAILS_TAX_CLASSIFICATION_FK); 181 } 182 183 private transient GeoCodesPath _txclsfndt_countrygeocodeid_fk; 184 185 /** 186 * Get the implicit join path to the <code>geocodes</code> table. 187 */ 188 public GeoCodesPath txclsfndt_countrygeocodeid_fk() { 189 if (_txclsfndt_countrygeocodeid_fk == null) 190 _txclsfndt_countrygeocodeid_fk = new GeoCodesPath(this, KeyRegistry.TAX_CLASSIFICATION_DETAILS_COUNTRY_GEO_CODE_FK, null); 191 192 return _txclsfndt_countrygeocodeid_fk; 193 } 194 195 private transient TaxClassificationsPath _txclsfndt_txclsfn_taxclassificationid_fk; 196 197 /** 198 * Get the implicit join path to the <code>taxclassifications</code> table. 199 */ 200 public TaxClassificationsPath txclsfndt_txclsfn_taxclassificationid_fk() { 201 if (_txclsfndt_txclsfn_taxclassificationid_fk == null) 202 _txclsfndt_txclsfn_taxclassificationid_fk = new TaxClassificationsPath(this, KeyRegistry.TAX_CLASSIFICATION_DETAILS_TAX_CLASSIFICATION_FK, null); 203 204 return _txclsfndt_txclsfn_taxclassificationid_fk; 205 } 206 207 @Override 208 public TaxClassificationDetails as(String alias) { 209 return new TaxClassificationDetails(DSL.name(alias), this); 210 } 211 212 @Override 213 public TaxClassificationDetails as(Name alias) { 214 return new TaxClassificationDetails(alias, this); 215 } 216 217 @Override 218 public TaxClassificationDetails as(Table<?> alias) { 219 return new TaxClassificationDetails(alias.getQualifiedName(), this); 220 } 221 222 /** 223 * Rename this table 224 */ 225 @Override 226 public TaxClassificationDetails rename(String name) { 227 return new TaxClassificationDetails(DSL.name(name), null); 228 } 229 230 /** 231 * Rename this table 232 */ 233 @Override 234 public TaxClassificationDetails rename(Name name) { 235 return new TaxClassificationDetails(name, null); 236 } 237 238 /** 239 * Rename this table 240 */ 241 @Override 242 public TaxClassificationDetails rename(Table<?> name) { 243 return new TaxClassificationDetails(name.getQualifiedName(), null); 244 } 245 246 /** 247 * Create an inline derived table from this table 248 */ 249 @Override 250 public TaxClassificationDetails where(Condition condition) { 251 return new TaxClassificationDetails(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 252 } 253 254 /** 255 * Create an inline derived table from this table 256 */ 257 @Override 258 public TaxClassificationDetails where(Collection<? extends Condition> conditions) { 259 return where(DSL.and(conditions)); 260 } 261 262 /** 263 * Create an inline derived table from this table 264 */ 265 @Override 266 public TaxClassificationDetails where(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 TaxClassificationDetails where(Field<Boolean> condition) { 275 return where(DSL.condition(condition)); 276 } 277 278 /** 279 * Create an inline derived table from this table 280 */ 281 @Override 282 @PlainSQL 283 public TaxClassificationDetails where(SQL condition) { 284 return where(DSL.condition(condition)); 285 } 286 287 /** 288 * Create an inline derived table from this table 289 */ 290 @Override 291 @PlainSQL 292 public TaxClassificationDetails where(@Stringly.SQL String condition) { 293 return where(DSL.condition(condition)); 294 } 295 296 /** 297 * Create an inline derived table from this table 298 */ 299 @Override 300 @PlainSQL 301 public TaxClassificationDetails where(@Stringly.SQL String condition, Object... binds) { 302 return where(DSL.condition(condition, binds)); 303 } 304 305 /** 306 * Create an inline derived table from this table 307 */ 308 @Override 309 @PlainSQL 310 public TaxClassificationDetails where(@Stringly.SQL String condition, QueryPart... parts) { 311 return where(DSL.condition(condition, parts)); 312 } 313 314 /** 315 * Create an inline derived table from this table 316 */ 317 @Override 318 public TaxClassificationDetails whereExists(TableLike<?> select) { 319 return where(DSL.exists(select)); 320 } 321 322 /** 323 * Create an inline derived table from this table 324 */ 325 @Override 326 public TaxClassificationDetails whereNotExists(TableLike<?> select) { 327 return where(DSL.notExists(select)); 328 } 329}