Table HLPDTEST.STATEGPS.T_CUSTOMERS 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
CUSTOMER_ID number 22
T_PROJECT_RESOURCE_RATES.CUSTOMER_ID CUSTOMER_ID_FK R
T_SUPPORT_TYPE.CUSTOMER_ID CUST_ID_FK R
CUSTOMER_NAME varchar2 500  √  null
COMPANY_NAME varchar2 500  √  null
BILLING_ADDR varchar2 2000  √  null
CONTANCT_PERSON varchar2 500  √  null
TERMS varchar2 100  √  null
CONTANCT_NUMBER varchar2 100  √  null
EMAIL_ID varchar2 100  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
CUSTOMER_ID Primary key Asc SYS_C009976

Close relationships: