SUPPORT
Schema Studio Support
Frequently asked questions
Which database products are supported?
PostgreSQL, MySQL, MariaDB, SQLite, Oracle Database, Microsoft SQL Server, and IBM Db2. The app generates dialect-aware DDL; it does not connect to or execute SQL against a live database.
Can I design indexes?
Yes. Open a table's Indexes section to create standard or unique indexes. You can add and reorder key columns, choose ASC or DESC, set a custom DDL name, and configure INCLUDE columns or a WHERE predicate where the selected product supports them.
What can I export?
A SQL file is always generated. You can also include Excel (.xlsx), PDF, Markdown, and HTML design documents. After generation, choose Save to Files to select an iCloud Drive or On My iPhone folder, or choose Share with another app to send a copy.
Why is “Assign numbers automatically” unavailable?
Automatic numbering is available only for a Whole number field. Choose Whole number under the value type first. Turning the option on creates a sequential primary key and also makes the field required. It is intended for technical IDs; do not rely on it for business numbers that must never have gaps.
Can I export the ER diagram?
The ER structure and relationships are included in the generated design documentation. Version 1.0 does not export the visual canvas itself as a standalone image.
Where is my design stored?
Your current schema is stored locally in the app's private container. Schema Studio has no account or cloud sync in version 1.0. Removing the app can remove this local data, so export important designs before uninstalling.
How do I change language?
Open Settings and choose Display Language. Document Language is separate, so the app and exported specification can use different languages.
Should generated DDL be run directly in production?
Review and test it first. Product versions, extensions, naming standards, storage settings, permissions, and organization-specific rules can require additional changes.
Contact
Email support@smart-bit.jp. Please include the iPhone or iPad model, iOS version, target database product, and steps to reproduce the issue. Do not include confidential schema data unless you intend to share it.
日本語
Schema Studio サポート
対応データベースは？
PostgreSQL、MySQL、MariaDB、SQLite、Oracle Database、Microsoft SQL Server、IBM Db2です。DDLを生成しますが、実データベースへの接続・実行機能はありません。
インデックスも設計できますか？
できます。通常／ユニーク、複合キー、ASC／DESC、DDL名、対応製品向けのINCLUDE列とWHERE条件を設定できます。
何を書き出せますか？
SQLは常に生成され、Excel、PDF、Markdown、HTMLの設計書を追加できます。作成後に「ファイルに保存」を選ぶとiCloud Driveまたは「このiPhone内」の保存先を指定でき、「他のアプリへ共有」を選ぶとコピーを送れます。
「番号を自動で付ける」が選べないのはなぜですか？
自動採番は、値の種類が「整数」の項目だけで使えます。先に「整数」を選んでください。オンにすると連番の主キーになり、「必ず入力する」も自動で有効になります。欠番が許されない伝票番号などではなく、内部管理用のIDに向く機能です。
ER図は書き出せますか？
ERの構造とリレーション情報は設計書に含まれます。バージョン1.0では、画面上のERキャンバスそのものを単独画像として書き出す機能はありません。
問い合わせ
support@smart-bit.jp まで、端末、iOSバージョン、対象製品、再現手順をお知らせください。意図しない機密スキーマ情報は添付しないでください。