lic

 

 

firmtype  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

code

char(3)

latin1_swedish_ci

NO

PRI

 

 

select,insert,update,references

 

descrip

varchar(30)

latin1_swedish_ci

YES

MUL

(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

firmtype

0

PRIMARY

1

code

A

3

(NULL)

(NULL)

 

BTREE

 

firmtype

1

descrip

1

descrip

A

3

(NULL)

(NULL)

YES

BTREE

 

Back