CS
Tables (12)
CONTACTS (contacts)
- CONTACT ID (contact_id) — NUMBER — Primary key — NOT NULL
- FIRST NAME (first_name) — VARCHAR2(255) — NOT NULL
- LAST_NAME (last_name) — VARCHAR2(255) — NOT NULL
- EMAIL (email) — VARCHAR2(255) — NOT NULL
- PHONE (phone) — VARCHAR2(20)
- CUSTOMER ID (customer_id) — NUMBER — Foreign key → CUSTOMERS.CUSTOMER ID — NOT NULL
COUNTRIES (countries)
- COUNTRY ID (country_id) — CHAR(2) — Primary key — NOT NULL
- COUNTRY NAME (country_name) — VARCHAR2(40)
- REGION ID (region_id) — NUMBER — Foreign key → REGIONS.REGION ID — NOT NULL
CUSTOMERS (customers)
- CUSTOMER ID (customer_id) — NUMBER — Primary key — NOT NULL
- NAME (name) — VARCHAR2(255) — NOT NULL
- ADDRESS (address) — VARCHAR2(255)
- WEBSITE (website) — VARCHAR2(255)
- CREDIT LIMIT (credit_limit) — NUMBER(8,2)
EMPLOYEES (employees)
- EMPLOYEE ID (employee_id) — NUMBER — Primary key — NOT NULL
- FIRST NAME (first_name) — VARCHAR2(255)
- LAST NAME (last_name) — VARCHAR2(255)
- EMAIL (email) — VARCHAR2(255)
- PHONE (phone) — VARCHAR2(50)
- HIRE DATE (hire_date) — DATE
- MANAGER ID (manager_id) — NUMBER — Foreign key → EMPLOYEES.EMPLOYEE ID — NOT NULL
- JOB TITLE (job_title) — VARCHAR2(255)
INVENTORIES (inventories)
- WAREHOUSE ID (warehouse_id2) — NUMBER(12,0) — Foreign key → WAREHOUSES.WAREHOUSE ID — NOT NULL
- PRODUCT ID (product_id) — NUMBER(12,0) — Foreign key → PRODUCTS.PRODUCT ID — NOT NULL
- QUANTITY (quantity) — NUMBER(8,0) — NOT NULL
LOCATIONS (locations)
- LOCATION ID (location_id) — NUMBER — Primary key — NOT NULL
- ADDRESS (address) — VARCHAR2(255) — NOT NULL
- POSTAL CODE (postal_code) — VARCHAR2(20)
- CITY (city) — VARCHAR2(50)
- STATE (state) — VARCHAR2(50)
- COUNTRY ID (country_id) — CHAR(2) — Foreign key → COUNTRIES.COUNTRY ID — NOT NULL
ORDER ITEMS (order_items)
- ITEM ID (item_id) — NUMBER(12,0) — Primary key — NOT NULL
- ORDER ID (order_id) — NUMBER(12,0) — Foreign key → ORDERS.ORDER ID — NOT NULL
- QUANTITY (quantity) — NUMBER(8,2)
- UNIT PRICE (unit_price) — NUMBER(8,2)
- PRODUCT ID (product_id) — NUMBER(12,0) — Foreign key → PRODUCTS.PRODUCT ID — NOT NULL
ORDERS (orders)
- ORDER ID (order_id) — NUMBER — Primary key — NOT NULL
- CUSTOMER ID (customer_id) — NUMBER — Foreign key → CUSTOMERS.CUSTOMER ID — NOT NULL
- STATUS (status) — VARCHAR2(20)
- SALESMAN ID (salesman_id) — NUMBER(6,0) — Foreign key → EMPLOYEES.EMPLOYEE ID — NOT NULL
- ORDER DATE (order_date) — DATE
PRODUCT CATEGORIES (product_categories)
- CATEGORY ID (category_id) — NUMBER — Primary key — NOT NULL
- CATEGORY NAME (category_name) — VARCHAR2(255)
PRODUCTS (products)
- PRODUCT ID (product_id) — NUMBER — Primary key — NOT NULL
- PRODUCT NAME (product_name) — VARCHAR2(255) — NOT NULL
- DESCRIPTION (description) — VARCHAR2(2000)
- STANDARD COST (standard_cost) — NUMBER(9,2)
- LIST PRICE (list_price) — NUMBER(9,2)
- CATEGORY ID (category_id) — NUMBER — Foreign key → PRODUCT CATEGORIES.CATEGORY ID — NOT NULL
REGIONS (regions)
- REGION ID (region_id) — NUMBER — Primary key — NOT NULL
- REGION NAME (region_name) — VARCHAR2(50)
WAREHOUSES (warehouses)
- WAREHOUSE ID (warehouse_id) — NUMBER — Primary key — NOT NULL
- WAREHOUSE NAME (warehouse_name) — VARCHAR2(255)
- LOCATION ID (location_id) — NUMBER(12,0) — Foreign key → LOCATIONS.LOCATION ID — NOT NULL