street

3,563 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: schaalundmueller_district_id, created (date), modified (date)

Next page

CREATE TABLE "street" (
   [id] INTEGER PRIMARY KEY,
   [created] TEXT,
   [modified] TEXT,
   [name] TEXT,
   [url_onlinestreet] TEXT,
   [city] TEXT,
   [district_id] INTEGER,
   [zipcode_id] INTEGER,
   [schaalundmueller_district_id] INTEGER,
   FOREIGN KEY(district_id) REFERENCES "district"(id),
   FOREIGN KEY(zipcode_id) REFERENCES "zipcode"(id)
);
CREATE INDEX [idx_main_street_zipcode_id]
                ON "street" ([zipcode_id]);
CREATE INDEX [idx_main_street_district_id]
                ON "street" ([district_id]);