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


Table Definition : "Building"


Definition of Building.


Relational tables associated with Building.

Primary table: "t_83883"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 building.organization c_organization mtext[] EID
 v_organization
 e_organization integer[] list of EID in this column.
 building.location c_location mtext EID
 v_location
 e_location integer[] list of EID in this column.
 building.name c_name mtext[] NAME
 v_name
 e_name integer[] list of EID in this column.
 building.structure c_structure mtext EID
 v_structure
 e_structure integer[] list of EID in this column.
 building.ownership c_ownership mtext EID
 v_ownership
 e_ownership integer[] list of EID in this column.
 building.use c_use mtext[] EID
 v_use
 e_use integer[] list of EID in this column.
 building.area c_area float8 REAL
 v_area
 e_area integer[] list of EID in this column.
 building.area2 c_area2 float8 REAL
 v_area2
 e_area2 integer[] list of EID in this column.
 building.date c_date int4 DATE
 v_date
 e_date integer[] list of EID in this column.
 building.date2 c_date2 int4[] DATE
 v_date2
 e_date2 integer[] list of EID in this column.
 building.period c_period int8 DATE2
 v_period
 e_period integer[] list of EID in this column.
 building.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_83883_organization"     --- associated with building.organization
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 building.organization r_idx0 integer subscript in primary tuple.
 c_organization mtext[] EID
 v_organization
 e_organization integer[] list of EID in this column.

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

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

"t_83883_structure"     --- associated with building.structure
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 building.structure r_idx0 integer subscript in primary tuple.
 c_structure mtext EID
 v_structure
 e_structure integer[] list of EID in this column.

"t_83883_ownership"     --- associated with building.ownership
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 building.ownership r_idx0 integer subscript in primary tuple.
 c_ownership mtext EID
 v_ownership
 e_ownership integer[] list of EID in this column.

"t_83883_use"     --- associated with building.use
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 building.use r_idx0 integer subscript in primary tuple.
 c_use mtext EID
 v_use
 e_use integer[] list of EID in this column.

"t_83883_area"     --- associated with building.area
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 building.area r_idx0 integer subscript in primary tuple.
 c_area float8 REAL
 v_area
 e_area integer[] list of EID in this column.

"t_83883_area2"     --- associated with building.area2
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 building.area2 r_idx0 integer subscript in primary tuple.
 c_area2 float8 REAL
 v_area2
 e_area2 integer[] list of EID in this column.

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

"t_83883_date2"     --- associated with building.date2
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 building.date2 r_idx0 integer subscript in primary tuple.
 c_date2 int4 DATE
 v_date2
 e_date2 integer[] list of EID in this column.

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

"t_83883_note"     --- associated with building.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 building.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=1373)