create database bwo;
use bwo;
create table Customer(
CustomerID varchar(5) primary key,
CustomerName varchar(20),
CustomerDOB date,
CUstomerPhone varchar(13),
CustomerEmail varchar(20),
CustomerAddress varchar(29));

create table WeddingPackage(
WeddingPackageID varchar(5) primary key,
WeddingPackageName varchar(20),
WeddingPackagePrice int);

create table AdditionalServiceType(
AdditionalServiceTypeID varchar(5) primary key,
AdditionalServiceTypeName varchar(20));

create table AdditionalService(
AdditionalServiceID varchar(5) primary key,
AddtionalServiceTypeID varchar(5),
AdditionalServiceName varchar(20),
AdditionalServicePrice int,
foreign key(AdditionalServiceTypeID) references AdditionalServiceType(AdditionalServiceTypeID));

create table DetailTransaction(
TransactionID varchar(5) primary key,
AdditionalServiceID varchar(5) primary key,
foreign key(TransactionID) references Transaction(TransactionID),
foreign key(AdditionalServiceID) references AdditionalService(AddtitionalServiceID));