SchemaSpy - Table slot9.WORLD.TSTA.K9_ACTIVITY

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_ACTIVITY_ID

number

0

K9_ID

number

0

K9_DOGS.K9_ID

K9ACT_K9DOG_FK R

WORK_GROUP

varchar2

5

√

null

EMPLOYEE_ID

number

0

√

null

EMPLOYEES.EJS_EMP_ID

K9ACT_EMP1_FK R

AGENCY_CODE

varchar2

30

√

null

AGENCY_CODES.AGENCY_CODE

K9ACT_AGNCY_CD_FK R

ACTIVITY_CODE

varchar2

30

√

null

EJS_CODES.CODE

K9ACT_ACTIVITY_COD_EJS_CODE_FK R

SEARCH_WARRANT

varchar2

1

√

null

NARRATIVE

varchar2

255

√

null

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

7

√

null

ACTIVITY_CODE_TYPE

varchar2

30

√

null

EJS_CODES.CODE_TYPE

K9ACT_ACTIVITY_COD_EJS_CODE_FK R

REC_ID

number

0

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"K9_ACTIVITY_ID" IS NOT NULL	K9ACT_K9_ACTIVITY_ID_NN
"K9_ID" IS NOT NULL	K9ACT_K9_ID_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
K9_ACTIVITY_ID + K9_ID	Primary key	Asc/Asc	K9ACT_PK
ACTIVITY_CODE	Performance	Asc	K9ACT_ACTC_FK_I
ACTIVITY_CODE_TYPE + ACTIVITY_CODE	Performance	Asc/Asc	K9ACT_ACTIVITY_COD_EJS_CODE_I
AGENCY_CODE	Performance	Asc	K9ACT_AGNCY_CODE_I
EMPLOYEE_ID	Performance	Asc	K9ACT_EMP1_FK_I
K9_ACTIVITY_ID	Performance	Asc	K9ACT_K9ACT_FK_I
K9_ID	Performance	Asc	K9ACT_K9DOG_FK_I