| id |
int(11)
|
|
|
|
| main_login |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| main_password |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| email_login |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| email_password |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| level |
int(11)
|
|
|
|
| current_rank |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| past_rank |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| previous_season_rank |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| region |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| locale |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| country |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| server_short |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| server_full |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| valorant_points |
int(11)
|
|
|
|
| radianite_points |
int(11)
|
|
|
|
| skin_count |
int(11)
|
|
|
|
| agent_count |
int(11)
|
|
|
|
| gunbuddies_count |
int(11)
|
|
|
|
| agents_list |
longtext
|
utf8mb4_bin
|
|
|
| skins_list |
longtext
|
utf8mb4_bin
|
|
|
| generated_title |
text
|
utf8mb4_unicode_ci
|
|
|
| generated_description |
text
|
utf8mb4_unicode_ci
|
|
|
| purchase_price |
decimal(10,2)
|
|
|
|
| sale_price |
decimal(10,2)
|
|
|
|
| profit_multiplier |
decimal(4,2)
|
|
|
|
| status |
enum('active', 'sold', 'reserved', 'deleted')
|
utf8mb4_unicode_ci
|
|
|
| is_email_confirmed |
tinyint(1)
|
|
|
|
| raw_data |
longtext
|
utf8mb4_unicode_ci
|
|
|
| notes |
text
|
utf8mb4_unicode_ci
|
|
|
| g2g_exported |
tinyint(1)
|
|
|
|
| g2g_exported_at |
timestamp
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
