Database reference - SAMPLE

SAMPLE -  table columns

All table columns

parentcolumndefinitioncomment
ADEFUSRWORKDEPT  CHARACTER (3)    
ADEFUSRNO_OF_EMPLOYEES  INTEGER (4)    
ACTACTNO  SMALLINT (2)    
ACTACTKWD  CHARACTER (6)    
ACTACTDESC  VARCHAR (20)    
CATALOGNAME  VARCHAR (128)    
CATALOGCATLOG  XML   
CL_SCHEDCLASS_CODE  CHARACTER (7)   same goes for the column... 
CL_SCHEDDAY  SMALLINT (2)   hi there 
CL_SCHEDSTARTING  TIME (3)   start of what? 
CL_SCHEDENDING  TIME (3)   end of what? 
CUSTOMERCID  BIGINT (8)    
CUSTOMERINFO  XML   
CUSTOMERHISTORY  XML   
DEPARTMENTDEPTNO  CHARACTER (3)    
DEPARTMENTDEPTNAME  VARCHAR (36)    
DEPARTMENTMGRNO  CHARACTER (6)    
DEPARTMENTADMRDEPT  CHARACTER (3)    
DEPARTMENTLOCATION  CHARACTER (16)    
EMP_PHOTOEMPNO  CHARACTER (6)    
EMP_PHOTOPHOTO_FORMAT  VARCHAR (10)    
EMP_PHOTOPICTURE  BLOB (102400)    
EMP_RESUMEEMPNO  CHARACTER (6)    
EMP_RESUMERESUME_FORMAT  VARCHAR (10)    
EMP_RESUMERESUME  CLOB (5120)    
EMPLOYEEEMPNO  CHARACTER (6)   the PK column of the employee table 
EMPLOYEEFIRSTNME  VARCHAR (12)    
EMPLOYEEMIDINIT  CHARACTER (1)    
EMPLOYEELASTNAME  VARCHAR (15)    
EMPLOYEEWORKDEPT  CHARACTER (3)    
EMPLOYEEPHONENO  CHARACTER (4)    
EMPLOYEEHIREDATE  DATE (4)    
EMPLOYEEJOB  CHARACTER (8)    
EMPLOYEEEDLEVEL  SMALLINT (2)    
EMPLOYEESEX  CHARACTER (1)    
EMPLOYEEBIRTHDATE  DATE (4)    
EMPLOYEESALARY  DECIMAL (9,2)    
EMPLOYEEBONUS  DECIMAL (9,2)    
EMPLOYEECOMM  DECIMAL (9,2)    
EMPMDCEMPNO  INTEGER (4)    
EMPMDCDEPT  INTEGER (4)    
EMPMDCDIV  INTEGER (4)    
EMPPROJACTEMPNO  CHARACTER (6)    
EMPPROJACTPROJNO  CHARACTER (6)    
EMPPROJACTACTNO  SMALLINT (2)    
EMPPROJACTEMPTIME  DECIMAL (5,2)    
EMPPROJACTEMSTDATE  DATE (4)    
EMPPROJACTEMENDATE  DATE (4)    
IN_TRAYRECEIVED  TIMESTAMP (10,6)    
IN_TRAYSOURCE  CHARACTER (8)    
IN_TRAYSUBJECT  CHARACTER (64)    
IN_TRAYNOTE_TEXT  VARCHAR (3000)    
INVENTORYPID  VARCHAR (10)    
INVENTORYQUANTITY  INTEGER (4)    
INVENTORYLOCATION  VARCHAR (128)    
ORGDEPTNUMB  SMALLINT (2)    
ORGDEPTNAME  VARCHAR (14)    
ORGMANAGER  SMALLINT (2)    
ORGDIVISION  VARCHAR (10)    
ORGLOCATION  VARCHAR (13)    
PRODUCTPID  VARCHAR (10)    
PRODUCTNAME  VARCHAR (128)    
PRODUCTPRICE  DECIMAL (30,2)    
PRODUCTPROMOPRICE  DECIMAL (30,2)    
PRODUCTPROMOSTART  DATE (4)    
PRODUCTPROMOEND  DATE (4)    
PRODUCTDESCRIPTION  XML   
PRODUCTSUPPLIERPID  VARCHAR (10)    
PRODUCTSUPPLIERSID  VARCHAR (10)    
PROJACTPROJNO  CHARACTER (6)    
PROJACTACTNO  SMALLINT (2)    
PROJACTACSTAFF  DECIMAL (5,2)    
PROJACTACSTDATE  DATE (4)    
PROJACTACENDATE  DATE (4)    
PROJECTPROJNO  CHARACTER (6)    
PROJECTPROJNAME  VARCHAR (24)    
PROJECTDEPTNO  CHARACTER (3)    
PROJECTRESPEMP  CHARACTER (6)    
PROJECTPRSTAFF  DECIMAL (5,2)    
PROJECTPRSTDATE  DATE (4)    
PROJECTPRENDATE  DATE (4)    
PROJECTMAJPROJ  CHARACTER (6)    
PURCHASEORDERPOID  BIGINT (8)    
PURCHASEORDERSTATUS  VARCHAR (10)    
PURCHASEORDERCUSTID  BIGINT (8)    
PURCHASEORDERORDERDATE  DATE (4)    
PURCHASEORDERPORDER  XML   
PURCHASEORDERCOMMENTS  VARCHAR (1000)    
SALESSALES_DATE  DATE (4)    
SALESSALES_PERSON  VARCHAR (15)    
SALESREGION  VARCHAR (15)    
SALESSALES  INTEGER (4)    
STAFFCOMM  DECIMAL (7,2)    
STAFFID  SMALLINT (2)    
STAFFNAME  VARCHAR (9)    
STAFFDEPT  SMALLINT (2)    
STAFFJOB  CHARACTER (5)    
STAFFYEARS  SMALLINT (2)    
STAFFSALARY  DECIMAL (7,2)    
STAFFGID  SMALLINT (2)    
STAFFGNAME  VARGRAPHIC (9)    
STAFFGDEPT  SMALLINT (2)    
STAFFGJOB  GRAPHIC (5)    
STAFFGYEARS  SMALLINT (2)    
STAFFGSALARY  DECIMAL (9)    
STAFFGCOMM  DECIMAL (9)    
SUPPLIERSSID  VARCHAR (10)    
SUPPLIERSADDR  XML   
VACTACTNO  SMALLINT (2)    
VACTACTKWD  CHARACTER (6)    
VACTACTDESC  VARCHAR (20)    
VASTRDE1DEPT1NO  CHARACTER (3)    
VASTRDE1DEPT1NAM  VARCHAR (36)    
VASTRDE1EMP1NO  CHARACTER (6)    
VASTRDE1EMP1FN  VARCHAR (12)    
VASTRDE1EMP1MI  CHARACTER (1)    
VASTRDE1EMP1LN  VARCHAR (15)    
VASTRDE1TYPE2  VARCHAR (1)    
VASTRDE1DEPT2NO  CHARACTER (3)    
VASTRDE1DEPT2NAM  VARCHAR (36)    
VASTRDE1EMP2NO  CHARACTER (6)    
VASTRDE1EMP2FN  VARCHAR (12)    
VASTRDE1EMP2MI  CHARACTER (1)    
VASTRDE1EMP2LN  VARCHAR (15)    
VASTRDE2DEPT1NO  CHARACTER (3)    
VASTRDE2DEPT1NAM  VARCHAR (36)    
VASTRDE2EMP1NO  CHARACTER (6)    
VASTRDE2EMP1FN  VARCHAR (12)    
VASTRDE2EMP1MI  CHARACTER (1)    
VASTRDE2EMP1LN  VARCHAR (15)    
VASTRDE2TYPE2  VARCHAR (1)    
VASTRDE2DEPT2NO  CHARACTER (3)    
VASTRDE2DEPT2NAM  VARCHAR (36)    
VASTRDE2EMP2NO  CHARACTER (6)    
VASTRDE2EMP2FN  VARCHAR (12)    
VASTRDE2EMP2MI  CHARACTER (1)    
VASTRDE2EMP2LN  VARCHAR (15)    
VDEPMG1DEPTNO  CHARACTER (3)    
VDEPMG1DEPTNAME  VARCHAR (36)    
VDEPMG1MGRNO  CHARACTER (6)   testing... 
VDEPMG1FIRSTNME  VARCHAR (12)    
VDEPMG1MIDINIT  CHARACTER (1)    
VDEPMG1LASTNAME  VARCHAR (15)    
VDEPMG1ADMRDEPT  CHARACTER (3)    
VDEPTDEPTNO  CHARACTER (3)   and here's a comment on a view column 
VDEPTDEPTNAME  VARCHAR (36)    
VDEPTMGRNO  CHARACTER (6)    
VDEPTADMRDEPT  CHARACTER (3)    
VEMPEMPNO  CHARACTER (6)    
VEMPFIRSTNME  VARCHAR (12)    
VEMPMIDINIT  CHARACTER (1)    
VEMPLASTNAME  VARCHAR (15)    
VEMPWORKDEPT  CHARACTER (3)    
VEMPDPT1DEPTNO  CHARACTER (3)    
VEMPDPT1DEPTNAME  VARCHAR (36)    
VEMPDPT1EMPNO  CHARACTER (6)    
VEMPDPT1FRSTINIT  CHARACTER (1)    
VEMPDPT1MIDINIT  CHARACTER (1)    
VEMPDPT1LASTNAME  VARCHAR (15)    
VEMPDPT1WORKDEPT  CHARACTER (3)    
VEMPLPEMPLOYEENUMBER  CHARACTER (6)    
VEMPLPPHONENUMBER  CHARACTER (4)    
VEMPPROJACTEMPNO  CHARACTER (6)    
VEMPPROJACTPROJNO  CHARACTER (6)    
VEMPPROJACTACTNO  SMALLINT (2)    
VEMPPROJACTEMPTIME  DECIMAL (5,2)    
VEMPPROJACTEMSTDATE  DATE (4)    
VEMPPROJACTEMENDATE  DATE (4)    
VFORPLAPROJNO  CHARACTER (6)    
VFORPLAPROJNAME  VARCHAR (24)    
VFORPLARESPEMP  CHARACTER (6)    
VFORPLAPROJDEP  CHARACTER (3)    
VFORPLAFRSTINIT  CHARACTER (1)    
VFORPLAMIDINIT  CHARACTER (1)    
VFORPLALASTNAME  VARCHAR (15)    
VHDEPTDEPTNO  CHARACTER (3)    
VHDEPTDEPTNAME  VARCHAR (36)    
VHDEPTMGRNO  CHARACTER (6)    
VHDEPTADMRDEPT  CHARACTER (3)    
VHDEPTLOCATION  CHARACTER (16)    
VPHONELASTNAME  VARCHAR (15)    
VPHONEFIRSTNAME  VARCHAR (12)    
VPHONEMIDDLEINITIAL  CHARACTER (1)    
VPHONEPHONENUMBER  VARCHAR (4)    
VPHONEEMPLOYEENUMBER  CHARACTER (6)    
VPHONEDEPTNUMBER  CHARACTER (3)    
VPHONEDEPTNAME  VARCHAR (36)    
VPROJPROJNO  CHARACTER (6)    
VPROJPROJNAME  VARCHAR (24)    
VPROJDEPTNO  CHARACTER (3)    
VPROJRESPEMP  CHARACTER (6)    
VPROJPRSTAFF  DECIMAL (5,2)    
VPROJPRSTDATE  DATE (4)    
VPROJPRENDATE  DATE (4)    
VPROJMAJPROJ  CHARACTER (6)    
VPROJACTPROJNO  CHARACTER (6)    
VPROJACTACTNO  SMALLINT (2)    
VPROJACTACSTAFF  DECIMAL (5,2)    
VPROJACTACSTDATE  DATE (4)    
VPROJACTACENDATE  DATE (4)    
VPROJRE1PROJNO  CHARACTER (6)    
VPROJRE1PROJNAME  VARCHAR (24)    
VPROJRE1PROJDEP  CHARACTER (3)    
VPROJRE1RESPEMP  CHARACTER (6)    
VPROJRE1FIRSTNME  VARCHAR (12)    
VPROJRE1MIDINIT  CHARACTER (1)    
VPROJRE1LASTNAME  VARCHAR (15)    
VPROJRE1MAJPROJ  CHARACTER (6)    
VPSTRDE1PROJ1NO  CHARACTER (6)    
VPSTRDE1PROJ1NAME  VARCHAR (24)    
VPSTRDE1RESP1NO  CHARACTER (6)    
VPSTRDE1RESP1FN  VARCHAR (12)    
VPSTRDE1RESP1MI  CHARACTER (1)    
VPSTRDE1RESP1LN  VARCHAR (15)    
VPSTRDE1PROJ2NO  CHARACTER (6)    
VPSTRDE1PROJ2NAME  VARCHAR (24)    
VPSTRDE1RESP2NO  CHARACTER (6)    
VPSTRDE1RESP2FN  VARCHAR (12)    
VPSTRDE1RESP2MI  CHARACTER (1)    
VPSTRDE1RESP2LN  VARCHAR (15)    
VPSTRDE2PROJ1NO  CHARACTER (6)    
VPSTRDE2PROJ1NAME  VARCHAR (24)    
VPSTRDE2RESP1NO  CHARACTER (6)    
VPSTRDE2RESP1FN  VARCHAR (12)    
VPSTRDE2RESP1MI  CHARACTER (1)    
VPSTRDE2RESP1LN  VARCHAR (15)    
VPSTRDE2PROJ2NO  CHARACTER (6)    
VPSTRDE2PROJ2NAME  VARCHAR (24)    
VPSTRDE2RESP2NO  CHARACTER (6)    
VPSTRDE2RESP2FN  VARCHAR (12)    
VPSTRDE2RESP2MI  CHARACTER (1)    
VPSTRDE2RESP2LN  VARCHAR (15)    
VSTAFAC1PROJNO  CHARACTER (6)    
VSTAFAC1ACTNO  SMALLINT (2)    
VSTAFAC1ACTDESC  VARCHAR (20)    
VSTAFAC1EMPNO  VARCHAR (1)    
VSTAFAC1FIRSTNME  VARCHAR (1)    
VSTAFAC1MIDINIT  VARCHAR (1)    
VSTAFAC1LASTNAME  VARCHAR (1)    
VSTAFAC1EMPTIME  DECIMAL (5,2)    
VSTAFAC1STDATE  DATE (4)    
VSTAFAC1ENDATE  DATE (4)    
VSTAFAC1TYPE  VARCHAR (1)    
VSTAFAC2PROJNO  CHARACTER (6)   for a project? 
VSTAFAC2ACTNO  SMALLINT (2)    
VSTAFAC2ACTDESC  VARCHAR (20)    
VSTAFAC2EMPNO  CHARACTER (6)    
VSTAFAC2FIRSTNME  VARCHAR (12)    
VSTAFAC2MIDINIT  CHARACTER (1)    
VSTAFAC2LASTNAME  VARCHAR (15)    
VSTAFAC2EMPTIME  DECIMAL (5,2)    
VSTAFAC2STDATE  DATE (4)    
VSTAFAC2ENDATE  DATE (4)    
VSTAFAC2TYPE  VARCHAR (1)    



Documentation generated by SqlSpec