DB Migration: Migrate to SQL Database

[0xTheProDev]

Create separate table for user_info, user_action, language and user_cache. A sample schema could be the following:

user_info:
+ user_id: int _(PK)_
+ user_name: string _(Unique)_
+ password: string _(Hash)_

user_action:
+ submission_id: uuid _(PK)_
+ user_id: int _(FK/NULL)_
+ ip: string
+ user_agent: string
+ time: timestamp
+ language_id: int _(FK)_
+ CPU Usage: int
+ MEM Usage: int

language:
+ id: int _(PK)_
+ name: string

user_cache:
+ user_id: int _(Part PK/FK)_
+ submission_id: uuid _(Part PK/FK)_
+ language_id: int _(Part PK/FK)_

[satyamvats5]

User_id will be provided by user or it will be auto-generated?
If provided by user how can it be int?