SchemaSpy - Table lawprod.MSCM.ATTRIBUTE

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

ATTRIBUTE_ID

number

22

OBJECT_TYPE_ID

number

22

OBJECT_TYPE.OBJECT_TYPE_ID

OBJ_TYPE_ID_FK R

OBJECT_ID

number

22

ATTRIBUTE_TYPE_ID

number

22

ATTRIBUTE_TYPE.ATTRIBUTE_TYPE_ID

ATTRIB_TYPE_ID_FK R

STRING_VALUE

varchar2

1000

√

null

INT_VALUE

number

22

√

null

BOOLEAN_VALUE

char

1

√

null

FLOAT_VALUE

number

13,4

√

null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
ATTRIBUTE_ID	Primary key	Asc	ATTRIB_ID
OBJECT_TYPE_ID + OBJECT_ID + ATTRIBUTE_TYPE_ID	Must be unique	Asc/Asc/Asc	ATTRIBUTE_UK