Alpha School Supplies

TEAM 1. -- Engineering

Created by: Robert Betterton

Date: Sun, Feb 16, 2004

Time: 03:51

1. Data Models
   1. Main
2. Data Dictionary

Data Models

Document: AlphaSchoolSupplies.erd

Related Diagrams:

None:

Related Dictionary Entries:

Entities/Tables:

AES_CUSTOMER
AES_EMPLOYEE
AES_EMPLOYEE_COMMENT
AES_INVENTORY
AES_INVENTORY_PROFILE
AES_ORDER
AES_ORDER_LINES
AES_ORDER-SHIP_PROFILE
AES_PRODUCT
AES_PRODUCT_PROFILE
AES_SHIP
AES_STORE
AES_STORE-EMP_PROFILE
AES_SUPPLIER
AES_SUPPLIER_PROFILE
AES_WAREHOUSE
AES_WAREHOUSE-EMP_PROFILE
AES_WAREHOUSE-STORE_PROFILE

Relationships:

Customer_Order
Employee_EmployeeComment
Employee_WarehouseProfile
InventoryProfile_Warehouse
Inventory_InventoryProfile
OrderLines_Products
OrderLines_Ship
Order_OrderLines
ProductProfile_Warehouse
Product_ProductProfile
SupplierProfile_Warehouse
Supplier_SupplierProfile
Warehouse_EmpProfile

Return To Contents

Data Dictionary

Name: AES_CUSTOMER
Composition:
*AES_CUSTOMER'CUSTOMER_ID +
AES_CUSTOMER'FIRST_NAME +
AES_CUSTOMER'LAST_NAME +
AES_CUSTOMER'REGION +
AES_CUSTOMER'PHONE +
AES_CUSTOMER'EMAIL +
AES_CUSTOMER'ADDRESS +
AES_CUSTOMER'CITY +
AES_CUSTOMER'ZIP +
AES_CUSTOMER'STATE
Definition: This is the customer entity which stores all information about the customer.


Customer Info
#Details
Physical: AES_CUSTOMER
##
#TableCode
##
#Notes
##
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_CUSTOMER'ADDRESS
Composition:
Definition:
#Details
DataType: VARCHAR2(60)
Describe: This is the address for the customer. It is assumed they have only one address for both shipping and billing.
Qualify: notnull
Physical: ADDRESS
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'CITY
Composition:
Definition:
#Details
DataType: VARCHAR2(40)
Describe: This is the customers city of resisidence.
Qualify: notnull
Physical: CITY
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'CUSTOMER_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the customers ID number.
Qualify: notnull
Physical: CUSTOMER_ID
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'EMAIL
Composition:
Definition:
#Details
DataType: VARCHAR2(80)
Describe: This is the email for the customer. It is obtain from the web and is used to tell the cusomter that an order has been received. It is also used to tell the customer when a shipment has been made, as well as telling the customer of sales deals and promotions.
Qualify: notnull
Physical: EMAIL
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'FIRST_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(35)
Describe: This is the first name of a customer.
Qualify: notnull
Physical: FIRST_NAME
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'LAST_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(35)
Describe: This is the last/family name of a Customer.
Qualify: notnull
Physical: LAST_NAME
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'PHONE
Composition:
Definition:
#Details
DataType: VARCHAR2(12)
Describe: This is the telephone number for the customer.
Qualify: notnull
Physical: PHONE
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'REGION
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the region the customer belongs to. It is used by the warehouse entity so that order filling and shipment is made from the proper warehouse, when orders are filled from the Web Site, and when a store needs to order from the warehouse. Warehouses can also send merchandise to other warehouses when the need arises.
Qualify: notnull
Physical: REGION
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'STATE
Composition:
[ALABAMA|ALASKA|ARIZONA|ARKANSAS|CALIFORNIA|COLORADO|etc.]
Definition:
#Details
DataType: VARCHAR2(15)
Describe: This is the State where the customer lives. In the web application this will be selected from a static drop down menu that is stored in the database. This same state list is shared by other STATE dropdown lists in the web application.
Qualify: notnull
Physical: STATE
##
References:
ATTRIBUTE

Name: AES_CUSTOMER'ZIP
Composition:
[XXXXX-XXXX]
Definition:
#Details
DataType: VARCHAR2(11)
Describe: This is the customers Zip code number. This number is auto filled based on the state, city and address. This zip is the 9 digit number, plus hyphen.
Qualify: notnull
Physical: ZIP
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE
Composition:
*AES_EMPLOYEE'EMPLOYEE_ID +
AES_EMPLOYEE'FIRST_NAME +
AES_EMPLOYEE'MIDDLE_NAME +
AES_EMPLOYEE'LAST_NAME +
AES_EMPLOYEE'PHONE +
AES_EMPLOYEE'ADDRESS +
AES_EMPLOYEE'CITY +
AES_EMPLOYEE'STATE +
AES_EMPLOYEE'ZIP +
AES_EMPLOYEE'TITLE +
AES_EMPLOYEE'SALARY +
AES_EMPLOYEE'START_DATE
Definition: This is the AES EMPLOYEE entity which stores all information about the employees that work in the main office, stores and warehouses. In the web application this will be selected from a static drop down menu that is stored in the database. This same STATE list is shared by other STATE dropdown lists in the web application.


Employee Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_EMPLOYEE'ADDRESS
Composition:
Definition:
#Details
DataType: VARCHAR2(60)
Describe: This is the address for each employee.
Qualify: notnull
Physical: ADDRESS
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'CITY
Composition:
Definition:
#Details
DataType: VARCHAR2(50)
Describe: This is the city where each employee lives.
Qualify: notnull
Physical: CITY
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'EMPLOYEE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the employee ID
Qualify: notnull
Physical: EMPLOYEE_ID
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'FIRST_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the first name of the employee.
Qualify: notnull
Physical: FIRST_NAME
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'LAST_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the last/family name of the employee.
Qualify: notnull
Physical: LAST_NAME
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'MIDDLE_NAME
Composition:
Definition:
#Details
TataType: VARCHAR2(10)
Describe: This is the middle initial for the employee.
Qualify: numll
Physical: MIDDLE_NAME
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'PHONE
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the home phone number for employee.
Qualify: notnull
Physical: PHONE
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'SALARY
Composition:
[$]
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the employees salary, repersented in US Dollars.
Qualify: notnull
Physical: SALARY
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'START_DATE
Composition:
[dd-mmm-yyyy]
Definition:
#Details
DataType: DATE
Describe: This is the employee's start date with the company. This date is selected from a common calendar tag that is used by the web application.
Qualify: notnull
Physical: START_DATE
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'STATE
Composition:
[ALABAMA|ALASKA|ARIZONA|ARKANSAS|CALIFORNIA|COLORADO|etc.]
Definition:
#Details
DataType: VARCHAR2(15)
Describe: This is the state that each employee livies in. In the web application this will be selected from a static drop down menu that is stored in database. This same state list is shared by other STATE dropdown lists.
Qualify: notnull
Physical: STATE
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'TITLE
Composition:
Definition:
#Details
DataType: VARCHAR2(35)
Describe: This is the employee title used in the company.
Qualify: notnull
Physical: TITLE
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE'ZIP
Composition:
[xxxxx-xxxx]
Definition:
#Details
DataType: VARCHAR2(11)
Describe: This is the employee's zip code. This zip is the 9 digit number, plus hyphen.
Qualify: notnull
Physical: ZIP
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE_COMMENT
Composition:
*AES_EMPLOYEE_COMMENT'EMPLOYEE_COM_ID +
@AES_EMPLOYEE_COMMENT'EMPLOYEE_ID +
AES_EMPLOYEE_COMMENT'COMMENT_DATE +
AES_EMPLOYEE_COMMENT'COMMENTS
Definition: This is the AES EMPLOYEE_COMMENT entity which stores all information about the employee comments given to HR (Human Resoruces).


Employee Comment Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" ""

Name: AES_EMPLOYEE_COMMENT'COMMENTS
Composition:
Definition:
#Details
DataType: VARCHAR2(2000)
Describe: Attribute for storing employee comments.
Qualify: notnull
Physical: COMMENTS
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE_COMMENT'COMMENT_DATE
Composition:
[dd-mmm-yyyy]
Definition:
#Details
DataType: DATE
Describe: The date the employee comment was made. This date is selected from a common calendar tag that is used by the web application.
Qualify: notnull
Physical: COMMENT_DATE
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE_COMMENT'EMPLOYEE_COM_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The employee comment ID number, used by the AES_EMPLOYEE_COMMENT entity.
Physical: EMPLOYEE_COM_ID
##
References:
ATTRIBUTE

Name: AES_EMPLOYEE_COMMENT'EMPLOYEE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The employee ID number.
Physical: EMPLOYEE_ID
##
References:
ATTRIBUTE

Name: AES_INVENTORY
Composition:
*AES_INVENTORY'INVENTORY_ID +
AES_INVENTORY'AMOUNT_IN_STOCK +
AES_INVENTORY'MAX_STOCKING_LEVEL +
AES_INVENTORY'REORDER_POINT +
AES_INVENTORY'WHY_OUTOF_STOCK
Definition: This is the AES INVENTORY entity which stores all information about the inventory.


Inventory Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_INVENTORY'AMOUNT_IN_STOCK
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The amount in stock within the warehouse.
Qualify: notnull
Physical: AMOUNT_IN_STOCK
##
References:
ATTRIBUTE

Name: AES_INVENTORY'INVENTORY_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The inventory ID number.
Qualify: notnull
Physical: INVENTORY_ID
##
References:
ATTRIBUTE

Name: AES_INVENTORY'MAX_STOCKING_LEVEL
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The amount that is set for the maximum stocking level.
Qualify: notnull
Physical: MAX_STOCKING_LEVEL
##
References:
ATTRIBUTE

Name: AES_INVENTORY'REORDER_POINT
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: What is the oder point for the inventory.
Qualify: notnull
Physical: ORDER_POINT
##
References:
ATTRIBUTE

Name: AES_INVENTORY'WHY_OUTOF_STOCK
Composition:
Definition:
#Details
DataType: VARCHAR2(60)
Describe: What is reason we are out of stock.
Physical: WHY_OUTOF_STOCK
##
References:
ATTRIBUTE

Name: AES_INVENTORY_PROFILE
Composition:
*AES_INVENTORY_PROFILE'INVENTORY_PROFILE_ID +
@AES_INVENTORY_PROFILE'INVENTORY_ID +
@AES_INVENTORY_PROFILE'WAREHOUSE_ID
Definition: This is the association/connection table between the AES INVENTORY and AES WAREHOUSE tables.


Inventory Profile Association Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_INVENTORY_PROFILE'INVENTORY_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the inventory ID number.
Qualify: notnull
Physical: INVENTORY_ID
##
References:
ATTRIBUTE

Name: AES_INVENTORY_PROFILE'INVENTORY_PROFILE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the inventory profile ID number.
Qualify: notnull
Physical: INVENTORY_PROFILE_ID
##
References:
ATTRIBUTE

Name: AES_INVENTORY_PROFILE'WAREHOUSE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the Warehouse_ID number.
Qualify: notnull
Physical: WAREHOUSE_ID
##
References:
ATTRIBUTE

Name: AES_ORDER
Composition:
*AES_ORDER'ORDER_ID +
@AES_ORDER'CUSTOMER_ID +
AES_ORDER'ORDER_DATE +
AES_ORDER'ORDER_FILLED
Definition: This is the AES ORDER entity which stores all information about the customer order.


Order Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" ""

Name: AES_ORDER'CUSTOMER_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the Customer ID number.
Qualify: notnull
Physical: CUSTOMER_ID
##
References:
ATTRIBUTE

Name: AES_ORDER'ORDER_DATE
Composition:
[dd-mmm-yyyy]
Definition:
#Details
DataType: DATE
Describe: This is the date the order was made by the customer. This date is selected from a common calendar tag that is used by the web application.
Qualify: notnull
Physical: ORDER_DATE
##
References:
ATTRIBUTE

Name: AES_ORDER'ORDER_FILLED
Composition:
[NO|YES|PARTIAL]
Definition:
#Details
DataType: VARCHAR2(8)
Describe: This is a flag used to single how much an order was filled. The flag takes on the values of NO, YES, PARTIAL.
Qualify: notnull
Physical: ORDER_FILLED
##
References:
ATTRIBUTE

Name: AES_ORDER'ORDER_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the order ID number.
Qualify: notnull
Physical: ORDER_ID
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES
Composition:
*AES_ORDER_LINES'ORDER_LINE_ID +
@AES_ORDER_LINES'ORDER_ID +
@AES_ORDER_LINES'PRODUCT_ID +
AES_ORDER_LINES'QUANTITY +
AES_ORDER_LINES'SELLING_PRICE +
AES_ORDER_LINES'LINE_COST +
@AES_ORDER_LINES'SHIPPING_ID +
AES_ORDER_LINES'SHIPPED
Definition: This is the association table-entity which stores all information about the order_lines.


Line Order Info
References:
ERD(ENTITY) "AlhpaSchoolSupplies.erd" ""

Name: AES_ORDER_LINES'LINE_COST
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the extended cost for each line product/item purchased.
Qualify: notnull
Physical: LINE_COST
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES'ORDER_ID
Composition:
Definition:
References:
ATTRIBUTE

Name: AES_ORDER_LINES'ORDER_LINE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the order line ID number.
Qualify: notnull
Physical: ORDER_LINE_ID
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES'PRODUCT_ID
Composition:
Definition:
References:
ATTRIBUTE

Name: AES_ORDER_LINES'QUANTITY
Composition:
Definition:
#Details
DataType: NUMBER(4)
Describe: This is the quantity that a customer orders for each line product/item.
Qualify: notnull
Physical: QUANTITY
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES'SELLING_PRICE
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the selling price for each product/item that a customer orders.
Qualify: notnull
Physical: SELLING_PRICE
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES'SHIPPED
Composition:
[FULL|PARTIAL]
Definition:
#Details
DataType: VARCHAR2(8)
Describe: This is the Shipping Status of a Customers order. The orders can be FULL, or PARTIAL.
Qualify: notnull
Physical: SHIPPED
##
References:
ATTRIBUTE

Name: AES_ORDER_LINES'SHIPPING_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the shipping ID for each complete and partial order that is filled.
Qualify: notnull
Physical: SHIPPING_ID
##
References:
ATTRIBUTE

Name: AES_ORDER-SHIP_PROFILE
Composition:
*AES_ORDER-SHIP_PROFILE'ORDER-SHIP_ID +
@AES_ORDER-SHIP_PROFILE'ORDER_ID +
AES_ORDER-SHIP_PROFILE'PROFILE_DATE +
@AES_ORDER-SHIP_PROFILE'SHIPPING_ID
Definition: This is the association table between the AES ORDER table and the AES SHIP table. This is a connection table that is needed because there can be several shippings within an order due to backlogs and out of stock items.


Order-ship profile Association Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_ORDER-SHIP_PROFILE'ORDER-SHIP_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the order-ship_ID profile number.
Qualify: notnull
Physical: ORDER-SHIP_ID
##
References:
ATTRIBUTE

Name: AES_ORDER-SHIP_PROFILE'ORDER_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the order_id profile number.
Qualify: notnull
Physical: ORDER_ID
##
References:
ATTRIBUTE

Name: AES_ORDER-SHIP_PROFILE'SHIPPING_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the Shipping_ID profile number.
Qualify: notnull
Physical: SHIPPING_ID
##
References:
ATTRIBUTE

Name: AES_ORDER-SHIP_PROFILE'PROFILE_DATE
Composition:
[dd-mmm-yyyy]
Definition:
#Details
DataType: DATE(7)
Describe: This is the order-ship profile table date. This date is automatically entered with the profile is updaded.
Qualify: notnull
Physical: PROFILE_DATE
##
References:
ATTRIBUTE

Name: AES_PRODUCT
Composition:
*AES_PRODUCT'PRODUCT_ID +
AES_PRODUCT'PRODUCT_NAME +
AES_PRODUCT'PRODUCT_DESCRIPTION +
AES_PRODUCT'SUGGESTED_PRICE
AES_PRODUCT'PRODUCT_REC_DATE
Definition: This is the AES PRODUCT entity which stores all information about the product.


Product Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" ""

Name: AES_PRODUCT'PRODUCT_DESCRIPTION
Composition:
Definition:
#Details
DataType: VARCHAR2(100)
Describe: This is a description for the product.
Qualify: notnull
Physical: PRODUCT_DESCRIPTION
##
References:
ATTRIBUTE

Name: AES_PRODUCT'PRODUCT_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the product ID.
Qualify: notnull
Physical: PRODUCT_ID
##
References:
ATTRIBUTE

Name: AES_PRODUCT'PRODUCT_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(25)
Describe: This is the products name.
Qualify: notnull
Physical: PRODUCT_NAME
##
References:
ATTRIBUTE

Name: AES_PRODUCT'PRODUCT_RED_DATE
Composition:
[dd-mmm-yyyy]
Definition:
#Details
DataType: DATE(7)
Describe: This is the products recept date. This date is selected from a common calendar tag that is used by the web application.
Qualify: notnull
Physical: PRODUCT_REC_DATE
##
References:
ATTRIBUTE

Name: AES_PRODUCT'SUGGESTED_PRICE
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This holds the suggested price for a product.
Qualify: notnull
Physical: SUGGESTED_PRICE
##
References:
ATTRIBUTE

Name: AES_PRODUCT_PROFILE
Composition:
*AES_PRODUCT_PROFILE'PRODUCT_PROFILE_ID +
@AES_PRODUCT_PROFILE'PRODUCT_ID +
@AES_PRODUCT_PROFILE'WAREHOUSE_ID
Definition: This is the association/connection table between the AES PRODUCT and AES WAREHOUSE tables.


Product Warehouse Profile Association Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_PRODUCT_PROFILE'PRODUCT_PROFILE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the product profile ID number.
Qualify: notnull
Physical: PRODUCT_ID
##
References:
ATTRIBUTE

Name: AES_PRODUCT_PROFILE'PRODUCT_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The product ID number.
Qualify: notnull
Physical: PRODUCT_PROFILE_ID
##
References:
ATTRIBUTE

Name: AES_PRODUCT_PROFILE'WAREHOUSE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the warehouse ID number.
Qualify: notnull
Physical: WAREHOUSE_ID
##
References:
ATTRIBUTE

Name: AES_SHIP
Composition:
*AES_SHIP'SHIPPING_ID +
AES_SHIP'SHIP_DATE +
AES_SHIP'SHIPPER +
AES_SHIP'COMMENTS
Definition: This is the table-entity AES SHIP which stores all information about shipments.


Ship Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_SHIP'COMMENTS
Composition:
Definition:
#Details
DataType: VARCHAR2(500)
Describe: Comments about the shipping.
Physical: COMMENTS
##
References:
ATTRIBUTE

Name: AES_SHIP'SHIPPER
Composition:
Definition:
#Details
DataType: VARCHAR2(40)
Describe: This is the shippers name.
Qualify: notnull
Physical: SHIPPER
##
References:
ATTRIBUTE

Name: AES_SHIP'SHIPPING_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the shp ID number.
Qualify: notnull
Physical: SHIPPING_ID
##
References:
ATTRIBUTE

Name: AES_SHIP'SHIP_DATE
Composition:
[dd-mmm-yyyy]
Definition:
#Details
DataType: DATE
Describe: This is the date the shippment was made. This date is selected from a common calendar tag that is used by the web application.
Qualify: notnull
Physical: SHIP_DATE
##
References:
ATTRIBUTE

Name: AES_STORE
Composition:
*AES_STORE'STORE_ID +
AES_STORE'STORE_NAME +
AES_STORE'REGION +
AES_STORE'PHONE +
AES_STORE'ADDRESS +
AES_STORE'CITY +
AES_STORE'STATE +
AES_STORE'ZIP
Definition: This is the table-entity AES STORE which stores all information about stores.


Store Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_STORE'ADDRESS
Composition:
Definition:
#Details
DataType: VARCHAR2(60)
Describe: This is address of the store.
Qualify: notnull
Physical: ADDRESS
##
References:
ATTRIBUTE

Name: AES_STORE'CITY
Composition:
Definition:
#Details
DataType: VARCHAR2(40)
Describe: This is the city where the store is located.
Qualify: notnull
Physical: CITY
##
References:
ATTRIBUTE

Name: AES_STORE'PHONE
Composition:
Definition:
#Details
DataType: VARCHAR2(12)
Describe: The phone for the store.
Qualify: notnull
Physical: PHONE
##
References:
ATTRIBUTE

Name: AES_STORE'REGION
Composition:
[EASTERN-US|NORTHERN-US|CENTRAL-US|SOUTHERN-US|WESTERN-US]
Definition:
This Attribute is a drop down list that holds the Regions.
#Details
DataType: VARCHAR2(30)
Describe: The region the store is located in.
Qualify: notnull
Physical: REGION
##
References:
ATTRIBUTE

Name: AES_STORE'STATE
Composition:
[ALABAMA|ALASKA|ARIZONA|ARKANSAS|CALIFORNIA|COLORADO|etc.]
Definition:
#Details
DataType: VARCHAR(15)
Describe: The state where the warehouse is located. In the web application this will be selected from a static drop down menu that is stored in the database. This same state list is shared by other STATE dropdown lists in the web application.
Qualify: notnull
Physical: STATE
##
References:
ATTRIBUTE

Name: AES_STORE'STORE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The store ID number.
Qualify: notnull
Physical: STORE_ID
##
References:
ATTRIBUTE

Name: AES_STORE'STORE_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(35)
Describe: The name of the store.
Qualify: notnull
Physical: STORE_NAME
##
References:
ATTRIBUTE

Name: AES_STORE'ZIP
Composition:
Definition:
#Details
DataType: VARCHAR2(11)
Describe: This is the zip for the store.
Qualify: notnull
Physical: ZIP
##
References:
ATTRIBUTE

Name: AES_STORE-EMP_PROFILE
Composition:
*AES_STORE-EMP_PROFILE'STORE-EMP_ID +
@AES_STORE-EMP'STORE_ID +
@AES_STORE-EMP'EMPLOYEE_ID
Definition: This is the association/connection profile table between the ASE STORE and ASE EMPLOYEE tables.


Store-Employee Profile Association Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_STORE-EMP_PROFILE'EMPLOYEE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the employee ID number.
Qualify: notnull
Physical: EMPLOYEE_ID
##
References:
ATTRIBUTE

Name: AES_STORE-EMP_PROFILE'STORE_EMP_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The store-emp ID number.
Qualify: notnull
Physical: STORE-EMP_ID
##
References:
ATTRIBUTE

Name: AES_STORE-EMP_PROFILE'STORE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the Store ID number.
Qualify: notnull
Physical: STORE_ID
##
References:
ATTRIBUTE

Name: AES_SUPPLIER
Composition:
*AES_SUPPLIER'SUPPLIER_ID +
AES_SUPPLIER'SUPPLIER_NAME +
AES_SUPPLIER'REGION +
AES_SUPPLIER'PHONE +
AES_SUPPLIER'ADDRESS +
AES_SUPPLIER'CITY +
AES_SUPPLIER'STATE +
AES_SUPPLIER'ZIP
Definition: This is the table-entity AES SUPPLIER which stores all information about the supplier.


Supplier Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_SUPPLIER'ADDRESS
Composition:
Definition:
#Details
DataType: VARCHAR2(60)
Describe: This is the suppliers address.
Qualify: notnull
Physical: ADDRESS
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'CITY
Composition:
Definition:
#Details
DataType: VARCHAR2(40)
Describe: This the suppliers city of resisdence.
Qualify: notnull
Physical: CITY
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'PHONE
Composition:
Definition:
#Details
DataType: VARCHAR2(12)
Describe: This is the suppliers telephone number.
Physical: PHONE
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'REGION
Composition:
Definition:
#Details
DataType: VARCHAR2(30)
Describe: This is the region were the supplier is located.
Qualify: notnull
Physical: REGION
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'STATE
Composition:
[ALABAMA|ALASKA|ARIZONA|ARKANSAS|CALIFORNIA|COLORADO|etc.]
Definition:
#Details
DataType: VARCHAR2(15)
Describe: This is the suppliers state of residence. In the web application this will be selected from a static drop down menu that is stored in the database. This same state list is shared by other STATE dropdown lists in the web application.
Qualify: notnull
Physical: STATE
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'SUPPLIER_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the supplier ID number.
Qualify: notnull
Physical: SUPPLIER_ID
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'SUPPLIER_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(35)
Describe: This is the suppliers name.
Qualify: notnull
Physical: SUPPLIER_NAME
##
References:
ATTRIBUTE

Name: AES_SUPPLIER'ZIP
Composition:
Definition:
#Details
DataType: VARCHAR2(11)
Describe: This the suppliers zip code.
Qualify: notnull
Physical: ZIP
##
References:
ATTRIBUTE

Name: AES_SUPPLIER_PROFILE
Composition:
*AES_SUPPLIER_PROFILE'SUPPLIER_PROFILE_ID +
@AES_SUPPLIER_PROFILE'SUPPLIER_ID +
@AES_SUPPLIER_PROFILE'WAREHOUSE_ID
Definition: This is the association/connection table between the SUPPLIER and WAREHOUSE tables.


Supplier Association Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_SUPPLIER_PROFILE'SUPPLIER_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the Supplier ID number.
Qualify: notnull
Physical: SUPPLIER_ID
##
References:
ATTRIBUTE

Name: AES_SUPPLIER_PROFILE'SUPPLIER_PROFILE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the supplier profile ID number.
Qualify: notnull
##
References:
ATTRIBUTE

Name: AES_SUPPLIER_PROFILE'WAREHOUSE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the warehouse ID number.
Qualify: notnull
Physical: WAREHOUSE_ID
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE
Composition:
*AES_WAREHOUSE'WAREHOUSE_ID +
AES_WAREHOUSE'WAREHOUSE_NAME +
AES_WAREHOUSE'REGION +
AES_WAREHOUSE'PHONE +
AES_WAREHOUSE'ADDRESS +
AES_WAREHOUSE'CITY +
AES_WAREHOUSE'STATE +
AES_WAREHOUSE'ZIP
Definition: This is the table-entity warehouse which stores all information about warehouse.


Warehouse Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_WAREHOUSE'ADDRESS
Composition:
Definition:
#Details
DataType: VARCHAR2(60)
Describe: The address of the warehouse.
Qualify: notnull
Physical: ADDRESS
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'CITY
Composition:
Definition:
#Details
DataType: VARCHAR2(40)
Describe: This is the city where the warehouse is located.
Qualify: notnull
Physical: CITY
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'PHONE
Composition:
Definition:
#Details
DataType: VARCHAR2(12)
Describe: The phone for the warehouse.
Qualify: notnull
Physical: PHONE
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'REGION
Composition:
[EASTERN-US|NORTHERN-US|CENTRAL-US|SOUTHERN-US|WESTERN-US]
Definition:
This Attribute is a drop down list that holds the Regions.
#Details
DataType: VARCHAR2(30)
Describe: The region the warehouse is located in.
Qualify: notnull
Physical: REGION
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'STATE
Composition:
[ALABAMA|ALASKA|ARIZONA|ARKANSAS|CALIFORNIA|COLORADO|etc.]
Definition:
#Details
DataType: VARCHAR(15)
Describe: The state where the warehouse is located. In the web application this will be selected from a static drop down menu that is stored in the database. This same state list is shared by other STATE dropdown lists in the web application.
Qualify: notnull
Physical: STATE
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'WAREHOUSE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: The warehouse ID number.
Qualify: notnull
Physical: WAREHOUSE_ID
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'WAREHOUSE_NAME
Composition:
Definition:
#Details
DataType: VARCHAR2(35)
Describe: The name of the warehouse.
Qualify: notnull
Physical: WAREHOUSE_NAME
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE'ZIP
Composition:
Definition:
#Details
DataType: VARCHAR2(11)
Describe: This is the zip for the warehouse.
Qualify: notnull
Physical: ZIP
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE-EMP_PROFILE
Composition:
*AES_WAREHOUSE-EMP_PROFILE'WAREHOUSE-EMP_ID +
@AES_WAREHOUSE-EMP_PROFILE'WAREHOUSE_ID +
@AES_WAREHOUSE-EMP_PROFILE'EMPLOYEE_ID
Definition: This is the association/connection table between the AES WAREHOUSE and AES EMPLOYEE tables.


Warehouse-Emp Profile Association Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_WAREHOUSE-EMP_PROFILE'EMPLOYE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the Employee ID number.
Qualify: notnull
Physical: EMPLOYEE_ID
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE-EMP_PROFILE'WAREHOUSE-EMP_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the warehouse-emp ID number.
Qualify: notnull
Physical: WAREHOUSE-EMP_ID
##
References:
ATTRIBUTE

Name: AES_WAREHOUSE-EMP_PROFILE'WAREHOUSE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the warehouse ID number.
Qualify: notnull
Physical: WAREHOUSE_ID
##
References:
ATTRIBUTE

Name: AES_STORE-EMP_PROFILE
Composition:
*AES_STORE-EMP_PROFILE'STORE-EMP_ID +
@AES_STORE-EMP_PROFILE'STORE_ID +
@AES_STORE-EMP_PROFILE'EMPLOYEE_ID
Definition: This is the association/connection table between the AES STORE and AES EMPLOYEE tables.


Store-Emp Profile Association Info
References:
ERD(ENTITY) "AlphaSchoolSupplies.erd" "Main"

Name: AES_STORE-EMP_PROFILE'EMPLOYEE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the Employee ID number.
Qualify: notnull
Physical: EMPLOYEE_ID
##
References:
ATTRIBUTE

Name: AES_STORE-EMP_PROFILE'STORE-EMP_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the store-emp ID number.
Qualify: notnull
Physical: STORE-EMP_ID
##
References:
ATTRIBUTE

Name: AES_STORE-EMP_PROFILE'STORE_ID
Composition:
Definition:
#Details
DataType: NUMBER(6)
Describe: This is the store ID number.
Qualify: notnull
Physical: STORE_ID
##
References:
ATTRIBUTE

Drop Down Menu References:

Name: ALABAMA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: ALASKA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: ARIZONA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: ARKANSAS
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: CALIFORNIA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: CENTRAL-US
Composition:
Definition: This is a REGION drop-down menu item/element.
References: MENU

Name: COLORADO
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: DISTRICT OF COLUMBIA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: EASTERN-US
Composition:
Definition: This is the REGION drop-down menu item/element.
References: MENU

Name: etc.
Composition:
Definition: This is CONTINUANCE drop-down menu item/element.
References: MENU

Name: FLORIDA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: FULL
Composition:
Definition: This is a SHIPMENT state drop-down menu item/element.
References: MENU

Name: GEORGIA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: HAWAII
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: IDAHO
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: ILLINOIS
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: INDIANA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: IOWA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: KANSAS
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: LOUISIANA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: MAINE
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: MARYLAND
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: MASSACHUSETTS
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: MINNESOTA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: MISSISSIPPI
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: MISSOURI
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: MONTANA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: NEBRASKA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: NEVADA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: NEVADA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: NEW HAMPSHIRE
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: NEW JERSEY
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: NEW MEXICO
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: NEW YORK
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: NO
Composition:
Definition: This is a DECISION drop-down menu item/element.
References: MENU

Name: NORTH CAROLINA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: NORTH DAKOTA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: NORTHERN-US
Composition:
Definition: This is REGION drop-down menu item/element.
References: MENU

Name: OHIO
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: OKLAHOMA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: OREGON
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: PARTIAL
Composition:
Definition: This is SHIPMENT state drop-down menu item/element.
References: MENU

Name: PENNSYLVANIA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: SOUTH CAROLINA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: SOUTH DAKOTA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: SOUTHERN-US
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: TENNESSEE
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: TEXAS
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: UTAH
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: VIRGINIA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: WASHINGTON
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: WEST VIRGINIA
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: WESTERN-US
Composition:
Definition: This is REGION drop-down menu item/element.
References:MENU

Name: WISCONSIN
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: WYOMING
Composition:
Definition: This is the STATE drop-down menu item/element.
References: MENU

Name: YES
Composition:
Definition: This is DECISION drop-down menu item/element.
References: MENU

Relationship Definitions:

Name: Customer_Order
Composition:
Definition:
[Customer] can place many [Order], and an [Order] has but one [customer].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

Name: Employee_EmployeeComment
Composition:
Definition:
An [Employee] can have many [Employee_Comment], and [Employee_Comment] belongs to one [Empolyee].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

Name: Employee_Warehouse
Composition:
Definition:
An [Employee] works for one [Warehouse], and [Warehouse] can have many [Empolyee].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

Name: InventoryProfile_Warehouse
Composition:
Definition:
A [Inventory_Profile] can have only one [Warehouse], and a [Warehouse] can have many [Inventory_Profile].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

Name: Inventory_InventoryProfile
Composition:
Definition:
[Inventory] can have many [Inventory_Profile], and [Inventory_Profile] has only one [Inventory].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

Name: OrderLines_Products
Composition:
Definition:
An [0rder-LInes] is made up of one [Product], and a [Product] can be part of many [Order-LInes].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

Name: OrderLines_Ship
Composition:
Definition:
An [Order_Line] can be made up of many [Ship] products, a [Ship] can have one [Order_Lines].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

Name: Order_OrderLines
Composition:
Definition:
An [0rder] can have many [Order_Lines], and an [Order-lines] can have but one [Order].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

Name: ProductProfile_Warehouse
Composition:
Definition:
A [Product_Profile] can have only one [Warehouse], and a [Warehouse] can have many [Product_Profile].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

Name: Product_ProductProfile
Composition:
Definition:
A [Product] can have many [Product_Profile], and [Product_Profile] has only one [Product].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

Name: SupplierProfile_Warehouse
Composition:
Definition:
A [Supplier_Profile] can have only one [Warehouse], and a [Warehouse] can have many [Supplier_Profile].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

Name: Supplier_SupplierProfile
Composition:
Definition:
[Supplier] can have many [Supplier_Profile], and [Supplier_Profile] has only one [Supplier].
References:
ERD(RELATION) "AlphaSchoolSupplies.erd" "Main"

---

E-Mail Me

This site is brought to you by Bob Betterton; 2001 - 2011. This page was last updated on 02/21/2004 Copyright, RDB Prime Engineering

This Page has been accessed " 2237" times.