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

Table Definition : "MeetingLog"

Definition of MeetingLog.

XML: meetinglog (XML, DTD)

SQL: t_10010

名前: （英）MeetingLog （日）会議録（読）かいぎろく

説明: （英）list of meeting logs （日）会議録の情報

解説: （英）（日）会議の議事，議事録，報告等を登録するテーブルです．1回の会議毎に情報を登録してください．

マップ:

属性: (検閲)

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

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

登録されているカラム

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

組織
Organization @.organization
c_organization 開催組織
Organization 参照 0 1 組織
◎ ○ (公開) (職員) (制限) (制限) 短 1 20

年度
Year @.year
c_year 年度
fiscal year 西暦年 1 1 ○ (公開) (職員) (制限) (制限) 短 1 10

回
Number @.number
c_number 第何回目
meeting number 整数 2 1 (公開) (職員) (制限) (制限) 短 1 10

日付
Date @.date
c_date 会議の開催日
date of meeting 日付 3 1 (公開) (職員) (制限) (制限) 長 1 20

議長
Chairman @.chairman
c_chairman 会議の議長
chairman of meeting 参照 4 1 個人
◎ (公開) (職員) (制限) (制限) × 0 20

出席者
Attendance @.attendance
c_attendance 会議出席者
attendants of meeting 参照 5 * 個人
◎ (公開) (職員) (制限) (制限) × 0 20

議事
Proceeding @.proceeding
c_agenda 議事リスト
Proceeings 文 6 * (公開) (職員) (制限) (制限) × 0 100

  議録
  Log @.proceeding.log
c_log 正式議事録
official log 文 7 1 (制限) (所有者) (所有者) (所有者) × 0 100

  議録2
  Log2 @.proceeding.log2
c_log2 教員議事録
log for teachers 文 8 1 (職員) (制限) (制限) (制限) × 0 100

  議録3
  Log3 @.proceeding.log3
c_log3 公開議事録
log for public 文 9 1 (公開) (制限) (制限) (制限) × 0 100

報告
Reporting @.reporting
c_topic 報告リスト
Reportings 文 10 * (公開) (職員) (制限) (制限) × 0 100

  報告録
  ReportLog @.reporting.log
c_replog 正式報告事項録
official report log 文 11 1 (制限) (所有者) (所有者) (所有者) × 0 100

  報告録2
  ReportLog2 @.reporting.log2
c_replog2 教員報告事項録
report log for teachers 文 12 1 (職員) (制限) (制限) (制限) × 0 100

  報告録3
  ReportLog3 @.reporting.log3
c_replog3 公開報告事項録
repot log for public 文 13 1 (公開) (制限) (制限) (制限) × 0 100

備考
Note @.note
c_note 備考
Note 文 14 * (公開) (職員) (制限) (制限) × 0 200

カラムの解説文:

組織: (英) Please choose the organization (日) 会議を開いたグループを選択してください．

年度: (英) Please write the fiscal year. (日) 年度を記入してください．

回: (英) Please write the meeting number. (日) 会議の番号を記入してください．

日付: (英) Please write the date of meeting. (日) 会議を行なった日付を記入してください．

議長: (英) Please choose the chairman of meeting. (日) 議長を選択してください．

出席者: (英) Please choose the attendants of meeting. (日) 会議出席者を選択してください．

議事: (英) Please register the proceddings (日) 議題を登録して下さい．

議録: (英) Please write the official log. (日) 正式な議事録を記入してください．

議録2: (英) Please write the log for teachers. (日) 教員公開用の議事録を記入してください．

議録3: (英) Please write the log for public. (日) 一般公開用の議事録を記入してください．

報告: (英) Please register the reportings (日) 報告を登録して下さい．

報告録: (英) Please write the official report log. (日) 正式な報告事項録を記入してください．

報告録2: (英) Please write the report log for teachers. (日) 教員公開用の報告事項録を記入してください．

報告録3: (英) Please write the report log for public. (日) 一般公開用の報告事項録を記入してください．

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

参照しているカラム:

Relational tables associated with MeetingLog.

Primary table: "t_10010"

Columns:

XML column name SQL definition description

Base Columns
meetinglog.organization c_organization mtext[] EID
v_organization
e_organization integer[] list of EID in this column.

meetinglog.year c_year int4 YEAR
v_year
e_year integer[] list of EID in this column.

meetinglog.number c_number int4 INTEGER
v_number
e_number integer[] list of EID in this column.

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

meetinglog.chairman c_chairman mtext EID
v_chairman
e_chairman integer[] list of EID in this column.

meetinglog.attendance c_attendance mtext[] EID
v_attendance
e_attendance integer[] list of EID in this column.

meetinglog.proceeding c_agenda mtext[] SENTENCE
v_agenda
e_agenda integer[] list of EID in this column.

meetinglog.proceeding.log c_log mtext[] SENTENCE
v_log
e_log integer[] list of EID in this column.

meetinglog.proceeding.log2 c_log2 mtext[] SENTENCE
v_log2
e_log2 integer[] list of EID in this column.

meetinglog.proceeding.log3 c_log3 mtext[] SENTENCE
v_log3
e_log3 integer[] list of EID in this column.

meetinglog.reporting c_topic mtext[] SENTENCE
v_topic
e_topic integer[] list of EID in this column.

meetinglog.reporting.log c_replog mtext[] SENTENCE
v_replog
e_replog integer[] list of EID in this column.

meetinglog.reporting.log2 c_replog2 mtext[] SENTENCE
v_replog2
e_replog2 integer[] list of EID in this column.

meetinglog.reporting.log3 c_replog3 mtext[] SENTENCE
v_replog3
e_replog3 integer[] list of EID in this column.

meetinglog.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_10010_organization"     --- associated with meetinglog.organization

Columns:

XML column name SQL definition description

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

"t_10010_year"     --- associated with meetinglog.year

Columns:

XML column name SQL definition description

Base Columns
meetinglog.year r_idx0 integer subscript in primary tuple.
c_year int4 YEAR
v_year
e_year integer[] list of EID in this column.

"t_10010_number"     --- associated with meetinglog.number

Columns:

XML column name SQL definition description

Base Columns
meetinglog.number r_idx0 integer subscript in primary tuple.
c_number int4 INTEGER
v_number
e_number integer[] list of EID in this column.

"t_10010_date"     --- associated with meetinglog.date

Columns:

XML column name SQL definition description

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

"t_10010_chairman"     --- associated with meetinglog.chairman

Columns:

XML column name SQL definition description

Base Columns
meetinglog.chairman r_idx0 integer subscript in primary tuple.
c_chairman mtext EID
v_chairman
e_chairman integer[] list of EID in this column.

"t_10010_attendance"     --- associated with meetinglog.attendance

Columns:

XML column name SQL definition description

Base Columns
meetinglog.attendance r_idx0 integer subscript in primary tuple.
c_attendance mtext EID
v_attendance
e_attendance integer[] list of EID in this column.

"t_10010_agenda"     --- associated with meetinglog.proceeding

Columns:

XML column name SQL definition description

Base Columns
meetinglog.proceeding r_idx0 integer subscript in primary tuple.
c_agenda mtext SENTENCE
v_agenda
e_agenda integer[] list of EID in this column.

meetinglog.proceeding.log c_log mtext SENTENCE
v_log
e_log integer[] list of EID in this column.

meetinglog.proceeding.log2 c_log2 mtext SENTENCE
v_log2
e_log2 integer[] list of EID in this column.

meetinglog.proceeding.log3 c_log3 mtext SENTENCE
v_log3
e_log3 integer[] list of EID in this column.

"t_10010_log"     --- associated with meetinglog.proceeding.log

Columns:

XML column name SQL definition description

Base Columns
meetinglog.proceeding r_idx0 integer subscript in primary tuple.
c_agenda mtext SENTENCE
v_agenda
e_agenda integer[] list of EID in this column.

meetinglog.proceeding.log r_idx1 integer subscript in super column.
c_log mtext SENTENCE
v_log
e_log integer[] list of EID in this column.

"t_10010_log2"     --- associated with meetinglog.proceeding.log2

Columns:

XML column name SQL definition description

Base Columns
meetinglog.proceeding r_idx0 integer subscript in primary tuple.
c_agenda mtext SENTENCE
v_agenda
e_agenda integer[] list of EID in this column.

meetinglog.proceeding.log2 r_idx1 integer subscript in super column.
c_log2 mtext SENTENCE
v_log2
e_log2 integer[] list of EID in this column.

"t_10010_log3"     --- associated with meetinglog.proceeding.log3

Columns:

XML column name SQL definition description

Base Columns
meetinglog.proceeding r_idx0 integer subscript in primary tuple.
c_agenda mtext SENTENCE
v_agenda
e_agenda integer[] list of EID in this column.

meetinglog.proceeding.log3 r_idx1 integer subscript in super column.
c_log3 mtext SENTENCE
v_log3
e_log3 integer[] list of EID in this column.

"t_10010_topic"     --- associated with meetinglog.reporting

Columns:

XML column name SQL definition description

Base Columns
meetinglog.reporting r_idx0 integer subscript in primary tuple.
c_topic mtext SENTENCE
v_topic
e_topic integer[] list of EID in this column.

meetinglog.reporting.log c_replog mtext SENTENCE
v_replog
e_replog integer[] list of EID in this column.

meetinglog.reporting.log2 c_replog2 mtext SENTENCE
v_replog2
e_replog2 integer[] list of EID in this column.

meetinglog.reporting.log3 c_replog3 mtext SENTENCE
v_replog3
e_replog3 integer[] list of EID in this column.

"t_10010_replog"     --- associated with meetinglog.reporting.log

Columns:

XML column name SQL definition description

Base Columns
meetinglog.reporting r_idx0 integer subscript in primary tuple.
c_topic mtext SENTENCE
v_topic
e_topic integer[] list of EID in this column.

meetinglog.reporting.log r_idx1 integer subscript in super column.
c_replog mtext SENTENCE
v_replog
e_replog integer[] list of EID in this column.

"t_10010_replog2"     --- associated with meetinglog.reporting.log2

Columns:

XML column name SQL definition description

Base Columns
meetinglog.reporting r_idx0 integer subscript in primary tuple.
c_topic mtext SENTENCE
v_topic
e_topic integer[] list of EID in this column.

meetinglog.reporting.log2 r_idx1 integer subscript in super column.
c_replog2 mtext SENTENCE
v_replog2
e_replog2 integer[] list of EID in this column.

"t_10010_replog3"     --- associated with meetinglog.reporting.log3

Columns:

XML column name SQL definition description

Base Columns
meetinglog.reporting r_idx0 integer subscript in primary tuple.
c_topic mtext SENTENCE
v_topic
e_topic integer[] list of EID in this column.

meetinglog.reporting.log3 r_idx1 integer subscript in super column.
c_replog3 mtext SENTENCE
v_replog3
e_replog3 integer[] list of EID in this column.

"t_10010_note"     --- associated with meetinglog.note

Columns:

XML column name SQL definition description

Base Columns
meetinglog.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	権限委譲	分類	読権	作権	書権	削権	見	順	巾
組織 Organization	@.organization c_organization	開催組織 Organization	参照	0	1	組織	◎	○	(公開)	(職員)	(制限)	(制限)	短	1	20
年度 Year	@.year c_year	年度 fiscal year	西暦年	1	1			○	(公開)	(職員)	(制限)	(制限)	短	1	10
回 Number	@.number c_number	第何回目 meeting number	整数	2	1				(公開)	(職員)	(制限)	(制限)	短	1	10
日付 Date	@.date c_date	会議の開催日 date of meeting	日付	3	1				(公開)	(職員)	(制限)	(制限)	長	1	20
議長 Chairman	@.chairman c_chairman	会議の議長 chairman of meeting	参照	4	1	個人	◎		(公開)	(職員)	(制限)	(制限)	×	0	20
出席者 Attendance	@.attendance c_attendance	会議出席者 attendants of meeting	参照	5	*	個人	◎		(公開)	(職員)	(制限)	(制限)	×	0	20
議事 Proceeding	@.proceeding c_agenda	議事リスト Proceeings	文	6	*				(公開)	(職員)	(制限)	(制限)	×	0	100
議録 Log	@.proceeding.log c_log	正式議事録 official log	文	7	1				(制限)	(所有者)	(所有者)	(所有者)	×	0	100
議録2 Log2	@.proceeding.log2 c_log2	教員議事録 log for teachers	文	8	1				(職員)	(制限)	(制限)	(制限)	×	0	100
議録3 Log3	@.proceeding.log3 c_log3	公開議事録 log for public	文	9	1				(公開)	(制限)	(制限)	(制限)	×	0	100
報告 Reporting	@.reporting c_topic	報告リスト Reportings	文	10	*				(公開)	(職員)	(制限)	(制限)	×	0	100
報告録 ReportLog	@.reporting.log c_replog	正式報告事項録 official report log	文	11	1				(制限)	(所有者)	(所有者)	(所有者)	×	0	100
報告録2 ReportLog2	@.reporting.log2 c_replog2	教員報告事項録 report log for teachers	文	12	1				(職員)	(制限)	(制限)	(制限)	×	0	100
報告録3 ReportLog3	@.reporting.log3 c_replog3	公開報告事項録 repot log for public	文	13	1				(公開)	(制限)	(制限)	(制限)	×	0	100
備考 Note	@.note c_note	備考 Note	文	14	*				(公開)	(職員)	(制限)	(制限)	×	0	200

XML	column name	SQL definition	description
	Base Columns
meetinglog.organization	c_organization	mtext[]	EID
v_organization
e_organization	integer[]	list of EID in this column.
meetinglog.year	c_year	int4	YEAR
v_year
e_year	integer[]	list of EID in this column.
meetinglog.number	c_number	int4	INTEGER
v_number
e_number	integer[]	list of EID in this column.
meetinglog.date	c_date	int4	DATE
v_date
e_date	integer[]	list of EID in this column.
meetinglog.chairman	c_chairman	mtext	EID
v_chairman
e_chairman	integer[]	list of EID in this column.
meetinglog.attendance	c_attendance	mtext[]	EID
v_attendance
e_attendance	integer[]	list of EID in this column.
meetinglog.proceeding	c_agenda	mtext[]	SENTENCE
v_agenda
e_agenda	integer[]	list of EID in this column.
meetinglog.proceeding.log	c_log	mtext[]	SENTENCE
v_log
e_log	integer[]	list of EID in this column.
meetinglog.proceeding.log2	c_log2	mtext[]	SENTENCE
v_log2
e_log2	integer[]	list of EID in this column.
meetinglog.proceeding.log3	c_log3	mtext[]	SENTENCE
v_log3
e_log3	integer[]	list of EID in this column.
meetinglog.reporting	c_topic	mtext[]	SENTENCE
v_topic
e_topic	integer[]	list of EID in this column.
meetinglog.reporting.log	c_replog	mtext[]	SENTENCE
v_replog
e_replog	integer[]	list of EID in this column.
meetinglog.reporting.log2	c_replog2	mtext[]	SENTENCE
v_replog2
e_replog2	integer[]	list of EID in this column.
meetinglog.reporting.log3	c_replog3	mtext[]	SENTENCE
v_replog3
e_replog3	integer[]	list of EID in this column.
meetinglog.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
meetinglog.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
meetinglog.year	r_idx0	integer	subscript in primary tuple.
c_year	int4	YEAR
v_year
e_year	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
meetinglog.number	r_idx0	integer	subscript in primary tuple.
c_number	int4	INTEGER
v_number
e_number	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
meetinglog.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
meetinglog.chairman	r_idx0	integer	subscript in primary tuple.
c_chairman	mtext	EID
v_chairman
e_chairman	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
meetinglog.attendance	r_idx0	integer	subscript in primary tuple.
c_attendance	mtext	EID
v_attendance
e_attendance	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
meetinglog.proceeding	r_idx0	integer	subscript in primary tuple.
c_agenda	mtext	SENTENCE
v_agenda
e_agenda	integer[]	list of EID in this column.
meetinglog.proceeding.log	c_log	mtext	SENTENCE
v_log
e_log	integer[]	list of EID in this column.
meetinglog.proceeding.log2	c_log2	mtext	SENTENCE
v_log2
e_log2	integer[]	list of EID in this column.
meetinglog.proceeding.log3	c_log3	mtext	SENTENCE
v_log3
e_log3	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
meetinglog.proceeding	r_idx0	integer	subscript in primary tuple.
c_agenda	mtext	SENTENCE
v_agenda
e_agenda	integer[]	list of EID in this column.
meetinglog.proceeding.log	r_idx1	integer	subscript in super column.
c_log	mtext	SENTENCE
v_log
e_log	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
meetinglog.proceeding	r_idx0	integer	subscript in primary tuple.
c_agenda	mtext	SENTENCE
v_agenda
e_agenda	integer[]	list of EID in this column.
meetinglog.proceeding.log2	r_idx1	integer	subscript in super column.
c_log2	mtext	SENTENCE
v_log2
e_log2	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
meetinglog.proceeding	r_idx0	integer	subscript in primary tuple.
c_agenda	mtext	SENTENCE
v_agenda
e_agenda	integer[]	list of EID in this column.
meetinglog.proceeding.log3	r_idx1	integer	subscript in super column.
c_log3	mtext	SENTENCE
v_log3
e_log3	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
meetinglog.reporting	r_idx0	integer	subscript in primary tuple.
c_topic	mtext	SENTENCE
v_topic
e_topic	integer[]	list of EID in this column.
meetinglog.reporting.log	c_replog	mtext	SENTENCE
v_replog
e_replog	integer[]	list of EID in this column.
meetinglog.reporting.log2	c_replog2	mtext	SENTENCE
v_replog2
e_replog2	integer[]	list of EID in this column.
meetinglog.reporting.log3	c_replog3	mtext	SENTENCE
v_replog3
e_replog3	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
meetinglog.reporting	r_idx0	integer	subscript in primary tuple.
c_topic	mtext	SENTENCE
v_topic
e_topic	integer[]	list of EID in this column.
meetinglog.reporting.log	r_idx1	integer	subscript in super column.
c_replog	mtext	SENTENCE
v_replog
e_replog	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
meetinglog.reporting	r_idx0	integer	subscript in primary tuple.
c_topic	mtext	SENTENCE
v_topic
e_topic	integer[]	list of EID in this column.
meetinglog.reporting.log2	r_idx1	integer	subscript in super column.
c_replog2	mtext	SENTENCE
v_replog2
e_replog2	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
meetinglog.reporting	r_idx0	integer	subscript in primary tuple.
c_topic	mtext	SENTENCE
v_topic
e_topic	integer[]	list of EID in this column.
meetinglog.reporting.log3	r_idx1	integer	subscript in super column.
c_replog3	mtext	SENTENCE
v_replog3
e_replog3	integer[]	list of EID in this column.

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