Creating or rebuilding the SQL database

Closed job
Maciej: web-2-business.com
Maciej: web-2-business.com
Employer
23 deals
Job category:
Other IT services
Expected budget:

Negotiable

Preferable skills:
Published:
Valid until:

Job description

Good morning,

I need a person who will build or rebuild the database to be GDPR compliant.

More details:

the jet database associated with the site

pl.edu.pl

- database sample: names of collected records

The structure of the base is attached. There is no data there, but all the tables and their fields are in the database. Hope that's what it was about.

- What are the consents collected

The only consent is the consent to the newsletter - if the application comes from the website:

https://www.pl.edu.pl/formularz/matura

But some users are entered manually into the system and they do not select this consent.

-Number of records with marketing consents to be contacted by phone

We do not collect such consent, so there are no such records.

- Number of records in total in the database and from the last 2 years

The database contains 193,064. In the last two years, 36,402.

But beware - not all tables have an additional timestamp + some records are deleted (e.g. proposal modification, payment removal).

Where we do not have a date for adding, but for example, there is a date for starting and ending classes, I assessed the number of added records using such fields. On the other hand, because participation or payments are changed / removed, for sure by these several / a dozen or so% more operations were actually performed.

- Number of visits during the year to the website (website pl.edu.pl)

we have about 80,000 visits per year

- CMS we use

This is a proprietary solution.

- who is your competition?

https://www.collegium-novum.pl/

https://www.kursysowa.pl/

https://www.pitagoras.edu.pl/

Required functions:

Place or location: