conferences-db

public

0 stars

0 forks

0 issues

Commits

List of commits on branch master.

Unverified

298e106a71c45e9ea83d57dd2c33714fb8958ee9

Add trigger validating booking date before conference start.

jjonatanklosko committed 5 years ago

Unverified

688fba53a813f6b8ab2264c851f1f80abdc18812

Fix available spots computation.

jjonatanklosko committed 5 years ago

Unverified

dee950a5c34975d9dab0b6728272eda0a5ef4eb8

Add triggers validating that bookings are withing proper conferences and days.

jjonatanklosko committed 5 years ago

Unverified

7300a8cb51ef992d993c90ea946712c32d9ee716

Add trigger preventing conference day from having lower attendee limit than its workshops.

jjonatanklosko committed 5 years ago

Unverified

8cdd37c930f3911f82b2d1633a96e2d54f59a37d

Update trigger name to be more accurate.

jjonatanklosko committed 5 years ago

Unverified

0bffac74e39cc519656d486e3cebb1c8ba1ecce9

Add trigger validating that workshop does not have lower attendee limit than conference day.

jjonatanklosko committed 5 years ago

README

The README file for this repository.

conferences-db

A database project for DB classes, see the docs for detailed Polish documentation.

Execution

Files ordered in the way they should be executed:

src/schema.sql - the database schema
src/indices.sql - additional indices boosting query performance
src/functions.sql
src/views.sql
src/procedures.sql
src/triggers.sql

Example data

The project includes sample data generator (under src/generator). To make things simple the repository includes an SQL file created by the generator, so you can just execute src/generator/sample_data.sql to fill the database.