sympa-community.github.io

Incubating the new Sympa documentation site

NAME

sympa_database - Structure of Sympa core database

DECRIPTION

Core database of Sympa is based on SQL. In following list of tables and indexes, data types are based on MySQL/MariaDB. Corresponding types are used by other platforms (PostgreSQL, SQLite, …).

Tables

subscriber_table

This table store subscription, subscription option etc.

Fields:

Indexes:

user_table

The user_table is mainly used to manage login from web interface. A subscriber may not appear in the user_table if he never log through the web interface.

Fields:

inclusion_table

Inclusion table is used in order to manage lists included from / including subscribers of other lists.

Fields:

exclusion_table

Exclusion table is used in order to manage unsubscription for subscriber included from an external data source.

Fields:

session_table

Management of HTTP session.

Fields:

one_time_ticket_table

One time ticket are random value used for authentication challenge. A ticket is associated with a context which look like a session.

Fields:

notification_table

Used for message tracking feature. If the list is configured for tracking, outgoing messages include a delivery status notification request and optionally a message disposition notification request. When DSN and MDN are received by Sympa, they are stored in this table in relation with the related list and message ID.

Fields:

logs_table

Each important event is stored in this table. List owners and listmaster can search entries in this table using web interface.

Fields:

stat_table

Statistics item are stored in this table, Sum average and so on are stored in stat_counter_table.

Fields:

Indexes:

stat_counter_table

Used in conjunction with stat_table for users statistics.

Fields:

admin_table

This table is an internal cash where list admin roles are stored. It is just a cash and it does not need to be saved. You may remove its content if needed. It will just make next Sympa startup slower.

Fields:

Indexes:

netidmap_table

FIXME

Fields:

conf_table

FIXME

Fields:

list_table

The list_table holds cached list config and some items to help searching lists.

Fields:

SEE ALSO

Sympa Administration Manual. https://sympa-community.github.io/manual/.


The content of this page is automatically generated from the source distribution of Sympa. For details about this document see original source file.

Theme originally designed by orderedlist