BISION

Tables (24)

AGECOUNT (年齢別検索量)

  • KEYWORDSEQ (Key) — NUMBER — Foreign key → KEYWORD.KEYWORDSEQ — NOT NULL
  • AGE (年齢) — VARCHAR2(100 BYTE )
  • PCMONTHCOUNT (PC月別検索量) — NUMBER
  • MOBILEMONTHCOUNT (MOBILE月別検索量) — NUMBER

BISION_USER (ユーザーテーブル)

  • USERID (ユーザーID) — VARCHAR2(100 BYTE) — Primary key — NOT NULL
  • USERNAME (ユーザー氏氏名) — VARCHAR2(100 BYTE)
  • USERPW (ユーザーPASSWORD) — VARCHAR2(200 BYTE)
  • USERBIRTH (ユーザー生年月日) — VARCHAR2(200 BYTE)
  • USERADDRESS (ユーザーアドレス) — VARCHAR2(1000 BYTE)
  • USERPHONE (ユーザー電話番号) — VARCHAR2(200 BYTE)
  • USERBELONG (ユーザー職業) — VARCHAR2(300 BYTE)
  • USERDIVISION (ユーザー区分) — VARCHAR2(300 BYTE)

CPYAGECOUNT (企業年齢別検索量)

  • CPYKEYWORDSEQ (企業一連番号) — varchar2(200) — Foreign key → CPYKEYWORD.CPYKEYWORDSEQ — NOT NULL
  • AGE (年齢) — VARCHAR2(100 )
  • PCMONTHCOUNT (PC 年齢別検索量) — NUMBER
  • MOBILEMONTHCOUNT (MOBLIE年齢別検索量) — NUMBER

CPYGENDERCOUNT (Untitled)

  • CPYKEYWORDSEQ (企業一連番号) — varchar2(200) — Foreign key → CPYKEYWORD.CPYKEYWORDSEQ — NOT NULL
  • MALEPCUSERCOUNT (男子PC検索量) — NUMBER
  • FEMALEPCUSERCOUNT (女子PC検索量) — NUMBER
  • MALEMOBILEUSERCOUNT (男子MOBLIE検索量) — NUMBER
  • FEMALEMOBILEUSERCOUNT (女子MOBLIE検索量) — NUMBER

CPYKEYWORD (Untitled2)

  • CPYKEYWORDSEQ (企業一連番号) — varchar2(200) — Primary key — NOT NULL
  • CPYKEYWORD (Field) — VARCHAR2(100 BYTE)

CPYMONTHCOUNT (Untitled3)

  • CPYKEYWORDSEQ (企業一連番号) — varchar2(200) — Foreign key → CPYKEYWORD.CPYKEYWORDSEQ — NOT NULL
  • PCCOUNT (PC検索量) — NUMBER
  • MOBILECOUNT (MOBLIE検索量) — NUMBER

CPYNEWSINFO (ニュース詳細情報)

  • NEWS_NO (ニュース一連番号) — NUMBER — Primary key — NOT NULL
  • NEWS_DIVISION (ニュース仕分け) — VARCHAR2(50 BYTE)
  • NEWS_TITLE (ニュースの題目) — VARCHAR2(800 BYTE)
  • NEWS_CONTENT (ニュース内容) — CLOB
  • NEWS_IMAGE (ニュースイメージ経路) — VARCHAR2(3000 BYTE)
  • NEWS_DATE (ニュース開始日) — DATE
  • BYLINE (記事書く) — VARCHAR2(300 BYTE)
  • EMTANALYSIS (鑑定分析結果) — NUMBER
  • CPYKEYWORDSEQ (企業一連番号) — varchar2(200) — Foreign key → CPYKEYWORD.CPYKEYWORDSEQ — NOT NULL

CPYRLIAGECOUNT (Untitled4)

  • CPYRLIKEYWORDSEQ (連関検索一連番号) — NUMBER — Foreign key → CPYRLIKEYWORD.CPYRLIKEYWORDSEQ — NOT NULL
  • AGE (年齢) — VARCHAR2(100 )
  • PCMONTHCOUNT (関連検索PCの月検索量) — NUMBER
  • MOBILEMONTHCOUNT (連関検索MOBLIE月検索量) — NUMBER

CPYRLIGENDERCOUNT (Untitled6)

  • CPYRLIKEYWORDSEQ (連関検索一連番号) — varchar2(200) — Foreign key → CPYRLIKEYWORD.CPYRLIKEYWORDSEQ — NOT NULL
  • MALEPCUSERCOUNT (関連検索男子PCの検索量) — NUMBER
  • FEMALEPCUSERCOUNT (連関検索女子PCの検索量) — NUMBER
  • MALEMOBILEUSERCOUNT (連関検索男子MOBLIE検索量) — NUMBER
  • FEMALEMOBILEUSERCOUNT (連関検索女子MOBLIE検索量) — NUMBER

CPYRLIKEYWORD (Untitled5)

  • CPYRLIKEYWORDSEQ (Key) — NUMBER — Primary key — NOT NULL
  • CPYKEYWORDSEQ (企業一連番号) — varchar2(200) — Foreign key → CPYKEYWORD.CPYKEYWORDSEQ — NOT NULL
  • CPYRLIKEYWORD (Field) — VARCHAR2(200 BYTE)

CPYRLIMONTHCOUNT (Untitled7)

  • CPYRLIKEYWORDSEQ (連関検索一連番号) — NUMBER — Foreign key → CPYRLIKEYWORD.CPYRLIKEYWORDSEQ — NOT NULL
  • PCCOUNT (関連検索PCの月検索量) — NUMBER
  • MOBILECOUNT (連関検索MOBLIE月検索量) — NUMBER

CPYRLIYEARCOUNT (Untitled8)

  • CPYRLIKEYWORDSEQ (連関検索一連番号) — NUMBER — Foreign key → CPYRLIKEYWORD.CPYRLIKEYWORDSEQ — NOT NULL
  • MONTH (区分月) — DATE
  • PCMONTHCOUNT (関連検索PCの月別検索量)
  • MOBILEMONTHCOUNT (関連検索MOBLIE月別検索量)

CPYSTOCK (Untitled9)

  • CPYKEYWORDSEQ (企業一連番号) — varchar2(200) — Foreign key → CPYKEYWORD.CPYKEYWORDSEQ — NOT NULL
  • STOCKVALUE (株式宗家) — NUMBER
  • COUNTRY (国) — VARCHAR2(20 BYTE)
  • MOVEVALUE (変動率) — VARCHAR2(20 BYTE)
  • PER (パーセント) — NUMBER
  • SIGN (記号) — VARCHAR2(10 BYTE)

CPYYEARCOUNT (Untitled10)

  • CPYKEYWORDSEQ (企業一連番号) — varchar2(200) — Foreign key → CPYKEYWORD.CPYKEYWORDSEQ — NOT NULL
  • MONTH (区分月) — DATE
  • PCMONTHCOUNT (PC 月別検索量) — NUMBER
  • MOBILEMONTHCOUNT (MOBILE 月別検索量) — NUMBER

GENDERCOUNT (Untitled12)

  • KEYWORDSEQ (Key) — NUMBER — Foreign key → KEYWORD.KEYWORDSEQ — NOT NULL
  • MALEPCUSERCOUNT (Field)
  • FEMALEPCUSERCOUNT (Field2)
  • MALEMOBILEUSERCOUNT (Field3)
  • FEMALEMOBILEUSERCOUNT (Field4)

KEYWORD (Untitled11)

  • KEYWORDSEQ (Key) — NUMBER — Primary key — NOT NULL
  • KEYWORD (Field2) — VARCHAR2(100 BYTE)

MONTHCOUNT (Untitled13)

  • KEYWORDSEQ (Key) — NUMBER — Foreign key → KEYWORD.KEYWORDSEQ — NOT NULL
  • PCCOUNT (Field) — NUMBER
  • MOBILECOUNT (Field2) — NUMBER
  • Field3

NEWSINFO (Untitled14)

  • NEWS_SEQ (Key) — NUMBER — Primary key — NOT NULL
  • NEWS_DIVISION (Field2) — VARCHAR2(50 BYTE)
  • NEWS_TITLE (Field3) — VARCHAR2(800 BYTE)
  • NEWS_CONTENT (Field4) — CLOB
  • NEWS_IMAGE (Field5) — VARCHAR2(3000 BYTE)
  • NEWS_DATE (Field6) — DATE
  • BYLINE (Field7) — VARCHAR2(300 BYTE)
  • EMTANALYSIS (Field8) — NUMBER
  • KEYWORDSEQ (Key2) — NUMBER — Foreign key → KEYWORD.KEYWORDSEQ — NOT NULL

RLIAGECOUNT (Untitled15)

  • RLIKEYWORDSEQ (Key) — NUMBER — Foreign key → RLIKEYWORD.RLIKEYWORDSEQ — NOT NULL
  • AGE (Field) — VARCHAR2(100 BYTE)
  • PCMONTHCOUNT (Field2) — NUMBER
  • MOBILEMONTHCOUNT (Field3) — NUMBER

RLIGENDERCOUNT (Untitled20)

  • RLIKEYWORDSEQ (Key) — NUMBER — Foreign key → RLIKEYWORD.RLIKEYWORDSEQ — NOT NULL
  • MALEPCUSERCOUNT (Field) — NUMBER
  • FEMALEPCUSERCOUNT (Field2) — NUMBER
  • MALEMOBILEUSERCOUNT (Field3) — NUMBER
  • FEMALEMOBILEUSERCOUNT (Field4) — NUMBER

RLIKEYWORD (Untitled16)

  • RLIKEYWORDSEQ (Key) — NUMBER — Primary key — NOT NULL
  • KEYWORDSEQ (Key2) — NUMBER — Foreign key → KEYWORD.KEYWORDSEQ — NOT NULL
  • KEYWORD (Field2) — VARCHAR2(200 BYTE)

RLIMONTHCOUNT (Untitled17)

  • RLIKEYWORDSEQ (Key) — NUMBER — Foreign key → RLIKEYWORD.RLIKEYWORDSEQ — NOT NULL
  • PCCOUNT (Field) — NUMBER
  • MOBILECOUNT (Field2) — NUMBER

RLIYEARCOUNT (Untitled18)

  • RLIKEYWORDSEQ (Key) — NUMBER — Foreign key → RLIKEYWORD.RLIKEYWORDSEQ — NOT NULL
  • MONTH (Field) — DATE
  • PCMONTHCOUNT (Field2) — NUMBER
  • MOBILEMONTHCOUNT (Field3) — NUMBER

YEARCOUNT (Untitled19)

  • KEYWORDSEQ (Key) — NUMBER — Foreign key → KEYWORD.KEYWORDSEQ — NOT NULL
  • MONTH (Field) — DATE
  • PCMONTHCOUNT (Field2) — NUMBER
  • MOBILEMONTHCOUNT (Field3) — NUMBER