common

var (
	PUBLISHER           = TABLE("PUBLISHER")
	PUBLISHER_C_ID      = PUBLISHER.KEY("ID")          // implicit map to field Id
	PUBLISHER_C_VERSION = PUBLISHER.VERSION("VERSION") // implicit map to field Version
	PUBLISHER_C_NAME    = PUBLISHER.COLUMN("NAME")     // implicit map to field Name

	PUBLISHER_A_BOOKS = PUBLISHER.
						ASSOCIATE(PUBLISHER_C_ID).
						TO(BOOK_C_PUBLISHER_ID).
						As("Books")
)

var (
	BOOK_BIN             = TABLE("BOOK_BIN")
	BOOK_BIN_C_ID        = BOOK_BIN.KEY("ID")
	BOOK_BIN_C_VERSION   = BOOK_BIN.VERSION("VERSION")
	BOOK_BIN_C_HARDCOVER = BOOK_BIN.COLUMN("HARDCOVER")

	BOOK_BIN_A_BOOK = BOOK_BIN.
					ASSOCIATE(BOOK_BIN_C_ID).
					TO(BOOK_C_ID).
					As("Book")
)

var (
	BOOK                = TABLE("BOOK")
	BOOK_C_ID           = BOOK.KEY("ID")
	BOOK_C_VERSION      = BOOK.VERSION("VERSION")
	BOOK_C_NAME         = BOOK.COLUMN("NAME")
	BOOK_C_PRICE        = BOOK.COLUMN("PRICE")
	BOOK_C_PUBLISHED    = BOOK.COLUMN("PUBLISHED")
	BOOK_C_PUBLISHER_ID = BOOK.COLUMN("PUBLISHER_ID")

	BOOK_A_PUBLISHER = BOOK.
						ASSOCIATE(BOOK_C_PUBLISHER_ID).
						TO(PUBLISHER_C_ID).
						As("Publisher")

	BOOK_A_AUTHORS = NewM2MAssociation(
		"Authors",
		ASSOCIATE(BOOK_C_ID).WITH(AUTHOR_BOOK_C_BOOK_ID),
		ASSOCIATE(AUTHOR_BOOK_C_AUTHOR_ID).WITH(AUTHOR_C_ID),
	)

	BOOK_A_BOOK_BIN = BOOK.
					ASSOCIATE(BOOK_C_ID).
					TO(BOOK_BIN_C_ID).
					As("BookBin")

	BOOK_A_BOOK_I18N = BOOK.
						ASSOCIATE(BOOK_C_ID).
						TO(BOOK_I18N_C_BOOK_ID).
						As("I18n").
						With(BOOK_I18N_C_LANG, Param("lang"))
)

var (
	BOOK_I18N           = TABLE("BOOK_I18N")
	BOOK_I18N_C_ID      = BOOK_I18N.KEY("ID")
	BOOK_I18N_C_VERSION = BOOK_I18N.VERSION("VERSION")
	BOOK_I18N_C_BOOK_ID = BOOK_I18N.COLUMN("BOOK_ID")
	BOOK_I18N_C_LANG    = BOOK_I18N.COLUMN("LANG")
	BOOK_I18N_C_TITLE   = BOOK_I18N.COLUMN("TITLE")
)

var (
	AUTHOR_BOOK             = TABLE("AUTHOR_BOOK")
	AUTHOR_BOOK_C_AUTHOR_ID = AUTHOR_BOOK.KEY("AUTHOR_ID") // implicit map to field 'AuthorId'
	AUTHOR_BOOK_C_BOOK_ID   = AUTHOR_BOOK.KEY("BOOK_ID")   // implicit map to field 'BookId'
)

var (
	AUTHOR           = TABLE("AUTHOR")
	AUTHOR_C_ID      = AUTHOR.KEY("ID")
	AUTHOR_C_VERSION = AUTHOR.VERSION("VERSION")
	AUTHOR_C_NAME    = AUTHOR.COLUMN("NAME")
	AUTHOR_C_SECRET  = AUTHOR.COLUMN("SECRET")

	AUTHOR_A_BOOKS = NewM2MAssociation(
		"Books",
		ASSOCIATE(AUTHOR_C_ID).WITH(AUTHOR_BOOK_C_AUTHOR_ID),
		ASSOCIATE(AUTHOR_BOOK_C_BOOK_ID).WITH(BOOK_C_ID),
	)
)

var (
	PROJECT                = TABLE("PROJECT")
	PROJECT_C_ID           = PROJECT.KEY("ID")              // implicit map to field Id
	PROJECT_C_VERSION      = PROJECT.VERSION("VERSION")     // implicit map to field Version
	PROJECT_C_NAME         = PROJECT.COLUMN("NAME")         // implicit map to field Name
	PROJECT_C_MANAGER_ID   = PROJECT.COLUMN("MANAGER_ID")   // implicit map to field ManagerId
	PROJECT_C_MANAGER_TYPE = PROJECT.COLUMN("MANAGER_TYPE") // implicit map to field ManagerType
	PROJECT_C_STATUS       = PROJECT.COLUMN("STATUS_COD")   // implicit map to field Status

	PROJECT_A_EMPLOYEE = PROJECT.
						ASSOCIATE(PROJECT_C_MANAGER_ID).
						TO(EMPLOYEE_C_ID).
						As("Employee").
						With(PROJECT_C_MANAGER_TYPE, "E")

	PROJECT_A_CONSULTANT = PROJECT.
							ASSOCIATE(PROJECT_C_MANAGER_ID).
							TO(CONSULTANT_C_ID).
							As("Consultant").
							With(PROJECT_C_MANAGER_TYPE, "C")

	PROJECT_A_STATUS = PROJECT.
						ASSOCIATE(PROJECT_C_STATUS).
						TO(STATUS_C_CODE).
						As("Status")
)

var (
	EMPLOYEE              = TABLE("EMPLOYEE")
	EMPLOYEE_C_ID         = EMPLOYEE.KEY("ID")            // implicit map to field Id
	EMPLOYEE_C_VERSION    = EMPLOYEE.VERSION("VERSION")   // implicit map to field Version
	EMPLOYEE_C_FIRST_NAME = EMPLOYEE.COLUMN("FIRST_NAME") // implicit map to field FirstName
	EMPLOYEE_C_LAST_NAME  = EMPLOYEE.COLUMN("LAST_NAME")  // implicit map to field LastName

	EMPLOYEE_A_PROJECT = EMPLOYEE.
						ASSOCIATE(EMPLOYEE_C_ID).
						TO(PROJECT_C_MANAGER_ID).
						As("Project").
						With(PROJECT_C_MANAGER_TYPE, "E")
)

var (
	CONSULTANT           = TABLE("CONSULTANT")
	CONSULTANT_C_ID      = CONSULTANT.KEY("ID")          // implicit map to field Id
	CONSULTANT_C_VERSION = CONSULTANT.VERSION("VERSION") // implicit map to field Version
	CONSULTANT_C_NAME    = CONSULTANT.COLUMN("NAME")     // implicit map to field Name

	CONSULTANT_A_PROJECT = CONSULTANT.
							ASSOCIATE(CONSULTANT_C_ID).
							TO(PROJECT_C_MANAGER_ID).
							As("Project").
							With(PROJECT_C_MANAGER_TYPE, "C")
)

var (
	CATALOG           = TABLE("CATALOG")
	CATALOG_C_ID      = CATALOG.KEY("ID")          // implicit map to field Id
	CATALOG_C_VERSION = CATALOG.VERSION("VERSION") // implicit map to field Version
	CATALOG_C_DOMAIN  = CATALOG.COLUMN("DOMAIN")
	CATALOG_C_CODE    = CATALOG.COLUMN("KEY")
	CATALOG_C_VALUE   = CATALOG.COLUMN("VALUE")
)

var (
	STATUS               = TABLE("CATALOG").With("DOMAIN", "STATUS")
	STATUS_C_ID          = STATUS.KEY("ID")          // implicit map to field Id
	STATUS_C_VERSION     = STATUS.VERSION("VERSION") // implicit map to field Version
	STATUS_C_CODE        = STATUS.COLUMN("KEY").As("Code")
	STATUS_C_DESCRIPTION = STATUS.COLUMN("VALUE").As("Description")
)

var RAW_SQL string