Bitrix Site Manager

Structure of the information blocks tables

Fields

Types of information blocks

FieldDescription Type Required Default
ID Unique ID of an information block type. String(50) Yes  
SECTIONS Flag (Y or N). Specifies whether this block contain sections. Required. Char(1) Yes Y
EDIT_FILE_BEFORE Full path to the element field array file handler called before an element is saved from the element editing page. String(255)    
EDIT_FILE_AFTER Full path to the element editing user interface file handler. String(255)    
IN_RSS Denotes that blocks of this type can be exported to RSS (Y|N). Char(1)   N
SORT Type sort order. Int   500

Language-dependent parameters of an information block type

FieldDescription Type Required Default
IBLOCK_TYPE_ID Block type ID. String(50) Yes  
LID ID of the parameters language. Char(2) Yes  
NAME Name of an information block type. String(100) Yes  
SECTION_NAME Name of the information block sections (if present). String(100) No  
ELEMENT_NAME Name of the information block elements. String(100) No  

Information Blocks

FieldDescription Type Required Default
ID Information block ID. Int Yes
CODE Mnemonic identifier (alias). String(50) No
EXTERNAL_ID External ID. String(255) No
IBLOCK_TYPE_ID Information block type ID. String(50) Yes
TIMESTAMP_X Date of the last modification of the block parameters. Datatime Yes Current
NAME Name. Int Yes
ACTIVE Active state flag (Y|N). Char(1) Yes Y
SORT Sort weight. Int Yes 500
LIST_PAGE_URL Template of the page URL used for the block elements public view. String(255) No
SECTION_PAGE_URL Template of the page URL used to view the block section. String(255) No
DETAIL_PAGE_URL Template of the page URL used for the element detailed view. String(255) No
PICTURE Picture ID in the file table. Int No
DESCRIPTION Description. Text No
DESCRIPTION_TYPE Description type (text/html) Char(4) Yes Text
RSS_ACTIVE Allows the dynamic export to RSS (Y|N) Char(1) Yes Y
RSS_TTL RSS time to live and interval between each build of an RSS file, in hours (requires RSS_FILE_ACTIVE or RSS_YANDEX_ACTIVE to be set) Int Yes 24
RSS_FILE_ACTIVE Export RSS to a file. Char(1) Yes N
RSS_FILE_LIMIT Number of elements exported to an RSS file (requires RSS_FILE_ACTIVE) Int No
RSS_FILE_DAYS Number of days to export to an RSS file (requires RSS_FILE_ACTIVE). -1 means no day limit. Int No
INDEX_ELEMENT Specifies the information block elements should be indexed for searching. Char(1) Yes Y
INDEX_SECTION Specifies the information block sections should be indexed for searching. Char(1) Yes N

Information Blocks Sections

FieldDescription Type Required Default
ID Section ID. Int Yes
CODE Mnemonic identifier (alias). String(255) No
EXTERNAL_ID External ID. String(255) No
IBLOCK_ID Information block ID. Int Yes
IBLOCK_SECTION_ID Parent section ID. Void for root sections. Int No
TIMESTAMP_X Date of the last modification. Datetime Yes Current
SORT Sort order (among sections within one parent group). Int Yes 500
NAME Section name. String(255) Yes
ACTIVE Active state flag (Y|N). Char(1) Yes Y
GLOBAL_ACTIVE Active state flag with respect to the state of parent groups. Read-only. Char(1) - -
PICTURE Picture ID in the file table. Int No
DESCRIPTION Description of a section. Text No
DESCRIPTION_TYPE Description type (text/html). Char(4) Yes Text
LEFT_MARGIN Left margin of a section. Calculated automatically. Read-only. Int - -
RIGHT_MARGIN Right margin of a section. Calculated automatically. Read-only. Int - -
DEPTH_LEVEL Section nesting level. Calculated automatically. Read-only. Int - -
SEARCHABLE_CONTENT Data used for search operations when filtering sections. Calculated automatically. Composed of the fields NAME and DESCRIPTION (latter without the HTML tags). Text - -
SECTION_PAGE_URL Template of the page URL used for the detailed view of the section. Defined by the information block parameters. Modified automatically. String(255)

Elements

FieldDescription Type Required Default
ID Element ID. Int Yes
CODE Mnemonic identifier (alias). String(255) No
EXTERNAL_ID External ID. String(255) No
NAME Element name. String(255) Yes
IBLOCK_ID Information block ID. Int Yes
IBLOCK_SECTION_ID Section ID. Void if the element does not belong to section. If the element belongs to more than one section, this field contains the ID of one of the sections. Int No
ACTIVE Active state flag (Y|N). Char(1) Yes Y
DATE_ACTIVE_FROM Date the element is active from. Datetime No
DATE_ACTIVE_TO Expiry date of the element. Datetime No
SORT Sort weight of an element within one parent section. Int Yes 500
PREVIEW_PICTURE Thumbnail picture ID in the file table. Int No
PREVIEW_TEXT Short description text (announcement). Text No
PREVIEW_TEXT_TYPE Type of the short description text (text/html). Char(4) Yes Text
DETAIL_PICTURE Detailed picture ID in the file table. Int No
DETAIL_TEXT Full  text of the element contents. Text No
DETAIL_TEXT_TYPE Type of the full text (text/html). Char(4) Yes Text
SEARCHABLE_CONTENT Data used for search operations when filtering sections. Calculated automatically. Composed of the fields NAME and DESCRIPTION (the latter without the HTML tags). Text - -
EXTERNAL_ID External ID. String(255) No  
DATE_CREATE Date of the element creation. Datetime Yes Current
CREATED_BY ID of a user who created the element. Int Yes Current user
CREATED_USER_NAME Name of a user who created the element. Read-only.
TIMESTAMP_X Date of the last element modification. Datetime Yes Current
MODIFIED_BY ID of a user who modified the element the last time. Int Yes Current user
USER_NAME Name of a user who modified the element the last time. Read-only.
LANG_DIR Path to the site folder. Inferred from the information block parameters. Modified automatically. String(255) - -
LIST_PAGE_URL Template of the page URL used for the public view of the information block elements. Inferred from the information block parameters. Modified automatically. String(255) - -
DETAIL_PAGE_URL Template of the page URL used for the detailed view of the information block elements. Inferred from the information block parameters. Modified automatically. String(255) - -
SHOW_COUNTER Number of the element shows. Changed upon each call of the function CIBlockElement::CounterInc. Int No
SHOW_COUNTER_START Date of the first show of the element. Changed upon each call of the function CIBlockElement::CounterInc. Datetime No
WF_COMMENTS Comment of the workflow administrator. Text No
WF_STATUS_ID ID of the element status in the workflow. Int Yes 1
LOCK_STATUS Current lock state of the element. Can have the following values:
  • red - locked;
  • greed - available for editing;
  • yellow - locked by the current user.
String -

Properties

FieldDescription Type Required Default
ID Property ID. Int Yes  
CODE Property mnemonic code (alias). String(50) No  
EXTERNAL_ID External ID of a property. Int No 100
IBLOCK_ID ID of an information block. Int Yes  
NAME Name of a property. String(100) Yes  
ACTIVE Property active state flag (Y|N). Char(1) Yes Y
SORT Sort weight. Int Yes 500
PROPERTY_TYPE Property type. Possible values: S - string, F - file, L - list. Char(1) Yes S
MULTIPLE Indicates the multiple property set. Char(1) Yes N
TIMESTAMP_X Date of the last property modification. Datetime Yes Current
DEFAULT_VALUE Default value of a property (except type L). String(255) No  
ROW_COUNT Number of rows in the input field. Int Yes 1
COL_COUNT Number of columns in the input field. Int Yes 30
LIST_TYPE Type of the list type (L). Can be "L" (drop-down list) or "C" (check boxes). Char(1) Yes L
MULTIPLE_CNT Number of rows in the drop-down list for properties of the LIST type. Int No  
FILE_TYPE Comma-separated list of acceptable file extensions for properties of the type FILE. Char(200) No
SEARCHABLE Specifies the property value should be indexed. Char(1) Yes N
FILTRABLE Specifies the fields for filtering by this property should be displayed int he administrative section. Char(1) Yes N

Possible values for properties of the type LIST

FieldDescription Type Required Default
ID Value ID. int Yes  
PROPERTY_ID Property ID. int Yes  
VALUE Value of the property. string(255) Yes  
DEF Denotes this value is default (Y|N). char(1) No N
SORT Sort weight of the variant. int No 500
EXTERNAL_ID External ID of the property variant. string(200) No  

Property values

FieldDescription Type Required Default
ID ID of a value. Yes  
IBLOCK_PROPERTY_ID Property ID. Yes  
IBLOCK_ELEMENT_ID Element ID. Yes  
VALUE Value itself. Yes  
VALUE_TYPE Type of a value (text/html). Yes