MKT_SEM_CONNECTION_PW
This table will be used to store SEM Connection Password. This is an extension of Connections table. The password data stored in this table will be encrypted.
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: USERS
Primary Key
| Name | Columns |
|---|---|
|
MKT_SEM_CONNECTION_PW_PK |
CONNECTIONID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONNECTIONID | NUMBER | 18 | Yes | Connection Id | |
| CLIENT_ACCOUNT_PW | VARCHAR2 | 1000 | Client Account Password | ||
| MASTER_ACCOUNT_PW | VARCHAR2 | 1000 | Master Account Password |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| MKT_SEM_CONNECTION_PW | mkt_sem_connections | CONNECTIONID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MKT_SEM_CONN_PW_PK1 | Unique | Default | CONNECTIONID |