WSRP Producer stores information about the physical WSRP producer like its location, registration context, registration data, its service description, etc.(WSRP - Web Service for Remote Portlets)
| Column Name | Column Datatype | Column Null Option | Column Comment |
| wsrp_prod_id | nvarchar(64) | not null | A unique identifier for producer. It is a generated uuid. |
| wsrp_prod_name | nvarchar(128) | with null | A name of the producer. |
| wsrp_prod_desc | long nvarchar | with null | A description of a producer. |
| markup_interface_url | long nvarchar | with null | Stores markup interface URL. |
| service_desc_interface_url | long nvarchar | with null | Stores service description URL. |
| reg_interface_url | long nvarchar | with null | Stores registration URL. |
| portlet_mgmnt_interface_url | long nvarchar | with null | Stores portlet management URL. |
| service_desc | long nvarchar | with null | Stores service description. |
| reg_required | integer | with null | Flag that denotes whether this producer requires registration. Possible values are 0 (false), 1 (true). This filed is not a boolean because it is not possible to constrain on a Boolean in EJBQL. |
| wsrp_prod_version | integer | with null | Represents the version of entity. Valid values are positive numbers. |
| wsrp_reg_context_id | nvarchar(64) | with null | A unique identifier for registration context. It is a generated uuid. |
| wsrp_reg_data_id | nvarchar(64) | with null | A unique identifier for registration data. It is a generated uuid. |
| portal_instance_id | nvarchar(64) | with null | Id of the portal instance. |
Product Name: Portal r12
Table Type: Table