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


Table Definition : "Report"


Definition of Report.


Relational tables associated with Report.

Primary table: "t_147938"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 report.reporter c_reporter mtext[] NAME
 v_reporter
 e_reporter integer[] list of EID in this column.
 report.media c_media mtext NAME
 v_media
 e_media integer[] list of EID in this column.
 report.organization c_organization mtext[] EID
 v_organization
 e_organization integer[] list of EID in this column.
 report.subject c_subject mtext[] EID
 v_subject
 e_subject integer[] list of EID in this column.
 report.category c_category mtext EID
 v_category
 e_category integer[] list of EID in this column.
 report.title c_title mtext SENTENCE
 v_title
 e_title integer[] list of EID in this column.
 report.summary c_summary mtext PARAGRAPH
 v_summary
 e_summary integer[] list of EID in this column.
 report.date c_date int4 DATE
 v_date
 e_date integer[] list of EID in this column.
 report.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_147938_reporter"     --- associated with report.reporter
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 report.reporter r_idx0 integer subscript in primary tuple.
 c_reporter mtext[] NAME
 v_reporter
 e_reporter integer[] list of EID in this column.

"t_147938_media"     --- associated with report.media
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 report.media r_idx0 integer subscript in primary tuple.
 c_media mtext NAME
 v_media
 e_media integer[] list of EID in this column.

"t_147938_organization"     --- associated with report.organization
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 report.organization r_idx0 integer subscript in primary tuple.
 c_organization mtext[] EID
 v_organization
 e_organization integer[] list of EID in this column.

"t_147938_subject"     --- associated with report.subject
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 report.subject r_idx0 integer subscript in primary tuple.
 c_subject mtext[] EID
 v_subject
 e_subject integer[] list of EID in this column.

"t_147938_category"     --- associated with report.category
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 report.category r_idx0 integer subscript in primary tuple.
 c_category mtext EID
 v_category
 e_category integer[] list of EID in this column.

"t_147938_title"     --- associated with report.title
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 report.title r_idx0 integer subscript in primary tuple.
 c_title mtext SENTENCE
 v_title
 e_title integer[] list of EID in this column.

"t_147938_summary"     --- associated with report.summary
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 report.summary r_idx0 integer subscript in primary tuple.
 c_summary mtext PARAGRAPH
 v_summary
 e_summary integer[] list of EID in this column.

"t_147938_date"     --- associated with report.date
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 report.date r_idx0 integer subscript in primary tuple.
 c_date int4 DATE
 v_date
 e_date integer[] list of EID in this column.

"t_147938_note"     --- associated with report.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 report.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 Thu Mar 28 03:40:05 2024. (p-db5.edb-private:5433:edb_latest v.15.6, o=8/8, c=2, q=107, h=1546)