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


Table Definition : "Collaboration"


Definition of Collaboration.


Relational tables associated with Collaboration.

Primary table: "t_10002"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 collaboration.organization c_organization mtext[] NAME
 v_organization
 e_organization integer[] list of EID in this column.
 collaboration.organization.researcher c_organ_researcher mtext[] NAME
 v_organ_researcher
 e_organ_researcher integer[] list of EID in this column.
 collaboration.researcher c_researcher mtext[] EID
 v_researcher
 e_researcher integer[] list of EID in this column.
 collaboration.class c_class mtext EID
 v_class
 e_class integer[] list of EID in this column.
 collaboration.collaborator c_collaborator mtext[] NAME
 v_collaborator
 e_collaborator integer[] list of EID in this column.
 collaboration.collaborator.person c_person mtext[] NAME
 v_person
 e_person integer[] list of EID in this column.
 collaboration.theme c_theme mtext SENTENCE
 v_theme
 e_theme integer[] list of EID in this column.
 collaboration.period c_period int8 DATE2
 v_period
 e_period integer[] list of EID in this column.
 collaboration.division c_division mtext EID
 v_division
 e_division integer[] list of EID in this column.
 collaboration.amount c_amount float8[] MONETARY
 v_amount
 e_amount integer[] list of EID in this column.
 collaboration.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_10002_organization"     --- associated with collaboration.organization
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 collaboration.organization r_idx0 integer subscript in primary tuple.
 c_organization mtext[] NAME
 v_organization
 e_organization integer[] list of EID in this column.
 collaboration.organization.researcher c_organ_researcher mtext[] NAME
 v_organ_researcher
 e_organ_researcher integer[] list of EID in this column.

"t_10002_organ_researcher"     --- associated with collaboration.organization.researcher
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 collaboration.organization r_idx0 integer subscript in primary tuple.
 c_organization mtext[] NAME
 v_organization
 e_organization integer[] list of EID in this column.
 collaboration.organization.researcher r_idx1 integer subscript in super column.
 c_organ_researcher mtext NAME
 v_organ_researcher
 e_organ_researcher integer[] list of EID in this column.

"t_10002_researcher"     --- associated with collaboration.researcher
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 collaboration.researcher r_idx0 integer subscript in primary tuple.
 c_researcher mtext EID
 v_researcher
 e_researcher integer[] list of EID in this column.

"t_10002_class"     --- associated with collaboration.class
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 collaboration.class r_idx0 integer subscript in primary tuple.
 c_class mtext EID
 v_class
 e_class integer[] list of EID in this column.

"t_10002_collaborator"     --- associated with collaboration.collaborator
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 collaboration.collaborator r_idx0 integer subscript in primary tuple.
 c_collaborator mtext[] NAME
 v_collaborator
 e_collaborator integer[] list of EID in this column.
 collaboration.collaborator.person c_person mtext NAME
 v_person
 e_person integer[] list of EID in this column.

"t_10002_person"     --- associated with collaboration.collaborator.person
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 collaboration.collaborator r_idx0 integer subscript in primary tuple.
 c_collaborator mtext[] NAME
 v_collaborator
 e_collaborator integer[] list of EID in this column.
 collaboration.collaborator.person r_idx1 integer subscript in super column.
 c_person mtext NAME
 v_person
 e_person integer[] list of EID in this column.

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

"t_10002_period"     --- associated with collaboration.period
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 collaboration.period r_idx0 integer subscript in primary tuple.
 c_period int8 DATE2
 v_period
 e_period integer[] list of EID in this column.

"t_10002_division"     --- associated with collaboration.division
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 collaboration.division r_idx0 integer subscript in primary tuple.
 c_division mtext EID
 v_division
 e_division integer[] list of EID in this column.

"t_10002_amount"     --- associated with collaboration.amount
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 collaboration.amount r_idx0 integer subscript in primary tuple.
 c_amount float8 MONETARY
 v_amount
 e_amount integer[] list of EID in this column.

"t_10002_note"     --- associated with collaboration.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 collaboration.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=1085)