Purpose

jDbT is a small utility designed to quickly generate SQL schemas and associated information from a lightweight spec.

Input format

The input is a yml file describing the tables.

The following conventions are assumed:

• every field has a not null constraint by default, unless it has a ? at the beginning of its name
• + at the beginning of a field name means it has a unique constraint
• all tables have a primary key named <table_name>_id of type uuid
• every column named <something>_id is assumed to be a foreign key

Contribute

Contribute to jDbT by using it, and submit issues if you find a bug.

Test it yourself