lic
 

 

indvnote  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ID

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

DATE

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

NOTES

longtext

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

NOTETYPE

char(8)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

USERNAME

char(6)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TRANNO

int(11)

(NULL)

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

indvnote

1

ID

1

ID

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

indvnote

1

TRANNO

1

TRANNO

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back