SchemaSpy - Table slot9.WORLD.TSTA.ARREST_PROPERTIES_AUDIT

This table stores the changes made to ARREST property in the application

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

PROP_AUDIT_ID

number

38

PROPERTIES_AUDIT.PROP_AUDIT_ID

Implied Constraint R

ARREST_PROP_ID

number

38

ARREST_PROPERTIES.ARREST_PROP_ID

ARPA_ARP_FK R

DESCRIPTION

varchar2

1000

√

null

RETURNED_TO

varchar2

100

√

null

RETURNED_DATE

date

7

√

null

SEIZING_OFFICER_ID

number

38

√

null

OFFICERS.OFFICER_ID

ARPA_OFF1_FK R

STATUS_CODE

varchar2

30

√

null

EJS_CODES.CODE

ARPA_EJSCD_STATCD_FK R

STATUS_CODE_TYPE

varchar2

30

√

'ARR_PROP_STATUS_CODES'

EJS_CODES.CODE_TYPE

ARPA_EJSCD_STATCD_FK R

RELEASE_OFFICER_ID

number

38

√

null

OFFICERS.OFFICER_ID

ARPA_OFF_REL_FK R

COMMENTS

varchar2

4000

√

null

RELEASE_SIGNATURE_ID

number

38

√

null

IMAGES.IMAGE_ID

ARPA_IMA_FK R

TYPE_CODE

varchar2

30

√

null

EJS_CODES.CODE

ARPA_EJSCD_TYPECD_FK R

TYPE_CODE_TYPE

varchar2

30

√

'ARR_PROP_TYPE_CODES'

EJS_CODES.CODE_TYPE

ARPA_EJSCD_TYPECD_FK R

DELETE_FLAG

varchar2

1

√

'N'

DELETE_USER_ID

varchar2

100

√

null

DELETE_DATE

date

7

√

null

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

7

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"PROP_AUDIT_ID" IS NOT NULL	ARPA_PROP_AUD_ID_NN
"ARREST_PROP_ID" IS NOT NULL	ARPA_PROP_ID_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
PROP_AUDIT_ID	Primary key	Asc	ARPA_PK
ARREST_PROP_ID	Performance	Asc	ARPA_ARP_FK_I
DELETE_USER_ID	Performance	Asc	ARPA_DEL_USRID_I
STATUS_CODE_TYPE + STATUS_CODE	Performance	Asc/Asc	ARPA_EJSCD_STATCD_FK_I
TYPE_CODE_TYPE + TYPE_CODE	Performance	Asc/Asc	ARPA_EJSCD_TYPECD_FK_I
RELEASE_SIGNATURE_ID	Performance	Asc	ARPA_IMA_FK_I
SEIZING_OFFICER_ID	Performance	Asc	ARPA_OFF1_FK_I
RELEASE_OFFICER_ID	Performance	Asc	ARPA_OFF_REL_FK_I