webeditor.oracle.txt

sms开发主要用于短信平台开发与应用45445倒萨啊打12221答案的第

CREATE TABLE Document(
    DOCUMENTID NUMBER(10) NOT NULL, 
    RECORDID VARCHAR2(16), 
    TEMPLATE VARCHAR2(16), 
    SUBJECT VARCHAR2(254), 
    AUTHOR VARCHAR2(64), 
    FILEDATE DATE, 
    FILETYPE VARCHAR2(50), 
    HTMLPATH VARCHAR2(128), 
    STATUS VARCHAR2(4)); 

CREATE TABLE Document_File(
    FILEID NUMBER(10) NOT NULL, 
    RECORDID VARCHAR2(16), 
    FILENAME VARCHAR2(254), 
    FILETYPE VARCHAR2(4), 
    FILESIZE NUMBER(10), 
    FILEDATE DATE, 
    FILEBODY BLOB , 
    FILEPATH VARCHAR2(128), 
    USERNAME VARCHAR2(64), 
    DESCRIPT VARCHAR2(255)); 

CREATE TABLE Version_File(
    FILEID NUMBER(10) NOT NULL, 
    RECORDID VARCHAR2(16), 
    FILENAME VARCHAR2(254), 
    FILETYPE VARCHAR2(4), 
    FILESIZE NUMBER(10), 
    FILEDATE DATE, 
    FILEBODY BLOB , 
    FILEPATH VARCHAR2(128), 
    USERNAME VARCHAR2(64), 
    DESCRIPT VARCHAR2(255)); 

CREATE TABLE BookMarks(
    BOOKMARKID NUMBER(10) NOT NULL, 
    BOOKMARKNAME VARCHAR2(64), 
    BOOKMARKDESC VARCHAR2(128), 
    BOOKMARKTEXT VARCHAR2(200)); 

CREATE TABLE Document_Signature(
    SIGNATUREID NUMBER(10) NOT NULL, 
    RECORDID VARCHAR2(50), 
    MARKNAME VARCHAR2(64), 
    USERNAME VARCHAR2(64), 
    DATETIME DATE, 
    HOSTNAME VARCHAR2(50), 
    MARKGUID VARCHAR2(128)); 

CREATE TABLE Signature(
    SIGNATUREID NUMBER(10) NOT NULL, 
    USERNAME VARCHAR2(64), 
    PASSWORD VARCHAR2(64), 
    MARKNAME VARCHAR2(254), 
    MARKTYPE VARCHAR2(50), 
    MARKBODY BLOB , 
    MARKPATH VARCHAR2(128), 
    MARKSIZE NUMBER(10), 
    MARKDATE DATE); 

CREATE TABLE Template_File(
    TEMPLATEID NUMBER(10) NOT NULL, 
    RECORDID VARCHAR2(16) NOT NULL, 
    FILENAME VARCHAR2(254), 
    FILETYPE VARCHAR2(50), 
    FILESIZE NUMBER(10), 
    FILEDATE DATE, 
    FILEBODY BLOB , 
    FILEPATH VARCHAR2(255), 
    USERNAME VARCHAR2(64), 
    DESCRIPT VARCHAR2(255)); 

CREATE TABLE Template_BookMarks(
    BOOKMARKID NUMBER(10) NOT NULL, 
    RECORDID VARCHAR2(50), 
    BOOKMARKNAME VARCHAR2(120));