Chris,

Following is table structure:

TLISTING:
LIST_ID NOT NULL NUMBER
CATEGORY_ID NUMBER
USER_ID NUMBER
LIST_STATUS_ID NUMBER
TITLE NOT NULL VARCHAR2(80)
SHORT_DESC NOT NULL VARCHAR2(150)
DESCRIPTION --(STORED OUTSIDE TABLE, IN OTHER TABLESPACE) NOT NULL CLOB
DESC_TYPE_FLAG VARCHAR2(1)
RATE NOT NULL NUMBER(10,2)
LIST_TYPE_ID NUMBER
CALLS_RECEIVED NUMBER
CALLS_FAILED NUMBER
NUM_PAID_EMAILS NUMBER
RELIABILITY_PCT NUMBER
AVG_GRADE NUMBER
CREATION_DATE DATE
========================================
TLISTRECORDING:
---------------
LIST_ID NOT NULL NUMBER
RECORDING_TYPE_ID NUMBER
LENGTH NOT NULL NUMBER
RECORDING NOT NULL BLOB

==================================================
TUSERAUTH:
-------------
USER_ID NOT NULL NUMBER
USERNAME NOT NULL VARCHAR2(30)
PASSWORD NOT NULL VARCHAR2(30)
PIN NUMBER
RESTRICTED_ACCESS VARCHAR2(1)
ACT_STATUS_ID NUMBER

==========================================================
TCATEGORY:
------------
CATEGORY_ID NOT NULL NUMBER
PARENT_ID NUMBER
NAME NOT NULL VARCHAR2(75)
LEAF_FLAG VARCHAR2(1)
DISPLAY_ORDER NOT NULL NUMBER
NUM_LISTINGS NUMBER

thanks,

np70