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


Table Definition : "History"


Definition of History.


Relational tables associated with History.

Primary table: "t_10006"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 history.subject c_subject mtext[] EID
 v_subject
 e_subject integer[] list of EID in this column.
 history.date c_date int4 DATE
 v_date
 e_date integer[] list of EID in this column.
 history.attribute c_attribute mtext EID
 v_attribute
 e_attribute integer[] list of EID in this column.
 history.event c_event mtext SENTENCE
 v_event
 e_event integer[] list of EID in this column.
 history.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_10006_subject"     --- associated with history.subject
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 history.subject r_idx0 integer subscript in primary tuple.
 c_subject mtext[] EID
 v_subject
 e_subject integer[] list of EID in this column.

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

"t_10006_attribute"     --- associated with history.attribute
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 history.attribute r_idx0 integer subscript in primary tuple.
 c_attribute mtext EID
 v_attribute
 e_attribute integer[] list of EID in this column.

"t_10006_event"     --- associated with history.event
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 history.event r_idx0 integer subscript in primary tuple.
 c_event mtext SENTENCE
 v_event
 e_event integer[] list of EID in this column.

"t_10006_note"     --- associated with history.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 history.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 Mar 29 03:40:05 2024. (p-db7.edb-private:5433:edb_latest v.15.6, o=8/8, c=2, q=107, h=1589)