// Path: src/main/java/com/clevergang/dbtests/repository/impl/jooq/generated/Public.java
// @Generated(
//     value = {
//         "http://www.jooq.org",
//         "jOOQ version:3.8.4"
//     },
//     comments = "This class is generated by jOOQ"
// )
// @SuppressWarnings({ "all", "unchecked", "rawtypes" })
// public class Public extends SchemaImpl {
// 
//     private static final long serialVersionUID = 1615711012;
// 
//     /**
//      * The reference instance of <code>public</code>
//      */
//     public static final Public PUBLIC = new Public();
// 
//     /**
//      * The table <code>public.company</code>.
//      */
//     public final Company COMPANY = com.clevergang.dbtests.repository.impl.jooq.generated.tables.Company.COMPANY;
// 
//     /**
//      * The table <code>public.department</code>.
//      */
//     public final Department DEPARTMENT = com.clevergang.dbtests.repository.impl.jooq.generated.tables.Department.DEPARTMENT;
// 
//     /**
//      * The table <code>public.employee</code>.
//      */
//     public final Employee EMPLOYEE = com.clevergang.dbtests.repository.impl.jooq.generated.tables.Employee.EMPLOYEE;
// 
//     /**
//      * The table <code>public.project</code>.
//      */
//     public final Project PROJECT = com.clevergang.dbtests.repository.impl.jooq.generated.tables.Project.PROJECT;
// 
//     /**
//      * The table <code>public.projectemployee</code>.
//      */
//     public final Projectemployee PROJECTEMPLOYEE = com.clevergang.dbtests.repository.impl.jooq.generated.tables.Projectemployee.PROJECTEMPLOYEE;
// 
//     /**
//      * No further instances allowed
//      */
//     private Public() {
//         super("public", null);
//     }
// 
// 
//     /**
//      * {@inheritDoc}
//      */
//     @Override
//     public Catalog getCatalog() {
//         return DefaultCatalog.DEFAULT_CATALOG;
//     }
// 
//     @Override
//     public final List<Sequence<?>> getSequences() {
//         List result = new ArrayList();
//         result.addAll(getSequences0());
//         return result;
//     }
// 
//     private final List<Sequence<?>> getSequences0() {
//         return Arrays.<Sequence<?>>asList(
//             Sequences.COMPANY_PID_SEQ,
//             Sequences.DEPARTMENT_PID_SEQ,
//             Sequences.EMPLOYEE_PID_SEQ,
//             Sequences.PROJECT_PID_SEQ);
//     }
// 
//     @Override
//     public final List<Table<?>> getTables() {
//         List result = new ArrayList();
//         result.addAll(getTables0());
//         return result;
//     }
// 
//     private final List<Table<?>> getTables0() {
//         return Arrays.<Table<?>>asList(
//             Company.COMPANY,
//             Department.DEPARTMENT,
//             Employee.EMPLOYEE,
//             Project.PROJECT,
//             Projectemployee.PROJECTEMPLOYEE);
//     }
// }


import com.clevergang.dbtests.repository.impl.jooq.generated.Public;
import org.jooq.Parameter;
import org.jooq.impl.AbstractRoutine;
import javax.annotation.Generated;
import java.math.BigDecimal;
/**
 * This class is generated by jOOQ
 */
package com.clevergang.dbtests.repository.impl.jooq.generated.routines;





/**
 * This class is generated by jOOQ.
 */
@Generated(
    value = {
        "http://www.jooq.org",
        "jOOQ version:3.8.4"
    },
    comments = "This class is generated by jOOQ"
)
@SuppressWarnings({ "all", "unchecked", "rawtypes" })
public class RegisterEmployee extends AbstractRoutine<java.lang.Void> {

    private static final long serialVersionUID = -1642852;

    /**
     * The parameter <code>public.register_employee._name</code>.
     */
    public static final Parameter<String> _NAME = createParameter("_name", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.register_employee._surname</code>.
     */
    public static final Parameter<String> _SURNAME = createParameter("_surname", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.register_employee._email</code>.
     */
    public static final Parameter<String> _EMAIL = createParameter("_email", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.register_employee._salary</code>.
     */
    public static final Parameter<BigDecimal> _SALARY = createParameter("_salary", org.jooq.impl.SQLDataType.NUMERIC, false, false);

    /**
     * The parameter <code>public.register_employee._department_name</code>.
     */
    public static final Parameter<String> _DEPARTMENT_NAME = createParameter("_department_name", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.register_employee._company_name</code>.
     */
    public static final Parameter<String> _COMPANY_NAME = createParameter("_company_name", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.register_employee.employee_id</code>.
     */
    public static final Parameter<Integer> EMPLOYEE_ID = createParameter("employee_id", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * The parameter <code>public.register_employee.department_id</code>.
     */
    public static final Parameter<Integer> DEPARTMENT_ID = createParameter("department_id", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * The parameter <code>public.register_employee.company_id</code>.
     */
    public static final Parameter<Integer> COMPANY_ID = createParameter("company_id", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * Create a new routine call instance
     */
    public RegisterEmployee() {
// Path: src/main/java/com/clevergang/dbtests/repository/impl/jooq/generated/Public.java
// @Generated(
//     value = {
//         "http://www.jooq.org",
//         "jOOQ version:3.8.4"
//     },
//     comments = "This class is generated by jOOQ"
// )
// @SuppressWarnings({ "all", "unchecked", "rawtypes" })
// public class Public extends SchemaImpl {
// 
//     private static final long serialVersionUID = 1615711012;
// 
//     /**
//      * The reference instance of <code>public</code>
//      */
//     public static final Public PUBLIC = new Public();
// 
//     /**
//      * The table <code>public.company</code>.
//      */
//     public final Company COMPANY = com.clevergang.dbtests.repository.impl.jooq.generated.tables.Company.COMPANY;
// 
//     /**
//      * The table <code>public.department</code>.
//      */
//     public final Department DEPARTMENT = com.clevergang.dbtests.repository.impl.jooq.generated.tables.Department.DEPARTMENT;
// 
//     /**
//      * The table <code>public.employee</code>.
//      */
//     public final Employee EMPLOYEE = com.clevergang.dbtests.repository.impl.jooq.generated.tables.Employee.EMPLOYEE;
// 
//     /**
//      * The table <code>public.project</code>.
//      */
//     public final Project PROJECT = com.clevergang.dbtests.repository.impl.jooq.generated.tables.Project.PROJECT;
// 
//     /**
//      * The table <code>public.projectemployee</code>.
//      */
//     public final Projectemployee PROJECTEMPLOYEE = com.clevergang.dbtests.repository.impl.jooq.generated.tables.Projectemployee.PROJECTEMPLOYEE;
// 
//     /**
//      * No further instances allowed
//      */
//     private Public() {
//         super("public", null);
//     }
// 
// 
//     /**
//      * {@inheritDoc}
//      */
//     @Override
//     public Catalog getCatalog() {
//         return DefaultCatalog.DEFAULT_CATALOG;
//     }
// 
//     @Override
//     public final List<Sequence<?>> getSequences() {
//         List result = new ArrayList();
//         result.addAll(getSequences0());
//         return result;
//     }
// 
//     private final List<Sequence<?>> getSequences0() {
//         return Arrays.<Sequence<?>>asList(
//             Sequences.COMPANY_PID_SEQ,
//             Sequences.DEPARTMENT_PID_SEQ,
//             Sequences.EMPLOYEE_PID_SEQ,
//             Sequences.PROJECT_PID_SEQ);
//     }
// 
//     @Override
//     public final List<Table<?>> getTables() {
//         List result = new ArrayList();
//         result.addAll(getTables0());
//         return result;
//     }
// 
//     private final List<Table<?>> getTables0() {
//         return Arrays.<Table<?>>asList(
//             Company.COMPANY,
//             Department.DEPARTMENT,
//             Employee.EMPLOYEE,
//             Project.PROJECT,
//             Projectemployee.PROJECTEMPLOYEE);
//     }
// }


// Path: src/main/java/com/clevergang/dbtests/repository/impl/jooq/generated/routines/RegisterEmployee.java
import com.clevergang.dbtests.repository.impl.jooq.generated.Public;
import org.jooq.Parameter;
import org.jooq.impl.AbstractRoutine;
import javax.annotation.Generated;
import java.math.BigDecimal;

/**
 * This class is generated by jOOQ
 */
package com.clevergang.dbtests.repository.impl.jooq.generated.routines;





/**
 * This class is generated by jOOQ.
 */
@Generated(
    value = {
        "http://www.jooq.org",
        "jOOQ version:3.8.4"
    },
    comments = "This class is generated by jOOQ"
)
@SuppressWarnings({ "all", "unchecked", "rawtypes" })
public class RegisterEmployee extends AbstractRoutine<java.lang.Void> {

    private static final long serialVersionUID = -1642852;

    /**
     * The parameter <code>public.register_employee._name</code>.
     */
    public static final Parameter<String> _NAME = createParameter("_name", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.register_employee._surname</code>.
     */
    public static final Parameter<String> _SURNAME = createParameter("_surname", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.register_employee._email</code>.
     */
    public static final Parameter<String> _EMAIL = createParameter("_email", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.register_employee._salary</code>.
     */
    public static final Parameter<BigDecimal> _SALARY = createParameter("_salary", org.jooq.impl.SQLDataType.NUMERIC, false, false);

    /**
     * The parameter <code>public.register_employee._department_name</code>.
     */
    public static final Parameter<String> _DEPARTMENT_NAME = createParameter("_department_name", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.register_employee._company_name</code>.
     */
    public static final Parameter<String> _COMPANY_NAME = createParameter("_company_name", org.jooq.impl.SQLDataType.CLOB, false, false);

    /**
     * The parameter <code>public.register_employee.employee_id</code>.
     */
    public static final Parameter<Integer> EMPLOYEE_ID = createParameter("employee_id", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * The parameter <code>public.register_employee.department_id</code>.
     */
    public static final Parameter<Integer> DEPARTMENT_ID = createParameter("department_id", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * The parameter <code>public.register_employee.company_id</code>.
     */
    public static final Parameter<Integer> COMPANY_ID = createParameter("company_id", org.jooq.impl.SQLDataType.INTEGER, false, false);

    /**
     * Create a new routine call instance
     */
    public RegisterEmployee() {
        super("register_employee", Public.PUBLIC);