SchemaSpy - Table slot9.WORLD.TSTA.STATE_LICENSE

This table defines the license plate formats for each state

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

STATE_CODE

varchar2

EJS_CODES.CODE

SLF_STATE_CODE_EJS_CODE_FK R

FORMAT_CODE

varchar2

EJS_CODES.CODE

SLF_FORMAT_CODE_EJS_CODE_FK R

FORMAT_CODE_TYPE

varchar2

√

'LICENSE_FORMAT_CODES'

EJS_CODES.CODE_TYPE

SLF_FORMAT_CODE_EJS_CODE_FK R

STATE_CODE_TYPE

varchar2

√

'STATE_CODES'

EJS_CODES.CODE_TYPE

SLF_STATE_CODE_EJS_CODE_FK R

REC_ID

number

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"FORMAT_CODE" IS NOT NULL	SLF_FORMAT_CODE_NN
"STATE_CODE" IS NOT NULL	SLF_STATE_CODE_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
STATE_CODE + FORMAT_CODE	Primary key	Asc/Asc	SLF_PK
FORMAT_CODE_TYPE + FORMAT_CODE	Performance	Asc/Asc	SLF_FORMAT_CODE_EJS_CODE_I
FORMAT_CODE	Performance	Asc	SLF_LFC_FK_I
STATE_CODE	Performance	Asc	SLF_STATE_CD_FK_I
STATE_CODE_TYPE + STATE_CODE	Performance	Asc/Asc	SLF_STATE_CODE_EJS_CODE_I