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