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


Table Definition : "DispatchLecturer"


Definition of DispatchLecturer.


Relational tables associated with DispatchLecturer.

Primary table: "t_50009"
Columns:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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 Sun Dec 1 03:40:05 2024. (p-db3.edb-private:5433:edb_latest v.13.18, o=4/4, c=2, q=107, h=1134)