|
lic |
| branch |
| Fields |
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|
BRANCHNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
select,insert,update,references |
|
|
COID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
LICID |
int(11) |
(NULL) |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
ADDRESS1 |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ADDRESS2 |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CITY |
char(24) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
CNCLCODE |
char(2) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
CNCLDATE |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CONTNAME |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
CONTTITLE |
varchar(34) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
|
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FAX |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
FIRM |
varchar(40) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
|
LASTCHGDAT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ST |
char(2) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
TEL |
char(17) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
USERINIT |
char(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
|
ZIPCODE |
char(10) |
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 |
|
branch |
0 |
PRIMARY |
1 |
BRANCHNO |
A |
8199 |
(NULL) |
(NULL) |
|
BTREE |
|
|
branch |
1 |
coid |
1 |
COID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
branch |
1 |
licid |
1 |
LICID |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
branch |
1 |
CITY |
1 |
CITY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
branch |
1 |
FIRM |
1 |
FIRM |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
|
branch |
1 |
BRANCHNO |
1 |
BRANCHNO |
A |
(NULL) |
(NULL) |
(NULL) |
|
BTREE |
|
|
branch |
1 |
CNCLCODE |
1 |
CNCLCODE |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back