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

Table Definition : "DispatchLecturer"

Definition of DispatchLecturer.

XML: dispatchlecturer (XML, DTD)

SQL: t_50009

名前: （英）DispatchLecturer （日）講師派遣（読）こうしはけん

説明: （英）dispatch lecturer （日）講師派遣の情報

解説: （英）（日）講師派遣を登録するテーブルです．

マップ:

属性:

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

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

登録されているカラム

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

カテゴリ
Category @.category
c_category 講師派遣のカテゴリ
Category of Dispatch Lecturer 参照 0 1 カテゴリ
○ 推奨 (公開) (ユーザ) (制限) (制限) × 0 20

種別
Class @.class
c_class 講師派遣の種別
Class of Dispatch Lecturer 参照 1 1 講師派遣種別
○ 推奨 (公開) (ユーザ) (制限) (制限) × 0 20

組織
Organization @.organization
c_organization 派遣した組織(教員の所属組織)
dispatcher 参照 2 * 組織
◎ ○ (公開) (ユーザ) (制限) (制限) 短 1 20

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

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

演題
Subject @.subject
c_subject 演題，講習会名，公開講座名など
subject 名称 5 1 (公開) (ユーザ) (制限) (制限) 長 0 40

受講者数
Participants @.participants
c_participants 受講した人の数
number of participants 整数 6 1 必須 (公開) (ユーザ) (制限) (制限) × 0 10

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

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

カラムの解説文:

カテゴリ: (英) Please choose the category. (日) 講師派遣のカテゴリをリストの中から選んでください．

種別: (英) Please choose the class. (日) 講師派遣の種別をリストの中から選んでください．

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

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

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

演題: (英) Please write the subject. (日) 演題，講習会名，公開講座名などを記述して下さい．

受講者数: (英) Please write the number of participants. (日) 受講した人の数を記入して下さい．

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

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

参照しているカラム:

Relational tables associated with DispatchLecturer.

Primary table: "t_50009"

Columns:

XML column name SQL definition description

Base Columns
dispatchlecturer.category c_category mtext EID
v_category
e_category integer[] list of EID in this column.

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

dispatchlecturer.organization c_organization mtext[] EID
v_organization
e_organization integer[] list of EID in this column.

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

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

dispatchlecturer.subject c_subject mtext NAME
v_subject
e_subject integer[] list of EID in this column.

dispatchlecturer.participants c_participants int4 INTEGER
v_participants
e_participants integer[] list of EID in this column.

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

dispatchlecturer.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_50009_category"     --- associated with dispatchlecturer.category

Columns:

XML column name SQL definition description

Base Columns
dispatchlecturer.category r_idx0 integer subscript in primary tuple.
c_category mtext EID
v_category
e_category integer[] list of EID in this column.

"t_50009_class"     --- associated with dispatchlecturer.class

Columns:

XML column name SQL definition description

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

"t_50009_organization"     --- associated with dispatchlecturer.organization

Columns:

XML column name SQL definition description

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

"t_50009_teacher"     --- associated with dispatchlecturer.teacher

Columns:

XML column name SQL definition description

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

"t_50009_destination"     --- associated with dispatchlecturer.destination

Columns:

XML column name SQL definition description

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

"t_50009_subject"     --- associated with dispatchlecturer.subject

Columns:

XML column name SQL definition description

Base Columns
dispatchlecturer.subject r_idx0 integer subscript in primary tuple.
c_subject mtext NAME
v_subject
e_subject integer[] list of EID in this column.

"t_50009_participants"     --- associated with dispatchlecturer.participants

Columns:

XML column name SQL definition description

Base Columns
dispatchlecturer.participants r_idx0 integer subscript in primary tuple.
c_participants int4 INTEGER
v_participants
e_participants integer[] list of EID in this column.

"t_50009_period"     --- associated with dispatchlecturer.period

Columns:

XML column name SQL definition description

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

"t_50009_note"     --- associated with dispatchlecturer.note

Columns:

XML column name SQL definition description

Base Columns
dispatchlecturer.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	権限委譲	分類	用法	読権	作権	書権	削権	見	順	巾
カテゴリ Category	@.category c_category	講師派遣のカテゴリ Category of Dispatch Lecturer	参照	0	1	カテゴリ		○	推奨	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
種別 Class	@.class c_class	講師派遣の種別 Class of Dispatch Lecturer	参照	1	1	講師派遣種別		○	推奨	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
組織 Organization	@.organization c_organization	派遣した組織(教員の所属組織) dispatcher	参照	2	*	組織	◎	○		(公開)	(ユーザ)	(制限)	(制限)	短	1	20
教員 Teacher	@.teacher c_teacher	派遣された教員 person to be dispatch	参照	3	*	個人	◎			(公開)	(ユーザ)	(制限)	(制限)	短	1	20
派遣先 Destination	@.destination c_destination	派遣先の組織 destination	名称	4	*	組織				(公開)	(ユーザ)	(制限)	(制限)	長	0	40
演題 Subject	@.subject c_subject	演題，講習会名，公開講座名など subject	名称	5	1					(公開)	(ユーザ)	(制限)	(制限)	長	0	40
受講者数 Participants	@.participants c_participants	受講した人の数 number of participants	整数	6	1				必須	(公開)	(ユーザ)	(制限)	(制限)	×	0	10
期間 Period	@.period c_period	派遣期間 period of dispatch	期間	7	1			○		(公開)	(ユーザ)	(制限)	(制限)	長	1	40
備考 Note	@.note c_note	備考 Note	文	8	*					(公開)	(ユーザ)	(制限)	(制限)	×	0	200

XML	column name	SQL definition	description
	Base Columns
dispatchlecturer.category	c_category	mtext	EID
v_category
e_category	integer[]	list of EID in this column.
dispatchlecturer.class	c_class	mtext	EID
v_class
e_class	integer[]	list of EID in this column.
dispatchlecturer.organization	c_organization	mtext[]	EID
v_organization
e_organization	integer[]	list of EID in this column.
dispatchlecturer.teacher	c_teacher	mtext[]	EID
v_teacher
e_teacher	integer[]	list of EID in this column.
dispatchlecturer.destination	c_destination	mtext[]	NAME
v_destination
e_destination	integer[]	list of EID in this column.
dispatchlecturer.subject	c_subject	mtext	NAME
v_subject
e_subject	integer[]	list of EID in this column.
dispatchlecturer.participants	c_participants	int4	INTEGER
v_participants
e_participants	integer[]	list of EID in this column.
dispatchlecturer.period	c_period	int8	DATE2
v_period
e_period	integer[]	list of EID in this column.
dispatchlecturer.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
dispatchlecturer.category	r_idx0	integer	subscript in primary tuple.
c_category	mtext	EID
v_category
e_category	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
dispatchlecturer.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
dispatchlecturer.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
dispatchlecturer.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
dispatchlecturer.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
dispatchlecturer.subject	r_idx0	integer	subscript in primary tuple.
c_subject	mtext	NAME
v_subject
e_subject	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
dispatchlecturer.participants	r_idx0	integer	subscript in primary tuple.
c_participants	int4	INTEGER
v_participants
e_participants	integer[]	list of EID in this column.

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