create table Tenant (
id_Tenant char(10) PRIMARY KEY,
nama varchar(50)
);

create table Menu (
id_Menu char(10) PRIMARY KEY,
nama_Menu varchar(50),
harga_Menu number,
id_Tenant char(10),
CONSTRAINT fk_idTenant FOREIGN KEY(id_Tenant) references Tenant
);

create table detailTransaksi (
id_DetailTrans char(10) PRIMARY KEY,
harga_detail number,
jumlah number,
id_Menu char(10),
CONSTRAINT fk_idMenu FOREIGN KEY(id_Menu) references Menu
);

create table Transaksi (
id_Transaksi char(10) PRIMARY KEY,
tanggal date,
tot_harga number,
id_DetailTrans char(10),
CONSTRAINT fk_idDetailTrans FOREIGN KEY(id_Transaksi) references detailTransaksi
);

INSERT into Tenant(id_Tenant,nama) values('TNT001','Kantin Sederhana');
INSERT into Tenant(id_Tenant,nama) values('TNT002','Kantin Roasting');
INSERT into Tenant(id_Tenant,nama) values('TNT003','Kantin Bowo');
INSERT into Tenant(id_Tenant,nama) values('TNT004','Kantin Lowo');

INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU001','Soto Ayam','5000','TNT001');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU002','Soto Kerbau','6000','TNT001');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU003','Nasi Rames ','7000','TNT001');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU004','Nasi Ayam','10000','TNT001');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU005','Nasi Goreng','12000','TNT001');

INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU006','Pecel Lele','13000','TNT002');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU007','Ayam Goreng','6000','TNT002');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU008','Ayam Bakar','6000','TNT002');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU009','Ikan Nila','15000','TNT002');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU010','Ikan Gurame','13000','TNT002');

INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU011','Susu Kedelai Coklat','3000','TNT003');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU012','Susu Soda','3000','TNT003');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU013','Susu Sapi Murni','4000','TNT003');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU014','Susu Murni Nasional','5000','TNT003');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU015','Susu Kambing','4000','TNT003');

INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU016','Swike Kodok','15000','TNT004');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU017','Sate Kambing','13000','TNT004');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU018','Klepon','5000','TNT004');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU019','Lupis','5000','TNT004');
INSERT into Menu(id_Menu,nama_Menu,harga_Menu,id_Tenant) values ('MENU020','Tahu dan Tempe Bacem','4000','TNT004');