SchemaSpy - Table slot9.WORLD.TSTA.EVIDENCE_LABELS

Custom printed evidence labels

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

LABEL_ID

number

38

EVIDENCE_LABEL_ROWS.LABEL_ID

EVIDLBLRW_EVIDLBL_FK C

AGENCY_CODE

varchar2

30

√

null

AGENCY_CODES.AGENCY_CODE

EVIDLBL_AGNCY_CD_FK C

DESCRIPTION

varchar2

255

√

null

WIDTH_INCHES

number

35,3

HEIGHT_INCHES

number

35,3

LABEL_FONT_SIZE

number

38

VALUE_FONT_SIZE

number

38

BARCODE_FLAG

varchar2

1

√

'N'

DEFAULT_FLAG

varchar2

1

√

'N'

ACTIVE_FLAG

varchar2

1

√

'Y'

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

7

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

7

√

null

CELL_PADDING

number

38

√

0

TYPE_CODE

varchar2

30

EJS_CODES.CODE

EVIDLBL_EJSCD_TYPCD_FK R

TYPE_CODE_TYPE

varchar2

30

'LABEL_TYPE_CODES'

EJS_CODES.CODE_TYPE

EVIDLBL_EJSCD_TYPCD_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"HEIGHT_INCHES" IS NOT NULL	EVIDLBL_HEIGHT_NN
"LABEL_ID" IS NOT NULL	EVIDLBL_LABEL_ID_NN
"LABEL_FONT_SIZE" IS NOT NULL	EVIDLBL_LBL_FNT_NN
"TYPE_CODE" IS NOT NULL	EVIDLBL_TYP_CD_NN
"TYPE_CODE_TYPE" IS NOT NULL	EVIDLBL_TYP_CD_TYP_NN
"VALUE_FONT_SIZE" IS NOT NULL	EVIDLBL_VL_FNT_NN
"WIDTH_INCHES" IS NOT NULL	EVIDLBL_WIDTH_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
LABEL_ID	Primary key	Asc	EVIDLBL_PK
AGENCY_CODE	Performance	Asc	EVIDLBL_AGNCY_CD_FK_I
TYPE_CODE_TYPE + TYPE_CODE	Performance	Asc/Asc	EVIDLBL_EJSCD_TYPCD_FK_I