podoc:camera_sql_table
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionLast revisionBoth sides next revision | ||
podoc:camera_sql_table [2007/04/12 12:09] – created Luud | podoc:camera_sql_table [2007/04/20 14:25] – Luud | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Database Table Description ===== | + | ===== Database Table Description |
=== Name === | === Name === | ||
+ | |||
+ | camera | ||
=== Description === | === Description === | ||
+ | |||
+ | A listing of all *specific* cameras that the users owns, complete with serial number. A camera can be associated with a photo. | ||
=== Purpose === | === Purpose === | ||
+ | |||
+ | A user should be able to keep track of their cameras. | ||
=== Schema === | === Schema === | ||
+ | |||
+ | <code sql> | ||
+ | create table camera ( | ||
+ | identifier | ||
+ | type integer references camera_type(identifier), | ||
+ | users | ||
+ | serial_number | ||
+ | date_of_purchase | ||
+ | purchased_new | ||
+ | access_rights | ||
+ | ); | ||
+ | </ | ||
+ | |||
+ | === References tables === | ||
+ | |||
+ | * type references [[camera_type sql table|camera_type]](identifier) | ||
+ | * users references [[users sql table|users]](identifier) | ||
+ | * access_rights references [[access_type sql table|access_type]](identifier) | ||
+ | |||
+ | === Is referenced by tables === | ||
+ | |||
+ | * [[photo_tech sql table|photo_tech]](camera) references identifier | ||
=== Related sequences === | === Related sequences === | ||
+ | |||
+ | * [[camera_id_sequence sql sequence|camera_id_sequence]] | ||
=== Related indexes === | === Related indexes === | ||
+ | |||
+ | * [[camera_type_idx sql index|camera_type_idx]] | ||
+ | * [[camera_users_idx sql index|camera_users_idx]] | ||
+ | |||
+ | === Related functions === | ||
+ | |||
+ | * [[count_equipment_by_user sql function|count_equipment_by_user]] | ||
+ | * [[number_of_camera_references sql function|number_of_camera_references]] | ||
+ | |||
+ | === Related views === | ||
+ | |||
+ | * [[view_camera sql view|view_camera]] | ||
=== History === | === History === | ||
Line 17: | Line 59: | ||
== Used first == | == Used first == | ||
- | Verions | + | Version |
== Used last == | == Used last == | ||
Line 27: | Line 69: | ||
= Version 2.5 = | = Version 2.5 = | ||
- | | + | <code sql> |
- | | + | create table camera |
- | ); | + | |
+ | | ||
+ | users | ||
+ | serial_number | ||
+ | date_of_purchase | ||
+ | purchased_new | ||
+ | access_rights | ||
+ | ); | ||
+ | </ |
podoc/camera_sql_table.txt · Last modified: 2007/10/19 20:05 by Luud