User Tools

Site Tools


podoc:paper_sql_table

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
podoc:paper_sql_table [2007/04/19 08:49] Luudpodoc:paper_sql_table [2007/04/20 15:29] (current) Luud
Line 11: Line 11:
 === Schema === === Schema ===
  
-  create table paper ( -- labels, for printing +<code sql> 
-    identifier            integer not null primary key, +create table paper ( -- labels, for printing 
-    name                  varchar(300), +  identifier            integer not null primary key, 
-    size_x                float, +  name                  varchar(300), 
-    size_y                float, +  size_x                float, 
-    last_modified_date timestamp, +  size_y                float, 
-    last_modifying_users  integer references users(identifier) +  last_modified_date timestamp, 
-  );+  last_modifying_users  integer references users(identifier) 
 +); 
 +</code> 
 + 
 +=== References tables === 
 + 
 +  * last_modifying_users references [[users sql table|users]](identifier) 
 + 
 +=== Is referenced by tables === 
 + 
 +  * [[label sql table|label]](paper) references identifier 
 +  * [[preferences sql table|preferences]](paper) references identifier 
 +  * [[system_preferences sql table|system_preferences]](new_user_paper) references identifier
  
 === Related sequences === === Related sequences ===
Line 50: Line 62:
 = Version 2.5 = = Version 2.5 =
  
-  create table paper ( -- labels, for printing +<code sql> 
-    identifier            integer not null primary key, +create table paper ( -- labels, for printing 
-    name                  varchar(300), +  identifier            integer not null primary key, 
-    size_x                float, +  name                  varchar(300), 
-    size_y                float, +  size_x                float, 
-    last_modified_date timestamp, +  size_y                float, 
-    last_modifying_users  integer references users(identifier) +  last_modified_date timestamp, 
-  );+  last_modifying_users  integer references users(identifier) 
 +); 
 +</code>
  
 == Data change history == == Data change history ==
Line 63: Line 77:
 = Version 2.5 = = Version 2.5 =
  
-<code>+<code sql>
 insert into paper values (nextval('paper_id_sequence'), 'Letter    - (216 x 279 mm)',   612,  792,  now(), 1); insert into paper values (nextval('paper_id_sequence'), 'Letter    - (216 x 279 mm)',   612,  792,  now(), 1);
 insert into paper values (nextval('paper_id_sequence'), 'Legal     - (216 x 356 mm)',   612,  1008, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'Legal     - (216 x 356 mm)',   612,  1008, now(), 1);
Line 119: Line 133:
 insert into paper values (nextval('paper_id_sequence'), '10x14     - (254 x 356 mm)',   720,  1008, now(), 1); insert into paper values (nextval('paper_id_sequence'), '10x14     - (254 x 356 mm)',   720,  1008, now(), 1);
 </code> </code>
- 
  
podoc/paper_sql_table.1176972597.txt.gz · Last modified: 2007/04/19 08:49 by Luud