Design PostgreSQL DB

[personam-solis]

Design the entire layout of the PG DB. This is completely dependent on the data sources and what the data looks like

The below need to be considered and also read the DB Design for mere mortals:

• Does there need to be a specific DB per source?
• Primary Keys
• Foreign Keys
• Tables
• Views

[personam-solis]

The actual database design will be saved to the branch, but managed using draw.io

[personam-solis]

Figure out Entities and Attributes to help design the database

[personam-solis]

Need to include the attributes:

• EM-DAT: DisNo. - Unique disaster Identifier
• GDACS: gdacs:eventid - Unique event ID
• FEMA: disasterNumber - Unique disaster number
• FEMA: declarationTitle - Name of event

[personam-solis]

There is a good chance that the databases will have to change in terms of design

dont worry about adding it to draw.io; lets get coding faster!

[personam-solis]

There should be a temp view for each database, for each year that is read only

[personam-solis]

Design has been completed. Will write another issue at some point to convert to draw.io

all actions completed, closing