lic |
ziptab |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
ZIPCODE |
char(5) |
latin1_swedish_ci |
NO |
PRI |
|
|
select,insert,update,references |
|
CITY |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
COUNTY |
varchar(40) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
TEL |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
Indexes |
Table | Non unique |
Key name |
Seq in index |
Column name |
Collation | Cardinality | Sub part |
Packed | Null | Index type |
Comment |
ziptab |
0 |
PRIMARY |
1 |
ZIPCODE |
A |
2675 |
(NULL) |
(NULL) |
|
BTREE |
|
ziptab |
1 |
COUNTY |
1 |
COUNTY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
ziptab |
1 |
CITY |
1 |
CITY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
ziptab |
1 |
ZIPCODE |
1 |
ZIPCODE |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
Back