App-PhotoDB
view release on metacpan or search on metacpan
docs/SCHEMA.pod view on Meta::CPAN
+---------------------+--------------+------------------------------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+---------------------+--------------+------------------------------------------------------------------------------+
| cameramodel_id | int(11) | Auto-incremented camera model ID |
| manufacturer_id | int(11) | Denotes the manufacturer of the camera. |
| model | varchar(45) | The model name of the camera |
| mount_id | int(11) | Denotes the lens mount of the camera if it is an interchangeable-lens camera |
| format_id | int(11) | Denotes the film format of the camera |
| focus_type_id | int(11) | Denotes the focus type of the camera |
| metering | tinyint(1) | Whether the camera has built-in metering |
| coupled_metering | tinyint(1) | Whether the camera's meter is coupled automatically |
| metering_type_id | int(11) | Denotes the technology used in the meter |
| body_type_id | int(11) | Denotes the style of camera body |
| weight | int(11) | Weight of the camera body (without lens or batteries) in grammes (g) |
| introduced | smallint(6) | Year in which the camera model was introduced |
| discontinued | smallint(6) | Year in which the camera model was discontinued |
| negative_size_id | int(11) | Denotes the size of negative made by the camera |
| shutter_type_id | int(11) | Denotes type of shutter |
| shutter_model | varchar(45) | Model of shutter |
| cable_release | tinyint(1) | Whether the camera has the facility for a remote cable release |
| viewfinder_coverage | int(11) | Percentage coverage of the viewfinder. Mostly applicable to SLRs. |
| power_drive | tinyint(1) | Whether the camera has integrated motor drive |
| continuous_fps | decimal(3,1) | The maximum rate at which the camera can shoot, in frames per second |
| video | tinyint(1) | Whether the camera can take video/movie |
| digital | tinyint(1) | Whether this is a digital camera |
| fixed_mount | tinyint(1) | Whether the camera has a fixed lens |
| lensmodel_id | int(11) | If fixed_mount is true, specify the lensmodel_id |
| battery_qty | int(11) | Quantity of batteries needed |
| battery_type | int(11) | Denotes type of battery needed |
| notes | text | Freeform text field for extra notes |
| bulb | tinyint(1) | Whether the camera supports bulb (B) exposure |
| time | tinyint(1) | Whether the camera supports time (T) exposure |
| min_iso | int(11) | Minimum ISO the camera will accept for metering |
| max_iso | int(11) | Maximum ISO the camera will accept for metering |
| af_points | tinyint(4) | Number of autofocus points |
| int_flash | tinyint(1) | Whether the camera has an integrated flash |
| int_flash_gn | tinyint(4) | Guide number of internal flash |
| ext_flash | tinyint(1) | Whether the camera supports an external flash |
| flash_metering | varchar(12) | Flash metering protocol |
| pc_sync | tinyint(1) | Whether the camera has a PC sync socket for flash |
| hotshoe | tinyint(1) | Whether the camera has a hotshoe |
| coldshoe | tinyint(1) | Whether the camera has a coldshoe or accessory shoe |
| x_sync | varchar(6) | X-sync shutter speed, expressed like 1/125 |
| meter_min_ev | tinyint(4) | Lowest EV/LV the built-in meter supports |
| meter_max_ev | tinyint(4) | Highest EV/LV the built-in meter supports |
| dof_preview | tinyint(1) | Whether the camera has depth of field preview |
| tripod | tinyint(1) | Whether the camera has a tripod bush |
+---------------------+--------------+------------------------------------------------------------------------------+
=head2 CONDITION
Table to list of physical condition descriptions that can be used to evaluate equipment
+--------------+--------------+---------------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+--------------+--------------+---------------------------------------------------------------+
| condition_id | int(11) | Unique condition ID |
| code | varchar(6) | Condition shortcode (e.g. EXC) |
| name | varchar(45) | Full name of condition (e.g. Excellent) |
| min_rating | int(11) | The lowest percentage rating that encompasses this condition |
| max_rating | int(11) | The highest percentage rating that encompasses this condition |
| description | varchar(300) | Longer description of condition |
+--------------+--------------+---------------------------------------------------------------+
=head2 DEVELOPER
Table to list film and paper developers
+-----------------+-------------+---------------------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+-----------------+-------------+---------------------------------------------------------------------+
| developer_id | int(11) | Unique developer ID |
| manufacturer_id | int(11) | Denotes the manufacturer ID |
| name | varchar(45) | Name of the developer |
| for_paper | tinyint(1) | Whether this developer can be used with paper |
| for_film | tinyint(1) | Whether this developer can be used with film |
| chemistry | varchar(45) | The key chemistry on which this developer is based (e.g. phenidone) |
+-----------------+-------------+---------------------------------------------------------------------+
=head2 ENLARGER
Table to list enlargers
+------------------+--------------+--------------------------------------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+------------------+--------------+--------------------------------------------------------------+
| enlarger_id | int(11) | Unique enlarger ID |
| manufacturer_id | int(11) | Manufacturer ID of the enlarger |
| enlarger | varchar(45) | Name/model of the enlarger |
| negative_size_id | int(11) | ID of the largest negative size that the enlarger can handle |
| acquired | date | Date on which the enlarger was acquired |
| lost | date | Date on which the enlarger was lost/sold |
| introduced | year(4) | Year in which the enlarger was introduced |
| discontinued | year(4) | Year in which the enlarger was discontinued |
| cost | decimal(6,2) | Purchase cost of the enlarger |
| lost_price | decimal(6,2) | Sale price of the enlarger |
+------------------+--------------+--------------------------------------------------------------+
=head2 EXHIBIT
Table to record which prints were displayed in which exhibitions
+---------------+-------------+----------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+---------------+-------------+----------------------------+
| exhibit_id | int(11) | Unique ID for this exhibit |
| exhibition_id | int(11) | ID of the exhibition |
| print_id | int(11) | ID of the print |
+---------------+-------------+----------------------------+
=head2 EXHIBITION
Table to record exhibition events
+---------------+--------------+-------------------------------+
| COLUMN_NAME | COLUMN_TYPE | COLUMN_COMMENT |
+---------------+--------------+-------------------------------+
| exhibition_id | int(11) | Unique ID for this exhibition |
| title | varchar(45) | Title of the exhibition |
| location | varchar(100) | Location of the exhibition |
| start_date | date | Start date of the exhibition |
( run in 2.547 seconds using v1.01-cache-2.11-cpan-39bf76dae61 )