# PostgreSQL and i-Reporter linkage item mapping table

## 1. PostgreSQL->i-Reporter linkage

PostgreSQL field type	i-Reporter cluster type
・character	・Keyboard（Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Text by handwriting ・Check ・Single choice ・Multiple choice
・character varying ・text	・Keyboard（Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Text by handwriting ・Check ・Single choice ・Multiple choice ・Barcode（Only without check "Value is numerical number"）・Barcode reader ・Select master
・bigint ・bigserial ・integer ・smallint ・serial ・decimal ・numeric ・double precision ・real ・money	・Keyboard 　* The automatic numbering mode is not supported. ・Text by handwriting ・Choice of Numerical number ・Numerical number keyboard ・Number of hours ・Check ・Single choice ・Multiple choice ・Barcode ・Barcode reader ・Select master
・date ・timestamp	・Keyboard（Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Text by handwriting ・Date ・Calender
・bit ・bit varying ・time [ without time zone ] ・time [ with time zone ] ・boolean ・box ・bytea ・cidr ・circle ・inet ・interval ・line ・lseg ・macaddr ・path ・point ・polygon ・tsquery ・tsvector ・txid_snapshot ・uuid ・xml	Unsupported

PostgreSQL field type

i-Reporter cluster type

・character

・Keyboard（Only None and Alphanumeric)
　* The automatic numbering mode is not supported.

・Text by handwriting

・Check

・Single choice

・Multiple choice

・character varying

・text

・Keyboard（Only None and Alphanumeric)
　* The automatic numbering mode is not supported.

・Text by handwriting

・Check

・Single choice

・Multiple choice

・Barcode（Only without check "Value is numerical number"）

・Barcode reader

・Select master

・bigint

・bigserial

・integer

・smallint

・serial

・decimal

・numeric

・double precision

・real

・money

・Keyboard
　* The automatic numbering mode is not supported.

・Text by handwriting

・Choice of Numerical number

・Numerical number keyboard

・Number of hours

・Check

・Single choice

・Multiple choice

・Barcode

・Barcode reader

・Select master

・date

・timestamp

・Keyboard（Only None and Alphanumeric)
　* The automatic numbering mode is not supported.

・Text by handwriting

・Date

・Calender

・bit

・bit varying

・time [ without time zone ]

・time [ with time zone ]

・boolean

・box

・bytea

・cidr

・circle

・inet

・interval

・line

・lseg

・macaddr

・path

・point

・polygon

・tsquery

・tsvector

・txid_snapshot

・uuid

・xml

Unsupported

## 2. i-Reporter→PostgreSQL linkage | i-Reporter cluster type | PostgreSQL field type | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |

・Keyboard（Only None and Alphanumeric)
　\* The automatic numbering mode is not supported.

・Text by handwriting

・Check

・Single choice

・Multiple choice

| ・character | |

・Keyboard（Only None and Alphanumeric)
　\* The automatic numbering mode is not supported.

・Text by handwriting

・Check

・Single choice

・Multiple choice

・Barcode（Only without check "Value is numerical number"）

・Barcode reader

・Select master

・character varying

・text

| |

・Keyboard（Only None and Alphanumeric)
　\* The automatic numbering mode is not supported.

・Choice of Numerical number

・Numerical number keyboard

・Number of hours

・Barcode

・bigint

・bigserial

・integer

・smallint

・serial

・decimal

・numeric

・double precision

・real

・money

| |

・Date

・Calender

・date

・timestamp

| | Unsupported |

・bit

・bit varying

・time \[ without time zone ]

・time \[ with time zone ]

・boolean

・box

・bytea

・cidr

・circle

・inet

・interval

・line

・lseg

・macaddr

・path

・point

・polygon

・tsquery

・tsvector

・txid\_snapshot

・uuid

・xml

| ## 3. PostgreSQL->ConMas Gateway real-time linkage

PostgreSQL field type	i-Reporter cluster type
・character	・Keyboard（Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Single choice (Only get data menu)
・character varying ・text	・Keyboard (Only None and Alphanumeric) 　* The automatic numbering mode is not supported. ・Single choice (Only get data menu) ・Barcode (Only without check "Value is numerical number", Only get data menu) ・Select master
・bigint ・bigserial ・integer ・smallint ・serial ・decimal ・numeric ・double precision ・real ・money	・Keyboard (Only get data menu) 　* The automatic numbering mode is not supported. ・Numerical number keyboard ・Check (Only get data menu) ・Single choice (Only get data menu) ・Barcode (Only get data menu) ・Select master
・date ・timestamp	Plan to support with it in the future
・bit ・bit varying ・time [ without time zone ] ・time [ with time zone ] ・boolean ・box ・bytea ・cidr ・circle ・inet ・interval ・line ・lseg ・macaddr ・path ・point ・polygon ・tsquery ・tsvector ・txid_snapshot ・uuid ・xml	Unsupported

PostgreSQL field type

i-Reporter cluster type

・character

・Keyboard（Only None and Alphanumeric)
　* The automatic numbering mode is not supported.

・Single choice (Only get data menu)

・character varying

・text

・Keyboard (Only None and Alphanumeric)
　* The automatic numbering mode is not supported.

・Single choice (Only get data menu)

・Barcode (Only without check "Value is numerical number", Only get data menu)

・Select master

・bigint

・bigserial

・integer

・smallint

・serial

・decimal

・numeric

・double precision

・real

・money

・Keyboard (Only get data menu)

　* The automatic numbering mode is not supported.

・Numerical number keyboard

・Check (Only get data menu)

・Single choice (Only get data menu)

・Barcode (Only get data menu)

・Select master

・date

・timestamp

Plan to support with it in the future

・bit

・bit varying

・time [ without time zone ]

・time [ with time zone ]

・boolean

・box

・bytea

・cidr

・circle

・inet

・interval

・line

・lseg

・macaddr

・path

・point

・polygon

・tsquery

・tsvector

・txid_snapshot

・uuid

・xml

Unsupported

--- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://cimtops.gitbook.io/i-repo-link-manual/english/data-source-linkage-all-databases-common/common/postgresql-and-i-reporter-linkage-item-mapping-table.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.