Backend Meeting 1.2

Meeting Information


Date	23/10/2022 14:00 - 15:30
Platform	Discord
Note Taker - Reviewer	Irfan Bozkurt - Alper Canberk Balcı

Participants

Alper Canberk Balcı
İrfan Bozkurt
Mehmet Emre Akbulut
Oğuzhan Demirel

Description

Mainly discussing the initial schema / tables of the database
Talking on the tasks briefly

Agenda

Deciding on the table structure of the database (decided as PostgreSQL)

Discussion

The table structure is decided as follows

Initial Tables (Of course, subject to change)

user:

- id (int)
- password (string)
- email (string) (unique)
- type (int)
	0 for admin
	1 for member / patient
	2 for doctors

admin:

- id (int)
- userid (fk)
- username (string) (unique)

member:

- id
- userid (fk)
- username (string) (unique)
- avatar (string -> S3 URL)
- banned_by (admin) (fk) (default NULL)
- member_info (member_info) (fk)

member_info:

- id
- firstName NULL
- lastName NULL
- address (?)
- weight (float)
- height (float)
- age (int)
- past_illnesses: array(str)
- allergies: array(str)
- chronic_diseases: array(str)
- undergone_operations: array(str)
- used_drugs: array(str)

category:

- id (BigNumber)
- name (string)
- definition (string)

doctor:

- id
- userid (fk)
- full_name (NOT NULL)
- specialization (Category (fk)) (many to 1)
- hospital_name (string)
- verified (bool)

report:

- id
- reporter_id (user) (fk)
- reported_id (user) (fk)
- report message (string)
- reviewed by (admin) (fk)

The database connection of the initial Django project was discussed and configured
It was decided that Login will be implemented right after the initial DB tables are created.
Discussing on the tasks briefly (that were decided in last back-end meeting)