User's Manual

PICS User’s Manual 07 June 2004

CREATE TABLE "PICS" (

USER_ID VARCHAR(64) NOT NULL,

USER_ID_LEN INTEGER,

PIC_KEY VARCHAR(512),

NAME VARCHAR(64),

PIC_ID VARCHAR(24),

PIC_KEY_LEN INTEGER,

DURESS_ID VARCHAR(64),

DURESS_LEN INTEGER,

PIN VARCHAR(16),

CONSTRAINT "USER_ID" PRIMARY KEY ("USER_ID")

);

CREATE TABLE "PICS_UPDATE" (

USER_ID VARCHAR(64) NOT NULL,

PIC_ID VARCHAR(24) NOT NULL,

CMD VARCHAR(32),

CMD_INDEX INTEGER

);

CREATE ROLE Administrators;

CREATE ROLE Users;

GRANT ALL ON PICS TO Administrators;

GRANT ALL ON PICS_UPDATE TO Administrators;

GRANT SELECT,DELETE,INSERT,UPDATE ON PICS TO Users;

GRANT SELECT,DELETE,INSERT,UPDATE ON PICS_UPDATE TO Users;

3.4 PICS Status Operation

The PICS Status software provides a means to display on screen what is currently

occurring at the PICS Reader. The display includes indicators for the current traffic light

status, as well as the PIC user’s name and the current battery voltage of their PIC. This

software can run on any computer connected to the database server and the computer

running the PICS Reader Control. The display is shown in Figure 11. Note that a green

light and a blinking yellow light together indicates that the user validated using their

duress fingerprint.