The table t_periodical
Prev | Chapter 15. Reference database design | Next

## The table t_periodical

This table is a list of all periodicals.

periodical_id

  This is the unique identifier of each periodical and is stored as a BIGINT value (INTEGER for SQLite).

periodical_name

  This is the full, unabbreviated name of the periodical. This is an alphanumeric field with a limit of 255 characters.

  Examples: Trends in Biochemical Sciences; Proceedings of the National Academy of Sciences of the United States of America

periodical_abbrev

  This is the official abbreviation of the periodical as seen in the Index Medicus. Abbreviated words have a trailing period. All words are separated by a space. This is also an alphanumeric field with a maximum of 255 characters.

  Examples: Trends Biochem. Sci.; Proc. Natl. Acad. Sci. USA

periodical_custabbrev1

  This is a custom abbreviation, often shorter and more popular than the official abbreviation. This is again an alphanumeric field with a limit of 255 characters.

  Examples: TIBS; PNAS

periodical_custabbrev2

  This is another custom abbreviation, often shorter and more popular than the official abbreviation. This is again an alphanumeric field with a limit of 255 characters.

Prev | Up | Next
The table t_keyword | Home | The table t_user