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


Table Definition : "Syllabus"


Definition of Syllabus.


Relational tables associated with Syllabus.

Primary table: "t_21095"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.entryyear c_entryyear int4 YEAR
 v_entryyear
 e_entryyear integer[] list of EID in this column.
 syllabus.affiliate c_affiliate mtext[] EID
 v_affiliate
 e_affiliate integer[] list of EID in this column.
 syllabus.name c_name mtext NAME
 v_name
 e_name integer[] list of EID in this column.
 syllabus.course c_course mtext EID
 v_course
 e_course integer[] list of EID in this column.
 syllabus.guide c_guide text URL
 v_guide
 e_guide integer[] list of EID in this column.
 syllabus.profession c_profession mtext[] NAME
 v_profession
 e_profession integer[] list of EID in this column.
 syllabus.profession.description c_prodesc mtext[] PARAGRAPH
 v_prodesc
 e_prodesc integer[] list of EID in this column.
 syllabus.profession.foundation c_foundation mtext[] EID
 v_foundation
 e_foundation integer[] list of EID in this column.
 syllabus.profession.foundation.necessity c_necessity float8[] REAL
 v_necessity
 e_necessity integer[] list of EID in this column.
 syllabus.category c_category mtext[] NAME
 v_category
 e_category integer[] list of EID in this column.
 syllabus.category.lecture c_lecture mtext[] EID
 v_lecture
 e_lecture integer[] list of EID in this column.
 syllabus.category.lecture.class c_sclass mtext[] EID
 v_sclass
 e_sclass integer[] list of EID in this column.
 syllabus.category.lecture.year c_year mtext[] EID
 v_year
 e_year integer[] list of EID in this column.
 syllabus.category.lecture.year.term c_term mtext[] EID
 v_term
 e_term integer[] list of EID in this column.
 syllabus.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_21095_entryyear"     --- associated with syllabus.entryyear
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.entryyear r_idx0 integer subscript in primary tuple.
 c_entryyear int4 YEAR
 v_entryyear
 e_entryyear integer[] list of EID in this column.

"t_21095_affiliate"     --- associated with syllabus.affiliate
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.affiliate r_idx0 integer subscript in primary tuple.
 c_affiliate mtext[] EID
 v_affiliate
 e_affiliate integer[] list of EID in this column.

"t_21095_name"     --- associated with syllabus.name
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.name r_idx0 integer subscript in primary tuple.
 c_name mtext NAME
 v_name
 e_name integer[] list of EID in this column.

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

"t_21095_guide"     --- associated with syllabus.guide
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.guide r_idx0 integer subscript in primary tuple.
 c_guide text URL
 v_guide
 e_guide integer[] list of EID in this column.

"t_21095_profession"     --- associated with syllabus.profession
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.profession r_idx0 integer subscript in primary tuple.
 c_profession mtext NAME
 v_profession
 e_profession integer[] list of EID in this column.
 syllabus.profession.description c_prodesc mtext PARAGRAPH
 v_prodesc
 e_prodesc integer[] list of EID in this column.
 syllabus.profession.foundation c_foundation mtext[] EID
 v_foundation
 e_foundation integer[] list of EID in this column.
 syllabus.profession.foundation.necessity c_necessity float8[] REAL
 v_necessity
 e_necessity integer[] list of EID in this column.

"t_21095_prodesc"     --- associated with syllabus.profession.description
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.profession r_idx0 integer subscript in primary tuple.
 c_profession mtext NAME
 v_profession
 e_profession integer[] list of EID in this column.
 syllabus.profession.description r_idx1 integer subscript in super column.
 c_prodesc mtext PARAGRAPH
 v_prodesc
 e_prodesc integer[] list of EID in this column.

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

"t_21095_necessity"     --- associated with syllabus.profession.foundation.necessity
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.profession r_idx0 integer subscript in primary tuple.
 c_profession mtext NAME
 v_profession
 e_profession integer[] list of EID in this column.
 syllabus.profession.foundation r_idx1 integer subscript in super column.
 c_foundation mtext EID
 v_foundation
 e_foundation integer[] list of EID in this column.
 syllabus.profession.foundation.necessity r_idx2 integer subscript in super column.
 c_necessity float8 REAL
 v_necessity
 e_necessity integer[] list of EID in this column.

"t_21095_category"     --- associated with syllabus.category
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.category r_idx0 integer subscript in primary tuple.
 c_category mtext NAME
 v_category
 e_category integer[] list of EID in this column.
 syllabus.category.lecture c_lecture mtext[] EID
 v_lecture
 e_lecture integer[] list of EID in this column.
 syllabus.category.lecture.class c_sclass mtext[] EID
 v_sclass
 e_sclass integer[] list of EID in this column.
 syllabus.category.lecture.year c_year mtext[] EID
 v_year
 e_year integer[] list of EID in this column.
 syllabus.category.lecture.year.term c_term mtext[] EID
 v_term
 e_term integer[] list of EID in this column.

"t_21095_lecture"     --- associated with syllabus.category.lecture
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.category r_idx0 integer subscript in primary tuple.
 c_category mtext NAME
 v_category
 e_category integer[] list of EID in this column.
 syllabus.category.lecture r_idx1 integer subscript in super column.
 c_lecture mtext EID
 v_lecture
 e_lecture integer[] list of EID in this column.
 syllabus.category.lecture.class c_sclass mtext EID
 v_sclass
 e_sclass integer[] list of EID in this column.
 syllabus.category.lecture.year c_year mtext[] EID
 v_year
 e_year integer[] list of EID in this column.
 syllabus.category.lecture.year.term c_term mtext[] EID
 v_term
 e_term integer[] list of EID in this column.

"t_21095_sclass"     --- associated with syllabus.category.lecture.class
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.category r_idx0 integer subscript in primary tuple.
 c_category mtext NAME
 v_category
 e_category integer[] list of EID in this column.
 syllabus.category.lecture r_idx1 integer subscript in super column.
 c_lecture mtext EID
 v_lecture
 e_lecture integer[] list of EID in this column.
 syllabus.category.lecture.class r_idx2 integer subscript in super column.
 c_sclass mtext EID
 v_sclass
 e_sclass integer[] list of EID in this column.

"t_21095_year"     --- associated with syllabus.category.lecture.year
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.category r_idx0 integer subscript in primary tuple.
 c_category mtext NAME
 v_category
 e_category integer[] list of EID in this column.
 syllabus.category.lecture r_idx1 integer subscript in super column.
 c_lecture mtext EID
 v_lecture
 e_lecture integer[] list of EID in this column.
 syllabus.category.lecture.year r_idx2 integer subscript in super column.
 c_year mtext EID
 v_year
 e_year integer[] list of EID in this column.
 syllabus.category.lecture.year.term c_term mtext[] EID
 v_term
 e_term integer[] list of EID in this column.

"t_21095_term"     --- associated with syllabus.category.lecture.year.term
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.category r_idx0 integer subscript in primary tuple.
 c_category mtext NAME
 v_category
 e_category integer[] list of EID in this column.
 syllabus.category.lecture r_idx1 integer subscript in super column.
 c_lecture mtext EID
 v_lecture
 e_lecture integer[] list of EID in this column.
 syllabus.category.lecture.year r_idx2 integer subscript in super column.
 c_year mtext EID
 v_year
 e_year integer[] list of EID in this column.
 syllabus.category.lecture.year.term r_idx3 integer subscript in super column.
 c_term mtext EID
 v_term
 e_term integer[] list of EID in this column.

"t_21095_note"     --- associated with syllabus.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 syllabus.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=1044)