Multipoint

Entity city_of_presence
city_name: varchar (PK)

Entity user
user_id: varchar (PK uuid)
name: varchar
surname: varchar
phone: varchar
email: varchar
picture: varchar
avatar: varchar
city: varchar (FK city_of_presence.city_name)
roles: varchar[]
default_comment: text
password: varchar

Entity agreement_type
agreement_type_id: varchar (PK uuid)
name: varchar
description: text
status: varchar

Entity user_agreement
user_id: varchar (FK user.user_id)
agreement_type_id: varchar (FK agreement_type.agreement_type_id)

Entity task
task_id: varchar (PK uuid)
user_id: varchar (FK user.user_id)
date: date
start_time: varchar
end_time: varchar
description: varchar(40)

Entity family
family_id: varchar (PK uuid)
head_id: varchar (FK user.user_id)

Entity family_member
family_member_id: varchar (PK uuid)
family_id: varchar (FK family.family_id)
user_id: varchar (FK user.user_id)
family_role: varchar
created_at: timestamp without time zone
invite_token: varchar
birth_date: date

Entity family_nickname
id: varchar (uuid)
from_family_member_id: varchar (FK family_member.family_member_id)
to_family_member_id: varchar (FK family_member.family_member_id)
nickname: varchar
color_schema: varchar

Entity user_agreement (fixed)
user_id: varchar (FK user.user_id)
agreement_type_id: varchar (FK agreement_type.agreement_type_id)
version: varchar
accepted_at: timestamp without time zone