本ページは,毎日1回午前3時時点のデータベース登録情報をもとに作成しています.したがって,本日登録・修正した変更内容は反映していません.本日作業分の変更内容の反映には,明日までお待ち下さい. |
Definition of Syllabus.
- XML: syllabus (XML, DTD)
- SQL: t_21095
- 名前: (英)Syllabus (日)教育プログラム (読)きょういくぷろぐらむ
- 説明: (英)list of syllabuses (日)教育プログラムのリスト
- 解説: (英) (日)教育プログラムを登録するためのテーブルです.
- マップ:
- 属性:
- タプル権限(既定値): 読権: 公開, 作権: ユーザ, 書権: 制限, 削権: 制限.
- カラム権限(既定値): 読権: 公開, 作権: 制限, 書権: 制限, 削権: 制限.
- 登録されているカラム
名前 XML
SQL説明 型 番 数 MAP 権限
委譲分類 同義 期間
限定用法 該当
無可読権 作権 書権 削権 見 順 巾 入学年度
EntryYear@.entryyear
c_entryyear入学年度
EntryYear西暦年 0 1 ○ 必須 (公開) (ユーザ) (制限) (制限) 短 1 10 所属
Affiliate@.affiliate
c_affiliate学科,専攻
Department, course参照 1 1 組織 ◎ ○ 必須 (公開) (ユーザ) (制限) (制限) 短 1 20 名称
Name@.name
c_nameプログラム名
Name of program名称 2 1 必須 (公開) (ユーザ) (制限) (制限) 短 1 40 コース
Course@.course
c_course昼間,夜間,課程
day,night,master,doctoral参照 3 1 コース ○ 必須 (公開) (ユーザ) (制限) (制限) 短 1 10 履修要項
Guidance@.guide
c_guide履修の手引きなどのURL
URL of guidanceURL 4 1 推奨 (公開) (ユーザ) (制限) (制限) × 0 50 修得技能
Profession@.profession
c_profession修得される技能
Accomplished Profession名称 5 * 推奨 (公開) (ユーザ) (制限) (制限) × 0 40 技能説明
Description@.profession.description
c_prodesc技能の説明
Description of Profession段落 6 1 任意 (公開) (ユーザ) (制限) (制限) × 0 200 修得科目
LearnedLecture@.profession.foundation
c_foundation修得する科目
required lectures of profession参照 7 * 授業概要 推奨 (公開) (ユーザ) (制限) (制限) × 0 20 必要度
Necessity@.profession.foundation.necessity
c_necessity科目の必要度
necessity of fundamental lecture実数 8 1 任意 (公開) (ユーザ) (制限) (制限) × 0 10 科目分類
Category@.category
c_category開講科目の分類
Category of lecture名称 9 * 教育プログラム 必須 (公開) (ユーザ) (制限) (制限) × 0 40 開講科目
Lecture@.category.lecture
c_lecture開講科目のリスト
List of lecture参照 10 * 授業概要 必須 (公開) (ユーザ) (制限) (制限) × 0 20 履修種別
SubjectClass@.category.lecture.class
c_sclass必修, 選択, 他
compulsory, selection, etc.参照 11 1 履修種別 推奨 (公開) (ユーザ) (制限) (制限) × 0 10 開講年次
LectureYear@.category.lecture.year
c_year開講年次(のリスト)
List of lecture year(s)参照 12 * 講義年次 推奨 (公開) (ユーザ) (制限) (制限) × 0 10 開講学期
LectureTerm@.category.lecture.year.term
c_term開講学期(のリスト)
List of lecture term(s)参照 13 * 講義期間 任意 (公開) (ユーザ) (制限) (制限) × 0 10 備考
Note@.note
c_note備考
Note文 14 * 任意 (公開) (ユーザ) (制限) (制限) × 0 200 - カラムの解説文:
- 入学年度: (英) EntryYear (日) 入学年度
- 所属: (英) Please choose the organization. (日) 本教育プログラムが属している学科または専攻を選択してください.
- 名称: (英) Please write the name of program. (日) 学科や専攻のほかに付加されるプログラム名があれば記述してください.
- コース: (英) Please choose the course. (日) 昼間,夜間,課程の種別を選択してください.
- 履修要項: (英) Please write the URL of guidance page. (日) 履修要項などのWeb page,PDFなどのURLを記述してください..
- 修得技能: (英) Please write the name of profession. (日) 修得される技能の呼称を記述してください.
- 技能説明: (英) Please write the description of profession. (日) 修得される技能の説明を記述してください.
- 修得科目: (英) Please choose the required lectures to get profession. Lectures must have same entry year. (日) この技能の修得に必要な科目を選択してください.科目は入学年度の等しい科目を選んでください.
- 必要度: (英) Please write the necessity of fundamental lecture, from 0.0 to 1.0 (default:1.0). (日) 本技能を修得するための科目の必要度を0.0(必要度:小)〜1.0(必要度:大)で指定してください.(省略された場合1.0と解釈されます.)
- 科目分類: (英) Please write the name of category. (日) 共通教育,専門科目などの開講科目の分類名を記述してください.
- 開講科目: (英) Please choose the lectures. (日) 開講されている科目を選択してください.
- 履修種別: (英) Please choose the class of taking subject. (日) 講義の履修要件(必修,選択,その他)を選択してください.
- 開講年次: (英) Please choose the lecture year(s). (日) 講義を開講している学生の年次を選択してください.複数の学年に開講している場合や学年にまたがって開講している場合には複数登録してください.
- 開講学期: (英) Please choose the lecture term(s). (日) 講義を開講している学期を選択してください.複数の学期に開講している場合は複数登録してください.
- 備考: (英) Please write the information which cannot be written on registered column. (日) 登録されているカラムに記述すべき内容以外に,特に記しておきたい事柄があれば記述してください.
- 参照しているカラム:
Relational tables associated with Syllabus.
- Primary table: "t_21095"
- Columns:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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:
XML column name SQL definition description 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.