Database design

## Table ### Naming Rule #### Use lower case + snake case users // OK user_categories // OK USERS // NG Users // NG userCategories // NG #### Use the plural users // OK user // NG #### n:n table ex. related users and images users_images // OK ## Column ### Required Columns id // Primary key(auto increment) created_at updated_at ### Naming Rule #### Use the noun title // OK description // OK #### Others table id ex. id on users table user_id // OK users_id // NG #### datetime posted_at // OK post_time // NG #### boolean published // OK publish_flag // NG ## Index ### Naming Rule #### Index `idx_<table>_XX` idx_users_01 // OK #### Unique Index`ui_<table>_XX` ui_users_01 // OK ## Others ### DO NOT logical deletion deleted_at // NG deleted // NG ### DO NOT create composite primary keys Use `id` for primary key ### DO NOT use foreign key basically ## MySQL ### type Use `bigint` for number Use `varcher` for string Use `datetime` for date Use `tinyint` for boolean ### autoupdate for created_at, updated_at #### `created_at` ``` `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ``` #### `updated_at` ``` `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ```

Meaningful Links for Ionic2/Cordova

##Implements * Template for starting Ionic 2 apps, used by the Ionic CLI https://github.com/driftyco/ionic2-app-base * Click Delays http://ionicframework.com/docs/v2/faq/#click-delays * Stick list headers https://forum.ionicframework.com/t/stick-list-headers/68818 * Navigation Controller within Modal https://forum.ionicframework.com/t/navigation-controller-within-modal/45302/3 * Zoom on image in Ionic 2? https://forum.ionicframework.com/t/zoom-on-image-in-ionic-2/45910/21 https://gist.github.com/vazad28/bd7ff445b090ab130ff1b291ca057002 ### VritualScroll, InfiniteScroll * VirtualScroll + InfiniteScroll scrolls top when reaching list bottom https://github.com/driftyco/ionic/issues/6423 * feat(infinite): add scroll in opposite direction https://github.com/driftyco/ionic/pull/8099 * Ionic2 two way infinite scroll component example https://github.com/lujakob/ionic-infinite-scroll-example * InfiniteScroll and ensuring there is "enough" data https://github.com/driftyco/ionic/issues/6341 * RC4: VirtualScroll disappears after data update, if has been scrolled before https://github.com/driftyco/ionic/issues/9722 ### Input * v2 feature request - autoresize on ion-textarea https://github.com/driftyco/ionic/issues/7193 * issue(forms): Input, scrolling, keyboard issues for forms https://github.com/driftyco/ionic/issues/6228 ### CLI * Feature request: Ionic 2 (dev/prod) environment variables configuration https://github.com/driftyco/ionic-cli/issues/1205 * [ionic-cli@2.1.4] ionic emulate ios --target parameter not working https://github.com/driftyco/ionic-cli/issues/1756 * Current working directory is not a Cordova based project https://github.com/driftyco/ionic-cli/issues/935 ## Plugin ### Storage * Ionic 2 storage doesn’t have query method https://github.com/driftyco/ionic/issues/8269#issuecomment-250869481 ### WKWebView * Cordova iOS Performance Improvements: Drop-in Speed with WKWebView http://blog.ionic.io/cordova-ios-performance-improvements-drop-in-speed-with-wkwebview/ * Handling CORS issues in Ionic http://blog.ionic.io/handling-cors-issues-in-ionic/ * CORS issues https://github.com/driftyco/cordova-plugin-wkwebview-engine/issues/3 ### InAppBrowser * Launch External URLs with IonicFramework https://www.thepolyglotdeveloper.com/2014/07/launch-external-urls-ionicframework/ * CB-3360: Set custom inappbrowser user agent for ios https://github.com/apache/cordova-plugin-inappbrowser/pull/94 * CB-12366: (ios) Reduce tmpWindow level to prevent overlapping statusbar https://github.com/apache/cordova-plugin-inappbrowser/pull/209 ### Photo Library * https://github.com/domax/cordova-plugin-photos * https://github.com/terikon/cordova-plugin-photo-library * https://github.com/subitolabs/cordova-gallery-api * https://github.com/glowmar/phonegap-plugin-assetslib ### Fabric * How to send all error messages to Plugin https://github.com/sarriaroman/FabricPlugin/issues/70 ### BackgroundFetch https://github.com/transistorsoft/cordova-plugin-background-fetch ## Build * error : ionc build ios or android, uglifyjs failed: SyntaxError: Unexpected token: operator (>) https://github.com/driftyco/ionic-app-scripts/issues/239#issuecomment-256064022 ### iOS * ionic run ios --device fails with Error code 65 for command: xcodebuild (xcode 8) https://github.com/driftyco/ionic/issues/8464#issuecomment-251335408 ## Deploy ### Fastlane * Fastfile for Cordova App https://github.com/platanus/fastlane-cordova/blob/master/fastlane/Fastfile * Use xcodebuild (Xcode 8) and automatic signing in CI (Travis/Jenkins) environments http://stackoverflow.com/questions/39500634/use-xcodebuild-xcode-8-and-automatic-signing-in-ci-travis-jenkins-environmen * Automating Cordova Workflow: xcodebuild Hangs During iOS Build http://moduscreate.com/cordova_xcodebuild_hangs_freezes_during_build/ * Got Code signing is required for product type 'Application' in SDK 'iOS 10.1 https://github.com/fastlane/fastlane/issues/6832 * `ProvisioningStyle` value not present in project.pbxproj https://github.com/hjanuschka/fastlane-plugin-update_project_codesigning/issues/4 ### CircleCI * CircleCI-Scripts https://github.com/bamlab/CircleCI-Scripts