+------------------------------------------------------------------+--------------------------------+------+-----+---------+-------+
| Field                                                            | Type                           | Null | Key | Default | Extra |
+------------------------------------------------------------------+--------------------------------+------+-----+---------+-------+
| payment_id                                                       | int(11) unsigned               | NO   |     | 0       |       | 
| booking_id                                                       | int(11) unsigned               | NO   |     | 0       |       | 
| owner                                                            | varchar(30)                    | NO   |     |         |       | 
| method                                                           | enum('CC','DN','RM','SEPA')    | NO   |     | CC      |       | 
| cc_type                                                          | enum('EC','MC','VI','AX','CA') | YES  |     | NULL    |       | 
| IF(method = 'CC' AND (cc_number IS NOT NULL OR cc_number != ''), | varchar(16)                    | YES  |     | NULL    |       | 
| cc_cvc2                                                          | char(3)                        | YES  |     | NULL    |       | 
| cc_valid                                                         | varchar(7)                     | YES  |     | NULL    |       | 
| bank_code                                                        | varchar(34)                    | YES  |     | NULL    |       | 
| bank_name                                                        | varchar(30)                    | YES  |     | NULL    |       | 
| IF(method != 'CC' AND (bank_account IS NOT NULL OR bank_account  | varchar(9)                     | YES  |     | NULL    |       | 
| amount                                                           | decimal(7,2)                   | NO   |     | 0.00    |       | 
| cc_fee                                                           | decimal(5,2)                   | YES  |     | NULL    |       | 
| update_ok                                                        | tinyint(1) unsigned            | YES  |     | 0       |       | 
+------------------------------------------------------------------+--------------------------------+------+-----+---------+-------+