账户表/余额表/消费储蓄表

中国广东省深圳市龙华新区民治街道溪山美地
518131
+86 13113668890
+86 755 29812080
netkiller@msn.com

id integer NOT NULL DEFAULT nextval(trade_id_seq::regclass), no character varying(10) NOT NULL, -- 账号 balance money NOT NULL DEFAULT 0.00, -- 余额 datetime timestamp without time zone NOT NULL DEFAULT (now())::timestamp(0) without time zone, CONSTRAINT account_pkey PRIMARY KEY (id) WITH ( OIDS=FALSE ALTER TABLE account OWNER TO dba; COMMENT ON COLUMN account.no IS 账号; COMMENT ON COLUMN account.balance IS 余额;

 

select acc.*, (select sum(balance)+acc.balance from account as ac where ac.id acc.id) as profit from account as acc;

test=# select acc.*, (select sum(balance)+acc.balance from account as ac where ac.id acc.id) as profit from account as acc;

 id | no | balance | datetime | profit

----+------+----------+---------------------+---------

 1 | 1000 | $0.00 | 2013-10-09 10:51:10 |

 2 | 1000 | $12.60 | 2013-10-09 10:51:22 | $12.60

 4 | 1000 | $16.80 | 2013-10-09 10:51:42 | $29.40

 5 | 1000 | $100.00 | 2013-10-09 10:51:49 | $129.40

 6 | 1000 | $200.00 | 2013-10-09 10:56:35 | $329.40

 7 | 1000 | $50.45 | 2013-10-09 10:57:23 | $379.85

 8 | 1000 | $75.50 | 2013-10-09 10:57:31 | $455.35

 9 | 1000 | -$55.30 | 2013-10-09 10:59:28 | $400.05

 10 | 1000 | -$200.00 | 2013-10-09 10:59:44 | $200.05

(9 rows)

银行账户类(Accoount)可以为账户存储交易。取款和存款都会产生交易信息。需要记录账户每次交易的信息，包括取钱还是存钱，交易的金额，交易时间和交易之后的余额。系统可以通过账户查询所有的交易次数(最 银行账户类(Accoount)可以为账户存储交易。取款和存款都会产生交易信息。需要记录账户每次交易的信息，包括取钱还是存钱，交易的金额，交易时间和交易之后的余额。系统可以通过账户查询所有的交易次数(最
创建一个银行账户的继承层次，表示银行的所有客户的账户。每个客户都能在他们的银行账户存钱，取钱。但是账户可以分为更具体的两种类型，例如，依靠存款生息的存储账户SavingsAccount类，另一种就是信 创建一个银行账户的继承层次，表示银行的所有客户的账户。每个客户都能在他们的银行账户存钱，取钱。但是账户可以分为更具体的两种类型，例如，依靠存款生息的存储账户SavingsAccount类，另一种就是信
netkiller Nickname：netkiller | English name: Neo chen | QQ: 291379 | 订阅号：netkiller-ebook | 网站：http://www.netkiller.cn