> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # text table > Long text fields from all over the system ## text Table (18) Long text fields from all over the system ## Fields | Name | Description | Type | Nullable | | ------------------------- | ----------------------------------------------------------------------------------------------------------------- | ------------------------------------- | :------: | | text\_id | Primary key | PK | No | | type | Text type, enum that specifies owning table and role | Enum [TextType](./enums/texttype.mdx) | Yes | | owner\_id | Record ID of owner record | Id | Yes | | registered | Registered when | UtcDateTime | No | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | No | | updated | Last updated when | UtcDateTime | No | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | No | | updatedCount | Table number of list table that this text contains an extension of; this is obsolete functionality | TableNumber | No | | text | The actual text, max 2047 significant characters even though it is stored as a larger data type on some databases | String(4000) | Yes | | lcid | Language/culture code of the text, if known. This is a reserved field for future use | UShort | Yes | | seqno | Sequence number, for possible chaining of multiple records to store longer texts | UShort | Yes | | html\_text | Formatted text suitable for html text editors | Clob | Yes | text table relationship diagram ## Indexes | Fields | Types | Description | | --------------- | ------------ | ----------- | | owner\_id, type | Id, Enum | Index | | text | String(4000) | Full text | ## Relationships | Table | Description | | -------------------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [appointment](./appointment) | Tasks, appointments, followups, phone calls; and documents (document\_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this. | | [associate](./associate) | Employees, resources and other users - except for External persons | | [contact](./contact) | Companies and Organizations. | | [document](./document) | Documents, this table is an extension of the Appointment table. There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a record in VisibleFor specifying who may see this. | | [ExternalEvent](./externalevent) | The definition of projects as events in Audience (or other Collaborative apps) | | [person](./person) | Persons | | [project](./project) | Projects | | [projectmember](./projectmember) | Project members. Link-table between person and project | | [Role](./role) | User roles for role-based security, names and tooltips are in LocaleText. For more information regarding role based security, see [http://techdoc.superoffice.com](http://techdoc.superoffice.com) | | [sale](./sale) | Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels. | | [SaleHist](./salehist) | Mirror image of the Sale table, providing a full transaction history. Every time you edit a sale, the current record of the sale is also saved here. | | [SearchCriteria](./searchcriteria) | Criteria storage for Selection and other Find mechanisms | | [SearchCriteriaGroup](./searchcriteriagroup) | Criteria storage for Selection and other Find mechanisms | | [selection](./selection) | Selections | | [StatusDef](./statusdef) | Status definitions. Name and description are in LocaleText for internationalization | | [UDefField](./udeffield) | Definition table for user-defined fields; one row in this table corresponds to one generation of one field. The user defined fields that are in use, and earlier versions of user defined fields. ColumnId refers to the field type; see UDXXXSmall or UDXXXLarge for the referring ID. Preferences prefsection='System', prefkey='CurrentUdefVersioncontact' (or CurrentUdefVersionperson, project, sale), gives you the current version of user defined fields. prefkey='AdminUdefVersion\<...>' gives you the current version that's being edited. If Current version = admin version, no editing has been done since the last Publish of user defined field was performed. | | [UserPreference](./userpreference) | Preference system. If deflevel is set to 5; the user may change the preferences | ## Replication Flags * Area Management controlled table. Contents replicated to satellites and traveller databases. * Replicate changes UP from satellites and travellers back to central. * Copy to satellite and travel prototypes. ## Security Flags * Sentry controls access to items in this table using user's Role and data rights matrix on the table's parent. ## Related topics - [LocaleText table](/en/database/tables/localetext.md) - [relationdefinition table](/en/database/tables/relationdefinition.md) - [relationtarget table](/en/database/tables/relationtarget.md) - [relations table](/en/database/tables/relations.md) - [freetextindex table](/en/database/tables/freetextindex.md) - [freetextwords table](/en/database/tables/freetextwords.md)