User Tools

Site Tools


podoc:scan_bitdepth_sql_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
podoc:scan_bitdepth_sql_table [2007/04/12 12:33]
Luud
podoc:scan_bitdepth_sql_table [2007/04/20 14:30] (current)
Luud
Line 1: Line 1:
-===== Database Table Description =====+===== Database Table Description of "scan_bitdepth" =====
  
 === Name === === Name ===
 +
 +scan_bitdepth
  
 === Description === === Description ===
Line 8: Line 10:
  
 === Schema === === Schema ===
 +
 +<code sql>
 +create table scan_bitdepth (
 +  identifier            integer not null primary key,
 +  value                 varchar(6)
 +);
 +</code>
 +
 +=== References tables ===
 +
 +None.
 +
 +=== Is referenced by tables ===
 +
 +  * [[photo_tech sql table|photo_tech]](scan_bitdepth) references identifier
  
 === Related sequences === === Related sequences ===
 +
 +  * [[scan_bitdepth_id_sequence sql sequence|scan_bitdepth_id_sequence]]
  
 === Related indexes === === Related indexes ===
 +
 +None.
  
 === Related functions === === Related functions ===
 +
 +None.
  
 === Related views === === Related views ===
 +
 +None.
  
 === History === === History ===
Line 27: Line 52:
 Still in use Still in use
  
-== Change history ==+== Schema change history ==
  
 = Version 2.5 = = Version 2.5 =
  
-  create table ... +<code sql> 
-    ...   +create table scan_bitdepth 
-  );+  identifier            integer not null primary key, 
 +  value                 varchar(6) 
 +); 
 +</code> 
 + 
 +== Data change history == 
 + 
 += Version 2.5 = 
 + 
 +<code sql> 
 +insert into scan_bitdepth values (nextval('scan_bitdepth_id_sequence'), '8'); 
 +insert into scan_bitdepth values (nextval('scan_bitdepth_id_sequence'), '12'); 
 +insert into scan_bitdepth values (nextval('scan_bitdepth_id_sequence'), '14'); 
 +insert into scan_bitdepth values (nextval('scan_bitdepth_id_sequence'), '16'); 
 +insert into scan_bitdepth values (nextval('scan_bitdepth_id_sequence'), '18'); 
 +insert into scan_bitdepth values (nextval('scan_bitdepth_id_sequence'), '24'); 
 +insert into scan_bitdepth values (nextval('scan_bitdepth_id_sequence'), '32'); 
 +</code> 
podoc/scan_bitdepth_sql_table.1176381239.txt.gz · Last modified: 2007/04/12 12:33 by Luud