The table t_note
Prev | Chapter 16. Reference database design | Next

## The table t_note

This table contains the extended notes.

note_id

  This unique identifier for entries in t_note is automatically generated by RefDB and is stored as a BIGINT value (INTEGER for SQLite).

note_key

  This is a user-supplied unique identifier for entries in t_note. If not supplied by the user, RefDB will create a unique identifier when the entry is added.

note_title

  This alphanumeric field (up to 255 characters) contains the title of the entry.

note_content

  This alphanumeric field of unlimited length contains the text of the note.

note_content_type

  This alphanumeric field (up to 255 characters) contains the type of the data in the note_content field.

note_content_xmllang

  This alphanumeric field (up to 255 characters) contains an identifier of the language of the data in the note_content field.

note_user_id

  This BIGINT (INTEGER for SQLite) variable points to the user_id in t_user which corresponds to the user who created the note.

note_date

  This DATETIME field stores the date the note was added, or any other user-supplied date.

note_share

  This short integer field stores whether the note may be shared with others (value != zero) or not (value = zero).

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