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

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

此表适用于购物车等金钱来往账面等等。

-- Table: account

-- DROP TABLE account;

CREATE TABLE account

(

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 '余额';

-- Index: account_no_idx

-- DROP INDEX account_no_idx;

CREATE INDEX account_no_idx

ON account

USING btree

(no COLLATE pg_catalog."default");

账户结余计算

select acc.*,(select sum(balance)+acc.balan