lic
 

 

compcodes  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

TRANNO

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

CODE

char(4)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

CMPTNATURE

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

PRIORITY

varchar(10)

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

compcodes

0

PRIMARY

1

TRANNO

A

18

(NULL)

(NULL)

 

BTREE

 

compcodes

1

CODE

1

CODE

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back