lic

 

 

compindv  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

CID

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

LOID

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

AMTOWED

double(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

AMTPAID

double(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

DATEPAID

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

CHECKNUM

varchar(30)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

NoRspFefEnfc

date

(NULL)

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

compindv

1

cid

1

CID

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

compindv

1

loid

1

LOID

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back