con_main Field Type Null Default Links to ID int(11) No first_Name text No Name varchar(100) No Title varchar(100) Yes NULL Company varchar(100) Yes NULL biztype text No Phone varchar(25) No Address varchar(100) Yes NULL FAX varchar(25) Yes NULL City varchar(100) No email varchar(100) No mkt int(1) No 1 State varchar(10) No ZipCode varchar(10) No alt_con varchar(100) No alt_title varchar(50) No dtnum int(8) No 0 dtup int(8) No 0 usrn varchar(25) No usremail varchar(100) No referred_by varchar(100) Yes NULL ref_RID int(11) Yes NULL rep_RID int(11) Yes NULL mfg_RID int(11) Yes NULL Indexes: Keyname Type Cardinality Field PRIMARY PRIMARY 360 ID Space usage: Type Usage Data 73,108 B Index 6,144 B Total 79,252 B Row Statistics: Statements Value Format dynamic Rows 360 Row length ø 203 Row size ø 220 B Next Autoindex 402 Creation Sep 06, 2006 at 08:27 AM Last update Apr 04, 2007 at 10:45 AM ////////////////////////////////////////////////// con_activity Field Type Null Default ID int(11) No CID int(11) No 0 act_year int(4) No 0 act_month int(2) No 0 act_day int(2) No 0 contact_type varchar(12) No act_respond varchar(12) No usrn varchar(25) No dtnum int(8) No 0 Indexes: Keyname Type Cardinality Field PRIMARY PRIMARY 2 ID Space usage: Type Usage Data 260 Bytes Index 2,048 Bytes Overhead 96 Bytes Effective 2,212 Bytes Total 2,308 Bytes Row Statistics: Statements Value Format dynamic Rows 2 Row length ø 82 Row size ø 1,154 Bytes Next Autoindex 23 Creation Dec 28, 2005 at 09:22 AM Last update Jan 17, 2006 at 07:41 AM //////////////////////////////////////////////// con_notes Field Type Null Default ID int(11) No CID int(11) No 0 Notes text No usrn varchar(25) No dtnum int(8) No 0 Indexes: Keyname Type Cardinality Field PRIMARY PRIMARY 14 ID Space usage: Type Usage Data 1,156 Bytes Index 2,048 Bytes Overhead 356 Bytes Effective 2,848 Bytes Total 3,204 Bytes Row Statistics: Statements Value Format dynamic Rows 14 Row length ø 57 Row size ø 229 Bytes Next Autoindex 27 Creation Dec 28, 2005 at 09:25 AM Last update Jan 17, 2006 at 07:41 AM //////////////////////////////////////////////////// con_reactivity Field Type Null Default ID int(11) No CID int(11) No 0 react_year int(4) No 0 react_month int(2) No 0 react_day int(2) No 0 usrn varchar(25) No dtnum int(8) No 0 Indexes: Keyname Type Cardinality Field PRIMARY PRIMARY 2 ID Space usage: Type Usage Data 96 Bytes Index 2,048 Bytes Total 2,144 Bytes Row Statistics: Statements Value Format dynamic Rows 2 Row length ø 48 Row size ø 1,072 Bytes Next Autoindex 10 Creation Dec 28, 2005 at 09:24 AM Last update Jan 17, 2006 at 04:26 AM con_main Field Type Null Default ID int(11) No first_Name text No Name varchar(100) No Title varchar(100) Yes NULL Company varchar(100) Yes NULL biztype text No Phone varchar(25) No Address varchar(100) Yes NULL FAX varchar(25) Yes NULL City varchar(100) No email varchar(100) No State varchar(10) No ZipCode varchar(10) No dtnum int(8) No 0 dtup int(8) No 0 usrn varchar(25) No usremail varchar(100) No Indexes: Keyname Type Cardinality Field PRIMARY PRIMARY 6 ID Space usage: Type Usage Data 1,072 Bytes Index 2,048 Bytes Total 3,120 Bytes Row Statistics: Statements Value Format dynamic Rows 6 Row length ø 178 Row size ø 520 Bytes Next Autoindex 14 Creation Jan 22, 2006 at 06:02 AM Last update Jan 22, 2006 at 06:02 AM