Database table naming.

Database table naming.

  
Just curious since the database table contain rather strange naming patterns, when using a 3rd party tool to map the database table, how will you know which project is using which table?

Also if you wanted to create a desktop application that connects to a application database you have written with outsystems, how will you map it? did you want us to create a web service? or is there an alternative option?

Hi Robert,

 

In the Entity System entity you will find the physical names of the entities (no pun intended).

 

This naming format is to allow complex environments where several eSpaces have entities with the same name and also due to Oracle table name limitations.

 

You might also want to take a look into these posts:
- Entity to physical table mapping
- Configuring the physical table name format for Entities
 

Cheers,

Tiago Simões

Thanks Tiago

"This naming format is to allow complex environments where several eSpaces have entities with the same name "
understood.

by the way is there a way to export the database out to a SQL DDL script?

Hi Robert,

 

You can get the SQL upgrade script if you do a step by step publish of your eSpace in Service Center

  1. Service Center>Factory>eSpaces>Upload & Publish an eSpace
  2. Click Upload
  3. Select "Publish Step by Step"
  4. Click "Download Database Upgrade Script"

This will get you the changes from the previous version. To get the complete ddl of the eSpace you might need to use a third party SQL tool (e.g. SQL Server Management Studio)

 

Cheers,

Tiago Simões