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