lic |
provider |
Fields |
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
PROVIDERNO |
int(11) |
(NULL) |
NO |
PRI |
(NULL) |
auto_increment |
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 |
|
AKA |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
APPROVALDT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
CITY |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
CONTACT |
varchar(34) |
latin1_swedish_ci |
YES |
MUL |
(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 |
|
PROVNAME |
varchar(50) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
ST |
varchar(2) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
STATUS |
varchar(1) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TEL1 |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TEL2 |
varchar(12) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
WEBSITE |
varchar(50) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
ZIPCODE |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
FNAME |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
LNAME |
varchar(20) |
latin1_swedish_ci |
YES |
MUL |
(NULL) |
|
select,insert,update,references |
|
MI |
varchar(10) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
USERINIT |
varchar(3) |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
PUBTOWEB |
tinyint(1) |
(NULL) |
YES |
|
0 |
|
select,insert,update,references |
|
LASTCHGDAT |
date |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
NOTES |
longtext |
latin1_swedish_ci |
YES |
|
(NULL) |
|
select,insert,update,references |
|
MASTERNO |
int(11) |
(NULL) |
YES |
|
(NULL) |
|
select,insert,update,references |
|
TITLE |
varchar(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 |
provider |
0 |
PRIMARY |
1 |
PROVIDERNO |
A |
182 |
(NULL) |
(NULL) |
|
BTREE |
|
provider |
1 |
ST |
1 |
ST |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
provider |
1 |
LNAME |
1 |
LNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
provider |
1 |
PROVNAME |
1 |
PROVNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
provider |
1 |
CONTACT |
1 |
CONTACT |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
provider |
1 |
CITY |
1 |
CITY |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
provider |
1 |
FNAME |
1 |
FNAME |
A |
(NULL) |
(NULL) |
(NULL) |
YES |
BTREE |
|
Back