Task - DDL & ER Diagram - Order Management System #2

akash-coded · 2022-03-11T06:44:28Z

akash-coded
Mar 11, 2022
Maintainer

Write DDL statements to create a DB and tables as per the given schema:

shreiyarandive · 2022-03-11T06:45:14Z

shreiyarandive
Mar 11, 2022

CREATE TABLE `employees`(
    `employeeNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `lastName` varchar(50) NOT NULL,
    `firstName` varchar(50) NOT NULL,
    `extension` varchar(50),
    `email` varchar(50) NOT NULL,
    `officeCode` int(11),
    `reportsTo` int(11),
    `jobTitle` varchar(50),
    CONSTRAINT `PK_employees` PRIMARY KEY (`employeeNumber`),
    CONSTRAINT `UQ_employees_email` UNIQUE (`email`),
    CONSTRAINT `FK_offices_employees` FOREIGN KEY (`officeCode`) REFERENCES `offices` (`officeCode`),
    CONSTRAINT `FK_employees_employees` FOREIGN KEY (`reportsTo`) REFERENCES `employees`(`employeeNumber`)   
);

CREATE TABLE `offices`(
    `officeCode` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `city` varchar(25) NOT NULL,
    `phone` varchar(10) NOT NULL,
    `addressLine1` varchar(75) NOT NULL,
    `addressLine2` varchar(75) DEFAULT NULL,
    `state` varchar(15) NOT NULL,
    `country` varchar(15) NOT NULL,
    `postalCode` int(8) NOT NULL,
    `territory` varchar(15) NOT NULL,
     CONSTRAINT `PK_offices` PRIMARY KEY (`officeCode`),
     CONSTRAINT `UQ_offices_phone` UNIQUE (`phone`)
);

CREATE TABLE `products`(
    `productCode` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productName` varchar(50) NOT NULL,
    `productLine` int(11) UNSIGNED NOT NULL,
    `productScale` varchar(25),
    `productVendor` varchar(30) NOT NULL,
    `productDescription` varchar(100),
    `quantityInStock` int(11) UNSIGNED NOT NULL,
    `buyPrice` decimal(11, 2) UNSIGNED NOT NULL,
    `MSRP` decimal(11, 2) UNSIGNED NOT NULL,
     CONSTRAINT `PK_products` PRIMARY KEY (`productCode`),
     CONSTRAINT `UQ_products_productName` UNIQUE (`productName`),
     CONSTRAINT `FK_productLines_products` FOREIGN KEY (`productLine`) REFERENCES `productLines` (`productLines`)
);

CREATE TABLE `productLines` (
    `productLine` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `textDescription` varchar(255),
    `htmlDescription` varchar(255),
    `image` varchar(255),
     CONSTRAINT `PK_productLines` PRIMARY KEY (`productLine`),
);

CREATE TABLE `orderDetails` (
    `orderNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productCode` int(11) UNSIGNED NOT NULL,
    `quantityOrdered` int(11) UNSIGNED NOT NULL,
    `priceEach` decimal(11,2) NOT NULL,
    `orderLineNumber` int(11),
     CONSTRAINT `PK_orderDetails` PRIMARY KEY (`orderNumber`, `productCode`),
     CONSTRAINT `FK_orderDetails_productCode` FOREIGN KEY (`productCode`) REFERENCES `products` (`productCode`)
);

CREATE TABLE `orders` (
    `orderNumber` int(11) UNSIGNED NOT NULL,
    `orderDate` datetime NOT NULL,
    `requiredDate` datetime,
    `shippedDate` datetime NOT NULL,
    `status` varchar(255) NOT NULL,
    `comments` varchar(255),
    `customerNumber` int(11) UNSIGNED NOT NULL,
     CONSTRAINT `PK_orders` PRIMARY KEY (`orderNumber`),
     CONSTRAINT `FK_orderDetails_orders` FOREIGN KEY (`orderNumber`) REFERENCES `orderDetails` (`orderNumber`),
     CONSTRAINT `FK_customers_orders` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`)
);

CREATE TABLE `customers` (
    `customerNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `customerName` varchar(50) NOT NULL,
    `contactLastName` varchar(25),
    `contactFirstName` varchar(25),
    `phone` varchar(10) NOT NULL,
    `addressLine1` varchar(100) NOT NULL,
    `addressLine2` varchar(100),
    `city` varchar(15) NOT NULL,
    `state` varchar(15) NOT NULL,
    `postalCode` varchar(6) NOT NULL,
    `country` varchar(15) NOT NULL,
    `salesRepEmployeeNumber` int(11) UNSIGNED,
    `creditLimit` decimal(11, 2) UNSIGNED,
     CONSTRAINT `PK_customers` PRIMARY KEY (`customerNumber`),
     CONSTRAINT `UQ_customers_phone` UNIQUE (`phone`)
     CONSTRAINT `FK_employees_customers` FOREIGN KEY (`salesRepEmployeeNumber`) REFERENCES `employees` (`employeeNumber`),
);

CREATE TABLE `payments`(
    `customerNumber` int(11) UNSIGNED NOT NULL,
    `checkNumber` int(11) UNSIGNED,
    `paymentDate` datetime NOT NULL,
    `amount` decimal(11, 2) NOT NULL,
     CONSTRAINT `PK_payments` PRIMARY KEY (`customerNumber`, `checkNumber`),
     CONSTRAINT `UQ_payments_checkNumber` UNIQUE (`checkNumber`)
     CONSTRAINT `FK_customers_payments` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`),
)

1 reply

ps030300 Mar 13, 2022

CREATE TABLE `employees`(
    `employeeNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `lastName` varchar(50) NOT NULL,
    `firstName` varchar(50) NOT NULL,
    `extension` varchar(50),
    `email` varchar(50) NOT NULL,
    `officeCode` int(11),
    `reportsTo` int(11),
    `jobTitle` varchar(50),
    CONSTRAINT `PK_employees` PRIMARY KEY (`employeeNumber`),
    CONSTRAINT `UQ_employees_email` UNIQUE (`email`),
    CONSTRAINT `FK_offices_employees` FOREIGN KEY (`officeCode`) REFERENCES `offices` (`officeCode`),
    CONSTRAINT `FK_employees_employees` FOREIGN KEY (`reportsTo`) REFERENCES `employees`(`employeeNumber`)   
);

CREATE TABLE `offices`(
    `officeCode` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `city` varchar(25) NOT NULL,
    `phone` varchar(10) NOT NULL,
    `addressLine1` varchar(75) NOT NULL,
    `addressLine2` varchar(75) DEFAULT NULL,
    `state` varchar(15) NOT NULL,
    `country` varchar(15) NOT NULL,
    `postalCode` int(8) NOT NULL,
    `territory` varchar(15) NOT NULL,
     CONSTRAINT `PK_offices` PRIMARY KEY (`officeCode`),
     CONSTRAINT `UQ_offices_phone` UNIQUE (`phone`)
);

CREATE TABLE `products`(
    `productCode` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productName` varchar(50) NOT NULL,
    `productLine` int(11) UNSIGNED NOT NULL,
    `productScale` varchar(25),
    `productVendor` varchar(30) NOT NULL,
    `productDescription` varchar(100),
    `quantityInStock` int(11) UNSIGNED NOT NULL,
    `buyPrice` decimal(11, 2) UNSIGNED NOT NULL,
    `MSRP` decimal(11, 2) UNSIGNED NOT NULL,
     CONSTRAINT `PK_products` PRIMARY KEY (`productCode`),
     CONSTRAINT `UQ_products_productName` UNIQUE (`productName`),
     CONSTRAINT `FK_productLines_products` FOREIGN KEY (`productLine`) REFERENCES `productLines` (`productLines`)
);

CREATE TABLE `productLines` (
    `productLine` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `textDescription` varchar(255),
    `htmlDescription` varchar(255),
    `image` varchar(255),
     CONSTRAINT `PK_productLines` PRIMARY KEY (`productLine`),
);

CREATE TABLE `orderDetails` (
    `orderNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productCode` int(11) UNSIGNED NOT NULL,
    `quantityOrdered` int(11) UNSIGNED NOT NULL,
    `priceEach` decimal(11,2) NOT NULL,
    `orderLineNumber` int(11),
     CONSTRAINT `PK_orderDetails` PRIMARY KEY (`orderNumber`, `productCode`),
     CONSTRAINT `FK_orderDetails_productCode` FOREIGN KEY (`productCode`) REFERENCES `products` (`productCode`)
);

CREATE TABLE `orders` (
    `orderNumber` int(11) UNSIGNED NOT NULL,
    `orderDate` datetime NOT NULL,
    `requiredDate` datetime,
    `shippedDate` datetime NOT NULL,
    `status` varchar(255) NOT NULL,
    `comments` varchar(255),
    `customerNumber` int(11) UNSIGNED NOT NULL,
     CONSTRAINT `PK_orders` PRIMARY KEY (`orderNumber`),
     CONSTRAINT `FK_orderDetails_orders` FOREIGN KEY (`orderNumber`) REFERENCES `orderDetails` (`orderNumber`),
     CONSTRAINT `FK_customers_orders` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`)
);

CREATE TABLE `customers` (
    `customerNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `customerName` varchar(50) NOT NULL,
    `contactLastName` varchar(25),
    `contactFirstName` varchar(25),
    `phone` varchar(10) NOT NULL,
    `addressLine1` varchar(100) NOT NULL,
    `addressLine2` varchar(100),
    `city` varchar(15) NOT NULL,
    `state` varchar(15) NOT NULL,
    `postalCode` varchar(6) NOT NULL,
    `country` varchar(15) NOT NULL,
    `salesRepEmployeeNumber` int(11) UNSIGNED,
    `creditLimit` decimal(11, 2) UNSIGNED,
     CONSTRAINT `PK_customers` PRIMARY KEY (`customerNumber`),
     CONSTRAINT `UQ_customers_phone` UNIQUE (`phone`)
     CONSTRAINT `FK_employees_customers` FOREIGN KEY (`salesRepEmployeeNumber`) REFERENCES `employees` (`employeeNumber`),
);

CREATE TABLE `payments`(
    `customerNumber` int(11) UNSIGNED NOT NULL,
    `checkNumber` int(11) UNSIGNED,
    `paymentDate` datetime NOT NULL,
    `amount` decimal(11, 2) NOT NULL,
     CONSTRAINT `PK_payments` PRIMARY KEY (`customerNumber`, `checkNumber`),
     CONSTRAINT `UQ_payments_checkNumber` UNIQUE (`checkNumber`)
     CONSTRAINT `FK_customers_payments` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`),
)

rakeshGit419 · 2022-03-11T06:46:20Z

rakeshGit419
Mar 11, 2022

CREATE DATABASE IF NOT EXISTS first_db;
USE first_db;

CREATE TABLE `productlines` (
    `productLine` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `textDescription` VARCHAR(100) NOTNULL,
    `htmlDescription` VARCHAR(100) NOTNULL,
    `image` VARCHAR(50) DEFAULT NULL,
    CONSTRAIT `prodLine_users` PRIMARY KEY('productLine')
)

CREATE TABLE `employees` (
    `employeeNumber` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `lastName` VARCHAR(20) DEFAULT NULL,
    `firstName` VARCHAR(20) NOTNULL,
    `extension` VARCHAR(10) DEFAULT NULL,
    `email` varchar(20) DEFAULT NULL, 
    `officeCode` VARCHAR(6) NOTNULL UNIQUE,
    `reportsTo` VARCHAR(20) NOTNULL,
    `jobTitle` VARCHAR(20) NOTNULL,
    CONSTRAIT `emp_id` PRIMARY KEY('employeeNumber'),
    CONSTRAINT `emp_email` UNIQUE (`email`),
    INDEX `IDX_email` (`email`),
    INDEX `IDX_emp_username_password` (`username`, `password`)
)

CREATE TABLE `offices` (
    `officeCode` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `city` VARCHAR(20) DEFAULT NULL,
    `phone` VARCHAR(50) DEFAULT NULL,
    `addressLine1` VARCHAR(50) NOTNULL,
    `addressLine2` VARCHAR(50) DEFAULT NULL,
    `state` VARCHAR(30) NOTNULL, 
    `country` varchar(30) NOTNULL, 
    `postalCode` varchar(10) NOTNULL UNIQUE, 
    `territory` varchar(30) DEFAULT NULL, 
    CONSTRAIT `office_emp` PRIMARY KEY('officeCode'),
    CONSTRAIT `emp_phone` UNIQUE ('phone'),
    CONSTRAIT `emp_addr` UNIQUE ('postalCode'),
    INDEX 'IDX_city' ('city'),
    INDEX 'IDX_country' ('country'),
    INDEX 'IDX_phone' ('phone')
)

CREATE TABLE `products` (
    `productCode` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productName` VARCHAR(50) NOTNULL,
    `productLine` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productScale` VARCHAR(20) NOT NULL,
    `productVendor` VARCHAR(20) NOT NULL,
    `productDescription` VARCHAR(100) DEFAULT NULL,
    `quantityInStock` int(10) DEFAULT NULL,
    `buyPrice` VARCHAR(20) NOT NULL,
    `MSRP` VARCHAR(20) NOT NULL,
    CONSTRAIT `prod_code` PRIMARY KEY(`productCode`),
    INDEX `prod_vendor` (`productVendor`);
    INDEX `prod_quant` (`quantityInStock`);
    INDEX `prod_line` (`productLine`);
)

CREATE TABLE `customers` (
    `customerNumber` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `customerName` VARCHAR(20) NOTNULL,
    `customerLastName` VARCHAR(20) DEFAULT NULL,
    `customerFirstName` VARCHAR(20) DEFAULT NULL,
    `phone` VARCHAR(50) DEFAULT NULL,
    `addressLine1` VARCHAR(50) NOTNULL,
    `addressLine2` VARCHAR(50) DEFAULT NULL,
    `state` VARCHAR(30) NOTNULL, 
    `country` varchar(30) NOTNULL, 
    `postalCode` varchar(10) NOTNULL UNIQUE, 
    `creditLimit` varchar(20) DEFAULT NULL,
    `salesRepEmployeeNumber` int(10) UNSIGNED NOTNULL UNIQUE,

    CONSTRAIT `prodLine_users` PRIMARY KEY(`productLine`),
    CONSTRAIT `emp_phone` UNIQUE (`phone`),
    CONSTRAIT `emp_addr` UNIQUE (`postalCode`),
    CONSTRAIT `emp_sales` UNIQUE (`salesRepEmployeeNumber`),
    INDEX `IDX_city` (`city`),
    INDEX `IDX_country` (`country`),
    INDEX `IDX_phone` (`phone`)
)

CREATE TABLE `orderdetails` (
    `orderNumber` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productCode` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productCode` VARCHAR(100) NOTNULL,
    `quantityOrdered` VARCHAR(50) NOTNULL,
    `priceEach` VARCHAR(50) NOTNULL,
    `quantityOrdered` VARCHAR(50) NOTNULL,
    CONSTRAIT `order_num_code` PRIMARY KEY('orderNumber',`productCode`),
    CONSTRAIT `order_line_num` UNIQUE (`orderLineNumber`)
)

CREATE TABLE `orders` (
    `orderNumber` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `orderDate` VARCHAR(100) NOTNULL,
)

0 replies

Sarfinaa · 2022-03-11T06:47:01Z

Sarfinaa
Mar 11, 2022

CREATE DATABASE IF NOT EXISTS db;
use db;
create table `productlines`(
`productLine` varchar(25) not null,
`textDescription`  varchar(25) default null,
`htmIDescription`  varchar(25) default null,
`image` varchar(25) default null,
CONSTRAINT `PK_productlines` primary key(`productLine`)
);
create table `products`(
`productCode` int unsigned not null,
`productName` varchar(25) default null,
`productLine` varchar(25) default null,
`productScale` varchar(40 ) default null,
`productVendor` varchar(30) default null,
`productDescription` varchar(40) default null,
`quantitylnStock` int default null,
`buyPrice` int default null,
`MSRP` int default null,
CONSTRAINT `FK_prductLine_Products` foreign key(`productLine`) references `productLines`(`productLine`) 
);
create table `orderdetails`(
`orderNumber` int not null,
`productCode` varchar(25) not null,
`quantityOrdered` int default null,
`priceEach` int default null,
`orderLineNumber` int default null,
CONSTRAINT `PK_orderdetails` primary key(`orderNumber`,`productCode`)
);

0 replies

Harshita-Joshi · 2022-03-11T06:47:13Z

Harshita-Joshi
Mar 11, 2022

CREATE DATABASE IF NOT EXISTS product_details CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

show databases;

USE product_details;

CREATE TABLE productlines(
-> productLine varchar(50) NOT NULL,
-> textDescription varchar(1000) DEFAULT NULL,
-> htmlDescription longtext,
-> image blob,
-> CONSTRAINT PK_productlines PRIMARY KEY (productLine)
-> )ENGINE=InnoDB;

CREATE TABLE products(
-> productCode varchar(10) NOT NULL,
-> productName varchar(20) NOT NULL,
-> productLine varchar(50) NOT NULL,
-> productScale varchar(8) NOT NULL,
-> productVendor varchar(20) NOT NULL,
-> productDescription longtext NOT NULL,
-> quantityInStock smallint(5) NOT NULL,
-> buyPrice decimal(8,2) NOT NULL,
-> MSRP decimal(8,2) NOT NULL,
-> CONSTRAINT PK_products PRIMARY KEY (productCode),
-> CONSTRAINT FK_productlines_products FOREIGN KEY (productLine) REFERENCES productlines (productLine)
-> )ENGINE=InnoDB;

CREATE TABLE offices(
-> officeCode varchar(5) NOT NULL,
-> city varchar(20) NOT NULL,
-> phone char(10) NOT NULL,
-> addressLine1 varchar(100) NOT NULL,
-> addressLine2 varchar(100) DEFAULT NULL,
-> state varchar(20) NOT NULL,
-> country varchar(50) NOT NULL,
-> postalCode varchar(10) NOT NULL,
-> territory varchar(20) NOT NULL,
-> CONSTRAINT PK_offices PRIMARY KEY (officeCode)
-> )ENGINE=InnoDB;

CREATE TABLE employees(
-> employeeNumber int(10) NOT NULL,
-> lastName varchar(30) DEFAULT NULL,
-> firstName varchar(30) NOT NULL,
-> extension varchar(15) NOT NULL,
-> email varchar(100) NOT NULL,
-> officeCode varchar(5) NOT NULL,
-> reportsTo int(10) DEFAULT NULL,
-> jobTitle varchar(20) NOT NULL,
-> CONSTRAINT PK_employees PRIMARY KEY (employeeNumber),
-> CONSTRAINT FK_employees_employees FOREIGN KEY (reportsTo) REFERENCES employees (employeeNumber),
-> CONSTRAINT FK_offices_employees FOREIGN KEY (officeCode) REFERENCES offices (officeCode)
-> )ENGINE=InnoDB;

CREATE TABLE customers(
-> customerNumber int(11) NOT NULL,
-> customerName varchar(50) NOT NULL,
-> contactLastName varchar(50) NOT NULL,
-> contactFirstName varchar(50) NOT NULL,
-> phone char(10) NOT NULL,
-> addressLine1 varchar(100) NOT NULL,
-> addressLine2 varchar(100) DEFAULT NULL,
-> city varchar(20) NOT NULL,
-> state varchar(20) NOT NULL,
-> postalCode varchar(10) NOT NULL,
-> country varchar(50) NOT NULL,
-> salesRepEmployeeNumber int(10) DEFAULT NULL,
-> CONSTRAINT PK_customers PRIMARY KEY (customerNumber),
-> CONSTRAINT FK_employees_customers FOREIGN KEY (salesRepEmployeeNumber) REFERENCES employees (employeeNumber)
-> )ENGINE=InnoDB;

CREATE TABLE payments(
-> customerNumber int(11) NOT NULL,
-> checkNumber varchar(20) NOT NULL,
-> paymentDate date NOT NULL,
-> amount decimal(8,2) NOT NULL,
-> CONSTRAINT PK_payments PRIMARY KEY (customerNumber,checkNumber),
-> CONSTRAINT FK_customers_payments FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber)
-> )ENGINE=InnoDB;

CREATE TABLE orders(
-> orderNumber int(11) NOT NULL UNIQUE,
-> orderDate date NOT NULL,
-> requiredDate date NOT NULL,
-> shippedDate date DEFAULT NULL,
-> status varchar(10) NOT NULL,
-> comments mediumtext,
-> customerNumber int(11) NOT NULL,
-> CONSTRAINT PK_orders PRIMARY KEY (orderNumber),
-> CONSTRAINT FK_customers_orders FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber)
-> )ENGINE=InnoDB;

CREATE TABLE orderdetails(
-> orderNumber int(11) NOT NULL,
-> productCode varchar(10) NOT NULL,
-> quantityOrdered int(11) NOT NULL,
-> priceEach decimal(10,2) NOT NULL,
-> orderLineNumber mediumint(6) NOT NULL,
-> CONSTRAINT PK_orderdetails PRIMARY KEY (orderNumber,productCode),
-> CONSTRAINT FK_products_orderdetails FOREIGN KEY (productCode) REFERENCES products (productCode)
-> )ENGINE=InnoDB;

0 replies

aish955 · 2022-03-11T06:48:03Z

aish955
Mar 11, 2022

CREATE TABLE employees (
employeenumber int(11) UNSIGNED NOT NULL ,
lastname varchar(25) NOT NULL,
firstname varchar(25) NOT NULL,
extension varchar(50) DEFAULT NULL,
email varchar(50) not NULL,
officecode int(11) UNSIGNED NOT NULL,
reportsto varchar(25) NOT NULL,
jobtitle varchar(25) NOT NULL,
CONSTRAINT PK_employees PRIMARY KEY (employeenumber),
CONSTRAINT UQ_employees_email UNIQUE (email)
)

CREATE TABLE products (
productcode int(11) UNSIGNED NOT NULL ,
productname varchar(25) NOT NULL,
productline varchar(25) NOT NULL,
productvendor varchar(50) DEFAULT NULL,
productdescription varchar(500) DEFAULT NULL,
quantityinstock int(11) UNSIGNED,
buyprice int(11) UNSIGNED not null,
msrp int(11) UNSIGNED not null,

CONSTRAINT PK_products PRIMARY KEY (productcode)
)

CREATE TABLE customers (
customernumber int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
customername varchar(25) NOT NULL,
lastname varchar(25) NOT NULL,
firstname varchar(25) NOT NULL,
phone varchar(10) DEFAULT NULL,
addressline1 varchar(50) not NULL,
addressline2 varchar(50) default NULL,
city varchar(50) not NULL,
state varchar(50) not NULL,
postalcode int(11) UNSIGNED NOT NULL,
country varchar(50) not NULL,
salesrepemployeenumber int(11) UNSIGNED NOT NULL unique,
creditlimit int(11) UNSIGNED NOT NULL,

CONSTRAINT PK_customers PRIMARY KEY (customernumber),
CONSTRAINT FK_employees_customers FOREIGN KEY (salesRepEmployeeNumber) REFERENCES employees (employeeNumber)
CONSTRAINT CHK_customers_phone CHECK(phone is null or phone regexp '^[0-9]{10}$')
)

CREATE TABLE offices (
officecode int(11) UNSIGNED NOT NULL unique ,
city varchar(50) not NULL,
phone varchar(10) DEFAULT NULL,
addressline1 varchar(50) not NULL,
addressline2 varchar(50) default NULL,
state varchar(50) not NULL,
country varchar(50) not NULL,
postalcode int(11) UNSIGNED NOT NULL,
territory varchar(50) not NULL,

CONSTRAINT CHK_offices_phone CHECK(phone is null or phone regexp '^[0-9]{10}$')
CONSTRAINT PK_offices PRIMARY KEY (officecode)

)

CREATE TABLE productlines (
productline varchar(50) NOT NULL,

textdescription varchar(50) not NULL,
htmldescription varchar(50) not NULL,
image varchar(50) default NULL,

CONSTRAINT PK_productlines PRIMARY KEY (productline)

)

CREATE TABLE orderdetails (
ordernumber int(11) UNSIGNED NOT NULL unique ,
productcode int(11) UNSIGNED NOT NULL ,
quantityordered int(11) UNSIGNED,
priceeach int(11) UNSIGNED not null,
orderlinenumber int(11) UNSIGNED NOT NULL unique ,

CONSTRAINT PK_orderdetails PRIMARY KEY (ordernumber),
CONSTRAINT FK_orderDetails_productCode FOREIGN KEY (productCode) REFERENCES products (productCode)

)

0 replies

hemanth409 · 2022-03-11T06:48:25Z

hemanth409
Mar 11, 2022

CREATE DATABASE IF NOT EXISTS first_db;
USE first_db;

CREATE TABLE productlines (
productLine int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
textDescription VARCHAR(20) NOTNULL,
htmlDescription VARCHAR(20) NOTNULL,
image VARCHAR(50) DEFAULT NULL,
CONSTRAIT prodLine_users PRIMARY KEY('productLine')
)

CREATE TABLE employees (
employeeNumber int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
lastName VARCHAR(40) DEFAULT NULL,
firstName VARCHAR(45) NOTNULL,
extension VARCHAR(12) DEFAULT NULL,
email varchar(20) DEFAULT NULL,
officeCode VARCHAR(6) NOTNULL UNIQUE,
reportsTo VARCHAR(20) NOTNULL,
jobTitle VARCHAR(20) NOTNULL,
CONSTRAIT emp_id PRIMARY KEY('employeeNumber'),
CONSTRAINT emp_email UNIQUE (email),
INDEX IDX_email (email),
INDEX IDX_emp_username_password (username, password)
)

CREATE TABLE offices (
officeCode int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
city VARCHAR(20) DEFAULT NULL,
phone VARCHAR(50) DEFAULT NULL,
addressLine1 VARCHAR(50) NOTNULL,
addressLine2 VARCHAR(50) DEFAULT NULL,
state VARCHAR(30) NOTNULL,
country varchar(30) NOTNULL,
postalCode varchar(10) NOTNULL UNIQUE,
territory varchar(30) DEFAULT NULL,
CONSTRAIT office_emp PRIMARY KEY('officeCode'),
CONSTRAIT emp_phone UNIQUE ('phone'),
CONSTRAIT emp_addr UNIQUE ('postalCode'),
INDEX 'IDX_city' ('city'),
INDEX 'IDX_country' ('country'),
INDEX 'IDX_phone' ('phone')
)

CREATE TABLE products (
productCode int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
productName VARCHAR(50) NOTNULL,
productLine int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
productScale VARCHAR(20) NOT NULL,
productVendor VARCHAR(20) NOT NULL,
productDescription VARCHAR(100) DEFAULT NULL,
quantityInStock int(10) DEFAULT NULL,
buyPrice VARCHAR(20) NOT NULL,
MSRP VARCHAR(20) NOT NULL,
CONSTRAIT prod_code PRIMARY KEY(productCode),
INDEX prod_vendor (productVendor);
INDEX prod_quant (quantityInStock);
INDEX prod_line (productLine);
)

CREATE TABLE customers (
customerNumber int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
customerName VARCHAR(20) NOTNULL,
customerLastName VARCHAR(20) DEFAULT NULL,
customerFirstName VARCHAR(20) DEFAULT NULL,
phone VARCHAR(50) DEFAULT NULL,
addressLine1 VARCHAR(50) NOTNULL,
addressLine2 VARCHAR(50) DEFAULT NULL,
state VARCHAR(30) NOTNULL,
country varchar(30) NOTNULL,
postalCode varchar(10) NOTNULL UNIQUE,
creditLimit varchar(20) DEFAULT NULL,
salesRepEmployeeNumber int(10) UNSIGNED NOTNULL UNIQUE,

CONSTRAIT `prodLine_users` PRIMARY KEY(`productLine`),
CONSTRAIT `emp_phone` UNIQUE (`phone`),
CONSTRAIT `emp_addr` UNIQUE (`postalCode`),
CONSTRAIT `emp_sales` UNIQUE (`salesRepEmployeeNumber`),
INDEX `IDX_city` (`city`),
INDEX `IDX_country` (`country`),
INDEX `IDX_phone` (`phone`)

)

0 replies

Ashwesh09 · 2022-03-11T06:49:05Z

Ashwesh09
Mar 11, 2022

CREATE DATABASE IF NOT EXISTS retail_business CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE retail_business;
CREATE TABLE 'customers'(
    'customerNumber' UNSIGNED int(11) NOT NULL AUTO_INCREMENT,
    'customerName' varchar(25) DEFAULT NULL,
    'contactLastName' varchar(25) DEFAULT NULL,
    'contactFirstName' varchar(25) DEFAULT NULL,
    'phone' varchar(10) DEFAULT NULL,
    'addressLine1' varchar(50) DEFAULT NULL,
    'addressLine2' varchar(50) DEFAULT NULL,
    'city' varchar(25) DEFAULT NULL,
    'state' varchar(25) DEFAULT NULL,
    'postalCode' varchar(6) DEFAULT NULL,
    'country' varchar(25) DEFAULT NULL,
    'salesRepEmployeeNumber' int(10) NOT NULL,
    'credLimit' varchar(50) NOT NULL,
    CONSTRAINT 'PK_customer' PRIMARY KEY ('customerNumber'),
    CONSTRAINT `CHK_customer_phone` CHECK(`phone` is null or `phone` regexp '^[0-9]{10}$'),
    CONSTRAINT `FK_employees_customer` FOREIGN KEY (`salesRepEmployeeNumber`) REFERENCES `employees` (`employeeNumber`),
    INDEX 'IX_customer_customerName' ('customerName'),
)ENGINE = InnoDB;

CREATE TABLE `employees`(
    'employeeNumber' UNSIGNED int(11) NOT NULL AUTO_INCREMENT,
    'lastName' varchar(25) DEFAULT NULL,
    'firstName' varchar(25) DEFAULT NULL,
    'extension' varchar(25) DEFAULT NULL,
    'email' varchar(25) DEFAULT NULL,
    'officeCode' UNSIGNED int(5) DEFAULT NULL,
    'reportsTo' varchar(25) DEFAULT NULL,
    'jobTitle' varchar(25) NOT NULL,
    CONSTRAINT `PK_employees` PRIMARY KEY ('employeeNumber'),
    CONSTRAINT `UQ_employees_email` UNIQUE ('email'),
    CONSTRAINT `FK_offices_employees` FOREIGN KEY (`officeCode`) REFERENCES `office` (`officeCode`),
    CONSTRAINT `FK_employees_employees` FOREIGN KEY (`reportsTo`) REFERENCES `employees`(`employeeNumber`),
    INDEX `IX_employees_email` (`email`)
)ENGINE=InnoDB;

CREATE TABLE `offices`(
    'officeCode' UNSIGNED int(11) DEFAULT NULL,
    'city' varchar(25) DEFAULT NULL,
    'phone' varchar(10) DEFAULT NULL,
    'addressLine1' varchar(50) DEFAULT NULL,
    'addressLine2' varchar(50) DEFAULT NULL,
    'state' varchar(25) DEFAULT NULL,
    'country' varchar(25) DEFAULT NULL,
    'postalCode' varchar(6) DEFAULT NULL,
    'territory' varchar(25) DEFAULT NULL,
    CONSTRAINT 'PK_offices' PRIMARY KEY ('officeCode'),
    CONSTRAINT `CHK_offices_phone` CHECK(`phone` is null or `phone` regexp '^[0-9]{10}$'),
    INDEX `IX_offices_postalCode` (`postalCode`)
)ENGINE = InnoDB;

CREATE TABLE `productlines`(
    'productLine' VARCHAR(25) NOT NULL,
    'textDescription' VARCHAR(255) DEFAULT NULL,
    'htmlDescription' VARCHAR(50),
    'image' VARCHAR(50) DEFAULT NULL,
    CONSTRAINT `PK_productLine` PRIMARY KEY (`productLine`),
)
 CREATE TABLE `product`(
     'productCode' int(11) NOT NULL,
     'productName' VARCHAR(255) DEFAULT NULL,
     'productLine' VARCHAR(50) DEFAULT NULL,
     'productScale' VARCHAR(50) DEFAULT NULL,
     'productVendor' VARCHAR(50) DEFAULT NULL,
     'productDescription' VARCHAR(255) DEFAULT NULL,
     'qunatityInStock' UNSIGNED int(5) DEFAULT NULL,
     'buyPrice' int(6) UNSIGNED DEFAULT NULL,
     'MSRP' int(6) UNSIGNED DEFAULT NULL,
     CONSTRAINT `PK_product` PRIMARY KEY (`productCode`),
     CONSTRAINT `FK_productLine_products` FOREIGN KEY (`productLine`) REFERENCES `productlines` (`productLine`),
     INDEX `IX_products_productName` (`productName`)
 )ENGINE=InnoDB;

 CREATE TABLE `orderdetails` (
     'orderNumber' int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
     'productCode' int(11) UNSIGNED DEFAULT NULL,
     'quantityOrdered' tinyint(2) UNSIGNED DEFAULT NULL,
     'priceEach' int(5) UNSIGNED DEFAULT NULL,
     'orderLineNumber' int(11) UNSIGNED DEFAULT NULL,
     CONSTRAINT `PK_orderDetails` PRIMARY KEY (`orderNumber`,`productCode`),
     CONSTRAINT `FK_orderDetails_productCode` FOREIGN KEY (`productCode`) REFERENCES `products` (`productCode`)
)ENGINE = InnoDB;

CREATE TABLE `orders` (
    `orderNumber` int(11) UNSIGNED NOT NULL,
    `orderDate` datetime NOT NULL,
    `requiredDate` datetime,
    `shippedDate` datetime NOT NULL,
    `status` enum('SHIPPED','DELIVERED','ORDER_CONFIRMED') NOT NULL,
    `comments` varchar(255) DEFAULT NULL,
    `customerNumber` int(11) UNSIGNED NOT NULL,
     CONSTRAINT `PK_orders` PRIMARY KEY (`orderNumber`),
     CONSTRAINT `FK_orderDetails_orders` FOREIGN KEY (`orderNumber`) REFERENCES `orderDetails` (`orderNumber`),
     CONSTRAINT `FK_customers_orders` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`)
)ENGINE = InnoDB;

CREATE TABLE `payments`(
    `customerNumber` int(11) UNSIGNED NOT NULL,
    `checkNumber` int(11) UNSIGNED,
    `paymentDate` datetime NOT NULL,
    `amount` int(11) NOT NULL,
     CONSTRAINT `PK_payments` PRIMARY KEY (`customerNumber`, `checkNumber`),
     CONSTRAINT `UQ_payments_checkNumber` UNIQUE (`checkNumber`)
     CONSTRAINT `FK_customers_payments` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`),
)ENGINE = InnoDB;

0 replies

nithin1429 · 2022-03-11T06:54:02Z

nithin1429
Mar 11, 2022

CREATE database IF NOT EXISTS Company CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

USE Company;

CREATE TABLE IF NOT EXISTS productLines(
productLine int(11) UNSIGNED NOT NULL,
textDescription VARCHAR(50) DEFAULT NULL,
htmlDescription VARCHAR(50) DEFAULT NULL,
image VARCHAR(50) DEFAULT NULL,
CONSTRAINT PK_productLines PRIMARY KEY (productLine)

);

CREATE TABLE IF NOT EXISTS products(
productCode int(11) UNSIGNED NOT NULL,
productName VARCHAR(25) DEFAULT NULL,
productLine int(11) UNSIGNED NOT NULL,
productScale VARCHAR(50) DEFAULT NULL,
productVendor VARCHAR(50) DEFAULT NULL,
productDescription VARCHAR(50) DEFAULT NULL,
quantityInStock INT DEFAULT NULL,
buyPrice DOUBLE(11,2) UNSIGNED DEFAULT NULL,
MSRP DOUBLE(11,2) UNSIGNED DEFAULT NULL,
CONSTRAINT PK_products PRIMARY KEY (productCode),
CONSTRAINT FK_productLines_products FOREIGN KEY (productLine) REFERENCES productLines (productLine)

);

CREATE TABLE IF NOT EXISTS employees(
employeeNumber int(11) UNSIGNED NOT NULL,
lastName VARCHAR(25) DEFAULT NULL,
firstname VARCHAR(25) DEFAULT NULL,
extension enum('Mr.','Mrs.','Ms.') DEFAULT NULL,
email VARCHAR(50) DEFAULT NULL,
officeCode INT(11) UNSIGNED NOT NULL,
reportsTo VARCHAR(50) DEFAULT NULL,
jobTitle VARCHAR(50) DEFAULT NULL,
CONSTRAINT PK_employees PRIMARY KEY (employeeNumber),
CONSTRAINT FK_offices_employees FOREIGN KEY (officeCode) REFERENCES offices (officeCode)
);

CREATE TABLE IF NOT EXISTS customers(
customerNumber int(11) UNSIGNED NOT NULL,
customerName VARCHAR(50) DEFAULT NULL,
contactlastName VARCHAR(25) DEFAULT NULL,
contactfirstname VARCHAR(25) DEFAULT NULL,
phone VARCHAR(10) DEFAULT NULL,
addressLine1 VARCHAR(255) DEFAULT NULL,
addressLine2 VARCHAR(255) DEFAULT NULL,
city VARCHAR(50) DEFAULT NULL,
state VARCHAR(50) DEFAULT NULL,
postalCode INT(10) NOT NULL,
country VARCHAR(25) DEFAULT NULL,
salesRepEmployeeNumber int(11) UNSIGNED NOT NULL,
creditLimit VARCHAR(10) DEFAULT NULL,
CONSTRAINT PK_customers PRIMARY KEY (customerNumber),
CONSTRAINT CHK_customers_phone CHECK(phone is null or phone regexp '^[0-9]{10}$'),
CONSTRAINT FK_employees_customers FOREIGN KEY (salesRepEmployeeNumber) REFERENCES employees (employeeNumber)
);

CREATE TABLE IF NOT EXISTS offices (
officeCode int(11) UNSIGNED NOT NULL,
city VARCHAR(50) DEFAULT NULL,
phone VARCHAR(10) DEFAULT NULL,
addressLine1 VARCHAR(255) DEFAULT NULL,
addressLine2 VARCHAR(255) DEFAULT NULL,
state VARCHAR(50) DEFAULT NULL,
countryVARCHAR(25) DEFAULT NULL,
postalCodeINT(10) NOT NULL,
territoryVARCHAR(255) DEFAULT NULL,
CONSTRAINT PK_offices PRIMARY KEY (officeCode),
CONSTRAINT CHK_offices_phone CHECK(phone is null or phone regexp '^[0-9]{10}$')
);

CREATE TABLE IF NOT EXISTS payments(
customerNumber int(11) UNSIGNED NOT NULL,
checkNumber INT(11) UNSIGNED NOT NULL,
paymentDate DATE NOT NULL,
amount DOUBLE(11,2) UNSIGNED NOT NULL,
CONSTRAINT PK_payments PRIMARY KEY (customerNumber,checkNumber),
CONSTRAINT FK_customers_payments FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber)
);

CREATE TABLE IF NOT EXISTS orders (
orderNumberint(11) UNSIGNED NOT NULL,
orderDate DATE NOT NULL,
requiredDate DATE NOT NULL,
shippedDate DATE DEFAULT NULL,
status enum('Delivered','Shipped','Confirmed') DEFAULT NULL,
comments VARCHAR(50) DEFAULT NULL,
customerNumberint(11) UNSIGNED NOT NULL,
CONSTRAINT PK_orders PRIMARY KEY (orderNumber),
CONSTRAINT FK_customers_orders FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber)
);

0 replies

Ashritha-sd · 2022-03-11T06:54:10Z

Ashritha-sd
Mar 11, 2022

create table `offices` (
 `officeCode` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `city` varchar(25) DEFAULT NULL,
 `phone` varchar(10) DEFAULT NULL,
 `addressLine1` varchar(50) DEFAULT NULL,
 `addressLine2` varchar(50) DEFAULT NULL,
 `state` varchar(30) DEFAULT NULL,
 `country` varchar(30) DEFAULT NULL,
 `postalCode` varchar(6) DEFAULT NULL,
 `territory` varchar(30) DEFAULT NULL,
 CONSTRAINT `PK_OfficeCode` PRIMARY KEY (`officeCode`),
 CONSTRAINT `CHK_offices_phone` CHECK(`phone` is null or `phone` regexp '^[0-9]{10}$'),
);



create table `employees` (
 `employeeNumber` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `lastName` varchar(25) DEFAULT NULL,
 `firstName` varchar(25) DEFAULT NULL,
 `extension` varchar(25) DEFAULT NULL,
 `email` varchar(50) DEFAULT NULL,
 `officeCode` int(10) UNSIGNED NOT NULL,
 `reportsTo` int(10) NOT NULL,
 `jobTitle` varchar(25) DEFAULT NULL,
 CONSTRAINT `PK_employeeNumber` PRIMARY KEY (`employeeNumber`)),
 CONSTRAINT `UQ_employee_email` UNIQUE (`email`),
 CONSTRAINT FK_employees_officeCode FOREIGN KEY (`officeCode`) REFERENCES `offices` (`officeCode`),
 CONSTRAINT FK_employees_reportsTo FOREIGN KEY (`officeCode`) REFERENCES `employees` (`employeeNumber`)
);

0 replies

Mrafe · 2022-03-11T06:59:47Z

Mrafe
Mar 11, 2022

CREATE DATABASE IF NOT EXISTS C202 CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

use C202;

CREATE TABLE `productlines` (
    `productLine` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `textDescription` VARCHAR(100) NOTNULL,
    `htmlDescription` VARCHAR(100) NOTNULL,
    `image` VARCHAR(50) DEFAULT NULL,
    CONSTRAIT `prodLine_users` PRIMARY KEY('productLine')
)

CREATE TABLE `employees` (
    `employeeNumber` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `lastName` VARCHAR(20) DEFAULT NULL,
    `firstName` VARCHAR(20) NOTNULL,
    `extension` VARCHAR(10) DEFAULT NULL,
    `email` varchar(20) DEFAULT NULL, 
    `officeCode` VARCHAR(6) NOTNULL UNIQUE,
    `reportsTo` VARCHAR(20) NOTNULL,
    `jobTitle` VARCHAR(20) NOTNULL,
    CONSTRAIT `emp_id` PRIMARY KEY('employeeNumber'),
    CONSTRAINT `emp_email` UNIQUE (`email`),
    INDEX `IDX_email` (`email`),
    INDEX `IDX_emp_username_password` (`username`, `password`)
)

CREATE TABLE `offices` (
    `officeCode` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `city` VARCHAR(20) DEFAULT NULL,
    `phone` VARCHAR(50) DEFAULT NULL,
    `addressLine1` VARCHAR(50) NOTNULL,
    `addressLine2` VARCHAR(50) DEFAULT NULL,
    `state` VARCHAR(30) NOTNULL, 
    `country` varchar(30) NOTNULL, 
    `postalCode` varchar(10) NOTNULL UNIQUE, 
    `territory` varchar(30) DEFAULT NULL, 
    CONSTRAIT `office_emp` PRIMARY KEY('officeCode'),
    CONSTRAIT `emp_phone` UNIQUE ('phone'),
    CONSTRAIT `emp_addr` UNIQUE ('postalCode'),
    INDEX 'IDX_city' ('city'),
    INDEX 'IDX_country' ('country'),
    INDEX 'IDX_phone' ('phone')
)

CREATE TABLE `products` (
    `productCode` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productName` VARCHAR(50) NOTNULL,
    `productLine` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productScale` VARCHAR(20) NOT NULL,
    `productVendor` VARCHAR(20) NOT NULL,
    `productDescription` VARCHAR(100) DEFAULT NULL,
    `quantityInStock` int(10) DEFAULT NULL,
    `buyPrice` VARCHAR(20) NOT NULL,
    `MSRP` VARCHAR(20) NOT NULL,
    CONSTRAIT `prod_code` PRIMARY KEY(`productCode`),
    INDEX `prod_vendor` (`productVendor`);
    INDEX `prod_quant` (`quantityInStock`);
    INDEX `prod_line` (`productLine`);
)

CREATE TABLE `customers` (
    `customerNumber` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `customerName` VARCHAR(20) NOTNULL,
    `customerLastName` VARCHAR(20) DEFAULT NULL,
    `customerFirstName` VARCHAR(20) DEFAULT NULL,
    `phone` VARCHAR(50) DEFAULT NULL,
    `addressLine1` VARCHAR(50) NOTNULL,
    `addressLine2` VARCHAR(50) DEFAULT NULL,
    `state` VARCHAR(30) NOTNULL, 
    `country` varchar(30) NOTNULL, 
    `postalCode` varchar(10) NOTNULL UNIQUE, 
    `creditLimit` varchar(20) DEFAULT NULL,
    `salesRepEmployeeNumber` int(10) UNSIGNED NOTNULL UNIQUE,

    CONSTRAIT `prodLine_users` PRIMARY KEY(`productLine`),
    CONSTRAIT `emp_phone` UNIQUE (`phone`),
    CONSTRAIT `emp_addr` UNIQUE (`postalCode`),
    CONSTRAIT `emp_sales` UNIQUE (`salesRepEmployeeNumber`),
    INDEX `IDX_city` (`city`),
    INDEX `IDX_country` (`country`),
    INDEX `IDX_phone` (`phone`)
)

CREATE TABLE `orderdetails` (
    `orderNumber` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productCode` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productCode` VARCHAR(100) NOTNULL,
    `quantityOrdered` VARCHAR(50) NOTNULL,
    `priceEach` VARCHAR(50) NOTNULL,
    `quantityOrdered` VARCHAR(50) NOTNULL,
    CONSTRAIT `order_num_code` PRIMARY KEY('orderNumber',`productCode`),
    CONSTRAIT `order_line_num` UNIQUE (`orderLineNumber`)
)

CREATE TABLE `orders` (
    `orderNumber` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `orderDate` VARCHAR(100) NOTNULL,
)

0 replies

Khyati-tripathi · 2022-03-11T07:01:13Z

Khyati-tripathi
Mar 11, 2022

CREATE TABLE `productlines` (
  `productLine` int(11) UNSIGNED NOT NULL UNIQUE,
  `textDescription` varchar(255) DEFAULT NULL, 
  `htmlDescription` varchar(255) DEFAULT NULL, 
  `image` varchar(50) DEFAULT NULL,
  CONSTRAINT `PK_productlines` PRIMARY KEY (`productLine`),
) ENGINE=InnoDB;


CREATE TABLE `products` (
  `productCode` int(11) UNSIGNED NOT NULL,
  `productName` varchar(25) NOT NULL UNIQUE,
  `productLine` int(11) UNSIGNED NOT NULL,
  `productScale` varchar(25) DEFAULT NULL,
 `productVendor` varchar(25) NOT NULL,
 `productDescription` varchar(30) DEFAULT NULL, 
 `quantityInStock` int(11) UNSIGNED NOT NULL,
 `buyPrice` int(11) UNSIGNED NOT NULL,
 `MSRP` int(11) UNSIGNED NOT NULL,
  CONSTRAINT `PK_products` PRIMARY KEY (`productCode`),
  CONSTRAINT `FK_productLines_products` FOREIGN KEY (`productLine`) REFERENCES `productLines` (`productLines`)
) ENGINE=InnoDB;


CREATE TABLE `orderdetails` (
 `orderNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT , 
  `productCode` varchar(25) NOT NULL ,
  `quantityOrdered` int(11) UNSIGNED NOT NULL,
  `priceEach` int(11) UNSIGNED DEFAULT NULL,
  `orderLineNumber` int(11) UNSIGNED DEFAULT NULL,
CONSTRAINT `PK_orderdetails` PRIMARY KEY (`orderNumber`,`productCode`),
CONSTRAINT `FK_orderDetails_productCode` FOREIGN KEY (`productCode`) REFERENCES `products` (`productCode`)
) ENGINE=InnoDB;


CREATE TABLE `employees` (
 `employeeNumber` int(11) UNSIGNED NOT NULL, 
  `lastName` varchar(25) NOT NULL,
  `firstName` varchar(25) NOT NULL,
  `extension` varchar(50) DEFAULT NULL,
  `email` varchar(50) NOT NULL, 
  `officeCode` int(11) UNSIGNED DEFAULT NULL,
  `reportsTo` varchar(25) DEFAULT NULL,
  `jobTitle` varchar(50) ,
    CONSTRAINT `PK_employees` PRIMARY KEY (`employeeNumber`),
    CONSTRAINT `UQ_employees_email` UNIQUE (`email`),
    CONSTRAINT `FK_offices_employees` FOREIGN KEY (`officeCode`) REFERENCES `offices` (`officeCode`),
    CONSTRAINT `FK_employees_employees` FOREIGN KEY (`reportsTo`) REFERENCES `employees`(`employeeNumber`)   
) ENGINE=InnoDB;


CREATE TABLE `offices` (
 `officeCode` int(11) UNSIGNED NOT NULL UNIQUE, 
  `city` varchar(25) NOT NULL,
  `phone` varchar(10) DEFAULT NULL, 
  `addressLine1` varchar(50)DEFAULT NULL ,
  `addressLine2` varchar(50)DEFAULT NULL ,
  `state` varchar(25)DEFAULT NULL ,
  `country` varchar(25)DEFAULT NULL ,
  `postalCode` int(11) UNSIGNED NOT NULL, 
  `territory` varchar(25)NOT NULL ,
  CONSTRAINT `PK_offices` PRIMARY KEY (`officeCode`),
  CONSTRAINT `CHK_users_phone` CHECK(`phone` is null or `phone` regexp '^[0-9]{10}$'),
) ENGINE=InnoDB;


CREATE TABLE `customers` (
`customerNumber` int(11) UNSIGNED NOT NULL UNIQUE, 
  `customerName` varchar(25) NOT NULL,
 `contactlastName` varchar(25) ,
  `contactfirstName` varchar(25) ,
 `phone` varchar(10) NOT NULL, 
  `addressLine1` varchar(50)NOT NULL ,
  `addressLine2` varchar(50)NOT NULL ,
  `city` varchar(25) NOT NULL,
  `state` varchar(25)NOT NULL ,
  `postalCode`varchar(10) NOT NULL, 
  `country` varchar(25)NOT NULL ,
 `salesRepEmployeeNumber` int(11) UNSIGNED ,
`creditLimit` int(11) UNSIGNED DEFAULT NULL, 
CONSTRAINT `PK_customers` PRIMARY KEY (`customerNumber`),
     CONSTRAINT `UQ_customers_phone` UNIQUE (`phone`)
     CONSTRAINT `FK_employees_customers` FOREIGN KEY (`salesRepEmployeeNumber`) REFERENCES `employees` (`employeeNumber`),
 
) ENGINE=InnoDB;


CREATE TABLE `payments` (
 `customerNumber` int(11) UNSIGNED NOT NULL, 
 `checkNumber` int(11) UNSIGNED, 
 `paymentDate` date NOT NULL, 
 `amount` decimal(11,3) UNSIGNED NOT NULL,
CONSTRAINT `PK_payments` PRIMARY KEY (`customerNumber`, `checkNumber`),
     CONSTRAINT `UQ_payments_checkNumber` UNIQUE (`checkNumber`)
     CONSTRAINT `FK_customers_payments` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`),
) ENGINE=InnoDB;


CREATE TABLE `orders` (
 `orderNumber` int(11) UNSIGNED NOT NULL, 
 `orderDate` date NOT NULL, 
 `requiredDate` date NOT NULL, 
 `shippedDate` date NOT NULL, 
  `status` varchar(25)DEFAULT NULL ,
  `comments` varchar(255)DEFAULT NULL ,
 `customerNumber` int(11) UNSIGNED NOT NULL, 
   CONSTRAINT `PK_orders` PRIMARY KEY (`orderNumber`),
     CONSTRAINT `FK_orderDetails_orders` FOREIGN KEY (`orderNumber`) REFERENCES `orderDetails` (`orderNumber`),
     CONSTRAINT `FK_customers_orders` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`)
) ENGINE=InnoDB;

0 replies

abhiraj2k · 2022-03-11T07:03:00Z

abhiraj2k
Mar 11, 2022

CREATE SCHEMA `wiley`;

CREATE TABLE wiley.products (
  productLine INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  textDescription VARCHAR(250) DEFAULT NULL,
  htmlDescription VARCHAR(250) DEFAULT NULL,
  image VARCHAR(200) DEFAULT NULL,
  PRIMARY KEY (`productLine`)
);
CREATE TABLE wiley.products (
  `productCode` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `productName` VARCHAR(50) DEFAULT NULL,
  `productLine` INT(11) UNSIGNED NOT NULL,
  `productScale` VARCHAR(45) DEFAULT NULL,
  `productVendor` VARCHAR(45) DEFAULT NULL,
  `productDescription` VARCHAR(250) DEFAULT NULL,
  `quantityInStock` INT NOT NULL,
  `buyPrice` INT NOT NULL,
  `MSRP` INT NOT NULL,
  PRIMARY KEY (`productCode`),
  CONSTRAINT `productLine`
	FOREIGN KEY (`productLine`)
	REFERENCES `wiley`.`productlines` (`productLine`)
);
CREATE TABLE wiley.orderdetails (
  orderNumber INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  productCode INT(11) UNSIGNED NOT NULL,
  quantityOrdered INT UNSIGNED DEFAULT NULL,
  priceEach INT DEFAULT NULL,
  orderLineNumber VARCHAR(50) NOT NULL,
  PRIMARY KEY (`orderNumber`,`productCode`),
  CONSTRAINT `productCode`
	FOREIGN KEY (`productCode`)
	REFERENCES `wiley`.`products` (`productCode`)
);
CREATE TABLE wiley.orders (
	orderNumber INT(11) UNSIGNED NOT NULL,
	orderDate DATETIME NOT NULL,
	requiredDate DATETIME,
	shippedDate DATETIME,
	status VARCHAR(100) NOT NULL,
	comments VARCHAR(200),
	customerNumber VARCHAR(10),
	PRIMARY KEY (orderNumber)
	);

0 replies

RohitNaikade1 · 2022-03-11T07:04:44Z

RohitNaikade1
Mar 11, 2022


create table productlines ( productline varchar(255)primary key,
			    textDescription varchar(255),
			    htmlDescription varchar(255),
			    image varchar(255)
			   );

insert into productlines values ("productline1","textDescription1","htmlDescription1","url");
			   
select * from productlines;



create table products(productCode varchar(10) primary key,
                      productName varchar(20),
                      productLine varchar(255),
                      productScale int,
                      productvendor varchar(20),
                      productDescription varchar(20),
                      quantityInStock int,
                      buyPrice int,
                      MSRP int,
                      FOREIGN KEY (productLine) REFERENCES productlines(productline)
                        );
                        
create table orderDetails ( ordernumber int primary key,
			                productCode varchar(10),
			                quantityOrdered int,
			                priceEach int,
			                orderLineNumber int,
			    FOREIGN KEY (productCode) REFERENCES products(productCode)
			   );

create table customers ( customerNumber int primary key,
			                customerName varchar(255),
			                lastName varchar(255),
			                firstName varchar(255),
			                phone int(10),
			                addressLine1 varchar(255),
			                addressLine2 varchar(255),
			                city varchar(25),
			                state varchar(255),
			                postalCode int,
			                country varchar(25),
			                salesperEmpNo int,
			                creditLimit int
			   );
                    
create table orders ( ordernumber int primary key,
			                orderDate date,
			                requiredDate date,
			                shippedDate date,
			                status varchar(25),
			                comments varchar(255),
			                customerNumber int,
			    FOREIGN KEY (ordernumber) REFERENCES orderDetails(ordernumber),
			    FOREIGN KEY (customerNumber) REFERENCES orderDetails(customerNumber)
			   );
			   
create table payments ( customerNumber int,
                        checkNumber int,
			                paymentDate date,
			                amount int,
			                CONSTRAINT PK_payments PRIMARY KEY (customerNumber,checkNumber)
			   );

create table offices ( officeCode int,
                        city varchar(255),
                        phone int(10),
                        addressLine1 varchar(255),
			            addressLine2 varchar(255),
			            state varchar(255),
			            postalCode int,
			            country varchar(25),
                        territory varchar(25)
			   );
			   
create table employees ( empNumber int primary key,
                        email varchar(255),
                        firstName varchar(255),
			            lastName varchar(255),
			            extension varchar(10),
			            officeCode int,
			            reportTo varchar(25),
			            jobTitle varchar(255),
			    FOREIGN KEY (officeCode) REFERENCES offices(officeCode)
			   );

0 replies

lalit-ky · 2022-03-11T07:05:05Z

lalit-ky
Mar 11, 2022

CREATE database IF NOT EXISTS `Company` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

USE `Company`;

CREATE TABLE IF NOT EXISTS `offices` (
    `officeCode` int(11) UNSIGNED NOT NULL,
    `city` VARCHAR(50) DEFAULT NULL,
    `phone` VARCHAR(10) DEFAULT NULL,
    `addressLine1` VARCHAR(255) DEFAULT NULL,
    `addressLine2` VARCHAR(255) DEFAULT NULL,
    `state` VARCHAR(50) DEFAULT NULL,
    `country`VARCHAR(25) DEFAULT NULL,
    `postalCode`INT(10) NOT NULL,
    `territory`VARCHAR(255) DEFAULT NULL,
    CONSTRAINT `PK_offices` PRIMARY KEY (`officeCode`),
    CONSTRAINT `CHK_offices_phone` CHECK(`phone` is null or `phone` regexp '^[0-9]{10}$')
);


CREATE TABLE IF NOT EXISTS `employees`(
    `employeeNumber` int(11) UNSIGNED NOT NULL,
    `lastName`  VARCHAR(25) DEFAULT NULL,
    `firstname` VARCHAR(25) NOT NULL,
    `extension` VARCHAR(25),
    `email` VARCHAR(50) DEFAULT NULL,
    `officeCode` INT(11) UNSIGNED,
    `reportsTo` int(11) UNSIGNED,
    `jobTitle` VARCHAR(50) DEFAULT NULL,
    CONSTRAINT `PK_employees` PRIMARY KEY (`employeeNumber`),
    CONSTRAINT `UQ_employees_email` UNIQUE (`email`),
    CONSTRAINT `FK_employees_employees` FOREIGN KEY (`reportsTo`) REFERENCES `employees`(`employeeNumber`),
    CONSTRAINT `FK_offices_employees` FOREIGN KEY (`officeCode`) REFERENCES `offices` (`officeCode`)
);

CREATE TABLE IF NOT EXISTS `customers`(
    `customerNumber` int(11) UNSIGNED NOT NULL,
    `customerName`  VARCHAR(50) DEFAULT NULL,
    `contactlastName`  VARCHAR(25) DEFAULT NULL,
    `contactfirstname` VARCHAR(25) DEFAULT NULL,
    `phone` VARCHAR(10) NOT NULL,
    `addressLine1` VARCHAR(255) DEFAULT NULL,
    `addressLine2` VARCHAR(255) DEFAULT NULL,
    `city` VARCHAR(50) DEFAULT NULL,
    `state` VARCHAR(50) DEFAULT NULL,
    `postalCode` INT(10) NOT NULL,
    `country` VARCHAR(25) NOT NULL,
    `salesRepEmployeeNumber` int(11) UNSIGNED,
    `creditLimit` decimal(11, 2) UNSIGNED DEFAULT 0,
    CONSTRAINT `PK_customers` PRIMARY KEY (`customerNumber`),
    CONSTRAINT `CHK_customers_phone` CHECK(`phone` is null or `phone` regexp '^[0-9]{10}$'),
    CONSTRAINT `UQ_customers_phone` UNIQUE (`phone`),
    CONSTRAINT `FK_employees_customers` FOREIGN KEY (`salesRepEmployeeNumber`) REFERENCES `employees` (`employeeNumber`)
);

CREATE TABLE IF NOT EXISTS `payments`(
    `customerNumber` int(11) UNSIGNED NOT NULL,
    `checkNumber` INT(11) UNSIGNED NOT NULL,
    `paymentDate` DATE NOT NULL DEFAULT (CURRENT_DATE),
    `amount` DOUBLE(11,2) UNSIGNED NOT NULL, 
    CONSTRAINT `PK_payments` PRIMARY KEY (`customerNumber`,`checkNumber`),
    CONSTRAINT `UQ_payments_checkNumber` UNIQUE (`checkNumber`),
    CONSTRAINT `FK_customers_payments` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`)
);

CREATE TABLE IF NOT EXISTS `productLines`(
    `productLine` int(11) UNSIGNED NOT NULL,
    `textDescription` VARCHAR(50) DEFAULT NULL,
    `htmlDescription` VARCHAR(50) DEFAULT NULL,
    `image` VARCHAR(50) DEFAULT NULL,
    CONSTRAINT `PK_productLines` PRIMARY KEY (`productLine`)

);

CREATE TABLE IF NOT EXISTS `products`(
    `productCode` int(11) UNSIGNED NOT NULL,
    `productName` VARCHAR(25) DEFAULT NULL,
    `productLine` int(11) UNSIGNED NOT NULL,
    `productScale` VARCHAR(50),
    `productVendor` VARCHAR(50) DEFAULT NULL,
    `productDescription` VARCHAR(100),
    `quantityInStock` INT DEFAULT NULL,
    `buyPrice`  DOUBLE(11,2) UNSIGNED DEFAULT NULL,
    `MSRP`  DOUBLE(11,2) UNSIGNED DEFAULT NULL,
    CONSTRAINT `PK_products` PRIMARY KEY (`productCode`),
    CONSTRAINT `UQ_products_productName` UNIQUE (`productName`),
    CONSTRAINT `FK_productLines_products` FOREIGN KEY (`productLine`) REFERENCES `productLines` (`productLine`)

);

CREATE TABLE IF NOT EXISTS `orderDetails`(
    `orderNumber`int(11) UNSIGNED NOT NULL,
    `productCode` int(11) UNSIGNED NOT NULL,
    `quantityOrdered` int UNSIGNED NOT NULL,
    `priceEach` DOUBLE(11,2) UNSIGNED NOT NULL,
    `orderLineNumber` int UNSIGNED NOT NULL,
    CONSTRAINT `PK_orderDetails` PRIMARY KEY (`orderNumber`,`productCode`),
    CONSTRAINT `FK_product_orderDetails` FOREIGN KEY (`productCode`) REFERENCES `products` (`productCode`)
);


CREATE TABLE IF NOT EXISTS `orders` (
    `orderNumber`int(11) UNSIGNED NOT NULL,
    `orderDate` DATE NOT NULL,
    `requiredDate` DATE NOT NULL,
    `shippedDate` DATE DEFAULT NULL,
    `status` enum('Delivered','Shipped','Confirmed','Pending') DEFAULT 'Pending',
    `comments` VARCHAR(50) DEFAULT NULL,
    `customerNumber`int(11) UNSIGNED NOT NULL,
    CONSTRAINT `PK_orders` PRIMARY KEY (`orderNumber`),
    CONSTRAINT `FK_orderDetails_orders` FOREIGN KEY (`orderNumber`) REFERENCES `orderDetails` (`orderNumber`),
    CONSTRAINT `FK_customers_orders` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`)
);

0 replies

SrideviYamala · 2022-03-11T07:13:07Z

SrideviYamala
Mar 11, 2022

CREATE TABLE `productlines` (
  `productLine` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `textDescription` varchar(255) DEFAULT NULL,
  `htmlDescription` varchar(255) DEFAULT NULL,
  `image` varchar(50) DEFAULT NULL,
  CONSTRAINT `PK_productlines` PRIMARY KEY (`productLine`),
) ENGINE=InnoDB;

CREATE TABLE `products` (
  `productCode` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `productName` varchar(25) NOT NULL,
  `productLine` int(11) UNSIGNED NOT NULL,
  `productSale` varchar(25) DEFAULT NULL,
  `productVendor` varchar(25) DEFAULT NULL,
  `productDescription` varchar(50) DEFAULT NULL,
  `quantityInStock` int(11) DEFAULT NULL,
  `buyPrice` int(11) DEFAULT NULL,
  `MSRP` int(11) DEFAULT NULL,
  CONSTRAINT `PK_products` PRIMARY KEY (`productCode`),
  CONSTRAINT FK_productlines_products FOREIGN KEY (`productLine`) REFERENCES `productlines` (`productLine`), 
) ENGINE=InnoDB;

CREATE TABLE `orderdetails` (
  `orderNumber` int(11) UNSIGNED NOT NULL,
  `productCode` int(11) NOT NULL,
  `quantityOrdered` int(11) DEFAULT NULL,
  `priceEach` int(11) DEFAULT NULL,
  `orderLineNumber` int(11) DEFAULT NULL,
  CONSTRAINT FK_orders_orderdetails FOREIGN KEY (`orderNumber`) REFERENCES `orders` (`orderNumber`),
  CONSTRAINT FK_products_orderdetails FOREIGN KEY (`productCode`) REFERENCES `products` (`productCode`), 
) ENGINE=InnoDB;

CREATE TABLE `orders` (
  `orderNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `orderDate` datetime DEFAULT CURRENT_TIMESTAMP,
  `requiredDate` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `shippedDate` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(50) DEFAULT NULL,
  `comments` varchar(255) DEFAULT NULL,
  `customerNumber` int(11) NOT NULL,
  CONSTRAINT `PK_order` PRIMARY KEY (`orderNumber`),
  CONSTRAINT FK_customers_orders FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`), 
) ENGINE=InnoDB;

CREATE TABLE `offices` (
  `officeCode` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `city` varchar(30) DEFAULT NULL,
  `phone` varchar(10) DEFAULT NULL, 
  `addressLine1` varchar(255) DEFAULT NULL,
  `addressLine2` varchar(255) DEFAULT NULL,
  `state` varchar(30) DEFAULT NULL, 
  `postalCode` varchar(6) DEFAULT NULL, 
  `country` varchar(30) DEFAULT NULL, 
  `territory` varchar(30) DEFAULT NULL, 
  CONSTRAINT `PK_offices` PRIMARY KEY (`officeCode`),
  CONSTRAINT `CHK_offices_phone` CHECK(`phone` is null or `phone` regexp '^[0-9]{10}$'),
) ENGINE=InnoDB;

CREATE TABLE `customers` (
  `customerNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, 
  `customerName` varchar(60) NOT NULL UNIQUE,
  `contactLastName` varchar(30) NOT NULL,
  `contactFirstName` varchar(30) NOT NULL,
  `phone` varchar(10) DEFAULT NULL, 
  `addressLine1` varchar(255) DEFAULT NULL,
  `addressLine2` varchar(255) DEFAULT NULL,
  `city` varchar(30) DEFAULT NULL,
  `state` varchar(30) DEFAULT NULL, 
  `postalCode` varchar(6) DEFAULT NULL, 
  `country` varchar(30) DEFAULT NULL, 
  `salesRepEmployeeNumber` varchar(10) DEFAULT NULL,
  `creditLimit` int(11) DEFAULT NULL, 
  CONSTRAINT `PK_customers` PRIMARY KEY (`customerNumber`),
  CONSTRAINT `CHK_customers_phone` CHECK(`phone` is null or `phone` regexp '^[0-9]{10}$'),
  CONSTRAINT `CHK_customers_salesRepEmployeeNumber` CHECK(`salesRepEmployeeNumber` is null or `salesRepEmployeeNumber` regexp '^[0-9]{10}$'),
) ENGINE=InnoDB;

CREATE TABLE `payments` (
  `checkNumber` varchar(12) UNSIGNED NOT NULL AUTO_INCREMENT,
  `customerNumber` int(11) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `paymentDate` datetime DEFAULT CURRENT_TIMESTAMP,
  CONSTRAINT `PK_order` PRIMARY KEY (`checkNumber`),
  CONSTRAINT FK_customers_payments FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`), 
) ENGINE=InnoDB;

0 replies

Anandhi22 · 2022-05-23T12:13:37Z

Anandhi22
May 23, 2022

CREATE TABLE `customers` (
 `customerNumber` int(12) UNSIGNED NOT NULL AUTO_INCREMENT, 
  `customerName` varchar(25) NOT NULL,
  `contactLastName` varchar(25) DEFAULT NULL,
  `contactFirstName` varchar(25) DEFAULT NULL,
  `phone` varchar(25) DEFAULT NULL, 
  `addressLine1` varchar(30) DEFAULT NULL, 
  `addressLine2` varchar(30) DEFAULT NULL, 
  `city` varchar(30) DEFAULT NULL,
  `state` varchar(30) DEFAULT NULL, 
  `postalCode` int DEFAULT NULL, 
  `country` varchar(30) DEFAULT NULL, 
  `salesRepEmployeeNumber` int DEFAULT NULL,
  `creditLimit` int DEFAULT NULL,
   CONSTRAINT `PK_customer` PRIMARY KEY (`customerNumber`)
   );
   
   CREATE TABLE `orders` (
 `orderNumber` int(12) UNSIGNED NOT NULL AUTO_INCREMENT, 
 `orderDate` datetime DEFAULT NULL, 
 `requiredDate` datetime DEFAULT NULL, 
 `shippedDate` datetime DEFAULT NULL, 
  `status` varchar(30) DEFAULT NULL, 
  `comments` varchar(30) DEFAULT NULL,
  `customerNumber` int(12) UNSIGNED NOT NULL, 
  CONSTRAINT `PK_order` PRIMARY KEY (`orderNumber`),
  CONSTRAINT `FK_customer` FOREIGN KEY (`customerNumber`) 
   REFERENCES customers(`customerNumber`)  
     );
     
     CREATE TABLE `products` (
 `productCode` int(12) UNSIGNED NOT NULL AUTO_INCREMENT,
  `productName` varchar(30) NOT NULL,
  `productLine` varchar(40) DEFAULT NULL,
  `producScale` varchar(30) DEFAULT NULL,
  `productVendor` varchar(30) DEFAULT NULL,
  `productDescription` varchar(50) DEFAULT NULL,
  `quantityInStock` int UNSIGNED , 
  `buyPrice` int UNSIGNED NOT NULL, 
  `MSRP` int UNSIGNED NOT NULL, 
  CONSTRAINT `PK_product` PRIMARY KEY (`productCode`)
     )

0 replies

Svishva · 2022-05-23T12:35:30Z

Svishva
May 23, 2022

CREATE SCHEMA IF NOT EXISTS `company` DEFAULT CHARACTER SET utf8mb4 ;
USE `company` ;

CREATE TABLE IF NOT EXISTS `company`.`customers` (
  `customerNumber` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `customerName` VARCHAR(50) NULL,
  `contactLastName` VARCHAR(25) NOT NULL,
  `contactFirstName` VARCHAR(25) NOT NULL,
  `phone` VARCHAR(13) NOT NULL,
  `addressLine1` VARCHAR(40) NOT NULL,
  `addressLine2` VARCHAR(30) NULL DEFAULT NULL,
  `city` VARCHAR(25) NOT NULL,
  `state` VARCHAR(20) NULL,
  `postalCode` VARCHAR(8) NULL DEFAULT NULL,
  `country` VARCHAR(56) NULL,
  `salesRepEmployeeNumber` INT UNSIGNED NOT NULL,
  `creditLimit` INT NULL,
  PRIMARY KEY (`customerNumber`))
ENGINE = InnoDB;

CREATE UNIQUE INDEX `customerNumber_UNIQUE` ON `company`.`customers` (`customerNumber` DESC) VISIBLE;
CREATE UNIQUE INDEX `customerName_UNIQUE` ON `company`.`customers` (`customerName` DESC) VISIBLE;

CREATE TABLE IF NOT EXISTS `company`.`orders` (
  `orderNumber` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `orderDate` DATETIME NOT NULL,
  `requiredDate` DATE NOT NULL,
  `shippedDate` DATE NULL DEFAULT NULL,
  `status` VARCHAR(40) NOT NULL,
  `comments` VARCHAR(70) NULL DEFAULT NULL,
  `customerNumber` INT UNSIGNED NOT NULL,
  PRIMARY KEY (`orderNumber`, `customerNumber`),
  CONSTRAINT `fk_orders_customers`
    FOREIGN KEY (`customerNumber`)
    REFERENCES `company`.`customers` (`customerNumber`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

CREATE UNIQUE INDEX `orderNumber_UNIQUE` ON `company`.`orders` (`orderNumber` DESC) VISIBLE;
CREATE INDEX `fk_orders_customers_idx` ON `company`.`orders` (`customerNumber` DESC) VISIBLE;

CREATE TABLE IF NOT EXISTS `company`.`products` (
  `productCode` VARCHAR(20) NOT NULL,
  `productName` VARCHAR(50) NOT NULL,
  `productLine` VARCHAR(20) NULL DEFAULT NULL,
  `productScale` VARCHAR(10) NULL DEFAULT NULL,
  `productVendor` VARCHAR(30) NOT NULL,
  `productDescription` VARCHAR(255) NOT NULL,
  `quantityInStock` INT UNSIGNED NOT NULL,
  `buyPrice` DECIMAL(14,2) UNSIGNED NOT NULL,
  `MSRP` DECIMAL(14,2) UNSIGNED NOT NULL,
  PRIMARY KEY (`productCode`))
ENGINE = InnoDB;

CREATE UNIQUE INDEX `productCode_UNIQUE` ON `company`.`products` (`productCode` DESC) VISIBLE;

0 replies

KalaiselviRajavadivel · 2022-05-23T12:40:48Z

KalaiselviRajavadivel
May 23, 2022

CREATE TABLE `orders` (
    `orderNumber` int(11) UNSIGNED NOT NULL,
    `orderDate` datetime NOT NULL,
    `requiredDate` datetime,
    `shippedDate` datetime NOT NULL,
    `status` varchar(255) NOT NULL,
    `comments` varchar(255),
    `customerNumber` int(11) UNSIGNED NOT NULL,
     CONSTRAINT `PK_orders` PRIMARY KEY (`orderNumber`),
     CONSTRAINT `FK_orderDetails_orders` FOREIGN KEY (`orderNumber`) REFERENCES `orderDetails` (`orderNumber`),
     CONSTRAINT `FK_customers_orders` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`)
);

CREATE TABLE `customers` (
    `customerNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `customerName` varchar(50) NOT NULL,
    `contactLastName` varchar(25),
    `contactFirstName` varchar(25),
    `phone` varchar(10) NOT NULL,
    `addressLine1` varchar(100) NOT NULL,
    `addressLine2` varchar(100),
    `city` varchar(15) NOT NULL,
    `state` varchar(15) NOT NULL,
    `postalCode` varchar(6) NOT NULL,
    `country` varchar(15) NOT NULL,
    `salesRepEmployeeNumber` int(11) UNSIGNED,
    `creditLimit` decimal(11, 2) UNSIGNED,
     CONSTRAINT `PK_customers` PRIMARY KEY (`customerNumber`),
     CONSTRAINT `UQ_customers_phone` UNIQUE (`phone`)
     CONSTRAINT `FK_employees_customers` FOREIGN KEY (`salesRepEmployeeNumber`) REFERENCES `employees` (`employeeNumber`),
);

CREATE TABLE `payments`(
    `customerNumber` int(11) UNSIGNED NOT NULL,
    `checkNumber` int(11) UNSIGNED,
    `paymentDate` datetime NOT NULL,
    `amount` decimal(11, 2) NOT NULL,
     CONSTRAINT `PK_payments` PRIMARY KEY (`customerNumber`, `checkNumber`),
     CONSTRAINT `UQ_payments_checkNumber` UNIQUE (`checkNumber`)
     CONSTRAINT `FK_customers_payments` FOREIGN KEY (`customerNumber`) REFERENCES `customers` (`customerNumber`),
)

0 replies

vamsi1234567891 · 2022-05-23T12:41:21Z

vamsi1234567891
May 23, 2022

CREATE TABLE `customers` (
    `customerNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `customerName` varchar(50) NOT NULL UNIQUE,
    `contactLastName` varchar(25) NOT NULL,
    `contactFirstName` varchar(25) NOT NULL,
    `phone` varchar(10) NOT NULL,
    `addressLine1` varchar(100) NOT NULL,
    `addressLine2` varchar(100) DEFAULT NULL,
    `city` varchar(15) NOT NULL,
    `state` varchar(15) NOT NULL,
    `postalCode` varchar(6) NOT NULL,
    `country` varchar(15) NOT NULL,
    `salesRepEmployeeNumber` int(11) UNSIGNED NOT NULL,
    `creditLimit` decimal(11, 2) UNSIGNED DEFAULT NULL,
     CONSTRAINT `PK_customers` PRIMARY KEY (`customerNumber`),
     CONSTRAINT `UQ_customers_phone` UNIQUE (`phone`)
     CONSTRAINT `CHK_customers` CHECK(`phone` is null or `phone` regexp '^[0-9]{10}$'),
     INDEX `IDX_phone` (`phone`)
);

CREATE TABLE `orders` (
    `orderNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `orderDate` datetime NOT NULL,
    `requiredDate` datetime DEFAULT NULL,
    `shippedDate` datetime NOT NULL,
    `status` varchar(255) NOT NULL,
    `comments` varchar(255) DEFAULT NULL,
    `customerNumber` int(11) UNSIGNED NOT NULL,
     CONSTRAINT `PK_orders` PRIMARY KEY (`orderNumber`),
     INDEX `IDX_customerNumber` (`customerNumber`)
);

CREATE TABLE `products`(
    `productCode` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `productName` varchar(50) NOT NULL UNIQUE,
    `productLine` int(11) UNSIGNED NOT NULL,
    `productScale` varchar(25) DEFAULT NULL,
    `productVendor` varchar(30) NOT NULL,
    `productDescription` varchar(100),
    `quantityInStock` int(11) UNSIGNED NOT NULL,
    `buyPrice` decimal(11, 2) UNSIGNED NOT NULL,
    `MSRP` decimal(11, 2) UNSIGNED NOT NULL,
     CONSTRAINT `PK_products` PRIMARY KEY (`productCode`),
     CONSTRAINT `UQ_products_productName` UNIQUE (`productName`),
     INDEX `IDX_productName` (`productName`)
     );

0 replies

GouthamGunji · 2022-05-23T12:47:57Z

GouthamGunji
May 23, 2022

CREATE TABLE `customers` (
 `customerNumber` int(12) UNSIGNED NOT NULL AUTO_INCREMENT, 
  `customerName` varchar(25) NOT NULL,
  `contactLastName` varchar(25) DEFAULT NULL,
  `contactFirstName` varchar(25) DEFAULT NULL,
  `phone` varchar(25) DEFAULT NULL, 
  `addressLine1` varchar(30) DEFAULT NULL, 
  `addressLine2` varchar(30) DEFAULT NULL, 
  `city` varchar(30) DEFAULT NULL,
  `state` varchar(30) DEFAULT NULL, 
  `postalCode` int DEFAULT NULL, 
  `country` varchar(30) DEFAULT NULL, 
  `salesRepEmployeeNumber` int DEFAULT NULL,
  `creditLimit` int DEFAULT NULL,
   CONSTRAINT `PK_customer` PRIMARY KEY (`customerNumber`)
   );
   
   CREATE TABLE `orders` (
 `orderNumber` int(12) UNSIGNED NOT NULL AUTO_INCREMENT, 
 `orderDate` datetime DEFAULT NULL, 
 `requiredDate` datetime DEFAULT NULL, 
 `shippedDate` datetime DEFAULT NULL, 
  `status` varchar(30) DEFAULT NULL, 
  `comments` varchar(30) DEFAULT NULL,
  `customerNumber` int(12) UNSIGNED NOT NULL, 
  CONSTRAINT `PK_order` PRIMARY KEY (`orderNumber`),
  CONSTRAINT `FK_customer` FOREIGN KEY (`customerNumber`) 
   REFERENCES customers(`customerNumber`)  
     );
     
     CREATE TABLE `products` (
 `productCode` int(12) UNSIGNED NOT NULL AUTO_INCREMENT,
  `productName` varchar(30) NOT NULL,
  `productLine` varchar(40) DEFAULT NULL,
  `producScale` varchar(30) DEFAULT NULL,
  `productVendor` varchar(30) DEFAULT NULL,
  `productDescription` varchar(50) DEFAULT NULL,
  `quantityInStock` int UNSIGNED , 
  `buyPrice` int UNSIGNED NOT NULL, 
  `MSRP` int UNSIGNED NOT NULL, 
  CONSTRAINT `PK_product` PRIMARY KEY (`productCode`)
     )

0 replies

meghvi-raj · 2022-07-04T05:46:41Z

meghvi-raj
Jul 4, 2022

CREATE

CREATE TABLE employees(
employeeNumber int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
lastName varchar(50) NOT NULL,
firstName varchar(50) NOT NULL,
extension varchar(50),
email varchar(50) NOT NULL,
officeCode int(11),
reportsTo int(11),
jobTitle varchar(50),
CONSTRAINT PK_employees PRIMARY KEY (employeeNumber),
CONSTRAINT UQ_employees_email UNIQUE (email)
);

CREATE TABLE offices(
officeCode int(11) unsigned NOT NULL,
city varchar(25),
phone varchar(10) NOT NULL,
addressLine1 varchar(75),
addressLine2 varchar(75),
state varchar(15) ,
country varchar(15) ,
postalCode int(8) UNSIGNED,
territory varchar(15) ,
CONSTRAINT PK_offices PRIMARY KEY (officeCode),
CONSTRAINT UQ_offices_phone UNIQUE (phone)
);

CREATE TABLE customers (
customerNumber int(11) UNSIGNED NOT NULL,
customerName varchar(50) ,
contactLastName varchar(25),
contactFirstName varchar(25),
phone varchar(10) NOT NULL,
addressLine1 varchar(100) NOT NULL,
addressLine2 varchar(100) DEFAULT NULL,
city varchar(15),
state varchar(15),
postalCode varchar(6),
country varchar(15) ,
salesRepEmployeeNumber int(11) UNSIGNED,
creditLimit int(11) UNSIGNED,
CONSTRAINT PK_customers PRIMARY KEY (customerNumber),
CONSTRAINT UQ_customers_phone UNIQUE (phone)

);

INSERT

INSERT INTO employees (

                  `lastName`, 
                  `firstName`, 
                  `extension`, 
                  `email`,
                  `officeCode`,
                  `reportsTo`,
                  `jobTitle`
                  ) 
         VALUES (
                  'Raj', 
                  'Meghvi', 
                  '+92', 
                  'meghviraj2@gmail.com', 
                  '55',
                  '2',
                  'SE'
                   );

INSERT INTO employees (

                  `lastName`, 
                  `firstName`, 
                  `extension`, 
                  `email`,
                  `officeCode`,
                  `reportsTo`,
                  `jobTitle`
                  ) 
         VALUES (
                  'Jamal', 
                  'Uzma', 
                  '+11', 
                  'uzmajamal@gmail.com', 
                  '66',
                  '3',
                  'ASE'
                   );

insert into offices ( officeCode,
city ,
phone ,
addressLine1 ,
addressLine2 ,
state ,
country ,
postalCode ,
territory) values
('10','Delhi','8764685478','Tower C','Cloud-9 Towers','Delhi','India','201014', 'abc');

insert into offices ( officeCode,
city ,
phone ,
addressLine1 ,
addressLine2 ,
state ,
country ,
postalCode ,
territory) values
('11','Bangalore','8764685238','HUB-4','Nagavara','Karnataka','India','560045', 'xyz');

insert into customers ( customerNumber,
customerName ,
contactLastName ,
contactFirstName ,
phone ,
addressLine1 ,
addressLine2 ,
city ,
state,
postalCode,
country,
salesRepEmployeeNumber,
creditLimit) values
('1','John Doe','Doe','John','9876543210','4th Street','5th Cross',
'Brooklyn','New York','123456','USA', '15','1000');

insert into customers ( customerNumber,
customerName ,
contactLastName ,
contactFirstName ,
phone ,
addressLine1 ,
addressLine2 ,
city ,
state,
postalCode,
country,
salesRepEmployeeNumber,
creditLimit) values
('2','John Snow','Snow','John','9876543211','5th Street','6th Cross',
'Bangalore','Karnataka','560045','India', '16','1000');

Retrieve all data from the three tables respectively.

select * from employees;
select * from offices;
select * from customers;

Update any employee’s extension and email.

UPDATE employees SET extension = '+92', email='abc@gmail.com' WHERE employeeNumber = '2';

Delete a customer record where the customer is from USA.

DELETE FROM customers where country=USA;

0 replies

vshvandana · 2022-07-04T06:01:58Z

vshvandana
Jul 4, 2022

0 replies

ghost · 2022-07-04T06:02:29Z

ghost
Jul 4, 2022

CREATE -
CREATE TABLE employees(
employeeNumber int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
lastName varchar(30) NOT NULL,
firstName varchar(30) NOT NULL,
extension varchar(40),
email varchar(50) NOT NULL,
officeCode int(10),
reportsTo int(10),
jobTitle varchar(50),
CONSTRAINT PK_employees PRIMARY KEY (employeeNumber),
CONSTRAINT UQ_employees_email UNIQUE (email)
);

CREATE TABLE offices(
officeCode int(10) unsigned NOT NULL,
city varchar(30),
phone varchar(10) NOT NULL,
addressLine1 varchar(100),
addressLine2 varchar(100),
state varchar(20) ,
country varchar(15) ,
postalCode int(8) UNSIGNED,
territory varchar(15) ,
CONSTRAINT PK_offices PRIMARY KEY (officeCode),
CONSTRAINT UQ_offices_phone UNIQUE (phone)
);

CREATE TABLE customers (
customerNumber int(10) UNSIGNED NOT NULL,
customerName varchar(30) ,
contactLastName varchar(30),
contactFirstName varchar(30),
phone varchar(10) NOT NULL,
addressLine1 varchar(100) NOT NULL,
addressLine2 varchar(100) DEFAULT NULL,
city varchar(25),
state varchar(25),
postalCode varchar(6),
country varchar(20) ,
salesRepEmployeeNumber int(10) UNSIGNED,
creditLimit int(10) UNSIGNED,
CONSTRAINT PK_customers PRIMARY KEY (customerNumber),
CONSTRAINT UQ_customers_phone UNIQUE (phone)
);

INSERT-
INSERT INTO employees (

              `lastName`, 
              `firstName`, 
              `extension`, 
              `email`,
              `officeCode`,
              `reportsTo`,
              `jobTitle`
              ) 
     VALUES (
              'ABC', 
              'DEF', 
              '+91', 
              'xyz@gmail.com', 
              '40',
              '1',
              'SDE'
               );

INSERT INTO employees (

              `lastName`, 
              `firstName`, 
              `extension`, 
              `email`,
              `officeCode`,
              `reportsTo`,
              `jobTitle`
              ) 
     VALUES (
              'UVW', 
              'XYZ', 
              '+91', 
              'abc@gmail.com', 
              '60',
              '1',
              'SDET'
               );

insert into offices ( officeCode,
city ,
phone ,
addressLine1 ,
addressLine2 ,
state ,
country ,
postalCode ,
territory) values
('432','Jaipur','9898989898','Sector A','Town D','Jaipur','Rajasthan','324005', 'abc');

insert into offices ( officeCode,
city ,
phone ,
addressLine1 ,
addressLine2 ,
state ,
country ,
postalCode ,
territory) values
('9','Bangalore','8777777778','HUB-4','Nagavara','Karnataka','India','560045', 'abc');

insert into customers ( customerNumber,
customerName ,
contactLastName ,
contactFirstName ,
phone ,
addressLine1 ,
addressLine2 ,
city ,
state,
postalCode,
country,
salesRepEmployeeNumber,
creditLimit) values
('10','Jkh','ABC','CDE','9898989898','7th Street','4th Cross',
'Brooklyn','New York','98765','USA', '15','9000');

insert into customers ( customerNumber,
customerName ,
contactLastName ,
contactFirstName ,
phone ,
addressLine1 ,
addressLine2 ,
city ,
state,
postalCode,
country,
salesRepEmployeeNumber,
creditLimit) values
('20','PQR','STU','DEF','9000080000','7th Street','8th Cross',
'Bangalore','Karnataka','560045','India', '18','1000');

RETRIEVE-
select * from employees;
select * from offices;
select * from customers;

UPDATE-
UPDATE employees SET extension = '+92', email='pqrst@gmail.com' WHERE employeeNumber = '436';

DELETE-
DELETE FROM customers where country=USA;

0 replies

ApoorvaSinha · 2022-07-04T06:51:17Z

ApoorvaSinha
Jul 4, 2022

mysql> create database company;

mysql> create table employees( empid INT(11) NOT NULL AUTO_INCREMENT,firstName varchar(20), lastName varchar(25),email varchar(25), phone_no varchar(20),hire_date date,jobid varchar(10),salary INT(11), commision_pct INT(10), managerid INT(10),departmentid INT(10), CONSTRAINT empid_pk PRIMARY KEY(empid));
Query OK, 0 rows affected, 5 warnings (0.04 sec)

mysql> create table locations(locationid INT(11) NOT NULL AUTO_INCREMENT,street_address varchar(25),postal_code varch
ar(12),city varchar(30),state_province varchar(12), countryid char(12), CONSTRAINT locationid_pk PRIMARY KEY(locationid));
Query OK, 0 rows affected, 1 warning (0.04 sec)

mysql> create table jobs(jobid varchar(10) NOT NULL,job_title varchar(35),min_salary INT,max_salary INT, CONSTRAINT jobid_pk PRIMARY KEY(jobid));

mysql> create table countries(countryid char(2) NOT NULL,country_name varchar(40),regionid INT, CONSTRAINT countryid_pk PRIMARY KEY(countryid));
Query OK, 0 rows affected (0.05 sec)

mysql> create table departments(departmentid INT NOT NULL AUTO_INCREMENT,department_name varchar(30),managerid INT,locationid INT, CONSTRAINT department_pk PRIMARY KEY(departmentid));
Query OK, 0 rows affected (0.07 sec)

mysql> create table regions(regionid INT NOT NULL AUTO_INCREMENT,region_name varchar(20), CONSTRAINT regionid_pk PRIMARY KEY(regionid));
Query OK, 0 rows affected (0.04 sec)


mysql> create table job_history(empid INT NOT NULL,start_date date NOT NULL,end_date date,jobid varchar(10),departmentid INT, CONSTRAINT start_date_pk PRIMARY KEY(empid,start_date));
Query OK, 0 rows affected (0.08 sec)

CREATE TABLE `customers` (
    `customerNumber` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
    `customerName` varchar(50) NOT NULL,
    `contactLastName` varchar(25),
    `contactFirstName` varchar(25),
    `phone` varchar(10) NOT NULL,
    `addressLine1` varchar(100) NOT NULL,
    `addressLine2` varchar(100),
    `city` varchar(15) NOT NULL,
    `state` varchar(15) NOT NULL,
    `postalCode` varchar(6) NOT NULL,
    `country` varchar(15) NOT NULL,
    `salesRepEmployeeNumber` int(11) UNSIGNED,
    `creditLimit` decimal(11, 2) UNSIGNED,
     CONSTRAINT `PK_customers` PRIMARY KEY (`customerNumber`),
     CONSTRAINT `UQ_customers_phone` UNIQUE (`phone`),
     CONSTRAINT `FK_employees_customers` FOREIGN KEY (`salesRepEmployeeNumber`) REFERENCES `employees` (`employeeNumber`)
);

insert into customers (customerName,contactLastName,contactFirstName,phone,addressLine1,addressLine2,city,state,postalCode,country,salesRepEmployeeNumber,creditLimit) values("Anu","Singh","Priya","9876554321","Kormangala","layout","Bangalore","Karanataka","560071","India",12,2456.89);

 insert into offices (city,phone,addressLine1,addressLine2,state,country,postalCode,territory) values("Bangalor
e","9987654321","Kormangala","Layout","Karanataka","India",560071,"Asia");

0 replies

ParthPatel999 · 2023-09-29T16:43:53Z

ParthPatel999
Sep 29, 2023

CREATE database IF NOT EXISTS Company CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

USE Company;

CREATE TABLE IF NOT EXISTS productLines(
productLine int(11) UNSIGNED NOT NULL,
textDescription VARCHAR(50) DEFAULT NULL,
htmlDescription VARCHAR(50) DEFAULT NULL,
image VARCHAR(50) DEFAULT NULL,
CONSTRAINT PK_productLines PRIMARY KEY (productLine)

);

CREATE TABLE IF NOT EXISTS offices (
officeCode int(11) UNSIGNED NOT NULL,
city VARCHAR(50) DEFAULT NULL,
phone VARCHAR(10) DEFAULT NULL,
addressLine1 VARCHAR(255) DEFAULT NULL,
addressLine2 VARCHAR(255) DEFAULT NULL,
state VARCHAR(50) DEFAULT NULL,
countryVARCHAR(25) DEFAULT NULL,
postalCodeINT(10) NOT NULL,
territoryVARCHAR(255) DEFAULT NULL,
CONSTRAINT PK_offices PRIMARY KEY (officeCode),
CONSTRAINT CHK_offices_phone CHECK(phone is null or phone regexp '^[0-9]{10}$')
);

CREATE TABLE IF NOT EXISTS products(
productCode int(11) UNSIGNED NOT NULL,
productName VARCHAR(25) DEFAULT NULL,
productLine int(11) UNSIGNED NOT NULL,
productScale VARCHAR(50) DEFAULT NULL,
productVendor VARCHAR(50) DEFAULT NULL,
productDescription VARCHAR(50) DEFAULT NULL,
quantityInStock INT DEFAULT NULL,
buyPrice DOUBLE(11,2) UNSIGNED DEFAULT NULL,
MSRP DOUBLE(11,2) UNSIGNED DEFAULT NULL,
CONSTRAINT PK_products PRIMARY KEY (productCode),
CONSTRAINT FK_productLines_products FOREIGN KEY (productLine) REFERENCES productLines (productLine)

);

CREATE TABLE IF NOT EXISTS employees(
employeeNumber int(11) UNSIGNED NOT NULL,
lastName VARCHAR(25) DEFAULT NULL,
firstname VARCHAR(25) DEFAULT NULL,
extension enum('Mr.','Mrs.','Ms.') DEFAULT NULL,
email VARCHAR(50) DEFAULT NULL,
officeCode INT(11) UNSIGNED NOT NULL,
reportsTo VARCHAR(50) DEFAULT NULL,
jobTitle VARCHAR(50) DEFAULT NULL,
CONSTRAINT PK_employees PRIMARY KEY (employeeNumber),
CONSTRAINT FK_offices_employees FOREIGN KEY (officeCode) REFERENCES offices (officeCode)
);

CREATE TABLE IF NOT EXISTS customers(
customerNumber int(11) UNSIGNED NOT NULL,
customerName VARCHAR(50) DEFAULT NULL,
contactlastName VARCHAR(25) DEFAULT NULL,
contactfirstname VARCHAR(25) DEFAULT NULL,
phone VARCHAR(10) DEFAULT NULL,
addressLine1 VARCHAR(255) DEFAULT NULL,
addressLine2 VARCHAR(255) DEFAULT NULL,
city VARCHAR(50) DEFAULT NULL,
state VARCHAR(50) DEFAULT NULL,
postalCode INT(10) NOT NULL,
country VARCHAR(25) DEFAULT NULL,
salesRepEmployeeNumber int(11) UNSIGNED NOT NULL,
creditLimit VARCHAR(10) DEFAULT NULL,
CONSTRAINT PK_customers PRIMARY KEY (customerNumber),
CONSTRAINT CHK_customers_phone CHECK(phone is null or phone regexp '^[0-9]{10}$'),
CONSTRAINT FK_employees_customers FOREIGN KEY (salesRepEmployeeNumber) REFERENCES employees (employeeNumber)
);

CREATE TABLE IF NOT EXISTS payments(
customerNumber int(11) UNSIGNED NOT NULL,
checkNumber INT(11) UNSIGNED NOT NULL,
paymentDate DATE NOT NULL,
amount DOUBLE(11,2) UNSIGNED NOT NULL,
CONSTRAINT PK_payments PRIMARY KEY (customerNumber,checkNumber),
CONSTRAINT FK_customers_payments FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber)
);

CREATE TABLE IF NOT EXISTS orders (
orderNumberint(11) UNSIGNED NOT NULL,
orderDate DATE NOT NULL,
requiredDate DATE NOT NULL,
shippedDate DATE DEFAULT NULL,
status enum('Delivered','Shipped','Confirmed') DEFAULT NULL,
comments VARCHAR(50) DEFAULT NULL,
customerNumberint(11) UNSIGNED NOT NULL,
CONSTRAINT PK_orders PRIMARY KEY (orderNumber),
CONSTRAINT FK_customers_orders FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber)
);

0 replies

Sourav21071998 · 2023-09-29T16:47:33Z

Sourav21071998
Sep 29, 2023

CREATE TABLE employees(
employeeNumber int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
lastName varchar(50) NOT NULL,
firstName varchar(50) NOT NULL,
extension varchar(50),
email varchar(50) NOT NULL,
officeCode int(11),
reportsTo int(11),
jobTitle varchar(50),
CONSTRAINT PK_employees PRIMARY KEY (employeeNumber),
CONSTRAINT UQ_employees_email UNIQUE (email),
CONSTRAINT FK_offices_employees FOREIGN KEY (officeCode) REFERENCES offices (officeCode),
CONSTRAINT FK_employees_employees FOREIGN KEY (reportsTo) REFERENCES employees(employeeNumber)
);

CREATE TABLE offices(
officeCode int(11) unsigned NOT NULL AUTO_INCREMENT,
city varchar(25) NOT NULL,
phone_number varchar(10) NOT NULL,
addressLine1 varchar(75) NOT NULL,
addressLine2 varchar(75) DEFAULT NULL,
state varchar(15) NOT NULL,
country varchar(15) NOT NULL,
postalCode int(8) NOT NULL,
territory varchar(15) NOT NULL,
CONSTRAINT PK_offices PRIMARY KEY (officeCode),
CONSTRAINT UQ_offices_phone UNIQUE (phone)
);

CREATE TABLE products(
productCode int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
productName varchar(50) NOT NULL,
productLine int(11) UNSIGNED NOT NULL,
productScale varchar(25),
productVendor varchar(30) NOT NULL,
productDescription varchar(100),
quantityInStock int(11) UNSIGNED NOT NULL,
buyPrice decimal(11, 2) UNSIGNED NOT NULL,
MSRP decimal(11, 2) UNSIGNED NOT NULL,
CONSTRAINT PK_products PRIMARY KEY (productCode),
CONSTRAINT UQ_products_productName UNIQUE (productName),
CONSTRAINT FK_productLines_products FOREIGN KEY (productLine) REFERENCES productLines (productLines)
);

CREATE TABLE productLines (
productLine int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
textDescription varchar(255),
htmlDescription varchar(255),
image varchar(255),
CONSTRAINT PK_productLines PRIMARY KEY (productLine),
);

CREATE TABLE orderDetails (
orderNumber int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
productCode int(11) UNSIGNED NOT NULL,
quantityOrdered int(11) UNSIGNED NOT NULL,
priceEach decimal(11,2) NOT NULL,
orderLineNumber int(11),
CONSTRAINT PK_orderDetails PRIMARY KEY (orderNumber, productCode),
CONSTRAINT FK_orderDetails_productCode FOREIGN KEY (productCode) REFERENCES products (productCode)
);

CREATE TABLE orders (
orderNumber int(11) UNSIGNED NOT NULL,
orderDate datetime NOT NULL,
requiredDate datetime,
shippedDate datetime NOT NULL,
status varchar(255) NOT NULL,
comments varchar(255),
customerNumber int(11) UNSIGNED NOT NULL,
CONSTRAINT PK_orders PRIMARY KEY (orderNumber),
CONSTRAINT FK_orderDetails_orders FOREIGN KEY (orderNumber) REFERENCES orderDetails (orderNumber),
CONSTRAINT FK_customers_orders FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber)
);

CREATE TABLE customers (
customerNumber int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
customerName varchar(50) NOT NULL,
contactLastName varchar(25),
contactFirstName varchar(25),
phone varchar(10) NOT NULL,
addressLine1 varchar(100) NOT NULL,
addressLine2 varchar(100),
city varchar(15) NOT NULL,
state varchar(15) NOT NULL,
postalCode varchar(6) NOT NULL,
country varchar(15) NOT NULL,
salesRepEmployeeNumber int(11) UNSIGNED,
creditLimit decimal(11, 2) UNSIGNED,
CONSTRAINT PK_customers PRIMARY KEY (customerNumber),
CONSTRAINT UQ_customers_phone UNIQUE (phone)
CONSTRAINT FK_employees_customers FOREIGN KEY (salesRepEmployeeNumber) REFERENCES employees (employeeNumber),
);

CREATE TABLE payments(
customerNumber int(11) UNSIGNED NOT NULL,
checkNumber int(11) UNSIGNED,
paymentDate datetime NOT NULL,
amount decimal(11, 2) NOT NULL,
CONSTRAINT PK_payments PRIMARY KEY (customerNumber, checkNumber),
CONSTRAINT UQ_payments_checkNumber UNIQUE (checkNumber)
CONSTRAINT FK_customers_payments FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber),
)

0 replies

akratimishra22 · 2023-09-29T19:43:35Z

akratimishra22
Sep 29, 2023

CREATE TABLE IF NOT EXISTS productlines (
productLine VARCHAR(50) PRIMARY KEY,
textDescription VARCHAR(255),
htmlDescription TEXT,
image VARCHAR(255)
);
CREATE TABLE IF NOT EXISTS products (
productCode VARCHAR(15) PRIMARY KEY,
productName VARCHAR(70) NOT NULL,
productLine VARCHAR(50),
productScale VARCHAR(10),
productVendor VARCHAR(50),
productDescription TEXT,
quantityInStock INT,
buyPrice DECIMAL(10, 2),
MSRP DECIMAL(10, 2),
CONSTRAINT fk_productLine FOREIGN KEY (productLine) REFERENCES productlines (productLine)
);
CREATE TABLE IF NOT EXISTS offices (
officeCode INT UNSIGNED PRIMARY KEY,
city VARCHAR(50) NOT NULL,
phone VARCHAR(20) NOT NULL,
addressLine1 VARCHAR(100) NOT NULL,
addressLine2 VARCHAR(100),
state VARCHAR(50),
country VARCHAR(50),
postalCode VARCHAR(15),
territory VARCHAR(10)
);
CREATE TABLE IF NOT EXISTS employees (
employeeNumber INT UNSIGNED PRIMARY KEY,
lastName VARCHAR(50) NOT NULL,
firstName VARCHAR(50) NOT NULL,
extension VARCHAR(10),
email VARCHAR(100) NOT NULL,
officeCode INT UNSIGNED,
reportsTo INT UNSIGNED,
jobTitle VARCHAR(50) NOT NULL,
CONSTRAINT fk_officeCode FOREIGN KEY (officeCode) REFERENCES offices (officeCode),
CONSTRAINT fk_reportsTo FOREIGN KEY (reportsTo) REFERENCES employees (employeeNumber)
);
CREATE TABLE IF NOT EXISTS customers (
customerNumber INT UNSIGNED PRIMARY KEY,
customerName VARCHAR(50) NOT NULL,
contactLastName VARCHAR(50) NOT NULL,
contactFirstName VARCHAR(50) NOT NULL,
phone VARCHAR(20),
addressLine1 VARCHAR(100) NOT NULL,
addressLine2 VARCHAR(100),
city VARCHAR(50),
state VARCHAR(50),
postalCode VARCHAR(15),
country VARCHAR(50),
salesRepEmployeeNumber INT UNSIGNED,
creditLimit DECIMAL(10, 2),
CONSTRAINT fk_customers_salesRepEmployeeNumber FOREIGN KEY (salesRepEmployeeNumber) REFERENCES employees (employeeNumber)
);
CREATE TABLE IF NOT EXISTS orders (
orderNumber INT UNSIGNED PRIMARY KEY,
orderDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
requiredDate DATE,
shippedDate DATE,
status VARCHAR(15),
comments TEXT,
customerNumber INT UNSIGNED,
CONSTRAINT fk_orders_customerNumber FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber)
);
CREATE TABLE IF NOT EXISTS orderdetails (
orderNumber INT UNSIGNED,
productCode VARCHAR(15),
quantityOrdered INT UNSIGNED,
priceEach DECIMAL(10, 2),
orderLineNumber INT UNSIGNED,
PRIMARY KEY (orderNumber, productCode),
CONSTRAINT fk_orderdetails_orderNumber FOREIGN KEY (orderNumber) REFERENCES orders (orderNumber),
CONSTRAINT fk_orderdetails_productCode FOREIGN KEY (productCode) REFERENCES products (productCode)
);

CREATE TABLE IF NOT EXISTS payments (
customerNumber INT UNSIGNED,
checkNumber VARCHAR(50),
paymentDate DATE,
amount DECIMAL(10, 2),
PRIMARY KEY (customerNumber, checkNumber),
FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber)
);

0 replies

sayanp-12 · 2023-10-02T10:42:17Z

sayanp-12
Oct 2, 2023

Hi @akash-coded , Please find the DDL statements as below.

CREATE TABLE IF NOT EXISTS employees (
employeeNumber INT(15) NOT NULL AUTO_INCREMENT,
lastName varchar(50) NOT NULL,
firstName varchar(50) NOT NULL,
extension varchar(25),
email varchar(50) NOT NULL,
officeCode INT(15),
reportsTo varchar(50),
jobTitle varchar(50),
CONSTRAINT empid_pk PRIMARY KEY(employeeNumber),
CONSTRAINT UQ_employees_email UNIQUE(email),
CONSTRAINT FK_offices_officeCode FOREIGN KEY(officeCode) REFERENCES offices(officeCode),
CONSTRAINT FK_employees_reportsTo FOREIGN KEY(reportsTo) REFERENCES employees(employeeNumber`);

CREATE TABLE IF NOT EXISTS customers (
customerNumber int(15) UNSIGNED NOT NULL AUTO_INCREMENT,
customerName varchar(100) NOT NULL,
contactLastName varchar(50),
contactFirstName varchar(50),
phone varchar(15) NOT NULL,
addressLine1 varchar(100) NOT NULL,
addressLine2 varchar(100),
city varchar(15) NOT NULL,
state varchar(15) NOT NULL,
postalCode varchar(10) NOT NULL,
country varchar(15) NOT NULL,
salesRepEmployeeNumber int(15) UNSIGNED,
creditLimit decimal(11, 2) UNSIGNED,
CONSTRAINT PK_customerNumber PRIMARY KEY (customerNumber),
CONSTRAINT UQ_customers_phone UNIQUE (phone)
CONSTRAINT FK_employees_customers FOREIGN KEY (salesRepEmployeeNumber) REFERENCES employees (employeeNumber),
);

CREATE TABLE IF NOT EXISTS offices(
officeCode int(15) unsigned NOT NULL AUTO_INCREMENT,
city varchar(25) NOT NULL,
phone varchar(15) NOT NULL,
addressLine1 varchar(100) NOT NULL,
addressLine2 varchar(100) DEFAULT NULL,
state varchar(25) NOT NULL,
country varchar(15) NOT NULL,
postalCode int(10) NOT NULL,
territory varchar(25) NOT NULL,
CONSTRAINT PK_officeCode PRIMARY KEY (officeCode),
CONSTRAINT UQ_offices_phone UNIQUE (phone)
);

CREATE TABLE IF NOT EXISTS orders (
orderNumber int(20) UNSIGNED NOT NULL,
orderDate datetime NOT NULL,
requiredDate datetime,
shippedDate datetime NOT NULL,
status varchar(255) NOT NULL,
comments varchar(300),
customerNumber int(20) UNSIGNED NOT NULL,
CONSTRAINT PK_orders PRIMARY KEY (orderNumber),
CONSTRAINT FK_orderDetails_orders FOREIGN KEY (orderNumber) REFERENCES orderDetails (orderNumber),
CONSTRAINT FK_customers_orders FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber)
);

CREATE TABLE IF NOT EXISTS payments(
customerNumber int(20) UNSIGNED NOT NULL,
checkNumber int(20) UNSIGNED,
paymentDate datetime NOT NULL,
amount decimal(15, 2) NOT NULL,
CONSTRAINT PK_payments_customerNumber_checkNumber PRIMARY KEY (customerNumber, checkNumber),
CONSTRAINT UQ_payments_checkNumber UNIQUE (checkNumber)
CONSTRAINT FK_customers_payments_customerNumber FOREIGN KEY (customerNumber) REFERENCES customers (customerNumber),
);

CREATE TABLE IF NOT EXISTS orderDetails (
orderNumber int(20) UNSIGNED NOT NULL AUTO_INCREMENT,
productCode int(20) UNSIGNED NOT NULL,
quantityOrdered int(15) UNSIGNED NOT NULL,
priceEach decimal(15,2) NOT NULL,
orderLineNumber int(15),
CONSTRAINT PK_orderDetails_orderNumber_productCode PRIMARY KEY (orderNumber, productCode),
CONSTRAINT FK_orderDetails_productCode FOREIGN KEY (productCode) REFERENCES products (productCode)
);

CREATE TABLE IF NOT EXISTS products(
productCode int(20) UNSIGNED NOT NULL AUTO_INCREMENT,
productName varchar(100) NOT NULL,
productLine int(15) UNSIGNED NOT NULL,
productScale varchar(25),
productVendor varchar(50) NOT NULL,
productDescription varchar(100),
quantityInStock int(15) UNSIGNED NOT NULL,
buyPrice decimal(15, 2) UNSIGNED NOT NULL,
MSRP decimal(15, 2) UNSIGNED NOT NULL,
CONSTRAINT PK_products_productCode PRIMARY KEY (productCode),
CONSTRAINT UQ_products_productName UNIQUE (productName),
CONSTRAINT FK_products_productLines FOREIGN KEY (productLine) REFERENCES productLines (productLines)
);

CREATE TABLE IF NOT EXISTS productLines (
productLine int(15) UNSIGNED NOT NULL AUTO_INCREMENT,
textDescription varchar(300),
htmlDescription varchar(300),
image varchar(300),
CONSTRAINT PK_productLines PRIMARY KEY (productLine),
);

0 replies

Aniruth-raman · 2023-10-03T13:19:38Z

Aniruth-raman
Oct 3, 2023

Hi @akash-coded,

Please find my solution attached.
ecommerce.zip

0 replies

manideep-vv · 2023-10-03T15:53:42Z

manideep-vv
Oct 3, 2023

CREATE DATABASE IF NOT EXISTS ecommerce CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE ecommerce;
CREATE TABLE offices (
officeCode INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
city VARCHAR(50) NOT NULL,
phone VARCHAR(10) NOT NULL,
addressLine1 VARCHAR(300) NOT NULL,
addressLine2 VARCHAR(100) DEFAULT NULL,
state VARCHAR(100) DEFAULT NULL,
country VARCHAR(100) NOT NULL,
postalCode VARCHAR(6) NOT NULL,
territory VARCHAR(10) NOT NULL,
CONSTRAINT PK_officeCode PRIMARY KEY(officeCode),
CONSTRAINT UQ_offices_phone UNIQUE(phone)
) ENGINE = InnoDB;
CREATE TABLE employees (
employeeNumber INT(8) NOT NULL AUTO_INCREMENT,
lastName VARCHAR(100) NOT NULL,
firstName VARCHAR(100) NOT NULL,
extension VARCHAR(100) DEFAULT 'x000',
email VARCHAR(100) NOT NULL,
officeCode INT(8) UNSIGNED,
reportsTo INT(8),
jobTitle VARCHAR(50) DEFAULT 'Employee',
CONSTRAINT empid_pk PRIMARY KEY(employeeNumber),
CONSTRAINT UQ_employees_email UNIQUE(email),
CONSTRAINT FK_offices_officeCode FOREIGN KEY(officeCode) REFERENCES offices(officeCode),
CONSTRAINT FK_employees_reportsTo FOREIGN KEY(reportsTo) REFERENCES employees(employeeNumber)
) ENGINE = InnoDB;
CREATE TABLE productLines (
productLine INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
textDescription VARCHAR(100),
htmlDescription VARCHAR(100),
image VARCHAR(300),
CONSTRAINT PK_productLines PRIMARY KEY(productLine)
) ENGINE = InnoDB;
CREATE TABLE products (
productCode INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
productName VARCHAR(100) NOT NULL,
productLine INT(8) UNSIGNED NOT NULL,
productScale VARCHAR(300),
productVendor VARCHAR(100) NOT NULL,
productDescription VARCHAR(300),
quantityInStock INT(8) UNSIGNED NOT NULL,
buyPrice DECIMAL(15, 2) UNSIGNED NOT NULL,
MSRP DECIMAL(15, 2) UNSIGNED NOT NULL,
CONSTRAINT PK_products_productCode PRIMARY KEY(productCode),
CONSTRAINT UQ_products_productName UNIQUE(productName),
CONSTRAINT FK_products_productLines FOREIGN KEY(productLine) REFERENCES productLines(productLine)
) ENGINE = InnoDB;
CREATE TABLE customers (
customerNumber INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
customerName VARCHAR(100) NOT NULL,
contactLastName VARCHAR(100),
contactFirstName VARCHAR(100),
phone VARCHAR(10) NOT NULL,
addressLine1 VARCHAR(300) NOT NULL,
addressLine2 VARCHAR(100) DEFAULT NULL,
city VARCHAR(50) NOT NULL,
state VARCHAR(50) DEFAULT NULL,
postalCode VARCHAR(6) NOT NULL,
country VARCHAR(50) NOT NULL,
salesRepEmployeeNumber INT(8),
creditLimit DECIMAL(11, 2) UNSIGNED DEFAULT 0.00,
CONSTRAINT PK_customerNumber PRIMARY KEY(customerNumber),
CONSTRAINT UQ_customers_phone UNIQUE(phone),
CONSTRAINT FK_employees_customers FOREIGN KEY(salesRepEmployeeNumber) REFERENCES employees(employeeNumber)
) ENGINE = InnoDB;
CREATE TABLE orders (
orderNumber INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
orderDate DATETIME NOT NULL,
requiredDate DATETIME,
shippedDate DATETIME NOT NULL,
STATUS VARCHAR(50) NOT NULL,
comments VARCHAR(300),
customerNumber INT(8) UNSIGNED NOT NULL,
CONSTRAINT PK_orders PRIMARY KEY(orderNumber),
CONSTRAINT FK_customers_orders FOREIGN KEY(customerNumber) REFERENCES customers(customerNumber)
) ENGINE = InnoDB;
CREATE TABLE orderDetails (
orderNumber INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
productCode INT(8) UNSIGNED NOT NULL,
quantityOrdered INT(8) UNSIGNED NOT NULL,
priceEach DECIMAL(15, 2) NOT NULL,
orderLineNumber INT(8),
CONSTRAINT PK_orderDetails_orderNumber_productCode PRIMARY KEY(orderNumber, productCode),
CONSTRAINT FK_orderDetails_productCode FOREIGN KEY(productCode) REFERENCES products(productCode)
) ENGINE = InnoDB;
CREATE TABLE payments (
customerNumber INT(8) UNSIGNED NOT NULL,
checkNumber INT(8) UNSIGNED,
paymentDate DATETIME NOT NULL,
amount DECIMAL(15, 2) NOT NULL,
CONSTRAINT PK_payments_customerNumber_checkNumber PRIMARY KEY(customerNumber, checkNumber),
CONSTRAINT UQ_payments_checkNumber UNIQUE(checkNumber),
CONSTRAINT FK_customers_payments_customerNumber FOREIGN KEY(customerNumber) REFERENCES customers(customerNumber)
) ENGINE = InnoDB;

0 replies

Task - DDL & ER Diagram - Order Management System #2

Uh oh!

akash-coded Mar 11, 2022 Maintainer

Replies: 43 comments · 1 reply

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

CREATE

INSERT

Retrieve all data from the three tables respectively.

Update any employee’s extension and email.

Delete a customer record where the customer is from USA.

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

akash-coded
Mar 11, 2022
Maintainer

Replies: 43 comments 1 reply