Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

bc160401882

      
            
                
            
 run  | edit  | history  | help 0

create database bc160401882

create table CUSTOMER( custID int primary key not null, Name varchar(50) not null, address varchar(50) not null, email varchar(50) not null );

create table CATEGORY( catID int primary key not null, catName varchar(50), intialRate float(50) );

create table SERVICES( serID int primary key not null, serTitle varchar(50) not null, serDescription varchar(max) not null, serCharges float(50) not null );

create table FOODITEM( itemID int primary key not null, itemName varchar(50) not null, description varchar(max) not null, );

create table MENU( menuId int primary key not null, noOfserving int not null, Quantity int not null, noOfItems int not null, );

create table VENUE( location varchar(250) not null, city varchar(250) not null, capacity varchar(250) not null, description varchar(250) not null );

create table EVENT( eId int primary key not null, Date date not null, timeSlot time not null ); insert into EVENT values(1,'07/12/2018', '08:34');

select * from EVENT;

  by  bc160401882, 1 years ago


create database bc160401882

create table CUSTOMER( custID int primary key not null, Name varchar(50) not null, address varchar(50) not null, email varchar(50) not null );

create table CATEGORY( catID int primary key not null, catName varchar(50), intialRate float(50) );

create table SERVICES( serID int primary key not null, serTitle varchar(50) not null, serDescription varchar(max) not null, serCharges float(50) not null );

create table FOODITEM( itemID int primary key not null, itemName varchar(50) not null, description varchar(max) not null, );

create table MENU( menuId int primary key not null, noOfserving int not null, Quantity int not null, noOfItems int not null, );

create table VENUE( location varchar(250) not null, city varchar(250) not null, capacity varchar(250) not null, description varchar(250) not null );

create table EVENT( eId int primary key not null, Date date not null, timeSlot time not null ); insert into EVENT values(1,'07/12/2018', '08:34');

select * from EVENT;

Code
  by  bc160401882, 1 years ago




Please log in to post a comment.
a