...
Column | Description |
|---|---|
table_schema | Name of the database schema in which the table is located. |
table_name | Name of the table to be published |
pk_column | Name of a column used to form the feature IDs |
pk_column_idx | Index of the column in a multi-column key. In case multi column keys are needed multiple records with the same table schema and table name will be used. |
pk_policy | The new value generation policy, used in case a new feature needs to be added in the table ('assigned', 'sequence' or 'autogenerated'). |
pk_sequence | The name of the database sequence to be used when generating a new value for the pk_column. |
Using primary key metadata configuration
You can also specify the above information directly in the spatial engin configuration.
| Name | Description |
|---|---|
| name | The table name |
| schema | The optional table schema |
| column | The column in the the table that contains the unique id |
| policy | How the key is generated |
| sequence | The name of the database sequence to use if the policy is 'sequence' |
| Code Block |
|---|
<spatial:spatialengine id="sqlserver">
<dbtype>sqlserver</dbtype>
<host>sqlhost</host>
<port>1434</port>
<user>gis</user>
<passwd>hak0rz</passwd>
<schema>GIS</schema>
<minconnection>2</minconnections>
<validateconnections>true</validateconnections>
<primarykeymetadata>
<table schema="dbo" name="park" column="gid" policy="autogenerated"/>
<table schema="dbo" name="property" column="park_id" type="autogenerated"/>
<table schema="dbo" name="road" column="objectid" type="autogenerated"/>
</primarykeymetadata>
</spatial:spatialengine> |
Using the geometry metadata table
...