Table j4_ra_bookings from database -testfeb25-35303837372c
Seq
Column name
Type
Max size
Null
Key
1 id int   NO PRI
2 event_id int   NO MUL
3 user_id int   NO MUL
4 num_places int   NO  
5 partner varchar 50 YES  
6 custom1 varchar 50 NO  
7 custom2 varchar 50 NO  
8 amount_paid decimal   YES  
9 date_paid date   YES  
10 payment_created datetime   YES  
11 payment_created_by int   YES  
12 payment_modified datetime   YES  
13 payment_modified_by int   YES  
14 state int   YES  
15 created datetime   NO  
16 created_by int   NO  
17 confirmed datetime   YES  
18 confirmed_by int   NO  
19 cancelled datetime   YES  
20 cancelled_by int   NO  
20 columns in the table
Back
| Seq | Column name | Type | Max size | Null | Key |
|---|---|---|---|---|---|
| 1 | id | int |   | NO | PRI |
| 2 | event_id | int |   | NO | MUL |
| 3 | user_id | int |   | NO | MUL |
| 4 | num_places | int |   | NO |   |
| 5 | partner | varchar | 50 | YES |   |
| 6 | custom1 | varchar | 50 | NO |   |
| 7 | custom2 | varchar | 50 | NO |   |
| 8 | amount_paid | decimal |   | YES |   |
| 9 | date_paid | date |   | YES |   |
| 10 | payment_created | datetime |   | YES |   |
| 11 | payment_created_by | int |   | YES |   |
| 12 | payment_modified | datetime |   | YES |   |
| 13 | payment_modified_by | int |   | YES |   |
| 14 | state | int |   | YES |   |
| 15 | created | datetime |   | NO |   |
| 16 | created_by | int |   | NO |   |
| 17 | confirmed | datetime |   | YES |   |
| 18 | confirmed_by | int |   | NO |   |
| 19 | cancelled | datetime |   | YES |   |
| 20 | cancelled_by | int |   | NO |   |
Back
