Yeah databases are cool and addictive!
Allan
PS No trees were harmed in the sending of this message and a very large
number of electrons were asked their permission to be terribly
inconvenienced. (And threw a party for them afterwards for being really cool
about it).
Disrupting the unnatural balance that you, as a conscious human being and a
confused mass of energy, have created.
-Disturb the mind -
>From: "Matthew Bristol" <bristolm@xxxxxxxxxxxxx>
>Reply-To: olympus@xxxxxxxxxx
>To: <olympus@xxxxxxxxxx>
>Subject: [OM] Re: My proposed database fields
>Date: Mon, 11 Dec 2006 07:24:38 -0600
>
>
>I decided to give you a quick example of what I meant by normalizing.
>This seemed more fun than working on my own DB's for work...
>
>
>You could even add another "layer" where only the unedited pictures are
>stored in tbl_Pictures and you stored information about different edits
>in another table that referenced the id_Picture of the original as well
>as any edit information. That would be much preferable if you were
>storing several edits for the same picture, as you would have to enter
>the original picture information only once.
>
>If you made a tbl_Films, you could just have a film type of "Digital"
>for your DSLR shots.
>
>I like DB's much too much.
>________
>tbl_Cameras
>_________
>id_Camera: Autonumber
>CameraDescription: A1
>CameraManufacturer: Canon
>CameraSN: 0912831902-309
>CameraType:DSLR
>
>
>_________
>tbl_Lenses
>__________
>id_Lens: Autonumber
>LensDescription: 18-50mm EFS
>LensManufacturer: Canon
>LensMaxmm:18
>LensMinmm: 50
>LensMaxf: 6.0
>LensMinf: 2.8
>LensSN: 45646516545
>
>__________
>tbl_Pictures
>___________
>id_Picture:Autonumber
>id_Camera: foreign key from tbl_Cameras
>id_Lens: foreign key from tbl_Lenses
>FileSpec: C:\MyDocuments\MyPictures\DSC001.JPG
>Date/Time: 12/12/2006 18:59:00
>Subject: Roxie the cat
>Shoot Desc: Rulers Of The Roost
>Location: Home
>Shot By: Me
>Etc...(no need for any additional camera or lens information)
>
>_________
>tbl_Edits
>_________
>id_Edit: Autonumber
>id_Picture: foreign key from tbl_Pictures
>EditProgram: CS2
>Edit Description: Crop, curve balancing...
>EditLink: :\MyDocuments\MyPictures\DSC001_Edit1.JPG
>etc...
>
>-----Original Message-----
>From: olympus-owner@xxxxxxxxxx [mailto:olympus-owner@xxxxxxxxxx] On
>Behalf Of Matthew Bristol
>Sent: Monday, December 11, 2006 7:00 AM
>To: olympus@xxxxxxxxxx
>Subject: [OM] Re: My proposed database fields
>
>
>I would do a bit of normalization. I would store camera and lens info
>in different tables. Then one could store more information about each
>of those and link to the entries in your pictures table. You also might
>want a table of film types as well that you could link to. Also, why
>would you need to store both the link to the picture AND a copy of the
>picture? It seems once you started editing pictures, it might be hard
>to keep straight which copy is the most current.
>
>
>-----Original Message-----
>From: olympus-owner@xxxxxxxxxx [mailto:olympus-owner@xxxxxxxxxx] On
>Behalf Of Allan Mee
>Sent: Sunday, December 10, 2006 1:22 PM
>To: olympus@xxxxxxxxxx
>Subject: [OM] My proposed database fields
>
>
>Here's my first thoughts regarding database fields for the database I'm
>going to write in VB - with a couple of made up examples of records.
>Any thoughts? Have I missed anything obvious?
>Allan
>
>Fields:
>RefNo: 000001 (Auto-generated by access)
>FileSpec: C:\MyDocuments\MyPictures\DSC001.JPG
>Date/Time: 12/12/2006 18:59:00
>Subject: Roxie the cat
>Shoot Desc: Rulers Of The Roost
>Location: Home
>Shot By: Me
>Edited: No
>Camera Make: Canon
>Model: EOS DIGITAL REBEL 300D
>Camera Type: DLSR
>Flash Used: No
>FlashType: Built-in
>Lens Used: 18-50mm EFS
>Focal Length: 70 mm
>Exposure Time: 1/500 sec
>Aperture: f/5.6
>ISO: 200
>Exposure Bias: -1/3
>White Balance: AWB
>Metering Mode: Matrix
>Image Format: JPEG
>JPEG Quality: High/Fine
>Exposure Program: Aperture Priority
>Focus Distance: 5m
>CFCardRefNo:0001
>ImageWidth: 1024
>ImageHeight: 768
>ColourInfo: 32-bit RGB+Alpha
>Scanned: No
>Image: (copy of actual image stored)
>
>RefNo: 000002 (Auto-generated by access)
>FileSpec: C:\MyDocuments\MyPictures\DSC002.JPG
>Date/Time: 12/12/2006 20:04:17
>Subject: Ben the dog
>Shoot Desc: Rulers Of The Roost
>Location: Garden
>Shot By: Me
>Edited: No
>Camera Make: Canon
>Model: A1
>Camera Type: 35mm
>Flash Used: No
>FlashType: None
>Lens Used: 28mm Cosina
>Focal Length: 28 mm
>Exposure Time: 1/250 sec
>Aperture: f/4
>ISO: 200
>Exposure Bias: -1/3
>White Balance: NA
>Metering Mode: Centre-Weighted
>Image Format: JPEG
>JPEG Quality: High/Fine
>Exposure Program: Aperture Priority
>Focus Distance: 10m
>CFCardRefNo:NA
>ImageWidth: 800
>ImageHeight: 600
>ColourInfo: 16-bit RGB+Alpha
>Scanned: Yes
>Image: (copy of actual image stored)
>
>
>
>
>PS No trees were harmed in the sending of this message and a very large
>number of electrons were asked their permission to be terribly
>inconvenienced. (And threw a party for them afterwards for being really
>cool
>about it).
>
>Disrupting the unnatural balance that you, as a conscious human being
>and a
>confused mass of energy, have created.
>-Disturb the mind -
>
>_________________________________________________________________
>It's Hotmail's 10th Birthday! Come and play Pass the Parcel
>http://www.msnpasstheparcel.com
>
>
>==============================================
>List usage info: http://www.zuikoholic.com
>List nannies: olympusadmin@xxxxxxxxxx
>==============================================
>This message (and any associated files) is intended only for the use of
>the individual or entity to which it is addressed, and may contain
>information that is confidential, subject to copyright or constitutes a
>trade secret. If you are not the intended recipient, you are hereby
>notified that any dissemination, copying or distribution of this message
>or files associated with the message are strictly prohibited. If you
>have received this message in error, kindly notify us immediately by
>replying to the message and deleting it from your computer
>==============================================
>List usage info: http://www.zuikoholic.com
>List nannies: olympusadmin@xxxxxxxxxx
>==============================================
>This message (and any associated files) is intended only for the use of the
>individual or entity to which it is addressed, and may contain information
>that is confidential, subject to copyright or constitutes a trade secret.
>If you are not the intended recipient, you are hereby notified that any
>dissemination, copying or distribution of this message or files associated
>with the message are strictly prohibited. If you have received this message
>in error, kindly notify us immediately by replying to the message and
>deleting it from your computer
>==============================================
>List usage info: http://www.zuikoholic.com
>List nannies: olympusadmin@xxxxxxxxxx
>==============================================
_________________________________________________________________
Windows Live? Messenger has arrived. Click here to download it for free!
http://imagine-msn.com/messenger/launch80/?locale=en-gb
==============================================
List usage info: http://www.zuikoholic.com
List nannies: olympusadmin@xxxxxxxxxx
==============================================
|