Różnice między wybraną wersją a wersją aktualną.
| Both sides previous revision Poprzednia wersja Nowa wersja | Poprzednia wersja | ||
|
pl:dydaktyka:sbd:2012:projekty:catch:start:konceptualny [2012/11/15 23:53] sbd12 |
pl:dydaktyka:sbd:2012:projekty:catch:start:konceptualny [2019/06/27 15:50] (aktualna) |
||
|---|---|---|---|
| Linia 79: | Linia 79: | ||
| **7.** [[http://ai.ia.agh.edu.pl/wiki/pl:dydaktyka:sbd:2012:projekty:catch:start:konceptualny:dhd|DFD:Budowa i analiza diagramu przepływu danych]] | **7.** [[http://ai.ia.agh.edu.pl/wiki/pl:dydaktyka:sbd:2012:projekty:catch:start:konceptualny:dhd|DFD:Budowa i analiza diagramu przepływu danych]] | ||
| + | |||
| + | **8. Wybór encji i ich atrybutów. ** | ||
| + | |||
| + | -//Streams:// | ||
| + | * stream_id (varchar) | ||
| + | * name (varchar) | ||
| + | * user_id (varchar) | ||
| + | * server_modified_at (date) | ||
| + | * local_modified_at (date) | ||
| + | * deleted_locally (bool) | ||
| + | * was_synchronised(bool) | ||
| + | * color (varchar) | ||
| + | * is_deleted (bool) | ||
| + | -//Objects:// | ||
| + | * object_id (varchar) | ||
| + | * type (varchar) | ||
| + | * text (text) | ||
| + | * created_at (date) | ||
| + | * location_id (varchar) | ||
| + | * stream_id (varchar) | ||
| + | * server_modified_at (date) | ||
| + | * local_modified_at (date) | ||
| + | * legacy_v2_share (bool) | ||
| + | * user_id (varchar) | ||
| + | * server_deleted_at (date) | ||
| + | * starred (bool) | ||
| + | * child_of (varchar) | ||
| + | * reminder_at (date) | ||
| + | * deleted_locally (bool) | ||
| + | * was_synchronised (bool) | ||
| + | * is_deleted (bool) | ||
| + | -//Users:// | ||
| + | * user_id (varchar) | ||
| + | * user_name (varchar) | ||
| + | * password (varchar) | ||
| + | * e_mail_address (varchar) | ||
| + | -//Locations:// | ||
| + | * location_id (varchar) | ||
| + | * longitude (varchar) | ||
| + | * latitude (varchar) | ||
| + | * altitude (varchar) | ||
| + | * bearing | ||
| + | * accuracy | ||
| + | * altitude_accuracy | ||
| + | * speed | ||
| + | * name (varchar) | ||
| + | * zoom | ||
| + | -//Tags:// | ||
| + | * tag_id (varchar) | ||
| + | * tag_text (varchar) | ||
| + | * object_id (varchar) | ||
| + | -//Shared_stream:// | ||
| + | * shared_stream_id (varchar) | ||
| + | * stream_id (varchar) | ||
| + | * user_name (varchar) | ||
| + | -//Comments:// | ||
| + | * object_id (varchar) | ||
| + | * e_mail_address (varchar) | ||
| + | * added_date (date) | ||
| + | * comment_text (text) | ||
| + | * server_modified_at (date) | ||
| + | * local_modified_at (date) | ||
| + | * is_deleted (bool) | ||
| + | -//To_do// | ||
| + | * to_do_id (varchar) | ||
| + | * object_id (varchar) | ||
| + | * to_do_text (text) | ||
| + | * is_checked (bool) | ||
| + | * is_deleted (bool) | ||
| + | * server_modified_at (date) | ||
| + | * local_modified_at (date) | ||
| + | |||
| + | **9. Projektowanie powiązań pomiędzy encjami.** | ||
| + | |||
| + | {{:pl:dydaktyka:sbd:2012:projekty:catch:start:erd.png|}} | ||
| + | |||
| + | **10. Projekt diagramów STD** | ||
| + | |||
| + | {{:pl:dydaktyka:sbd:2012:projekty:catch:start:std.png|}} | ||
