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

Table Definition : "CollaborationClass3"

Definition of CollaborationClass3.

XML: collaborationclass3 (XML, DTD)

SQL: t_309489

名前: （英）CollaborationClass3 （日）共同研究種別3 （読）きょうどうけんきゅうしゅべつ

説明: （英）class of collaboration （日）共同研究の種別

解説: （英）（日）

マップ:

属性: (補助テーブル)

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

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

登録されているカラム

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

並べ順
Order @.order
c_order 並べ順
order 整数 0 1 (公開) (制限) (制限) (制限) × 1 5

種別
Class @.class
c_class 共同研究の種別
class of collaboration 名称 1 1 (公開) (制限) (制限) (制限) 短 0 20

説明
Description @.description
c_description 説明
Description 文 2 * (公開) (制限) (制限) (制限) 長 0 200

備考
Note @.note
c_note 備考
Note 文 3 * (公開) (制限) (制限) (制限) × 0 200

カラムの解説文:

並べ順: (英) order (日) 並べ順を記入してください．

種別: (英) Please write the name of class. (日) 共同研究の種別の名称を記入してください．

説明: (英) Please write the description. (日) 説明を記述してください．

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

参照しているカラム:

【著作】.[共著種別]

Relational tables associated with CollaborationClass3.

Primary table: "t_309489"

Columns:

XML column name SQL definition description

Base Columns
collaborationclass3.order c_order int4 INTEGER
v_order
e_order integer[] list of EID in this column.

collaborationclass3.class c_class mtext NAME
v_class
e_class integer[] list of EID in this column.

collaborationclass3.description c_description mtext[] SENTENCE
v_description
e_description integer[] list of EID in this column.

collaborationclass3.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_309489_order"     --- associated with collaborationclass3.order

Columns:

XML column name SQL definition description

Base Columns
collaborationclass3.order r_idx0 integer subscript in primary tuple.
c_order int4 INTEGER
v_order
e_order integer[] list of EID in this column.

"t_309489_class"     --- associated with collaborationclass3.class

Columns:

XML column name SQL definition description

Base Columns
collaborationclass3.class r_idx0 integer subscript in primary tuple.
c_class mtext NAME
v_class
e_class integer[] list of EID in this column.

"t_309489_description"     --- associated with collaborationclass3.description

Columns:

XML column name SQL definition description

Base Columns
collaborationclass3.description r_idx0 integer subscript in primary tuple.
c_description mtext SENTENCE
v_description
e_description integer[] list of EID in this column.

"t_309489_note"     --- associated with collaborationclass3.note

Columns:

XML column name SQL definition description

Base Columns
collaborationclass3.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	説明	型	番	数	読権	作権	書権	削権	見	順	巾
並べ順 Order	@.order c_order	並べ順 order	整数	0	1	(公開)	(制限)	(制限)	(制限)	×	1	5
種別 Class	@.class c_class	共同研究の種別 class of collaboration	名称	1	1	(公開)	(制限)	(制限)	(制限)	短	0	20
説明 Description	@.description c_description	説明 Description	文	2	*	(公開)	(制限)	(制限)	(制限)	長	0	200
備考 Note	@.note c_note	備考 Note	文	3	*	(公開)	(制限)	(制限)	(制限)	×	0	200

XML	column name	SQL definition	description
	Base Columns
collaborationclass3.order	c_order	int4	INTEGER
v_order
e_order	integer[]	list of EID in this column.
collaborationclass3.class	c_class	mtext	NAME
v_class
e_class	integer[]	list of EID in this column.
collaborationclass3.description	c_description	mtext[]	SENTENCE
v_description
e_description	integer[]	list of EID in this column.
collaborationclass3.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
collaborationclass3.order	r_idx0	integer	subscript in primary tuple.
c_order	int4	INTEGER
v_order
e_order	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
collaborationclass3.class	r_idx0	integer	subscript in primary tuple.
c_class	mtext	NAME
v_class
e_class	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
collaborationclass3.description	r_idx0	integer	subscript in primary tuple.
c_description	mtext	SENTENCE
v_description
e_description	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
collaborationclass3.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)