Table HLPDTEST.STATEGPS.T_GPS_EMAIL_CONTACT Generated by
SchemaSpy
Legend: SourceForge.net
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
EMAIL_CONTACT_ID number 22
EMAIL varchar2 255
EMAIL_USER varchar2 255  √  null
DOMAIN varchar2 255  √  null
FORMAT_VALID varchar2 20  √  null
SMTP_CHECK varchar2 20
MX_FOUND varchar2 20  √  null
DID_YOU_MEAN varchar2 20  √  null
ROLE varchar2 20  √  null
DISPOSABLE varchar2 20  √  null
FREE varchar2 20  √  null
SCORE number 22  √  null
CATCH_ALL varchar2 255  √  null
CREATED_BY varchar2 255
CREATED_DATE timestamp(6) 11,6

Table contained 0 rows at Tue Aug 11 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
EMAIL_CONTACT_ID Primary key Asc PK_T_GPS_EMAIL_CONTACT
EMAIL Must be unique Asc UQ_EMAIL