| affiliate_id |
int |
11 |
|
√ |
|
|
|
| affiliate_gender |
char |
1 |
|
|
|
|
|
| affiliate_firstname |
varchar |
32 |
|
|
|
|
|
| affiliate_lastname |
varchar |
32 |
|
|
|
|
|
| affiliate_dob |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| affiliate_email_address |
varchar |
96 |
|
|
|
|
|
| affiliate_telephone |
varchar |
32 |
|
|
|
|
|
| affiliate_fax |
varchar |
32 |
|
|
|
|
|
| affiliate_password |
varchar |
40 |
|
|
|
|
|
| affiliate_homepage |
varchar |
96 |
|
|
|
|
|
| affiliate_street_address |
varchar |
64 |
|
|
|
|
|
| affiliate_suburb |
varchar |
64 |
|
|
|
|
|
| affiliate_city |
varchar |
32 |
|
|
|
|
|
| affiliate_postcode |
varchar |
10 |
|
|
|
|
|
| affiliate_state |
varchar |
32 |
|
|
|
|
|
| affiliate_country_id |
int |
11 |
|
|
0 |
|
|
| affiliate_zone_id |
int |
11 |
|
|
0 |
|
|
| affiliate_agb |
tinyint |
4 |
|
|
0 |
|
|
| affiliate_company |
varchar |
60 |
|
|
|
|
|
| affiliate_company_taxid |
varchar |
64 |
|
|
|
|
|
| affiliate_commission_percent |
decimal |
4,2 |
|
|
0.00 |
|
|
| affiliate_payment_check |
varchar |
100 |
|
|
|
|
|
| affiliate_payment_paypal |
varchar |
64 |
|
|
|
|
|
| affiliate_payment_bank_name |
varchar |
64 |
|
|
|
|
|
| affiliate_payment_bank_branch_number |
varchar |
64 |
|
|
|
|
|
| affiliate_payment_bank_swift_code |
varchar |
64 |
|
|
|
|
|
| affiliate_payment_bank_account_name |
varchar |
64 |
|
|
|
|
|
| affiliate_payment_bank_account_number |
varchar |
64 |
|
|
|
|
|
| affiliate_date_of_last_logon |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| affiliate_number_of_logons |
int |
11 |
|
|
0 |
|
|
| affiliate_date_account_created |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| affiliate_date_account_last_modified |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| affiliate_lft |
int |
11 |
|
|
0 |
|
|
| affiliate_rgt |
int |
11 |
|
|
0 |
|
|
| affiliate_root |
int |
11 |
|
|
0 |
|
|
| affiliate_newsletter |
char |
1 |
|
|
1 |
|
|
