【Folioチュートリアル】Single Server DeploymentのDB


随時追記

```

postgres-# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+-----------------------
 folio     | folio    | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 okapi     | okapi    | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres

```


```
postgres-# \c okapi
You are now connected to database "okapi" as user "postgres".
okapi-# \dt
          List of relations
 Schema |    Name     | Type  | Owner
--------+-------------+-------+-------
 public | deployments | table | okapi
 public | env         | table | okapi
 public | modules     | table | okapi
 public | tenants     | table | okapi

```

```
okapi=# select * from env;
                     json
----------------------------------------------
 {"name": "DB_HOST", "value": "10.0.2.15"}
 {"name": "DB_PORT", "value": "5432"}
 {"name": "DB_DATABASE", "value": "folio"}
 {"name": "DB_USERNAME", "value": "folio"}
 {"name": "DB_PASSWORD", "value": "folio123"}
```

select * from deployments;の一部

```
{"url": "http://10.0.2.15:9131", "instId": "f3e65bf4-f453-4499-be0c-e1348382f2bc", "nodeId": "10.0.2.15", "srvcId": "mo
d-calendar-1.9.1", "descriptor": {"env": [{"name": "DB_MAXPOOLSIZE", "value": "5"}, {"name": "DB_USERNAME", "value": "fo
lio"}, {"name": "DB_CHARSET", "value": "UTF-8"}, {"name": "DB_PORT", "value": "5432"}, {"name": "JAVA_OPTIONS", "value":
 "-XX:MaxRAMPercentage=66.0"}, {"name": "DB_HOST", "value": "10.0.2.15"}, {"name": "DB_DATABASE", "value": "folio"}, {"n
ame": "DB_QUERYTIMEOUT", "value": "60000"}, {"name": "DB_PASSWORD", "value": "folio123"}], "dockerArgs": {"HostConfig":
{"Memory": 357913941, "PortBindings": {"8081/tcp": [{"HostPort": "%p"}]}}}, "dockerPull": true, "dockerImage": "folioorg
/mod-calendar:1.9.1"}}
 {"url": "http://10.0.2.15:9132", "instId": "acdb9645-991a-4782-8ab2-01ca39fb39c4", "nodeId": "10.0.2.15", "srvcId": "mo
d-inventory-storage-19.3.2", "descriptor": {"env": [{"name": "DB_MAXPOOLSIZE", "value": "5"}, {"name": "DB_USERNAME", "v
alue": "folio"}, {"name": "DB_CHARSET", "value": "UTF-8"}, {"name": "DB_PORT", "value": "5432"}, {"name": "JAVA_OPTIONS"
, "value": "-XX:MaxRAMPercentage=66.0"}, {"name": "DB_HOST", "value": "10.0.2.15"}, {"name": "DB_DATABASE", "value": "fo
lio"}, {"name": "DB_QUERYTIMEOUT", "value": "60000"}, {"name": "DB_PASSWORD", "value": "folio123"}], "dockerArgs": {"Hos
tConfig": {"Memory": 715827883, "PortBindings": {"8081/tcp": [{"HostPort": "%p"}]}}}, "dockerPull": true, "dockerImage":
 "folioorg/mod-inventory-storage:19.3.2"}}
```

select * from tenants;

```
 {"enabled": {"okapi-3.1.2": true}, "descriptor": {"id": "supertenant", "name": "supertenant", "description": "Okapi built-in super tenant"}}
 {"enabled": {"okapi-3.1.2": true, "mod-tags-0.6.0": true, "mod-email-1.8.0": true, "mod-login-7.0.1": true, "mod-notes-2.9.0": true, "folio_tags-3.0.0": true, "mod-notify-2.6.0": true, "mod-pubsub-1.2.5": true, "mod-sender-1.3.1": true, "mod-users-17.1.0": true, "folio_users-4.0.7": true, "folio_search-3.0.0": true, "mod-calendar-1.9.1": true, "mod-users-bl-6.0.0": true, "folio_checkin-3.0.2": true, "mod-authtoken-2.5.1": true, "mod-codex-mux-2.8.0": true, "folio_calendar-4.0.1": true, "folio_checkout-4.0.2": true, "folio_requests-3.0.7": true, "mod-feesfines-15.8.2": true, "mod-inventory-16.0.2": true, "mod-login-saml-2.0.1": true, "folio_developer-3.0.0": true, "folio_inventory-4.0.3": true, "folio_myprofile-3.0.0": true, "mod-event-config-1.5.0": true, "mod-permissions-5.11.3": true, "folio_circulation-3.0.2": true, "mod-circulation-19.0.14": true, "mod-configuration-5.4.2": true, "mod-patron-blocks-1.0.7": true, "folio_stripes-core-5.0.2": true, "folio_servicepoints-3.0.0": true, "mod-codex-inventory-1.7.0": true, "mod-template-engine-1.9.0": true, "folio_tenant-settings-4.0.0": true, "folio_plugin-find-user-3.0.1": true, "mod-inventory-storage-19.3.2": true, "mod-password-validator-1.7.0": true, "mod-circulation-storage-12.0.3": true, "mod-source-record-storage-4.0.3": true, "folio_plugin-find-instance-3.0.0": true, "folio_stripes-smart-components-4.1.5": true}, "descriptor": {"id": "diku", "name": "Datalogisk Institut", "description": "Danish Library Technology Institute"}}
```