556
edits
(→Aims) |
|||
Line 48: | Line 48: | ||
=== Database Design === | === Database Design === | ||
* Box | * Box | ||
** creator_id (Reference ID) - As anyone will be able to create a new box record this would be handy for identifying | ** creator_id (Reference ID) - As anyone will be able to create a new box record this would be handy for identifying when people aren't being excellent i.e. someone spams the create button. | ||
** owner_id (Reference ID) - Who owns the box/contents. The idea is that this will only get updated on claiming the box so it will be possible to identify old owners if they left something in the box after disowning it. | ** owner_id (Reference ID) - Who owns the box/contents. The idea is that this will only get updated on claiming the box so it will be possible to identify old owners if they left something in the box after disowning it. | ||
** owned (BOOLEAN) - If the assign owner still wishes to own the box. | ** owned (BOOLEAN) - If the assign owner still wishes to own the box. |