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

Table Definition : "Building"

Definition of Building.

XML: building (XML, DTD)

SQL: t_83883

名前: （英）Building （日）建物（読）たてもの

説明: （英）list of building （日）本学が保有する建物のリスト

解説: （英）（日）

マップ:

属性:

タプル権限(既定値): 読権: 公開, 作権: ユーザ, 書権: 制限, 削権: 制限.

カラム権限(既定値): 読権: 公開, 作権: 制限, 書権: 制限, 削権: 制限.

登録されているカラム

名前 XML
SQL 説明型番数 MAP 権限
委譲分類同義期間
限定用法該当
無可読権作権書権削権見順巾

組織
Organization @.organization
c_organization 建物を保有する組織
owner organization 参照 0 1 組織
(公開) (ユーザ) (制限) (制限) × 0 40

所在地
Location @.location
c_location 建物の所在地
location of building 参照 1 1 土地
(公開) (ユーザ) (制限) (制限) × 1 40

名称
Name @.name
c_name 建物の呼称
name 名称 2 2 ○ (公開) (ユーザ) (制限) (制限) 短 1 40

構造
Structure @.structure
c_structure 建物の構造
structure of building 参照 3 1 建物構造
(公開) (ユーザ) (制限) (制限) 短 0 100

所有形態
Ownership @.ownership
c_ownership 建物の所有形態
kind of ownership 参照 4 1 所有形態
(公開) (ユーザ) (制限) (制限) × 0 40

用途
Use @.use
c_use 建物の用途
kind of use 参照 5 * 建物用途
(公開) (ユーザ) (制限) (制限) × 0 20

面積
Area @.area
c_area 建物の建築面積
area of building 実数 6 1 (公開) (ユーザ) (制限) (制限) × 0 20

床面積
AreaFloor @.area2
c_area2 建物の延床面積
area of building 実数 7 1 (公開) (ユーザ) (制限) (制限) × 0 20

新築年月日
ConstructedDate @.date
c_date 新築された年月日
date of constructed 日付 8 1 (公開) (ユーザ) (制限) (制限) × 0 20

改築年月日
ReconstructedDate @.date2
c_date2 改築された年月日
date of reconstructed 日付 9 * (公開) (ユーザ) (制限) (制限) × 0 20

利用期間
Period @.period
c_period 建物の利用期間
period of use 期間 10 1 (公開) (ユーザ) (制限) (制限) × 0 20

備考
Note @.note
c_note 備考
Note 文 11 * (公開) (ユーザ) (制限) (制限) × 0 200

カラムの解説文:

組織: (英) Please choose the organization. (日) 建物を保有する組織を選択してください．

所在地: (英) Please choose the location of building. (日) 建物の所在地を選択してください．

名称: (英) Please write the kind of building. (日) 建物の呼称を記入してください．

構造: (英) Please choose the structure of building. (日) 建物の構造を選択してください．

所有形態: (英) Please choose the kind of ownership. (日) 建物の所有形態を選択してください．

用途: (英) Please choose the uses. (日) 建物の用途を選択してください．

面積: (英) Please write the area of building. (日) 建物の建築面積を平方メートルで記述してください．

床面積: (英) Please write the area of building. (日) 建物の延床面積を平方メートルで記述してください．

新築年月日: (英) Please write the date of constructed. (日) 建物が新築された年月日を記述してください．

改築年月日: (英) Please write the date of reconstructed. (日) 建物が改築された年月日を記述してください．

利用期間: (英) Please write the period of use. (日) 建物の利用期間を記述してください．

備考: (英) Please write the information which cannot be written on registered column. (日) 登録されているカラムに記述すべき内容以外に，特に記しておきたい事柄があれば記述してください．

参照しているカラム:

Relational tables associated with Building.

Primary table: "t_83883"

Columns:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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:

XML column name SQL definition description

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.

名前	XML SQL	説明	型	番	数	MAP	同義	読権	作権	書権	削権	見	順	巾
組織 Organization	@.organization c_organization	建物を保有する組織 owner organization	参照	0	1	組織		(公開)	(ユーザ)	(制限)	(制限)	×	0	40
所在地 Location	@.location c_location	建物の所在地 location of building	参照	1	1	土地		(公開)	(ユーザ)	(制限)	(制限)	×	1	40
名称 Name	@.name c_name	建物の呼称 name	名称	2	2		○	(公開)	(ユーザ)	(制限)	(制限)	短	1	40
構造 Structure	@.structure c_structure	建物の構造 structure of building	参照	3	1	建物構造		(公開)	(ユーザ)	(制限)	(制限)	短	0	100
所有形態 Ownership	@.ownership c_ownership	建物の所有形態 kind of ownership	参照	4	1	所有形態		(公開)	(ユーザ)	(制限)	(制限)	×	0	40
用途 Use	@.use c_use	建物の用途 kind of use	参照	5	*	建物用途		(公開)	(ユーザ)	(制限)	(制限)	×	0	20
面積 Area	@.area c_area	建物の建築面積 area of building	実数	6	1			(公開)	(ユーザ)	(制限)	(制限)	×	0	20
床面積 AreaFloor	@.area2 c_area2	建物の延床面積 area of building	実数	7	1			(公開)	(ユーザ)	(制限)	(制限)	×	0	20
新築年月日 ConstructedDate	@.date c_date	新築された年月日 date of constructed	日付	8	1			(公開)	(ユーザ)	(制限)	(制限)	×	0	20
改築年月日 ReconstructedDate	@.date2 c_date2	改築された年月日 date of reconstructed	日付	9	*			(公開)	(ユーザ)	(制限)	(制限)	×	0	20
利用期間 Period	@.period c_period	建物の利用期間 period of use	期間	10	1			(公開)	(ユーザ)	(制限)	(制限)	×	0	20
備考 Note	@.note c_note	備考 Note	文	11	*			(公開)	(ユーザ)	(制限)	(制限)	×	0	200

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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.

XML	column name	SQL definition	description
	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 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=1373)