Table: JTF_UM_SUBSCRIPTIONS_B

Product:	JTF - CRM Foundation
Description:	An enrollment usually gives access to some specific part of the system through roles, permissions, and the responsibility defined for the enrollment.
Implementation/DBA Data:	JTF.JTF_UM_SUBSCRIPTIONS_B

Primary Key: JTF_UM_SUBSCRIPTIONS_B_PK

1. SUBSCRIPTION_ID

Primary Key: JTF_UM_SUBSCRIPTIONS_B_U1

1. SUBSCRIPTION_KEY
2. EFFECTIVE_START_DATE

Foreign Keys

Table		Foreign Table	Foreign Key Column
JTF_UM_SUBSCRIPTIONS_B		JTF_AUTH_PRINCIPALS_B	JTF_UM_SUBSCRIPTIONS_B.AUTH_DELEGATION_ROLE_ID
JTF_UM_SUBSCRIPTIONS_TL		JTF_UM_SUBSCRIPTIONS_B	JTF_UM_SUBSCRIPTIONS_TL.SUBSCRIPTION_ID
JTF_UM_SUBSCRIPTION_REG		JTF_UM_SUBSCRIPTIONS_B	JTF_UM_SUBSCRIPTION_REG.SUBSCRIPTION_ID
JTF_UM_SUBSCRIPTION_RESP		JTF_UM_SUBSCRIPTIONS_B	JTF_UM_SUBSCRIPTION_RESP.SUBSCRIPTION_ID
JTF_UM_SUBSCRIPTION_ROLE		JTF_UM_SUBSCRIPTIONS_B	JTF_UM_SUBSCRIPTION_ROLE.SUBSCRIPTION_ID
JTF_UM_SUBSCRIPTION_TMPL		JTF_UM_SUBSCRIPTIONS_B	JTF_UM_SUBSCRIPTION_TMPL.SUBSCRIPTION_ID
JTF_UM_USERTYPE_SUBSCRIP		JTF_UM_SUBSCRIPTIONS_B	JTF_UM_USERTYPE_SUBSCRIP.SUBSCRIPTION_ID