KCRT_FG_SERVICE

This table stores service.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

REQUEST_TYPE_ID

KNTA_SERVICES_NLS

SERVICE_ID

SERVICE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

REQUEST_ID

NOT NULL

NUMBER

System-generated identifier

REQUEST_TYPE_ID

NOT NULL

NUMBER

Request type ID

SERVICE_ID

NULLABLE

VARCHAR2(40)

Service ID

SERVICE_NAME

NULLABLE

VARCHAR2(255)

Service name

Indexes

Index Name

Index Type

Sequence

Column Name

KCRT_FG_SERVICE_U1

UNIQUE

1

REQUEST_ID

Sequences

This table uses no sequences.