+-------------------------+---------------+
| Column                  | Type          |
+-------------------------+---------------+
| M_AdressZusatz          | varchar(50)   |
| M_Angemeldet            | tinyint(1)    |
| M_BankName              | varchar(255)  |
| M_BIC                   | varchar(11)   |
| M_BLZ                   | varchar(8)    |
| M_DNI                   | varchar(9)    |
| M_Email                 | varchar(200)  |
| M_Geaendert             | int(1)        |
| M_Geburtstag            | date          |
| M_Gekuendigt            | datetime      |
| M_Geschlecht            | char(1)       |
| M_Gesperrt              | tinyint(1)    |
| M_Hausnummer            | varchar(10)   |
| M_IBAN                  | varchar(34)   |
| M_KontoInhaber          | varchar(100)  |
| M_KontoNr               | varchar(24)   |
| M_Limit                 | decimal(10,2) |
| M_Limit_MonatsVerbrauch | decimal(10,2) |
| M_LS_ID                 | varchar(30)   |
| M_Mitarbeiter_Art       | int(11)       |
| M_Name                  | varchar(50)   |
| M_NewsletterAbonniert   | tinyint(1)    |
| M_NIE                   | varchar(9)    |
| M_Nummer                | double        |
| M_Ort                   | varchar(50)   |
| M_Password              | varchar(32)   |
| M_Passwort              | varchar(32)   |
| M_Passwort_Key          | char(20)      |
| M_PLZ                   | varchar(5)    |
| M_S_KZ                  | char(5)       |
| M_Strasse               | varchar(50)   |
| M_SV_ID                 | int(11)       |
| M_Telefon               | varchar(50)   |
| M_Vertragsart           | char(1)       |
| M_Vertragsbeginn        | date          |
| M_Vorname               | varchar(50)   |
| M_Zahlart               | char(1)       |
+-------------------------+---------------+