Created
June 13, 2012 20:27
-
-
Save slmnhq/2926316 to your computer and use it in GitHub Desktop.
A complex hierarchical JSON document
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "database":{ | |
| "@name":"std", | |
| "@type":"PostgreSQL - 8.4.11", | |
| "@schema":"public", | |
| "tables":{ | |
| "table":[ | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"activity_pkey" | |
| }, | |
| "@name":"activity", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":{ | |
| "@foreignKey":"activity_detail_activity_id_fkey", | |
| "@column":"activity_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"activity_detail", | |
| "@implied":"false" | |
| }, | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"user_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"object_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"activity_type", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"data", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"4" | |
| }, | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"activity_detail_pkey" | |
| }, | |
| "@name":"activity_detail", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"activity_id", | |
| "parent":{ | |
| "@foreignKey":"activity_detail_activity_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"activity", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"object_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"object_type", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"activity_type", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"data", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"12" | |
| }, | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"authorization_group_pkey" | |
| }, | |
| "@name":"authorization_group", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":[ | |
| { | |
| "@foreignKey":"authorization_group_role_authorization_group_id_fkey", | |
| "@column":"authorization_group_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"authorization_group_role", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"authorization_group_user_authorization_group_id_fkey", | |
| "@column":"authorization_group_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"authorization_group_user", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"user_object_role_authorized_group_id_fkey", | |
| "@column":"authorized_group_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"user_object_role", | |
| "@implied":"false" | |
| } | |
| ], | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"name", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"created", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"2" | |
| }, | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"user_object_role_id" | |
| }, | |
| "@unique":"true", | |
| "@name":"authorization_group_role_pkey" | |
| }, | |
| "@name":"authorization_group_role", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"user_object_role_id", | |
| "parent":{ | |
| "@foreignKey":"authorization_group_role_user_object_role_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"user_object_role", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"authorization_group_id", | |
| "parent":{ | |
| "@foreignKey":"authorization_group_role_authorization_group_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"authorization_group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"user_object_role_id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"2" | |
| }, | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"authorization_group_user_pkey" | |
| }, | |
| "@name":"authorization_group_user", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"authorization_group_id", | |
| "parent":{ | |
| "@foreignKey":"authorization_group_user_authorization_group_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"authorization_group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"user_id", | |
| "parent":{ | |
| "@foreignKey":"authorization_group_user_user_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"user", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"0" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"group_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"name" | |
| }, | |
| "@unique":"true", | |
| "@name":"group_name_key" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_group_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"name" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_group_name" | |
| } | |
| ], | |
| "@name":"group", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":[ | |
| { | |
| "@foreignKey":"group_extra_group_id_fkey", | |
| "@column":"group_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group_extra", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"group_extra_revision_group_id_fkey", | |
| "@column":"group_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group_extra_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"group_revision_continuity_id_fkey", | |
| "@column":"continuity_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"group_role_group_id_fkey", | |
| "@column":"group_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group_role", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"member_group_id_fkey", | |
| "@column":"group_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"member", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"member_revision_group_id_fkey", | |
| "@column":"group_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"member_revision", | |
| "@implied":"false" | |
| } | |
| ], | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"name", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"title", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"description", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"created", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"group_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"type", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"2" | |
| }, | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"group_extra_pkey" | |
| }, | |
| "@name":"group_extra", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":{ | |
| "@foreignKey":"group_extra_revision_continuity_id_fkey", | |
| "@column":"continuity_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group_extra_revision", | |
| "@implied":"false" | |
| }, | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"group_id", | |
| "parent":{ | |
| "@foreignKey":"group_extra_group_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"key", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"value", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"group_extra_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"0" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| } | |
| ], | |
| "@unique":"true", | |
| "@name":"group_extra_revision_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"current" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_group_extra_current" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_group_extra_period" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"group_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_group_extra_period_group" | |
| } | |
| ], | |
| "@name":"group_extra_revision", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"group_id", | |
| "parent":{ | |
| "@foreignKey":"group_extra_revision_group_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"key", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"value", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"group_extra_revision_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"continuity_id", | |
| "parent":{ | |
| "@foreignKey":"group_extra_revision_continuity_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group_extra", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"expired_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"revision_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"expired_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"current", | |
| "@nullable":"true", | |
| "@size":"1", | |
| "@remarks":"", | |
| "@id":"10", | |
| "@type":"bool", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":[ | |
| { | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| { | |
| "@column":"revision_id", | |
| "@sequenceNumberInPK":"2" | |
| } | |
| ], | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"0" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| } | |
| ], | |
| "@unique":"true", | |
| "@name":"group_revision_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"current" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_group_current" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_group_period" | |
| } | |
| ], | |
| "@name":"group_revision", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"name", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"title", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"description", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"created", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"group_revision_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"continuity_id", | |
| "parent":{ | |
| "@foreignKey":"group_revision_continuity_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"expired_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"revision_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"expired_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"10", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"current", | |
| "@nullable":"true", | |
| "@size":"1", | |
| "@remarks":"", | |
| "@id":"11", | |
| "@type":"bool", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"type", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"12", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":[ | |
| { | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| { | |
| "@column":"revision_id", | |
| "@sequenceNumberInPK":"2" | |
| } | |
| ], | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"2" | |
| }, | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"user_object_role_id" | |
| }, | |
| "@unique":"true", | |
| "@name":"group_role_pkey" | |
| }, | |
| "@name":"group_role", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"user_object_role_id", | |
| "parent":{ | |
| "@foreignKey":"group_role_user_object_role_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"user_object_role", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"group_id", | |
| "parent":{ | |
| "@foreignKey":"group_role_group_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"user_object_role_id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"8" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"member_pkey" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"group_id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"table_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_extra_grp_id_pkg_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"table_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_group_pkg_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"group_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_group_group_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_group_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"table_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_group_pkg_id" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"group_id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"table_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_package_group_pkg_id_group_id" | |
| } | |
| ], | |
| "@name":"member", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":{ | |
| "@foreignKey":"member_revision_continuity_id_fkey", | |
| "@column":"continuity_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"member_revision", | |
| "@implied":"false" | |
| }, | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"table_id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"group_id", | |
| "parent":{ | |
| "@foreignKey":"member_group_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"member_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"table_name", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"capacity", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"3" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| } | |
| ], | |
| "@unique":"true", | |
| "@name":"member_revision_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"current" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_group_current" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"table_id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"group_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_package_group_period_package_group" | |
| } | |
| ], | |
| "@name":"member_revision", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"table_id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"group_id", | |
| "parent":{ | |
| "@foreignKey":"member_revision_group_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"member_revision_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"continuity_id", | |
| "parent":{ | |
| "@foreignKey":"member_revision_continuity_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"member", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"expired_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"revision_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"expired_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"current", | |
| "@nullable":"true", | |
| "@size":"1", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"bool", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"table_name", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"10", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"capacity", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"11", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":[ | |
| { | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| { | |
| "@column":"revision_id", | |
| "@sequenceNumberInPK":"2" | |
| } | |
| ], | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"3" | |
| }, | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"repository_id" | |
| }, | |
| "@unique":"true", | |
| "@name":"migrate_version_pkey" | |
| }, | |
| "@name":"migrate_version", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"repository_id", | |
| "@nullable":"false", | |
| "@size":"250", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"varchar", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"repository_path", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"version", | |
| "@nullable":"true", | |
| "@size":"10", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"int4", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"repository_id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"1" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"package_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_pkg_id" | |
| }, | |
| { | |
| "@unique":"false", | |
| "@name":"idx_pkg_lname" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"name" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_pkg_name" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_pkg_rev_id" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"state" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_pkg_sid" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"state" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_pkg_slname" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"name" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"state" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_pkg_sname" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"state" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_pkg_srev_id" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"title" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"state" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_pkg_stitle" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"state" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_pkg_suname" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"title" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_pkg_title" | |
| }, | |
| { | |
| "@unique":"false", | |
| "@name":"idx_pkg_uname" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"name" | |
| }, | |
| "@unique":"true", | |
| "@name":"package_name_key" | |
| } | |
| ], | |
| "@name":"package", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":[ | |
| { | |
| "@foreignKey":"package_extra_package_id_fkey", | |
| "@column":"package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_extra", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_extra_revision_package_id_fkey", | |
| "@column":"package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_extra_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_relationship_object_package_id_fkey", | |
| "@column":"object_package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_relationship", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_relationship_subject_package_id_fkey", | |
| "@column":"subject_package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_relationship", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_relationship_revision_object_package_id_fkey", | |
| "@column":"object_package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_relationship_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_relationship_revision_subject_package_id_fkey", | |
| "@column":"subject_package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_relationship_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_revision_continuity_id_fkey", | |
| "@column":"continuity_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_role_package_id_fkey", | |
| "@column":"package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_role", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_tag_package_id_fkey", | |
| "@column":"package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_tag", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_tag_revision_package_id_fkey", | |
| "@column":"package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_tag_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"rating_package_id_fkey", | |
| "@column":"package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"rating", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"resource_group_package_id_fkey", | |
| "@column":"package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource_group", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"resource_group_revision_package_id_fkey", | |
| "@column":"package_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource_group_revision", | |
| "@implied":"false" | |
| } | |
| ], | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"name", | |
| "@nullable":"false", | |
| "@size":"100", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"varchar", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"title", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"version", | |
| "@nullable":"true", | |
| "@size":"100", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"varchar", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"url", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"notes", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"license_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"package_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"author", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"author_email", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"maintainer", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"10", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"maintainer_email", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"11", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"12", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"type", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"13", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"3" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"package_extra_pkey" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"package_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_extra_id_pkg_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"package_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_extra_pkg_id" | |
| } | |
| ], | |
| "@name":"package_extra", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":{ | |
| "@foreignKey":"package_extra_revision_continuity_id_fkey", | |
| "@column":"continuity_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_extra_revision", | |
| "@implied":"false" | |
| }, | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"package_id", | |
| "parent":{ | |
| "@foreignKey":"package_extra_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"key", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"value", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"package_extra_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"2" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| } | |
| ], | |
| "@unique":"true", | |
| "@name":"package_extra_revision_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"current" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_extra_current" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_package_extra_period" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"package_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_package_extra_period_package" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_extra_rev_id" | |
| } | |
| ], | |
| "@name":"package_extra_revision", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"package_id", | |
| "parent":{ | |
| "@foreignKey":"package_extra_revision_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"key", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"value", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"package_extra_revision_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"continuity_id", | |
| "parent":{ | |
| "@foreignKey":"package_extra_revision_continuity_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_extra", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"expired_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"revision_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"expired_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"current", | |
| "@nullable":"true", | |
| "@size":"1", | |
| "@remarks":"", | |
| "@id":"10", | |
| "@type":"bool", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":[ | |
| { | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| { | |
| "@column":"revision_id", | |
| "@sequenceNumberInPK":"2" | |
| } | |
| ], | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"2" | |
| }, | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"package_relationship_pkey" | |
| }, | |
| "@name":"package_relationship", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":{ | |
| "@foreignKey":"package_relationship_revision_continuity_id_fkey", | |
| "@column":"continuity_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_relationship_revision", | |
| "@implied":"false" | |
| }, | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"subject_package_id", | |
| "parent":{ | |
| "@foreignKey":"package_relationship_subject_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"object_package_id", | |
| "parent":{ | |
| "@foreignKey":"package_relationship_object_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"type", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"comment", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"package_relationship_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"0" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| } | |
| ], | |
| "@unique":"true", | |
| "@name":"package_relationship_revision_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"current" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_relationship_current" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"object_package_id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"subject_package_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_period_package_relationship" | |
| } | |
| ], | |
| "@name":"package_relationship_revision", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"subject_package_id", | |
| "parent":{ | |
| "@foreignKey":"package_relationship_revision_subject_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"object_package_id", | |
| "parent":{ | |
| "@foreignKey":"package_relationship_revision_object_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"type", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"comment", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"package_relationship_revision_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"continuity_id", | |
| "parent":{ | |
| "@foreignKey":"package_relationship_revision_continuity_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_relationship", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"expired_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"revision_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"expired_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"10", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"current", | |
| "@nullable":"true", | |
| "@size":"1", | |
| "@remarks":"", | |
| "@id":"11", | |
| "@type":"bool", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":[ | |
| { | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| { | |
| "@column":"revision_id", | |
| "@sequenceNumberInPK":"2" | |
| } | |
| ], | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"0" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| } | |
| ], | |
| "@unique":"true", | |
| "@name":"package_revision_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"current" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_current" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_package_period" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_pkg_revision_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"name" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_pkg_revision_name" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_pkg_revision_rev_id" | |
| } | |
| ], | |
| "@name":"package_revision", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"name", | |
| "@nullable":"false", | |
| "@size":"100", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"varchar", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"title", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"version", | |
| "@nullable":"true", | |
| "@size":"100", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"varchar", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"url", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"notes", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"license_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"package_revision_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"continuity_id", | |
| "parent":{ | |
| "@foreignKey":"package_revision_continuity_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"author", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"author_email", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"10", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"maintainer", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"11", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"maintainer_email", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"12", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"13", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"expired_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"14", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"revision_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"15", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"expired_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"16", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"current", | |
| "@nullable":"true", | |
| "@size":"1", | |
| "@remarks":"", | |
| "@id":"17", | |
| "@type":"bool", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"type", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"18", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":[ | |
| { | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| { | |
| "@column":"revision_id", | |
| "@sequenceNumberInPK":"2" | |
| } | |
| ], | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"3" | |
| }, | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"user_object_role_id" | |
| }, | |
| "@unique":"true", | |
| "@name":"package_role_pkey" | |
| }, | |
| "@name":"package_role", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"user_object_role_id", | |
| "parent":{ | |
| "@foreignKey":"package_role_user_object_role_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"user_object_role", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"package_id", | |
| "parent":{ | |
| "@foreignKey":"package_role_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"user_object_role_id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"11" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"package_tag_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_tag_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"package_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_tag_pkg_id" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"tag_id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"package_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_package_tag_pkg_id_tag_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"tag_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_tag_tag_id" | |
| } | |
| ], | |
| "@name":"package_tag", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":{ | |
| "@foreignKey":"package_tag_revision_continuity_id_fkey", | |
| "@column":"continuity_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_tag_revision", | |
| "@implied":"false" | |
| }, | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"package_id", | |
| "parent":{ | |
| "@foreignKey":"package_tag_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"tag_id", | |
| "parent":{ | |
| "@foreignKey":"package_tag_tag_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"tag", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"package_tag_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"5" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| } | |
| ], | |
| "@unique":"true", | |
| "@name":"package_tag_revision_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"current" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_tag_current" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_tag_revision_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"package_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_tag_revision_pkg_id" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"tag_id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"package_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_package_tag_revision_pkg_id_tag_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_tag_revision_rev_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"tag_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_tag_revision_tag_id" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"package_id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"tag_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_period_package_tag" | |
| } | |
| ], | |
| "@name":"package_tag_revision", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"package_id", | |
| "parent":{ | |
| "@foreignKey":"package_tag_revision_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"tag_id", | |
| "parent":{ | |
| "@foreignKey":"package_tag_revision_tag_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"tag", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"package_tag_revision_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"continuity_id", | |
| "parent":{ | |
| "@foreignKey":"package_tag_revision_continuity_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_tag", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"expired_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"revision_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"expired_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"current", | |
| "@nullable":"true", | |
| "@size":"1", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"bool", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":[ | |
| { | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| { | |
| "@column":"revision_id", | |
| "@sequenceNumberInPK":"2" | |
| } | |
| ], | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"5" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"rating_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_rating_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"package_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_rating_package_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"user_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_rating_user_id" | |
| } | |
| ], | |
| "@name":"rating", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"user_id", | |
| "parent":{ | |
| "@foreignKey":"rating_user_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"user", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"user_ip_address", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"package_id", | |
| "parent":{ | |
| "@foreignKey":"rating_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"17", | |
| "@name":"rating", | |
| "@nullable":"true", | |
| "@size":"17", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"float8", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"created", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"0" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"resource_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_resource_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"resource_group_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_resource_pkg_id" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"resource_group_id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_package_resource_pkg_id_resource_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"url" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_resource_url" | |
| } | |
| ], | |
| "@name":"resource", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":{ | |
| "@foreignKey":"resource_revision_continuity_id_fkey", | |
| "@column":"continuity_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource_revision", | |
| "@implied":"false" | |
| }, | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"resource_group_id", | |
| "parent":{ | |
| "@foreignKey":"resource_resource_group_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource_group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"url", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"format", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"description", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"position", | |
| "@nullable":"true", | |
| "@size":"10", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"int4", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"resource_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"hash", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"extras", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"name", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"10", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"resource_type", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"11", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"mimetype", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"12", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"mimetype_inner", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"13", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"size", | |
| "@nullable":"true", | |
| "@size":"19", | |
| "@remarks":"", | |
| "@id":"14", | |
| "@type":"int8", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"last_modified", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"15", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"cache_url", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"16", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"cache_last_updated", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"17", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"webstore_url", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"18", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"webstore_last_updated", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"19", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"2" | |
| }, | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"resource_group_pkey" | |
| }, | |
| "@name":"resource_group", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":[ | |
| { | |
| "@foreignKey":"resource_resource_group_id_fkey", | |
| "@column":"resource_group_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"resource_group_revision_continuity_id_fkey", | |
| "@column":"continuity_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource_group_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"resource_revision_resource_group_id_fkey", | |
| "@column":"resource_group_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource_revision", | |
| "@implied":"false" | |
| } | |
| ], | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"package_id", | |
| "parent":{ | |
| "@foreignKey":"resource_group_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"label", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"sort_order", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"extras", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"resource_group_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"3" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| } | |
| ], | |
| "@unique":"true", | |
| "@name":"resource_group_revision_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"current" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_resource_group_current" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_resource_group_period" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"package_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_resource_group_period_package" | |
| } | |
| ], | |
| "@name":"resource_group_revision", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"package_id", | |
| "parent":{ | |
| "@foreignKey":"resource_group_revision_package_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"label", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"sort_order", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"extras", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"resource_group_revision_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"continuity_id", | |
| "parent":{ | |
| "@foreignKey":"resource_group_revision_continuity_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource_group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"expired_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"revision_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"expired_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"10", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"current", | |
| "@nullable":"true", | |
| "@size":"1", | |
| "@remarks":"", | |
| "@id":"11", | |
| "@type":"bool", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":[ | |
| { | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| { | |
| "@column":"revision_id", | |
| "@sequenceNumberInPK":"2" | |
| } | |
| ], | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"3" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| } | |
| ], | |
| "@unique":"true", | |
| "@name":"resource_revision_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"revision_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_package_resource_rev_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"current" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_resource_current" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_resource_period" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"revision_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"expired_timestamp" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"resource_group_id" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_resource_period_resource_group" | |
| } | |
| ], | |
| "@name":"resource_revision", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"resource_group_id", | |
| "parent":{ | |
| "@foreignKey":"resource_revision_resource_group_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource_group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"url", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"format", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"description", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"position", | |
| "@nullable":"true", | |
| "@size":"10", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"int4", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"revision_id", | |
| "parent":{ | |
| "@foreignKey":"resource_revision_revision_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"revision", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"continuity_id", | |
| "parent":{ | |
| "@foreignKey":"resource_revision_continuity_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"hash", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"extras", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"10", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"expired_id", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"11", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"revision_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"12", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"expired_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"13", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"current", | |
| "@nullable":"true", | |
| "@size":"1", | |
| "@remarks":"", | |
| "@id":"14", | |
| "@type":"bool", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"name", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"15", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"resource_type", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"16", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"mimetype", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"17", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"mimetype_inner", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"18", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"size", | |
| "@nullable":"true", | |
| "@size":"19", | |
| "@remarks":"", | |
| "@id":"19", | |
| "@type":"int8", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"last_modified", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"20", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"cache_url", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"21", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"cache_last_updated", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"22", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"webstore_url", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"23", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"webstore_last_updated", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"24", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":[ | |
| { | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| { | |
| "@column":"revision_id", | |
| "@sequenceNumberInPK":"2" | |
| } | |
| ], | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"2" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"revision_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"state" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_rev_state" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"author" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_revision_author" | |
| } | |
| ], | |
| "@name":"revision", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":[ | |
| { | |
| "@foreignKey":"group_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"group_extra_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group_extra", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"group_extra_revision_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group_extra_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"group_revision_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"member_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"member", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"member_revision_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"member_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_extra_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_extra", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_extra_revision_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_extra_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_relationship_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_relationship", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_relationship_revision_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_relationship_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_revision_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_tag_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_tag", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_tag_revision_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_tag_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"resource_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"resource_group_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource_group", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"resource_group_revision_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource_group_revision", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"resource_revision_revision_id_fkey", | |
| "@column":"revision_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"resource_revision", | |
| "@implied":"false" | |
| } | |
| ], | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"author", | |
| "@nullable":"true", | |
| "@size":"200", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"varchar", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"message", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"approved_timestamp", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"4" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"role_action_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"action" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_ra_action" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"role" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_ra_role" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"action" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"role" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_ra_role_action" | |
| } | |
| ], | |
| "@name":"role_action", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"role", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"context", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"action", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"20" | |
| }, | |
| { | |
| "index":{ | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"user_object_role_id" | |
| }, | |
| "@unique":"true", | |
| "@name":"system_role_pkey" | |
| }, | |
| "@name":"system_role", | |
| "column":{ | |
| "@digits":"0", | |
| "@name":"user_object_role_id", | |
| "parent":{ | |
| "@foreignKey":"system_role_user_object_role_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"user_object_role", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| "primaryKey":{ | |
| "@column":"user_object_role_id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"4" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"tag_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_tag_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"name" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_tag_name" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"name" | |
| }, | |
| "@unique":"true", | |
| "@name":"tag_name_key" | |
| } | |
| ], | |
| "@name":"tag", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":[ | |
| { | |
| "@foreignKey":"package_tag_tag_id_fkey", | |
| "@column":"tag_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_tag", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_tag_revision_tag_id_fkey", | |
| "@column":"tag_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_tag_revision", | |
| "@implied":"false" | |
| } | |
| ], | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"name", | |
| "@nullable":"false", | |
| "@size":"100", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"varchar", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"3" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"task_status_pkey" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"entity_id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"task_type" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"key" | |
| } | |
| ], | |
| "@unique":"true", | |
| "@name":"task_status_entity_id_task_type_key_key" | |
| } | |
| ], | |
| "@name":"task_status", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"entity_id", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"entity_type", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"task_type", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"key", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"value", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"state", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"error", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"last_updated", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"0" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"user_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"openid" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_openid" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_user_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"name" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_user_name" | |
| }, | |
| { | |
| "@unique":"false", | |
| "@name":"idx_user_name_index" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"name" | |
| }, | |
| "@unique":"true", | |
| "@name":"user_name_key" | |
| } | |
| ], | |
| "@name":"user", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":[ | |
| { | |
| "@foreignKey":"authorization_group_user_user_id_fkey", | |
| "@column":"user_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"authorization_group_user", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"rating_user_id_fkey", | |
| "@column":"user_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"rating", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"user_object_role_user_id_fkey", | |
| "@column":"user_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"user_object_role", | |
| "@implied":"false" | |
| } | |
| ], | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"name", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"apikey", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"6", | |
| "@name":"created", | |
| "@nullable":"true", | |
| "@size":"29", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"timestamp", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"about", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"openid", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"5", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"password", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"6", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"fullname", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"7", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"email", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"8", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"reset_key", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"9", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"9" | |
| }, | |
| { | |
| "index":[ | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"true", | |
| "@name":"user_object_role_pkey" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"context" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_uor_context" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_uor_id" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"role" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_uor_role" | |
| }, | |
| { | |
| "column":{ | |
| "@ascending":"true", | |
| "@name":"user_id" | |
| }, | |
| "@unique":"false", | |
| "@name":"idx_uor_user_id" | |
| }, | |
| { | |
| "column":[ | |
| { | |
| "@ascending":"true", | |
| "@name":"user_id" | |
| }, | |
| { | |
| "@ascending":"true", | |
| "@name":"role" | |
| } | |
| ], | |
| "@unique":"false", | |
| "@name":"idx_uor_user_id_role" | |
| } | |
| ], | |
| "@name":"user_object_role", | |
| "column":[ | |
| { | |
| "@digits":"0", | |
| "@name":"id", | |
| "@nullable":"false", | |
| "child":[ | |
| { | |
| "@foreignKey":"authorization_group_role_user_object_role_id_fkey", | |
| "@column":"user_object_role_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"authorization_group_role", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"group_role_user_object_role_id_fkey", | |
| "@column":"user_object_role_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"group_role", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"package_role_user_object_role_id_fkey", | |
| "@column":"user_object_role_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"package_role", | |
| "@implied":"false" | |
| }, | |
| { | |
| "@foreignKey":"system_role_user_object_role_id_fkey", | |
| "@column":"user_object_role_id", | |
| "@onDeleteCascade":"false", | |
| "@table":"system_role", | |
| "@implied":"false" | |
| } | |
| ], | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"0", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"user_id", | |
| "parent":{ | |
| "@foreignKey":"user_object_role_user_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"user", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"1", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"context", | |
| "@nullable":"false", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"2", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"role", | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"3", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| }, | |
| { | |
| "@digits":"0", | |
| "@name":"authorized_group_id", | |
| "parent":{ | |
| "@foreignKey":"user_object_role_authorized_group_id_fkey", | |
| "@column":"id", | |
| "@onDeleteCascade":"false", | |
| "@table":"authorization_group", | |
| "@implied":"false" | |
| }, | |
| "@nullable":"true", | |
| "@size":"2147483647", | |
| "@remarks":"", | |
| "@id":"4", | |
| "@type":"text", | |
| "@autoUpdated":"false" | |
| } | |
| ], | |
| "primaryKey":{ | |
| "@column":"id", | |
| "@sequenceNumberInPK":"1" | |
| }, | |
| "@remarks":"", | |
| "@type":"TABLE", | |
| "@schema":"public", | |
| "@numRows":"25" | |
| } | |
| ] | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment