= DDL/Seeder/Views =

== 1. Вовед ==

DDL-от беше генериран од страна на Visual Paradigm, испробан локално и дополнет со constraints. Потоа, направивме pg_dump и го импортиравме на нашата remote база за предметот.

== 2. DDL ==
[[html(<a href="https://develop.finki.ukim.mk/projects/eventflow/attachment/wiki/DatabaseCreation/ddl.sql">ddl.sql</a>)]]

DDL-от без alter table (туку со foreign keys во самите табели) и со последните промени од ЕР-от се наоѓа на линкот:
[[html(<a href="https://develop.finki.ukim.mk/projects/eventflow/attachment/wiki/DatabaseCreation/ddl_updated.sql">ddl_updated.sql</a>)]]

DDL-от без непотребни cascades се наоѓа на линкот:
[[html(<a href="https://develop.finki.ukim.mk/projects/eventflow/attachment/wiki/DatabaseCreation/ddl_without_unnecessary_cascades.sql">ddl_without_unnecessary_cascades.sql</a>)]]

== 3. Seeder ==
[[html(<a href="https://develop.finki.ukim.mk/projects/eventflow/attachment/wiki/DatabaseCreation/seeder.sql">seeder.sql</a>)]]

=== CSV dump from final population of tables
[[html(<a href="https://develop.finki.ukim.mk/projects/eventflow/attachment/wiki/DatabaseCreation/insert_proof.csv">insert_proof.csv</a>)]]

== 4. Views ==
[[html(<a href="https://develop.finki.ukim.mk/projects/eventflow/attachment/wiki/DatabaseCreation/views.sql">views.sql</a>)]]

Додаден поглед за landing page (upcoming events):
[[html(<a href="https://develop.finki.ukim.mk/projects/eventflow/attachment/wiki/DatabaseCreation/views_updated.sql">views_updated.sql</a>)]]