lic
 

 

lookup  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

MODULE

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

LOOKUP

varchar(30)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

TABLENAME

varchar(11)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

SORTFIELD

varchar(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PRIMEKEY

varchar(10)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

LOOKUPTYPE

varchar(1)

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

lookup

1

LOOKUP

1

LOOKUP

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

lookup

1

TABLENAME

1

TABLENAME

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

lookup

1

PRIMEKEY

1

PRIMEKEY

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back