Proposed structure - Githubissues

UnwarySage / dndb

Databases final project attempt in clojure(script)

Eclipse Public License 1.0

0 stars 0 forks source link

Proposed structure #1

Open UnwarySage opened 5 years ago

UnwarySage commented 5 years ago

We need a scope and idea for our project, here's my proposal.

DbND

A message board for heroes and quest givers to exchange job postings.

Database layout.

Heroes: a table for heroes, consisting of name,class, race, level, and bio
Quests: a table for quests given. Name, location, reward, notes.
Patrons: A table of those who can afford to give quests. Name, location.
Offers: a junction table, between patron and quest ids. Each entry has it's own id.
Claims: a table for "we did that" claims. contains offer id,the hero id, the amount that was paid, and the date it was made.

Database features

We will be using the following features.

Views to sort out completed claims
Triggers to automate paying claims in full if the amount is left blank, this should also include a procedure.
Functions to take a hero and produce a terse bio. Eg "Sha-fu, Elf Monk."

Site features

View heroes
View a specific hero.
View an offer, and claim it as a hero.
View claimed offers.
Mark an offer paid or custom payment.

Stretch goals

Make new hero
Make new offer
Make new patron

UnwarySage commented 4 years ago

claims now have a claim id

UnwarySage commented 4 years ago

Heroes now have a LastClaim_ID field, which is the ID of their most recent claim, maintained by a trigger.