SchemaSpy - Table slot9.WORLD.TSTA.K9_MISC_IDS

This table is not currently used

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

K9_ID

number

0

K9_DOGS.K9_ID

K9MISCK9_ID_FK C

ID_NUMBER

varchar2

30

STATE_CODE

varchar2

30

√

null

EJS_CODES.CODE

K9MISC_STATE_CODE_EJS_CODE_FK R

COUNTRY_TYPE_CODE

varchar2

30

√

null

EJS_CODES.CODE

K9MISC_COUNTRY_TYP_EJS_CODE_FK R

MISC_ID_CODE

varchar2

2

MISC_ID_CODES.MISC_ID_CODE

K9MISC_MISC_CD_FK R

DATE_OF_ISSUE

date

7

√

null

CREATOR_DATE

date

7

√

null

CREATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

EXPIRATION

date

7

√

null

MISC_ID_TYPE

varchar2

30

√

null

EJS_CODES.CODE

K9MISC_MISC_ID_TYP_EJS_CODE_FK R

MISC_ID_CNTR

number

38

COUNTRY_TYPE_CODE_TYPE

varchar2

30

√

null

EJS_CODES.CODE_TYPE

K9MISC_COUNTRY_TYP_EJS_CODE_FK R

MISC_ID_TYPE_TYPE

varchar2

30

√

null

EJS_CODES.CODE_TYPE

K9MISC_MISC_ID_TYP_EJS_CODE_FK R

STATE_CODE_TYPE

varchar2

30

√

null

EJS_CODES.CODE_TYPE

K9MISC_STATE_CODE_EJS_CODE_FK R

REC_ID

number

0

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"ID_NUMBER" IS NOT NULL	K9MISC_ID_NUMBER_NN
"K9_ID" IS NOT NULL	K9MISC_K9_ID_NN
"MISC_ID_CNTR" IS NOT NULL	K9MISC_MISC_ID_CNTR_NN
"MISC_ID_CODE" IS NOT NULL	K9MISC_MISC_ID_CODE_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
K9_ID + MISC_ID_CODE + ID_NUMBER + MISC_ID_CNTR	Primary key	Asc/Asc/Asc/Asc	K9MISC_PK
COUNTRY_TYPE_CODE	Performance	Asc	K9MISC_CNTRY_CD_FK_I
COUNTRY_TYPE_CODE_TYPE + COUNTRY_TYPE_CODE	Performance	Asc/Asc	K9MISC_COUNTRY_TYP_EJS_CODE_I
K9_ID	Performance	Asc	K9MISC_K9_ID_FK_I
MISC_ID_CODE	Performance	Asc	K9MISC_MISC_CD_FK_I
MISC_ID_TYPE_TYPE + MISC_ID_TYPE	Performance	Asc/Asc	K9MISC_MISC_ID_TYP_EJS_CODE_I
MISC_ID_TYPE	Performance	Asc	K9MISC_MITC_CD_FK_I
STATE_CODE	Performance	Asc	K9MISC_STATE_CD_FK_I
STATE_CODE_TYPE + STATE_CODE	Performance	Asc/Asc	K9MISC_STATE_CODE_EJS_CODE_I