Database Models - bounswe/2021SpringGroup6 GitHub Wiki
User
| Field Name | Is it optional? | Datatype |
|---|---|---|
| user_id | No, this is a primary key | bigint / int8 |
| 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 |