Revize 6c1e92e3

re #9425 Struktury upraveny dle vize. Endpointy rozděleny do souboru podle funkcionality.

server/sql_app/models.py

@@ -13 +13 @@
     serial_number = Column(String, index=True, nullable=False)
 
     logs = relationship("USBLog", back_populates="device")
+    licenses = relationship("DeviceLicense", back_populates="device_lic")
 
 
 class USBLog(Base):
     __tablename__ = "usb_logs"
 
     id = Column(Integer, primary_key=True, index=True)
-    username = Column(String, index=True, nullable=False)
-    hostname = Column(String, index=True, nullable=False)
+    pc_id = Column(Integer, ForeignKey("pc.id"))
     timestamp = Column(String, index=True, nullable=False)
     status = Column(String, index=True, nullable=False)
     device_id = Column(Integer, ForeignKey("devices.id"))
 
     device = relationship("Device", back_populates="logs")
+    pc = relationship("PC", back_populates="logs_pc")
+
+
+class License(Base):
+    __tablename__ = "licenses"
+
+    id = Column(Integer, primary_key=True, index=True)
+    name = Column(String, index=True, nullable=False)
+    expiration_date = Column(String, index=True, nullable=False)
+
+    devices = relationship("DeviceLicense", back_populates="licenses")
+
+
+class DeviceLicense(Base):
+    __tablename__ = "devices_licenses"
+
+    id = Column(Integer, primary_key=True, index=True)
+    device_id = Column(Integer, ForeignKey("devices.id"))
+    license_id = Column(Integer, ForeignKey("licenses.id"))
+    assigned_datetime = Column(String, index=True, nullable=False)
+
+    device_lic = relationship("Device", back_populates="licenses")
+    licenses = relationship("License", back_populates="devices")
+
+
+class PC(Base):
+    __tablename__ = "pc"
+
+    id = Column(Integer, primary_key=True, index=True)
+    username = Column(String, index=True, nullable=False)
+    hostname = Column(String, index=True, nullable=False)
+    logs_pc = relationship("USBLog", back_populates="pc")