createtable.sql

J2EE之EJB,RMI多个源码

drop table Registration;
create table Registration (cRegistration_id int not null primary key,cFirst_name char(50) not null,cLast_name char(50) not null,cAddress char(50) not null,cAccount_type char(30) not null,mAnnual_income decimal null,cPhone_no char(10) not null);

drop table Account_Holder;
create table Account_Holder(cAccount_id char(10) not null primary key,cRegistration_id int not null references Registration(cRegistration_id),mBalance decimal not null);

drop table Account_Holder_Transaction;
create table Account_Holder_Transaction(cAccount_id char(10) not null references Account_Holder(cAccount_id),dDate_of_transaction char(10) not null,vcParticulars varchar(50) not null,cCheck_no char(10) null,mAmount decimal not null);

insert into Registration values(100,'Diana','Helbert','Bay 
Road,Singapore 5892','Savings',34000,'02163467');
insert into Registration values(101,'Jim','Hopkins','Stockholm street SW 678902','Current',60000,'032234');
insert into Registration values(102,'Diana','Hayden','10 Hays street ,NY 30570','Savings',240000,'045678');
insert into Registration values(103,'Bob','Meakings','23 SunLey House,CA 45678','Fixed Deposit',450000,'02145');
insert into Registration values(104,'Laurry','Helbert','Rock St.Seattle 234657','Fixed Deposit',450000,'0416348');
insert into Registration values(105,'Shane','Cornway','25,Mackin St.CA 31435','Savings',200000,'041656');

insert into Account_Holder values('AH0001',100,500000);
insert into Account_Holder values('AH0002',101,100000);
insert into Account_Holder values('AH0003',102,100000);
insert into Account_Holder values('AH0004',103,150000);
insert into Account_Holder values('AH0005',104,145000);

exit;