User Tools

Site Tools


podoc:paper_sql_table

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)
);

References tables

  • last_modifying_users references users(identifier)

Is referenced by tables

None.

None.

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.txt · Last modified: 2007/04/20 11:29 by Luud