📄 table-oracle-gbk.sql

📁 交易撮合系统是一套买卖信息沟通的平台
💻 SQL
📖 第 1 页 / 共 4 页
字号:
  VOTEID             VARCHAR2(40),
  TAGID              VARCHAR2(40) default 0,
  TAGNAME            VARCHAR2(255),
  ISGUEST            NUMBER(1) default 0,
  PREVIEWATTACH      NUMBER(1) default 0,
  PRIMARY KEY  (ID)
)
######
create index I_FA4_BID on BBSCS_FORUMARCHIVES_4 (BOARDID)
######
create index I_FA4_LASTTIME on BBSCS_FORUMARCHIVES_4 (LASTTIME)
######
create index I_FA4_MID on BBSCS_FORUMARCHIVES_4 (MAINID)
######
create index I_FA4_POSTTIME on BBSCS_FORUMARCHIVES_4 (POSTTIME)
######
create table BBSCS_FORUMARCHIVES_5
(
  ID                 VARCHAR2(40) default '' not null,
  PARENTID           VARCHAR2(40) default '',
  MAINID             VARCHAR2(40) default '',
  BOARDID            NUMBER(20) default 0 not null,
  BOARDNAME          VARCHAR2(60),
  RENUM              NUMBER(11) default 0,
  FACE               NUMBER(2) default 1,
  USERID             VARCHAR2(40),
  USERNAME           VARCHAR2(20),
  NICKNAME           VARCHAR2(60),
  TITLE              VARCHAR2(150),
  DETAIL             CLOB,
  SIGN               CLOB,
  ARTSIZE            NUMBER(11) default 0,
  CLICK              NUMBER(11) default 0,
  POSTTIME           NUMBER(20) default 0,
  LASTTIME           NUMBER(20) default 0,
  IPADDRESS          VARCHAR2(20),
  ISNEW              NUMBER(1) default 0,
  ELITE              NUMBER(20) default 0,
  ELITEID            NUMBER(20) default 0,
  AGREE              NUMBER(11) default 0,
  BEAGAINST          NUMBER(11) default 0,
  CANNOTDEL          NUMBER(1) default 0,
  CANNOTRE           NUMBER(1) default 0,
  COMMEND            NUMBER(20) default 0,
  DELSIGN            NUMBER(1) default 0,
  DELUSERID          VARCHAR2(40),
  DELUSERNAME        VARCHAR2(20),
  DELTIME            NUMBER(20) default 0,
  DELIP              VARCHAR2(20),
  AMEND              VARCHAR2(255),
  DOELITENAME        VARCHAR2(20) default 0,
  DOELITETIME        NUMBER(20) default 0,
  HAVEATTACHFILE     NUMBER(1) default 0,
  ATTACHFILENAME     CLOB,
  LASTPOSTUSERNAME   VARCHAR2(20),
  LASTPOSTTITLE      VARCHAR2(150),
  LASTPOSTNICKNAME   VARCHAR2(60),
  ISTOP              NUMBER(20) default 0,
  ISLOCK             NUMBER(1) default 0,
  AUDITING           NUMBER(1) default 0,
  AUDITINGATTACHFILE NUMBER(1) default 0,
  ISVOTE             NUMBER(1) default 0,
  ISHIDDEN           NUMBER(4) default 0,
  ISHIDDENVALUE      NUMBER(11) default 1,
  EDITTYPE           NUMBER(1) default 0,
  QUOTETEXT          CLOB,
  QUOTEEDITTYPE      NUMBER(1) default 0,
  POSTTYPE           NUMBER(1) default 0,
  TITLECOLOR         NUMBER(2) default 0,
  USERBLOG           NUMBER(1) default 0,
  INDEXSTATUS        NUMBER(1) default 0,
  EMAILINFORM        NUMBER(1) default 0,
  MSGINFORM          NUMBER(1) default 0,
  VOTEID             VARCHAR2(40),
  TAGID              VARCHAR2(40) default 0,
  TAGNAME            VARCHAR2(255),
  ISGUEST            NUMBER(1) default 0,
  PREVIEWATTACH      NUMBER(1) default 0,
  PRIMARY KEY  (ID)
)
######
create index I_FA5_BID on BBSCS_FORUMARCHIVES_5 (BOARDID)
######
create index I_FA5_LASTTIME on BBSCS_FORUMARCHIVES_5 (LASTTIME)
######
create index I_FA5_MID on BBSCS_FORUMARCHIVES_5 (MAINID)
######
create index I_FA5_POSTTIME on BBSCS_FORUMARCHIVES_5 (POSTTIME)
######
create table BBSCS_FORUMARCHIVES_6
(
  ID                 VARCHAR2(40) default '' not null,
  PARENTID           VARCHAR2(40) default '',
  MAINID             VARCHAR2(40) default '',
  BOARDID            NUMBER(20) default 0 not null,
  BOARDNAME          VARCHAR2(60),
  RENUM              NUMBER(11) default 0,
  FACE               NUMBER(2) default 1,
  USERID             VARCHAR2(40),
  USERNAME           VARCHAR2(20),
  NICKNAME           VARCHAR2(60),
  TITLE              VARCHAR2(150),
  DETAIL             CLOB,
  SIGN               CLOB,
  ARTSIZE            NUMBER(11) default 0,
  CLICK              NUMBER(11) default 0,
  POSTTIME           NUMBER(20) default 0,
  LASTTIME           NUMBER(20) default 0,
  IPADDRESS          VARCHAR2(20),
  ISNEW              NUMBER(1) default 0,
  ELITE              NUMBER(20) default 0,
  ELITEID            NUMBER(20) default 0,
  AGREE              NUMBER(11) default 0,
  BEAGAINST          NUMBER(11) default 0,
  CANNOTDEL          NUMBER(1) default 0,
  CANNOTRE           NUMBER(1) default 0,
  COMMEND            NUMBER(20) default 0,
  DELSIGN            NUMBER(1) default 0,
  DELUSERID          VARCHAR2(40),
  DELUSERNAME        VARCHAR2(20),
  DELTIME            NUMBER(20) default 0,
  DELIP              VARCHAR2(20),
  AMEND              VARCHAR2(255),
  DOELITENAME        VARCHAR2(20) default 0,
  DOELITETIME        NUMBER(20) default 0,
  HAVEATTACHFILE     NUMBER(1) default 0,
  ATTACHFILENAME     CLOB,
  LASTPOSTUSERNAME   VARCHAR2(20),
  LASTPOSTTITLE      VARCHAR2(150),
  LASTPOSTNICKNAME   VARCHAR2(60),
  ISTOP              NUMBER(20) default 0,
  ISLOCK             NUMBER(1) default 0,
  AUDITING           NUMBER(1) default 0,
  AUDITINGATTACHFILE NUMBER(1) default 0,
  ISVOTE             NUMBER(1) default 0,
  ISHIDDEN           NUMBER(4) default 0,
  ISHIDDENVALUE      NUMBER(11) default 1,
  EDITTYPE           NUMBER(1) default 0,
  QUOTETEXT          CLOB,
  QUOTEEDITTYPE      NUMBER(1) default 0,
  POSTTYPE           NUMBER(1) default 0,
  TITLECOLOR         NUMBER(2) default 0,
  USERBLOG           NUMBER(1) default 0,
  INDEXSTATUS        NUMBER(1) default 0,
  EMAILINFORM        NUMBER(1) default 0,
  MSGINFORM          NUMBER(1) default 0,
  VOTEID             VARCHAR2(40),
  TAGID              VARCHAR2(40) default 0,
  TAGNAME            VARCHAR2(255),
  ISGUEST            NUMBER(1) default 0,
  PREVIEWATTACH      NUMBER(1) default 0,
  PRIMARY KEY  (ID)
)
######
create index I_FA6_BID on BBSCS_FORUMARCHIVES_6 (BOARDID)
######
create index I_FA6_LASTTIME on BBSCS_FORUMARCHIVES_6 (LASTTIME)
######
create index I_FA6_MID on BBSCS_FORUMARCHIVES_6 (MAINID)
######
create index I_FA6_POSTTIME on BBSCS_FORUMARCHIVES_6 (POSTTIME)
######
create table BBSCS_FORUMARCHIVES_7
(
  ID                 VARCHAR2(40) default '' not null,
  PARENTID           VARCHAR2(40) default '',
  MAINID             VARCHAR2(40) default '',
  BOARDID            NUMBER(20) default 0 not null,
  BOARDNAME          VARCHAR2(60),
  RENUM              NUMBER(11) default 0,
  FACE               NUMBER(2) default 1,
  USERID             VARCHAR2(40),
  USERNAME           VARCHAR2(20),
  NICKNAME           VARCHAR2(60),
  TITLE              VARCHAR2(150),
  DETAIL             CLOB,
  SIGN               CLOB,
  ARTSIZE            NUMBER(11) default 0,
  CLICK              NUMBER(11) default 0,
  POSTTIME           NUMBER(20) default 0,
  LASTTIME           NUMBER(20) default 0,
  IPADDRESS          VARCHAR2(20),
  ISNEW              NUMBER(1) default 0,
  ELITE              NUMBER(20) default 0,
  ELITEID            NUMBER(20) default 0,
  AGREE              NUMBER(11) default 0,
  BEAGAINST          NUMBER(11) default 0,
  CANNOTDEL          NUMBER(1) default 0,
  CANNOTRE           NUMBER(1) default 0,
  COMMEND            NUMBER(20) default 0,
  DELSIGN            NUMBER(1) default 0,
  DELUSERID          VARCHAR2(40),
  DELUSERNAME        VARCHAR2(20),
  DELTIME            NUMBER(20) default 0,
  DELIP              VARCHAR2(20),
  AMEND              VARCHAR2(255),
  DOELITENAME        VARCHAR2(20) default 0,
  DOELITETIME        NUMBER(20) default 0,
  HAVEATTACHFILE     NUMBER(1) default 0,
  ATTACHFILENAME     CLOB,
  LASTPOSTUSERNAME   VARCHAR2(20),
  LASTPOSTTITLE      VARCHAR2(150),
  LASTPOSTNICKNAME   VARCHAR2(60),
  ISTOP              NUMBER(20) default 0,
  ISLOCK             NUMBER(1) default 0,
  AUDITING           NUMBER(1) default 0,
  AUDITINGATTACHFILE NUMBER(1) default 0,
  ISVOTE             NUMBER(1) default 0,
  ISHIDDEN           NUMBER(4) default 0,
  ISHIDDENVALUE      NUMBER(11) default 1,
  EDITTYPE           NUMBER(1) default 0,
  QUOTETEXT          CLOB,
  QUOTEEDITTYPE      NUMBER(1) default 0,
  POSTTYPE           NUMBER(1) default 0,
  TITLECOLOR         NUMBER(2) default 0,
  USERBLOG           NUMBER(1) default 0,
  INDEXSTATUS        NUMBER(1) default 0,
  EMAILINFORM        NUMBER(1) default 0,
  MSGINFORM          NUMBER(1) default 0,
  VOTEID             VARCHAR2(40),
  TAGID              VARCHAR2(40) default 0,
  TAGNAME            VARCHAR2(255),
  ISGUEST            NUMBER(1) default 0,
  PREVIEWATTACH      NUMBER(1) default 0,
  PRIMARY KEY  (ID)
)
######
create index I_FA7_BID on BBSCS_FORUMARCHIVES_7 (BOARDID)
######
create index I_FA7_LASTTIME on BBSCS_FORUMARCHIVES_7 (LASTTIME)
######
create index I_FA7_MID on BBSCS_FORUMARCHIVES_7 (MAINID)
######
create index I_FA7_POSTTIME on BBSCS_FORUMARCHIVES_7 (POSTTIME)
######
create table BBSCS_FORUMARCHIVES_8
(
  ID                 VARCHAR2(40) default '' not null,
  PARENTID           VARCHAR2(40) default '',
  MAINID             VARCHAR2(40) default '',
  BOARDID            NUMBER(20) default 0 not null,
  BOARDNAME          VARCHAR2(60),
  RENUM              NUMBER(11) default 0,
  FACE               NUMBER(2) default 1,
  USERID             VARCHAR2(40),
  USERNAME           VARCHAR2(20),
  NICKNAME           VARCHAR2(60),
  TITLE              VARCHAR2(150),
  DETAIL             CLOB,
  SIGN               CLOB,
  ARTSIZE            NUMBER(11) default 0,
  CLICK              NUMBER(11) default 0,
  POSTTIME           NUMBER(20) default 0,
  LASTTIME           NUMBER(20) default 0,
  IPADDRESS          VARCHAR2(20),
  ISNEW              NUMBER(1) default 0,
  ELITE              NUMBER(20) default 0,
  ELITEID            NUMBER(20) default 0,
  AGREE              NUMBER(11) default 0,
  BEAGAINST          NUMBER(11) default 0,
  CANNOTDEL          NUMBER(1) default 0,
  CANNOTRE           NUMBER(1) default 0,
  COMMEND            NUMBER(20) default 0,
  DELSIGN            NUMBER(1) default 0,
  DELUSERID          VARCHAR2(40),
  DELUSERNAME        VARCHAR2(20),
  DELTIME            NUMBER(20) default 0,
  DELIP              VARCHAR2(20),
  AMEND              VARCHAR2(255),
  DOELITENAME        VARCHAR2(20) default 0,
  DOELITETIME        NUMBER(20) default 0,
  HAVEATTACHFILE     NUMBER(1) default 0,
  ATTACHFILENAME     CLOB,
  LASTPOSTUSERNAME   VARCHAR2(20),
  LASTPOSTTITLE      VARCHAR2(150),
  LASTPOSTNICKNAME   VARCHAR2(60),
  ISTOP              NUMBER(20) default 0,
  ISLOCK             NUMBER(1) default 0,
  AUDITING           NUMBER(1) default 0,
  AUDITINGATTACHFILE NUMBER(1) default 0,
  ISVOTE             NUMBER(1) default 0,
  ISHIDDEN           NUMBER(4) default 0,
  ISHIDDENVALUE      NUMBER(11) default 1,
  EDITTYPE           NUMBER(1) default 0,
  QUOTETEXT          CLOB,
  QUOTEEDITTYPE      NUMBER(1) default 0,
  POSTTYPE           NUMBER(1) default 0,
  TITLECOLOR         NUMBER(2) default 0,
  USERBLOG           NUMBER(1) default 0,
  INDEXSTATUS        NUMBER(1) default 0,
  EMAILINFORM        NUMBER(1) default 0,
  MSGINFORM          NUMBER(1) default 0,
  VOTEID             VARCHAR2(40),
  TAGID              VARCHAR2(40) default 0,
  TAGNAME            VARCHAR2(255),
  ISGUEST            NUMBER(1) default 0,
  PREVIEWATTACH      NUMBER(1) default 0,
  PRIMARY KEY  (ID)
)
######
create index I_FA8_BID on BBSCS_FORUMARCHIVES_8 (BOARDID)
######
create index I_FA8_LASTTIME on BBSCS_FORUMARCHIVES_8 (LASTTIME)
######
create index I_FA8_MID on BBSCS_FORUMARCHIVES_8 (MAINID)
######
create index I_FA8_POSTTIME on BBSCS_FORUMARCHIVES_8 (POSTTIME)
######
create table BBSCS_FORUMARCHIVES_9
(
  ID                 VARCHAR2(40) default '' not null,
  PARENTID           VARCHAR2(40) default '',
  MAINID             VARCHAR2(40) default '',
  BOARDID            NUMBER(20) default 0 not null,
  BOARDNAME          VARCHAR2(60),
  RENUM              NUMBER(11) default 0,
  FACE               NUMBER(2) default 1,
  USERID             VARCHAR2(40),
  USERNAME           VARCHAR2(20),
  NICKNAME           VARCHAR2(60),
  TITLE              VARCHAR2(150),
  DETAIL             CLOB,
  SIGN               CLOB,
  ARTSIZE            NUMBER(11) default 0,
  CLICK              NUMBER(11) default 0,
  POSTTIME           NUMBER(20) default 0,
  LASTTIME           NUMBER(20) default 0,
  IPADDRESS          VARCHAR2(20),
  ISNEW              NUMBER(1) default 0,
  ELITE              NUMBER(20) default 0,
  ELITEID            NUMBER(20) default 0,
  AGREE              NUMBER(11) default 0,
  BEAGAINST          NUMBER(11) default 0,
  CANNOTDEL          NUMBER(1) default 0,
  CANNOTRE           NUMBER(1) default 0,
💿 文件大小 45766 K
👤 上传用户 SAMDUK
📂 所属分类 Jsp/Servlet
🏷️ 相关标签

#沟通
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -