求银行客户数据库里的储存数据类型? 求帮忙做一个银行数据库 Oracle
\u94f6\u884c\u5361\u53f7\u5728\u6570\u636e\u5e93\u4e2d\u7528\u4ec0\u4e48\u6570\u636e\u7c7b\u578b\u94f6\u884c\u5361\u5b58\u50a8\u7528\u7684\u662f\u5b57\u7b26\u4e32\u7c7b\u578b\u4e5f\u5c31\u662fvarchar\u7c7b\u578b\uff1b
\u5907\u6ce8\uff1a\u56e0\u4e3a\u94f6\u884c\u5361\u7684\u53f7\u7801\u8f83\u957f\uff0c\u5e76\u4e14\u5168\u662f\u6570\u5b57\uff0c\u4e3a\u4e86\u65b9\u4fbf\u5b58\u50a8\uff0c\u5c31\u7edf\u4e00\u5b58\u50a8\u4e3a\u5b57\u7b26\u4e32\u7c7b\u578b\u3002\u5982\u679c\u5b58\u50a8\u4e3anumber\u7c7b\u578b\uff0c\u5df2\u7ecf\u8d85\u51fa\u4e86int\u7c7b\u578b\u6700\u5927\u503c\u8303\u56f4\uff0c\u5fc5\u987b\u7528bigInteger\u5b58\u50a8\uff0c\u5f88\u4e0d\u65b9\u4fbf\u3002\u5e76\u4e14\u4f4d\u6570\u592a\u591a\u7684\u6570\u503c\u4f1a\u53d8\u6210\u79d1\u5b66\u8ba1\u6570\u6cd5\uff0c\u4e0d\u5229\u4e8e\u6570\u636e\u7684\u6b63\u5e38\u8f6c\u6362\uff0c\u6240\u4ee5\u8fd8\u662f\u7528\u5b57\u7b26\u4e32\u7c7b\u578b\u5b58\u50a8\u66f4\u65b9\u4fbf\u4e00\u4e9b\u3002
\u529f\u80fd\u4e00\uff1a
create database bank;
\u529f\u80fd\u4e8c\uff1a
create table userinfo(
customerID number(10) not null,
customerName varchar2(10) not null,
PID char(18) not null,
telephone char(11) not null,
address varchar2(255) not null
);
create table cardinfo(
cardID varchar2(19) not null,
cardCustomerID number(10) not null,
curtype char(3) not null,
savingtype char(4) not null,
openDate date not null,
openmoney number(10,2) not null,
blance number(10,2) not null,
password char(6) not null,
isreportLoss char(2) not null
);
create table transinfo(
id number(15) not null,
transcustomerID number(10) not null,
transcardID varchar2(19) not null,
transdate date not null,
transmoney number(10,2) not null,
transtype char(4) not null,
remark varchar2(255) not null
);
\u529f\u80fd\u4e09\uff1a
alter table userinfo add constraint pk_userinfo primary key (customerID);
alter table userinfo add constraint ck_PID check(length(PID)=18);
alter table cardinfo add constraint pk_cardinfo primary key (cardID);
alter table cardinfo add constraint fk_CustomerID_card foreign key cardCustomerID references userinfo(customerID);
alter table transinfo add constraint pk_transinfo primary key (id);
alter table transinfo add constraint fk_CustomerID_trans foreign key cardCustomerID references userinfo(customerID);
alter table transinfo add constraint fk_transcardID_trans foreign key cardCustomerID references cardinfo(cardID);
\u529f\u80fd\u56db\uff1a
insert into userinfo values(1,'\u5f20\u4e09','123456789012345671','13012345671','\u5730\u57401');
insert into userinfo values(2,'\u674e\u56db','123456789012345672','13012345672','\u5730\u57402');
insert into userinfo values(3,'\u738b\u4e94','123456789012345673','13012345673','\u5730\u57403');
insert into cardinfo values('1234567890123456789',1,'RMB','\u6d3b\u671f',sysdate,5.04,5.04,'123456','\u5426');
insert into cardinfo values('1234567890123456788',2,'JPY','\u6d3b\u671f',sysdate,3.22,3.22,'123457','\u5426');
insert into cardinfo values('1234567890123456787',3,'USA','\u5b9a\u671f',sysdate,6.78,6.78,'123458','\u5426');
insert into transinfo values(1,1,'1234567890123456789',sysdate,0.23,'\u5b58\u5165','\u5b58\u94b1');
insert into transinfo values(2,2,'1234567890123456788',sysdate,1.27,'\u652f\u53d6','\u53d6\u94b1');
insert into transinfo values(3,3,'1234567890123456787',sysdate,2.34,'\u5b58\u5165','\u5b58\u94b1');
\u529f\u80fd\u4e94\uff1a
select transcardID,transmoney from transinfo where to_char(transdate,'mm')=to_char(sysdate,'mm') and transmoney=max(transmoney);
\u529f\u80fd\u516d\uff1a
create procedure p_c
is
cursor cr is
select b.cardID,a.customerName,a.telephone from userinfo a,cardinfo b where a.customerID=b.cardCustomerID and to_char(sysdate,'dd') in ('28','29','30','31') and b.blance<200;
cur_info cr;
begin
for cur_info in cr loop
dbms_output.put_line('\u5361\u53f7\uff1a' || cur_info.cardID || '&&' || '\u59d3\u540d\uff1a' || cur_info.customerName || '\u7535\u8bdd\uff1a' || cur_info.telephone);
end loop;
end p_c;
帐号、姓名等 char
教育金额、余额等decimal
日期char(10)
交易流水号、int居多（或者long）
标志等char(1)
如果是其它数据库，参照对应的数据类型就可以了。
绛旓細鑷充簬杩欏嚑骞村幓IOE,鏈鍚庝篃灏卞幓浜咺BM鐨勫ぇ鏈,Oracle鏁版嵁搴鐓ф牱澶ц妯′娇鐢,EMC鐨勫瓨鍌灏辨洿涓嶇敤璇翠簡銆 鎬讳箣涓鍙ヨ瘽,瀹夊叏浣跨敤缇庡浗浣妧鏈!绱閲戣瀺IT姘戝伐! 娉勫瘑鍒颁笉瀛樺湪,涓鑸浗鍐閾惰鐢∣racle鐨勫悓鏃堕兘浼氳喘涔癘racle鐨勭淮鎶ゆ湇鍔,闄ら潪鐢查鏂囦笉鎯冲仛涓浗鐨勭敓鎰忎簡銆傚綋鐒跺洜涓轰腑缇庡叧绯荤殑闂,涓浜涜宸茬粡寮濮嬩粠鍛ㄨ竟绯荤粺閫愭笎寮濮嬫敼閫犱娇鐢ㄥ浗...
绛旓細绗竴涓係ET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROCEDURE [dbo].[acc_moneyout](@acc_from INTEGER,@acc_to INTEGER,@money INTEGER,@rtn INTEGER OUTPUT)--@rtn琛ㄧず杩斿洖鍊笺傝繑鍥炰负0鏃舵墽琛屾垚鍔熴傚叾浠栧兼椂琛ㄧず閿欒銆備笉闇瑕佸彲鍙栨秷ASBEGIN TRANDECLARE @tran_err INTEGERSET NOCOUNT ON...
绛旓細涓摱锛歋YBASE锛孫RACLE 鍐滆锛歋QL Server锛孲YBASE 宸ュ晢锛歄RACLE 寤鸿锛歩nformix锛孫RACLE 涓俊锛欴B2 鍏夊ぇ锛歄RACLE
绛旓細鏄疧racle,鍚屾椂澶у鏄痡ava绯荤粺
绛旓細鐢ㄥ崕鍒涗俊鎭鐞嗗钩鍙板緢瀹规槗瀹炵幇锛屼綘瑕瀛樺偍浠涔堟牱鐨勪俊鎭紝灏卞缓浠涔堟牱鐨勮〃锛屽彲鑷敱璁剧疆琛ㄧ殑瀛楁锛屽氨鍍廵xcel涓鏍枫傛牴鎹〃鐨勫瓧娈碉紝鑳借嚜鍔ㄧ敓鎴愰〉寮忕殑鏁版嵁鎿嶄綔鐣岄潰锛屽洜姝ゆ煡璇㈠緢鏂逛究鐨勩傝嚦浜庝綘璇寸殑缁熻锛屽彲鑷敱璁剧疆缁熻鎶ヨ〃銆傝繖浜涢兘涓嶉渶瑕佺紪绋嬶紝棰勮1銆2澶╁氨鍙互鎼炲ソ锛屼笉闇瑕佸啓绋嬪簭寮鍙戜簡銆
绛旓細閾惰鍙夋嫨锛1.寮婧愭暟鎹簱锛屽簲鐢ㄥ紑鍙戝晢/闆嗘垚鍟嗗枩娆㈠仛锛屽洜涓哄彲浠ュ悆鎺鏁版嵁搴撶殑棰勭畻銆備絾瀹㈡埛闈复闀挎湡鐨勫彂灞曢棶棰橈紝缁存姢闂銆備骇鍝佺ǔ瀹氭с佹ц兘闂銆2.鍥戒骇鏁版嵁搴擄紝浜у搧鍔熻兘銆佹ц兘銆佺ǔ瀹氭т笉鍙婂紑婧愭暟鎹簱锛屼絾鏈夋妧鏈敮鎸佷繚闅滐紝鍙敤鍦ㄤ竴浜涜竟缂樼郴缁熴3.GBase 8t锛屽紩杩涘浗澶栧厛杩涗骇鍝侊紝婊¤冻鍥戒骇璧勮川锛孖nformix鏈韩鍦...
绛旓細3.鏁版嵁姣斿锛氬彲浠ュ皢鏁版嵁搴撲腑鐨淇℃伅涓庡叾浠栨暟鎹簮杩涜姣斿锛屼互鏍稿疄瀹㈡埛淇℃伅鐨勫噯纭у拰涓鑷存с4.鏁版嵁鐩戞帶锛氬彲浠ュ鏁版嵁搴撲腑鐨勪俊鎭繘琛屽疄鏃剁洃鎺э紝鍙婃椂鍙戠幇寮傚父浜ゆ槗鍜岄闄╀簨浠讹紝浠ヤ究閾惰閲囧彇鐩稿簲鐨勬帾鏂姐5.鏁版嵁澶囦唤锛氬彲浠ュ鏁版嵁搴撲腑鐨勪俊鎭繘琛屽浠藉拰瀛樺偍锛屼互渚垮湪绯荤粺鏁呴殰銆佹暟鎹涪澶辩瓑鎯呭喌涓嬭繘琛屾暟鎹仮澶嶅拰閲嶅缓銆
绛旓細浣犲ソ鐨 涓嶅悓鏁版嵁搴閲囩敤鐨勫瓨鍌涓嶅悓锛涗笉杩囦竴鑸兘鏄娇鐢╫racle鍜孌B2锛涙墍浠ラ噰鐢ㄧ殑瀛楁绫诲瀷涓鑸槸number(m,n);搴旇鏄繖鏍凤紒鏈涢噰绾筹紒
绛旓細鍝,鏅撳緱浜嗗摝鏅撳緱浜嗘垜鏈変竴鍙版憾姘с丳H鎺у埗鍣.鐢盧S-485涓插彛涓庤绠椾氦鎹㈡暟鎹.浣嗗巶瀹跺彧缁欏嚭绠鍗曠殑璁＄畻鏈虹▼搴忥紝鍙兘鍦ㄨ绠楁満閲岀湅鍒版暟鎹紝浣嗕笉鑳借褰曟暟鎹傝繕鏈変竴浠介氳鍗忚,鎴戞兂鐢╒B缂栧啓绋嬪簭鏉ュ鐞嗚鍙栫殑鏁版嵁鍙婄敤鏁版嵁搴撳瓨鍌ㄦ暟鎹.浣嗘湰浜轰互鍓嶄粠鏈帴瑙﹁繃涓插彛绋嬪簭,璇曚簡缂栧啓绋嬪簭锛屾湭鑳借鍙栧埌鏁版嵁锛屾墍浠ヨ鍚勪綅楂樻墜甯繖...
绛旓細涓浗寤鸿閾惰鏁版嵁搴鏍稿績绯荤粺锛坈ore banking锛夌敤鐨勬槸DB2銆侱B2鏄疘BM鐨勬暟鎹簱浜у搧銆傝繖鏄竴涓叧绯绘暟鎹簱绠＄悊绯荤粺锛圧DBMS锛夈 DB2琚璁℃垚瀛樺偍锛屽垎鏋愬拰鏈夋晥鍦版绱㈡暟鎹 DB2浜у搧鎵╁睍浜嗛潰鍚戝璞＄殑鐗规у拰闈炲叧绯诲瀷缁撴瀯浠ュ強XML鐨勬敮鎸併傛暟鎹簱锛Database锛夋槸鎸夌収鏁版嵁缁撴瀯鏉ョ粍缁囥佸瓨鍌ㄥ拰绠＄悊鏁版嵁鐨勪粨搴擄紝瀹冧骇鐢熶簬璺濅粖...
