Navrh prikazov - adamkral12/PA036 GitHub Wiki

Vkladanie (Insert)
- vlozit jeden event do mailu
- vlozit viac eventov do mailu
- vlozit mail bez eventov
- vlozit mail s jednym eventom
- vlozit mail s viacerymi eventami
- vlozit viacej mailov bez eventov
- vlozit viacej mailov s jednym eventom
- vlozit viacej mailov s rovnakym pcotom eventov
- vlozit viacej mailov s roznym poctom eventov
Mazanie (Delete)
- vymazat mail podla adresy from
- vymazat mail podla type confirmed
- vymazat maily s danym clientom
- vymazat eventy s danym clientom
- vymazat eventy s event_type open, delivery, click
- vymazat eventy s danou country
Aktualizovanie (Update)
- aktualizovat mail from
- aktualizovat mail sent timezone
- aktualizovat type confirmed na iny
- aktualizovat event type:
  - open na click
  - clienta na iny os
  - country na inu country
  - country aj mesto na ine hodnoty
  - timezone na inu timezone
Spojovanie (Join)
- eventy do jedneho mailu pre maily s rovnakym from a to ??? SELECT ???
- maily s rovnakym from
- maily s rovnakym to
- v maily:
  - eventy podla typu
  - eventy podla clienta
Cteni (Select)
- podla mail:
  - from
  - to
- podla event:
  - type: open, delivery, click
  - client: broser, platform
Agregace (Agregate)
1. Count
  - events in mail
    - events in mail by event_type
  - clients in mail - browser, platform
    - distinct clients (browser,platform) in mail
  - country in mail
2. Min
  - longitude
  - latitude
3. Max
  - longitude
  - latitude
Pritomnost atributu (exists)
- ci sa v sent nachadza timezone
- ci sa v position nachadza timezone
- ci sa v received nachadza timezone
- ci sa v occured nachadza timezone

Dalsie (nebolo zatial navrhovane):

Triedenie - vybrat ktory event (prvy)
- podla krajiny abecedne
- podla mesta abecedne
- podla krajiny a potom mesta
- podla longitude
- podla latitude

Pozn:

Vyhybal som sa polickam date, ak by s tym bola lahka praca mozeme podla toho triedit, pripadne vyhladavat/menit/mazat v rozsahu