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

Table Definition : "Collaboration"

Definition of Collaboration.

XML: collaboration (XML, DTD)

SQL: t_10002

名前: （英）Collaboration （日）共同研究（読）きょうどうけんきゅう

説明: （英）list of collaboration （日）学外，他学部との共同研究の情報

解説: （英）（日）学外・他学部と行なっている共同研究を登録するテーブルです．

マップ:

属性:

タプル権限(既定値): 読権: 公開, 作権: ユーザ, 書権: 制限, 削権: 制限.

カラム権限(既定値): 読権: 公開, 作権: 制限, 書権: 制限, 削権: 制限.

登録されているカラム

名前 XML
SQL 説明型番数 MAP 権限
委譲分類同義期間
限定用法該当
無可読権作権書権削権見順巾

組織
Organization @.organization
c_organization 研究者の所属
organization of researcher 名称 0 * 組織
◎ ○ 必須 (公開) (ユーザ) (制限) (制限) 短 1 20

  研究者
  Researcher @.organization.researcher
c_organ_researcher 研究者
name of researcher 名称 1 * 個人
◎ 必須 (公開) (ユーザ) (制限) (制限) 短 1 20

研究者1
Researcher1 @.researcher
c_researcher 学内の研究者(廃止)
name of researcher 参照 2 * 個人
◎ ○ (公開) (ユーザ) (制限) (制限) 短 1 20

種別
Class @.class
c_class 共同研究の種別
class of collaboration 参照 3 1 共同研究種別
○ 必須 (公開) (ユーザ) (制限) (制限) 短 1 10

共同研究機関
Collaborator @.collaborator
c_collaborator 共同研究機関(廃止)
Collaborators 名称 4 * 組織
○ (公開) (ユーザ) (制限) (制限) 短 1 50

  共同研究者名
  Name @.collaborator.person
c_person 学外の研究者(廃止)
name of collaborator 名称 5 1 個人
(公開) (ユーザ) (制限) (制限) 短 1 20

テーマ
Theme @.theme
c_theme 研究テーマなど
theme 文 6 1 必須 (公開) (ユーザ) (制限) (制限) 長 0 100

期間
Period @.period
c_period 研究期間
period of collaboration 期間 7 1 ○ 必須 (公開) (ユーザ) (制限) (制限) 長 0 40

区分
Division @.division
c_division 地共センターの研究区分
division of collaboration 参照 8 1 地共区分
任意 (公開) (ユーザ) (制限) (制限) 短 1 10

金額
Amount @.amount
c_amount 研究費の年度毎の総額
amount of budget (each year) 金額 9 * 推奨 (公開) (ユーザ) (制限) (制限) × 0 10

備考
Note @.note
c_note 備考
Note 文 10 * 任意 (公開) (ユーザ) (制限) (制限) × 0 200

カラムの解説文:

組織: (英) Please choose the organization. (日) 研究者の所属を選択または記述してください．各学科，講座の共同研究などを集計するときに利用しますので学内の組織については必ず参照形式登録して下さい．研究者が複数の学科，講座にまたがっているときにはそれらを全て登録してください．

研究者: (英) Please choose the researcher. (日) 研究者を選択または記述してください．学内の研究者の場合には必ず参照形式で登録して下さい．記述よる場合には，英名は「Surname(Family-name), Given-name」の順に記入してください．

研究者1: (英) Please choose the researcher. (日) 学内の研究者を選択してください．

種別: (英) Please choose the class of collaboration. (日) 共同研究の種別を選択してください．

共同研究機関: (英) Please register the collaborators (日) 共同研究機関の情報を記入して下さい．

共同研究者名: (英) Please write the name of collaborator. (日) 学外の研究者の名前を記入してください．英名は「Surname(Family-name), Given-name」の順に記入してください．

テーマ: (英) Please write the theme of collaboration. (日) 共同研究テーマを記入してください．

期間: (英) Please write the period of collaboration. (日) 共同研究期間を記入してください．

区分: (英) Please choose the division of collaboration. (日) 地域共同研究センターの共同研究区分を選択してください．

金額: (英) Please write the amount of budget. (first year:1., second year:2. ...) (日) 共同研究費の年度毎の総額を記入してください．(初年度:1., 2年目:2., ...)

備考: (英) Please write the information which cannot be written on registered column. (日) 登録されているカラムに記述すべき内容以外に，特に記しておきたい事柄があれば記述してください．

参照しているカラム:

Relational tables associated with Collaboration.

Primary table: "t_10002"

Columns:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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.

名前	XML SQL	説明	型	番	数	MAP	権限委譲	分類	用法	読権	作権	書権	削権	見	順	巾
組織 Organization	@.organization c_organization	研究者の所属 organization of researcher	名称	0	*	組織	◎	○	必須	(公開)	(ユーザ)	(制限)	(制限)	短	1	20
研究者 Researcher	@.organization.researcher c_organ_researcher	研究者 name of researcher	名称	1	*	個人	◎		必須	(公開)	(ユーザ)	(制限)	(制限)	短	1	20
研究者1 Researcher1	@.researcher c_researcher	学内の研究者(廃止) name of researcher	参照	2	*	個人	◎	○		(公開)	(ユーザ)	(制限)	(制限)	短	1	20
種別 Class	@.class c_class	共同研究の種別 class of collaboration	参照	3	1	共同研究種別		○	必須	(公開)	(ユーザ)	(制限)	(制限)	短	1	10
共同研究機関 Collaborator	@.collaborator c_collaborator	共同研究機関(廃止) Collaborators	名称	4	*	組織		○		(公開)	(ユーザ)	(制限)	(制限)	短	1	50
共同研究者名 Name	@.collaborator.person c_person	学外の研究者(廃止) name of collaborator	名称	5	1	個人				(公開)	(ユーザ)	(制限)	(制限)	短	1	20
テーマ Theme	@.theme c_theme	研究テーマなど theme	文	6	1				必須	(公開)	(ユーザ)	(制限)	(制限)	長	0	100
期間 Period	@.period c_period	研究期間 period of collaboration	期間	7	1			○	必須	(公開)	(ユーザ)	(制限)	(制限)	長	0	40
区分 Division	@.division c_division	地共センターの研究区分 division of collaboration	参照	8	1	地共区分			任意	(公開)	(ユーザ)	(制限)	(制限)	短	1	10
金額 Amount	@.amount c_amount	研究費の年度毎の総額 amount of budget (each year)	金額	9	*				推奨	(公開)	(ユーザ)	(制限)	(制限)	×	0	10
備考 Note	@.note c_note	備考 Note	文	10	*				任意	(公開)	(ユーザ)	(制限)	(制限)	×	0	200

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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 Thu Nov 28 03:40:01 2024. (p-db6.edb-private:5433:edb_latest v.15.10, o=6/6, c=2, q=107, h=1085)