houseinfo.sql

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

CREATE TABLE HSEMAN.HouseInfo
(
  HouseId    	Smallint NOT NULL,
  BuildingId 	Smallint,
  HouseUnit  	Varchar2(20),
  Floor	Smallint,
  RoomNo	Varchar2(10),
  StyleId	Smallint,
  Ownership	Varchar2(20),
  Memo	Varchar2(600)
)
TABLESPACE USERS;