PRODUCT

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   PRODUCT

Columns

Name	Datatype	Precision	Allow Null	Identity	Description
COLOR			NULL		Virtual column
DESCRIPTION			NULL		Virtual column
ID	number		NOT NULL		Column
MANAGER_ID	number		NULL		Column
NAME			NULL		Virtual column
PICTURE_NAME			NULL		Virtual column
PROD_SIZE			NULL		Virtual column
QUANTITY			NULL		Virtual column
TOTAL_HT			NULL		Virtual column
UNIT_PRICE	FLOAT		NULL		Column

Indexes

No Data

Check Constraints

No Data

Triggers

Name	ANSI Nulls On	Quoted Identifier On	On	Description
CHECKPRODUCT				after ; update
INSERTPRODUCT				after ; insert

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

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
FLOAT	PL/SQL System type	PL/SQL System Object
NUMBER	PL/SQL System type	PL/SQL System Object
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column

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

Name	Types	Description
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS	Table	Table
<DEFAULT SCHEMA>.ALL_PRODUCTS	View	View
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS	View	View
<DEFAULT SCHEMA>.CHECKPRODUCT	Trigger	Simple Trigger of AFTER "update ON Product"
<DEFAULT SCHEMA>.INSERTPRODUCT	Trigger	Simple Trigger of AFTER "insert ON Product"
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.c1	Cursor	PLSQL Cursor defined in PRODUCTS.ProductsByCustomer
<DEFAULT SCHEMA>.CHECKPRODUCT.NEW	PseudoRecord	PRODUCT
<DEFAULT SCHEMA>.INSERTPRODUCT.NEW	PseudoRecord	PRODUCT
<DEFAULT SCHEMA>.INSERTPRODUCT.OLD	PseudoRecord	PRODUCT
<DEFAULT SCHEMA>.CHECKPRODUCT.OLD	PseudoRecord	PRODUCT
<DEFAULT SCHEMA>.PRODUCTS.CreateProduct.Insert	Insert Statement	INSERT INTO PRODUCT (name, description,prod_size,quantity,unit_price) VALUES (name, description,prod
<DEFAULT SCHEMA>.EMPLOYEE_DELETING.Update	Update Statement	UPDATE PRODUCT SET MANAGER_ID = managerId WHERE c.ID = Id
<DEFAULT SCHEMA>.PRODUCTS.UpdateProductPrice.Update	Update Statement	UPDATE PRODUCT SET unit_price=price WHERE id = productId
<DEFAULT SCHEMA>.PRODUCTS.DeleteProductById.Delete	Delete Statement	DELETE PRODUCT where id = productId
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	select fname, lname, all_products.name, all_products.prod_size, all_products.id,
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	select fname,lname, all_products.name, all_products.prod_size, all_products.id, product.n
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.c1.Select	Select Statement	SELECT product.id Pid, product.name prod_name, sum (sales_order_items.quantity*unit_price) P
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	SELECT Count(*) into Prod_num FROM customer, product, sales_order_items,
<DEFAULT SCHEMA>.ALL_PRODUCTS.Select	Select Statement	SELECT Id, Description, Color, Picture_name, prod_size,quantity,Total_HT,unit_price FROM PRODUCT
<DEFAULT SCHEMA>.ALL_PRODUCTS.Select	Select Statement	SELECT P.Id, P.Description, P.Color, P.Picture_name, P.prod_size, P.quantity,
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.Select	Select Statement	SELECT sales_order.id, sales_order.order_date, sales_order.fin_code_id, sales_
<DEFAULT SCHEMA>.TRG_ORDER.Select	Select Statement	Select name into Prod_name From product Where id = :NEW.prod_id
<DEFAULT SCHEMA>.TRG_ORDER.Select	Select Statement	Select DECODE(count(*),0,false,1,true) into Exist_Prod from product Where id = :NEW.prod_id
<DEFAULT SCHEMA>.PRODUCTSBYCUSTOMER.Select	Select Statement	SELECT product.* FROM SALES_ORDER_ITEMS join customer c on customerId = c.id join SALES_
<DEFAULT SCHEMA>.TRG_ORDER.Select	Select Statement	Select count(*) into Prod_num from product Where id = :NEW.prod_id
d_tab_product.color	Datawindow Column UI
d_tab_product.description	Datawindow Column UI
d_tab_product.id	Datawindow Column UI
dddw_product.id	Datawindow Column UI
d_tab_product.name	Datawindow Column UI
dddw_product.name	Datawindow Column UI
d_tab_product.picture_name	Datawindow Column UI
d_tab_sales_order_items.product_color	Datawindow Column UI
d_tab_sales_order_items.product_description	Datawindow Column UI
d_tab_sales_order_items.product_name	Datawindow Column UI
d_tab_sales_order_items.product_size	Datawindow Column UI
d_tab_sales_order_items.product_unit_price	Datawindow Column UI
d_tab_product.quantity	Datawindow Column UI
d_tab_product.size	Datawindow Column UI
d_tab_product.unit_price	Datawindow Column UI
d_tab_product.table.update	Datawindow Attribute
dddw_product.table.update	Datawindow Attribute
dddw_product.Retrieve SQL	Datawindow DataSource
d_tab_sales_order.Retrieve SQL	Datawindow DataSource
d_tab_product.Retrieve SQL	Datawindow DataSource
d_tab_sales_order_items.Retrieve SQL	Datawindow DataSource
w_sheet_sales_order.dw_detail.itemchanged.Select	SQL Select Statement	SELECT product.name, product.description, product.prod_size, pro