User tools

Website tools


database schema

Differences

The differences between two versions are shown here.

Link to this comparison view

Both sides of the previous revisionPrevious revision
Next revision
Previous revision
datenbank-schema [2025/02/07 08:40] lwsystemsdatenbank-schema [2025/02/07 08:42] (current) – [filter] lwsystems
Zeile 67: Zeile 67:
 mit dem Benutzernamen "userid" geladen und bei jeder Suche per //AND// verknüpft. mit dem Benutzernamen "userid" geladen und bei jeder Suche per //AND// verknüpft.
  
 +<code sql>
 +--------+--------------+------+-----+---------+-------+ +--------+--------------+------+-----+---------+-------+
 | Field | Type | Null | Key | Default | Extra | | Field | Type | Null | Key | Default | Extra |
 +--------+--------------+------+-----+---------+-------+ +--------+--------------+------+-----+---------+-------+
-| id | varchar(64)  | NO | PRI |               | +| id | varchar(64)  | NO | PRI |               eindeutige Id des Filters 
-| userid | varchar(128) | YES |                   | +| userid | varchar(128) | YES |                   Anmeldename 
-| name | varchar(255) | YES |                   | +| name | varchar(255) | YES |                   Name des Filters zur Anzeige im [i] Fenster 
-| filter | text | YES | | NULL | |+| filter | text | YES | | NULL |       Lucene Query String
 +--------+--------------+------+-----+---------+-------+ +--------+--------------+------+-----+---------+-------+
 +</code>
  
 ===== storedquery  ===== ===== storedquery  =====
datenbank-schema.1738917648.txt.gz · Zuletzt geändert: 2025/02/07 08:40 von lwsystems