pmeter

Tables (4)

Bill_Data

  • comp_name (Field3) — Primary key
  • date (Field) — Primary key
  • bill_apply_power (Field2)
  • maximun_power (Field4)
  • pf_id (Key) — Foreign key → Power_Factor.pf_id — NOT NULL
  • pu_id (Key2) — Foreign key → Power_Type_Usage.ptu_id — NOT NULL
  • rb_id (Key3) — Foreign key → Request_Bill.rb_id — NOT NULL

Power_Factor (Untitled2)

  • pf_id (Key) — Primary key — NOT NULL
  • pf_jin (Field)
  • pf_ji (Field2)
  • pf_cost (Field3)

Power_Type_Usage (Untitled3)

  • ptu_id (Key) — Primary key — NOT NULL
  • ptu_light (Field)
  • ptu_middle (Field2)
  • ptu_max (Field3)
  • ptu_cost (Field4)
  • ptu_total (Field5)

Request_Bill (Untitled4)

  • rb_id (Key) — Primary key — NOT NULL
  • rb_base (Field)
  • rb_kwh (Field2)
  • rb_dc (Field3)
  • rb_electric (Field4)
  • rb_total (Field5)