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