TelegramAktienBot/documentation/database/structure_database.uxf

<diagram program="umletino" version="14.3.0"><zoom_level>10</zoom_level><help_text>Database V0.1</help_text><element><id>UMLClass</id><coordinates><x>705</x><y>360</y><w>210</w><h>80</h></coordinates><panel_attributes>keywords
--
PK: s_id                              int(11)
FK: email                  varchar(255)
keyword                   varchar(255)</panel_attributes><additional_attributes></additional_attributes></element><element><id>UMLClass</id><coordinates><x>425</x><y>240</y><w>210</w><h>130</h></coordinates><panel_attributes>users
--
PK: email                  varchar(255)
password                  varchar(255)
username                 varchar(255)
telegram_user_id      varchar(255)
admin                             tinyint(1)
cron                            varchar(20)
</panel_attributes><additional_attributes></additional_attributes></element><element><id>UMLClass</id><coordinates><x>705</x><y>150</y><w>210</w><h>90</h></coordinates><panel_attributes>shares
--
PK: a_id                              int(11)
FK: email                  varchar(255)
isin                           varchar(255)
comment                  varchar(255)</panel_attributes><additional_attributes></additional_attributes></element><element><id>UMLClass</id><coordinates><x>135</x><y>150</y><w>210</w><h>130</h></coordinates><panel_attributes>transaction
--
PK: t_id                               int(11)
FK: email                  varchar(255)
isin                           varchar(255)
comment                  varchar(255)
time                               datetime
count                                 int(11)
price                                     float
</panel_attributes><additional_attributes></additional_attributes></element><element><id>Relation</id><coordinates><x>335</x><y>190</y><w>110</w><h>100</h></coordinates><panel_attributes>lt=&lt;&lt;-
group=1</panel_attributes><additional_attributes>10;10;60;10;60;80;90;80</additional_attributes></element><element><id>Relation</id><coordinates><x>625</x><y>190</y><w>100</w><h>100</h></coordinates><panel_attributes>lt=&lt;&lt;-</panel_attributes><additional_attributes>80;10;50;10;50;80;10;80</additional_attributes></element><element><id>Relation</id><coordinates><x>625</x><y>260</y><w>100</w><h>160</h></coordinates><panel_attributes>lt=&lt;&lt;-</panel_attributes><additional_attributes>80;140;50;140;50;10;10;10</additional_attributes></element><element><id>UMLClass</id><coordinates><x>140</x><y>410</y><w>100</w><h>30</h></coordinates><panel_attributes>Database V0.1</panel_attributes><additional_attributes></additional_attributes></element><element><id>UMLClass</id><coordinates><x>705</x><y>150</y><w>210</w><h>90</h></coordinates><panel_attributes>shares
--
PK: a_id                              int(11)
FK: email                  varchar(255)
isin                           varchar(255)
comment                  varchar(255)</panel_attributes><additional_attributes></additional_attributes></element><element><id>UMLClass</id><coordinates><x>140</x><y>300</y><w>210</w><h>90</h></coordinates><panel_attributes>share_price
--
PK: id                                 int(11)
isin                           varchar(255)
price                                      float
date                                datetime</panel_attributes><additional_attributes></additional_attributes></element></diagram>