charging.sql

来自「Visual Basic + Oracle 9i数据库应用系统开发与实例《小区物」· SQL 代码 · 共 13 行

CREATE TABLE HSEMAN.Charging
(
  ChargeId	Smallint PRIMARY KEY,
  HouseId	Smallint,
  ItemId	Smallint,
  UnitPrice	Number(15,2) DEFAULT 0,
  UnitNum	Smallint,
  Amount1	Number(15,2) DEFAULT 0,
  PayDate	Char(10),
  Receiver	Varchar2(40)
)
TABLESPACE USERS;