3DCityDB v4 - Database Schema - Appearance

Generated using DbSchema

HTML Mode

Click Here to View same Document in Interactive HTML Mode

Appearance Layout

Tables

1. citydb.appear_to_surface_data 2. citydb.appearance 3. citydb.citymodel 4. citydb.cityobject 5. citydb.cityobject_member 6. citydb.objectclass 7. citydb.surface_data 8. citydb.surface_geometry 9. citydb.tex_image 10. citydb.textureparam

Table appear_to_surface_data

Idx	Field Name	Data Type
*🔑 ⬈	surface_data_id	bigint
*🔑 ⬈	appearance_id	bigint
Indexes
🔑	appear_to_surface_data_pk
🔎	app_to_surf_data_fkx
🔎	app_to_surf_data_fkx1
Foreign Keys
	app_to_surf_data_fk1	( appearance_id ) ref citydb.appearance (id)
	app_to_surf_data_fk	( surface_data_id ) ref citydb.surface_data (id)

Table appearance

Idx	Field Name	Data Type
*🔑 ⬋	id	bigint DEFAULT nextval('appearance_seq'::regclass)
🔎	gmlid	varchar(256)
🔎	gmlid_codespace	varchar(1000)
🔎	theme	varchar(256)
🔎 ⬈	citymodel_id	bigint
🔎 ⬈	cityobject_id	bigint
Indexes
🔑	appearance_pk
🔎	appearance_inx
🔎	appearance_theme_inx
🔎	appearance_citymodel_fkx
🔎	appearance_cityobject_fkx
Foreign Keys
	appearance_citymodel_fk	( citymodel_id ) ref citydb.citymodel (id)
	appearance_cityobject_fk	( cityobject_id ) ref citydb.cityobject (id)

Table citymodel

Idx	Field Name	Data Type
*🔑 ⬋	id	bigint DEFAULT nextval('citymodel_seq'::regclass)
🔎	gmlid	varchar(256)
🔎	gmlid_codespace	varchar(1000)
	name	varchar(1000)
	name_codespace	varchar(4000)
	description	varchar(4000)
🔎	envelope	geometry
	creation_date	timestamptz
	termination_date	timestamptz
	last_modification_date	timestamptz
	updating_person	varchar(256)
	reason_for_update	varchar(4000)
	lineage	varchar(256)
Indexes
🔑	citymodel_pk
🔎	citymodel_inx
🔎	citymodel_envelope_spx

Table cityobject

Idx	Field Name	Data Type
*🔑 ⬋	id	bigint DEFAULT nextval('cityobject_seq'::regclass)
*🔎	objectclass_id	integer
🔎	gmlid	varchar(256)
🔎	gmlid_codespace	varchar(1000)
	name	varchar(1000)
	name_codespace	varchar(4000)
	description	varchar(4000)
🔎	envelope	geometry
🔎	creation_date	timestamptz
🔎	termination_date	timestamptz
	relative_to_terrain	varchar(256)
	relative_to_water	varchar(256)
🔎	last_modification_date	timestamptz
	updating_person	varchar(256)
	reason_for_update	varchar(4000)
🔎	lineage	varchar(256)
	xml_source	text
Indexes
🔑	cityobject_pk
🔎	cityobject_inx
🔎	cityobject_objectclass_fkx
🔎	cityobject_lineage_inx
🔎	cityobj_creation_date_inx
🔎	cityobj_term_date_inx
🔎	cityobj_last_mod_date_inx
🔎	cityobject_envelope_spx

Table cityobject_member

Idx	Field Name	Data Type
*🔑 ⬈	citymodel_id	bigint
*🔑 ⬈	cityobject_id	bigint
Indexes
🔑	cityobject_member_pk
🔎	cityobject_member_fkx
🔎	cityobject_member_fkx1
Foreign Keys
	cityobject_member_fk1	( citymodel_id ) ref citydb.citymodel (id)
	cityobject_member_fk	( cityobject_id ) ref citydb.cityobject (id)

Table objectclass

Idx	Field Name	Data Type
*🔑 ⬋	id	integer
⬈	superclass_id	integer
⬈	baseclass_id	integer
*	class_name	varchar
	package	varchar
	is_top_level	numeric
	ade_id	integer
Indexes
🔑	t_objectclass_pkey
Foreign Keys
	fk_t_objectclass_baseclass_id	( baseclass_id ) ref citydb.objectclass (id)
	fk_t_objectclass_superclass_id	( superclass_id ) ref citydb.objectclass (id)

Table surface_data

Idx	Field Name	Data Type
*🔑 ⬋	id	bigint DEFAULT nextval('surface_data_seq'::regclass)
🔎	gmlid	varchar(256)
🔎	gmlid_codespace	varchar(1000)
	is_front	numeric
*🔎	objectclass_id	integer
	x3d_shininess	double precision
	x3d_transparency	double precision
	x3d_ambient_intensity	double precision
	x3d_specular_color	varchar(256)
	x3d_diffuse_color	varchar(256)
	x3d_emissive_color	varchar(256)
	x3d_is_smooth	numeric
🔎 ⬈	tex_image_id	bigint
	tex_texture_type	varchar(256)
	tex_wrap_mode	varchar(256)
	tex_border_color	varchar(256)
	gt_prefer_worldfile	numeric
	gt_orientation	varchar(256)
🔎	gt_reference_point	geometry
Indexes
🔑	surface_data_pk
🔎	surface_data_inx
🔎	surface_data_tex_image_fkx
🔎	surface_data_objclass_fkx
🔎	surface_data_spx
Foreign Keys
	surface_data_tex_image_fk	( tex_image_id ) ref citydb.tex_image (id)

Table surface_geometry

Idx	Field Name	Data Type
*🔑 ⬋	id	bigint DEFAULT nextval('surface_geometry_seq'::regclass)
🔎	gmlid	varchar(256)
🔎	gmlid_codespace	varchar(1000)
🔎 ⬈	parent_id	bigint
🔎 ⬈	root_id	bigint
	is_solid	numeric
	is_composite	numeric
	is_triangulated	numeric
	is_xlink	numeric
	is_reverse	numeric
🔎	solid_geometry	geometry
🔎	geometry	geometry
	implicit_geometry	geometry
🔎 ⬈	cityobject_id	bigint
Indexes
🔑	surface_geometry_pk
🔎	surface_geom_inx
🔎	surface_geom_parent_fkx
🔎	surface_geom_root_fkx
🔎	surface_geom_cityobj_fkx
🔎	surface_geom_solid_spx
🔎	surface_geom_spx
Foreign Keys
	surface_geom_cityobj_fk	( cityobject_id ) ref citydb.cityobject (id)
	surface_geom_parent_fk	( parent_id ) ref citydb.surface_geometry (id)
	surface_geom_root_fk	( root_id ) ref citydb.surface_geometry (id)

Table tex_image

Idx	Field Name	Data Type
*🔑 ⬋	id	bigint DEFAULT nextval('tex_image_seq'::regclass)
	tex_image_uri	varchar(4000)
	tex_image_data	bytea
	tex_mime_type	varchar(256)
	tex_mime_type_codespace	varchar(4000)
Indexes
🔑	tex_image_pk

Table textureparam

Idx	Field Name	Data Type
*🔑 ⬈	surface_geometry_id	bigint
	is_texture_parametrization	numeric
	world_to_texture	varchar(1000)
	texture_coordinates	geometry
*🔑 ⬈	surface_data_id	bigint
Indexes
🔑	textureparam_pk
🔎	texparam_geom_fkx
🔎	texparam_surface_data_fkx
Foreign Keys
	texparam_surface_data_fk	( surface_data_id ) ref citydb.surface_data (id)
	texparam_geom_fk	( surface_geometry_id ) ref citydb.surface_geometry (id)