User Tools

Site Tools


podoc:support_sql_table

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
podoc:support_sql_table [2007/04/19 08:15] Luudpodoc:support_sql_table [2007/04/20 14:37] Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create table support ( +<code sql> 
-    identifier            integer not null primary key, +create table support ( 
-    type                  integer not null references support_type(identifier), +  identifier            integer not null primary key, 
-    users                 integer not null references users(identifier), +  type                  integer not null references support_type(identifier), 
-    serial_number         varchar(20), +  users                 integer not null references users(identifier), 
-    date_of_purchase      timestamp, +  serial_number         varchar(20), 
-    purchased_new         char(1) check (purchased_new in ('t', 'f')), +  date_of_purchase      timestamp, 
-    access_rights         integer not null references access_type(identifier) +  purchased_new         char(1) check (purchased_new in ('t', 'f')), 
-  );+  access_rights         integer not null references access_type(identifier) 
 +); 
 +</code> 
 + 
 +=== References tables === 
 + 
 +None. 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[photo_tech sql table|photo_tech]](support) references identifier
  
 === Related sequences === === Related sequences ===
Line 53: Line 63:
 = Version 2.5 = = Version 2.5 =
  
-  create table support ( +<code> 
-    identifier            integer not null primary key, +create table support ( 
-    type                  integer not null references support_type(identifier), +  identifier            integer not null primary key, 
-    users                 integer not null references users(identifier), +  type                  integer not null references support_type(identifier), 
-    serial_number         varchar(20), +  users                 integer not null references users(identifier), 
-    date_of_purchase      timestamp, +  serial_number         varchar(20), 
-    purchased_new         char(1) check (purchased_new in ('t', 'f')), +  date_of_purchase      timestamp, 
-    access_rights         integer not null references access_type(identifier) +  purchased_new         char(1) check (purchased_new in ('t', 'f')), 
-  );+  access_rights         integer not null references access_type(identifier) 
 +); 
 +</code>
  
podoc/support_sql_table.txt · Last modified: 2007/04/20 15:22 by Luud