User Tools

Site Tools


podoc:scanner_type_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
podoc:scanner_type_sql_table [2007/04/20 10:46]
Luud
podoc:scanner_type_sql_table [2007/04/20 11:01] (current)
Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  ​create table scanner_type ( +<code sql> 
-    identifier ​           integer not null primary key, +create table scanner_type ( 
-    manufacturer ​         integer not null references manufacturer(identifier),​ +  identifier ​           integer not null primary key, 
-    model                 ​varchar(100),​ +  manufacturer ​         integer not null references manufacturer(identifier),​ 
-    variation ​            ​varchar(100),​ +  model                 ​varchar(100),​ 
-    last_modified_date ​   timestamp,​ +  variation ​            ​varchar(100),​ 
-    last_modifying_users ​ integer references users(identifier) +  last_modified_date ​   timestamp,​ 
-  );+  last_modifying_users ​ integer references users(identifier) 
 +); 
 +</​code>​
  
 === References tables === === References tables ===
  
-None.+  * last_modifying_users references [[users sql table|users]](identifier) 
 +  * manufacturer references [[manufacturer sql table|manufacturer]](identifier)
  
 === Is referenced by tables === === Is referenced by tables ===
  
-None.+  * [[scanner sql table|scanner]](type) references identifier
  
 === Related sequences === === Related sequences ===
Line 59: Line 62:
 = Version 2.5 = = Version 2.5 =
  
-  ​create table scanner_type ( +<code sql> 
-    identifier ​           integer not null primary key, +create table scanner_type ( 
-    manufacturer ​         integer not null references manufacturer(identifier),​ +  identifier ​           integer not null primary key, 
-    model                 ​varchar(100),​ +  manufacturer ​         integer not null references manufacturer(identifier),​ 
-    variation ​            ​varchar(100),​ +  model                 ​varchar(100),​ 
-    last_modified_date ​   timestamp,​ +  variation ​            ​varchar(100),​ 
-    last_modifying_users ​ integer references users(identifier) +  last_modified_date ​   timestamp,​ 
-  );+  last_modifying_users ​ integer references users(identifier) 
 +); 
 +</​code>​
  
podoc/scanner_type_sql_table.txt · Last modified: 2007/04/20 11:01 by Luud