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

Table Definition : "Thesis"

Definition of Thesis.

XML: thesis (XML, DTD)

SQL: t_10022

名前: （英）Thesis （日）学位論文（読）がくいろんぶん

説明: （英）thesis （日）学位授与の情報

解説: （英）（日）授与した学位を登録するためのテーブルです．

マップ:

属性:

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

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

登録されているカラム

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

学科・専攻
Course @.course
c_course 学位授与学科・専攻（論文博士の場合には研究科名）
name of organization 参照 0 * 組織
◎ ○ 必須 (公開) (ユーザ) (制限) (制限) 短 1 20

学位
Degree @.degree
c_degree 学位の種別
degree 参照 1 1 学位論文属性
○ 必須 (公開) (ユーザ) (制限) (制限) 短 1 10

  学位名称
  DegreeName @.degree.name
c_degree_name 学位の名称
name of degree 参照 2 1 学位名称
必須 (公開) (ユーザ) (制限) (制限) × 1 10

    学位正式名称
    OfficialDegreeName @.degree.name.official
c_official_name 学位の正式名称
official name of degree 名称 3 1 必須 (公開) (ユーザ) (制限) (制限) × 1 20

言語
Language @.language
c_language 論文の言語
language of thesis 参照 4 1 言語
推奨 (公開) (ユーザ) (制限) (制限) × 0 10

氏名
Name @.name
c_name 氏名
name 名称 5 * 個人
◎ 必須 (学内) (ユーザ) (制限) (制限) 長 0 20

題名
Title @.title
c_title 論文名
title of thesis 文 6 1 必須 (公開) (ユーザ) (制限) (制限) 短 0 100

副題
Subtitle @.subtitle
c_subtitle 論文の副題
subtitle of thesis 文 7 1 任意 (公開) (ユーザ) (制限) (制限) × 0 100

要約
Summary @.summary
c_summary 論文の要約
summary of artile 段落 8 1 任意 (公開) (ユーザ) (制限) (制限) × 0 500

キーワード
Keyword @.keyword
c_keyword 論文のキーワード
keyword of thesis 名称 9 * キーワード
推奨 (公開) (ユーザ) (制限) (制限) × 0 20

年月日
Date @.date
c_date 発行年月日
date of publication 日付 10 1 ○ 必須 (公開) (ユーザ) (制限) (制限) 短 1 20

指導教員
Teacher @.teacher
c_teacher 指導教員の氏名
name of teacher 参照 11 * 個人
◎ 必須 (公開) (ユーザ) (制限) (制限) 短 0 20

指導協力教員
CooperativeTeacher @.teacher2
c_teacher2 指導協力教員の氏名
name of cooperative teacher 参照 12 * 個人
◎ 任意 (公開) (ユーザ) (制限) (制限) × 0 20

審査教員
Referee @.referee
c_referee 審査教員の氏名
name of referee 名称 13 * 個人
◎ 必須 (公開) (ユーザ) (制限) (制限) × 0 20

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

カラムの解説文:

学科・専攻: (英) Please choose the course of thesis. (日) 学位授与を行なった学科または専攻（学科，論文博士の場合には研究科名）を選んでください．

学位: (英) Please choose the type of thesis. (日) 学位論文の種別を選んでください．

学位名称: (英) Please choose the name of degree. (日) 学位の名称を選んでください．

学位正式名称: (英) Please write the official name of degree. (日) 学位の正式名称を記入して下さい．

言語: (英) Please select the language of this thesis. (日) 論文の言語を選択してください．

氏名: (英) Please write the name of student. (日) 学位を受けた学生の名前を記入してください．英名は「Surname(Family-name), Given-name」の順に記入してください．

題名: (英) Please write the title of thesis. (日) 学位論文の題名を記入してください．

副題: (英) Please write the subtitle of thesis. (if titled) (日) 副題があれば記入してください．

要約: (英) Please write the summary of thesis. (voluntary) (日) 要約を記入してください．(必須ではありません)

キーワード: (英) Please write the keyword of thesis. (voluntary) (日) キーワードを記入してください．(必須ではありません)

年月日: (英) Please write the date of conferment. (日) 学位授与を行なった年月日を記入してください．

指導教員: (英) Please choose the teachers. (日) 指導教員を選んでください．

指導協力教員: (英) Please choose the cooperative teachers. (日) 指導協力教員を選んでください．

審査教員: (英) Please choose the referees.(first is main referee, others are assistant referee) (日) 審査を行なった教員を選んでください．最初に登録された教員が主査，残りは副査となります．

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

参照しているカラム:

Relational tables associated with Thesis.

Primary table: "t_10022"

Columns:

XML column name SQL definition description

Base Columns
thesis.course c_course mtext[] EID
v_course
e_course integer[] list of EID in this column.

thesis.degree c_degree mtext EID
v_degree
e_degree integer[] list of EID in this column.

thesis.degree.name c_degree_name mtext EID
v_degree_name
e_degree_name integer[] list of EID in this column.

thesis.degree.name.official c_official_name mtext NAME
v_official_name
e_official_name integer[] list of EID in this column.

thesis.language c_language mtext EID
v_language
e_language integer[] list of EID in this column.

thesis.name c_name mtext[] NAME
v_name
e_name integer[] list of EID in this column.

thesis.title c_title mtext SENTENCE
v_title
e_title integer[] list of EID in this column.

thesis.subtitle c_subtitle mtext SENTENCE
v_subtitle
e_subtitle integer[] list of EID in this column.

thesis.summary c_summary mtext PARAGRAPH
v_summary
e_summary integer[] list of EID in this column.

thesis.keyword c_keyword mtext[] NAME
v_keyword
e_keyword integer[] list of EID in this column.

thesis.date c_date int4 DATE
v_date
e_date integer[] list of EID in this column.

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

thesis.teacher2 c_teacher2 mtext[] EID
v_teacher2
e_teacher2 integer[] list of EID in this column.

thesis.referee c_referee mtext[] NAME
v_referee
e_referee integer[] list of EID in this column.

thesis.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_10022_course"     --- associated with thesis.course

Columns:

XML column name SQL definition description

Base Columns
thesis.course r_idx0 integer subscript in primary tuple.
c_course mtext[] EID
v_course
e_course integer[] list of EID in this column.

"t_10022_degree"     --- associated with thesis.degree

Columns:

XML column name SQL definition description

Base Columns
thesis.degree r_idx0 integer subscript in primary tuple.
c_degree mtext EID
v_degree
e_degree integer[] list of EID in this column.

thesis.degree.name c_degree_name mtext EID
v_degree_name
e_degree_name integer[] list of EID in this column.

thesis.degree.name.official c_official_name mtext NAME
v_official_name
e_official_name integer[] list of EID in this column.

"t_10022_degree_name"     --- associated with thesis.degree.name

Columns:

XML column name SQL definition description

Base Columns
thesis.degree r_idx0 integer subscript in primary tuple.
c_degree mtext EID
v_degree
e_degree integer[] list of EID in this column.

thesis.degree.name r_idx1 integer subscript in super column.
c_degree_name mtext EID
v_degree_name
e_degree_name integer[] list of EID in this column.

thesis.degree.name.official c_official_name mtext NAME
v_official_name
e_official_name integer[] list of EID in this column.

"t_10022_official_name"     --- associated with thesis.degree.name.official

Columns:

XML column name SQL definition description

Base Columns
thesis.degree r_idx0 integer subscript in primary tuple.
c_degree mtext EID
v_degree
e_degree integer[] list of EID in this column.

thesis.degree.name r_idx1 integer subscript in super column.
c_degree_name mtext EID
v_degree_name
e_degree_name integer[] list of EID in this column.

thesis.degree.name.official r_idx2 integer subscript in super column.
c_official_name mtext NAME
v_official_name
e_official_name integer[] list of EID in this column.

"t_10022_language"     --- associated with thesis.language

Columns:

XML column name SQL definition description

Base Columns
thesis.language r_idx0 integer subscript in primary tuple.
c_language mtext EID
v_language
e_language integer[] list of EID in this column.

"t_10022_name"     --- associated with thesis.name

Columns:

XML column name SQL definition description

Base Columns
thesis.name r_idx0 integer subscript in primary tuple.
c_name mtext NAME
v_name
e_name integer[] list of EID in this column.

"t_10022_title"     --- associated with thesis.title

Columns:

XML column name SQL definition description

Base Columns
thesis.title r_idx0 integer subscript in primary tuple.
c_title mtext SENTENCE
v_title
e_title integer[] list of EID in this column.

"t_10022_subtitle"     --- associated with thesis.subtitle

Columns:

XML column name SQL definition description

Base Columns
thesis.subtitle r_idx0 integer subscript in primary tuple.
c_subtitle mtext SENTENCE
v_subtitle
e_subtitle integer[] list of EID in this column.

"t_10022_summary"     --- associated with thesis.summary

Columns:

XML column name SQL definition description

Base Columns
thesis.summary r_idx0 integer subscript in primary tuple.
c_summary mtext PARAGRAPH
v_summary
e_summary integer[] list of EID in this column.

"t_10022_keyword"     --- associated with thesis.keyword

Columns:

XML column name SQL definition description

Base Columns
thesis.keyword r_idx0 integer subscript in primary tuple.
c_keyword mtext NAME
v_keyword
e_keyword integer[] list of EID in this column.

"t_10022_date"     --- associated with thesis.date

Columns:

XML column name SQL definition description

Base Columns
thesis.date r_idx0 integer subscript in primary tuple.
c_date int4 DATE
v_date
e_date integer[] list of EID in this column.

"t_10022_teacher"     --- associated with thesis.teacher

Columns:

XML column name SQL definition description

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

"t_10022_teacher2"     --- associated with thesis.teacher2

Columns:

XML column name SQL definition description

Base Columns
thesis.teacher2 r_idx0 integer subscript in primary tuple.
c_teacher2 mtext EID
v_teacher2
e_teacher2 integer[] list of EID in this column.

"t_10022_referee"     --- associated with thesis.referee

Columns:

XML column name SQL definition description

Base Columns
thesis.referee r_idx0 integer subscript in primary tuple.
c_referee mtext NAME
v_referee
e_referee integer[] list of EID in this column.

"t_10022_note"     --- associated with thesis.note

Columns:

XML column name SQL definition description

Base Columns
thesis.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	権限委譲	分類	用法	読権	作権	書権	削権	見	順	巾
学科・専攻 Course	@.course c_course	学位授与学科・専攻（論文博士の場合には研究科名） name of organization	参照	0	*	組織	◎	○	必須	(公開)	(ユーザ)	(制限)	(制限)	短	1	20
学位 Degree	@.degree c_degree	学位の種別 degree	参照	1	1	学位論文属性		○	必須	(公開)	(ユーザ)	(制限)	(制限)	短	1	10
学位名称 DegreeName	@.degree.name c_degree_name	学位の名称 name of degree	参照	2	1	学位名称			必須	(公開)	(ユーザ)	(制限)	(制限)	×	1	10
学位正式名称 OfficialDegreeName	@.degree.name.official c_official_name	学位の正式名称 official name of degree	名称	3	1				必須	(公開)	(ユーザ)	(制限)	(制限)	×	1	20
言語 Language	@.language c_language	論文の言語 language of thesis	参照	4	1	言語			推奨	(公開)	(ユーザ)	(制限)	(制限)	×	0	10
氏名 Name	@.name c_name	氏名 name	名称	5	*	個人	◎		必須	(学内)	(ユーザ)	(制限)	(制限)	長	0	20
題名 Title	@.title c_title	論文名 title of thesis	文	6	1				必須	(公開)	(ユーザ)	(制限)	(制限)	短	0	100
副題 Subtitle	@.subtitle c_subtitle	論文の副題 subtitle of thesis	文	7	1				任意	(公開)	(ユーザ)	(制限)	(制限)	×	0	100
要約 Summary	@.summary c_summary	論文の要約 summary of artile	段落	8	1				任意	(公開)	(ユーザ)	(制限)	(制限)	×	0	500
キーワード Keyword	@.keyword c_keyword	論文のキーワード keyword of thesis	名称	9	*	キーワード			推奨	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
年月日 Date	@.date c_date	発行年月日 date of publication	日付	10	1			○	必須	(公開)	(ユーザ)	(制限)	(制限)	短	1	20
指導教員 Teacher	@.teacher c_teacher	指導教員の氏名 name of teacher	参照	11	*	個人	◎		必須	(公開)	(ユーザ)	(制限)	(制限)	短	0	20
指導協力教員 CooperativeTeacher	@.teacher2 c_teacher2	指導協力教員の氏名 name of cooperative teacher	参照	12	*	個人	◎		任意	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
審査教員 Referee	@.referee c_referee	審査教員の氏名 name of referee	名称	13	*	個人	◎		必須	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
備考 Note	@.note c_note	備考 Note	文	14	*				任意	(公開)	(ユーザ)	(制限)	(制限)	×	0	200

XML	column name	SQL definition	description
	Base Columns
thesis.course	c_course	mtext[]	EID
v_course
e_course	integer[]	list of EID in this column.
thesis.degree	c_degree	mtext	EID
v_degree
e_degree	integer[]	list of EID in this column.
thesis.degree.name	c_degree_name	mtext	EID
v_degree_name
e_degree_name	integer[]	list of EID in this column.
thesis.degree.name.official	c_official_name	mtext	NAME
v_official_name
e_official_name	integer[]	list of EID in this column.
thesis.language	c_language	mtext	EID
v_language
e_language	integer[]	list of EID in this column.
thesis.name	c_name	mtext[]	NAME
v_name
e_name	integer[]	list of EID in this column.
thesis.title	c_title	mtext	SENTENCE
v_title
e_title	integer[]	list of EID in this column.
thesis.subtitle	c_subtitle	mtext	SENTENCE
v_subtitle
e_subtitle	integer[]	list of EID in this column.
thesis.summary	c_summary	mtext	PARAGRAPH
v_summary
e_summary	integer[]	list of EID in this column.
thesis.keyword	c_keyword	mtext[]	NAME
v_keyword
e_keyword	integer[]	list of EID in this column.
thesis.date	c_date	int4	DATE
v_date
e_date	integer[]	list of EID in this column.
thesis.teacher	c_teacher	mtext[]	EID
v_teacher
e_teacher	integer[]	list of EID in this column.
thesis.teacher2	c_teacher2	mtext[]	EID
v_teacher2
e_teacher2	integer[]	list of EID in this column.
thesis.referee	c_referee	mtext[]	NAME
v_referee
e_referee	integer[]	list of EID in this column.
thesis.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
thesis.course	r_idx0	integer	subscript in primary tuple.
c_course	mtext[]	EID
v_course
e_course	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.degree	r_idx0	integer	subscript in primary tuple.
c_degree	mtext	EID
v_degree
e_degree	integer[]	list of EID in this column.
thesis.degree.name	c_degree_name	mtext	EID
v_degree_name
e_degree_name	integer[]	list of EID in this column.
thesis.degree.name.official	c_official_name	mtext	NAME
v_official_name
e_official_name	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.degree	r_idx0	integer	subscript in primary tuple.
c_degree	mtext	EID
v_degree
e_degree	integer[]	list of EID in this column.
thesis.degree.name	r_idx1	integer	subscript in super column.
c_degree_name	mtext	EID
v_degree_name
e_degree_name	integer[]	list of EID in this column.
thesis.degree.name.official	c_official_name	mtext	NAME
v_official_name
e_official_name	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.degree	r_idx0	integer	subscript in primary tuple.
c_degree	mtext	EID
v_degree
e_degree	integer[]	list of EID in this column.
thesis.degree.name	r_idx1	integer	subscript in super column.
c_degree_name	mtext	EID
v_degree_name
e_degree_name	integer[]	list of EID in this column.
thesis.degree.name.official	r_idx2	integer	subscript in super column.
c_official_name	mtext	NAME
v_official_name
e_official_name	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.language	r_idx0	integer	subscript in primary tuple.
c_language	mtext	EID
v_language
e_language	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.name	r_idx0	integer	subscript in primary tuple.
c_name	mtext	NAME
v_name
e_name	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.title	r_idx0	integer	subscript in primary tuple.
c_title	mtext	SENTENCE
v_title
e_title	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.subtitle	r_idx0	integer	subscript in primary tuple.
c_subtitle	mtext	SENTENCE
v_subtitle
e_subtitle	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.summary	r_idx0	integer	subscript in primary tuple.
c_summary	mtext	PARAGRAPH
v_summary
e_summary	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.keyword	r_idx0	integer	subscript in primary tuple.
c_keyword	mtext	NAME
v_keyword
e_keyword	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.date	r_idx0	integer	subscript in primary tuple.
c_date	int4	DATE
v_date
e_date	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.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
thesis.teacher2	r_idx0	integer	subscript in primary tuple.
c_teacher2	mtext	EID
v_teacher2
e_teacher2	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
thesis.referee	r_idx0	integer	subscript in primary tuple.
c_referee	mtext	NAME
v_referee
e_referee	integer[]	list of EID in this column.

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