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

 

EMAIL

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