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

Table Definition : "Prize"

Definition of Prize.

XML: prize (XML, DTD)

SQL: t_10016

名前: （英）Prize （日）賞（読）しょう

説明: （英）list of prizes （日）教職員，学生または組織の受賞の情報

解説: （英）（日）教職員，学生または組織が受賞した賞を登録するテーブルです．

マップ:

属性:

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

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

登録されているカラム

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

カテゴリ
Category @.category
c_category 賞のカテゴリ
Category of Prize 参照 0 1 カテゴリ
○ 必須 (公開) (ユーザ) (制限) (制限) × 0 20

団体
Awarder @.awarder
c_awarder 授与団体の名称
name of awarder 名称 1 1 組織
必須 (公開) (ユーザ) (制限) (制限) 長 0 40

名称
Name @.name
c_name 賞の名称
name of award 名称 2 1 必須 (公開) (ユーザ) (制限) (制限) 短 0 50

組織
Organization @.organization
c_organization 受賞者の所属する組織
organization 参照 3 * 組織
◎ ○ 推奨 (公開) (ユーザ) (制限) (制限) × 0 20

受賞者
Awardee @.awardee
c_awardee 受賞者または受賞組織
awardee 名称 4 * 個人
 組織
◎ 必須 (公開) (ユーザ) (制限) (制限) 短 0 20

  学籍番号
  StudentCode @.awardee.studentcode
c_awardee_studentcode 学生の学籍番号
Student Code 外部DB識別子 5 1 推奨 (ユーザ) (ユーザ) (制限) (制限) × 0 12

  所属(学生)
  AwardeeAffiliate @.awardee.affiliate
c_awardee_affiliate 学生の所属組織
Affiliate of Student 参照 6 1 組織
(ユーザ) (ユーザ) (制限) (制限) × 0 10

  肩書(学生)
  AwardeeTitle @.awardee.title
c_awardee_title 学生の身分
Title of Awardee(Student) 参照 7 1 肩書
(ユーザ) (ユーザ) (制限) (制限) × 0 10

テーマ
Theme @.theme
c_theme 研究テーマなど
theme 文 8 1 必須 (公開) (ユーザ) (制限) (制限) × 0 100

年月日
Date @.date
c_date 受賞した年月日
date of prize 日付 9 1 ○ 必須 (公開) (ユーザ) (制限) (制限) 長 1 20

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

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

カラムの解説文:

カテゴリ: (英) Please choose the category. (日) 賞の種別をカテゴリのリストの中から選んでください．

団体: (英) Please write the awarder. (日) 授与団体の名称を記入してください．

名称: (英) Please write the name of award. (日) 賞の名称を記入してください．

組織: (英) Please choose the organization. (日) 受賞者の所属する講座を選んでください．学科，専攻，講座毎の受賞の集計を行なうときに利用します．

受賞者: (英) Please choose the awardee. (日) 受賞者または受賞組織を選んでください．受賞者が本学の教員の場合には必ず参照登録して下さい．受賞者が学生の場合には，副項目[学籍番号]または副項目[所属(学生)]，[肩書(学生)]に登録を行って下さい．

学籍番号: (英) Student code (10 digits) if awardee is student. (日) 受賞者が本学の学生の場合，学生の学籍番号（10桁）を記入して下さい．

所属(学生): (英) Organization which the awardee(student) belonging on. (日) 受賞者が本学の学生の場合，学生の所属する組織（学科，専攻，コース）を選択して下さい．

肩書(学生): (英) Title of awardee(student). (日) 受賞者が本学の学生の場合，学生の身分（修士課程，博士課程，…等）を選択して下さい．

テーマ: (英) Please write the theme. (日) 受賞を受けた研究テーマ（論文題目など）を記入してください．

年月日: (英) Please write the date of prize. (日) 受賞年月日を記入してください．

指導教員: (英) If awardee is student, please choose the teachers. (日) 学生の単独受賞などの場合には，指導教員を選んでください．

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

参照しているカラム:

Relational tables associated with Prize.

Primary table: "t_10016"

Columns:

XML column name SQL definition description

Base Columns
prize.category c_category mtext EID
v_category
e_category integer[] list of EID in this column.

prize.awarder c_awarder mtext[] NAME
v_awarder
e_awarder integer[] list of EID in this column.

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

prize.organization c_organization mtext[] EID
v_organization
e_organization integer[] list of EID in this column.

prize.awardee c_awardee mtext[] NAME
v_awardee
e_awardee integer[] list of EID in this column.

prize.awardee.studentcode c_awardee_studentcode text[] EXTID
v_awardee_studentcode
e_awardee_studentcode integer[] list of EID in this column.

prize.awardee.affiliate c_awardee_affiliate mtext[] EID
v_awardee_affiliate
e_awardee_affiliate integer[] list of EID in this column.

prize.awardee.title c_awardee_title mtext[] EID
v_awardee_title
e_awardee_title integer[] list of EID in this column.

prize.theme c_theme mtext SENTENCE
v_theme
e_theme integer[] list of EID in this column.

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

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

prize.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_10016_category"     --- associated with prize.category

Columns:

XML column name SQL definition description

Base Columns
prize.category r_idx0 integer subscript in primary tuple.
c_category mtext EID
v_category
e_category integer[] list of EID in this column.

"t_10016_awarder"     --- associated with prize.awarder

Columns:

XML column name SQL definition description

Base Columns
prize.awarder r_idx0 integer subscript in primary tuple.
c_awarder mtext[] NAME
v_awarder
e_awarder integer[] list of EID in this column.

"t_10016_name"     --- associated with prize.name

Columns:

XML column name SQL definition description

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

"t_10016_organization"     --- associated with prize.organization

Columns:

XML column name SQL definition description

Base Columns
prize.organization r_idx0 integer subscript in primary tuple.
c_organization mtext[] EID
v_organization
e_organization integer[] list of EID in this column.

"t_10016_awardee"     --- associated with prize.awardee

Columns:

XML column name SQL definition description

Base Columns
prize.awardee r_idx0 integer subscript in primary tuple.
c_awardee mtext[] NAME
v_awardee
e_awardee integer[] list of EID in this column.

prize.awardee.studentcode c_awardee_studentcode text EXTID
v_awardee_studentcode
e_awardee_studentcode integer[] list of EID in this column.

prize.awardee.affiliate c_awardee_affiliate mtext[] EID
v_awardee_affiliate
e_awardee_affiliate integer[] list of EID in this column.

prize.awardee.title c_awardee_title mtext EID
v_awardee_title
e_awardee_title integer[] list of EID in this column.

"t_10016_awardee_studentco"     --- associated with prize.awardee.studentcode

Columns:

XML column name SQL definition description

Base Columns
prize.awardee r_idx0 integer subscript in primary tuple.
c_awardee mtext[] NAME
v_awardee
e_awardee integer[] list of EID in this column.

prize.awardee.studentcode r_idx1 integer subscript in super column.
c_awardee_studentcode text EXTID
v_awardee_studentcode
e_awardee_studentcode integer[] list of EID in this column.

"t_10016_awardee_affiliate"     --- associated with prize.awardee.affiliate

Columns:

XML column name SQL definition description

Base Columns
prize.awardee r_idx0 integer subscript in primary tuple.
c_awardee mtext[] NAME
v_awardee
e_awardee integer[] list of EID in this column.

prize.awardee.affiliate r_idx1 integer subscript in super column.
c_awardee_affiliate mtext[] EID
v_awardee_affiliate
e_awardee_affiliate integer[] list of EID in this column.

"t_10016_awardee_title"     --- associated with prize.awardee.title

Columns:

XML column name SQL definition description

Base Columns
prize.awardee r_idx0 integer subscript in primary tuple.
c_awardee mtext[] NAME
v_awardee
e_awardee integer[] list of EID in this column.

prize.awardee.title r_idx1 integer subscript in super column.
c_awardee_title mtext EID
v_awardee_title
e_awardee_title integer[] list of EID in this column.

"t_10016_theme"     --- associated with prize.theme

Columns:

XML column name SQL definition description

Base Columns
prize.theme r_idx0 integer subscript in primary tuple.
c_theme mtext SENTENCE
v_theme
e_theme integer[] list of EID in this column.

"t_10016_date"     --- associated with prize.date

Columns:

XML column name SQL definition description

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

"t_10016_teacher"     --- associated with prize.teacher

Columns:

XML column name SQL definition description

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

"t_10016_note"     --- associated with prize.note

Columns:

XML column name SQL definition description

Base Columns
prize.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	権限委譲	分類	用法	読権	作権	書権	削権	見	順	巾
カテゴリ Category	@.category c_category	賞のカテゴリ Category of Prize	参照	0	1	カテゴリ		○	必須	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
団体 Awarder	@.awarder c_awarder	授与団体の名称 name of awarder	名称	1	1	組織			必須	(公開)	(ユーザ)	(制限)	(制限)	長	0	40
名称 Name	@.name c_name	賞の名称 name of award	名称	2	1				必須	(公開)	(ユーザ)	(制限)	(制限)	短	0	50
組織 Organization	@.organization c_organization	受賞者の所属する組織 organization	参照	3	*	組織	◎	○	推奨	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
受賞者 Awardee	@.awardee c_awardee	受賞者または受賞組織 awardee	名称	4	*	個人組織	◎		必須	(公開)	(ユーザ)	(制限)	(制限)	短	0	20
学籍番号 StudentCode	@.awardee.studentcode c_awardee_studentcode	学生の学籍番号 Student Code	外部DB識別子	5	1				推奨	(ユーザ)	(ユーザ)	(制限)	(制限)	×	0	12
所属(学生) AwardeeAffiliate	@.awardee.affiliate c_awardee_affiliate	学生の所属組織 Affiliate of Student	参照	6	1	組織				(ユーザ)	(ユーザ)	(制限)	(制限)	×	0	10
肩書(学生) AwardeeTitle	@.awardee.title c_awardee_title	学生の身分 Title of Awardee(Student)	参照	7	1	肩書				(ユーザ)	(ユーザ)	(制限)	(制限)	×	0	10
テーマ Theme	@.theme c_theme	研究テーマなど theme	文	8	1				必須	(公開)	(ユーザ)	(制限)	(制限)	×	0	100
年月日 Date	@.date c_date	受賞した年月日 date of prize	日付	9	1			○	必須	(公開)	(ユーザ)	(制限)	(制限)	長	1	20
指導教員 Teacher	@.teacher c_teacher	指導教員の氏名 name of teacher	参照	10	*	個人	◎		推奨	(公開)	(ユーザ)	(制限)	(制限)	短	0	20
備考 Note	@.note c_note	備考 Note	文	11	*				任意	(公開)	(ユーザ)	(制限)	(制限)	×	0	200

XML	column name	SQL definition	description
	Base Columns
prize.category	c_category	mtext	EID
v_category
e_category	integer[]	list of EID in this column.
prize.awarder	c_awarder	mtext[]	NAME
v_awarder
e_awarder	integer[]	list of EID in this column.
prize.name	c_name	mtext	NAME
v_name
e_name	integer[]	list of EID in this column.
prize.organization	c_organization	mtext[]	EID
v_organization
e_organization	integer[]	list of EID in this column.
prize.awardee	c_awardee	mtext[]	NAME
v_awardee
e_awardee	integer[]	list of EID in this column.
prize.awardee.studentcode	c_awardee_studentcode	text[]	EXTID
v_awardee_studentcode
e_awardee_studentcode	integer[]	list of EID in this column.
prize.awardee.affiliate	c_awardee_affiliate	mtext[]	EID
v_awardee_affiliate
e_awardee_affiliate	integer[]	list of EID in this column.
prize.awardee.title	c_awardee_title	mtext[]	EID
v_awardee_title
e_awardee_title	integer[]	list of EID in this column.
prize.theme	c_theme	mtext	SENTENCE
v_theme
e_theme	integer[]	list of EID in this column.
prize.date	c_date	int4	DATE
v_date
e_date	integer[]	list of EID in this column.
prize.teacher	c_teacher	mtext[]	EID
v_teacher
e_teacher	integer[]	list of EID in this column.
prize.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
prize.category	r_idx0	integer	subscript in primary tuple.
c_category	mtext	EID
v_category
e_category	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
prize.awarder	r_idx0	integer	subscript in primary tuple.
c_awarder	mtext[]	NAME
v_awarder
e_awarder	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
prize.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
prize.organization	r_idx0	integer	subscript in primary tuple.
c_organization	mtext[]	EID
v_organization
e_organization	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
prize.awardee	r_idx0	integer	subscript in primary tuple.
c_awardee	mtext[]	NAME
v_awardee
e_awardee	integer[]	list of EID in this column.
prize.awardee.studentcode	c_awardee_studentcode	text	EXTID
v_awardee_studentcode
e_awardee_studentcode	integer[]	list of EID in this column.
prize.awardee.affiliate	c_awardee_affiliate	mtext[]	EID
v_awardee_affiliate
e_awardee_affiliate	integer[]	list of EID in this column.
prize.awardee.title	c_awardee_title	mtext	EID
v_awardee_title
e_awardee_title	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
prize.awardee	r_idx0	integer	subscript in primary tuple.
c_awardee	mtext[]	NAME
v_awardee
e_awardee	integer[]	list of EID in this column.
prize.awardee.studentcode	r_idx1	integer	subscript in super column.
c_awardee_studentcode	text	EXTID
v_awardee_studentcode
e_awardee_studentcode	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
prize.awardee	r_idx0	integer	subscript in primary tuple.
c_awardee	mtext[]	NAME
v_awardee
e_awardee	integer[]	list of EID in this column.
prize.awardee.affiliate	r_idx1	integer	subscript in super column.
c_awardee_affiliate	mtext[]	EID
v_awardee_affiliate
e_awardee_affiliate	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
prize.awardee	r_idx0	integer	subscript in primary tuple.
c_awardee	mtext[]	NAME
v_awardee
e_awardee	integer[]	list of EID in this column.
prize.awardee.title	r_idx1	integer	subscript in super column.
c_awardee_title	mtext	EID
v_awardee_title
e_awardee_title	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
prize.theme	r_idx0	integer	subscript in primary tuple.
c_theme	mtext	SENTENCE
v_theme
e_theme	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
prize.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
prize.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
prize.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 Sat Apr 20 03:40:06 2024. (p-db3.edb-private:5433:edb_latest v.13.14, o=8/8, c=2, q=107, h=1301)