Plz

Beschreibung

Beinhaltet die möglichen PLZs im DACH Raum.

altes plz-Model

old migration

CREATE TABLE `pyou_plz_austria` (
  `postalcode` int(11) NOT NULL,
  `locality` varchar(40) NOT NULL,
  `state` varchar(2) NOT NULL,
  `nameplztype` varchar(16) NOT NULL,
  `intern_extern` varchar(6) NOT NULL,
  `adressierbar` varchar(4) NOT NULL,
  `box` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `pyou_plz_german` (
  `state` varchar(22) NOT NULL,
  `postalcode` int(11) NOT NULL,
  `locality` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `pyou_plz_luxembourg` (
  `postalcode` int(11) NOT NULL,
  `place` varchar(40) NOT NULL,
  `lat` varchar(10) NOT NULL,
  `long` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `pyou_plz_swiss` (
  `postalcode` int(11) NOT NULL,
  `location` varchar(27) NOT NULL,
  `kanton` varchar(24) NOT NULL,
  `canton` varchar(28) NOT NULL,
  `cantone` varchar(28) NOT NULL,
  `shortcut` varchar(2) NOT NULL,
  `country` varchar(13) NOT NULL,
  `pays` varchar(13) NOT NULL,
  `Paese` varchar(13) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

neues Plz-Model

Anmerkung

• Functionality
• Implementierung: ✅
• Reduzierung der Spalten
• merge in eine Tabelle

Model (json)

{
    "class": "App\\Models\\Plz",
    "database": "mysql",
    "table": "plzs",
    "policy": null,
    "attributes": [
    {
    "name": "id",
    "type": "bigint unsigned",
    "increments": true,
    "nullable": false,
    "default": null,
    "unique": true,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": "int"
    },
    {
    "name": "postal_code",
    "type": "integer",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "locality",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "country_code",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    }
    ],
    "relations": [],
    "observers": []
}

übergeordnetes Thema

2.6 Datenstruktur