Database Models

User

Field Name	Is it optional?	Datatype
user_id	No, this is a primary key	bigint / int8
email	No	character varying / varchar
password	No	character varying / varchar
identifier	No	character varying / varchar
name	Yes	character varying / varchar
familyName	Yes	character varying / varchar
birthDate	Yes	date
gender	Yes	smallint / int2

Sport

Field Name	Is it optional?	Datatype
sport_id	No, this is a primary key	bigint / int8
name	No	character varying / varchar

Sport_SkillLevel

Field Name	Is it optional?	Datatype
user_id	No	bigint / int8
sport_id	No	bigint / int8
skill_level	No	smallint / int2