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


Table Definition : "Conference"


Definition of Conference.


Relational tables associated with Conference.

Primary table: "t_10003"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.category c_category mtext EID
 v_category
 e_category integer[] list of EID in this column.
 conference.society c_society mtext[] NAME
 v_society
 e_society integer[] list of EID in this column.
 conference.name c_name mtext NAME
 v_name
 e_name integer[] list of EID in this column.
 conference.class1 c_class1 mtext EID
 v_class1
 e_class1 integer[] list of EID in this column.
 conference.class2 c_class2 mtext EID
 v_class2
 e_class2 integer[] list of EID in this column.
 conference.class3 c_class3 mtext EID
 v_class3
 e_class3 integer[] list of EID in this column.
 conference.organization c_organization mtext[] EID
 v_organization
 e_organization integer[] list of EID in this column.
 conference.promoter c_promoter mtext[] NAME
 v_promoter
 e_promoter integer[] list of EID in this column.
 conference.promoter.role c_promoter_role mtext[] NAME
 v_promoter_role
 e_promoter_role integer[] list of EID in this column.
 conference.participants c_participants int4 INTEGER
 v_participants
 e_participants integer[] list of EID in this column.
 conference.period c_period int8 DATE2
 v_period
 e_period integer[] list of EID in this column.
 conference.location c_location mtext NAME
 v_location
 e_location integer[] list of EID in this column.
 conference.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_10003_category"     --- associated with conference.category
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.category r_idx0 integer subscript in primary tuple.
 c_category mtext EID
 v_category
 e_category integer[] list of EID in this column.

"t_10003_society"     --- associated with conference.society
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.society r_idx0 integer subscript in primary tuple.
 c_society mtext[] NAME
 v_society
 e_society integer[] list of EID in this column.

"t_10003_name"     --- associated with conference.name
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.name r_idx0 integer subscript in primary tuple.
 c_name mtext NAME
 v_name
 e_name integer[] list of EID in this column.

"t_10003_class1"     --- associated with conference.class1
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.class1 r_idx0 integer subscript in primary tuple.
 c_class1 mtext EID
 v_class1
 e_class1 integer[] list of EID in this column.

"t_10003_class2"     --- associated with conference.class2
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.class2 r_idx0 integer subscript in primary tuple.
 c_class2 mtext EID
 v_class2
 e_class2 integer[] list of EID in this column.

"t_10003_class3"     --- associated with conference.class3
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.class3 r_idx0 integer subscript in primary tuple.
 c_class3 mtext EID
 v_class3
 e_class3 integer[] list of EID in this column.

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

"t_10003_promoter"     --- associated with conference.promoter
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.promoter r_idx0 integer subscript in primary tuple.
 c_promoter mtext NAME
 v_promoter
 e_promoter integer[] list of EID in this column.
 conference.promoter.role c_promoter_role mtext NAME
 v_promoter_role
 e_promoter_role integer[] list of EID in this column.

"t_10003_promoter_role"     --- associated with conference.promoter.role
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.promoter r_idx0 integer subscript in primary tuple.
 c_promoter mtext NAME
 v_promoter
 e_promoter integer[] list of EID in this column.
 conference.promoter.role r_idx1 integer subscript in super column.
 c_promoter_role mtext NAME
 v_promoter_role
 e_promoter_role integer[] list of EID in this column.

"t_10003_participants"     --- associated with conference.participants
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.participants r_idx0 integer subscript in primary tuple.
 c_participants int4 INTEGER
 v_participants
 e_participants integer[] list of EID in this column.

"t_10003_period"     --- associated with conference.period
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.period r_idx0 integer subscript in primary tuple.
 c_period int8 DATE2
 v_period
 e_period integer[] list of EID in this column.

"t_10003_location"     --- associated with conference.location
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.location r_idx0 integer subscript in primary tuple.
 c_location mtext NAME
 v_location
 e_location integer[] list of EID in this column.

"t_10003_note"     --- associated with conference.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 conference.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=1217)