SchemaSpy - Table rice-2.1.1.krim_role_perm_t

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_PERM_ID

varchar

40

krim_pnd_role_perm_t.ROLE_PERM_ID

Implied Constraint R

OBJ_ID

varchar

36

VER_NBR

decimal

8

1

ROLE_ID

varchar

40

krim_role_t.ROLE_ID

Implied Constraint R

PERM_ID

varchar

40

krim_perm_t.PERM_ID

KRIM_ROLE_PERM_TR1 R

ACTV_IND

varchar

1

√

Y

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

Indexes:

Column(s)	Type	Sort	Constraint Name
ROLE_PERM_ID	Primary key	Asc	PRIMARY
OBJ_ID	Must be unique	Asc	KRIM_ROLE_PERM_TC0
PERM_ID	Performance	Asc	KRIM_ROLE_PERM_TI1
PERM_ID + ACTV_IND	Performance	Asc/Asc	KRIM_ROLE_PERM_TI2