{"id":140,"date":"2017-03-23T00:15:06","date_gmt":"2017-03-22T23:15:06","guid":{"rendered":"http:\/\/uc-mobileapps.com\/de\/?page_id=140"},"modified":"2021-01-30T14:09:22","modified_gmt":"2021-01-30T13:09:22","slug":"annotation-sql-typ-fremdschluessel-pflichtfeld","status":"publish","type":"page","link":"http:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/","title":{"rendered":"SQL Optionen in den Metadaten"},"content":{"rendered":"<p><code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">isPrimaryKey : boolean<\/code><\/p>\n<p>definiert, ob das Feld der Prim\u00e4rschl\u00fcssel oder Teil des Prim\u00e4rschl\u00fcssels sein soll.<\/p>\n<p><code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">mandatory : boolean<\/code><\/p>\n<p>Mit diesem Attribut wird definiert ob die Nicht-Null Bedingung auf der Tabellenspalte gelten soll. Zus\u00e4tzlich wir eine Methode zum \u00dcberpr\u00fcfen der Pflichtfelder im Schema-Peer erstellt. Mandatory kann zusammen mit dem version Attribut verwendet werden, es erzeugt dann das erwartete <code class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">alter table ... not null<\/code> SQL statement in der Update-Logik.<\/p>\n<p><code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">foreignKey<\/code><\/p>\n<p>Siehe dazu den separaten <a href=\"http:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/fremdschluessel\/\">Abschnitt \u00fcber Fremdschl\u00fcssel<\/a><\/p>\n<p><strong>SQL spezifische Optionen<\/strong><br \/>\n<code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">sqlOptions=@SqlFieldOptions( \/* .. *\/ )<\/code>&nbsp;gruppieren nur SQL relevante Optionen;<\/p>\n<ul>\n<li><code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">sqlColumn : String<br \/>\n<\/code>den Namen der Tabellenspalte abweichend zum Namen des Java-Attributs w\u00e4hlen<\/li>\n<li><code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">sqlAutoIncrement : boolean<\/code><br \/>\nlegt fest ob der default Wert automatisch erh\u00f6ht werden soll<\/li>\n<li><code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">sqlDefault : String<\/code><br \/>\nden Standardwert der beim Erzeugen eines Datensatzes ohne expliziten Wert eingef\u00fcgt werden soll<\/li>\n<li><code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">sqlType : String<br \/>\n<\/code>\u00fcberschreiben des Standard SQL Datentyps der aus dem Java-Typen ermittelt wird<\/li>\n<li><code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">sqlIndex : String[]<br \/>\n<\/code> n\u00fctzlich bei nicht-Prim\u00e4rschl\u00fcsseln zur Erzeugung eines Tabellen-Indexes. Es k\u00f6nnen mehrere Felder den gleichen Index-Namen referenzieren, f\u00fcr diese wird dann ein gemeinsamer Index erstellt. Ein Feld kann auch zu mehreren Indeces geh\u00f6ren, dann werden mehrere Namen in das Array geschrieben.<\/li>\n<li><code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">sqlUniqueGroup : String[]<br \/>\n<\/code>analog zum Index wird hiermit der Unique-Constraint f\u00fcr ein Feld oder \u00fcber eine Kombination mehrerer Felder definiert. Ein Feld kann ebenfalls zu mehreren &#8220;unique-groups&#8221; geh\u00f6ren.<\/li>\n<\/ul>\n<p><code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">dataName : String <\/code><br \/>\n<code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">description : String <\/code><br \/>\n<code class=\"EnlighterJSRAW\" data-enlighter-language=\"java\">dataOptions : String[] <\/code><br \/>\ndiese Felder k\u00f6nnen f\u00fcr Erweiterungen genutzt werden und werden gegenw\u00e4rtig jedoch nicht ausgewertet.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>isPrimaryKey : boolean definiert, ob das Feld der Prim\u00e4rschl\u00fcssel oder Teil des Prim\u00e4rschl\u00fcssels sein soll. mandatory : boolean Mit diesem Attribut wird definiert ob die Nicht-Null Bedingung auf der Tabellenspalte gelten soll. Zus\u00e4tzlich wir eine Methode zum \u00dcberpr\u00fcfen der Pflichtfelder im Schema-Peer erstellt. Mandatory kann zusammen mit dem version Attribut verwendet werden, es erzeugt dann &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"http:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/\"> <span class=\"screen-reader-text\">SQL Optionen in den Metadaten<\/span> Weiterlesen &raquo;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":62,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.5.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Optionen in den Metadaten - UC Mobile Apps<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/\" \/>\n<meta name=\"twitter:label1\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"http:\/\/uc-mobileapps.com\/de\/#organization\",\"name\":\"UC Mobile Apps\",\"url\":\"http:\/\/uc-mobileapps.com\/de\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/uc-mobileapps.com\/de\/#logo\",\"inLanguage\":\"de-DE\",\"url\":\"http:\/\/uc-mobileapps.com\/de\/wp-content\/uploads\/sites\/2\/2018\/07\/cropped-UC-Logo.png\",\"contentUrl\":\"http:\/\/uc-mobileapps.com\/de\/wp-content\/uploads\/sites\/2\/2018\/07\/cropped-UC-Logo.png\",\"width\":512,\"height\":512,\"caption\":\"UC Mobile Apps\"},\"image\":{\"@id\":\"http:\/\/uc-mobileapps.com\/de\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/uc-mobileapps.com\/de\/#website\",\"url\":\"http:\/\/uc-mobileapps.com\/de\/\",\"name\":\"UC Mobile Apps\",\"description\":\"Innovative Softwareentwicklung und mobile Anwendungen\",\"publisher\":{\"@id\":\"http:\/\/uc-mobileapps.com\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/uc-mobileapps.com\/de\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de-DE\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/#webpage\",\"url\":\"https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/\",\"name\":\"SQL Optionen in den Metadaten - UC Mobile Apps\",\"isPartOf\":{\"@id\":\"http:\/\/uc-mobileapps.com\/de\/#website\"},\"datePublished\":\"2017-03-22T23:15:06+00:00\",\"dateModified\":\"2021-01-30T13:09:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/#breadcrumb\"},\"inLanguage\":\"de-DE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/uc-mobileapps.com\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Android Code Generator f\u00fcr SQLite and DataProvider Schnittstellen\",\"item\":\"http:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Optionen in den Metadaten\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Optionen in den Metadaten - UC Mobile Apps","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/","twitter_misc":{"Gesch\u00e4tzte Lesezeit":"1 Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"http:\/\/uc-mobileapps.com\/de\/#organization","name":"UC Mobile Apps","url":"http:\/\/uc-mobileapps.com\/de\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"http:\/\/uc-mobileapps.com\/de\/#logo","inLanguage":"de-DE","url":"http:\/\/uc-mobileapps.com\/de\/wp-content\/uploads\/sites\/2\/2018\/07\/cropped-UC-Logo.png","contentUrl":"http:\/\/uc-mobileapps.com\/de\/wp-content\/uploads\/sites\/2\/2018\/07\/cropped-UC-Logo.png","width":512,"height":512,"caption":"UC Mobile Apps"},"image":{"@id":"http:\/\/uc-mobileapps.com\/de\/#logo"}},{"@type":"WebSite","@id":"http:\/\/uc-mobileapps.com\/de\/#website","url":"http:\/\/uc-mobileapps.com\/de\/","name":"UC Mobile Apps","description":"Innovative Softwareentwicklung und mobile Anwendungen","publisher":{"@id":"http:\/\/uc-mobileapps.com\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/uc-mobileapps.com\/de\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de-DE"},{"@type":"WebPage","@id":"https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/#webpage","url":"https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/","name":"SQL Optionen in den Metadaten - UC Mobile Apps","isPartOf":{"@id":"http:\/\/uc-mobileapps.com\/de\/#website"},"datePublished":"2017-03-22T23:15:06+00:00","dateModified":"2021-01-30T13:09:22+00:00","breadcrumb":{"@id":"https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/#breadcrumb"},"inLanguage":"de-DE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/annotation-sql-typ-fremdschluessel-pflichtfeld\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/uc-mobileapps.com\/de\/"},{"@type":"ListItem","position":2,"name":"Android Code Generator f\u00fcr SQLite and DataProvider Schnittstellen","item":"http:\/\/uc-mobileapps.com\/de\/android-sqlite-dataprovider-code-generator\/"},{"@type":"ListItem","position":3,"name":"SQL Optionen in den Metadaten"}]}]}},"_links":{"self":[{"href":"http:\/\/uc-mobileapps.com\/de\/wp-json\/wp\/v2\/pages\/140"}],"collection":[{"href":"http:\/\/uc-mobileapps.com\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/uc-mobileapps.com\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/uc-mobileapps.com\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/uc-mobileapps.com\/de\/wp-json\/wp\/v2\/comments?post=140"}],"version-history":[{"count":7,"href":"http:\/\/uc-mobileapps.com\/de\/wp-json\/wp\/v2\/pages\/140\/revisions"}],"predecessor-version":[{"id":366,"href":"http:\/\/uc-mobileapps.com\/de\/wp-json\/wp\/v2\/pages\/140\/revisions\/366"}],"up":[{"embeddable":true,"href":"http:\/\/uc-mobileapps.com\/de\/wp-json\/wp\/v2\/pages\/62"}],"wp:attachment":[{"href":"http:\/\/uc-mobileapps.com\/de\/wp-json\/wp\/v2\/media?parent=140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}