podoc:paper_sql_table
This is an old revision of the document!
Database Table Description of "paper"
Name
paper
Description
Purpose
Schema
create table paper ( -- labels, for printing identifier integer not null primary key, name varchar(300), size_x float, size_y float, last_modified_date timestamp, last_modifying_users integer references users(identifier) );
Related sequences
Related indexes
Related functions
Related views
History
Used first
Version 2.5
Used last
Still in use
Schema change history
= Version 2.5 =
create table paper ( -- labels, for printing identifier integer not null primary key, name varchar(300), size_x float, size_y float, last_modified_date timestamp, last_modifying_users integer references users(identifier) );
Data change history
= Version 2.5 =
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'), 'Statement - (140 x 216 mm)', 396, 612, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'Tabloid - (279 x 432 mm)', 792, 1224, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'Ledger - (432 x 279 mm)', 1224, 792, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'Folio - (216 x 330 mm)', 612, 936, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'Quarto - (215 x 275 mm)', 610, 780, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'Executive - (190 x 254 mm)', 540, 720, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'A0 - (841 x 1189 mm)', 2384, 3370, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'A1 - (594 x 841 mm)', 1684, 2384, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'A2 - (420 x 594 mm)', 1191, 1684, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'A3 - (297 x 420 mm)', 842, 1191, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'A4 - (210 x 297 mm)', 595, 842, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'A5 - (148 x 210 mm)', 420, 595, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'A6 - (105 x 148 mm)', 297, 420, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'A7 - (74 x 105 mm)', 210, 297, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'A8 - (52 x 74 mm)', 148, 210, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'A9 - (37 x 52 mm)', 105, 148, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'A10 - (26 x 37 mm)', 73, 105, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'B0 - (1030 x 1456 mm)', 2920, 4127, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'B1 - (728 x 1030 mm)', 2064, 2920, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'B2 - (515 x 728 mm)', 1460, 2064, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'B3 - (364 x 515 mm)', 1032, 1460, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'B4 - (257 x 364 mm)', 729, 1032, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'B5 - (182 x 257 mm)', 516, 729, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'B6 - (128 x 182 mm)', 363, 516, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'B7 - (91 x 128 mm)', 258, 363, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'B8 - (64 x 91 mm)', 181, 258, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'B9 - (45 x 64 mm)', 127, 181, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'B10 - (32 x 45 mm)', 91, 127, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'C0 - (917 x 1297 mm)', 2599, 3676, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'C1 - (648 x 917 mm)', 1837, 2599, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'C2 - (458 x 648 mm)', 1298, 1837, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'C3 - (324 x 457 mm)', 918, 1296, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'C4 - (229 x 324 mm)', 649, 918, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'C5 - (162 x 229 mm)', 459, 649, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'C6 - (114 x 162 mm)', 323, 459, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'C7 - (81 x 114 mm)', 230, 323, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'ISOB0 - (1000 x 141 mm)', 2835, 4008, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'ISOB1 - (707 x 1000 mm)', 2004, 2835, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'ISOB2 - (500 x 707 mm)', 1417, 2004, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'ISOB3 - (353 x 500 mm)', 1001, 1417, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'ISOB4 - (250 x 353 mm)', 709, 1001, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'ISOB5 - (176 x 250 mm)', 499, 709, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'ISOB6 - (125 x 176 mm)', 354, 499, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'ISOB7 - (88 x 125 mm)', 249, 354, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'ISOB8 - (62 x 88 mm)', 176, 249, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'ISOB9 - (44 x 62 mm)', 125, 176, now(), 1); insert into paper values (nextval('paper_id_sequence'), 'ISOB10 - (31 x 44 mm)', 88, 125, now(), 1); insert into paper values (nextval('paper_id_sequence'), '7x9 - (178 x 229 mm)', 504, 648, now(), 1); insert into paper values (nextval('paper_id_sequence'), '9x11 - (229 x 279 mm)', 648, 792, now(), 1); insert into paper values (nextval('paper_id_sequence'), '9x12 - (229 x 305 mm)', 648, 864, now(), 1); insert into paper values (nextval('paper_id_sequence'), '10x13 - (254 x 330 mm)', 720, 936, now(), 1); insert into paper values (nextval('paper_id_sequence'), '10x14 - (254 x 356 mm)', 720, 1008, now(), 1);
podoc/paper_sql_table.1176457078.txt.gz · Last modified: 2007/04/13 09:37 by Luud