本ページは,毎日1回午前3時時点のデータベース登録情報をもとに作成しています.したがって,本日登録・修正した変更内容は反映していません.本日作業分の変更内容の反映には,明日までお待ち下さい.


Table Definition : "Article"


Definition of Article.


Relational tables associated with Article.

Primary table: "t_10001"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.kind c_kind mtext EID
 v_kind
 e_kind integer[] list of EID in this column.
 article.language c_language mtext EID
 v_language
 e_language integer[] list of EID in this column.
 article.invitation c_invitation mtext EID
 v_invitation
 e_invitation integer[] list of EID in this column.
 article.judge c_judge mtext EID
 v_judge
 e_judge integer[] list of EID in this column.
 article.category c_category mtext EID
 v_category
 e_category integer[] list of EID in this column.
 article.collaboration c_collaboration mtext EID
 v_collaboration
 e_collaboration integer[] list of EID in this column.
 article.scholarclass c_scholar mtext EID
 v_scholar
 e_scholar integer[] list of EID in this column.
 article.organization c_organization mtext[] EID
 v_organization
 e_organization integer[] list of EID in this column.
 article.author c_author mtext[] NAME
 v_author
 e_author integer[] list of EID in this column.
 article.author.role c_author_role mtext[] SENTENCE
 v_author_role
 e_author_role integer[] list of EID in this column.
 article.author.contribution c_author_contribution int4[] INTEGER
 v_author_contribution
 e_author_contribution integer[] list of EID in this column.
 article.author.studentcode c_author_studentcode text[] EXTID
 v_author_studentcode
 e_author_studentcode integer[] list of EID in this column.
 article.author.affiliate c_author_affiliate mtext[] EID
 v_author_affiliate
 e_author_affiliate integer[] list of EID in this column.
 article.author.title c_author_title mtext[] EID
 v_author_title
 e_author_title integer[] list of EID in this column.
 article.title c_title mtext SENTENCE
 v_title
 e_title integer[] list of EID in this column.
 article.subtitle c_subtitle mtext SENTENCE
 v_subtitle
 e_subtitle integer[] list of EID in this column.
 article.summary c_summary mtext PARAGRAPH
 v_summary
 e_summary integer[] list of EID in this column.
 article.keyword c_keyword mtext[] NAME
 v_keyword
 e_keyword integer[] list of EID in this column.
 article.publisher c_publisher mtext[] NAME
 v_publisher
 e_publisher integer[] list of EID in this column.
 article.magazine c_magazine mtext NAME
 v_magazine
 e_magazine integer[] list of EID in this column.
 article.magazine.issn c_issn text EXTID
 v_issn
 e_issn integer[] list of EID in this column.
 article.volume c_volume text TEXT
 v_volume
 e_volume integer[] list of EID in this column.
 article.number c_number text TEXT
 v_number
 e_number integer[] list of EID in this column.
 article.page c_page text TEXT2
 v_page
 e_page integer[] list of EID in this column.
 article.city c_city mtext NAME
 v_city
 e_city integer[] list of EID in this column.
 article.date c_date int4 DATE
 v_date
 e_date integer[] list of EID in this column.
 article.url c_url text URL
 v_url
 e_url integer[] list of EID in this column.
 article.doi c_doi text EXTID
 v_doi
 e_doi integer[] list of EID in this column.
 article.pmid c_pmid text EXTID
 v_pmid
 e_pmid integer[] list of EID in this column.
 article.crid c_crid text EXTID
 v_crid
 e_crid integer[] list of EID in this column.
 article.naid c_naid text EXTID
 v_naid
 e_naid integer[] list of EID in this column.
 article.wos c_wos text EXTID
 v_wos
 e_wos integer[] list of EID in this column.
 article.scopus c_scopus text EXTID
 v_scopus
 e_scopus integer[] list of EID in this column.
 article.tuir c_tuir text EXTID
 v_tuir
 e_tuir integer[] list of EID in this column.
 article.valuation c_valuation int4 INTEGER
 v_valuation
 e_valuation integer[] list of EID in this column.
 article.citation c_citation int4 INTEGER
 v_citation
 e_citation integer[] list of EID in this column.
 article.teacher c_teacher mtext[] EID
 v_teacher
 e_teacher integer[] list of EID in this column.
 article.note c_note mtext[] SENTENCE
 v_note
 e_note integer[] list of EID in this column.
 l_eid integer[] list of EID in this tuple.
 l_peid integer[] list of authorized EID in this tuple.

Secondary tables:
"t_10001_kind"     --- associated with article.kind
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.kind r_idx0 integer subscript in primary tuple.
 c_kind mtext EID
 v_kind
 e_kind integer[] list of EID in this column.

"t_10001_language"     --- associated with article.language
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.language r_idx0 integer subscript in primary tuple.
 c_language mtext EID
 v_language
 e_language integer[] list of EID in this column.

"t_10001_invitation"     --- associated with article.invitation
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.invitation r_idx0 integer subscript in primary tuple.
 c_invitation mtext EID
 v_invitation
 e_invitation integer[] list of EID in this column.

"t_10001_judge"     --- associated with article.judge
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.judge r_idx0 integer subscript in primary tuple.
 c_judge mtext EID
 v_judge
 e_judge integer[] list of EID in this column.

"t_10001_category"     --- associated with article.category
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.category r_idx0 integer subscript in primary tuple.
 c_category mtext EID
 v_category
 e_category integer[] list of EID in this column.

"t_10001_collaboration"     --- associated with article.collaboration
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.collaboration r_idx0 integer subscript in primary tuple.
 c_collaboration mtext EID
 v_collaboration
 e_collaboration integer[] list of EID in this column.

"t_10001_scholar"     --- associated with article.scholarclass
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.scholarclass r_idx0 integer subscript in primary tuple.
 c_scholar mtext EID
 v_scholar
 e_scholar integer[] list of EID in this column.

"t_10001_organization"     --- associated with article.organization
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.organization r_idx0 integer subscript in primary tuple.
 c_organization mtext[] EID
 v_organization
 e_organization integer[] list of EID in this column.

"t_10001_author"     --- associated with article.author
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.author r_idx0 integer subscript in primary tuple.
 c_author mtext NAME
 v_author
 e_author integer[] list of EID in this column.
 article.author.role c_author_role mtext SENTENCE
 v_author_role
 e_author_role integer[] list of EID in this column.
 article.author.contribution c_author_contribution int4 INTEGER
 v_author_contribution
 e_author_contribution integer[] list of EID in this column.
 article.author.studentcode c_author_studentcode text EXTID
 v_author_studentcode
 e_author_studentcode integer[] list of EID in this column.
 article.author.affiliate c_author_affiliate mtext[] EID
 v_author_affiliate
 e_author_affiliate integer[] list of EID in this column.
 article.author.title c_author_title mtext EID
 v_author_title
 e_author_title integer[] list of EID in this column.

"t_10001_author_role"     --- associated with article.author.role
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.author r_idx0 integer subscript in primary tuple.
 c_author mtext NAME
 v_author
 e_author integer[] list of EID in this column.
 article.author.role r_idx1 integer subscript in super column.
 c_author_role mtext SENTENCE
 v_author_role
 e_author_role integer[] list of EID in this column.

"t_10001_author_contributi"     --- associated with article.author.contribution
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.author r_idx0 integer subscript in primary tuple.
 c_author mtext NAME
 v_author
 e_author integer[] list of EID in this column.
 article.author.contribution r_idx1 integer subscript in super column.
 c_author_contribution int4 INTEGER
 v_author_contribution
 e_author_contribution integer[] list of EID in this column.

"t_10001_author_studentcod"     --- associated with article.author.studentcode
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.author r_idx0 integer subscript in primary tuple.
 c_author mtext NAME
 v_author
 e_author integer[] list of EID in this column.
 article.author.studentcode r_idx1 integer subscript in super column.
 c_author_studentcode text EXTID
 v_author_studentcode
 e_author_studentcode integer[] list of EID in this column.

"t_10001_author_affiliate"     --- associated with article.author.affiliate
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.author r_idx0 integer subscript in primary tuple.
 c_author mtext NAME
 v_author
 e_author integer[] list of EID in this column.
 article.author.affiliate r_idx1 integer subscript in super column.
 c_author_affiliate mtext[] EID
 v_author_affiliate
 e_author_affiliate integer[] list of EID in this column.

"t_10001_author_title"     --- associated with article.author.title
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.author r_idx0 integer subscript in primary tuple.
 c_author mtext NAME
 v_author
 e_author integer[] list of EID in this column.
 article.author.title r_idx1 integer subscript in super column.
 c_author_title mtext EID
 v_author_title
 e_author_title integer[] list of EID in this column.

"t_10001_title"     --- associated with article.title
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.title r_idx0 integer subscript in primary tuple.
 c_title mtext SENTENCE
 v_title
 e_title integer[] list of EID in this column.

"t_10001_subtitle"     --- associated with article.subtitle
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.subtitle r_idx0 integer subscript in primary tuple.
 c_subtitle mtext SENTENCE
 v_subtitle
 e_subtitle integer[] list of EID in this column.

"t_10001_summary"     --- associated with article.summary
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.summary r_idx0 integer subscript in primary tuple.
 c_summary mtext PARAGRAPH
 v_summary
 e_summary integer[] list of EID in this column.

"t_10001_keyword"     --- associated with article.keyword
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.keyword r_idx0 integer subscript in primary tuple.
 c_keyword mtext NAME
 v_keyword
 e_keyword integer[] list of EID in this column.

"t_10001_publisher"     --- associated with article.publisher
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.publisher r_idx0 integer subscript in primary tuple.
 c_publisher mtext[] NAME
 v_publisher
 e_publisher integer[] list of EID in this column.

"t_10001_magazine"     --- associated with article.magazine
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.magazine r_idx0 integer subscript in primary tuple.
 c_magazine mtext NAME
 v_magazine
 e_magazine integer[] list of EID in this column.
 article.magazine.issn c_issn text EXTID
 v_issn
 e_issn integer[] list of EID in this column.

"t_10001_issn"     --- associated with article.magazine.issn
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.magazine r_idx0 integer subscript in primary tuple.
 c_magazine mtext NAME
 v_magazine
 e_magazine integer[] list of EID in this column.
 article.magazine.issn r_idx1 integer subscript in super column.
 c_issn text EXTID
 v_issn
 e_issn integer[] list of EID in this column.

"t_10001_volume"     --- associated with article.volume
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.volume r_idx0 integer subscript in primary tuple.
 c_volume text TEXT
 v_volume
 e_volume integer[] list of EID in this column.

"t_10001_number"     --- associated with article.number
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.number r_idx0 integer subscript in primary tuple.
 c_number text TEXT
 v_number
 e_number integer[] list of EID in this column.

"t_10001_page"     --- associated with article.page
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.page r_idx0 integer subscript in primary tuple.
 c_page text TEXT2
 v_page
 e_page integer[] list of EID in this column.

"t_10001_city"     --- associated with article.city
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.city r_idx0 integer subscript in primary tuple.
 c_city mtext NAME
 v_city
 e_city integer[] list of EID in this column.

"t_10001_date"     --- associated with article.date
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.date r_idx0 integer subscript in primary tuple.
 c_date int4 DATE
 v_date
 e_date integer[] list of EID in this column.

"t_10001_url"     --- associated with article.url
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.url r_idx0 integer subscript in primary tuple.
 c_url text URL
 v_url
 e_url integer[] list of EID in this column.

"t_10001_doi"     --- associated with article.doi
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.doi r_idx0 integer subscript in primary tuple.
 c_doi text EXTID
 v_doi
 e_doi integer[] list of EID in this column.

"t_10001_pmid"     --- associated with article.pmid
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.pmid r_idx0 integer subscript in primary tuple.
 c_pmid text EXTID
 v_pmid
 e_pmid integer[] list of EID in this column.

"t_10001_crid"     --- associated with article.crid
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.crid r_idx0 integer subscript in primary tuple.
 c_crid text EXTID
 v_crid
 e_crid integer[] list of EID in this column.

"t_10001_naid"     --- associated with article.naid
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.naid r_idx0 integer subscript in primary tuple.
 c_naid text EXTID
 v_naid
 e_naid integer[] list of EID in this column.

"t_10001_wos"     --- associated with article.wos
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.wos r_idx0 integer subscript in primary tuple.
 c_wos text EXTID
 v_wos
 e_wos integer[] list of EID in this column.

"t_10001_scopus"     --- associated with article.scopus
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.scopus r_idx0 integer subscript in primary tuple.
 c_scopus text EXTID
 v_scopus
 e_scopus integer[] list of EID in this column.

"t_10001_tuir"     --- associated with article.tuir
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.tuir r_idx0 integer subscript in primary tuple.
 c_tuir text EXTID
 v_tuir
 e_tuir integer[] list of EID in this column.

"t_10001_valuation"     --- associated with article.valuation
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.valuation r_idx0 integer subscript in primary tuple.
 c_valuation int4 INTEGER
 v_valuation
 e_valuation integer[] list of EID in this column.

"t_10001_citation"     --- associated with article.citation
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.citation r_idx0 integer subscript in primary tuple.
 c_citation int4 INTEGER
 v_citation
 e_citation integer[] list of EID in this column.

"t_10001_teacher"     --- associated with article.teacher
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.teacher r_idx0 integer subscript in primary tuple.
 c_teacher mtext EID
 v_teacher
 e_teacher integer[] list of EID in this column.

"t_10001_note"     --- associated with article.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 article.note r_idx0 integer subscript in primary tuple.
 c_note mtext SENTENCE
 v_note
 e_note integer[] list of EID in this column.


EDB Working Group <edb-admin (at) web (dot) db (dot) tokushima-u (dot) ac (dot) jp> at Fri Mar 29 03:40:05 2024. (p-db7.edb-private:5433:edb_latest v.15.6, o=8/8, c=2, q=107, h=1442)