Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/postgis-workshop/schemas/changes/?format=api&page=4
{ "count": 226, "next": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/changes/?format=api&page=5", "previous": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/changes/?format=api&page=3", "results": [ { "unit": "https://weblate.osgeo.org/api/units/98430/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T10:05:30.651965Z", "action": 4, "target": "アプリケーションデータがスキーマ内にある時には、アプリケーションの差異の管理が簡単になるので、新しいバージョンのソフトウェアは、新しいスキーマ内のテーブル構造を処理して、カットオーバーの際はスキーマ名の単純な変更を行います。", "id": 1884433, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884433/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98429/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T10:05:30.646635Z", "action": 4, "target": "別のスキーマへのデータの格納は簡単ですので、アプリケーション指向のスキーマは、タイムトラベルとリカバリのための、個別の格納とバックアップが可能です。", "id": 1884432, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884432/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98428/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T10:05:30.641308Z", "action": 4, "target": "別のスキーマ内のデータのバックアップの方が簡単ですので、揮発性データと不揮発データとはバックアップスケジュールが異なります。", "id": 1884431, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884431/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98427/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T10:05:30.635697Z", "action": 4, "target": "スキーマ内で管理されるデータは一括処理に適用しやすいです。", "id": 1884430, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884430/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98424/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T10:05:30.621383Z", "action": 4, "target": "\"public\" スキーマ内では、ワークショップでこれまでに生成してきたテーブルの全てを見ることができます。", "id": 1884429, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884429/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98448/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:20:04.739571Z", "action": 7, "target": "ユーザスキーマの生成", "id": 1884426, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884426/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98446/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:20:01.283891Z", "action": 7, "target": "これで postgres ユーザは常に検索パスに ``census`` スキーマが入っているようになります。", "id": 1884425, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884425/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98444/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:19:50.119362Z", "action": 7, "target": "毎回の検索パスの設定も、面倒くさくなりますが、幸運にも、永続的に検索パスを設定することができます:", "id": 1884424, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884424/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98443/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:19:46.709050Z", "action": 7, "target": "これによって、全てのリレーションや関数委への参照が ``census`` と ``public`` スキーマの両方で確実に検索されることになります。全ての PostGIS の関数と型が ``public`` 内にあり、検索パスから外したくないものであることを忘れないで下さい。", "id": 1884423, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884423/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98442/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:19:40.895634Z", "action": 7, "target": "``SET`` コマンドで実行時に ``search_path`` の設定ができます:", "id": 1884422, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884422/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98441/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:19:36.276131Z", "action": 7, "target": "``search_path`` の操作は、多数の追加的なキー入力をせずに複数のスキーマ内にあるテーブルにアクセスするのに良い方法です。", "id": 1884421, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884421/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98440/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:19:30.456095Z", "action": 7, "target": "明示的な参照は簡単ですが、しばらくすると面倒くさくなります:", "id": 1884420, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884420/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98439/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:19:14.056334Z", "action": 2, "target": "スキーマの ``search_path``への追加によるアクセス", "id": 1884419, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1884419/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98439/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:19:05.149380Z", "action": 7, "target": "スキーマの `search_path``への追加によるアクセス", "id": 1884418, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884418/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98438/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:19:02.815337Z", "action": 7, "target": "``schema.table`` 標記を使用した参照によるアクセス", "id": 1884417, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884417/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98437/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:18:59.674187Z", "action": 7, "target": "スキーマ内のテーブルへのアクセスには二つの方法があります:", "id": 1884416, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884416/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98436/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:18:54.940444Z", "action": 7, "target": "コマンドラインプログラム :command:`psql` を使用している場合には、``nyc_census_blocks`` がテーブル一覧から消えたことに気付くでしょう! pgAdmin を使用している場合には、新しいスキーマとその中にあるテーブルを見るためには表示のリフレッシュが必要な場合があります。", "id": 1884415, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884415/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98435/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:18:47.219533Z", "action": 7, "target": "次に ``nyc_census_blocks`` テーブルを ``census`` スキーマに移動させます:", "id": 1884414, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884414/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98434/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:18:32.225803Z", "action": 7, "target": "新しいスキーマを生成して、テーブルをそちらに移動させましょう。まず、データベース内に新しいスキーマを生成します:", "id": 1884413, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884413/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98433/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:18:27.713121Z", "action": 7, "target": "データスキーマの生成", "id": 1884412, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884412/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98426/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:18:24.873529Z", "action": 7, "target": "スキーマを使用する二つの理由があります:", "id": 1884411, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884411/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98425/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:18:20.345209Z", "action": 7, "target": "なぜスキーマを使うのか?", "id": 1884410, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884410/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98424/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:18:16.939824Z", "action": 7, "target": "public スキーマ内では、ワークショップでこれまでに生成してきたテーブルの全てを見ることができます。", "id": 1884409, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884409/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98423/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:18:10.896509Z", "action": 2, "target": "スキーマ内では、PostGIS のデフォルトインストールによって、PostGISが使用する全ての型と関数とともに``geometry_columns``, ``geography_columns``, ``spatial_ref_sys`` メタデータリレーションが生成されます。そのため、PostGIS ユーザは常に public スキーマへのアクセスが必要となります。", "id": 1884408, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1884408/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98423/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:18:05.381723Z", "action": 7, "target": "スキーマ内では、PostGIS のデフォルトインストールによって、PostGISが使用する全ての型と関数とともに \"geometry_columns\", \"geography_columns\", \"spatial_ref_sys\" メタデータリレーションが生成されます。そのため、PostGIS ユーザは常に public スキーマへのアクセスが必要となります。", "id": 1884407, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884407/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98422/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:17:29.745361Z", "action": 2, "target": "スキーマはフォルダのようなもので、テーブル、ビュー、関数、シーケンスやその他のリレーションを保持できます。全てのデータベースは ``public`` という一つのスキーマから始まります。", "id": 1884406, "action_name": "Translation changed", "url": "https://weblate.osgeo.org/api/changes/1884406/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98422/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:41.723467Z", "action": 7, "target": "スキーマはフォルダのようなもので、テーブル、ビュー、関数、シーケンスやその他のリレーションを保持できます。全てのデータベースは \"public\" という一つのスキーマから始まります。", "id": 1884405, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884405/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98420/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:34.489068Z", "action": 7, "target": "運用データベースは必然的に多数のテーブルとビューを持ち、これら全てを一つのスキーマで管理すると、すぐに扱いにくくなります。幸運にも PostgreSQL_ には \"_Schema\"の概念があります。", "id": 1884404, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884404/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98418/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:28.369635Z", "action": 7, "target": "PostgreSQL スキーマ", "id": 1884403, "action_name": "Suggestion accepted", "url": "https://weblate.osgeo.org/api/changes/1884403/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98448/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.772829Z", "action": 4, "target": "ユーザスキーマの生成", "id": 1884402, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884402/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98446/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.765865Z", "action": 4, "target": "これで postgres ユーザは常に検索パスに ``census`` スキーマが入っているようになります。", "id": 1884401, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884401/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98444/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.758893Z", "action": 4, "target": "毎回の検索パスの設定も、面倒くさくなりますが、幸運にも、永続的に検索パスを設定することができます:", "id": 1884400, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884400/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98443/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.752139Z", "action": 4, "target": "これによって、全てのリレーションや関数委への参照が ``census`` と ``public`` スキーマの両方で確実に検索されることになります。全ての PostGIS の関数と型が ``public`` 内にあり、検索パスから外したくないものであることを忘れないで下さい。", "id": 1884399, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884399/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98442/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.745312Z", "action": 4, "target": "``SET`` コマンドで実行時に ``search_path`` の設定ができます:", "id": 1884398, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884398/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98441/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.738653Z", "action": 4, "target": "``search_path`` の操作は、多数の追加的なキー入力をせずに複数のスキーマ内にあるテーブルにアクセスするのに良い方法です。", "id": 1884397, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884397/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98440/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.731782Z", "action": 4, "target": "明示的な参照は簡単ですが、しばらくすると面倒くさくなります:", "id": 1884396, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884396/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98439/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.725017Z", "action": 4, "target": "スキーマの `search_path``への追加によるアクセス", "id": 1884395, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884395/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98438/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.718085Z", "action": 4, "target": "``schema.table`` 標記を使用した参照によるアクセス", "id": 1884394, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884394/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98437/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.711237Z", "action": 4, "target": "スキーマ内のテーブルへのアクセスには二つの方法があります:", "id": 1884393, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884393/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98436/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.704627Z", "action": 4, "target": "コマンドラインプログラム :command:`psql` を使用している場合には、``nyc_census_blocks`` がテーブル一覧から消えたことに気付くでしょう! pgAdmin を使用している場合には、新しいスキーマとその中にあるテーブルを見るためには表示のリフレッシュが必要な場合があります。", "id": 1884392, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884392/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98435/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.697523Z", "action": 4, "target": "次に ``nyc_census_blocks`` テーブルを ``census`` スキーマに移動させます:", "id": 1884391, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884391/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98434/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.689476Z", "action": 4, "target": "新しいスキーマを生成して、テーブルをそちらに移動させましょう。まず、データベース内に新しいスキーマを生成します:", "id": 1884390, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884390/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98433/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.682785Z", "action": 4, "target": "データスキーマの生成", "id": 1884389, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884389/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98426/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.664646Z", "action": 4, "target": "スキーマを使用する二つの理由があります:", "id": 1884388, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884388/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98425/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.659970Z", "action": 4, "target": "なぜスキーマを使うのか?", "id": 1884387, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884387/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98424/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.655259Z", "action": 4, "target": "public スキーマ内では、ワークショップでこれまでに生成してきたテーブルの全てを見ることができます。", "id": 1884386, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884386/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98423/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.650668Z", "action": 4, "target": "スキーマ内では、PostGIS のデフォルトインストールによって、PostGISが使用する全ての型と関数とともに \"geometry_columns\", \"geography_columns\", \"spatial_ref_sys\" メタデータリレーションが生成されます。そのため、PostGIS ユーザは常に public スキーマへのアクセスが必要となります。", "id": 1884385, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884385/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98422/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.645869Z", "action": 4, "target": "スキーマはフォルダのようなもので、テーブル、ビュー、関数、シーケンスやその他のリレーションを保持できます。全てのデータベースは \"public\" という一つのスキーマから始まります。", "id": 1884384, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884384/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98420/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.640991Z", "action": 4, "target": "運用データベースは必然的に多数のテーブルとビューを持ち、これら全てを一つのスキーマで管理すると、すぐに扱いにくくなります。幸運にも PostgreSQL_ には \"_Schema\"の概念があります。", "id": 1884383, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884383/?format=api" }, { "unit": "https://weblate.osgeo.org/api/units/98418/?format=api", "component": "https://weblate.osgeo.org/api/components/postgis-workshop/schemas/?format=api", "translation": "https://weblate.osgeo.org/api/translations/postgis-workshop/schemas/ja/?format=api", "user": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "author": "https://weblate.osgeo.org/api/users/yellow73/?format=api", "timestamp": "2023-10-16T09:16:20.600819Z", "action": 4, "target": "PostgreSQL スキーマ", "id": 1884382, "action_name": "Suggestion added", "url": "https://weblate.osgeo.org/api/changes/1884382/?format=api" } ] }