3DCityDB v4 - Database Schema - Core
Generated using DbSchema
HTML Mode
Click Here to View same Document in Interactive HTML Mode
Core Layout
Tables
- citydb.address 2. citydb.citymodel 3. citydb.cityobject 4. citydb.cityobject_member 5. citydb.external_reference 6. citydb.generalization
Table address
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬋ | id | bigint DEFAULT nextval('address_seq'::regclass) |
| 🔎 | gmlid | varchar(256) |
| 🔎 | gmlid_codespace | varchar(1000) |
| street | varchar(1000) | |
| house_number | varchar(256) | |
| po_box | varchar(256) | |
| zip_code | varchar(256) | |
| city | varchar(256) | |
| state | varchar(256) | |
| country | varchar(256) | |
| 🔎 | multi_point | geometry |
| xal_source | text | |
| Indexes | ||
| 🔑 | address_pk | |
| 🔎 | address_inx | |
| 🔎 | address_point_spx |
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 external_reference
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 | id | bigint DEFAULT nextval('external_ref_seq'::regclass) |
| infosys | varchar(4000) | |
| name | varchar(4000) | |
| uri | varchar(4000) | |
| 🔎 ⬈ | cityobject_id | bigint |
| Indexes | ||
| 🔑 | external_reference_pk | |
| 🔎 | ext_ref_cityobject_fkx | |
| Foreign Keys | ||
| ext_ref_cityobject_fk | ( cityobject_id ) ref citydb.cityobject (id) |
Table generalization
| Idx | Field Name | Data Type |
|---|---|---|
| *🔑 ⬈ | cityobject_id | bigint |
| *🔑 ⬈ | generalizes_to_id | bigint |
| Indexes | ||
| 🔑 | generalization_pk | |
| 🔎 | general_cityobject_fkx | |
| 🔎 | general_generalizes_to_fkx | |
| Foreign Keys | ||
| general_cityobject_fk | ( cityobject_id ) ref citydb.cityobject (id) | |
| general_generalizes_to_fk | ( generalizes_to_id ) ref citydb.cityobject (id) |