createprodax.sql

县级供电企业电费核算源码, 在客户处正常运行8年以上, Delphi 5开发,数据库为Interbase/Firebird, 深入使用Procedure和Trigger等, 对入门者具有很好的参考价值

时间：2001-5-16 
作者：蒋跃明
内容：建立Prodax表Transfer和House用来作数据输出用，输出的数据将被引入到公司的中心数据库

表的定义如下：
Create Table Transfer
(
	F_Transfer_No Char(6) Not Null,
	F_Transfer_Name Char(20),
	F_PowerCount Integer,
	F_NormalCount Integer,
	F_BuyCount Numeric(12,2),
	F_ProvideCount Numeric(12,2),
	Constraint F_Key Primary Key(F_Transfer_No)
)

Create Table House
(
	F_House_No Char(12) Not Null,
	F_Transfer_No Char(6),
	F_House_Name Char(20),
	F_Ct SmallInt,
	F_Used_Count Numeric(12,2),
	F_Elect_No Char(2),
	F_LateFee Numeric(10,2),
	F_Used_Amount Numeric(10,2),
	Constraint F_Key Primary key(F_House_No)
)

Create Table Transfer_Fee 
(
   F_transfer_no char(6) Not Null,/*变压器编号*/
   F_line_no char(3),/*线路*/
   F_transfer_name char(20),/*变压器名称*/
   F_counter integer,/*票数*/
   F_BuyCount integer,/*购电量*/
/*用电类别1*/
  F_COUNT1 Integer,/*用电量*/
  F_COUNTRYAMOUNT1 Numeric(12,2),/*国价费*/
  F_SERVICEAMOUNT1 Numeric(12,2),/*维护费*/
  F_AMOUNT1 Numeric(12,2),/*合计*/
/*用电类别2*/
  F_COUNT2 Integer,
  F_COUNTRYAMOUNT2 Numeric(12,2),
  F_SERVICEAMOUNT2 Numeric(12,2),
  F_AMOUNT2 Numeric(12,2),
/*用电类别3*/
  F_COUNT3 Integer,
  F_COUNTRYAMOUNT3 Numeric(12,2),
  F_SERVICEAMOUNT3 Numeric(12,2),
  F_AMOUNT3 Numeric(12,2),
/*用电类别4*/
  F_COUNT4 Integer,
  F_COUNTRYAMOUNT4 Numeric(12,2),
  F_SERVICEAMOUNT4 Numeric(12,2),
  F_AMOUNT4 Numeric(12,2),
/*用电类别5*/
  F_COUNT5 Integer,
  F_COUNTRYAMOUNT5 Numeric(12,2),
  F_SERVICEAMOUNT5 Numeric(12,2),
  F_AMOUNT5 Numeric(12,2),
/*合计*/
   F_count integer,/*电量*/
   F_countryAmount numeric(12,2),/*国价费*/
   F_serviceAmount numeric(12,2),/*维护费*/
   F_Arrearage numeric(12,2),/*欠费*/
   F_LateFee numeric(12,2),/*滞纳金*/
   F_Amount numeric(12,2),/*电费*/
   Constraint F_Key Primary Key(F_Transfer_No)
)


Create Table transfer_wasting 
(
   f_line_no char(3),/*线路*/
   f_transfer_no char(6),/*变压器编号*/
   f_transfer_name char(20),/*变压器名称*/
   f_counter integer,/*票数*/
   f_count integer,/*电量*/
   f_countryAmount numeric(12,2),/*国价费*/
   f_serviceAmount numeric(12,2),/*维护费*/
   f_Arrearage numeric(12,2),/*欠费*/
   f_LateFee numeric(12,2),/*滞纳金*/
   f_Amount numeric(12,2),/*电费*/
   f_BuyCount integer,/*购电量*/
   f_WastCount integer,/*损失电量*/
   f_WastRate numeric(12,3)/*线损率*/
)