App-PhotoDB
view release on metacpan or search on metacpan
docs/SCHEMA.pod view on Meta::CPAN
| notes | varchar(145) | Title of the film |
| frames | int(11) | Expected (not actual) number of frames from the film |
| developer_id | int(11) | ID of the developer used to process this film |
| directory | varchar(100) | Name of the directory that contains the scanned images from this film |
| dev_uses | int(11) | Numnber of previous uses of the developer |
| dev_time | time | Duration of development |
| dev_temp | decimal(3,1) | Temperature of development |
| dev_n | int(11) | Number of the Push/Pull rating of the film, e.g. N+1, N-2 |
| development_notes | varchar(200) | Extra freeform notes about the development process |
| film_bulk_id | int(11) | ID of bulk film from which this film was cut |
| film_bulk_loaded | date | Date that this film was cut from a bulk roll |
| film_batch | varchar(45) | Batch number of the film |
| film_expiry | date | Expiry date of the film |
| purchase_date | date | Date this film was purchased |
| price | decimal(4,2) | Price paid for this film |
| processed_by | varchar(45) | Person or place that processed this film |
| archive_id | int(11) | ID of the archive to which this film belongs |
+-------------------+--------------+-----------------------------------------------------------------------+
=head2 FILMSTOCK
Table to list different brands of film stock
+-----------------+-------------+----------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-----------------+-------------+----------------------------------------+
| filmstock_id | int(11) | Unique ID of the filmstock |
| manufacturer_id | int(11) | ID of the manufacturer of the film |
| name | varchar(45) | Name of the film |
| iso | int(11) | Nominal ISO speed of the film |
| colour | tinyint(1) | Whether the film is colour |
| process_id | int(11) | ID of the normal process for this film |
| panchromatic | tinyint(1) | Whether this film is panchromatic |
+-----------------+-------------+----------------------------------------+
=head2 FILM_BULK
Table to record bulk film stock, from which individual films can be cut
+---------------+--------------+--------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+---------------+--------------+--------------------------------------------+
| film_bulk_id | int(11) | Unique ID of this bulk roll of film |
| format_id | int(11) | ID of the format of this bulk roll |
| filmstock_id | int(11) | ID of the filmstock |
| purchase_date | date | Purchase date of this bulk roll |
| cost | decimal(5,2) | Purchase cost of this bulk roll |
| source | varchar(45) | Place where this bulk roll was bought from |
| batch | varchar(45) | Batch code of this bulk roll |
| expiry | date | Expiry date of this bulk roll |
+---------------+--------------+--------------------------------------------+
=head2 FILTER
Table to catalog filters
+-----------------+--------------+---------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-----------------+--------------+---------------------------------------------+
| filter_id | int(11) | Unique filter ID |
| thread | decimal(4,1) | Diameter of screw thread in mm |
| type | varchar(45) | Filter type (e.g. Red, CPL, UV) |
| attenuation | decimal(2,1) | Attenuation of this filter in decimal stops |
| qty | int(11) | Quantity of these filters available |
| manufacturer_id | int(11) | Denotes the manufacturer of the filter. |
+-----------------+--------------+---------------------------------------------+
=head2 FILTER_ADAPTER
Table to catalogue filter adapter rings
+-------------------+--------------+----------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-------------------+--------------+----------------------------------------------+
| filter_adapter_id | int(11) | Unique ID of filter adapter |
| camera_thread | decimal(3,1) | Diameter of camera-facing screw thread in mm |
| filter_thread | decimal(3,1) | Diameter of filter-facing screw thread in mm |
+-------------------+--------------+----------------------------------------------+
=head2 FLASH
Table to catlog flashes, flashguns and speedlights
+-------------------+--------------+-------------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-------------------+--------------+-------------------------------------------------------------+
| flash_id | int(11) | Unique ID of external flash unit |
| manufacturer_id | int(11) | Manufacturer ID of the flash |
| model | varchar(45) | Model name/number of the flash |
| guide_number | int(11) | Guide number of the flash |
| gn_info | varchar(45) | Extra freeform info about how the guide number was measured |
| battery_powered | tinyint(1) | Whether this flash takes batteries |
| pc_sync | tinyint(1) | Whether the flash has a PC sync socket |
| hot_shoe | tinyint(1) | Whether the flash has a hot shoe connection |
| light_stand | tinyint(1) | Whether the flash can be used on a light stand |
| battery_type_id | int(11) | ID of battery type |
| battery_qty | int(11) | Quantity of batteries needed in this flash |
| manual_control | tinyint(1) | Whether this flash offers manual power control |
| swivel_head | tinyint(1) | Whether this flash has a horizontal swivel head |
| tilt_head | tinyint(1) | Whether this flash has a vertical tilt head |
| zoom | tinyint(1) | Whether this flash can zoom |
| dslr_safe | tinyint(1) | Whether this flash is safe to use with a digital camera |
| ttl | tinyint(1) | Whether this flash supports TTL metering |
| flash_protocol_id | int(11) | ID of flash TTL metering protocol |
| trigger_voltage | decimal(4,1) | Trigger voltage of the flash, in Volts |
| own | tinyint(1) | Whether we currently own this flash |
| acquired | date | Date this flash was acquired |
| cost | decimal(5,2) | Purchase cost of this flash |
+-------------------+--------------+-------------------------------------------------------------+
=head2 FLASH_PROTOCOL
Table to catalog different protocols used to communicate with flashes
+-------------------+-------------+------------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-------------------+-------------+------------------------------------------------------------+
| flash_protocol_id | int(11) | Unique ID of this flash protocol |
| manufacturer_id | int(11) | ID of the manufacturer that introduced this flash protocol |
| name | varchar(45) | Name of the flash protocol |
+-------------------+-------------+------------------------------------------------------------+
=head2 FOCUS_TYPE
Table to catalog different focusing methods
+---------------+-------------+-------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+---------------+-------------+-------------------------+
| focus_type_id | int(11) | Unique ID of focus type |
| focus_type | varchar(45) | Name of focus type |
+---------------+-------------+-------------------------+
=head2 FORMAT
Table to catalogue different film formats. These are distinct from negative sizes.
+-------------+-------------+-------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-------------+-------------+-------------------------------------+
| format_id | int(11) | Unique ID for this format |
| format | varchar(45) | The name of this film/sensor format |
| digital | tinyint(1) | Whether this is a digital format |
+-------------+-------------+-------------------------------------+
=head2 LENS
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 |
( run in 0.623 second using v1.01-cache-2.11-cpan-f56aa216473 )