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