ORCLPDB1
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
CUSTOMERS
0
rows
Columns
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
CUSTOMER_ID
NUMBER
0
"OT"."ISEQ$$_73018".nextval
CONTACTS
.CUSTOMER_ID
FK_CONTACTS_CUSTOMERS
C
ORDERS
.CUSTOMER_ID
FK_ORDERS_CUSTOMERS
C
NAME
VARCHAR2
255
null
ADDRESS
VARCHAR2
255
√
null
WEBSITE
VARCHAR2
255
√
null
CREDIT_LIMIT
NUMBER
8,2
√
null
Indexes
Constraint Name
Type
Sort
Column(s)
SYS_C007578
Primary key
Asc
CUSTOMER_ID
Relationships
Close relationships within degrees of separation
One
Two degrees