Table HLPDTEST.STATEGPS.T_GPS_PHONE_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
PHONE_CONTACT_ID number 22
PHONE_NUMBER varchar2 20
LOCAL_FORMAT varchar2 20  √  null
INTERNATIONAL_FORMAT varchar2 20
COUNTRY_PREFIX varchar2 20  √  null
COUNTRY_CODE varchar2 20
COUNTRY_NAME varchar2 255  √  null
LOCATION varchar2 255  √  null
CARRIER varchar2 255  √  null
LINE_TYPE varchar2 255  √  null
IS_VALID varchar2 20
CREATED_BY varchar2 255
CREATED_DATE timestamp(6) 11,6

Table contained 0 rows at Fri Aug 14 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
PHONE_CONTACT_ID Primary key Asc PK_T_GPS_PHONE_CONTACT
INTERNATIONAL_FORMAT Must be unique Asc UQ_PHONE_CNT_INTL_FORMAT