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


Table Definition : "SDG(UN2015)"


Definition of SDG(UN2015).


Relational tables associated with SDG(UN2015).

Primary table: "t_366020"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 un2015sdg.goal c_goal mtext NAME
 v_goal
 e_goal integer[] list of EID in this column.
 un2015sdg.detail c_detail mtext SENTENCE
 v_detail
 e_detail integer[] list of EID in this column.
 un2015sdg.number c_number int4 INTEGER
 v_number
 e_number integer[] list of EID in this column.
 un2015sdg.logo c_logo text PICTURE
 v_logo
 e_logo integer[] list of EID in this column.
 un2015sdg.url c_url text URL
 v_url
 e_url integer[] list of EID in this column.
 un2015sdg.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_366020_goal"     --- associated with un2015sdg.goal
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 un2015sdg.goal r_idx0 integer subscript in primary tuple.
 c_goal mtext NAME
 v_goal
 e_goal integer[] list of EID in this column.

"t_366020_detail"     --- associated with un2015sdg.detail
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 un2015sdg.detail r_idx0 integer subscript in primary tuple.
 c_detail mtext SENTENCE
 v_detail
 e_detail integer[] list of EID in this column.

"t_366020_number"     --- associated with un2015sdg.number
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 un2015sdg.number r_idx0 integer subscript in primary tuple.
 c_number int4 INTEGER
 v_number
 e_number integer[] list of EID in this column.

"t_366020_logo"     --- associated with un2015sdg.logo
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 un2015sdg.logo r_idx0 integer subscript in primary tuple.
 c_logo text PICTURE
 v_logo
 e_logo integer[] list of EID in this column.

"t_366020_url"     --- associated with un2015sdg.url
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 un2015sdg.url r_idx0 integer subscript in primary tuple.
 c_url text URL
 v_url
 e_url integer[] list of EID in this column.

"t_366020_note"     --- associated with un2015sdg.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 un2015sdg.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 Nov 28 03:40:01 2024. (p-db6.edb-private:5433:edb_latest v.15.10, o=6/6, c=2, q=107, h=915)