![]() ![]() foreign key: each column marked as foreign key will have its own index.primary key: each column marked as primary key will be part of the primary key constraint.The default value can be stored in the default tag. The column name is derived from the name but the column tag can be used to override it. The table tag can be used to override the Entity name. The table name is composed of the ER Diagram prefix (optional) and the entity name. Each entity will be transformed into a table and at this level the user can provide a table name prefix for them using the tag prefix. The schema name is provided by the schema tag, default value being public if none is defined. Data Model: part of a Project, it gives the schema where all member tables will be created.If the tag is not present one will be created with the actual name. Project: provides the database name, either derived from its name or through the database tag.Follow the spteps above to re-generate with the new preferences.īelows are the rules to convert from ERD elements to DDL.Īll entities and columns are converted to create table statements as follow:.From Preferences/Postgresql DDL tab set your preferences and close.Click the menu ( Tools > Postgresql Model Generation > Configure.).If you want to change the generation options please follow the steps below. Save the ERD model if changes were perfomed during code generation.Select a directory where the generated code will be deployed.Click the menu ( Tools > Postgresql Model Generation > Generate DDL.).Install this extension from Extension Manager of StarUML. This extension for StarUML support to generate DDL (Data Definition Language) from PostgreSQL. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |