The '''IPIX''' ''project'' Makes use of the `CCPKI` project. The table layout is a simple:

SQL> desc ipixusers
Name Null? Type

PASS NOT NULL VARCHAR2(64)
BUSUNIT NOT NULL VARCHAR2(64)
USERNAME NOT NULL VARCHAR2(64)
SQL> desc ipixads
Name Null? Type

FIRSTNAME VARCHAR2(64)
LASTNAME VARCHAR2(64)
ADDR1 VARCHAR2(64)
ADDR2 VARCHAR2(64)
CITY VARCHAR2(64)
STATE VARCHAR2(64)
ZIP VARCHAR2(64)
PHONE VARCHAR2(64)
EMAIL VARCHAR2(64)
ADTEXT VARCHAR2(256)
PIC1 VARCHAR2(128)
PIC2 VARCHAR2(128)
PIC3 VARCHAR2(128)
PIC4 VARCHAR2(128)
PIC5 VARCHAR2(128)
CLASSIFICATION VARCHAR2(64)
IMAGECOUNT NUMBER(10,4)
STARTDATE DATE
DURATION NUMBER(10,4)
RUNONLYON VARCHAR2(64)
CCNUMBER VARCHAR2(64)
CCTYPE VARCHAR2(64)
CCEXP DATE
BUSUNIT VARCHAR2(64)
SESSIONID VARCHAR2(128)
PROCSTATE NOT NULL VARCHAR2(32)
LOCALID VARCHAR2(128)
PICSENT VARCHAR2(10)
INPRINT VARCHAR2(10)
DATECREATED DATE
PROCSTATE values can be "approved|unprocessed" BUSUNIT is "knoxnews|test" Each pic represents a triplet of images a thumbnail, and medium res, and a hires-for-print version. the PICn fields hold a URL reference to the medium res image. To get the thumbnail, insert "thumb/" after the last "/" in the URL and insert "_t" just before the ".jpg" To get the large rendition, simply add "_l" just before the ".jpg"