lic

 

 

loans  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

COID

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

LICID

int(11)

(NULL)

YES

MUL

(NULL)

 

select,insert,update,references

 

LOANID

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

AGREESWBRNCH

tinyint(1)

(NULL)

YES

 

0

 

select,insert,update,references

 

AGREESWLO

tinyint(1)

(NULL)

YES

 

0

 

select,insert,update,references

 

LASTCHGDAT

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

REPORTYEAR

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTACTBR

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTCONVCDO

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTCONVCNO

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTCONVNDO

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTCONVNNO

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTDOLVOL

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTFHADOL

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTFHALOAN

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTHCDOL

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTHCLOAN

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTNOLOANS

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTOTHERDO

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTOTHERNO

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTOTHERTY

varchar(10)

latin1_swedish_ci

YES

MUL

(NULL)

 

select,insert,update,references

 

TOTSPONLO

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTVADOL

double

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

TOTVALOAN

int(11)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

USERINIT

varchar(3)

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

loans

0

PRIMARY

1

LOANID

A

57170

(NULL)

(NULL)

 

BTREE

 

loans

1

coid

1

COID

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

loans

1

loid

1

LICID

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

loans

1

LICID

1

LICID

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

loans

1

TOTOTHERTY

1

TOTOTHERTY

A

(NULL)

(NULL)

(NULL)

YES

BTREE

 

Back