Alright, I've attached it.
On Thursday, September 13, 2012 12:19:39 PM UTC+2, Lukas Eder wrote:
>
> > It's rather long so I attached it here.
>
> I'm sorry, I meant the generated Table class, i.e.
> com.abbaba.tables.LaborTicket
>
> Cheers
> Lukas
>
/**
* This class is generated by jOOQ
*/
package com.abbaba.tables;
/**
* This class is generated by jOOQ.
*/
@javax.annotation.Generated(value = {"http://www.jooq.org";, "2.5.0"},
comments = "This class is generated by jOOQ")
public class LaborTicket extends org.jooq.impl.UpdatableTableImpl<com.abbaba.tables.records.LaborTicketRecord> {
private static final long serialVersionUID = -1467169129;
/**
* The singleton instance of dbo.LABOR_TICKET
*/
public static final com.abbaba.tables.LaborTicket LABOR_TICKET = new com.abbaba.tables.LaborTicket();
/**
* The class holding records for this type
*/
@Override
public java.lang.Class<com.abbaba.tables.records.LaborTicketRecord> getRecordType() {
return com.abbaba.tables.records.LaborTicketRecord.class;
}
/**
* The table column <code>dbo.LABOR_TICKET.ROWID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.Integer> ROWID = createField("ROWID", org.jooq.impl.SQLDataType.INTEGER, this);
/**
* The table column <code>dbo.LABOR_TICKET.TRANSACTION_ID</code>
* <p>
* This column is part of the table's PRIMARY KEY
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.Integer> TRANSACTION_ID = createField("TRANSACTION_ID", org.jooq.impl.SQLDataType.INTEGER, this);
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_TYPE</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> WORKORDER_TYPE = createField("WORKORDER_TYPE", org.jooq.impl.SQLDataType.CHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_BASE_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> WORKORDER_BASE_ID = createField("WORKORDER_BASE_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_LOT_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> WORKORDER_LOT_ID = createField("WORKORDER_LOT_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_SPLIT_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> WORKORDER_SPLIT_ID = createField("WORKORDER_SPLIT_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.WORKORDER_SUB_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> WORKORDER_SUB_ID = createField("WORKORDER_SUB_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.OPERATION_SEQ_NO</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.Short> OPERATION_SEQ_NO = createField("OPERATION_SEQ_NO", org.jooq.impl.SQLDataType.SMALLINT, this);
/**
* The table column <code>dbo.LABOR_TICKET.TYPE</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> TYPE = createField("TYPE", org.jooq.impl.SQLDataType.CHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.SETUP_COMPLETED</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> SETUP_COMPLETED = createField("SETUP_COMPLETED", org.jooq.impl.SQLDataType.CHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.EMPLOYEE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0086
* FOREIGN KEY (EMPLOYEE_ID)
* REFERENCES dbo.EMPLOYEE (ID)
* </pre></code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> EMPLOYEE_ID = createField("EMPLOYEE_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.DEPARTMENT_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> DEPARTMENT_ID = createField("DEPARTMENT_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.RESOURCE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0129
* FOREIGN KEY (RESOURCE_ID)
* REFERENCES dbo.SHOP_RESOURCE (ID)
* </pre></code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> RESOURCE_ID = createField("RESOURCE_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.HOURLY_COST</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> HOURLY_COST = createField("HOURLY_COST", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.CLOCK_IN</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.sql.Timestamp> CLOCK_IN = createField("CLOCK_IN", org.jooq.impl.SQLDataType.TIMESTAMP, this);
/**
* The table column <code>dbo.LABOR_TICKET.CLOCK_OUT</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.sql.Timestamp> CLOCK_OUT = createField("CLOCK_OUT", org.jooq.impl.SQLDataType.TIMESTAMP, this);
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_WORKED</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> HOURS_WORKED = createField("HOURS_WORKED", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_BREAK</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> HOURS_BREAK = createField("HOURS_BREAK", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.MULTIPLIER_1</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> MULTIPLIER_1 = createField("MULTIPLIER_1", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.MULTIPLIER_2</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> MULTIPLIER_2 = createField("MULTIPLIER_2", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.GOOD_QTY</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> GOOD_QTY = createField("GOOD_QTY", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.BAD_QTY</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> BAD_QTY = createField("BAD_QTY", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.TRANSACTION_DATE</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.sql.Timestamp> TRANSACTION_DATE = createField("TRANSACTION_DATE", org.jooq.impl.SQLDataType.TIMESTAMP, this);
/**
* The table column <code>dbo.LABOR_TICKET.DESCRIPTION</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> DESCRIPTION = createField("DESCRIPTION", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.USER_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> USER_ID = createField("USER_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.BURDEN_PER_HR</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> BURDEN_PER_HR = createField("BURDEN_PER_HR", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.BURDEN_PERCENT</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> BURDEN_PERCENT = createField("BURDEN_PERCENT", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.BUR_PER_OPERATION</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> BUR_PER_OPERATION = createField("BUR_PER_OPERATION", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.POSTING_CANDIDATE</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> POSTING_CANDIDATE = createField("POSTING_CANDIDATE", org.jooq.impl.SQLDataType.CHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_OVERALL</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> HOURS_OVERALL = createField("HOURS_OVERALL", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_PREVIOUS</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> HOURS_PREVIOUS = createField("HOURS_PREVIOUS", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.INDIRECT_CODE</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> INDIRECT_CODE = createField("INDIRECT_CODE", org.jooq.impl.SQLDataType.CHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.INDIRECT_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0048
* FOREIGN KEY (INDIRECT_ID)
* REFERENCES dbo.INDIRECT (ID)
* </pre></code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> INDIRECT_ID = createField("INDIRECT_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.SHIFT_DATE</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.sql.Timestamp> SHIFT_DATE = createField("SHIFT_DATE", org.jooq.impl.SQLDataType.TIMESTAMP, this);
/**
* The table column <code>dbo.LABOR_TICKET.BREAK_CLOCKIN</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.sql.Timestamp> BREAK_CLOCKIN = createField("BREAK_CLOCKIN", org.jooq.impl.SQLDataType.TIMESTAMP, this);
/**
* The table column <code>dbo.LABOR_TICKET.HOURS_BREAK_IND</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> HOURS_BREAK_IND = createField("HOURS_BREAK_IND", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.ACT_LABOR_COST</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> ACT_LABOR_COST = createField("ACT_LABOR_COST", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.ACT_BURDEN_COST</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> ACT_BURDEN_COST = createField("ACT_BURDEN_COST", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.CREATE_DATE</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.sql.Timestamp> CREATE_DATE = createField("CREATE_DATE", org.jooq.impl.SQLDataType.TIMESTAMP, this);
/**
* The table column <code>dbo.LABOR_TICKET.ACT_CLOCK_IN</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.sql.Timestamp> ACT_CLOCK_IN = createField("ACT_CLOCK_IN", org.jooq.impl.SQLDataType.TIMESTAMP, this);
/**
* The table column <code>dbo.LABOR_TICKET.ACT_CLOCK_OUT</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.sql.Timestamp> ACT_CLOCK_OUT = createField("ACT_CLOCK_OUT", org.jooq.impl.SQLDataType.TIMESTAMP, this);
/**
* The table column <code>dbo.LABOR_TICKET.STARTING_TRANS</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> STARTING_TRANS = createField("STARTING_TRANS", org.jooq.impl.SQLDataType.CHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.BURDEN_PER_UNIT</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> BURDEN_PER_UNIT = createField("BURDEN_PER_UNIT", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.UNIT_COST</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.math.BigDecimal> UNIT_COST = createField("UNIT_COST", org.jooq.impl.SQLDataType.NUMERIC, this);
/**
* The table column <code>dbo.LABOR_TICKET.GL_ACCT_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> GL_ACCT_ID = createField("GL_ACCT_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.EARNING_CODE_ID</code>
* <p>
* This column is part of a FOREIGN KEY: <code><pre>
* CONSTRAINT FKEY0051
* FOREIGN KEY (EARNING_CODE_ID)
* REFERENCES dbo.EARNING_CODE (ID)
* </pre></code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> EARNING_CODE_ID = createField("EARNING_CODE_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.BUDGET_ACCT_YEAR</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.Short> BUDGET_ACCT_YEAR = createField("BUDGET_ACCT_YEAR", org.jooq.impl.SQLDataType.SMALLINT, this);
/**
* The table column <code>dbo.LABOR_TICKET.BUDGET_ACCT_PERIOD</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.Byte> BUDGET_ACCT_PERIOD = createField("BUDGET_ACCT_PERIOD", org.jooq.impl.SQLDataType.TINYINT, this);
/**
* The table column <code>dbo.LABOR_TICKET.MILESTONE_TXN_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.Integer> MILESTONE_TXN_ID = createField("MILESTONE_TXN_ID", org.jooq.impl.SQLDataType.INTEGER, this);
/**
* The table column <code>dbo.LABOR_TICKET.MILESTONE_UPDATED</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> MILESTONE_UPDATED = createField("MILESTONE_UPDATED", org.jooq.impl.SQLDataType.CHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.COST_CATEGORY_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> COST_CATEGORY_ID = createField("COST_CATEGORY_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.AUTOGEN_TXN_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.Integer> AUTOGEN_TXN_ID = createField("AUTOGEN_TXN_ID", org.jooq.impl.SQLDataType.INTEGER, this);
/**
* The table column <code>dbo.LABOR_TICKET.UNADJ_CLOCK_IN</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.sql.Timestamp> UNADJ_CLOCK_IN = createField("UNADJ_CLOCK_IN", org.jooq.impl.SQLDataType.TIMESTAMP, this);
/**
* The table column <code>dbo.LABOR_TICKET.UNADJ_CLOCK_OUT</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.sql.Timestamp> UNADJ_CLOCK_OUT = createField("UNADJ_CLOCK_OUT", org.jooq.impl.SQLDataType.TIMESTAMP, this);
/**
* The table column <code>dbo.LABOR_TICKET.DEVIATION_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> DEVIATION_ID = createField("DEVIATION_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.DATA_COLL_COMP</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> DATA_COLL_COMP = createField("DATA_COLL_COMP", org.jooq.impl.SQLDataType.CHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.PRD_INSP_PLAN_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> PRD_INSP_PLAN_ID = createField("PRD_INSP_PLAN_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.ACT_RATE_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> ACT_RATE_ID = createField("ACT_RATE_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.ACT_PERIOD_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> ACT_PERIOD_ID = createField("ACT_PERIOD_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.RETRO_RATE_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> RETRO_RATE_ID = createField("RETRO_RATE_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.RETRO_PERIOD_ID</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> RETRO_PERIOD_ID = createField("RETRO_PERIOD_ID", org.jooq.impl.SQLDataType.VARCHAR, this);
/**
* The table column <code>dbo.LABOR_TICKET.RETRO_RATE_CODE</code>
*/
public final org.jooq.TableField<com.abbaba.tables.records.LaborTicketRecord, java.lang.String> RETRO_RATE_CODE = createField("RETRO_RATE_CODE", org.jooq.impl.SQLDataType.CHAR, this);
public LaborTicket() {
super("LABOR_TICKET", com.abbaba.Dbo.DBO);
}
public LaborTicket(java.lang.String alias) {
super(alias, com.abbaba.Dbo.DBO, com.abbaba.tables.LaborTicket.LABOR_TICKET);
}
@Override
public org.jooq.Identity<com.abbaba.tables.records.LaborTicketRecord, java.lang.Integer> getIdentity() {
return com.abbaba.Keys.IDENTITY_LABOR_TICKET;
}
@Override
public org.jooq.UniqueKey<com.abbaba.tables.records.LaborTicketRecord> getMainKey() {
return com.abbaba.Keys.PK_LABOR_TICKET;
}
@Override
@SuppressWarnings("unchecked")
public java.util.List<org.jooq.UniqueKey<com.abbaba.tables.records.LaborTicketRecord>> getKeys() {
return java.util.Arrays.<org.jooq.UniqueKey<com.abbaba.tables.records.LaborTicketRecord>>asList(com.abbaba.Keys.PK_LABOR_TICKET);
}
@Override
@SuppressWarnings("unchecked")
public java.util.List<org.jooq.ForeignKey<com.abbaba.tables.records.LaborTicketRecord, ?>> getReferences() {
return java.util.Arrays.<org.jooq.ForeignKey<com.abbaba.tables.records.LaborTicketRecord, ?>>asList(com.abbaba.Keys.FKEY0086, com.abbaba.Keys.FKEY0129, com.abbaba.Keys.FKEY0048, com.abbaba.Keys.FKEY0051);
}
@Override
public com.abbaba.tables.LaborTicket as(java.lang.String alias) {
return new com.abbaba.tables.LaborTicket(alias);
}
}
