Oracle Live SQL - Script: askTom

Statement 1

create table suppliers
( 
  sup_tab          NUMBER(3) not null, 
  sup_pad          NUMBER(3) not null, 
  sup_in           NUMBER(7) not null)

Table created.

Statement 2

alter table suppliers
  add constraint pk_agents primary key (sup_tab, sup_pad, sup_in)

Table altered.

Statement 3

insert into suppliers (sup_tab, sup_pad, sup_in) values (53, 1, 1);
insert into suppliers (sup_tab, sup_pad, sup_in) values (53, 1, 2);
insert into suppliers (sup_tab, sup_pad, sup_in) values (53, 1, 3);
insert into suppliers (sup_tab, sup_pad, sup_in) values (53, 1, 77);
insert into suppliers (sup_tab, sup_pad, sup_in) values (53, 1, 78);

Statement 4

create table banks
( 
  bank_tab          NUMBER(3) not null, 
  bank_pad          NUMBER(3) not null, 
  bank_in           NUMBER(7) not null)

Statement 5

alter table banks
  add constraint pk_banks primary key (bank_tab, bank_pad, bank_in)

Statement 6

insert into banks (bank_tab, bank_pad, bank_in) values (53, 1, 88);
insert into banks (bank_tab, bank_pad, bank_in) values (53, 1, 89);
insert into banks (bank_tab, bank_pad, bank_in) values (53, 1, 90);
insert into banks (bank_tab, bank_pad, bank_in) values (53, 1, 91);

Statement 7

create table bills
( 
  org_tab          NUMBER(3) not null, 
  org_pad          NUMBER(3) not null, 
  org_in           NUMBER(7) not null,
  sup_tab          NUMBER(3) not null, 
  sup_pad          NUMBER(3) not null, 
  sup_in           NUMBER(7) not null,
  bill_tab          NUMBER(3) not null, 
  bill_pad          NUMBER(3) not null, 
  bill_in           NUMBER(7) not null)

Statement 8

alter table bills
  add constraint pk_bills primary key (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in)

Statement 9

alter table bills
   add constraint  fk_bills_agents foreign key (sup_tab, sup_pad, sup_in) references suppliers (sup_tab, sup_pad, sup_in)

Statement 10

insert into bills (org_tab, org_pad, org_in, sup_tab, sup_pad, sup_in, bill_tab, bill_pad, bill_in) values (53, 1, 100, 53, 1, 1, 100,1, 1);
insert into bills (org_tab, org_pad, org_in, sup_tab, sup_pad, sup_in, bill_tab, bill_pad, bill_in) values (53, 1, 100, 53, 1, 1, 100,1, 2);
insert into bills (org_tab, org_pad, org_in, sup_tab, sup_pad, sup_in, bill_tab, bill_pad, bill_in) values (53, 1, 100, 53, 1, 1, 100,1, 3);
insert into bills (org_tab, org_pad, org_in, sup_tab, sup_pad, sup_in, bill_tab, bill_pad, bill_in) values (53, 1, 100, 53, 1, 2, 100,1, 4);
insert into bills (org_tab, org_pad, org_in, sup_tab, sup_pad, sup_in, bill_tab, bill_pad, bill_in) values (53, 1, 200, 53, 1, 2, 100,1, 5);
insert into bills (org_tab, org_pad, org_in, sup_tab, sup_pad, sup_in, bill_tab, bill_pad, bill_in) values (53, 1, 200, 53, 1, 1, 100,1, 6);
insert into bills (org_tab, org_pad, org_in, sup_tab, sup_pad, sup_in, bill_tab, bill_pad, bill_in) values (53, 1, 200, 53, 1, 1, 100,1, 7);
insert into bills (org_tab, org_pad, org_in, sup_tab, sup_pad, sup_in, bill_tab, bill_pad, bill_in) values (53, 1, 200, 53, 1, 1, 100,1, 8);
insert into bills (org_tab, org_pad, org_in, sup_tab, sup_pad, sup_in, bill_tab, bill_pad, bill_in) values (53, 1, 200, 53, 1, 2, 100,1, 9);

Statement 11

create table payments
( 
  org_tab          NUMBER(3) not null, 
  org_pad         NUMBER(3) not null, 
  org_in            NUMBER(7) not null,
  bank_tab           NUMBER(3) not null, 
  bank_pad          NUMBER(3) not null, 
  bank_in             NUMBER(7) not null,
  pay_tab          NUMBER(3) not null, 
  pay_pad         NUMBER(3) not null, 
  pay_in            NUMBER(7) not null,
pay_day           DATE not null)

Statement 12

alter table payments add constraint pk_payments primary key (org_tab, org_pad, org_in, pay_tab, pay_pad, pay_in)

Statement 13

alter table payments
   add constraint  fk_payments_banks foreign key (bank_tab, bank_pad, bank_in) references banks (bank_tab, bank_pad, bank_in)

Statement 14

insert into payments (org_tab, org_pad, org_in, bank_tab, bank_pad, bank_in, pay_tab, pay_pad, pay_in, pay_day) values (53, 1, 100, 53, 1, 91, 100,1, 10, '10-JAN-2020');
insert into payments (org_tab, org_pad, org_in, bank_tab, bank_pad, bank_in, pay_tab, pay_pad, pay_in, pay_day) values (53, 1, 100, 53, 1, 88, 100,1, 11, '12-JAN-2020');
insert into payments (org_tab, org_pad, org_in, bank_tab, bank_pad, bank_in, pay_tab, pay_pad, pay_in, pay_day) values (53, 1, 100, 53, 1, 88, 100,1, 12, '15-JAN-2020');
insert into payments (org_tab, org_pad, org_in, bank_tab, bank_pad, bank_in, pay_tab, pay_pad, pay_in, pay_day) values (53, 1, 100, 53, 1, 88, 100,1, 13, '18-JAN-2020');
insert into payments (org_tab, org_pad, org_in, bank_tab, bank_pad, bank_in, pay_tab, pay_pad, pay_in, pay_day) values (53, 1, 200, 53, 1, 90, 100,1, 14, '19-JAN-2020');
insert into payments (org_tab, org_pad, org_in, bank_tab, bank_pad, bank_in, pay_tab, pay_pad, pay_in, pay_day) values (53, 1, 200, 53, 1, 91, 100,1, 15, '17-JAN-2020');
insert into payments (org_tab, org_pad, org_in, bank_tab, bank_pad, bank_in, pay_tab, pay_pad, pay_in, pay_day) values (53, 1, 200, 53, 1, 91, 100,1, 16, '16-JAN-2020');
insert into payments (org_tab, org_pad, org_in, bank_tab, bank_pad, bank_in, pay_tab, pay_pad, pay_in, pay_day) values (53, 1, 200, 53, 1, 89, 100,1, 17, '18-JAN-2020');

Statement 15

create table bills_payments
( 
  org_tab          NUMBER(3) not null, 
  org_pad         NUMBER(3) not null, 
  org_in            NUMBER(7) not null,
  bill_tab           NUMBER(3) not null, 
  bill_pad          NUMBER(3) not null, 
  bill_in             NUMBER(7) not null,
  pay_tab          NUMBER(3) not null, 
  pay_pad         NUMBER(3) not null, 
  pay_in            NUMBER(7) not null)

Statement 16

alter table bills_payments
  add constraint pk_bills_payments primary key (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in, pay_tab, pay_pad, pay_in)

Statement 17

alter table bills_payments
   add constraint  fk_payments foreign key (org_tab, org_pad, org_in, pay_tab, pay_pad, pay_in) references payments (org_tab, org_pad, org_in, pay_tab, pay_pad, pay_in)

Statement 18

alter table bills_payments
   add constraint  fk_bills foreign key (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in) references bills (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in)

Statement 19

insert into bills_payments (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in, pay_tab, pay_pad, pay_in) values (53, 1, 100, 100, 1, 1, 100, 1, 10); 
insert into bills_payments (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in, pay_tab, pay_pad, pay_in) values (53, 1, 100, 100, 1, 2, 100, 1, 11);
insert into bills_payments (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in, pay_tab, pay_pad, pay_in) values (53, 1, 100, 100, 1, 3, 100, 1, 12);
insert into bills_payments (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in, pay_tab, pay_pad, pay_in) values (53, 1, 100, 100, 1, 4, 100, 1, 13);
insert into bills_payments (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in, pay_tab, pay_pad, pay_in) values (53, 1, 200, 100, 1, 5, 100, 1, 14);
insert into bills_payments (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in, pay_tab, pay_pad, pay_in) values (53, 1, 200, 100, 1, 6, 100, 1, 15);
insert into bills_payments (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in, pay_tab, pay_pad, pay_in) values (53, 1, 200, 100, 1, 7, 100, 1, 16);
insert into bills_payments (org_tab, org_pad, org_in, bill_tab, bill_pad, bill_in, pay_tab, pay_pad, pay_in) values (53, 1, 200, 100, 1, 9, 100, 1, 17);

askTom

Additional Information