Customization of tables and columns in databases, export automatization

[Peter_Dolphin]

Hallo,

I am trying to figure out if Sparx EA software offers possibilities for custmizing tables and columns - for instance, I need to make my own tab for combo box where I can pre-define single value and assign this value to the table or column for further use.

Next, I will need feature that will generate complete script defining the database I designed in EA that will be processeable by another application, such as some sort of source control management system.

Thank you very much!

Peter

[Geert Bellekens]

Hi Peter,

I'm sorry, I didn't understand what you are looking for.
Can you explain in more detail?

Geert

[qwerty]

I am trying to figure out if Sparx EA software offers possibilities for custmizing tables and columns - for instance, I need to make my own tab for combo box where I can pre-define single value and assign this value to the table or column for further use.

If you are referring to EA's database structure: the answer is No. If you are after DB modeling in general, well, that's sort of possible with EA but in that case your question is not clear enough.

Regarding the 2nd question I'm as stunned as Geert.

q.

[Peter_Dolphin]

Hallo, Geert, qwerty, and all the other visitors,

thank you for the reply and my apology for not making myself clear enough.

I will give an examle:

1) Let us assume I want to engineer my own database model in EA. I will use Firebird database in which I create table Employee. Employee Table will have three columns:
id int
Name Char(50)
Age - pre-defined values (combo box)

In Age column, user will be able to choose from three options : (0-16), (17-18), (18-99).

This is what I need. I either need some add in that can do that for database modelling or learn how to do it by myself...


2) let assume I want to export database model I created in AE in some .txt file, for instance, then import this file to MS Visual Basic. I want VB to be able to open this file as database model, read it, and re-create database based on data in that .txt file.

[Peter_Dolphin]

or another example:

Here in this tutorial we can see creation of such database:

https://youtu.be/LLtp49TU1H8?t=261

I want in this customer tabe for FirstName have only two options, two values I can choose from: "Jill" or "Jane", nothing else.

and I want to be able to pre-define or re-define these values any time I work with this database model.