SchemaSpy - Table rice-2.1.1.krim_role_mbr

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

ROLE_MBR_ID

varchar

krim_dlgn_mbr_t.ROLE_MBR_ID	Implied Constraint R
krim_pnd_dlgn_mbr_t.ROLE_MBR_ID	Implied Constraint R
krim_pnd_role_mbr_attr_data_mt.ROLE_MBR_ID	Implied Constraint R
krim_pnd_role_mbr_mt.ROLE_MBR_ID	Implied Constraint R
krim_pnd_role_rsp_actn_mt.ROLE_MBR_ID	Implied Constraint R
krim_role_grp_v.ROLE_MBR_ID	Implied Constraint R
krim_role_mbr_attr_data_t.ROLE_MBR_ID	Implied Constraint R
krim_role_prncpl_v.ROLE_MBR_ID	Implied Constraint R
krim_role_role_v.role_mbr_id	Implied Constraint R
krim_role_rsp_actn_t.ROLE_MBR_ID	Implied Constraint R
krim_rsp_role_actn_v.ROLE_MBR_ID	Implied Constraint R

VER_NBR

decimal

OBJ_ID

varchar

ROLE_ID

varchar

krim_role_t.ROLE_ID

KRIM_ROLE_MBR_TR1 C

MBR_ID

varchar

MBR_TYP_CD

char

ACTV_FRM_DT

datetime

√

null

ACTV_TO_DT

datetime

√

null

LAST_UPDT_DT

datetime

√

null

Table contained 3 rows at Tue Sep 18 22:24 PDT 2012

Indexes:

Column(s)	Type	Sort	Constraint Name
ROLE_MBR_ID	Primary key	Asc	PRIMARY
OBJ_ID	Must be unique	Asc	KRIM_ROLE_MBR_TC0
MBR_ID	Performance	Asc	KRIM_ROLE_MBR_TI1
ROLE_ID + MBR_ID + MBR_TYP_CD	Performance	Asc/Asc/Asc	KRIM_ROLE_MBR_TI2
MBR_ID + MBR_TYP_CD	Performance	Asc/Asc	KRIM_ROLE_MBR_TI3