lic

 

 
gen  
Fields
Field Type Collation Null Key Default Extra Privileges Comment

ID

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

 

ADDR1

varchar(32)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ADDR2

varchar(32)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

BILLDATE

date

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

BKFEE

decimal(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

CITY

varchar(20)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CONTEMAIL

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

CONVFEE

decimal(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

DOWNLDTIME

varchar(11)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

EMBFee

decimal(8,2)

(NULL)

YES

 

(NULL)

 

select,insert,update,references

 

FAX

varchar(12)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

FBIDPSFEE

decimal(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

LOFEE

decimal(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

MBARYEAR

char(4)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

MBFEE

decimal(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

NOTES

longtext

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ORGCODE

char(6)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ORGNAME

varchar(50)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

RECOVERYFE

decimal(8,2)

(NULL)

YES

 

0.00

 

select,insert,update,references

 

ST

char(2)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

TEL

varchar(12)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

SMTPIP

varchar(22)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

USEAMEX

tinyint(1)

(NULL)

YES

 

0

 

select,insert,update,references

 

USEDISCOV

tinyint(1)

(NULL)

YES

 

0

 

select,insert,update,references

 

USEMC

tinyint(1)

(NULL)

YES

 

0

 

select,insert,update,references

 

USEVISA

tinyint(1)

(NULL)

YES

 

0

 

select,insert,update,references

 

VERSIONNO

char(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ZIPCODE

char(10)

latin1_swedish_ci

YES

 

(NULL)

 

select,insert,update,references

 

ENFORCEYEAR

int(11)

(NULL)

YES

 

0

 

select,insert,update,references

 

Indexes
Table Non
unique
Key
name
Seq
in
index
Column
name
Collation Cardinality Sub
part
Packed Null Index
type
Comment

gen

0

PRIMARY

1

ID

A

1

(NULL)

(NULL)

 

BTREE

 

Back