SchemaSpy - Table slot9.WORLD.TSTA.ARREST_PROPERTIES

This table stores the association to PROPERTIES added to an ARREST 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

ARREST_PROP_ID

number

38

ARREST_PROPERTIES_AUDIT.ARREST_PROP_ID

ARPA_ARP_FK R

ARREST_ID

number

38

ARRESTS.ARREST_ID

ARP_ARR_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

ARP_OFF1_FK R

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

7

√

null

STATUS_CODE

varchar2

30

√

null

EJS_CODES.CODE

ARP_EJSCD_STATCD_FK R

STATUS_CODE_TYPE

varchar2

30

√

'ARR_PROP_STATUS_CODES'

EJS_CODES.CODE_TYPE

ARP_EJSCD_STATCD_FK R

TYPE_CODE

varchar2

30

√

null

EJS_CODES.CODE

ARP_EJSCD_TYPECD_FK R

TYPE_CODE_TYPE

varchar2

30

√

'ARR_PROP_TYPE_CODES'

EJS_CODES.CODE_TYPE

ARP_EJSCD_TYPECD_FK R

RELEASE_OFFICER_ID

number

38

√

null

OFFICERS.OFFICER_ID

ARP_OFF1_REL_FK R

COMMENTS

varchar2

4000

√

null

RELEASE_SIGNATURE_ID

number

38

√

null

IMAGES.IMAGE_ID

ARP_IMA_FK R

DELETE_FLAG

varchar2

1

√

'N'

DELETE_USER_ID

varchar2

100

√

null

IJIS_USER_PROFILES.LOGIN_ID

ARP_IUP_FK R

DELETE_DATE

date

7

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"ARREST_ID" IS NOT NULL	ARP_ARREST_ID_NN
"ARREST_PROP_ID" IS NOT NULL	ARP_PROP_ID_NN
DELETE_FLAG IN ( 'Y' , 'N' )	CK_ARP_DELETE_FLAG

Indexes:

Column(s)	Type	Sort	Constraint Name
ARREST_PROP_ID	Primary key	Asc	ARP_PK
ARREST_ID	Performance	Asc	ARP_ARR_FK_I
STATUS_CODE_TYPE + STATUS_CODE	Performance	Asc/Asc	ARP_EJSCD_STATCD_FK_I
TYPE_CODE_TYPE + TYPE_CODE	Performance	Asc/Asc	ARP_EJSCD_TYPECD_FK_I
RELEASE_SIGNATURE_ID	Performance	Asc	ARP_IMA_FK_I
DELETE_USER_ID	Performance	Asc	ARP_IUP_FK_I
SEIZING_OFFICER_ID	Performance	Asc	ARP_OFF1_FK_I
RELEASE_OFFICER_ID	Performance	Asc	ARP_OFF1_REL_FK_I