Changes

Jump to navigation Jump to search
1,762 bytes added ,  05:40, 30 April 2021
m
no edit summary
Line 185: Line 185:     
== Notes ==
 
== Notes ==
 +
=== Photographic equipment case study ===
 +
'''''Headings'''''
 +
;Intro:
 +
;Nomenclature:[[Glossary#Library]], [[Glossary#Entry]], [[Glossary#Entry name]], & [[Glossary#Link to entry]] vs [[Glossary#Table]], [[Glossary#Record]] (or row), [[Glossary#Primary key]], & [[Glossary#SQL]]
 +
;Requirements (the need):
 +
:;Intro:
 +
:;Design considerations:Initial camera/lens/filter&hood, flash, tripod, bag/strap
 +
;Solution:
 +
:;Intro:
 +
:;Design:
 +
::;Screenshots: See the 5 email attachments
 +
:;Implementation:
 +
::;Intro:
    +
'''''The email'''''
 +
 +
I have a LOT of camera equipment (Camera, Lens, Filters, tripods, bags, etc.). I want to be able to create records of all of this equipment for personal inventory as well as insurance purposes.
 +
 +
So far, none of the prebuilt programs I have looked at covered all of the data that I wanted to track on a per item basis, so I decided to use this program, some research into existing templates and a lot of soul-searching to create my own me-friendly database. So far so good. I spent all day yesterday architecting  starting database. As will all programming, there will be further minor changes (new fields, verbiage tweaks, section grouping changes, etc.). That said, I am very happy with my initial go at this.
 +
 +
So, in this bare bones example, I have a camera entry, a lens entry, and a filter entry.
 +
In real life, ALL three of these items are physically part of the same "group/unit", The Lens is attached to the camera body and the filter is attached to that particular lens.
 +
While I still want to keep each item as their own separate record, I also want to link these 3 records together to visually show this relationship. And at some point, i want this grouping be part of a larger grouping (in a camera bag with other items for example).
    
[[Category: Dev]]
 
[[Category: Dev]]

Navigation menu