cn.vertxup.workflow.domain.tables.WTicket Maven / Gradle / Ivy
The newest version!
/*
* This file is generated by jOOQ.
*/
package cn.vertxup.workflow.domain.tables;
import cn.vertxup.workflow.domain.Db;
import cn.vertxup.workflow.domain.Indexes;
import cn.vertxup.workflow.domain.Keys;
import cn.vertxup.workflow.domain.tables.records.WTicketRecord;
import org.jooq.Record;
import org.jooq.*;
import org.jooq.impl.DSL;
import org.jooq.impl.SQLDataType;
import org.jooq.impl.TableImpl;
import java.time.LocalDateTime;
import java.util.Arrays;
import java.util.List;
/**
* This class is generated by jOOQ.
*/
@SuppressWarnings({"all", "unchecked", "rawtypes"})
public class WTicket extends TableImpl {
/**
* The reference instance of DB_ETERNAL.W_TICKET
*/
public static final WTicket W_TICKET = new WTicket();
private static final long serialVersionUID = 1L;
/**
* The column DB_ETERNAL.W_TICKET.KEY. 「key」- 单据主键
*/
public final TableField KEY = createField(DSL.name("KEY"), SQLDataType.VARCHAR(36).nullable(false), this, "「key」- 单据主键");
/**
* The column DB_ETERNAL.W_TICKET.SERIAL. 「serial」- 单据编号，使用
* X_NUMBER 生成
*/
public final TableField SERIAL = createField(DSL.name("SERIAL"), SQLDataType.VARCHAR(255), this, "「serial」- 单据编号，使用 X_NUMBER 生成");
/**
* The column DB_ETERNAL.W_TICKET.NAME. 「name」- 单据标题
*/
public final TableField NAME = createField(DSL.name("NAME"), SQLDataType.VARCHAR(255), this, "「name」- 单据标题");
/**
* The column DB_ETERNAL.W_TICKET.CODE. 「code」- 单据系统编号（内码）
*/
public final TableField CODE = createField(DSL.name("CODE"), SQLDataType.VARCHAR(36), this, "「code」- 单据系统编号（内码）");
/**
* The column DB_ETERNAL.W_TICKET.TYPE. 「type」- 主单类型类型
*/
public final TableField TYPE = createField(DSL.name("TYPE"), SQLDataType.VARCHAR(36), this, "「type」- 主单类型类型");
/**
* The column DB_ETERNAL.W_TICKET.PHASE. 「phase」-
* 主单据所属阶段（状态描述，由于挂TODO，所以不使用status）
*/
public final TableField PHASE = createField(DSL.name("PHASE"), SQLDataType.VARCHAR(36), this, "「phase」- 主单据所属阶段（状态描述，由于挂TODO，所以不使用status）");
/**
* The column DB_ETERNAL.W_TICKET.MODEL_ID. 「modelId」-
* 关联的模型identifier，用于描述
*/
public final TableField MODEL_ID = createField(DSL.name("MODEL_ID"), SQLDataType.VARCHAR(255), this, "「modelId」- 关联的模型identifier，用于描述");
/**
* The column DB_ETERNAL.W_TICKET.MODEL_KEY. 「modelKey」-
* 关联的模型记录ID，用于描述哪一个Model中的记录
*/
public final TableField MODEL_KEY = createField(DSL.name("MODEL_KEY"), SQLDataType.VARCHAR(36), this, "「modelKey」- 关联的模型记录ID，用于描述哪一个Model中的记录");
/**
* The column DB_ETERNAL.W_TICKET.MODEL_CATEGORY.
* 「modelCategory」- 关联的category记录，只包含叶节点
*/
public final TableField MODEL_CATEGORY = createField(DSL.name("MODEL_CATEGORY"), SQLDataType.VARCHAR(128), this, "「modelCategory」- 关联的category记录，只包含叶节点");
/**
* The column DB_ETERNAL.W_TICKET.MODEL_COMPONENT.
* 「modelComponent」- 关联的待办组件记录
*/
public final TableField MODEL_COMPONENT = createField(DSL.name("MODEL_COMPONENT"), SQLDataType.VARCHAR(255), this, "「modelComponent」- 关联的待办组件记录");
/**
* The column DB_ETERNAL.W_TICKET.MODEL_CHILD. 「modelChild」-
* 关联多个模型的记录ID，JsonArray格式
*/
public final TableField MODEL_CHILD = createField(DSL.name("MODEL_CHILD"), SQLDataType.CLOB, this, "「modelChild」- 关联多个模型的记录ID，JsonArray格式");
/**
* The column DB_ETERNAL.W_TICKET.QUANTITY. 「quantity」-
* 数量信息，多个模型记录时统计模型总数
*/
public final TableField QUANTITY = createField(DSL.name("QUANTITY"), SQLDataType.INTEGER, this, "「quantity」- 数量信息，多个模型记录时统计模型总数");
/**
* The column DB_ETERNAL.W_TICKET.FLOW_DEFINITION_KEY.
* 「flowDefinitionKey」- 流程定义的KEY, getProcessDefinitionKey
*/
public final TableField FLOW_DEFINITION_KEY = createField(DSL.name("FLOW_DEFINITION_KEY"), SQLDataType.VARCHAR(64), this, "「flowDefinitionKey」- 流程定义的KEY, getProcessDefinitionKey");
/**
* The column DB_ETERNAL.W_TICKET.FLOW_DEFINITION_ID.
* 「flowDefinitionId」- 流程定义的ID，getProcessDefinitionKey
*/
public final TableField FLOW_DEFINITION_ID = createField(DSL.name("FLOW_DEFINITION_ID"), SQLDataType.VARCHAR(64), this, "「flowDefinitionId」- 流程定义的ID，getProcessDefinitionKey");
/**
* The column DB_ETERNAL.W_TICKET.FLOW_INSTANCE_ID.
* 「flowInstanceId」- 流程定义的ID，getProcessId
*/
public final TableField FLOW_INSTANCE_ID = createField(DSL.name("FLOW_INSTANCE_ID"), SQLDataType.VARCHAR(64), this, "「flowInstanceId」- 流程定义的ID，getProcessId");
/**
* The column DB_ETERNAL.W_TICKET.FLOW_END. 「flowEnd」- 主单是否执行完成
*/
public final TableField FLOW_END = createField(DSL.name("FLOW_END"), SQLDataType.BIT, this, "「flowEnd」- 主单是否执行完成");
/**
* The column DB_ETERNAL.W_TICKET.TITLE. 「title」- 主单业务标题
*/
public final TableField TITLE = createField(DSL.name("TITLE"), SQLDataType.VARCHAR(1024), this, "「title」- 主单业务标题");
/**
* The column DB_ETERNAL.W_TICKET.DESCRIPTION. 「description」-
* 主单描述内容
*/
public final TableField DESCRIPTION = createField(DSL.name("DESCRIPTION"), SQLDataType.CLOB, this, "「description」- 主单描述内容");
/**
* The column DB_ETERNAL.W_TICKET.CATALOG. 「catalog」- 关联服务目录
*/
public final TableField CATALOG = createField(DSL.name("CATALOG"), SQLDataType.VARCHAR(36), this, "「catalog」- 关联服务目录");
/**
* The column DB_ETERNAL.W_TICKET.CATEGORY. 「category」- 业务类别
*/
public final TableField CATEGORY = createField(DSL.name("CATEGORY"), SQLDataType.VARCHAR(36), this, "「category」- 业务类别");
/**
* The column DB_ETERNAL.W_TICKET.CATEGORY_SUB. 「categorySub」-
* 子类别
*/
public final TableField CATEGORY_SUB = createField(DSL.name("CATEGORY_SUB"), SQLDataType.VARCHAR(36), this, "「categorySub」- 子类别");
/**
* The column DB_ETERNAL.W_TICKET.OWNER. 「owner」- 制单人/拥有者
*/
public final TableField OWNER = createField(DSL.name("OWNER"), SQLDataType.VARCHAR(36), this, "「owner」- 制单人/拥有者");
/**
* The column DB_ETERNAL.W_TICKET.SUPERVISOR. 「supervisor」- 监督人
*/
public final TableField SUPERVISOR = createField(DSL.name("SUPERVISOR"), SQLDataType.VARCHAR(36), this, "「supervisor」- 监督人");
/**
* The column DB_ETERNAL.W_TICKET.OPEN_BY. 「openBy」- 开单人
*/
public final TableField OPEN_BY = createField(DSL.name("OPEN_BY"), SQLDataType.VARCHAR(36), this, "「openBy」- 开单人");
/**
* The column DB_ETERNAL.W_TICKET.OPEN_GROUP. 「openGroup」- 开单组
*/
public final TableField OPEN_GROUP = createField(DSL.name("OPEN_GROUP"), SQLDataType.VARCHAR(36), this, "「openGroup」- 开单组");
/**
* The column DB_ETERNAL.W_TICKET.OPEN_AT. 「openAt」- 开单时间
*/
public final TableField OPEN_AT = createField(DSL.name("OPEN_AT"), SQLDataType.LOCALDATETIME(0), this, "「openAt」- 开单时间");
/**
* The column DB_ETERNAL.W_TICKET.CANCEL_BY. 「cancelBy」- 中断人
*/
public final TableField CANCEL_BY = createField(DSL.name("CANCEL_BY"), SQLDataType.VARCHAR(36), this, "「cancelBy」- 中断人");
/**
* The column DB_ETERNAL.W_TICKET.CANCEL_AT. 「cancelAt」- 中断时间
*/
public final TableField CANCEL_AT = createField(DSL.name("CANCEL_AT"), SQLDataType.LOCALDATETIME(0), this, "「cancelAt」- 中断时间");
/**
* The column DB_ETERNAL.W_TICKET.CLOSE_BY. 「closeBy」- 关闭人
*/
public final TableField CLOSE_BY = createField(DSL.name("CLOSE_BY"), SQLDataType.VARCHAR(36), this, "「closeBy」- 关闭人");
/**
* The column DB_ETERNAL.W_TICKET.CLOSE_AT. 「closeAt」- 关闭时间
*/
public final TableField CLOSE_AT = createField(DSL.name("CLOSE_AT"), SQLDataType.LOCALDATETIME(0), this, "「closeAt」- 关闭时间");
/**
* The column DB_ETERNAL.W_TICKET.CLOSE_SOLUTION.
* 「closeSolution」- 关闭解决方案
*/
public final TableField CLOSE_SOLUTION = createField(DSL.name("CLOSE_SOLUTION"), SQLDataType.CLOB, this, "「closeSolution」- 关闭解决方案");
/**
* The column DB_ETERNAL.W_TICKET.CLOSE_CODE. 「closeCode」- 关闭代码
*/
public final TableField CLOSE_CODE = createField(DSL.name("CLOSE_CODE"), SQLDataType.VARCHAR(255), this, "「closeCode」- 关闭代码");
/**
* The column DB_ETERNAL.W_TICKET.CLOSE_KB. 「closeKb」-
* 关闭时KB链接地址
*/
public final TableField CLOSE_KB = createField(DSL.name("CLOSE_KB"), SQLDataType.VARCHAR(1024), this, "「closeKb」- 关闭时KB链接地址");
/**
* The column DB_ETERNAL.W_TICKET.ACTIVE. 「active」- 是否启用
*/
public final TableField ACTIVE = createField(DSL.name("ACTIVE"), SQLDataType.BIT, this, "「active」- 是否启用");
/**
* The column DB_ETERNAL.W_TICKET.SIGMA. 「sigma」- 统一标识
*/
public final TableField SIGMA = createField(DSL.name("SIGMA"), SQLDataType.VARCHAR(32), this, "「sigma」- 统一标识");
/**
* The column DB_ETERNAL.W_TICKET.METADATA. 「metadata」- 附加配置
*/
public final TableField METADATA = createField(DSL.name("METADATA"), SQLDataType.CLOB, this, "「metadata」- 附加配置");
/**
* The column DB_ETERNAL.W_TICKET.LANGUAGE. 「language」- 使用的语言
*/
public final TableField LANGUAGE = createField(DSL.name("LANGUAGE"), SQLDataType.VARCHAR(8), this, "「language」- 使用的语言");
/**
* The column DB_ETERNAL.W_TICKET.CREATED_AT. 「createdAt」- 创建时间
*/
public final TableField CREATED_AT = createField(DSL.name("CREATED_AT"), SQLDataType.LOCALDATETIME(0), this, "「createdAt」- 创建时间");
/**
* The column DB_ETERNAL.W_TICKET.CREATED_BY. 「createdBy」- 创建人
*/
public final TableField CREATED_BY = createField(DSL.name("CREATED_BY"), SQLDataType.VARCHAR(36), this, "「createdBy」- 创建人");
/**
* The column DB_ETERNAL.W_TICKET.UPDATED_AT. 「updatedAt」- 更新时间
*/
public final TableField UPDATED_AT = createField(DSL.name("UPDATED_AT"), SQLDataType.LOCALDATETIME(0), this, "「updatedAt」- 更新时间");
/**
* The column DB_ETERNAL.W_TICKET.UPDATED_BY. 「updatedBy」- 更新人
*/
public final TableField UPDATED_BY = createField(DSL.name("UPDATED_BY"), SQLDataType.VARCHAR(36), this, "「updatedBy」- 更新人");
private WTicket(Name alias, Table aliased) {
this(alias, aliased, null);
}
private WTicket(Name alias, Table aliased, Field[] parameters) {
super(alias, null, aliased, parameters, DSL.comment(""), TableOptions.table());
}
/**
* Create an aliased DB_ETERNAL.W_TICKET table reference
*/
public WTicket(String alias) {
this(DSL.name(alias), W_TICKET);
}
/**
* Create an aliased DB_ETERNAL.W_TICKET table reference
*/
public WTicket(Name alias) {
this(alias, W_TICKET);
}
/**
* Create a DB_ETERNAL.W_TICKET table reference
*/
public WTicket() {
this(DSL.name("W_TICKET"), null);
}
public WTicket(Table child, ForeignKey key) {
super(child, key, W_TICKET);
}
/**
* The class holding records for this type
*/
@Override
public Class getRecordType() {
return WTicketRecord.class;
}
@Override
public Schema getSchema() {
return aliased() ? null : Db.DB_ETERNAL;
}
@Override
public List getIndexes() {
return Arrays.asList(Indexes.W_TICKET_IDXM_W_TICKET_SIGMA_CATALOG, Indexes.W_TICKET_IDXM_W_TICKET_SIGMA_FLOW_DEFINITION_KEY, Indexes.W_TICKET_IDXM_W_TICKET_SIGMA_STATUS, Indexes.W_TICKET_IDXM_W_TICKET_SIGMA_TYPE_STATUS);
}
@Override
public UniqueKey getPrimaryKey() {
return Keys.KEY_W_TICKET_PRIMARY;
}
@Override
public List> getUniqueKeys() {
return Arrays.asList(Keys.KEY_W_TICKET_SIGMA_2, Keys.KEY_W_TICKET_SIGMA);
}
@Override
public WTicket as(String alias) {
return new WTicket(DSL.name(alias), this);
}
@Override
public WTicket as(Name alias) {
return new WTicket(alias, this);
}
@Override
public WTicket as(Table alias) {
return new WTicket(alias.getQualifiedName(), this);
}
/**
* Rename this table
*/
@Override
public WTicket rename(String name) {
return new WTicket(DSL.name(name), null);
}
/**
* Rename this table
*/
@Override
public WTicket rename(Name name) {
return new WTicket(name, null);
}
/**
* Rename this table
*/
@Override
public WTicket rename(Table name) {
return new WTicket(name.getQualifiedName(), null);
}
}