| id |
int(11)
|
|
|
|
| player_id |
int(11)
|
|
|
|
| player_name |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| player_db_id |
int(11)
|
|
|
|
| social_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| first_name |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| last_name |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| birth_date |
date
|
|
|
|
| height |
int(11)
|
|
|
|
| origin |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| gender |
tinyint(4)
|
|
|
|
| model |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| face_mother |
tinyint(4)
|
|
|
|
| face_father |
tinyint(4)
|
|
|
|
| face_mix |
float
|
|
|
|
| skin_mother |
tinyint(4)
|
|
|
|
| skin_father |
tinyint(4)
|
|
|
|
| skin_mix |
float
|
|
|
|
| hair_style |
tinyint(4)
|
|
|
|
| hair_color |
tinyint(4)
|
|
|
|
| hair_highlight |
tinyint(4)
|
|
|
|
| eyebrow_style |
tinyint(4)
|
|
|
|
| eyebrow_color |
tinyint(4)
|
|
|
|
| eyebrow_opacity |
float
|
|
|
|
| beard_style |
tinyint(4)
|
|
|
|
| beard_color |
tinyint(4)
|
|
|
|
| beard_opacity |
float
|
|
|
|
| eye_color |
tinyint(4)
|
|
|
|
| makeup_style |
tinyint(4)
|
|
|
|
| makeup_color |
tinyint(4)
|
|
|
|
| makeup_opacity |
float
|
|
|
|
| lipstick_style |
tinyint(4)
|
|
|
|
| lipstick_color |
tinyint(4)
|
|
|
|
| lipstick_opacity |
float
|
|
|
|
| torso |
tinyint(4)
|
|
|
|
| torso_texture |
tinyint(4)
|
|
|
|
| legs |
tinyint(4)
|
|
|
|
| legs_texture |
tinyint(4)
|
|
|
|
| feet |
tinyint(4)
|
|
|
|
| feet_texture |
tinyint(4)
|
|
|
|
| accessories |
tinyint(4)
|
|
|
|
| accessories_texture |
tinyint(4)
|
|
|
|
| undershirt |
tinyint(4)
|
|
|
|
| undershirt_texture |
tinyint(4)
|
|
|
|
| hats |
tinyint(4)
|
|
|
|
| hats_texture |
tinyint(4)
|
|
|
|
| glasses |
tinyint(4)
|
|
|
|
| glasses_texture |
tinyint(4)
|
|
|
|
| last_pos_x |
float
|
|
|
|
| last_pos_y |
float
|
|
|
|
| last_pos_z |
float
|
|
|
|
| last_heading |
float
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|
