search_simpledb_index

0 rows


Description

search_simpledb table containing the index data.

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 ConstraintR
areaid VARCHAR 255
type BIT 1 null
courseid BIGINT 19 null
course.id Implied ConstraintR
owneruserid BIGINT 19 null
modified BIGINT 19 null
userid BIGINT 19 null
description1 LONGTEXT 2147483647 null
description2 LONGTEXT 2147483647 null

Indexes

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

Relationships