SchemaSpy - Table slot9.WORLD.TSTA.INCIDENT_SUPPLEMENT_MARIJ

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

INCSUP_MARIJ_ID

number

38

INCIDENT_ID

number

38

INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID

INCSUPMJ_INCSUP_FK R

Incident ID number assigned

SUPP_SEQ

number

38

INCIDENT_SUPPLEMENTS.SUPP_SEQ

INCSUPMJ_INCSUP_FK R

Supplement Sequence Number 1 = Original Report

MARIJ_SEIZED_CODE

varchar2

30

EJS_CODES.CODE

INCSUPMJ_MARIJSZ_EJS_CODE_FK R

Marijuana Fields and Gardens Seized

MARIJ_SEIZED_CD_TYPE

varchar2

30

'MARIJ_SEIZED_CODES'

EJS_CODES.CODE_TYPE

INCSUPMJ_MARIJSZ_EJS_CODE_FK R

Marijuana Fields and Gardens Seized

NUM_MARIJ_SEIZED_CODE

varchar2

30

√

null

EJS_CODES.CODE

INCSUPMJ_NMARIJSZ_EJS_CD_FK R

Number Marijuana Fields and Gardens

NUM_MARIJ_SEIZED_CD_TYPE

varchar2

30

√

null

EJS_CODES.CODE_TYPE

INCSUPMJ_NMARIJSZ_EJS_CD_FK R

Number Marijuana Fields and Gardens

CREATOR_ID

varchar2

100

√

null

Domain to store an Oracle USER ID

CREATOR_DATE

date

7

√

null

Date Record was created

UPDATOR_ID

varchar2

100

√

null

Domain to store an Oracle USER ID

UPDATOR_DATE

date

7

√

null

Date Record was last updated

REC_ID

number

0

√

null

Sequence used to uniquely identify this record.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"INCIDENT_ID" IS NOT NULL	INCSUPMJ_INCIDENT_ID_NN
"INCSUP_MARIJ_ID" IS NOT NULL	INCSUPMJ_INCSUP_MARIJ_ID_NN
"MARIJ_SEIZED_CODE" IS NOT NULL	INCSUPMJ_MARIJ_SEIZED_CD_NN
"MARIJ_SEIZED_CD_TYPE" IS NOT NULL	INCSUPMJ_MARIJ_SEIZED_TYPE_NN
"SUPP_SEQ" IS NOT NULL	INCSUPMJ_SUPP_SEQ_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
INCSUP_MARIJ_ID	Primary key	Asc	INCSUPMJ_PK
INCIDENT_ID + SUPP_SEQ	Performance	Asc/Asc	INCSUPMJ_INCSUP_FK_I
MARIJ_SEIZED_CD_TYPE + MARIJ_SEIZED_CODE	Performance	Asc/Asc	INCSUPMJ_MARIJSZ_EJS_CODE_FK_I
NUM_MARIJ_SEIZED_CD_TYPE + NUM_MARIJ_SEIZED_CODE	Performance	Asc/Asc	INCSUPMJ_NMARIJSZ_EJS_CD_FK_I