App-PhotoDB
view release on metacpan or search on metacpan
docs/SCHEMA.pod view on Meta::CPAN
Table to catalog lenses
+--------------+--------------+-------------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+--------------+--------------+-------------------------------------------------------------+
| lens_id | int(11) | Unique ID for this lens |
| lensmodel_id | int(11) | |
| serial | varchar(45) | Serial number of this lens |
| date_code | varchar(45) | Date code of this lens, if different from the serial number |
| manufactured | smallint(6) | Year in which this specific lens was manufactured |
| acquired | date | Date on which this lens was acquired |
| cost | decimal(6,2) | Price paid for this lens in local currency units |
| notes | text | Freeform notes field |
| own | tinyint(1) | Whether we currently own this lens |
| lost | date | Date on which lens was lost/sold/disposed |
| lost_price | decimal(6,2) | Price for which the lens was sold |
| source | varchar(150) | Place where the lens was acquired from |
| condition_id | int(11) | Denotes the cosmetic condition of the camera |
+--------------+--------------+-------------------------------------------------------------+
=head2 LENSMODEL
Table to catalog lens models
+------------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+------------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------+
| lensmodel_id | int(11) | Unique ID for this lens model |
| mount_id | int(11) | Denotes the ID of the lens mount, if this is an interchangeable lens |
| zoom | tinyint(1) | Whether this is a zoom lens |
| min_focal_length | int(11) | Shortest focal length of this lens, in mm |
| max_focal_length | int(11) | Longest focal length of this lens, in mm |
| manufacturer_id | int(11) | ID of the manufacturer of this lens |
| model | varchar(45) | Model name of this lens |
| closest_focus | int(11) | The closest focus possible with this lens, in cm |
| max_aperture | decimal(4,1) | Maximum (widest) aperture available on this lens (numerical part only, e.g. 2.8) |
| min_aperture | decimal(4,1) | Minimum (narrowest) aperture available on this lens (numerical part only, e.g. 22) |
| elements | int(11) | Number of optical lens elements |
| groups | int(11) | Number of optical groups |
| weight | int(11) | Weight of this lens, in grammes (g) |
| nominal_min_angle_diag | int(11) | Nominal minimum diagonal field of view from manufacturer's specs |
| nominal_max_angle_diag | int(11) | Nominal maximum diagonal field of view from manufacturer's specs |
| aperture_blades | int(11) | Number of aperture blades |
| autofocus | tinyint(1) | Whether this lens has autofocus capability |
| filter_thread | decimal(4,1) | Diameter of lens filter thread, in mm |
| magnification | decimal(5,3) | Maximum magnification ratio of the lens, expressed like 0.765 |
| url | varchar(145) | URL to more information about this lens |
| introduced | smallint(6) | Year in which this lens model was introduced |
| discontinued | smallint(6) | Year in which this lens model was discontinued |
| negative_size_id | int(11) | ID of the negative size which this lens is designed for |
| fixed_mount | tinyint(1) | Whether this is a fixed lens (i.e. on a compact camera) |
| notes | text | Freeform notes field |
| coating | varchar(45) | Notes about the lens coating type |
| hood | varchar(45) | Model number of the compatible lens hood |
| exif_lenstype | varchar(45) | EXIF LensID number, if this lens has one officially registered. See documentation at http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/ |
| rectilinear | tinyint(1) | Whether this is a rectilinear lens |
| length | int(11) | Length of lens in mm |
| diameter | int(11) | Width of lens in mm |
| image_circle | int(11) | Diameter of image circle projected by lens, in mm |
| formula | varchar(45) | Name of the type of lens formula (e.g. Tessar) |
| shutter_model | varchar(45) | Name of the integrated shutter, if any |
+------------------------+--------------+---------------------------------------------------------------------------------------------------------------------------------------------+
=head2 LIGHT_METER
Table to catalog light meters
+-----------------+-------------+--------------------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-----------------+-------------+--------------------------------------------------------------------+
| light_meter_id | int(11) | Unique ID for this light meter |
| manufacturer_id | int(11) | Denotes ID of manufacturer of the light meter |
| model | varchar(45) | Model name or number of the light meter |
| metering_type | int(11) | ID of metering technology used in this light meter |
| reflected | tinyint(1) | Whether the meter is capable of reflected-light metering |
| incident | tinyint(1) | Whether the meter is capable of incident-light metering |
| flash | tinyint(1) | Whether the meter is capable of flash metering |
| spot | tinyint(1) | Whether the meter is capable of spot metering |
| min_asa | int(11) | Minimum ISO/ASA that this meter is capable of handling |
| max_asa | int(11) | Maximum ISO/ASA that this meter is capable of handling |
| min_lv | int(11) | Minimum light value (LV/EV) that this meter is capable of handling |
| max_lv | int(11) | Maximum light value (LV/EV) that this meter is capable of handling |
+-----------------+-------------+--------------------------------------------------------------------+
=head2 LOG
Table to store data modification logs
+-------------+--------------+-------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-------------+--------------+-------------------------------------+
| log_id | int(11) | Unique ID of the log entry |
| datetime | datetime | Timestamp for the log entry |
| type | varchar(45) | Type of log message, e.g. ADD, EDIT |
| message | varchar(450) | Log message |
+-------------+--------------+-------------------------------------+
=head2 MANUFACTURER
Table to catalog manufacturers of equipment and consumables
+-----------------+-------------+----------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-----------------+-------------+----------------------------------------------+
| manufacturer_id | int(11) | Unique ID of the manufacturer |
| manufacturer | varchar(45) | Name of the manufacturer |
| city | varchar(45) | City in which the manufacturer is based |
| country | varchar(45) | Country in which the manufacturer is based |
| url | varchar(45) | URL to the manufacturer's main website |
| founded | smallint(6) | Year in which the manufacturer was founded |
| dissolved | smallint(6) | Year in which the manufacturer was dissolved |
+-----------------+-------------+----------------------------------------------+
=head2 METERING_MODE
Metering modes as defined by EXIF tag MeteringMode
+------------------+-------------+-----------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+------------------+-------------+-----------------------------------------------------------+
docs/SCHEMA.pod view on Meta::CPAN
Table to list all possible shutter speeds
+---------------+--------------+--------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+---------------+--------------+--------------------------------------------------+
| shutter_speed | varchar(10) | Shutter speed in fractional notation, e.g. 1/250 |
| duration | decimal(9,5) | Shutter speed in decimal notation, e.g. 0.04 |
+---------------+--------------+--------------------------------------------------+
=head2 SHUTTER_SPEED_AVAILABLE
Table to associate cameras with shutter speeds
+----------------+-------------+-----------------------------------------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+----------------+-------------+-----------------------------------------------------------------------------------------+
| cameramodel_id | int(11) | ID of the camera model |
| shutter_speed | varchar(10) | Shutter speed that this camera has |
| bulb | int(1) | Whether this is a manual "bulb" shutter speed that can only be accessed in B or T modes |
+----------------+-------------+-----------------------------------------------------------------------------------------+
=head2 SHUTTER_TYPE
Table to catalog the different types of camera shutter
+-----------------+-------------+--------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-----------------+-------------+--------------------------------------------------------+
| shutter_type_id | int(11) | Unique ID of the shutter type |
| shutter_type | varchar(45) | Name of the shutter type (e.g. Focal plane, Leaf, etc) |
+-----------------+-------------+--------------------------------------------------------+
=head2 TELECONVERTER
Table to catalog teleconverters (multipliers)
+------------------+--------------+----------------------------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+------------------+--------------+----------------------------------------------------------------------------+
| teleconverter_id | int(11) | Unique ID of this teleconverter |
| mount_id | int(11) | ID of the lens mount used by this teleconverter |
| factor | decimal(4,2) | Magnification factor of this teleconverter (numerical part only, e.g. 1.4) |
| manufacturer_id | int(11) | ID of the manufacturer of this teleconverter |
| model | varchar(45) | Model name of this teleconverter |
| elements | tinyint(4) | Number of optical elements used in this teleconverter |
| groups | tinyint(4) | Number of optical groups used in this teleconverter |
| multicoated | tinyint(1) | Whether this teleconverter is multi-coated |
+------------------+--------------+----------------------------------------------------------------------------+
=head2 TONER
Table to catalog paper toners that can be used during the printing process
+-----------------+-------------+-------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-----------------+-------------+-------------------------------------+
| toner_id | int(11) | Unique ID of the toner |
| manufacturer_id | int(11) | ID of the manufacturer of the toner |
| toner | varchar(45) | Name of the toner |
| formulation | varchar(45) | Chemical formulation of the toner |
| stock_dilution | varchar(10) | Stock dilution of the toner |
+-----------------+-------------+-------------------------------------+
=head2 TO_PRINT
Table to catalogue negatives that should be printed
+-------------+-------------+---------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-------------+-------------+---------------------------------+
| id | int(11) | Unique ID of this table |
| negative_id | int(11) | Negative ID to be printed |
| width | int(11) | Width of print to be made |
| height | int(11) | Height of print to be made |
| printed | tinyint(1) | Whether the print has been made |
| print_id | int(11) | ID of print made |
| recipient | varchar(45) | Recipient of the print |
| added | date | Date that record was added |
+-------------+-------------+---------------------------------+
=head2 schema_migrations
+--------------+--------------+----------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+--------------+--------------+----------------+
| name | varchar(255) | |
| date_applied | datetime | |
+--------------+--------------+----------------+
( run in 1.028 second using v1.01-cache-2.11-cpan-75ffa21a3d4 )