001/* 002 * This file is generated by jOOQ. 003 */ 004package com.echothree.model.jooq.server.tables.content; 005 006 007import com.echothree.model.data.content.common.pk.ContentCollectionDescriptionPK; 008import com.echothree.model.data.content.common.pk.ContentCollectionPK; 009import com.echothree.model.data.party.common.pk.LanguagePK; 010import com.echothree.model.jooq.server.KeyRegistry; 011import com.echothree.model.jooq.server.tables.content.ContentCollections.ContentCollectionsPath; 012import com.echothree.model.jooq.server.tables.party.Languages.LanguagesPath; 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 ContentCollectionDescriptions extends TableImpl<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions> { 043 044 private static final long serialVersionUID = 1L; 045 046 /** 047 * The reference instance of <code>contentcollectiondescriptions</code> 048 */ 049 public static final ContentCollectionDescriptions ContentCollectionDescriptions = new ContentCollectionDescriptions(); 050 051 /** 052 * The class holding records for this type 053 */ 054 @Override 055 public Class<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions> getRecordType() { 056 return com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions.class; 057 } 058 059 /** 060 * The column 061 * <code>contentcollectiondescriptions.cntcd_contentcollectiondescriptionid</code>. 062 */ 063 public final TableField<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions, ContentCollectionDescriptionPK> CONTENT_COLLECTION_DESCRIPTION = createField(DSL.name("cntcd_contentcollectiondescriptionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ContentCollectionDescriptionPK.class, id -> new com.echothree.model.data.content.common.pk.ContentCollectionDescriptionPK(id), primaryKey -> primaryKey.getEntityId())); 064 065 /** 066 * The column 067 * <code>contentcollectiondescriptions.cntcd_cntc_contentcollectionid</code>. 068 */ 069 public final TableField<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions, ContentCollectionPK> CONTENT_COLLECTION = createField(DSL.name("cntcd_cntc_contentcollectionid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, ContentCollectionPK.class, id -> new com.echothree.model.data.content.common.pk.ContentCollectionPK(id), primaryKey -> primaryKey.getEntityId())); 070 071 /** 072 * The column 073 * <code>contentcollectiondescriptions.cntcd_lang_languageid</code>. 074 */ 075 public final TableField<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions, LanguagePK> LANGUAGE = createField(DSL.name("cntcd_lang_languageid"), SQLDataType.BIGINT.nullable(false), this, "", Converter.ofNullable(Long.class, LanguagePK.class, id -> new com.echothree.model.data.party.common.pk.LanguagePK(id), primaryKey -> primaryKey.getEntityId())); 076 077 /** 078 * The column <code>contentcollectiondescriptions.cntcd_description</code>. 079 */ 080 public final TableField<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions, String> DESCRIPTION = createField(DSL.name("cntcd_description"), SQLDataType.VARCHAR(132).nullable(false), this, ""); 081 082 /** 083 * The column <code>contentcollectiondescriptions.cntcd_fromtime</code>. 084 */ 085 public final TableField<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions, Long> FROM_TIME = createField(DSL.name("cntcd_fromtime"), SQLDataType.BIGINT.nullable(false), this, ""); 086 087 /** 088 * The column <code>contentcollectiondescriptions.cntcd_thrutime</code>. 089 */ 090 public final TableField<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions, Long> THRU_TIME = createField(DSL.name("cntcd_thrutime"), SQLDataType.BIGINT.nullable(false), this, ""); 091 092 private ContentCollectionDescriptions(Name alias, Table<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions> aliased) { 093 this(alias, aliased, (Field<?>[]) null, null); 094 } 095 096 private ContentCollectionDescriptions(Name alias, Table<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions> aliased, Field<?>[] parameters, Condition where) { 097 super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table(), where); 098 } 099 100 /** 101 * Create an aliased <code>contentcollectiondescriptions</code> table 102 * reference 103 */ 104 public ContentCollectionDescriptions(String alias) { 105 this(DSL.name(alias), ContentCollectionDescriptions); 106 } 107 108 /** 109 * Create an aliased <code>contentcollectiondescriptions</code> table 110 * reference 111 */ 112 public ContentCollectionDescriptions(Name alias) { 113 this(alias, ContentCollectionDescriptions); 114 } 115 116 /** 117 * Create a <code>contentcollectiondescriptions</code> table reference 118 */ 119 public ContentCollectionDescriptions() { 120 this(DSL.name("contentcollectiondescriptions"), null); 121 } 122 123 @Override 124 public UniqueKey<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions> getPrimaryKey() { 125 return KeyRegistry.CONTENT_COLLECTION_DESCRIPTIONS_PK; 126 } 127 128 @Override 129 public List<ForeignKey<com.echothree.model.jooq.server.records.content.ContentCollectionDescriptions, ?>> getReferences() { 130 return Arrays.asList(KeyRegistry.CONTENT_COLLECTION_DESCRIPTIONS_CONTENT_COLLECTION_FK, KeyRegistry.CONTENT_COLLECTION_DESCRIPTIONS_LANGUAGE_FK); 131 } 132 133 private transient ContentCollectionsPath _cntcd_cntc_contentcollectionid_fk; 134 135 /** 136 * Get the implicit join path to the <code>contentcollections</code> table. 137 */ 138 public ContentCollectionsPath cntcd_cntc_contentcollectionid_fk() { 139 if (_cntcd_cntc_contentcollectionid_fk == null) 140 _cntcd_cntc_contentcollectionid_fk = new ContentCollectionsPath(this, KeyRegistry.CONTENT_COLLECTION_DESCRIPTIONS_CONTENT_COLLECTION_FK, null); 141 142 return _cntcd_cntc_contentcollectionid_fk; 143 } 144 145 private transient LanguagesPath _cntcd_lang_languageid_fk; 146 147 /** 148 * Get the implicit join path to the <code>languages</code> table. 149 */ 150 public LanguagesPath cntcd_lang_languageid_fk() { 151 if (_cntcd_lang_languageid_fk == null) 152 _cntcd_lang_languageid_fk = new LanguagesPath(this, KeyRegistry.CONTENT_COLLECTION_DESCRIPTIONS_LANGUAGE_FK, null); 153 154 return _cntcd_lang_languageid_fk; 155 } 156 157 @Override 158 public ContentCollectionDescriptions as(String alias) { 159 return new ContentCollectionDescriptions(DSL.name(alias), this); 160 } 161 162 @Override 163 public ContentCollectionDescriptions as(Name alias) { 164 return new ContentCollectionDescriptions(alias, this); 165 } 166 167 @Override 168 public ContentCollectionDescriptions as(Table<?> alias) { 169 return new ContentCollectionDescriptions(alias.getQualifiedName(), this); 170 } 171 172 /** 173 * Rename this table 174 */ 175 @Override 176 public ContentCollectionDescriptions rename(String name) { 177 return new ContentCollectionDescriptions(DSL.name(name), null); 178 } 179 180 /** 181 * Rename this table 182 */ 183 @Override 184 public ContentCollectionDescriptions rename(Name name) { 185 return new ContentCollectionDescriptions(name, null); 186 } 187 188 /** 189 * Rename this table 190 */ 191 @Override 192 public ContentCollectionDescriptions rename(Table<?> name) { 193 return new ContentCollectionDescriptions(name.getQualifiedName(), null); 194 } 195 196 /** 197 * Create an inline derived table from this table 198 */ 199 @Override 200 public ContentCollectionDescriptions where(Condition condition) { 201 return new ContentCollectionDescriptions(getQualifiedName(), aliased() ? this : null, null, Internal.condition(this, condition)); 202 } 203 204 /** 205 * Create an inline derived table from this table 206 */ 207 @Override 208 public ContentCollectionDescriptions where(Collection<? extends Condition> conditions) { 209 return where(DSL.and(conditions)); 210 } 211 212 /** 213 * Create an inline derived table from this table 214 */ 215 @Override 216 public ContentCollectionDescriptions where(Condition... conditions) { 217 return where(DSL.and(conditions)); 218 } 219 220 /** 221 * Create an inline derived table from this table 222 */ 223 @Override 224 public ContentCollectionDescriptions where(Field<Boolean> condition) { 225 return where(DSL.condition(condition)); 226 } 227 228 /** 229 * Create an inline derived table from this table 230 */ 231 @Override 232 @PlainSQL 233 public ContentCollectionDescriptions where(SQL 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 ContentCollectionDescriptions where(@Stringly.SQL String 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 ContentCollectionDescriptions where(@Stringly.SQL String condition, Object... binds) { 252 return where(DSL.condition(condition, binds)); 253 } 254 255 /** 256 * Create an inline derived table from this table 257 */ 258 @Override 259 @PlainSQL 260 public ContentCollectionDescriptions where(@Stringly.SQL String condition, QueryPart... parts) { 261 return where(DSL.condition(condition, parts)); 262 } 263 264 /** 265 * Create an inline derived table from this table 266 */ 267 @Override 268 public ContentCollectionDescriptions whereExists(TableLike<?> select) { 269 return where(DSL.exists(select)); 270 } 271 272 /** 273 * Create an inline derived table from this table 274 */ 275 @Override 276 public ContentCollectionDescriptions whereNotExists(TableLike<?> select) { 277 return where(DSL.notExists(select)); 278 } 279}