prrec.sql

来自「Visual Basic + Oracle 9i数据库应用系统开发与实例(项目售」· SQL 代码 · 共 15 行

CREATE TABLE CALLMAN.PrRec
  (PrId	Number Primary Key,
   Cname	Varchar2(50) NOT NULL,
   Cperson	Varchar2(50),
   Ctel	Varchar2(50),
   Plevel	Varchar2(20) NOT NULL,
   Pdetail	Varchar2(300),
   Ptype	Varchar2(20),
   Pstatus	Varchar2(20)NOT NULL,
   Pcomment	Varchar2(300),
   PEdate	Char(10),
   LogPerson	Varchar2(20),
   Createdate	Char(10)
  );