CUSTOMER

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   CUSTOMER

Columns

Name	Datatype	Precision	Allow Null	Identity	Description
CITY			NULL
COMPANY_NAME			NULL
CUSTOMERID			NULL		Virtual column
FNAME			NULL		Virtual column
ID			NULL		Virtual column
LNAME			NULL		Virtual column
PHONE			NULL
ZIP			NULL

Indexes

No Data

Check Constraints

No Data

Triggers

No Data

References
     The items listed in the matrix below are called / used by the Table “CUSTOMER”

No Data

Impact Analysis
     The items listed in the matrix below are using / calling the Table “CUSTOMER”

Name	Types	Description
<DEFAULT SCHEMA>.ALL_CUSTOMERS	View	View
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.c1	Cursor	PLSQL Cursor defined in PRODUCTS.ProductsByCustomer
<DEFAULT SCHEMA>.CUSTOMERS.InsertCustomer.Insert	Insert Statement	INSERT INTO CUSTOMER (fname, lname) VALUES (fname,lname)
<DEFAULT SCHEMA>.CUSTOMERS.UpdateCustomerName.Update	Update Statement	UPDATE CUSTOMER SET FNAME=fname, LNAME=lname WHERE Id = customerId
<DEFAULT SCHEMA>.CUSTOMERS.DeleteCustomerById.Delete	Delete Statement	DELETE CUSTOMER where ID = id
<DEFAULT SCHEMA>.ALL_CUSTOMERS.Select	Select Statement	SELECT ID, LNAME FROM CUSTOMER
<DEFAULT SCHEMA>.EMPLOYEES.OrdersByEmployee2.Select	Select Statement	SELECT sales_order.id Oid, sales_order.order_date Odate, DECODE(sales_order.fi
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	select fname, lname into Cust_fname, Cust_lname from customer where id = Customer_Id
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	SELECT Count(*) into Prod_num FROM customer, product, sales_order_items,
<DEFAULT SCHEMA>.PRODUCTSBYCUSTOMER.Select	Select Statement	SELECT product.* FROM SALES_ORDER_ITEMS join customer c on customerId = c.id join SALES_
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.c1.Select	Select Statement	SELECT product.id Pid, product.name prod_name, sum (sales_order_items.quantity*unit_price) P
d_tab_customer.city	Datawindow Column UI
d_tab_customer.company_name	Datawindow Column UI
d_ff_sales_order.customer_fname	Datawindow Column UI
d_tab_sales_order.customer_lname	Datawindow Column UI
d_ff_sales_order.customer_lname	Datawindow Column UI
d_tab_customer.fname	Datawindow Column UI
d_tab_customer.id	Datawindow Column UI
d_tab_customer.lname	Datawindow Column UI
d_tab_customer.phone	Datawindow Column UI
d_tab_customer.zip	Datawindow Column UI
d_tab_customer.table.update	Datawindow Attribute
d_ff_sales_order.Retrieve SQL	Datawindow DataSource
d_tab_sales_order.Retrieve SQL	Datawindow DataSource
d_tab_customer.Retrieve SQL	Datawindow DataSource