Table j4_ra_profiles_bak from database -testfeb25-35303837372c
Seq
Column name
Type
Max size
Null
Key
1 id int   NO PRI
2 home_group varchar 255 NO MUL
3 preferred_name varchar 60 YES  
4 security_token varchar 100 YES  
5 subscribe int   NO  
6 software_version varchar 50 YES  
7 groups_to_follow varchar 255 YES  
8 acknowledge_follow varchar 255 YES  
9 privacy_level varchar 255 NO  
10 mobile varchar 100 YES  
11 contactviaemail varchar 255 YES  
12 min_miles varchar 2 YES  
13 contactviatextmessage varchar 255 YES  
14 max_miles varchar 2 YES  
15 max_radius varchar 3 YES  
16 notify_joiners varchar 255 YES  
17 state tinyint   YES  
18 ordering int   YES  
19 created datetime   YES  
20 created_by int   YES  
21 modified datetime   YES  
22 modified_by int   YES  
23 checked_out_time date   YES  
24 checked_out int   YES  
24 columns in the table
Back
| Seq | Column name | Type | Max size | Null | Key |
|---|---|---|---|---|---|
| 1 | id | int |   | NO | PRI |
| 2 | home_group | varchar | 255 | NO | MUL |
| 3 | preferred_name | varchar | 60 | YES |   |
| 4 | security_token | varchar | 100 | YES |   |
| 5 | subscribe | int |   | NO |   |
| 6 | software_version | varchar | 50 | YES |   |
| 7 | groups_to_follow | varchar | 255 | YES |   |
| 8 | acknowledge_follow | varchar | 255 | YES |   |
| 9 | privacy_level | varchar | 255 | NO |   |
| 10 | mobile | varchar | 100 | YES |   |
| 11 | contactviaemail | varchar | 255 | YES |   |
| 12 | min_miles | varchar | 2 | YES |   |
| 13 | contactviatextmessage | varchar | 255 | YES |   |
| 14 | max_miles | varchar | 2 | YES |   |
| 15 | max_radius | varchar | 3 | YES |   |
| 16 | notify_joiners | varchar | 255 | YES |   |
| 17 | state | tinyint |   | YES |   |
| 18 | ordering | int |   | YES |   |
| 19 | created | datetime |   | YES |   |
| 20 | created_by | int |   | YES |   |
| 21 | modified | datetime |   | YES |   |
| 22 | modified_by | int |   | YES |   |
| 23 | checked_out_time | date |   | YES |   |
| 24 | checked_out | int |   | YES |   |
Back
