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


Table Definition : "Study"


Definition of Study.


Relational tables associated with Study.

Primary table: "t_10019"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 study.researcher c_researcher mtext EID
 v_researcher
 e_researcher integer[] list of EID in this column.
 study.field c_field mtext[] NAME
 v_field
 e_field integer[] list of EID in this column.
 study.theme c_theme mtext[] SENTENCE
 v_theme
 e_theme integer[] list of EID in this column.
 study.summary c_summary mtext PARAGRAPH
 v_summary
 e_summary integer[] list of EID in this column.
 study.keyword c_keyword mtext[] NAME
 v_keyword
 e_keyword integer[] list of EID in this column.
 study.collaborate c_collaborate mtext[] SENTENCE
 v_collaborate
 e_collaborate integer[] list of EID in this column.
 study.preference c_preference int4 INTEGER
 v_preference
 e_preference integer[] list of EID in this column.
 study.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_10019_researcher"     --- associated with study.researcher
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 study.researcher r_idx0 integer subscript in primary tuple.
 c_researcher mtext EID
 v_researcher
 e_researcher integer[] list of EID in this column.

"t_10019_field"     --- associated with study.field
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 study.field r_idx0 integer subscript in primary tuple.
 c_field mtext NAME
 v_field
 e_field integer[] list of EID in this column.

"t_10019_theme"     --- associated with study.theme
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 study.theme r_idx0 integer subscript in primary tuple.
 c_theme mtext SENTENCE
 v_theme
 e_theme integer[] list of EID in this column.

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

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

"t_10019_collaborate"     --- associated with study.collaborate
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 study.collaborate r_idx0 integer subscript in primary tuple.
 c_collaborate mtext SENTENCE
 v_collaborate
 e_collaborate integer[] list of EID in this column.

"t_10019_preference"     --- associated with study.preference
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 study.preference r_idx0 integer subscript in primary tuple.
 c_preference int4 INTEGER
 v_preference
 e_preference integer[] list of EID in this column.

"t_10019_note"     --- associated with study.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 study.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=1092)