Generated table for enumeration column type

[SchweinchenFuntik]

Generate dictionary table for Enum.

Motivation: for the correctness of the scheme, especially useful for other systems that will also work with the database

enum class AccountType { DEBIT, CREDIT }

object Accounts : Table() {
    val type = enumeration("type", AccountType::class)
}

We get in the database:

CREATE TABLE ACCOUNT_TYPE(ID INT, NAME VARCHAR);

ALTER TABLE ACCOUNT ADD CONSTRAINT FX_ACCOUNT_ACCOUNT_TYPE_ID FOREIGN KEY (TYPE) REFERENCES ACCOUNT_TYPE(ID);

INSERT INTO ACCOUNT_TYPE(ID, NAME) VALUES (1, 'DEBIT');
INSERT INTO ACCOUNT_TYPE(ID, NAME) VALUES (2, 'CREDIT');

make optional

[SchweinchenFuntik]

it is possible to add a similar function to SchemeUtils, who needs to call

[SchweinchenFuntik]

add a special annotation @GenerateEnumTable (tentative name), which will tell SchemeUtils to generate or update the table data for this enum.

[Tapac]

Should it be resolved/linked with columns by id/enum ordinal or by enum value?

[SchweinchenFuntik]

It is hard to say. I think to use ordinal, but still give the user the opportunity to specify the values from the enum class