/**
 * This class is generated by jOOQ
 */
package classes;


import classes.tables.PersonSchedule;
import classes.tables.PersonShop;
import classes.tables.Persons;
import classes.tables.PositionSalary;
import classes.tables.Positions;
import classes.tables.ProductAmounts;
import classes.tables.ProductPrices;
import classes.tables.ProductTypes;
import classes.tables.Products;
import classes.tables.SellLog;
import classes.tables.Shops;
import classes.tables.records.PersonScheduleRecord;
import classes.tables.records.PersonShopRecord;
import classes.tables.records.PersonsRecord;
import classes.tables.records.PositionSalaryRecord;
import classes.tables.records.PositionsRecord;
import classes.tables.records.ProductAmountsRecord;
import classes.tables.records.ProductPricesRecord;
import classes.tables.records.ProductTypesRecord;
import classes.tables.records.ProductsRecord;
import classes.tables.records.SellLogRecord;
import classes.tables.records.ShopsRecord;

import javax.annotation.Generated;

import org.jooq.ForeignKey;
import org.jooq.Identity;
import org.jooq.UniqueKey;
import org.jooq.impl.AbstractKeys;


/**
 * A class modelling foreign key relationships between tables of the <code>public</code> 
 * schema
 */
@Generated(
    value = {
        "http://www.jooq.org",
        "jOOQ version:3.8.6"
    },
    comments = "This class is generated by jOOQ"
)
@SuppressWarnings({ "all", "unchecked", "rawtypes" })
public class Keys {

    // -------------------------------------------------------------------------
    // IDENTITY definitions
    // -------------------------------------------------------------------------

    public static final Identity<PersonsRecord, Integer> IDENTITY_PERSONS = Identities0.IDENTITY_PERSONS;
    public static final Identity<PositionsRecord, Integer> IDENTITY_POSITIONS = Identities0.IDENTITY_POSITIONS;
    public static final Identity<ProductAmountsRecord, Integer> IDENTITY_PRODUCT_AMOUNTS = Identities0.IDENTITY_PRODUCT_AMOUNTS;
    public static final Identity<ProductPricesRecord, Integer> IDENTITY_PRODUCT_PRICES = Identities0.IDENTITY_PRODUCT_PRICES;
    public static final Identity<ProductTypesRecord, Integer> IDENTITY_PRODUCT_TYPES = Identities0.IDENTITY_PRODUCT_TYPES;
    public static final Identity<ProductsRecord, Integer> IDENTITY_PRODUCTS = Identities0.IDENTITY_PRODUCTS;
    public static final Identity<SellLogRecord, Integer> IDENTITY_SELL_LOG = Identities0.IDENTITY_SELL_LOG;
    public static final Identity<ShopsRecord, Integer> IDENTITY_SHOPS = Identities0.IDENTITY_SHOPS;

    // -------------------------------------------------------------------------
    // UNIQUE and PRIMARY KEY definitions
    // -------------------------------------------------------------------------

    public static final UniqueKey<PersonScheduleRecord> PERSON_SCHEDULE_PKEY = UniqueKeys0.PERSON_SCHEDULE_PKEY;
    public static final UniqueKey<PersonShopRecord> PERSON_SHOP_PKEY = UniqueKeys0.PERSON_SHOP_PKEY;
    public static final UniqueKey<PersonsRecord> PERSONS_PKEY = UniqueKeys0.PERSONS_PKEY;
    public static final UniqueKey<PersonsRecord> PASSPORT_KEY = UniqueKeys0.PASSPORT_KEY;
    public static final UniqueKey<PositionSalaryRecord> POSITION_SALARY_PKEY = UniqueKeys0.POSITION_SALARY_PKEY;
    public static final UniqueKey<PositionsRecord> POSITIONS_PKEY = UniqueKeys0.POSITIONS_PKEY;
    public static final UniqueKey<ProductAmountsRecord> PRODUCT_AMOUNTS_PKEY = UniqueKeys0.PRODUCT_AMOUNTS_PKEY;
    public static final UniqueKey<ProductPricesRecord> PRODUCT_PRICES_PKEY = UniqueKeys0.PRODUCT_PRICES_PKEY;
    public static final UniqueKey<ProductTypesRecord> PRODUCT_TYPES_PKEY = UniqueKeys0.PRODUCT_TYPES_PKEY;
    public static final UniqueKey<ProductTypesRecord> TITLE_UNIQ_KEY = UniqueKeys0.TITLE_UNIQ_KEY;
    public static final UniqueKey<ProductsRecord> PRODUCTS_PKEY = UniqueKeys0.PRODUCTS_PKEY;
    public static final UniqueKey<SellLogRecord> NEWTABLE_PK = UniqueKeys0.NEWTABLE_PK;
    public static final UniqueKey<ShopsRecord> SHOPS_PKEY = UniqueKeys0.SHOPS_PKEY;
    public static final UniqueKey<ShopsRecord> STREETS_UNIQ_KEY = UniqueKeys0.STREETS_UNIQ_KEY;

    // -------------------------------------------------------------------------
    // FOREIGN KEY definitions
    // -------------------------------------------------------------------------

    public static final ForeignKey<PersonScheduleRecord, PersonsRecord> PERSON_SCHEDULE__TTT = ForeignKeys0.PERSON_SCHEDULE__TTT;
    public static final ForeignKey<PersonShopRecord, PersonsRecord> PERSON_SHOP__TTT = ForeignKeys0.PERSON_SHOP__TTT;
    public static final ForeignKey<PersonShopRecord, ShopsRecord> PERSON_SHOP__FK_SHOP_ID = ForeignKeys0.PERSON_SHOP__FK_SHOP_ID;
    public static final ForeignKey<PersonsRecord, PositionsRecord> PERSONS__FK_POSITION_ID = ForeignKeys0.PERSONS__FK_POSITION_ID;
    public static final ForeignKey<PositionSalaryRecord, PositionsRecord> POSITION_SALARY__FK_POSITION_ID = ForeignKeys0.POSITION_SALARY__FK_POSITION_ID;
    public static final ForeignKey<PositionSalaryRecord, ShopsRecord> POSITION_SALARY__FK_SHOP_ID = ForeignKeys0.POSITION_SALARY__FK_SHOP_ID;
    public static final ForeignKey<ProductAmountsRecord, ProductsRecord> PRODUCT_AMOUNTS__FK_PRODUCT_ID = ForeignKeys0.PRODUCT_AMOUNTS__FK_PRODUCT_ID;
    public static final ForeignKey<ProductAmountsRecord, ShopsRecord> PRODUCT_AMOUNTS__FK_SHOP_ID = ForeignKeys0.PRODUCT_AMOUNTS__FK_SHOP_ID;
    public static final ForeignKey<ProductPricesRecord, ProductsRecord> PRODUCT_PRICES__FK_PRODUCT_ID = ForeignKeys0.PRODUCT_PRICES__FK_PRODUCT_ID;
    public static final ForeignKey<ProductPricesRecord, ShopsRecord> PRODUCT_PRICES__FK_SHOP_ID = ForeignKeys0.PRODUCT_PRICES__FK_SHOP_ID;
    public static final ForeignKey<ProductsRecord, ProductTypesRecord> PRODUCTS__FK_TYPE_ID = ForeignKeys0.PRODUCTS__FK_TYPE_ID;
    public static final ForeignKey<SellLogRecord, ProductsRecord> SELL_LOG__FK_PRODUCT_ID = ForeignKeys0.SELL_LOG__FK_PRODUCT_ID;
    public static final ForeignKey<SellLogRecord, ShopsRecord> SELL_LOG__FK_SHOP_ID = ForeignKeys0.SELL_LOG__FK_SHOP_ID;

    // -------------------------------------------------------------------------
    // [#1459] distribute members to avoid static initialisers > 64kb
    // -------------------------------------------------------------------------

    private static class Identities0 extends AbstractKeys {
        public static Identity<PersonsRecord, Integer> IDENTITY_PERSONS = createIdentity(Persons.PERSONS, Persons.PERSONS.PERSON_ID);
        public static Identity<PositionsRecord, Integer> IDENTITY_POSITIONS = createIdentity(Positions.POSITIONS, Positions.POSITIONS.POSITION_ID);
        public static Identity<ProductAmountsRecord, Integer> IDENTITY_PRODUCT_AMOUNTS = createIdentity(ProductAmounts.PRODUCT_AMOUNTS, ProductAmounts.PRODUCT_AMOUNTS.PRODUCT_ID);
        public static Identity<ProductPricesRecord, Integer> IDENTITY_PRODUCT_PRICES = createIdentity(ProductPrices.PRODUCT_PRICES, ProductPrices.PRODUCT_PRICES.PRODUCT_ID);
        public static Identity<ProductTypesRecord, Integer> IDENTITY_PRODUCT_TYPES = createIdentity(ProductTypes.PRODUCT_TYPES, ProductTypes.PRODUCT_TYPES.TYPE_ID);
        public static Identity<ProductsRecord, Integer> IDENTITY_PRODUCTS = createIdentity(Products.PRODUCTS, Products.PRODUCTS.PRODUCT_ID);
        public static Identity<SellLogRecord, Integer> IDENTITY_SELL_LOG = createIdentity(SellLog.SELL_LOG, SellLog.SELL_LOG.LOG_ID);
        public static Identity<ShopsRecord, Integer> IDENTITY_SHOPS = createIdentity(Shops.SHOPS, Shops.SHOPS.SHOP_ID);
    }

    private static class UniqueKeys0 extends AbstractKeys {
        public static final UniqueKey<PersonScheduleRecord> PERSON_SCHEDULE_PKEY = createUniqueKey(PersonSchedule.PERSON_SCHEDULE, "person_schedule_pkey", PersonSchedule.PERSON_SCHEDULE.SCHED_ID);
        public static final UniqueKey<PersonShopRecord> PERSON_SHOP_PKEY = createUniqueKey(PersonShop.PERSON_SHOP, "person_shop_pkey", PersonShop.PERSON_SHOP.PERSON_ID);
        public static final UniqueKey<PersonsRecord> PERSONS_PKEY = createUniqueKey(Persons.PERSONS, "persons_pkey", Persons.PERSONS.PERSON_ID);
        public static final UniqueKey<PersonsRecord> PASSPORT_KEY = createUniqueKey(Persons.PERSONS, "passport_key", Persons.PERSONS.PASSPORT);
        public static final UniqueKey<PositionSalaryRecord> POSITION_SALARY_PKEY = createUniqueKey(PositionSalary.POSITION_SALARY, "position_salary_pkey", PositionSalary.POSITION_SALARY.POSITION_ID, PositionSalary.POSITION_SALARY.SHOP_ID);
        public static final UniqueKey<PositionsRecord> POSITIONS_PKEY = createUniqueKey(Positions.POSITIONS, "positions_pkey", Positions.POSITIONS.POSITION_ID);
        public static final UniqueKey<ProductAmountsRecord> PRODUCT_AMOUNTS_PKEY = createUniqueKey(ProductAmounts.PRODUCT_AMOUNTS, "product_amounts_pkey", ProductAmounts.PRODUCT_AMOUNTS.PRODUCT_ID, ProductAmounts.PRODUCT_AMOUNTS.SHOP_ID);
        public static final UniqueKey<ProductPricesRecord> PRODUCT_PRICES_PKEY = createUniqueKey(ProductPrices.PRODUCT_PRICES, "product_prices_pkey", ProductPrices.PRODUCT_PRICES.PRODUCT_ID, ProductPrices.PRODUCT_PRICES.SHOP_ID);
        public static final UniqueKey<ProductTypesRecord> PRODUCT_TYPES_PKEY = createUniqueKey(ProductTypes.PRODUCT_TYPES, "product_types_pkey", ProductTypes.PRODUCT_TYPES.TYPE_ID);
        public static final UniqueKey<ProductTypesRecord> TITLE_UNIQ_KEY = createUniqueKey(ProductTypes.PRODUCT_TYPES, "title_uniq_key", ProductTypes.PRODUCT_TYPES.TITLE);
        public static final UniqueKey<ProductsRecord> PRODUCTS_PKEY = createUniqueKey(Products.PRODUCTS, "products_pkey", Products.PRODUCTS.PRODUCT_ID);
        public static final UniqueKey<SellLogRecord> NEWTABLE_PK = createUniqueKey(SellLog.SELL_LOG, "newtable_pk", SellLog.SELL_LOG.LOG_ID);
        public static final UniqueKey<ShopsRecord> SHOPS_PKEY = createUniqueKey(Shops.SHOPS, "shops_pkey", Shops.SHOPS.SHOP_ID);
        public static final UniqueKey<ShopsRecord> STREETS_UNIQ_KEY = createUniqueKey(Shops.SHOPS, "streets_uniq_key", Shops.SHOPS.STREET);
    }

    private static class ForeignKeys0 extends AbstractKeys {
        public static final ForeignKey<PersonScheduleRecord, PersonsRecord> PERSON_SCHEDULE__TTT = createForeignKey(classes.Keys.PERSONS_PKEY, PersonSchedule.PERSON_SCHEDULE, "person_schedule__ttt", PersonSchedule.PERSON_SCHEDULE.PERSON_ID);
        public static final ForeignKey<PersonShopRecord, PersonsRecord> PERSON_SHOP__TTT = createForeignKey(classes.Keys.PERSONS_PKEY, PersonShop.PERSON_SHOP, "person_shop__ttt", PersonShop.PERSON_SHOP.PERSON_ID);
        public static final ForeignKey<PersonShopRecord, ShopsRecord> PERSON_SHOP__FK_SHOP_ID = createForeignKey(classes.Keys.SHOPS_PKEY, PersonShop.PERSON_SHOP, "person_shop__fk_shop_id", PersonShop.PERSON_SHOP.SHOP_ID);
        public static final ForeignKey<PersonsRecord, PositionsRecord> PERSONS__FK_POSITION_ID = createForeignKey(classes.Keys.POSITIONS_PKEY, Persons.PERSONS, "persons__fk_position_id", Persons.PERSONS.POSITION_ID);
        public static final ForeignKey<PositionSalaryRecord, PositionsRecord> POSITION_SALARY__FK_POSITION_ID = createForeignKey(classes.Keys.POSITIONS_PKEY, PositionSalary.POSITION_SALARY, "position_salary__fk_position_id", PositionSalary.POSITION_SALARY.POSITION_ID);
        public static final ForeignKey<PositionSalaryRecord, ShopsRecord> POSITION_SALARY__FK_SHOP_ID = createForeignKey(classes.Keys.SHOPS_PKEY, PositionSalary.POSITION_SALARY, "position_salary__fk_shop_id", PositionSalary.POSITION_SALARY.SHOP_ID);
        public static final ForeignKey<ProductAmountsRecord, ProductsRecord> PRODUCT_AMOUNTS__FK_PRODUCT_ID = createForeignKey(classes.Keys.PRODUCTS_PKEY, ProductAmounts.PRODUCT_AMOUNTS, "product_amounts__fk_product_id", ProductAmounts.PRODUCT_AMOUNTS.PRODUCT_ID);
        public static final ForeignKey<ProductAmountsRecord, ShopsRecord> PRODUCT_AMOUNTS__FK_SHOP_ID = createForeignKey(classes.Keys.SHOPS_PKEY, ProductAmounts.PRODUCT_AMOUNTS, "product_amounts__fk_shop_id", ProductAmounts.PRODUCT_AMOUNTS.SHOP_ID);
        public static final ForeignKey<ProductPricesRecord, ProductsRecord> PRODUCT_PRICES__FK_PRODUCT_ID = createForeignKey(classes.Keys.PRODUCTS_PKEY, ProductPrices.PRODUCT_PRICES, "product_prices__fk_product_id", ProductPrices.PRODUCT_PRICES.PRODUCT_ID);
        public static final ForeignKey<ProductPricesRecord, ShopsRecord> PRODUCT_PRICES__FK_SHOP_ID = createForeignKey(classes.Keys.SHOPS_PKEY, ProductPrices.PRODUCT_PRICES, "product_prices__fk_shop_id", ProductPrices.PRODUCT_PRICES.SHOP_ID);
        public static final ForeignKey<ProductsRecord, ProductTypesRecord> PRODUCTS__FK_TYPE_ID = createForeignKey(classes.Keys.PRODUCT_TYPES_PKEY, Products.PRODUCTS, "products__fk_type_id", Products.PRODUCTS.TYPE_ID);
        public static final ForeignKey<SellLogRecord, ProductsRecord> SELL_LOG__FK_PRODUCT_ID = createForeignKey(classes.Keys.PRODUCTS_PKEY, SellLog.SELL_LOG, "sell_log__fk_product_id", SellLog.SELL_LOG.PRODUCT_ID);
        public static final ForeignKey<SellLogRecord, ShopsRecord> SELL_LOG__FK_SHOP_ID = createForeignKey(classes.Keys.SHOPS_PKEY, SellLog.SELL_LOG, "sell_log__fk_shop_id", SellLog.SELL_LOG.SHOP_ID);
    }
}