repair.sql

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

CREATE TABLE HSEMAN.Repair
(
  RepairId	Smallint PRIMARY KEY,
  HouseId	Smallint,
  RepairItem	Varchar2(200),
  RecordDate	Char(10),
  RepairEmp	  Varchar2(50),
  FinishDate	Char(10),
  Servicefee	Number(15, 2),
  Materialfee	Number(15, 2)
)
TABLESPACE USERS;