Search Simpledb Index Table Schema (search_simpledb_index)


Description

search_simpledb table containing the index data.

search_simpledb_index table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
docid VARCHAR 255
itemid BIGINT 19 null
title LONGTEXT 2147483647 √ null
content LONGTEXT 2147483647 √ null
contextid BIGINT 19 null
context.id Implied Constraint R
areaid VARCHAR 255
type BIT 1 null
courseid BIGINT 19 null
course.id Implied Constraint R
owneruserid BIGINT 19 √ null
modified BIGINT 19 null
userid BIGINT 19 √ null
user.id Implied Constraint R
description1 LONGTEXT 2147483647 √ null
description2 LONGTEXT 2147483647 √ null

Table contained -1 rows

search_simpledb_index table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
searsimpinde_doc_uix Must be unique Asc docid
searsimpinde_owncon_ix Performance Asc/Asc owneruserid + contextid

search_simpledb_index table relationships

Close relationships within degrees of separation