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