ATLAN SQL EDITOR

Workspace

Tables

Tables with their respective records

Categories

8

Table Keys
categoryID
categoryName
description
picture

Customers

91

Table Keys
customerID
companyName
contactName
contactTitle
address
city
region
postalCode
country
phone
fax

Employees

9

Table Keys
employeeID
lastName
firstName
title
titleOfCourtesy
birthDate
hireDate
address
city
region
postalCode
country
homePhone
extension
photo
notes
reportsTo
photoPath

Order_details

126

Table Keys
orderID
productID
unitPrice
quantity
discount

Orders

122

Table Keys
orderID
customerID
employeeID
orderDate
requiredDate
shippedDate
shipVia
freight
shipName
shipAddress
shipCity
shipRegion
shipPostalCode
shipCountry

Products

77

Table Keys
productID
productName
supplierID
categoryID
quantityPerUnit
unitPrice
unitsInStock
unitsOnOrder
reorderLevel
discontinued

Regions

4

Table Keys
regionID
regionDescription

Suppliers

29

Table Keys
supplierID
companyName
contactName
contactTitle
address
city
region
postalCode
country
phone
fax
homePage
Query
Results
Reset