Changes

Jump to navigation Jump to search
1,763 bytes removed ,  15:51, 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