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
==============================================
|