lic |
gen |   |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ID |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
ADDR1 |
varchar(32) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ADDR2 |
varchar(32) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BILLDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
BKFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
CITY |
varchar(20) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CONTEMAIL |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CONVFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
DOWNLDTIME |
varchar(11) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
EMBFee |
decimal(8,2) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FAX |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FBIDPSFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
LOFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
MBARYEAR |
char(4) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
MBFEE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ORGCODE |
char(6) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ORGNAME |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
RECOVERYFE |
decimal(8,2) |
(NULL) |
YES |
|
0.00 |
|
select,insert,update,references |
|
ST |
char(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TEL |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
SMTPIP |
varchar(22) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
USEAMEX |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
USEDISCOV |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
USEMC |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
USEVISA |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
VERSIONNO |
char(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ZIPCODE |
char(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ENFORCEYEAR |
int(11) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
gen |
0 |
PRIMARY |
1 |
ID |
A |
1 |
(NULL) |
(NULL) |
|
BTREE |
|
Back