User Tools

Site Tools


podoc:label_sql_table

Database Table Description of "label"

Name

label

Description

Purpose

Schema

CREATE TABLE label ( -- labels, for printing
  identifier            INTEGER NOT NULL PRIMARY KEY,
  users                 INTEGER REFERENCES users(identifier),
  manufacturer          INTEGER REFERENCES manufacturer(identifier),
  name                  VARCHAR(300),
  space_x               FLOAT,
  space_y               FLOAT,
  size_x                FLOAT,
  size_y                FLOAT,
  offset_x              FLOAT,
  offset_y              FLOAT,
  COLUMNS               FLOAT,
  ROWS                  FLOAT,
  paper                 INTEGER NOT NULL REFERENCES paper(identifier),
  date_of_creation      TIMESTAMP,
  last_modified_date 	TIMESTAMP
);

References tables

  • manufacturer references manufacturer(identifier)
  • paper references paper(identifier)
  • 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 label ( -- labels, for printing
  identifier            INTEGER NOT NULL PRIMARY KEY,
  users                 INTEGER REFERENCES users(identifier),
  manufacturer          INTEGER REFERENCES manufacturer(identifier),
  name                  VARCHAR(300),
  space_x               FLOAT,
  space_y               FLOAT,
  size_x                FLOAT,
  size_y                FLOAT,
  offset_x              FLOAT,
  offset_y              FLOAT,
  COLUMNS               FLOAT,
  ROWS                  FLOAT,
  paper                 INTEGER NOT NULL REFERENCES paper(identifier),
  date_of_creation      TIMESTAMP,
  last_modified_date 	TIMESTAMP
);
Data change history

= Version 2.5 =

INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5267 - Return Address', 2.06300*25.4, 0.50000*25.4, 1.75000*25.4, 0.50000*25.4, 0.28100*25.4, 0.50000*25.4, 4, 20, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5960 - Address', 2.75000*25.4, 1.00000*25.4, 2.62500*25.4, 1.00000*25.4, 0.18800*25.4, 0.50000*25.4, 3, 10, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5961 - Address', 4.18750*25.4, 1.00000*25.4, 4.00000*25.4, 1.00000*25.4, 0.15600*25.4, 0.50000*25.4, 2, 10, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5962 - Address', 4.18750*25.4, 1.33330*25.4, 4.00000*25.4, 1.33330*25.4, 0.15600*25.4, 0.83330*25.4, 2, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5963 - Address', 4.18750*25.4, 2.00000*25.4, 4.00000*25.4, 2.00000*25.4, 0.15600*25.4, 0.50000*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5264 - Address', 4.18750*25.4, 3.33330*25.4, 4.00000*25.4, 3.33330*25.4, 0.15600*25.4, 0.50000*25.4, 2, 3, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5667 - Clear Return Address', 2.05000*25.4, 0.50000*25.4, 1.75000*25.4, 0.50000*25.4, 0.30000*25.4, 0.50000*25.4, 4, 20, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5930 - Clear Address', 2.83330*25.4, 1.00000*25.4, 2.83300*25.4, 1.00000*25.4, 0.00000*25.4, 0.50000*25.4, 3, 10, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5932 - Clear Address', 4.25000*25.4, 1.33300*25.4, 4.25000*25.4, 1.33300*25.4, 0.00000*25.4, 0.83500*25.4, 2, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5664 - Clear Address', 4.25000*25.4, 3.33330*25.4, 4.25000*25.4, 3.33300*25.4, 0.00000*25.4, 0.50000*25.4, 2, 3, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5265 - Full Sheet', 0.00000*25.4, 0.00000*25.4, 8.50000*25.4, 11.00000*25.4, 0.00000*25.4, 0.00000*25.4, 1, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5266 - File Folder-Assorted', 4.00000*25.4, 0.67500*25.4, 3.43800*25.4, 0.54100*25.4, 0.53100*25.4, 0.50000*25.4, 2, 15, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5388 - Index Card', 5.00000*25.4, 3.00000*25.4, 5.00000*25.4, 3.00000*25.4, 1.75000*25.4, 1.00000*25.4, 1, 3, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5305 - Laser Tent Cards Med.', 8.50000*25.4, 5.00000*25.4, 7.75000*25.4, 4.25000*25.4, 0.37500*25.4, 0.87500*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5309 - Laser Tent Cards Large', 11.00000*25.4, 7.00000*25.4, 10.25000*25.4, 6.25000*25.4, 0.37500*25.4, 1.12500*25.4, 1, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5315 - Laser Note Cards', 5.50000*25.4, 0.00000*25.4, 5.50000*25.4, 8.50000*25.4, 0.00000*25.4, 0.00000*25.4, 2, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '6020 - 35mm Slide', 2.54, 0, 43.18, 8.47, 14.83, 12.91, 4, 32, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8920 - Ink Jet Address', 2.75000*25.4, 1.00000*25.4, 2.62500*25.4, 1.00000*25.4, 0.18800*25.4, 0.50000*25.4, 3, 10, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8161 - Ink Jet Address', 4.18750*25.4, 1.00000*25.4, 4.00000*25.4, 1.00000*25.4, 0.15600*25.4, 0.50000*25.4, 2, 10, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8922 - Ink Jet Address', 4.18750*25.4, 1.33330*25.4, 4.00000*25.4, 1.33330*25.4, 0.15600*25.4, 0.83330*25.4, 2, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8923 - Ink Jet Address', 4.18750*25.4, 2.00000*25.4, 4.00000*25.4, 2.00000*25.4, 0.15600*25.4, 0.50000*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8164 - Ink Jet Address', 4.18750*25.4, 3.33330*25.4, 4.00000*25.4, 3.33330*25.4, 0.15600*25.4, 0.50000*25.4, 2, 3, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8165 - Ink Jet Full Sheet', 8.50000*25.4, 11.00000*25.4, 8.50000*25.4, 11.00000*25.4, 0.00000*25.4, 0.00000*25.4, 1, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8166 - Ink Jet File Folder-Assorted', 4.00000*25.4, 0.67500*25.4, 3.43800*25.4, 0.54100*25.4, 0.53100*25.4, 0.50000*25.4, 2, 15, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8927 - Ink Jet Return Address', 2.06300*25.4, 0.50000*25.4, 1.75000*25.4, 0.50000*25.4, 0.28100*25.4, 0.50000*25.4, 4, 20, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8315 - Ink Jet Note Cards', 5.50000*25.4, 0.00000*25.4, 5.50000*25.4, 8.50000*25.4, 0.00000*25.4, 0.00000*25.4, 2, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8316 - Ink Jet Greeting Card(Portrait)', 8.50000*25.4, 5.50000*25.4, 8.50000*25.4, 5.50000*25.4, 0.00000*25.4, 0.00000*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8316 - Ink Jet Greeting Card(Landscape)', 5.50000*25.4, 8.50000*25.4, 5.50000*25.4, 8.50000*25.4, 0.00000*25.4, 0.00000*25.4, 2, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8371 - Ink Jet Business Card', 3.50000*25.4, 2.00000*25.4, 3.50000*25.4, 2.00000*25.4, 0.75000*25.4, 0.50000*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8372 - Ink Jet Business Card', 3.50000*25.4, 2.00000*25.4, 3.50000*25.4, 2.00000*25.4, 0.75000*25.4, 0.50000*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8660 - Ink Jet Clear Address', 2.75000*25.4, 1.00000*25.4, 2.62500*25.4, 1.00000*25.4, 0.18800*25.4, 0.50000*25.4, 3, 10, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8930 - Ink Jet Clear Address', 2.75000*25.4, 1.00000*25.4, 2.62500*25.4, 1.00000*25.4, 0.18800*25.4, 0.50000*25.4, 3, 10, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8662 - Ink Jet Clear Address', 4.18750*25.4, 1.33330*25.4, 4.00000*25.4, 1.33330*25.4, 0.15600*25.4, 0.83330*25.4, 2, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8932 - Ink Jet Clear Address', 4.18750*25.4, 1.33330*25.4, 4.00000*25.4, 1.33330*25.4, 0.15600*25.4, 0.83330*25.4, 2, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '8663 - Ink Jet Clear Address/Shipping', 4.18750*25.4, 2.00000*25.4, 4.00000*25.4, 2.00000*25.4, 0.15600*25.4, 0.50000*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '2160 - Addressing', 2.63000*25.4, 1.00000*25.4, 2.63000*25.4, 1.00000*25.4, 0.81000*25.4, 0.50000*25.4, 1, 8, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '2162 - Addressing', 4.00000*25.4, 1.33330*25.4, 4.00000*25.4, 1.33330*25.4, 0.12500*25.4, 0.50000*25.4, 1, 6, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '2163 - Address/Shipping', 4.00000*25.4, 2.00000*25.4, 4.00000*25.4, 2.00000*25.4, 0.12500*25.4, 0.50000*25.4, 1, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '2164 - Shipping', 4.00000*25.4, 5.00000*25.4, 4.00000*25.4, 3.31250*25.4, 0.12500*25.4, 0.84375*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '2660 - Clear Address', 2.63000*25.4, 1.00000*25.4, 2.63000*25.4, 1.00000*25.4, 0.81000*25.4, 0.50000*25.4, 1, 8, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '2662 - Clear Address', 4.25000*25.4, 1.33330*25.4, 4.25000*25.4, 1.33330*25.4, 0.00000*25.4, 0.50000*25.4, 1, 6, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '2663 - Clear Address/Shipping', 4.25000*25.4, 2.00000*25.4, 4.25000*25.4, 2.00000*25.4, 0.00000*25.4, 0.50000*25.4, 1, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '2180 - File Folder-Assorted', 3.44000*25.4, 0.67500*25.4, 3.44000*25.4, 0.54100*25.4, 0.40500*25.4, 0.50000*25.4, 1, 12, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '2181 - File Folder-White', 3.44000*25.4, 0.67500*25.4, 3.44000*25.4, 0.66600*25.4, 0.40500*25.4, 0.50000*25.4, 1, 12, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5824 - CD-Recordable Labels', 4.50000*25.4, 5.50000*25.4, 4.50000*25.4, 4.50000*25.4, 2.00000*25.4, 0.50000*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5836 - MtgCreator Portfolio Label', 3.50000*25.4, 2.00000*25.4, 3.50000*25.4, 2.00000*25.4, 0.75000*25.4, 0.50000*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5836 - MtgCreator Divider 5 Tab', 2.05000*25.4, 0.50000*25.4, 1.75000*25.4, 0.50000*25.4, 0.30000*25.4, 0.50000*25.4, 4, 20, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5841 - MtgCreator Portfolio Label', 3.50000*25.4, 2.00000*25.4, 3.50000*25.4, 2.00000*25.4, 0.75000*25.4, 0.50000*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5843 - MtgCreator Name Badge', 3.50000*25.4, 2.16667*25.4, 3.50000*25.4, 2.16667*25.4, 0.75000*25.4, 1.16667*25.4, 2, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5844 - MtgCreator Tent Card', 8.50000*25.4, 5.00000*25.4, 7.75000*25.4, 4.25000*25.4, 0.37500*25.4, 0.87500*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5845 - MtgCreator Clear Address', 2.83300*25.4, 1.00000*25.4, 2.83300*25.4, 1.00000*25.4, 0.00000*25.4, 0.50000*25.4, 3, 10, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '5845 - MtgCreator Note Card', 5.50000*25.4, 0.00000*25.4, 5.50000*25.4, 8.50000*25.4, 0.00000*25.4, 0.00000*25.4, 2, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '3110 - Rectangle Stickers', 2.68750*25.4, 1.50000*25.4, 2.37500*25.4, 1.25000*25.4, 0.37500*25.4, 1.12500*25.4, 3, 6, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '3111 - Square Stickers', 2.68750*25.4, 3.00000*25.4, 2.50000*25.4, 2.50000*25.4, 0.31300*25.4, 1.25000*25.4, 3, 3, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '3112 - Small Round Stickers', 2.00000*25.4, 2.00000*25.4, 1.50000*25.4, 1.50000*25.4, 0.50000*25.4, 0.75000*25.4, 4, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '3113 - Big Round Stickers', 2.68750*25.4, 3.00000*25.4, 2.50000*25.4, 2.50000*25.4, 0.31250*25.4, 1.25000*25.4, 3, 3, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '3114 - Full Page Stickers', 8.50000*25.4, 11.00000*25.4, 8.50000*25.4, 11.00000*25.4, 0.00000*25.4, 0.00000*25.4, 1, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '3610 - Greeting Cards', 7.00000*25.4, 5.00000*25.4, 7.00000*25.4, 4.50000*25.4, 0.75000*25.4, 0.75000*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '3611 - Postcards', 6.00000*25.4, 4.50000*25.4, 6.00000*25.4, 4.00000*25.4, 1.25000*25.4, 1.25000*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '3612 - Biz Cards', 4.00000*25.4, 2.50000*25.4, 3.50000*25.4, 2.00000*25.4, 0.50000*25.4, 0.75000*25.4, 2, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, '3613 - Laminated ID Cards', 3.25000*25.4, 3.66660*25.4, 3.25000*25.4, 2.00000*25.4, 4.31250*25.4, 0.83330*25.4, 1, 3, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7159 - Address', 2.61969*25.4, 1.33307*25.4, 2.51969*25.4, 1.33307*25.4, 0.25433*25.4, 0.54272*25.4, 3, 8, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7160 - Address', 2.60039*25.4, 1.50000*25.4, 2.50000*25.4, 1.50000*25.4, 0.28346*25.4, 0.62500*25.4, 3, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7161 - Address', 2.60000*25.4, 1.83307*25.4, 2.50000*25.4, 1.83307*25.4, 0.28386*25.4, 0.37579*25.4, 3, 6, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7162 - Address', 4.00000*25.4, 1.33346*25.4, 3.90000*25.4, 1.33346*25.4, 0.18386*25.4, 0.54114*25.4, 2, 8, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7163 - Address', 4.00000*25.4, 1.50000*25.4, 3.90000*25.4, 1.50000*25.4, 0.18386*25.4, 0.62500*25.4, 2, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7164 - Address', 2.60000*25.4, 2.83335*25.4, 2.50000*25.4, 2.83335*25.4, 0.28386*25.4, 0.20827*25.4, 3, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7165 - Parcel', 4.00000*25.4, 2.66654*25.4, 3.90000*25.4, 2.66654*25.4, 0.18386*25.4, 0.54173*25.4, 2, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7166 - Parcel', 4.00000*25.4, 3.66654*25.4, 3.90000*25.4, 3.66654*25.4, 0.18386*25.4, 0.37500*25.4, 2, 3, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7167 - Shipping', 7.85827*25.4, 11.37992*25.4, 7.85827*25.4, 11.37992*25.4, 0.20472*25.4, 0.18504*25.4, 1, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7168 - Shipping', 7.85827*25.4, 5.65079*25.4, 7.85827*25.4, 5.65079*25.4, 0.18504*25.4, 0.22421*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7169 - Parcel', 5.47244*25.4, 4.00157*25.4, 5.47244*25.4, 3.90157*25.4, 0.40236*25.4, 0.18228*25.4, 2, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7173 - Shipping', 4.00000*25.4, 2.24409*25.4, 3.90000*25.4, 2.24409*25.4, 0.18386*25.4, 0.26476*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7551 - Clear Mini Address', 1.60000*25.4, 0.83346*25.4, 1.50000*25.4, 0.83346*25.4, 0.18386*25.4, 0.45827*25.4, 5, 13, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7552 - Petite Clear', 4.10169*25.4, 0.83331*25.4, 2.16598*25.4, 0.50000*25.4, 1.00000*25.4, 1.87500*25.4, 2, 10, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7553 - Petite Clear', 1.80000*25.4, 0.66661*25.4, 0.86598*25.4, 0.50000*25.4, 1.00000*25.4, 1.95799*25.4, 4, 12, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7560 - Clear Address', 2.60039*25.4, 1.50000*25.4, 2.50000*25.4, 1.50000*25.4, 0.28346*25.4, 0.62500*25.4, 3, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7562 - Clear Address', 4.00000*25.4, 1.33346*25.4, 3.90000*25.4, 1.33346*25.4, 0.18386*25.4, 0.54114*25.4, 2, 8, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7563 - Clear Address', 4.00000*25.4, 1.50000*25.4, 3.90000*25.4, 1.50000*25.4, 0.18386*25.4, 0.62500*25.4, 2, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7565 - Clear Parcel', 4.00000*25.4, 2.66654*25.4, 3.90000*25.4, 2.66654*25.4, 0.18386*25.4, 0.54173*25.4, 2, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7263 - Address', 4.00000*25.4, 1.50000*25.4, 3.90000*25.4, 1.50000*25.4, 0.18386*25.4, 0.62500*25.4, 2, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7651 - Mini Address', 1.60000*25.4, 0.83346*25.4, 1.50000*25.4, 0.83346*25.4, 0.18386*25.4, 0.45827*25.4, 5, 13, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7656 - 35mm Slide', 1.99488*25.4, 0.50000*25.4, 1.81102*25.4, 0.43740*25.4, 0.22717*25.4, 0.65630*25.4, 4, 21, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7665 - Mini Data Cartridge', 3.70079*25.4, 0.83150*25.4, 2.83465*25.4, 0.83268*25.4, 0.86614*25.4, 0.87795*25.4, 2, 12, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7667 - Standard Data Cartridge', 5.23622*25.4, 1.16575*25.4, 5.23622*25.4, 1.16575*25.4, 1.51575*25.4, 0.62913*25.4, 1, 9, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7690 - Mini Address', 1.60000*25.4, 0.83346*25.4, 1.50000*25.4, 0.83346*25.4, 0.18386*25.4, 0.45827*25.4, 5, 13, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7170 - Eurofolio', 5.27559*25.4, 0.43307*25.4, 5.27559*25.4, 0.43307*25.4, 1.49606*25.4, 0.67815*25.4, 1, 24, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7172 - Ring Binder', 4.03701*25.4, 1.18110*25.4, 3.93701*25.4, 1.18110*25.4, 0.14685*25.4, 0.56004*25.4, 2, 9, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7171 - Lever Arch', 2.36220*25.4, 7.87402*25.4, 2.36220*25.4, 7.87402*25.4, 1.15059*25.4, 0.19685*25.4, 4, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7701 - Lever Arch', 2.44094*25.4, 7.55906*25.4, 2.44094*25.4, 7.55906*25.4, 0.99311*25.4, 0.35433*25.4, 4, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7702 - Lever Arch', 1.53543*25.4, 7.55906*25.4, 1.53543*25.4, 7.55906*25.4, 0.50098*25.4, 0.35433*25.4, 7, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7413 - Business Card', 3.54331*25.4, 2.00000*25.4, 3.54331*25.4, 2.00000*25.4, 0.59055*25.4, 0.84646*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7414 - Business Card', 3.54331*25.4, 2.04724*25.4, 3.54331*25.4, 2.04724*25.4, 0.59055*25.4, 0.72835*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7415 - Business Card', 3.54331*25.4, 2.04724*25.4, 3.54331*25.4, 2.04724*25.4, 0.59055*25.4, 0.72835*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7417 - Business Card', 3.54331*25.4, 2.12598*25.4, 3.54331*25.4, 2.12598*25.4, 0.59055*25.4, 0.53150*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7419 - Business Card', 3.54331*25.4, 2.12598*25.4, 3.54331*25.4, 2.12598*25.4, 0.59055*25.4, 0.53150*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7418 - Name Badge', 3.38583*25.4, 2.16535*25.4, 3.38583*25.4, 2.16535*25.4, 0.74803*25.4, 1.51575*25.4, 2, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7421 - Post Card', 5.48701*25.4, 3.83031*25.4, 5.48701*25.4, 3.83031*25.4, 0.37323*25.4, 0.30354*25.4, 2, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7901 - Organizer Page', 3.74016*25.4, 6.69291*25.4, 3.74016*25.4, 6.69291*25.4, 0.00000*25.4, 0.00000*25.4, 3, 1, 13, now(), now());
 
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L7902 - Organizer Page', 5.84646*25.4, 8.26772*25.4, 5.84646*25.4, 8.26772*25.4, 0.00000*25.4, 0.00000*25.4, 2, 1, 14, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8159 - Address', 2.61969*25.4, 1.33307*25.4, 2.51969*25.4, 1.33307*25.4, 0.25433*25.4, 0.54272*25.4, 3, 8, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8160 - Address', 2.60039*25.4, 1.50000*25.4, 2.50000*25.4, 1.50000*25.4, 0.28346*25.4, 0.62500*25.4, 3, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8161 - Address', 2.60000*25.4, 1.83307*25.4, 2.50000*25.4, 1.83307*25.4, 0.28386*25.4, 0.37579*25.4, 3, 6, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8162 - Address', 4.00000*25.4, 1.33346*25.4, 3.90000*25.4, 1.33346*25.4, 0.18386*25.4, 0.54114*25.4, 2, 8, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8163 - Address', 4.00000*25.4, 1.50000*25.4, 3.90000*25.4, 1.50000*25.4, 0.18386*25.4, 0.62500*25.4, 2, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8164 - Address', 2.60000*25.4, 2.83335*25.4, 2.50000*25.4, 2.83335*25.4, 0.28386*25.4, 0.20827*25.4, 3, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8165 - Parcel', 4.00000*25.4, 2.66654*25.4, 3.90000*25.4, 2.66654*25.4, 0.18386*25.4, 0.54173*25.4, 2, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8166 - Parcel', 4.00000*25.4, 3.66654*25.4, 3.90000*25.4, 3.66654*25.4, 0.18386*25.4, 0.37500*25.4, 2, 3, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8167 - Shipping', 7.85827*25.4, 11.37992*25.4, 7.85827*25.4, 11.37992*25.4, 0.20472*25.4, 0.18504*25.4, 1, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8168 - Shipping', 7.85827*25.4, 5.65079*25.4, 7.85827*25.4, 5.65079*25.4, 0.18504*25.4, 0.22421*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8169 - Parcel', 5.47244*25.4, 4.00157*25.4, 5.47244*25.4, 3.90157*25.4, 0.40236*25.4, 0.18228*25.4, 2, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8173 - Shipping', 4.00000*25.4, 2.24409*25.4, 3.90000*25.4, 2.24409*25.4, 0.18386*25.4, 0.26476*25.4, 2, 5, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8360 - Address', 2.60039*25.4, 1.50000*25.4, 2.50000*25.4, 1.50000*25.4, 0.28346*25.4, 0.62500*25.4, 3, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8361 - Address', 2.60000*25.4, 1.83307*25.4, 2.50000*25.4, 1.83307*25.4, 0.28386*25.4, 0.37579*25.4, 3, 6, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8362 - Address', 4.00000*25.4, 1.33346*25.4, 3.90000*25.4, 1.33346*25.4, 0.18386*25.4, 0.54114*25.4, 2, 8, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8363 - Address', 4.00000*25.4, 1.50000*25.4, 3.90000*25.4, 1.50000*25.4, 0.18386*25.4, 0.62500*25.4, 2, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8365 - Parcel', 4.00000*25.4, 2.66654*25.4, 3.90000*25.4, 2.66654*25.4, 0.18386*25.4, 0.54173*25.4, 2, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8367 - Shipping', 7.85827*25.4, 11.37992*25.4, 7.85827*25.4, 11.37992*25.4, 0.20472*25.4, 0.18504*25.4, 1, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8368 - Shipping', 7.85827*25.4, 5.65079*25.4, 7.85827*25.4, 5.65079*25.4, 0.18504*25.4, 0.22421*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8560 - Clear Address', 2.60039*25.4, 1.50000*25.4, 2.50000*25.4, 1.50000*25.4, 0.28346*25.4, 0.62500*25.4, 3, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8562 - Clear Address', 4.00000*25.4, 1.33346*25.4, 3.90000*25.4, 1.33346*25.4, 0.18386*25.4, 0.54114*25.4, 2, 8, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8563 - Clear Address', 4.00000*25.4, 1.50000*25.4, 3.90000*25.4, 1.50000*25.4, 0.18386*25.4, 0.62500*25.4, 2, 7, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8565 - Clear Parcel', 4.00000*25.4, 2.66654*25.4, 3.90000*25.4, 2.66654*25.4, 0.18386*25.4, 0.54173*25.4, 2, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8651 - Mini Address', 1.60000*25.4, 0.83346*25.4, 1.50000*25.4, 0.83346*25.4, 0.18386*25.4, 0.45827*25.4, 5, 13, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J8657 - 35mm Slide', 1.99488*25.4, 0.50000*25.4, 1.81102*25.4, 0.43740*25.4, 1.23346*25.4, 2.40630*25.4, 3, 14, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L2160 - Address', 2.62992*25.4, 1.00000*25.4, 2.62992*25.4, 1.00000*25.4, 0.80984*25.4, 0.50000*25.4, 1, 8, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L2162 - Address', 4.00000*25.4, 1.32992*25.4, 4.00000*25.4, 1.33000*25.4, 0.12500*25.4, 0.50000*25.4, 1, 6, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L2163 - Parcel', 4.00000*25.4, 2.00000*25.4, 4.00000*25.4, 2.00000*25.4, 0.12500*25.4, 0.50000*25.4, 1, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L30063 - Address', 3.90157*25.4, 2.50000*25.4, 3.90157*25.4, 1.50000*25.4, 2.18307*25.4, 0.92520*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L30065 - Parcel', 3.90157*25.4, 2.66535*25.4, 3.90157*25.4, 2.66535*25.4, 0.23228*25.4, 1.59055*25.4, 2, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'L300SL - 35mm Slide', 1.81102*25.4, 1.33228*25.4, 1.81102*25.4, 0.43740*25.4, 0.51181*25.4, 0.70610*25.4, 4, 4, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J40063 - Address', 3.90157*25.4, 2.50000*25.4, 3.90157*25.4, 1.50000*25.4, 2.18307*25.4, 0.92520*25.4, 1, 2, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J40065 - Parcel', 3.90157*25.4, 2.66535*25.4, 3.90157*25.4, 2.66535*25.4, 0.23228*25.4, 1.59055*25.4, 2, 1, 13, now(), now());
INSERT INTO label VALUES (NEXTVAL('label_id_sequence'), NULL, 1, 'J400SL - 35mm Slide', 1.81102*25.4, 1.33228*25.4, 1.81102*25.4, 0.43740*25.4, 0.51181*25.4, 0.70610*25.4, 4, 4, 13, now(), now());
podoc/label_sql_table.txt · Last modified: 2007/04/20 11:28 by Luud