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

Table Definition : "DispatchStudent"

Definition of DispatchStudent.

XML: dispatchstudent (XML, DTD)

SQL: t_50008

名前: （英）DispatchStudent （日）学生派遣（読）がくせいはけん

説明: （英）dispatch student to oversea （日）学生の海外派遣の情報

解説: （英）（日）学生の海外派遣を登録するテーブルです．

マップ:

属性:

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

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

登録されているカラム

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

組織
Organization @.organization
c_organization 派遣した組織
dispatcher 参照 0 * 組織
◎ ○ (公開) (ユーザ) (制限) (制限) 長 1 20

教員
Teacher @.teacher
c_teacher 派遣した教員
person to be dispatch 参照 1 * 個人
◎ (公開) (ユーザ) (制限) (制限) 短 1 20

学生
Student @.student
c_student 派遣された学生
person to be dispatch 名称 2 * 個人
◎ (学内) (ユーザ) (制限) (制限) 長 0 20

目的
Purpose @.purpose
c_purpose 派遣目的
purpose to dispatch 文 3 1 (公開) (ユーザ) (制限) (制限) 長 0 100

行き先の国
Nation @.nation
c_nation 派遣先の国
destination 名称 4 1 国家
(公開) (ユーザ) (制限) (制限) 長 0 20

行き先の組織
Destination @.destination
c_destination 派遣先の組織
destination 名称 5 * 組織
(公開) (ユーザ) (制限) (制限) 長 0 40

期間
Period @.period
c_period 派遣期間
period of dispatch 期間 6 1 ○ (公開) (ユーザ) (制限) (制限) 短 1 40

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

カラムの解説文:

組織: (英) Please choose the dispatched person. (日) 派遣した組織を選択してください

教員: (英) Please choose the dispatched person. (日) 派遣した教員を選択してください

学生: (英) Please choose the dispatched person. (日) 派遣された学生を選択してください

目的: (英) Please wirte the purpose of dispatch. (日) 派遣目的を記入してください．

行き先の国: (英) Please choose the destination country. (日) 派遣先の国を選択してください．

行き先の組織: (英) Please choose the destination country. (日) 派遣先の組織を選択してください．

期間: (英) Please write the period of dispatch. (日) 派遣期間を記入してください．

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

参照しているカラム:

Relational tables associated with DispatchStudent.

Primary table: "t_50008"

Columns:

XML column name SQL definition description

Base Columns
dispatchstudent.organization c_organization mtext[] EID
v_organization
e_organization integer[] list of EID in this column.

dispatchstudent.teacher c_teacher mtext[] EID
v_teacher
e_teacher integer[] list of EID in this column.

dispatchstudent.student c_student mtext[] NAME
v_student
e_student integer[] list of EID in this column.

dispatchstudent.purpose c_purpose mtext SENTENCE
v_purpose
e_purpose integer[] list of EID in this column.

dispatchstudent.nation c_nation mtext NAME
v_nation
e_nation integer[] list of EID in this column.

dispatchstudent.destination c_destination mtext[] NAME
v_destination
e_destination integer[] list of EID in this column.

dispatchstudent.period c_period int8 DATE2
v_period
e_period integer[] list of EID in this column.

dispatchstudent.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_50008_organization"     --- associated with dispatchstudent.organization

Columns:

XML column name SQL definition description

Base Columns
dispatchstudent.organization r_idx0 integer subscript in primary tuple.
c_organization mtext[] EID
v_organization
e_organization integer[] list of EID in this column.

"t_50008_teacher"     --- associated with dispatchstudent.teacher

Columns:

XML column name SQL definition description

Base Columns
dispatchstudent.teacher r_idx0 integer subscript in primary tuple.
c_teacher mtext EID
v_teacher
e_teacher integer[] list of EID in this column.

"t_50008_student"     --- associated with dispatchstudent.student

Columns:

XML column name SQL definition description

Base Columns
dispatchstudent.student r_idx0 integer subscript in primary tuple.
c_student mtext NAME
v_student
e_student integer[] list of EID in this column.

"t_50008_purpose"     --- associated with dispatchstudent.purpose

Columns:

XML column name SQL definition description

Base Columns
dispatchstudent.purpose r_idx0 integer subscript in primary tuple.
c_purpose mtext SENTENCE
v_purpose
e_purpose integer[] list of EID in this column.

"t_50008_nation"     --- associated with dispatchstudent.nation

Columns:

XML column name SQL definition description

Base Columns
dispatchstudent.nation r_idx0 integer subscript in primary tuple.
c_nation mtext NAME
v_nation
e_nation integer[] list of EID in this column.

"t_50008_destination"     --- associated with dispatchstudent.destination

Columns:

XML column name SQL definition description

Base Columns
dispatchstudent.destination r_idx0 integer subscript in primary tuple.
c_destination mtext[] NAME
v_destination
e_destination integer[] list of EID in this column.

"t_50008_period"     --- associated with dispatchstudent.period

Columns:

XML column name SQL definition description

Base Columns
dispatchstudent.period r_idx0 integer subscript in primary tuple.
c_period int8 DATE2
v_period
e_period integer[] list of EID in this column.

"t_50008_note"     --- associated with dispatchstudent.note

Columns:

XML column name SQL definition description

Base Columns
dispatchstudent.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	派遣した組織 dispatcher	参照	0	*	組織	◎	○	(公開)	(ユーザ)	(制限)	(制限)	長	1	20
教員 Teacher	@.teacher c_teacher	派遣した教員 person to be dispatch	参照	1	*	個人	◎		(公開)	(ユーザ)	(制限)	(制限)	短	1	20
学生 Student	@.student c_student	派遣された学生 person to be dispatch	名称	2	*	個人	◎		(学内)	(ユーザ)	(制限)	(制限)	長	0	20
目的 Purpose	@.purpose c_purpose	派遣目的 purpose to dispatch	文	3	1				(公開)	(ユーザ)	(制限)	(制限)	長	0	100
行き先の国 Nation	@.nation c_nation	派遣先の国 destination	名称	4	1	国家			(公開)	(ユーザ)	(制限)	(制限)	長	0	20
行き先の組織 Destination	@.destination c_destination	派遣先の組織 destination	名称	5	*	組織			(公開)	(ユーザ)	(制限)	(制限)	長	0	40
期間 Period	@.period c_period	派遣期間 period of dispatch	期間	6	1			○	(公開)	(ユーザ)	(制限)	(制限)	短	1	40
備考 Note	@.note c_note	備考 Note	文	7	*				(公開)	(ユーザ)	(制限)	(制限)	×	0	200

XML	column name	SQL definition	description
	Base Columns
dispatchstudent.organization	c_organization	mtext[]	EID
v_organization
e_organization	integer[]	list of EID in this column.
dispatchstudent.teacher	c_teacher	mtext[]	EID
v_teacher
e_teacher	integer[]	list of EID in this column.
dispatchstudent.student	c_student	mtext[]	NAME
v_student
e_student	integer[]	list of EID in this column.
dispatchstudent.purpose	c_purpose	mtext	SENTENCE
v_purpose
e_purpose	integer[]	list of EID in this column.
dispatchstudent.nation	c_nation	mtext	NAME
v_nation
e_nation	integer[]	list of EID in this column.
dispatchstudent.destination	c_destination	mtext[]	NAME
v_destination
e_destination	integer[]	list of EID in this column.
dispatchstudent.period	c_period	int8	DATE2
v_period
e_period	integer[]	list of EID in this column.
dispatchstudent.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
dispatchstudent.organization	r_idx0	integer	subscript in primary tuple.
c_organization	mtext[]	EID
v_organization
e_organization	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
dispatchstudent.teacher	r_idx0	integer	subscript in primary tuple.
c_teacher	mtext	EID
v_teacher
e_teacher	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
dispatchstudent.student	r_idx0	integer	subscript in primary tuple.
c_student	mtext	NAME
v_student
e_student	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
dispatchstudent.purpose	r_idx0	integer	subscript in primary tuple.
c_purpose	mtext	SENTENCE
v_purpose
e_purpose	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
dispatchstudent.nation	r_idx0	integer	subscript in primary tuple.
c_nation	mtext	NAME
v_nation
e_nation	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
dispatchstudent.destination	r_idx0	integer	subscript in primary tuple.
c_destination	mtext[]	NAME
v_destination
e_destination	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
dispatchstudent.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
dispatchstudent.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 Apr 19 03:40:06 2024. (p-db7.edb-private:5433:edb_latest v.15.6, o=8/8, c=2, q=107, h=985)