Users Table Schema:
Array
(
[Field] => id
[Type] => int(11)
[Null] => NO
[Key] => PRI
[Default] =>
[Extra] => auto_increment
)
Array
(
[Field] => email
[Type] => varchar(100)
[Null] => NO
[Key] => UNI
[Default] =>
[Extra] =>
)
Array
(
[Field] => password
[Type] => varchar(255)
[Null] => NO
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => token
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => created_at
[Type] => datetime
[Null] => YES
[Key] =>
[Default] => current_timestamp()
[Extra] =>
)
Array
(
[Field] => is_premium
[Type] => tinyint(1)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
User Profiles Table Schema:
Array
(
[Field] => id
[Type] => int(11)
[Null] => NO
[Key] => PRI
[Default] =>
[Extra] => auto_increment
)
Array
(
[Field] => user_id
[Type] => int(11)
[Null] => NO
[Key] => MUL
[Default] =>
[Extra] =>
)
Array
(
[Field] => name
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => age
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => height
[Type] => float
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => weight
[Type] => float
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
Array
(
[Field] => units
[Type] => varchar(20)
[Null] => YES
[Key] =>
[Default] => metric
[Extra] =>
)
Array
(
[Field] => created_at
[Type] => datetime
[Null] => YES
[Key] =>
[Default] => current_timestamp()
[Extra] =>
)
Array
(
[Field] => updated_at
[Type] => datetime
[Null] => YES
[Key] =>
[Default] => current_timestamp()
[Extra] =>
)