finance_analysis_book_bills

运营费用表

所属应用: finance

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
book_bill_id	book_bill_id	int(10) unsigned	Y		Y
bid	费用流水编号	varchar(32)	N		N
account_id	虚拟账户科目编号	varchar(32)	N		N
journal_type	流水类型	mediumint(9)	N		N
amount	操作金额	decimal(20,3)	N		N
book_time	记账时间	int(10) unsigned	N		N
description	备注	longtext	N		N
gmt_create	创建时间	int(10) unsigned	N		N
taobao_alipay_id	流水的淘宝支付宝id	varchar(32)	N		N
other_alipay_id	流水的商家支付宝id	varchar(32)	N		N
shop_id	店铺名称	varchar(32)	N		N
shop_type	店铺类型	varchar(50)	N		N
fee_item_id	科目名称	int(10) unsigned	N		N

索引

Key name	Column names	Unique	Comment
primary	book_bill_id	Y
idx_bid_shopid	bid, shop_id	Y
idx_book_time	book_time	N
idx_gmt_create	gmt_create	N
idx_c_shop_id	shop_id	N
idx_c_fee_item_id	fee_item_id	N