chapter5: add physic model

7 files changed, 56 insertions, 7 deletions

diff --git a/chapters/physic.tex b/chapters/physic.tex
new file mode 100644
index 0000000..1e923a9
--- /dev/null
+++ b/chapters/physic.tex
@@ -0,0 +1,34 @@
+Qui di seguito è riportato il \verb|dump| in SQL per la creazione delle tabelle all'interno di PostgreSQL
+\begin{lstlisting}[language=SQL]
+CREATE TABLE "repository" (
+    id serial PRIMARY KEY NOT NULL,
+    url varchar(255) UNIQUE NOT NULL,
+    created_date timestamp NOT NULL,
+    updated_date timestamp NOT NULL,
+	uploader_ip varchar(15) NOT NULL
+);
+
+CREATE TABLE "email"(
+    email varchar(120) PRIMARY KEY NOT NULL,
+    hash_md5 varchar(32) UNIQUE NOT NULL
+);
+
+CREATE TABLE "commit" (
+    hash varchar(40) PRIMARY KEY NOT NULL,
+    tree varchar(40) REFERENCES commit(hash) NULL,
+    text text NOT NULL,
+    date timestamp NOT NULL,
+    author_email varchar(120) REFERENCES email(email) NOT NULL,
+    author_name varchar(120) NOT NULL,
+    committer_email varchar(120) REFERENCES email(email) NOT NULL,
+    committer_name varchar(120) NOT NULL,
+    repository_url varchar(256) REFERENCES repository(url) NOT NULL 
+);
+
+CREATE TABLE "branch" (
+    id serial PRIMARY KEY NOT NULL,
+    name varchar(120) NOT NULL,
+    repository_id integer REFERENCES repository(id) NOT NULL,
+    head varchar(40) REFERENCES commit(hash) NULL
+);
+\end{lstlisting}
\ No newline at end of file
diff --git a/conf.tex b/conf.tex
index bc4c445..0b41c75 100644
--- a/conf.tex
+++ b/conf.tex
@@ -3,13 +3,25 @@
 \usepackage{charter}
 \usepackage
 [
-        a4paper,
-        left=2cm,
-        right=2cm,
-        top=3cm,
-        bottom=4cm,
+   a4paper,
+   left=2cm,
+   right=2cm,
+   top=3cm,
+   bottom=4cm,
 ]
 {geometry}
+\usepackage{listings}
+\lstset
+{
+    language=SQL,
+    basicstyle=\footnotesize,
+    numbers=left,
+    stepnumber=1,
+    showstringspaces=false,
+    tabsize=4,
+    breaklines=true,
+    breakatwhitespace=false,
+}
 
 
 
diff --git a/data/relation.drawio b/data/relation.drawio
index bdc14ac..57da931 100644
--- a/data/relation.drawio
+++ b/data/relation.drawio
@@ -1 +1 @@
-<mxfile host="app.diagrams.net" modified="2021-03-10T21:30:22.663Z" agent="5.0 (X11)" etag="Wuw_bCHz0Qqz515RAkCZ" version="14.4.6" type="device"><diagram name="Page-1" id="2ca16b54-16f6-2749-3443-fa8db7711227">7Vpbc+I2FP41PIaxLdvAYyCXziTbzey23d2+MMIStrq25QqRwP76SrZ8kw0hBBPoQGaC9enonKNjnZtND0yi1T2DSfCJIhz2LAOteuCmZ1nuwBX/JbDOAGCDDPAZQRlklsBX8gsr0FDokiC8qBFySkNOkjro0TjGHq9hkDH6Uieb07AuNYE+bgBfPRg20W8E8UChpmGUE79h4gdK9NBREzPo/fQZXcZKXs8C8/STTUcw56XoFwFE9KUCgdsemDBKeXYVrSY4lKbNzZatu9swW+jNcMx3WWBhBCw8Nyw4mNtiH1eKwzMMlzjfghsKXmNEnqXCfK2M5P67lFqOZ3R1tSC/SOz3wLU0AWUIsysBi4GYF/9fMhvK2dSETjFTtZecFvbCtvwrKBKIUMHbSlalYHHly+8vOKELwilb56qK/abaZvM5yuFMqN62hc36zWnM5e6wmsVRVb7hCWsuEuilClYYGg2qYhsVKqu5l0LXGUXrBsgaCMqRp4fK5ku4SUhQjs0a7FqXSrApeIsqb+RfIksWnqxuHsOQExpPEeT4ZLVcJlI9VFPyw1UKKRQBYUqSQ5hNgm2+IfHMv3Pcqrm69YwZJyLCX4fEjwXEaSLIoBqFeC5XUUE1D9OAPCciUIJxwCPxdWOKyzRMYRk4ZXAoIrcceDQinroO4QyH4yKuTWhImZiKaYzlMs7ozyKpSLYyxNzBiIQyV/6FGYIxVLBKjKbVDOt5nBa7wqsKpML8PaYR5jIiGmrWtlXKUSnZAmr8UklwOU1QyW1mnqugSqp+wbtMLOJC5ZYd84x9fnnmCbMFjS855qxzDI4gCU9ElxhGp5tKArgIphFyLkH7A4O2CepB2zZbgrbZFrSNAwRte0weprPlffDyNxt8+4zGP26mV6BxkzASvZMaUsYD6tMYhrclqt2EkuaRyvuZGvQfzPlamQ4uOa3fRbwi/Lu4vjL6hmEp4Ifk1wcDNbxZKf7pYF0ZiMBNxOYxy7FYGOJ7dZCxEubOgZJZOlpXRzq7BYeMX8uuUwC3X/IjI8C79DiqlagkiWCMPqdkAq4QbTwxC7pkHt6QSh3VIEPmY76dRt6qreeO4VCUuc/1NrjtDKmlT5QIVYvzOtRqDFs7hZmOalF5EIVl4LpClkiCxe5iBsN6k/sKuTPUvCCTX/pEYZD9ahvn/GqbCY0iwi+1zW558bAp+k6INn7/8/Fx71zNGT7dQkKkOn6yyh2jm7972Fs9kQkDKlrnzuvpd+jopaGD40OpeSkW9y0WzR06/GFbsQi6KhadjygWm/XYH/QTjNe9PauyjeWi03ulWlRVa7NoHeXD3YvW7mpD+zi1YfEcKe9ldiwOm4y0cw50RplF3l1lDkZ1MY6xVS2N3AbOQavMVv8afGQz1jzWQ8N887nuzFtNoR7QPfZVl21r8Da63im4lQXaz90+btUHrlF+zPrxB0bfBJ04mjPSJW1VVCN39FecGnnut/vSa47cvAGDrfTdOP7w/FrMMYOxV22dLi3m+T0+P8Yj63f0Iqz4KcBRe6bXHhlgiN4u+tIH7dkH6W86baOlD2p909nZQ/PR/6sP6o9Go3plBSzreJWVeZzKyjX0x8x7NiyO9gDadt1O6ih3g5xNeun0ljvaTq8/YKjTd1Pp5DLP+YVTdz2O3t+84oQb/a3zLmWkv4Nx+3v2KTYY9V17U5tiD+2+ral3IPeyteMvRG1XVHcXZ7C9kWjYqEb/VvcSw/J3pBl5+VtdcPsf</diagram></mxfile>
\ No newline at end of file
+<mxfile host="app.diagrams.net" modified="2021-03-11T20:12:52.061Z" agent="5.0 (X11)" etag="_wcAmTgS6KpZ2zZGHrlf" version="14.4.7" type="device"><diagram name="Page-1" id="2ca16b54-16f6-2749-3443-fa8db7711227">7Vpbc+I2FP41PIaxJZvLY0hCOpNsN7Pbdnf7khGWwOralitEAvvrK9nyTTaXEEygA8mA9eno6OhY5ya7A2/C5T1Hsf+JYRJ0gIWXHXjbAcB2AOiofwuvUqQPnBSYcYo1UQF8pb+IBi2NLigm8wqhYCwQNK6CHosi4okKhjhnr1WyKQuqs8ZoRmrAVw8FdfQbxcLXqG1ZRcdvhM58PfXA1R0T5P2ccbaI9HwdAKfJJ+0OUcZL0899hNlrCYJ3HXjDGRPpVbi8IYHSbaa2dNx4TW8uNyeR2GUAIBgCMrUA6k/lXRtcaQ4vKFiQbAm9QPIaYfqiBBYrraTevwsl5WjClldz+otGsw68VipgHBN+JWHZkP3y+zXVoepNVOjmPWV9qW6pL+Kov5wiRhjnvEG8LCaWVzP1+4XEbE4F46tMVLneRNq0P0MFmkjRm5awXr4pi4RaHdG9JCzPb3lSm/MYeYmAJYZWjSpfRokK1NeSyzpheFUDeQ3BGfL0UFp8AdcJKc6wSY1d41AF1ifeIMob+RfIggcnK5vHCRIEP2P5fbJCLmJcE/LDRQoYkv7gmcaHUJsCm0xD4al5ZzioWDp4IVxQ6eCvAzqLJCRYLMmQbgVkqkYxSTUNEn88pdJPwpEvQvlza8vLxEsR5TeVb8gdt2p4LKSevg7QhASj3K3dsIBx2RWxiKhhgrOfeUxRbJWHGaOQBipU/kU4RhHSsI6LNqh79cxNy1WRZQnSXv6esJAI5RAt3es4OuLoiAygbr+W4ltG45dCm52FKqRj6iznXcQVeaFDy45hxjm/MPNE+JxFlxBz1iGGhIgGJyJLhMLTDSU+mvvPIXYvTvsDnbYNq07bsRuctt3ktK0DOG1nRB+eJ4t7//Vv3v/2GY9+3D5fwdpNIliWTrrJuPDZjEUouCtQ4yYUNI9M3c9Eof8QIVZadWghWPUukiUV3+X1ldW1LKCBH4pfF/Z183ap+SeNVakhHTeViyc8wyKpiO/lRspKqjsDCmZJa1VumezmAnFxrYpOCdx9ybaMBMfJdtQjcUESogh/TsgkXCJau2PmbME9siaUuro+RnxGxGYadas27jtOAiToS7UKbtpDeugTo1LUfL8OjBzDMXZhKqMeVGxEqRm0KpHFimC++zT9QbXG3ULuDgwrSOcvbCJXyH65jXt+uc0NC0MqLrnNbnHxsCF6LKe2fv/z8XHvWC04Od1EQoY6cbLCHaOaHz/sLZ6MhD6TpXPr+fQ7ZPQS1yHIocS8JIv7Jov2DhX+oClZhG0li+5HJIv1fOwP9glFq86eWdnadNHtbMkWddZaT1qHWXP3pLW93NA5Tm6YnyNltcyOyWGdkbHPocko1ci7s8z+sDqNa20UyyB3oHvQLLPRvvofWYzVt/XAst+8r1uzVluKB02L3WqyTQXeWtM7BbMCsHnf7WNWXdizio9d3f7Q6tqwFUNzh+ZMGwU1yF3zCadBntntvvSGIddvQH8jfTuGPzi/EnPEUeSVS6dLiXl+x+fHOLJ+Ry3C8zcBjlozbTsyIAi/fepLHbRnHWQ+6XSshjqo8Ulna4fmw/9XHdQdDofVzAoCcLzMyj5OZtWzzGPmPQsW1ziAdnq9VvKo3pp51sll0oPecDO9ecBQpW8n08nmPOcHTu3VOGZ9s8UI19pb61XK0HwG0+vuWac4cNjtOevKFGfgdB1DvAOZl2NsfznVZkFNc3H7mwuJmo4q9G81L9ksXiNNyYt3deHdfw==</diagram></mxfile>
\ No newline at end of file
diff --git a/data/relation.png b/data/relation.png
index 2b17e32..87bdb40 100644
--- a/data/relation.png
+++ b/data/relation.png
diff --git a/data/relation_final.drawio b/data/relation_final.drawio
index 8447be2..cf8cb0d 100644
--- a/data/relation_final.drawio
+++ b/data/relation_final.drawio
@@ -1 +1 @@
-<mxfile host="app.diagrams.net" modified="2021-03-11T19:31:12.108Z" agent="5.0 (X11)" etag="exXV94_6guYA5iLTdZ6t" version="14.4.7" type="device"><diagram name="Page-1" id="2ca16b54-16f6-2749-3443-fa8db7711227">7VrbcuI4EP0aHkPZlm3MYyAhW5VkJzsz2WT2hRJYGO3YFitEgPn6kWz5JtsEDCSwBakKVqsldbfVlyPRAv1gdUfhbPpIXOS3DM1dtcBNyzAcHfD/grCOCaZuxgSPYjcm6RnhG/6FJFGT1AV20bzAyAjxGZ4ViWMShmjMCjRIKVkW2SbEL646gx4qEb6NoV+mvmCXTSVV17Ss4w+Evalc2rFkxwiOf3qULEK5XssAk+gTdwcwmUvyz6fQJcscCdy2QJ8SwuKnYNVHvjBtYrZ43KCmN5WbopBtM8BALjDQRDNgZ2JyPa7kDG/QX6BEBdvnc/Vc/CYEZmtpJPu/hZCyNyKrqzn+hUOvBa6FCQh1Eb3iZN7g/fz/Mrah6I1MaKU9eXuJbm4vZIq/lGMGXTed25itsoX5kye+v6IZmWNG6DoRlesbSRv3J1QGR1z0KhXq5ZuQkAntkOxFQX59bcytOZ/BcSRgbkKtxJWqkeMyyrqkso6Iuy4RaYniJpSn+5zyGbnMiN2ENipNVzlUEMsLbxDl+a8dV8goC+ofW7rGso0pggyTcOhChk5WysVMiOcWhPx0kXwCeUgY4tkhzCaIVd4h6LGHJ3Sj4OzGG6IM8xh/7WMv5CRGZpwNypaPJmIU4VwTPwrJE8xDJehNWcC/bnT+GAUqJEKnCA9p7BaNMQnwWD77cIT8XhrZ+sQnlHeFJERiGKPkZ5pWxLQiyAxggH2RLf9G1IUhlGSZGnWjHNiTSM21QqscSQb6O0QCxERM1GSvmSSdJCknSWuZS3GmpE1z2U1PBkKZVr107iy18AeZXbbMNOb5ZZrbAGI/t98uSaaGEeUNdYJ5Zgrn02HgWpd49InxSLeVeNSpiEd6RTyyDxCOzB6+H44Wd9PlP7Tz8sXt/bgZXoHSO0IuxwWySSibEo+E0L/NqMo7yHgeiHidkT3/RYytpeXggpHiS0QrzF7lcPH8Qzy3eXiImzerXN/NOmmEXN/XfEMO48hLErKBUasw8glRzE2GaLJ1GKTsWgAnTrj9mmwMThxEm06OdDOWAIbul4iNk3NMtftiThZ0jGpygRXzCGtv3DkU+bwGeyuitKptIIc+EczFyHacXtxxhtVpm53iLFxpDzE5MNtPXHO4zrHNBMN8w1Jat7hUp1MEYgq/o+3FbhXY+UMsb61sbRt0c5/iZE6nDbTcR7FQ/CZLFoo8Ln1XzWoC6/xqgj4JAswuRcF2SfewFcCAL639+fzw0LgQYBSdLpbjeZSdrHAfgYIH943F43l2SujwQwrRfYUMYXDKphxHEY4XCyduzUzOEzcoTQ8shwc68LpgkKYYRK0IQQUGcarORLrHAiHWZ4CQMgD4Th5huG4dGgYcvcRXQKWlKe+ppr5/FyuAjjJRTRm8K1DodCuXqRNLYU/Uq9WixhyVQKFBBV+5gzufCqPbmma08lDa0ZL+GizNG+8D4v38IcXrequA163WZrRe60fxNq6BUebH+JoBipvRBFZjX2sDO4c49aJPAK2d3Cgf2PusrrrSRkEVdvsd7wOWthf/h3irc36Yu0dhOM5jyQvmrmE8/m1v4yr4fIr04xtxsPUZCoLu7ktf4EFDeGBa6jnrtlematl5MHjQ/T/Ag6RY03mxBgrFmu3sXKttizWKdxD1ufDgdZKlXnQ5DTFJaSL1Yv5AVZENFOyjOxvlUvkTBbfWw/mAOifBc2fuOSmQSHBOBiZ0y34HTlRe/m3vPxtBh3UU3wHqAY1tNvMdNZQDANoKXDmQ95jqyQEAmyUrqfgOStjMv7f3eC8T7+FtOTIeX58nRv+7NiTp70LP3Hlyaad4RtA1ujvnnewOnk9nFV0ROHpzVyz5XcPr9I3ueqQjga4S2dVTs23dFRham6e3uhMBzTmK6wL1J3La5mt4oCayXfm79j6uy5vZT8Vj9uzn+OD2Nw==</diagram></mxfile>
\ No newline at end of file
+<mxfile host="app.diagrams.net" modified="2021-03-11T20:13:50.359Z" agent="5.0 (X11)" etag="DqkGxpq0SlAGm7WaIG9K" version="14.4.7" type="device"><diagram name="Page-1" id="2ca16b54-16f6-2749-3443-fa8db7711227">7Vptd+IoFP41fqwnCYnGj9XW7jltd7oz021nv3hQMLKTBBex1fn1Awl5I8ZqfKnu0fZouFzgcuG+PJAG6AWLOwank0eKsN+wDLRogJuGZZm2ZTXkv4GWMaVt2THBYwQppozwjfzCimgo6pwgPCswckp9TqZF4oiGIR7xAg0yRt+LbGPqF0edQg+XCN9G0C9TXwjiE0U1DSOr+AMTb6KGdh1VMYSjnx6j81CN17DAOPrE1QFM+lL8swlE9D1HArcN0GOU8vgpWPSwL3WbqC1u16+oTeVmOOSbNLAwAhYeGxZsj8WquVeqhzfoz3EyhZYv+uoi8iYF5kulpNZ/cylld0gXVzPyi4ReA1xLFVCGMLsSZFEQ9eL7PdahrI1U6KQ1eX3JaqEvbMu/lGMKEUr7tqaLbGDx5Mnfr3hKZ4RTtkxEFfONpI3rEyqHQyH6qilUyzemIZezw6oWB/nxjZHQ5mwKR5GAuQ6NElc6jRyXVZ5LKuuQomWJyEoUlFCe7nOTz8hlRoIS2rDU3cqmklgeeI0oz39tOUJGmTP/0NLVlm3EMOQYDZD4Plkh51NUEvLTRfIpFB5hQKb7UJskrjIOSY8NPKFbBVu33jDjRLj4a594oSBxOhVsUJV8PJatqOAa+5FHHhPhKUF3wgPxc2OKx8hPYek5pXdIXbcsjGhARurZh0Psd1PH1qM+ZaIqpCGWzTijP9OoIruVPqYPA+LLYPk3ZgiGUJFVZDStsl9PHLWYFV7kSMrP32EaYC5doqFq7STmqJhsJzHrPRfhbEWb5IKbmTSEKqp6ad9ZZBEPKrhsGGjs8ws0twEkfm6/XWJMBSPOK+oEw8wEziaDADkXf/SJ/shsaf6ovcIfmSv8UWsP7sjukvvBcH43ef+HtV++oO6Pm8EVKK0RRgIWqCJlfEI9GkL/NqNqa5DxPFC5nJE+/8WcL5Xm4JzT4iLiBeGvqrl8/iGfm8I9xMWbRa7uZpkUQjHf13xBNTNBQsgaRqVCyyfMiFAZZsnW4ZDxa4mbBOH2a7IxBLEfbTrVEmUsAQzRl4hNkHNMlftiRudshCtigRPzSG2v3TkM+5CTtyJIW7UNVNMnSoQY2Y4zizvOctpNu13sRUzaw1w1zPaTmDlc5timkmG2ZiijUxyq3S7iMI3fNXZidwrs4iGWt1K2Zgt0cp9iZ267CYzcR9NQvJIlDUUWl65VvZzAOb+coEeDgPBLUrBZ0N1vBtAXQxt/Pj881E4EOMOni+VEHOUnK9wxUHD/vrZ4Is5OKBscJRHdVcgQBqesylHk4USycOLazOQ8cYWy9LxysKfzrgsGqYtB9IwQrMAg7qozkc6hQIjzGSCkDAC+00cYLhv7hgEHT/E1UOkY2jpV5PcfYgXQ1jqqSIO3BQrtzsphqsTS2JPpVc6iQh0rgUKNDH7lDm5/KoxuGobVyENp10jqK7C0KHwMiHezhxSvm40CXnca69F6pR3F27gCRtnHsTULFDejDZzattYErRziNIs2AYymCQ5ifU5HH2mtoBp76wPrA46xE/9RrNU9P8zdZTAc5bHkBXNXMB7+srd2Fnw+Sfrhldjf+AwFQ7T90Bd4UBMe2I5+zrrplamedu4NHnT+D/AgSdZMkayBQrLWcrfO1SrXOX/lsC70HTpPcvSLLrcmJil1pF/M7ykragEN+5juWrl0/mSCG8/DPUKek+C5M7ecFEgkOCcDE6bT+gBOrLz8q4cxjnRlB/QDmpZdz3Z0Vw4AaGpwZU/WY+snBwCsl6w0xQ9Qwnr+na3Hexl7D2/vQ+vx9Xls9b4bA5q+FnrmxpMLO8Uzgo7V2TruZHfwojunaIrANfdqipvcnq811yMdv1kdzbPrp2abmiuwjKYIb1UnAoZ7ENMF+ityxvpreKAHsm35O61dTFcUszfFY/bsdXxw+xs=</diagram></mxfile>
\ No newline at end of file
diff --git a/data/relation_final.png b/data/relation_final.png
index 87e80e4..d098d36 100644
--- a/data/relation_final.png
+++ b/data/relation_final.png
diff --git a/gico.tex b/gico.tex
index 553f6d1..e4985c8 100644
--- a/gico.tex
+++ b/gico.tex
@@ -27,4 +27,7 @@
 \chapter{Schema logico}
 \input{chapters/relation}
 
+\chapter{Schema fisico}
+\input{chapters/physic}
+
 \end{document}