pears.IXSSearchDefinition [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.IXSSearchDefinition ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Description =====
Definitions of the types of text searches available using Index Server.

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **ID** | char(20) | NOT NULL |  |  |
| Catalog | char(100) | NULL |  | e.g. query://machinename/System |
| Scope | char(250) | NULL |  | Directory from point of view of Index Server - blank for entire catalog |
| Directory | char(250) | NULL |  | Directory from point of view of Database Server |
| Command | char(250) | NULL |  | Full pathname of search daemon invoked by Database Server |
| DSN | char(50) | NULL |  | For daemon login to this database |
| UID | char(20) | NULL |  | For daemon login to this database |

===== Primary Key =====
  * ID

===== Foreign Keys =====
  * No outgoing foreign keys found.

===== Referenced By =====
  * No incoming foreign keys found.

===== Indexes =====
  * No indexes found.

===== Triggers =====
  * No triggers found.

===== Original SQL =====
<code sql>
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IXSSearchDefinition"
-- Table comment: Definitions of the types of text searches available using Index Server.
-- Statement count: 8

CREATE TABLE "pears"."IXSSearchDefinition" (
    "ID"                             char(20) NOT NULL
   ,"Catalog"                        char(100) NULL
   ,"Scope"                          char(250) NULL
   ,"Directory"                      char(250) NULL
   ,"Command"                        char(250) NULL
   ,"DSN"                            char(50) NULL
   ,"UID"                            char(20) NULL
   ,PRIMARY KEY ("ID" ASC) 
)
go


COMMENT ON COLUMN "pears"."IXSSearchDefinition"."Catalog" IS 
	'e.g. query://machinename/System'
go


COMMENT ON COLUMN "pears"."IXSSearchDefinition"."Scope" IS 
	'Directory from point of view of Index Server - blank for entire catalog'
go


COMMENT ON COLUMN "pears"."IXSSearchDefinition"."Directory" IS 
	'Directory from point of view of Database Server'
go


COMMENT ON COLUMN "pears"."IXSSearchDefinition"."Command" IS 
	'Full pathname of search daemon invoked by Database Server'
go


COMMENT ON COLUMN "pears"."IXSSearchDefinition"."DSN" IS 
	'For daemon login to this database'
go


COMMENT ON COLUMN "pears"."IXSSearchDefinition"."UID" IS 
	'For daemon login to this database'
go


COMMENT ON TABLE "pears"."IXSSearchDefinition" IS 
	'Definitions of the types of text searches available using Index Server.'
go
</code>