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.UnitOfMeasureKindPK; 008import com.echothree.model.data.uom.common.pk.UnitOfMeasureKindUsePK; 009import com.echothree.model.data.uom.common.pk.UnitOfMeasureKindUseTypePK; 010import com.echothree.model.jooq.server.KeyRegistry; 011import com.echothree.model.jooq.server.tables.uom.UnitOfMeasureKindUseTypes.UnitOfMeasureKindUseTypesPath; 012import com.echothree.model.jooq.server.tables.uom.UnitOfMeasureKinds.UnitOfMeasureKindsPath; 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.Name; 023import org.jooq.PlainSQL; 024import org.jooq.QueryPart; 025import org.jooq.SQL; 026import org.jooq.Stringly; 027import org.jooq.Table; 028import org.jooq.TableField; 029import org.jooq.TableLike; 030import org.jooq.TableOptions; 031import org.jooq.UniqueKey; 032import org.jooq.impl.DSL; 033import org.jooq.impl.Internal; 034import org.jooq.impl.SQLDataType; 035import org.jooq.impl.TableImpl; 036 037 038/** 039 * This class is generated by jOOQ. 040 */ 041@SuppressWarnings({ "all", "unchecked", "rawtypes", "this-escape" }) 042public class UnitOfMeasureKindUses extends TableImpl<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses> { 043 044 private static final long serialVersionUID = 1L; 045 046 /** 047 * The reference instance of <code>unitofmeasurekinduses</code> 048 */ 049 public static final UnitOfMeasureKindUses UnitOfMeasureKindUses = new UnitOfMeasureKindUses(); 050 051 /** 052 * The class holding records for this type 053 */ 054 @Override 055 public Class<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses> getRecordType() { 056 return com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses.class; 057 } 058 059 /** 060 * The column 061 * <code>unitofmeasurekinduses.uomku_unitofmeasurekinduseid</code>. 062 */ 063 public final TableField<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses, UnitOfMeasureKindUsePK> UNIT_OF_MEASURE_KIND_USE = createField(DSL.name("uomku_unitofmeasurekinduseid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, UnitOfMeasureKindUsePK.class, id -> new com.echothree.model.data.uom.common.pk.UnitOfMeasureKindUsePK(id), primaryKey -> primaryKey.getEntityId())); 064 065 /** 066 * The column 067 * <code>unitofmeasurekinduses.uomku_uomkut_unitofmeasurekindusetypeid</code>. 068 */ 069 public final TableField<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses, UnitOfMeasureKindUseTypePK> UNIT_OF_MEASURE_KIND_USE_TYPE = createField(DSL.name("uomku_uomkut_unitofmeasurekindusetypeid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, UnitOfMeasureKindUseTypePK.class, id -> new com.echothree.model.data.uom.common.pk.UnitOfMeasureKindUseTypePK(id), primaryKey -> primaryKey.getEntityId())); 070 071 /** 072 * The column 073 * <code>unitofmeasurekinduses.uomku_uomk_unitofmeasurekindid</code>. 074 */ 075 public final TableField<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses, UnitOfMeasureKindPK> UNIT_OF_MEASURE_KIND = createField(DSL.name("uomku_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())); 076 077 /** 078 * The column <code>unitofmeasurekinduses.uomku_isdefault</code>. 079 */ 080 public final TableField<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses, Boolean> IS_DEFAULT = createField(DSL.name("uomku_isdefault"), SQLDataType.BIT.nullable(false), this, ""); 081 082 /** 083 * The column <code>unitofmeasurekinduses.uomku_sortorder</code>. 084 */ 085 public final TableField<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses, Integer> SORT_ORDER = createField(DSL.name("uomku_sortorder"), SQLDataType.INTEGER.nullable(false), this, ""); 086 087 /** 088 * The column <code>unitofmeasurekinduses.uomku_fromtime</code>. 089 */ 090 public final TableField<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses, Long> FROM_TIME = createField(DSL.name("uomku_fromtime"), SQLDataType.BIGINT.nullable(false), this, ""); 091 092 /** 093 * The column <code>unitofmeasurekinduses.uomku_thrutime</code>. 094 */ 095 public final TableField<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses, Long> THRU_TIME = createField(DSL.name("uomku_thrutime"), SQLDataType.BIGINT.nullable(false), this, ""); 096 097 private UnitOfMeasureKindUses(Name alias, Table<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses> aliased) { 098 this(alias, aliased, (Field<?>[]) null, null); 099 } 100 101 private UnitOfMeasureKindUses(Name alias, Table<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses> aliased, Field<?>[] parameters, Condition where) { 102 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 103 } 104 105 /** 106 * Create an aliased <code>unitofmeasurekinduses</code> table reference 107 */ 108 public UnitOfMeasureKindUses(String alias) { 109 this(DSL.name(alias), UnitOfMeasureKindUses); 110 } 111 112 /** 113 * Create an aliased <code>unitofmeasurekinduses</code> table reference 114 */ 115 public UnitOfMeasureKindUses(Name alias) { 116 this(alias, UnitOfMeasureKindUses); 117 } 118 119 /** 120 * Create a <code>unitofmeasurekinduses</code> table reference 121 */ 122 public UnitOfMeasureKindUses() { 123 this(DSL.name("unitofmeasurekinduses"), null); 124 } 125 126 @Override 127 public UniqueKey<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses> getPrimaryKey() { 128 return KeyRegistry.UNIT_OF_MEASURE_KIND_USES_PK; 129 } 130 131 @Override 132 public List<UniqueKey<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses>> getUniqueKeys() { 133 return Arrays.asList(KeyRegistry.UNIT_OF_MEASURE_KIND_USES_UNIT_OF_MEASURE_KIND_USE_TYPE_AND_UNIT_OF_MEASURE_KIND_AND_THRU_TIME_UK); 134 } 135 136 @Override 137 public List<ForeignKey<com.echothree.model.jooq.server.records.uom.UnitOfMeasureKindUses, ?>> getReferences() { 138 return Arrays.asList(KeyRegistry.UNIT_OF_MEASURE_KIND_USES_UNIT_OF_MEASURE_KIND_FK, KeyRegistry.UNIT_OF_MEASURE_KIND_USES_UNIT_OF_MEASURE_KIND_USE_TYPE_FK); 139 } 140 141 private transient UnitOfMeasureKindsPath _uomku_uomk_unitofmeasurekindid_fk; 142 143 /** 144 * Get the implicit join path to the <code>unitofmeasurekinds</code> table. 145 */ 146 public UnitOfMeasureKindsPath uomku_uomk_unitofmeasurekindid_fk() { 147 if (_uomku_uomk_unitofmeasurekindid_fk == null) 148 _uomku_uomk_unitofmeasurekindid_fk = new UnitOfMeasureKindsPath(this, KeyRegistry.UNIT_OF_MEASURE_KIND_USES_UNIT_OF_MEASURE_KIND_FK, null); 149 150 return _uomku_uomk_unitofmeasurekindid_fk; 151 } 152 153 private transient UnitOfMeasureKindUseTypesPath _uomku_uomkut_unitofmeasurekindusetypeid_fk; 154 155 /** 156 * Get the implicit join path to the <code>unitofmeasurekindusetypes</code> 157 * table. 158 */ 159 public UnitOfMeasureKindUseTypesPath uomku_uomkut_unitofmeasurekindusetypeid_fk() { 160 if (_uomku_uomkut_unitofmeasurekindusetypeid_fk == null) 161 _uomku_uomkut_unitofmeasurekindusetypeid_fk = new UnitOfMeasureKindUseTypesPath(this, KeyRegistry.UNIT_OF_MEASURE_KIND_USES_UNIT_OF_MEASURE_KIND_USE_TYPE_FK, null); 162 163 return _uomku_uomkut_unitofmeasurekindusetypeid_fk; 164 } 165 166 @Override 167 public UnitOfMeasureKindUses as(String alias) { 168 return new UnitOfMeasureKindUses(DSL.name(alias), this); 169 } 170 171 @Override 172 public UnitOfMeasureKindUses as(Name alias) { 173 return new UnitOfMeasureKindUses(alias, this); 174 } 175 176 @Override 177 public UnitOfMeasureKindUses as(Table<?> alias) { 178 return new UnitOfMeasureKindUses(alias.getQualifiedName(), this); 179 } 180 181 /** 182 * Rename this table 183 */ 184 @Override 185 public UnitOfMeasureKindUses rename(String name) { 186 return new UnitOfMeasureKindUses(DSL.name(name), null); 187 } 188 189 /** 190 * Rename this table 191 */ 192 @Override 193 public UnitOfMeasureKindUses rename(Name name) { 194 return new UnitOfMeasureKindUses(name, null); 195 } 196 197 /** 198 * Rename this table 199 */ 200 @Override 201 public UnitOfMeasureKindUses rename(Table<?> name) { 202 return new UnitOfMeasureKindUses(name.getQualifiedName(), null); 203 } 204 205 /** 206 * Create an inline derived table from this table 207 */ 208 @Override 209 public UnitOfMeasureKindUses where(Condition condition) { 210 return new UnitOfMeasureKindUses(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 211 } 212 213 /** 214 * Create an inline derived table from this table 215 */ 216 @Override 217 public UnitOfMeasureKindUses where(Collection<? extends Condition> conditions) { 218 return where(DSL.and(conditions)); 219 } 220 221 /** 222 * Create an inline derived table from this table 223 */ 224 @Override 225 public UnitOfMeasureKindUses where(Condition... conditions) { 226 return where(DSL.and(conditions)); 227 } 228 229 /** 230 * Create an inline derived table from this table 231 */ 232 @Override 233 public UnitOfMeasureKindUses where(Field<Boolean> condition) { 234 return where(DSL.condition(condition)); 235 } 236 237 /** 238 * Create an inline derived table from this table 239 */ 240 @Override 241 @PlainSQL 242 public UnitOfMeasureKindUses where(SQL condition) { 243 return where(DSL.condition(condition)); 244 } 245 246 /** 247 * Create an inline derived table from this table 248 */ 249 @Override 250 @PlainSQL 251 public UnitOfMeasureKindUses where(@Stringly.SQL String condition) { 252 return where(DSL.condition(condition)); 253 } 254 255 /** 256 * Create an inline derived table from this table 257 */ 258 @Override 259 @PlainSQL 260 public UnitOfMeasureKindUses where(@Stringly.SQL String condition, Object... binds) { 261 return where(DSL.condition(condition, binds)); 262 } 263 264 /** 265 * Create an inline derived table from this table 266 */ 267 @Override 268 @PlainSQL 269 public UnitOfMeasureKindUses where(@Stringly.SQL String condition, QueryPart... parts) { 270 return where(DSL.condition(condition, parts)); 271 } 272 273 /** 274 * Create an inline derived table from this table 275 */ 276 @Override 277 public UnitOfMeasureKindUses whereExists(TableLike<?> select) { 278 return where(DSL.exists(select)); 279 } 280 281 /** 282 * Create an inline derived table from this table 283 */ 284 @Override 285 public UnitOfMeasureKindUses whereNotExists(TableLike<?> select) { 286 return where(DSL.notExists(select)); 287 } 288}