dbo.archive

Columns

Column name1) Column type Description Notes
PK ar_id INT
ar_namespace SMALLINT
ar_title NVARCHAR(255)
ar_text NVARCHAR(MAX)
ar_comment NVARCHAR(255)
FK1 ar_user INT
ar_user_text NVARCHAR(255)
ar_timestamp VARCHAR(14)
ar_minor_edit BIT
ar_flags NVARCHAR(255)
ar_rev_id INT
FK2 ar_text_id INT
ar_deleted TINYINT
ar_len INT
ar_page_id INT
ar_parent_id INT
ar_sha1 NVARCHAR(32)
ar_content_model NVARCHAR(32)
ar_content_format NVARCHAR(64)

Relationships

This table belongs to the Content module.

References to other tables

Attributes
(in this table) 		Referenced table Referenced attributes
(in referenced table)
FK1 ar_user dbo.mwuser user_id
FK2 ar_text_id dbo.text old_id

References to this table from others

Relationship Attributes
(in referencing table) 		Referenced attributes
(in this table)
(None).

Page generated from database metadata by DbScout.

1)
Columns with names in bold are non-nullable; columns with underlined names are participants in the table's primary key.