SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Store( BranchNo VARCHAR(10) NOT NULL, StoreCategory VARCHAR(20), Name VARCHAR(20) NOT NULL, Logo VARCHAR(5) NOT NULL, Rate VARCHAR(15), WorkHours VARCHAR(40), Address VARCHAR(30) NOT NULL, DeliveryApproxTime VARCHAR(20), OfferPercentage DECIMAL(2,2), CHECK (Rate IN('1 Star', '2 Stars', '3 Stars', '4 Stars', '5 Stars')), PRIMARY KEY (BranchNo)); CREATE TABLE Driver( PhoneNo Char (10) not NULL, Name Varchar (20) not NULL, Photo Varchar (5), Rate Varchar(15), CurrentAddress Varchar(20) not NULL, CHECK (Rate IN('1 Star', '2 Stars', '3 Stars', '4 Stars', '5 Stars')), PRIMARY KEY (PhoneNo)) ; CREATE TABLE Customer( PhoneNo Char(10) not NULL, Email Varchar (20), Passwords Varchar (8) not NULL, Fname Varchar(15) not NULL, Lname Varchar(15) not NULL, Neighborhood Varchar(20) not NULL , Street Varchar(15) not NULL, Wallet Varchar(10), PRIMARY KEY (PhoneNo)); Create table Products( ProductNo Varchar(20) not NULL, Description Varchar(70), Quantity numeric(10) not null, Price Decimal(10,2) not null, PRIMARY KEY (ProductNo)); Create table Contains_( ProductNo, OrderNo, PRIMARY KEY(ProductNo, OrderNo), FOREIGN KEY(ProductNo) references Products (ProductNo), FOREIGN KEY(OrderNo)references Order(OrderNo)); CREATE TABLE Order_ ( OrderNo Varchar (10) NOT NULL, OrderDate DATE, OrderTime TIME, Cupon Varchar (10), PaymentMethod Varchar (20) NOT NULL, TotalPrice Decimal (15) NOT NULL, Status_ Varchar (15) NOT NULL, BranchNo, DPhoneNo, CPhoneNo, DeliveryTime TIME, PRIMARY KEY (OrderNo), FOREIGN KEY (BranchNo) REFERENCES Store(BranchNo), FOREIGN KEY (CPhoneNo) REFERENCES Customer(PhoneNo), FOREIGN KEY (DPhoneNo) REFERENCES Driver(PhoneNo));
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear