Create PostGreSQL Script

[kirubeltadesse]

Description

Create a PostgreSQL Script for all the tables and their relationship.

Acceptable Criteria

• Create a PostgreSQL script (including all the tables and relationships)
• Create a script to populate fake data

Related Story

Use the table naming and relationship from this #19

Technical Info

There are different ways of creating the script
using lucid diagram
or
you can use the PostgreSQL tool

[dinaolmelak]

Updated the ER_diagram documentation in the following PR #43

[dinaolmelak]

I had used Lucidchart create the following diagram based on the ER_Diagram in the documentation. I will be exporting it as a POSTGREsql schema and create the databases.

[dinaolmelak]

I just created the database based on the above diagram. The script I exported from Lucid Chart worked fine. However, I had to change the string to VARCHAR, because POSTGREsql does not have string datatype.

[kirubeltadesse]

@dinaolmelak yes, the datatypes are different between language and database language. VARCHAR seems the right type for string you can refer to here for more information.

I believe what is remaining now is creating a script to populate the tables using fake data.

[dinaolmelak]

For tracking the database table structures and fake data.

/sap/resources/script.sql
/sap/resources/schema.sql

should it be stored like that?

[kirubeltadesse]

Let me ask you this thing where is the /sap folder going to be?

[dinaolmelak]

By /sap I meant ./ (i.e ./resources/script.sql and ./resources/schema.sql)

[kirubeltadesse]

By /sap I meant ./

I guess for now you can put it inside /sap-web/sapweb/resources/ which means you need to create the resources folder under the already existing sapweb folder.