Chapter 20. Article Record Definition

An article record contains information about an article, its owner and the topic it belongs to.

The following list gives an overview of the fields of an article record as well as a generalized form of their typisation in the storage backend.

Warning

Be careful when you rely on the datatypes mentioned below! Some of those fields are "implicit foreign keys" that are especially critical to the integrity of your database when using replication. The Midgard functions, object methods and repligard can deal with these dependencies -- so, if you do not really know what you do, use them.

Fields of an article record

id (integer)

The id of the article record.

up (integer)

Points to the id of the article this record is a reply/followup to.

topic (integer)

Points to the topic-id of the topic this record is under.

title (string(255))

The title of the article.

abstract (text)

An abstract of the article.

content (text)

The content of the article.

author (integer)

Points to the person-id of the author of the article.

created (datetime)

Date and time the article was created.

url (string(255))

Pointer to a URL leading to further information.

calstart (date)

Date indicating a start date (for publication, normally).

caldays (integer)

The number of calendar days from calstart.

icon (integer)

An integer, originally pointing to an icon ID for this article.

view (integer)

An integer, originally pointing to a "view" ID for this article.

print (integer)

An integer, originally pointing to a printable version ID of this article.

extra1 (string(255))

A freeform information field.

extra2 (string(255))

A freeform information field.

extra3 (string(255))

A freeform information field.

name (string(255))

The name of the article, to be used in URLs, for example.

creator (integer)

Points to the person-id of the creator of the article.

revisor (integer)

Points to the person-id of the last revisor of the article.

revision (integer)

An integer representing the number of times the article has been revised.

approver (integer)

Points to the person-id of the last approver of the article.

revised (datetime)

Date and time of the last revision of the article.

approved (datetime)

Date and time the article has been approved the last time.

score (integer)

An integer value that can be used to sort articles.

type (integer)

An integer value that can be used to filter articles.

locked (datetime)

Data and time the article has been locked last.

locker (integer)

Points to the person-id of the last locker of the article.

sitegroup (integer)

Points to the sitegroup-id of the sitegroup to which the article belongs.