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


Table Definition : "Lecture"


Definition of Lecture.


Relational tables associated with Lecture.

Primary table: "t_21112"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.kind c_kind mtext EID
 v_kind
 e_kind integer[] list of EID in this column.
 lecture.entryyear c_entryyear int4 YEAR
 v_entryyear
 e_entryyear integer[] list of EID in this column.
 lecture.name c_name mtext NAME
 v_name
 e_name integer[] list of EID in this column.
 lecture.name.topic c_topic mtext NAME
 v_topic
 e_topic integer[] list of EID in this column.
 lecture.topics c_topics mtext[] EID
 v_topics
 e_topics integer[] list of EID in this column.
 lecture.style c_style mtext[] EID
 v_style
 e_style integer[] list of EID in this column.
 lecture.course c_course mtext[] EID
 v_course
 e_course integer[] list of EID in this column.
 lecture.lecturer c_lecturer mtext[] EID
 v_lecturer
 e_lecturer integer[] list of EID in this column.
 lecture.lecturer.title c_title mtext[] EID
 v_title
 e_title integer[] list of EID in this column.
 lecture.lecturer.role c_role mtext[] EID
 v_role
 e_role integer[] list of EID in this column.
 lecture.unit c_unit int4 INTEGER
 v_unit
 e_unit integer[] list of EID in this column.
 lecture.target c_target mtext PARAGRAPH
 v_target
 e_target integer[] list of EID in this column.
 lecture.outline c_outline mtext PARAGRAPH
 v_outline
 e_outline integer[] list of EID in this column.
 lecture.theme c_theme mtext SENTENCE
 v_theme
 e_theme integer[] list of EID in this column.
 lecture.position c_position mtext SENTENCE
 v_position
 e_position integer[] list of EID in this column.
 lecture.keyword c_keyword mtext[] NAME
 v_keyword
 e_keyword integer[] list of EID in this column.
 lecture.foundation c_foundation mtext[] EID
 v_foundation
 e_foundation integer[] list of EID in this column.
 lecture.foundation.necessity c_necessity float8[] REAL
 v_necessity
 e_necessity integer[] list of EID in this column.
 lecture.relation c_relation mtext[] EID
 v_relation
 e_relation integer[] list of EID in this column.
 lecture.relation.relatedness c_relatedness float8[] REAL
 v_relatedness
 e_relatedness integer[] list of EID in this column.
 lecture.requirement c_requirement mtext PARAGRAPH
 v_requirement
 e_requirement integer[] list of EID in this column.
 lecture.manner c_manner mtext[] SENTENCE
 v_manner
 e_manner integer[] list of EID in this column.
 lecture.location c_location mtext SENTENCE
 v_location
 e_location integer[] list of EID in this column.
 lecture.notice c_notice mtext PARAGRAPH
 v_notice
 e_notice integer[] list of EID in this column.
 lecture.goal c_goal mtext[] SENTENCE
 v_goal
 e_goal integer[] list of EID in this column.
 lecture.goal.goal2 c_goal2 mtext[] SENTENCE
 v_goal2
 e_goal2 integer[] list of EID in this column.
 lecture.goal.position2 c_position2 mtext[] SENTENCE
 v_position2
 e_position2 integer[] list of EID in this column.
 lecture.plan c_plan mtext[] SENTENCE
 v_plan
 e_plan integer[] list of EID in this column.
 lecture.plan.detail c_detail mtext[] SENTENCE
 v_detail
 e_detail integer[] list of EID in this column.
 lecture.plan.charger c_charger mtext[] SENTENCE
 v_charger
 e_charger integer[] list of EID in this column.
 lecture.plan.goal c_plangoal text[] TEXT
 v_plangoal
 e_plangoal integer[] list of EID in this column.
 lecture.plan.times c_times text[] TEXT
 v_times
 e_times integer[] list of EID in this column.
 lecture.evaluation c_evaluation mtext PARAGRAPH
 v_evaluation
 e_evaluation integer[] list of EID in this column.
 lecture.evaluation2 c_evaluation2 mtext PARAGRAPH
 v_evaluation2
 e_evaluation2 integer[] list of EID in this column.
 lecture.jabeeevaluation c_jabeeevaluation mtext PARAGRAPH
 v_jabeeevaluation
 e_jabeeevaluation integer[] list of EID in this column.
 lecture.jabeerelation c_jabeerelation mtext PARAGRAPH
 v_jabeerelation
 e_jabeerelation integer[] list of EID in this column.
 lecture.student c_student mtext SENTENCE
 v_student
 e_student integer[] list of EID in this column.
 lecture.textbook c_textbook mtext[] SENTENCE
 v_textbook
 e_textbook integer[] list of EID in this column.
 lecture.reference c_reference mtext[] SENTENCE
 v_reference
 e_reference integer[] list of EID in this column.
 lecture.url c_url text URL
 v_url
 e_url integer[] list of EID in this column.
 lecture.contact c_contact mtext[] NAME
 v_contact
 e_contact integer[] list of EID in this column.
 lecture.contact.officehour c_contact_oh mtext[] SENTENCE
 v_contact_oh
 e_contact_oh integer[] list of EID in this column.
 lecture.subjectcode c_subjectcode text[] TEXT
 v_subjectcode
 e_subjectcode integer[] list of EID in this column.
 lecture.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_21112_kind"     --- associated with lecture.kind
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.kind r_idx0 integer subscript in primary tuple.
 c_kind mtext EID
 v_kind
 e_kind integer[] list of EID in this column.

"t_21112_entryyear"     --- associated with lecture.entryyear
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.entryyear r_idx0 integer subscript in primary tuple.
 c_entryyear int4 YEAR
 v_entryyear
 e_entryyear integer[] list of EID in this column.

"t_21112_name"     --- associated with lecture.name
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.name r_idx0 integer subscript in primary tuple.
 c_name mtext NAME
 v_name
 e_name integer[] list of EID in this column.
 lecture.name.topic c_topic mtext NAME
 v_topic
 e_topic integer[] list of EID in this column.

"t_21112_topic"     --- associated with lecture.name.topic
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.name r_idx0 integer subscript in primary tuple.
 c_name mtext NAME
 v_name
 e_name integer[] list of EID in this column.
 lecture.name.topic r_idx1 integer subscript in super column.
 c_topic mtext NAME
 v_topic
 e_topic integer[] list of EID in this column.

"t_21112_topics"     --- associated with lecture.topics
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.topics r_idx0 integer subscript in primary tuple.
 c_topics mtext EID
 v_topics
 e_topics integer[] list of EID in this column.

"t_21112_style"     --- associated with lecture.style
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.style r_idx0 integer subscript in primary tuple.
 c_style mtext EID
 v_style
 e_style integer[] list of EID in this column.

"t_21112_course"     --- associated with lecture.course
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.course r_idx0 integer subscript in primary tuple.
 c_course mtext EID
 v_course
 e_course integer[] list of EID in this column.

"t_21112_lecturer"     --- associated with lecture.lecturer
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.lecturer r_idx0 integer subscript in primary tuple.
 c_lecturer mtext[] EID
 v_lecturer
 e_lecturer integer[] list of EID in this column.
 lecture.lecturer.title c_title mtext EID
 v_title
 e_title integer[] list of EID in this column.
 lecture.lecturer.role c_role mtext EID
 v_role
 e_role integer[] list of EID in this column.

"t_21112_title"     --- associated with lecture.lecturer.title
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.lecturer r_idx0 integer subscript in primary tuple.
 c_lecturer mtext[] EID
 v_lecturer
 e_lecturer integer[] list of EID in this column.
 lecture.lecturer.title r_idx1 integer subscript in super column.
 c_title mtext EID
 v_title
 e_title integer[] list of EID in this column.

"t_21112_role"     --- associated with lecture.lecturer.role
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.lecturer r_idx0 integer subscript in primary tuple.
 c_lecturer mtext[] EID
 v_lecturer
 e_lecturer integer[] list of EID in this column.
 lecture.lecturer.role r_idx1 integer subscript in super column.
 c_role mtext EID
 v_role
 e_role integer[] list of EID in this column.

"t_21112_unit"     --- associated with lecture.unit
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.unit r_idx0 integer subscript in primary tuple.
 c_unit int4 INTEGER
 v_unit
 e_unit integer[] list of EID in this column.

"t_21112_target"     --- associated with lecture.target
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.target r_idx0 integer subscript in primary tuple.
 c_target mtext PARAGRAPH
 v_target
 e_target integer[] list of EID in this column.

"t_21112_outline"     --- associated with lecture.outline
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.outline r_idx0 integer subscript in primary tuple.
 c_outline mtext PARAGRAPH
 v_outline
 e_outline integer[] list of EID in this column.

"t_21112_theme"     --- associated with lecture.theme
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.theme r_idx0 integer subscript in primary tuple.
 c_theme mtext SENTENCE
 v_theme
 e_theme integer[] list of EID in this column.

"t_21112_position"     --- associated with lecture.position
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.position r_idx0 integer subscript in primary tuple.
 c_position mtext SENTENCE
 v_position
 e_position integer[] list of EID in this column.

"t_21112_keyword"     --- associated with lecture.keyword
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.keyword r_idx0 integer subscript in primary tuple.
 c_keyword mtext NAME
 v_keyword
 e_keyword integer[] list of EID in this column.

"t_21112_foundation"     --- associated with lecture.foundation
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.foundation r_idx0 integer subscript in primary tuple.
 c_foundation mtext EID
 v_foundation
 e_foundation integer[] list of EID in this column.
 lecture.foundation.necessity c_necessity float8 REAL
 v_necessity
 e_necessity integer[] list of EID in this column.

"t_21112_necessity"     --- associated with lecture.foundation.necessity
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.foundation r_idx0 integer subscript in primary tuple.
 c_foundation mtext EID
 v_foundation
 e_foundation integer[] list of EID in this column.
 lecture.foundation.necessity r_idx1 integer subscript in super column.
 c_necessity float8 REAL
 v_necessity
 e_necessity integer[] list of EID in this column.

"t_21112_relation"     --- associated with lecture.relation
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.relation r_idx0 integer subscript in primary tuple.
 c_relation mtext EID
 v_relation
 e_relation integer[] list of EID in this column.
 lecture.relation.relatedness c_relatedness float8 REAL
 v_relatedness
 e_relatedness integer[] list of EID in this column.

"t_21112_relatedness"     --- associated with lecture.relation.relatedness
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.relation r_idx0 integer subscript in primary tuple.
 c_relation mtext EID
 v_relation
 e_relation integer[] list of EID in this column.
 lecture.relation.relatedness r_idx1 integer subscript in super column.
 c_relatedness float8 REAL
 v_relatedness
 e_relatedness integer[] list of EID in this column.

"t_21112_requirement"     --- associated with lecture.requirement
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.requirement r_idx0 integer subscript in primary tuple.
 c_requirement mtext PARAGRAPH
 v_requirement
 e_requirement integer[] list of EID in this column.

"t_21112_manner"     --- associated with lecture.manner
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.manner r_idx0 integer subscript in primary tuple.
 c_manner mtext SENTENCE
 v_manner
 e_manner integer[] list of EID in this column.

"t_21112_location"     --- associated with lecture.location
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.location r_idx0 integer subscript in primary tuple.
 c_location mtext SENTENCE
 v_location
 e_location integer[] list of EID in this column.

"t_21112_notice"     --- associated with lecture.notice
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.notice r_idx0 integer subscript in primary tuple.
 c_notice mtext PARAGRAPH
 v_notice
 e_notice integer[] list of EID in this column.

"t_21112_goal"     --- associated with lecture.goal
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.goal r_idx0 integer subscript in primary tuple.
 c_goal mtext SENTENCE
 v_goal
 e_goal integer[] list of EID in this column.
 lecture.goal.goal2 c_goal2 mtext[] SENTENCE
 v_goal2
 e_goal2 integer[] list of EID in this column.
 lecture.goal.position2 c_position2 mtext SENTENCE
 v_position2
 e_position2 integer[] list of EID in this column.

"t_21112_goal2"     --- associated with lecture.goal.goal2
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.goal r_idx0 integer subscript in primary tuple.
 c_goal mtext SENTENCE
 v_goal
 e_goal integer[] list of EID in this column.
 lecture.goal.goal2 r_idx1 integer subscript in super column.
 c_goal2 mtext SENTENCE
 v_goal2
 e_goal2 integer[] list of EID in this column.

"t_21112_position2"     --- associated with lecture.goal.position2
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.goal r_idx0 integer subscript in primary tuple.
 c_goal mtext SENTENCE
 v_goal
 e_goal integer[] list of EID in this column.
 lecture.goal.position2 r_idx1 integer subscript in super column.
 c_position2 mtext SENTENCE
 v_position2
 e_position2 integer[] list of EID in this column.

"t_21112_plan"     --- associated with lecture.plan
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.plan r_idx0 integer subscript in primary tuple.
 c_plan mtext SENTENCE
 v_plan
 e_plan integer[] list of EID in this column.
 lecture.plan.detail c_detail mtext[] SENTENCE
 v_detail
 e_detail integer[] list of EID in this column.
 lecture.plan.charger c_charger mtext SENTENCE
 v_charger
 e_charger integer[] list of EID in this column.
 lecture.plan.goal c_plangoal text TEXT
 v_plangoal
 e_plangoal integer[] list of EID in this column.
 lecture.plan.times c_times text TEXT
 v_times
 e_times integer[] list of EID in this column.

"t_21112_detail"     --- associated with lecture.plan.detail
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.plan r_idx0 integer subscript in primary tuple.
 c_plan mtext SENTENCE
 v_plan
 e_plan integer[] list of EID in this column.
 lecture.plan.detail r_idx1 integer subscript in super column.
 c_detail mtext SENTENCE
 v_detail
 e_detail integer[] list of EID in this column.

"t_21112_charger"     --- associated with lecture.plan.charger
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.plan r_idx0 integer subscript in primary tuple.
 c_plan mtext SENTENCE
 v_plan
 e_plan integer[] list of EID in this column.
 lecture.plan.charger r_idx1 integer subscript in super column.
 c_charger mtext SENTENCE
 v_charger
 e_charger integer[] list of EID in this column.

"t_21112_plangoal"     --- associated with lecture.plan.goal
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.plan r_idx0 integer subscript in primary tuple.
 c_plan mtext SENTENCE
 v_plan
 e_plan integer[] list of EID in this column.
 lecture.plan.goal r_idx1 integer subscript in super column.
 c_plangoal text TEXT
 v_plangoal
 e_plangoal integer[] list of EID in this column.

"t_21112_times"     --- associated with lecture.plan.times
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.plan r_idx0 integer subscript in primary tuple.
 c_plan mtext SENTENCE
 v_plan
 e_plan integer[] list of EID in this column.
 lecture.plan.times r_idx1 integer subscript in super column.
 c_times text TEXT
 v_times
 e_times integer[] list of EID in this column.

"t_21112_evaluation"     --- associated with lecture.evaluation
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.evaluation r_idx0 integer subscript in primary tuple.
 c_evaluation mtext PARAGRAPH
 v_evaluation
 e_evaluation integer[] list of EID in this column.

"t_21112_evaluation2"     --- associated with lecture.evaluation2
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.evaluation2 r_idx0 integer subscript in primary tuple.
 c_evaluation2 mtext PARAGRAPH
 v_evaluation2
 e_evaluation2 integer[] list of EID in this column.

"t_21112_jabeeevaluation"     --- associated with lecture.jabeeevaluation
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.jabeeevaluation r_idx0 integer subscript in primary tuple.
 c_jabeeevaluation mtext PARAGRAPH
 v_jabeeevaluation
 e_jabeeevaluation integer[] list of EID in this column.

"t_21112_jabeerelation"     --- associated with lecture.jabeerelation
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.jabeerelation r_idx0 integer subscript in primary tuple.
 c_jabeerelation mtext PARAGRAPH
 v_jabeerelation
 e_jabeerelation integer[] list of EID in this column.

"t_21112_student"     --- associated with lecture.student
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.student r_idx0 integer subscript in primary tuple.
 c_student mtext SENTENCE
 v_student
 e_student integer[] list of EID in this column.

"t_21112_textbook"     --- associated with lecture.textbook
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.textbook r_idx0 integer subscript in primary tuple.
 c_textbook mtext SENTENCE
 v_textbook
 e_textbook integer[] list of EID in this column.

"t_21112_reference"     --- associated with lecture.reference
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.reference r_idx0 integer subscript in primary tuple.
 c_reference mtext SENTENCE
 v_reference
 e_reference integer[] list of EID in this column.

"t_21112_url"     --- associated with lecture.url
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.url r_idx0 integer subscript in primary tuple.
 c_url text URL
 v_url
 e_url integer[] list of EID in this column.

"t_21112_contact"     --- associated with lecture.contact
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.contact r_idx0 integer subscript in primary tuple.
 c_contact mtext[] NAME
 v_contact
 e_contact integer[] list of EID in this column.
 lecture.contact.officehour c_contact_oh mtext SENTENCE
 v_contact_oh
 e_contact_oh integer[] list of EID in this column.

"t_21112_contact_oh"     --- associated with lecture.contact.officehour
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.contact r_idx0 integer subscript in primary tuple.
 c_contact mtext[] NAME
 v_contact
 e_contact integer[] list of EID in this column.
 lecture.contact.officehour r_idx1 integer subscript in super column.
 c_contact_oh mtext SENTENCE
 v_contact_oh
 e_contact_oh integer[] list of EID in this column.

"t_21112_subjectcode"     --- associated with lecture.subjectcode
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.subjectcode r_idx0 integer subscript in primary tuple.
 c_subjectcode text TEXT
 v_subjectcode
 e_subjectcode integer[] list of EID in this column.

"t_21112_note"     --- associated with lecture.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 lecture.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 Tue Apr 23 03:40:05 2024. (p-db3.edb-private:5433:edb_latest v.13.14, o=8/8, c=2, q=107, h=1267)