Changes between Version 5 and Version 6 of RelationalDesign

Timestamp:

01/21/26 00:16:33 (3 weeks ago)

Author:

231118

Comment:

--

RelationalDesign

@@ -9 +9 @@
 * Атрибутите кои мора задолжително да имаат вредност (NOT NULL) се болдирани.
 * Атрибутите со услов за единственост во рамки на табелата се дополнително означени со '''(UNIQUE)'''.
+* За составна единственост (composite unique) се користи ознака: '''(UNIQUE: A + B)'''.
 
 Овие ознаки овозможуваат појасно разбирање на структурата на базата на податоци и релациите помеѓу табелите.
@@ -14 +15 @@
 === Табели ===
 
-1. Environments ('''__id PK__''', '''name''' (UNIQUE), '''created_at''')
-2. ENV_Tokens ('''__id PK__''', '''env_name FK*(Environments.name)''', '''token''' (UNIQUE), '''created_at''', expires_at)
-3. Admin_sessions ('''__id PK__''', '''token''' (UNIQUE), '''created_at''')
+1. Tenants ('''__id PK__''', '''name''', '''owner_email''', '''created_at''')
 
-4. Computers ('''__id PK__''', '''name''' (UNIQUE), user, ip, os, first_seen, last_seen, sysmon_available, '''env_name FK*(Environments.name)''')
-5. Computer_history ('''__id PK__''', '''computer_id FK*(Computers.id)''', cpu_usage, ram_usage, disk_usage, network_sent_mb, network_recv_mb, timestamp)
-6. Computer_processes ('''__id PK__''', '''computer_id FK*(Computers.id)''', pid, name, cpu_percent, memory_mb, username, cmdline, timestamp)
+2. Users ('''__id PK__''', '''email''' (UNIQUE), name, picture, '''created_at''')
 
-7. Sysmon_events ('''__id PK__''', '''computer_id FK*(Computers.id)''', event_id, event_type, message, timestamp, details)
-8. Network_connections ('''__id PK__''', '''computer_id FK*(Computers.id)''', pid, local_address, remote_address, status, process_name, timestamp)
-9. Security_alerts ('''__id PK__''', '''computer_id FK*(Computers.id)''', alert_type, severity, description, timestamp, resolved)
+3. Memberships ('''__user_id PK__ FK*(Users.id)''', '''__tenant_id PK__ FK*(Tenants.id)''', '''role''', '''created_at''')
+   *Забелешка:* Memberships има составен примарен клуч: (user_id, tenant_id).
+
+4. Environments ('''__id PK__''', '''name''', '''created_at''', '''tenant_id FK*(Tenants.id)''', (UNIQUE: tenant_id + name))
+
+5. ENV_Tokens ('''__id PK__''', '''env_name FK*(Environments.name)''', '''token''' (UNIQUE), '''created_at''', expires_at, '''tenant_id FK*(Tenants.id)''')
+
+6. Admin_sessions ('''__id PK__''', '''token''' (UNIQUE), '''created_at''')
+
+7. Computers ('''__id PK__''', '''name''', user, ip, os, first_seen, last_seen, sysmon_available, '''env_name FK*(Environments.name)''', '''tenant_id FK*(Tenants.id)''', (UNIQUE: tenant_id + name))
+
+8. Computer_history ('''__id PK__''', '''computer_id FK*(Computers.id)''', cpu_usage, ram_usage, disk_usage, network_sent_mb, network_recv_mb, timestamp)
+
+9. Computer_processes ('''__id PK__''', '''computer_id FK*(Computers.id)''', pid, name, cpu_percent, memory_mb, username, cmdline, timestamp)
+
+10. Sysmon_events ('''__id PK__''', '''computer_id FK*(Computers.id)''', event_id, event_type, message, timestamp, details)
+
+11. Network_connections ('''__id PK__''', '''computer_id FK*(Computers.id)''', pid, local_address, remote_address, status, process_name, timestamp)
+
+12. Security_alerts ('''__id PK__''', '''computer_id FK*(Computers.id)''', alert_type, severity, description, timestamp, resolved)
 
 === DDL скрипта за бришење на табелите и креирање на табелите ===
@@ -32 +46 @@
 [attachment:dml.sql dml.sql]
 
-
 === Релациски дијаграм ===
 
-[[Image(Untitled.png)]] 
+[[Image(Untitled.png)]]