Database: scorp1_db
Table: member
[43 columns]
+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Column              | Type                                                                                                                                                                                                                                                                                        |
+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| abn                 | varchar(15)                                                                                                                                                                                                                                                                                 |
| activate_key        | varchar(40)                                                                                                                                                                                                                                                                                 |
| activated_on        | datetime                                                                                                                                                                                                                                                                                    |
| auto_email          | tinyint(1)                                                                                                                                                                                                                                                                                  |
| auto_pricing        | set('Yes','No')                                                                                                                                                                                                                                                                             |
| bill_postcode       | varchar(4)                                                                                                                                                                                                                                                                                  |
| bill_state          | varchar(30)                                                                                                                                                                                                                                                                                 |
| bill_street         | varchar(100)                                                                                                                                                                                                                                                                                |
| bill_suburb         | varchar(100)                                                                                                                                                                                                                                                                                |
| company             | varchar(80)                                                                                                                                                                                                                                                                                 |
| contact_method      | varchar(20)                                                                                                                                                                                                                                                                                 |
| createdate          | datetime                                                                                                                                                                                                                                                                                    |
| default_level       | int(11)                                                                                                                                                                                                                                                                                     |
| deliver_postcode    | varchar(4)                                                                                                                                                                                                                                                                                  |
| deliver_state       | varchar(30)                                                                                                                                                                                                                                                                                 |
| deliver_street      | varchar(100)                                                                                                                                                                                                                                                                                |
| deliver_suburb      | varchar(100)                                                                                                                                                                                                                                                                                |
| department          | varchar(60)                                                                                                                                                                                                                                                                                 |
| disabled            | tinyint(1)                                                                                                                                                                                                                                                                                  |
| dummy               | tinyint(1)                                                                                                                                                                                                                                                                                  |
| email               | varchar(100)                                                                                                                                                                                                                                                                                |
| fax                 | varchar(15)                                                                                                                                                                                                                                                                                 |
| firstname           | varchar(30)                                                                                                                                                                                                                                                                                 |
| hphone              | varchar(15)                                                                                                                                                                                                                                                                                 |
| lastname            | varchar(30)                                                                                                                                                                                                                                                                                 |
| lastupdate          | timestamp                                                                                                                                                                                                                                                                                   |
| lastuser            | varchar(50)                                                                                                                                                                                                                                                                                 |
| memid               | int(11)                                                                                                                                                                                                                                                                                     |
| MemListID           | varchar(50)                                                                                                                                                                                                                                                                                 |
| memno               | int(11)                                                                                                                                                                                                                                                                                     |
| mphone              | varchar(15)                                                                                                                                                                                                                                                                                 |
| on_mailing_list     | tinyint(1)                                                                                                                                                                                                                                                                                  |
| password            | varchar(40)                                                                                                                                                                                                                                                                                 |
| password_answer     | varchar(255)                                                                                                                                                                                                                                                                                |
| password_question   | set('What is your favourite sports team?','What is your favourite movie?','What is your favourite song?','What is your favourite restaurant?','What is your favourite dish?','What is your favourite colour?','What is your favourite pet name?','What is your mother's maiden name?') |
| pricing_expiry_date | date                                                                                                                                                                                                                                                                                        |
| pricing_reason      | varchar(255)                                                                                                                                                                                                                                                                                |
| pricing_start_date  | date                                                                                                                                                                                                                                                                                        |
| qb_name             | varchar(255)                                                                                                                                                                                                                                                                                |
| reference_channel   | varchar(100)                                                                                                                                                                                                                                                                                |
| theme               | varchar(50)                                                                                                                                                                                                                                                                                 |
| type                | varchar(50)                                                                                                                                                                                                                                                                                 |
| wphone              | varchar(15)                                                                                                                                                                                                                                                                                 |
+---------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+