lic

 

 

notetype  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

CODE

varchar(8)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

DESCRIP

varchar(180)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

PREFENTRY

longtext

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

notetype

1

DESCRIP

1

DESCRIP

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

notetype

1

CODE

1

CODE

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back