! &e8c82084-911e-43a4-adf0-5411bb909a4a all-table-columns: ! - ! &fc9097ca-bfb0-4bc3-9717-1a2ee3904552 name: ID short-name: AUTHORS.ID full-name: PUBLIC.BOOKS.AUTHORS.ID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: ! &95ab46a8-7604-4de2-8b07-eabf736af81a name: INTEGER full-name: INTEGER auto-incrementable: true case-sensitive: false database-specific-type-name: INTEGER enumerated: false fixed-precision-scale: false java-sql-type: ! &7860a55e-68c5-43aa-a727-a814b608bcaa name: INTEGER default-mapped-class: java.lang.Integer java-sql-type-group: integer vendor: java.sql vendor-type-number: 4 maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 32 schema: ! {} &265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: INTEGER type: system type-mapped-class-name: java.lang.Integer unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: ! &69115558-04df-4b38-bc27-b82c4e3e59a1 name: BOOKS full-name: PUBLIC.BOOKS catalog-name: PUBLIC significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &516bd94e-0634-4370-be45-50c789e8729e name: ID short-name: AUTHORSLIST.ID full-name: PUBLIC.BOOKS.AUTHORSLIST.ID attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &5c86d315-9295-4cf8-8292-b43802837ad8 name: BOOKID short-name: BOOKAUTHORS.BOOKID full-name: PUBLIC.BOOKS.BOOKAUTHORS.BOOKID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: true schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &9a441767-d861-4b18-bd07-c9766dbcdb2e name: ID short-name: BOOKS.ID full-name: PUBLIC.BOOKS.BOOKS.ID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: Unique (internal) id for book SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true remarks: Unique (internal) id for book schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &b7b068d1-fd57-4e85-a9b4-3b65cb2c8773 name: Id short-name: '"Celebrities"."Id"' full-name: PUBLIC.BOOKS."Celebrities"."Id" attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &af75a4dd-786d-4e4e-9719-9978cbd0aa94 name: Celebrity Id short-name: '"Celebrity Updates"."Celebrity Id"' full-name: PUBLIC.BOOKS."Celebrity Updates"."Celebrity Id" attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &af39b184-264b-4ecf-8ba9-bd182f323546 name: ID short-name: COUPONS.ID full-name: PUBLIC.BOOKS.COUPONS.ID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &aa1180ad-cffe-40c8-bcb0-c722962e7fca name: CUSTOMERID short-name: CUSTOMERDATA.CUSTOMERID full-name: PUBLIC.BOOKS.CUSTOMERDATA.CUSTOMERID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &8ed58ef5-63df-4acc-8089-2444c8626774 name: ID short-name: CUSTOMERS.ID full-name: PUBLIC.BOOKS.CUSTOMERS.ID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &a18d596b-e302-432c-82df-bf8fbe00f08d name: ID short-name: PUBLISHERS.ID full-name: PUBLIC.BOOKS.PUBLISHERS.ID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: Unique (internal) id for book publisher SQL_DATA_TYPE: 4 auto-incremented: true column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true remarks: Unique (internal) id for book publisher schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &1f368400-9a4d-4df8-aeb3-2abe6d799cab name: ΜΟΝΑΔΙΚΌΣ short-name: ΒΙΒΛΊΑ.ΜΟΝΑΔΙΚΌΣ full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΜΟΝΑΔΙΚΌΣ attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 5 auto-incremented: false column-data-type: ! &d7d53b23-90d2-40b4-9dfd-2c723f1217d8 name: SMALLINT full-name: SMALLINT auto-incrementable: true case-sensitive: false database-specific-type-name: SMALLINT enumerated: false fixed-precision-scale: false java-sql-type: ! &6d7f037b-8a66-4d74-9dba-5280191f487e name: SMALLINT default-mapped-class: java.lang.Integer java-sql-type-group: integer vendor: java.sql vendor-type-number: 5 maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 16 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: SMALLINT type: system type-mapped-class-name: java.lang.Integer unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 16 type: *d7d53b23-90d2-40b4-9dfd-2c723f1217d8 - ! &df062cb2-d09c-4f35-a2f2-fca3d85a97fd name: WRITERID short-name: EXTRA_PK.WRITERID full-name: PUBLIC.FOR_LINT.EXTRA_PK.WRITERID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 25 auto-incremented: false column-data-type: ! &b22e5c40-f8f0-49bf-9f98-71acbc3f752d name: BIGINT full-name: BIGINT auto-incrementable: true case-sensitive: false database-specific-type-name: BIGINT enumerated: false fixed-precision-scale: false java-sql-type: ! &ef120fb3-68fe-436a-b23a-e8c62f0c76bd name: BIGINT default-mapped-class: java.lang.Long java-sql-type-group: integer vendor: java.sql vendor-type-number: -5 maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 64 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: BIGINT type: system type-mapped-class-name: java.lang.Long unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: ! &50571370-29a6-46ba-af20-d540170d65cf name: FOR_LINT full-name: PUBLIC.FOR_LINT catalog-name: PUBLIC significant: true size: 64 type: *b22e5c40-f8f0-49bf-9f98-71acbc3f752d - ! &81e96953-01be-4073-8d7a-21a52deeb1ec name: ID short-name: WRITERS.ID full-name: PUBLIC.FOR_LINT.WRITERS.ID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 25 auto-incremented: false column-data-type: *b22e5c40-f8f0-49bf-9f98-71acbc3f752d column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 64 type: *b22e5c40-f8f0-49bf-9f98-71acbc3f752d - ! &41cbf72d-96c0-47f1-8fa4-2fa2d3d6a7fe name: Global Count short-name: '"Global Counts"."Global Count"' full-name: PUBLIC.FOR_LINT."Global Counts"."Global Count" attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &c62241a4-53a6-461d-b153-a49498bfd57a name: ID short-name: PUBLICATIONS.ID full-name: PUBLIC.FOR_LINT.PUBLICATIONS.ID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &982641ae-4988-465f-b265-401f5ff3e10a name: PUBLICATIONID short-name: PUBLICATIONWRITERS.PUBLICATIONID full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &b2325c37-9956-4efb-9b42-2d1ecc07eb17 name: ID short-name: SELFREFERENCE.ID full-name: PUBLIC.FOR_LINT.SELFREFERENCE.ID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: true part-of-unique-index: true schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &0c4da277-4e50-4647-848f-bad21985c6b9 name: SALESDATAID short-name: SALESDATA.SALESDATAID full-name: PUBLIC."PUBLISHER SALES".SALESDATA.SALESDATAID attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: true schema: ! &1f19bea6-f03f-4259-be6c-2b1a8aad373f name: PUBLISHER SALES full-name: PUBLIC."PUBLISHER SALES" catalog-name: PUBLIC significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &72dde35b-3832-49b1-9aed-08aca391d9c9 name: CITY short-name: REGIONS.CITY full-name: PUBLIC."PUBLISHER SALES".REGIONS.CITY attribute: true attributes: ! CHAR_OCTET_LENGTH: 50 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: ! &563251d5-275e-453f-9b2d-113b04af8880 name: VARCHAR full-name: VARCHAR auto-incrementable: false case-sensitive: true create-parameters: LENGTH database-specific-type-name: VARCHAR enumerated: false fixed-precision-scale: false java-sql-type: ! &10cf783b-d5c7-467f-b920-80850deb3b21 name: VARCHAR default-mapped-class: java.lang.String java-sql-type-group: character vendor: java.sql vendor-type-number: 12 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable standard-type-name: VARCHAR type: system type-mapped-class-name: java.lang.String unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: false size: 50 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (50) - ! &2bc97408-8ced-4806-bfb7-b97ed5735e56 name: POSTALCODE short-name: SALES.POSTALCODE full-name: PUBLIC."PUBLISHER SALES".SALES.POSTALCODE attribute: false attributes: ! CHAR_OCTET_LENGTH: 10 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: true size: 10 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (10) - ! &957115f9-e344-45ee-bd49-4ae94182206d name: DATA short-name: COUPONS.DATA full-name: PUBLIC.BOOKS.COUPONS.DATA attribute: true attributes: ! CHAR_OCTET_LENGTH: 1073741824 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 40 auto-incremented: false column-data-type: ! &9cf061a4-08b4-4d8e-b6a3-acd547efa671 name: CLOB full-name: CLOB auto-incrementable: false case-sensitive: true create-parameters: LENGTH database-specific-type-name: CLOB enumerated: false fixed-precision-scale: false java-sql-type: ! &e114c436-1487-4de8-a9bd-bde7a1329717 name: CLOB default-mapped-class: java.sql.Clob java-sql-type-group: large_object vendor: java.sql vendor-type-number: 2005 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: not searchable standard-type-name: CLOB type: system type-mapped-class-name: java.sql.Clob unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 1073741824 type: *9cf061a4-08b4-4d8e-b6a3-acd547efa671 - ! &015a13d1-df6f-4809-996c-11fb23497d71 name: AUTHORID short-name: BOOKAUTHORS.AUTHORID full-name: PUBLIC.BOOKS.BOOKAUTHORS.AUTHORID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: true schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &45c15214-0bf7-4fa6-bf47-528d0f0c3765 name: DATAID short-name: CUSTOMERDATA.DATAID full-name: PUBLIC.BOOKS.CUSTOMERDATA.DATAID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &d74c1228-66d8-443f-a693-368dbae4b002 name: FIRSTNAME short-name: AUTHORS.FIRSTNAME full-name: PUBLIC.BOOKS.AUTHORS.FIRSTNAME attribute: true attributes: ! CHAR_OCTET_LENGTH: 20 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 20 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (20) - ! &77f128fc-e562-4ca4-bc42-a121c0a14b96 name: FIRSTNAME short-name: AUTHORSLIST.FIRSTNAME full-name: PUBLIC.BOOKS.AUTHORSLIST.FIRSTNAME attribute: true attributes: ! CHAR_OCTET_LENGTH: 20 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 20 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (20) - ! &094771b9-67b2-4762-8a08-4b4a9706aad9 name: TITLE short-name: BOOKS.TITLE full-name: PUBLIC.BOOKS.BOOKS.TITLE attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: Book title SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false remarks: Book title schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &a2b6f7a2-b93c-4d47-ac58-a70f9233f7c0 name: NAME short-name: '"Celebrities".NAME' full-name: PUBLIC.BOOKS."Celebrities".NAME attribute: true attributes: ! CHAR_OCTET_LENGTH: 20 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 20 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (20) - ! &2602964d-f34f-4aa6-b8d2-b69c51c5d60e name: UPDATE short-name: '"Celebrity Updates"."UPDATE"' full-name: PUBLIC.BOOKS."Celebrity Updates"."UPDATE" attribute: true attributes: ! CHAR_OCTET_LENGTH: 20 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 20 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (20) - ! &0a64cba3-1e2d-4bda-a5b1-bebbe3bcb12d name: PUBLISHER short-name: PUBLISHERS.PUBLISHER full-name: PUBLIC.BOOKS.PUBLISHERS.PUBLISHER attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: Name of book publisher SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false remarks: Name of book publisher schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &762b1d21-0bae-476c-9122-5ef16f011b3c name: ΤΊΤΛΟΣ short-name: ΒΙΒΛΊΑ.ΤΊΤΛΟΣ full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΤΊΤΛΟΣ attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &8852eab4-226b-4a59-bbef-d79d9ce33345 name: FIRSTNAME short-name: CUSTOMERS.FIRSTNAME full-name: PUBLIC.BOOKS.CUSTOMERS.FIRSTNAME attribute: true attributes: ! CHAR_OCTET_LENGTH: 100 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SOURCE_DATA_TYPE: 12 SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: ! &ba227aa4-5ce1-47b5-b1a9-8c60d4d36798 name: NAME_TYPE full-name: PUBLIC.BOOKS.NAME_TYPE attributes: ! REMARKS: "" TYPE_CAT: PUBLIC TYPE_SCHEM: BOOKS auto-incrementable: false case-sensitive: false database-specific-type-name: NAME_TYPE enumerated: false fixed-precision-scale: false java-sql-type: ! &caf859cc-0c79-4ae6-a0d8-ad247854e7a2 name: DISTINCT default-mapped-class: java.lang.Object java-sql-type-group: object vendor: java.sql vendor-type-number: 2001 maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 searchable: not searchable standard-type-name: DISTINCT type: user_defined type-mapped-class-name: java.lang.String unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 100 type: *ba227aa4-5ce1-47b5-b1a9-8c60d4d36798 - ! &887b1924-fa0b-4203-b08a-86b3a77753f6 name: WRITERID short-name: PUBLICATIONWRITERS.WRITERID full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS.WRITERID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 25 auto-incremented: false column-data-type: *b22e5c40-f8f0-49bf-9f98-71acbc3f752d column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 64 type: *b22e5c40-f8f0-49bf-9f98-71acbc3f752d - ! &718d4c6d-0a69-4a86-bf2e-ba284eca2ef5 name: PUBLICATIONID short-name: EXTRA_PK.PUBLICATIONID full-name: PUBLIC.FOR_LINT.EXTRA_PK.PUBLICATIONID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &d695f683-4b0c-4914-bf1e-ee8bb9c81421 name: TITLE short-name: PUBLICATIONS.TITLE full-name: PUBLIC.FOR_LINT.PUBLICATIONS.TITLE attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: Publication title SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false remarks: Publication title schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &b56b8286-194b-430b-8efe-2a6278449454 name: TITLE short-name: SELFREFERENCE.TITLE full-name: PUBLIC.FOR_LINT.SELFREFERENCE.TITLE attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &47eb7efd-df59-4f14-a9d2-9bb47fe65391 name: FIRSTNAME short-name: WRITERS.FIRSTNAME full-name: PUBLIC.FOR_LINT.WRITERS.FIRSTNAME attribute: true attributes: ! CHAR_OCTET_LENGTH: 20 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 20 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (20) - ! &f9a4c48b-5095-4299-bf2d-e07beb8051ec name: YEARLYAMOUNT short-name: SALESDATA.YEARLYAMOUNT full-name: PUBLIC."PUBLISHER SALES".SALESDATA.YEARLYAMOUNT attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 8 auto-incremented: false column-data-type: ! &0950bbd8-8008-40df-9f0f-7f7495b9e46b name: DOUBLE full-name: DOUBLE auto-incrementable: false case-sensitive: false database-specific-type-name: DOUBLE enumerated: false fixed-precision-scale: false java-sql-type: ! &adccb201-d133-4d62-96d2-2bb4559af626 name: DOUBLE default-mapped-class: java.lang.Double java-sql-type-group: real vendor: java.sql vendor-type-number: 8 maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 64 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: DOUBLE type: system type-mapped-class-name: java.lang.Double unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: false size: 64 type: *0950bbd8-8008-40df-9f0f-7f7495b9e46b width: "(64, 0)" - ! &ee4fcd34-e584-48ef-a132-50b00ebc8713 name: STATE short-name: REGIONS.STATE full-name: PUBLIC."PUBLISHER SALES".REGIONS.STATE attribute: true attributes: ! CHAR_OCTET_LENGTH: 2 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: false size: 2 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (2) - ! &53348b1d-451f-4be9-be60-8fcbb5a0af71 name: COUNTRY short-name: SALES.COUNTRY full-name: PUBLIC."PUBLISHER SALES".SALES.COUNTRY attribute: false attributes: ! CHAR_OCTET_LENGTH: 50 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: true size: 50 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (50) - ! &8bd0e9be-3062-4dda-b238-74c4ed8a41e6 name: LASTNAME short-name: AUTHORS.LASTNAME full-name: PUBLIC.BOOKS.AUTHORS.LASTNAME attribute: true attributes: ! CHAR_OCTET_LENGTH: 20 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 20 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (20) - ! &64e383ef-11c0-44a0-9189-74c51e8ab008 name: LASTNAME short-name: AUTHORSLIST.LASTNAME full-name: PUBLIC.BOOKS.AUTHORSLIST.LASTNAME attribute: true attributes: ! CHAR_OCTET_LENGTH: 20 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 20 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (20) - ! &3dbc6622-6f77-4bd3-90c7-7a015a7c1bfc name: SOMEDATA short-name: BOOKAUTHORS.SOMEDATA full-name: PUBLIC.BOOKS.BOOKAUTHORS.SOMEDATA attribute: true attributes: ! CHAR_OCTET_LENGTH: 30 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 30 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (30) - ! &c1076f8c-6d20-4809-a8be-e2c32323df0f name: DESCRIPTION short-name: BOOKS.DESCRIPTION full-name: PUBLIC.BOOKS.BOOKS.DESCRIPTION attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: |- Book description (Usually the blurb from the book jacket or promotional materials) SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false remarks: |- Book description (Usually the blurb from the book jacket or promotional materials) schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &26e94b32-dc33-4536-9696-8699646d0a8c name: ΠΕΡΙΓΡΑΦΉ short-name: ΒΙΒΛΊΑ.ΠΕΡΙΓΡΑΦΉ full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΠΕΡΙΓΡΑΦΉ attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &e9df2ab0-843e-44a7-9e9f-e2173c2d775a name: COUPONS short-name: COUPONS.COUPONS full-name: PUBLIC.BOOKS.COUPONS.COUPONS attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 50 auto-incremented: false column-data-type: ! &c4654859-f317-4f67-9d25-9c1c6092f038 name: INTEGER ARRAY full-name: PUBLIC.BOOKS."INTEGER ARRAY" auto-incrementable: false case-sensitive: false database-specific-type-name: INTEGER ARRAY enumerated: false fixed-precision-scale: false java-sql-type: ! &606dd276-98ac-444e-8591-9f6a1aa9e9f7 name: ARRAY default-mapped-class: java.sql.Array java-sql-type-group: object vendor: java.sql vendor-type-number: 2003 maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 searchable: not searchable standard-type-name: ARRAY type: user_defined type-mapped-class-name: java.sql.Array unsigned: false column-data-type-known: true decimal-digits: 0 default-value: "ARRAY[]" generated: false hidden: false nullable: true ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 0 type: *c4654859-f317-4f67-9d25-9c1c6092f038 - ! &c38a2b8b-2505-49bd-b235-cb246d9263de name: LASTNAME short-name: CUSTOMERS.LASTNAME full-name: PUBLIC.BOOKS.CUSTOMERS.LASTNAME attribute: true attributes: ! CHAR_OCTET_LENGTH: 100 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SOURCE_DATA_TYPE: 12 SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *ba227aa4-5ce1-47b5-b1a9-8c60d4d36798 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 100 type: *ba227aa4-5ce1-47b5-b1a9-8c60d4d36798 - ! &2723d231-87c0-415e-b7e1-2c05a0dfc489 name: DATA short-name: CUSTOMERDATA.DATA full-name: PUBLIC.BOOKS.CUSTOMERDATA.DATA attribute: true attributes: ! CHAR_OCTET_LENGTH: 20 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SOURCE_DATA_TYPE: 12 SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: ! &911952a3-50f4-4ea4-9531-141b085eb0f0 name: VALID_STRING full-name: PUBLIC.BOOKS.VALID_STRING auto-incrementable: false case-sensitive: false database-specific-type-name: VALID_STRING enumerated: false fixed-precision-scale: false java-sql-type: *10cf783b-d5c7-467f-b920-80850deb3b21 maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 searchable: not searchable standard-type-name: VARCHAR type: user_defined type-mapped-class-name: java.lang.String unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 20 type: *911952a3-50f4-4ea4-9531-141b085eb0f0 width: (20) - ! &6a2cdd5e-586b-48a0-bac5-35a9e9fd99bc name: ID short-name: EXTRA_PK.ID full-name: PUBLIC.FOR_LINT.EXTRA_PK.ID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &1de903b2-7a81-4ce1-9dd3-032a4f115a0b name: DESCRIPTION short-name: PUBLICATIONS.DESCRIPTION full-name: PUBLIC.FOR_LINT.PUBLICATIONS.DESCRIPTION attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &6eb8c9b2-1956-483b-b382-2d5968bbdaf9 name: LASTNAME short-name: WRITERS.LASTNAME full-name: PUBLIC.FOR_LINT.WRITERS.LASTNAME attribute: true attributes: ! CHAR_OCTET_LENGTH: 20 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 20 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (20) - ! &3c5f46ec-03ec-4113-8f9c-0da96677c2b7 name: BOOKID short-name: SALES.BOOKID full-name: PUBLIC."PUBLISHER SALES".SALES.BOOKID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 3 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &382d482a-f6d8-4ac7-ab80-03c6be211cdd name: POSTALCODE short-name: REGIONS.POSTALCODE full-name: PUBLIC."PUBLISHER SALES".REGIONS.POSTALCODE attribute: false attributes: ! CHAR_OCTET_LENGTH: 10 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: true size: 10 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (10) - ! &4ecd4746-6800-43f4-a7b3-a2f946dcc640 name: PUBLISHERID short-name: BOOKS.PUBLISHERID full-name: PUBLIC.BOOKS.BOOKS.PUBLISHERID attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: Foreign key to the book publisher SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 4 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false remarks: Foreign key to the book publisher schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &159f4082-50e0-4d60-b652-4ecdb7c16d1e name: ΕΚΔΌΤΗΣ short-name: ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 5 auto-incremented: false column-data-type: *d7d53b23-90d2-40b4-9dfd-2c723f1217d8 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 4 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 16 type: *d7d53b23-90d2-40b4-9dfd-2c723f1217d8 - ! &15ef2b47-8ad1-4967-b952-66d970ec6f6b name: ADDRESS1 short-name: AUTHORS.ADDRESS1 full-name: PUBLIC.BOOKS.AUTHORS.ADDRESS1 attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 4 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &10a34180-cc8a-478c-b3de-c4c2b7fbf806 name: AGE short-name: CUSTOMERS.AGE full-name: PUBLIC.BOOKS.CUSTOMERS.AGE attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SOURCE_DATA_TYPE: 5 SQL_DATA_TYPE: 5 auto-incremented: false column-data-type: ! &5d14174d-364f-4b4e-8928-639f687349b9 name: AGE_TYPE full-name: PUBLIC.BOOKS.AGE_TYPE attributes: ! REMARKS: "" TYPE_CAT: PUBLIC TYPE_SCHEM: BOOKS auto-incrementable: false base-type: *d7d53b23-90d2-40b4-9dfd-2c723f1217d8 case-sensitive: false database-specific-type-name: AGE_TYPE enumerated: false fixed-precision-scale: false java-sql-type: *caf859cc-0c79-4ae6-a0d8-ad247854e7a2 maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 searchable: not searchable standard-type-name: DISTINCT type: user_defined type-mapped-class-name: java.lang.Integer unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 4 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 16 type: *5d14174d-364f-4b4e-8928-639f687349b9 - ! &6a037254-c848-42d7-9e3e-ea8eb972bc6e name: BOOKS short-name: COUPONS.BOOKS full-name: PUBLIC.BOOKS.COUPONS.BOOKS attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 50 auto-incremented: false column-data-type: ! &5ed5d2a2-ba47-415c-859e-179c0075101d name: "VARCHAR(20) ARRAY[10]" full-name: "PUBLIC.BOOKS.\"VARCHAR(20) ARRAY[10]\"" auto-incrementable: false case-sensitive: false database-specific-type-name: "VARCHAR(20) ARRAY[10]" enumerated: false fixed-precision-scale: false java-sql-type: *606dd276-98ac-444e-8591-9f6a1aa9e9f7 maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 searchable: not searchable standard-type-name: ARRAY type: user_defined type-mapped-class-name: java.sql.Array unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 4 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 0 type: *5ed5d2a2-ba47-415c-859e-179c0075101d - ! &0853f52d-27f3-48c3-849a-4bda3f3fa8e5 name: WRITERID short-name: PUBLICATIONS.WRITERID full-name: PUBLIC.FOR_LINT.PUBLICATIONS.WRITERID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 25 auto-incremented: false column-data-type: *b22e5c40-f8f0-49bf-9f98-71acbc3f752d column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 4 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 64 type: *b22e5c40-f8f0-49bf-9f98-71acbc3f752d - ! &fe86e3dd-1b71-46d7-b6af-1d3c47eb144c name: ADDRESS1 short-name: WRITERS.ADDRESS1 full-name: PUBLIC.FOR_LINT.WRITERS.ADDRESS1 attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 4 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &eb2c0a61-fc55-48fc-8c83-8caa7530a097 name: COUPON_ID short-name: SALES.COUPON_ID full-name: PUBLIC."PUBLISHER SALES".SALES.COUPON_ID attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 4 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: false size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &d41fea5c-1a31-4b1c-aac6-b985791db3eb name: COUNTRY short-name: REGIONS.COUNTRY full-name: PUBLIC."PUBLISHER SALES".REGIONS.COUNTRY attribute: false attributes: ! CHAR_OCTET_LENGTH: 50 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 4 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: true size: 50 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (50) - ! &a89a79d2-8ea4-40c2-9ed5-1fc90982264e name: PUBLICATIONDATE short-name: BOOKS.PUBLICATIONDATE full-name: PUBLIC.BOOKS.BOOKS.PUBLICATIONDATE attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: Book publication date SQL_DATA_TYPE: 91 SQL_DATETIME_SUB: 1 auto-incremented: false column-data-type: ! &089e74f2-493e-4796-b386-7465a861a76e name: DATE full-name: DATE auto-incrementable: false case-sensitive: false database-specific-type-name: DATE enumerated: false fixed-precision-scale: false java-sql-type: ! &497e5fde-4791-4dd9-82e8-037a1277a786 name: DATE default-mapped-class: java.sql.Date java-sql-type-group: temporal vendor: java.sql vendor-type-number: 91 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: DATE type: system type-mapped-class-name: java.sql.Date unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 5 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false remarks: Book publication date schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 10 type: *089e74f2-493e-4796-b386-7465a861a76e - ! &4734be87-9fba-4978-bc0f-2a8d5cb7440a name: ADDRESS2 short-name: AUTHORS.ADDRESS2 full-name: PUBLIC.BOOKS.AUTHORS.ADDRESS2 attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 5 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &2d446134-fae7-411c-9879-9f5dadbebcf1 name: PUBLICATIONDATE short-name: PUBLICATIONS.PUBLICATIONDATE full-name: PUBLIC.FOR_LINT.PUBLICATIONS.PUBLICATIONDATE attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 91 SQL_DATETIME_SUB: 1 auto-incremented: false column-data-type: *089e74f2-493e-4796-b386-7465a861a76e column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 5 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 10 type: *089e74f2-493e-4796-b386-7465a861a76e - ! &49824beb-a915-429e-848a-d9a5c55fdaab name: ADDRESS2 short-name: WRITERS.ADDRESS2 full-name: PUBLIC.FOR_LINT.WRITERS.ADDRESS2 attribute: true attributes: ! CHAR_OCTET_LENGTH: 255 IS_GENERATED: NEVER IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 default-value: "NULL" generated: false hidden: false nullable: false ordinal-position: 5 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 255 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (255) - ! &7b2acba9-c8c0-4b0c-b287-a4fff25562c1 name: PERIODENDDATE short-name: SALES.PERIODENDDATE full-name: PUBLIC."PUBLISHER SALES".SALES.PERIODENDDATE attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 91 SQL_DATETIME_SUB: 1 auto-incremented: false column-data-type: *089e74f2-493e-4796-b386-7465a861a76e column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 5 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: false size: 10 type: *089e74f2-493e-4796-b386-7465a861a76e - ! &50a7c21f-18a5-42b9-9afb-cff234e4d53a name: PRICE short-name: BOOKS.PRICE full-name: PUBLIC.BOOKS.BOOKS.PRICE attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: Current price for the book SQL_DATA_TYPE: 8 auto-incremented: false column-data-type: *0950bbd8-8008-40df-9f0f-7f7495b9e46b column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 6 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false remarks: Current price for the book schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: false size: 64 type: *0950bbd8-8008-40df-9f0f-7f7495b9e46b width: "(64, 0)" - ! &49f5407c-8ad2-4693-bc07-66be810dace1 name: CITY short-name: AUTHORS.CITY full-name: PUBLIC.BOOKS.AUTHORS.CITY attribute: true attributes: ! CHAR_OCTET_LENGTH: 50 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 6 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 50 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (50) - ! &506b7ec5-c1ea-4e85-acbe-52ddd06799a5 name: PRICE short-name: PUBLICATIONS.PRICE full-name: PUBLIC.FOR_LINT.PUBLICATIONS.PRICE attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 8 auto-incremented: false column-data-type: *0950bbd8-8008-40df-9f0f-7f7495b9e46b column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 6 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 64 type: *0950bbd8-8008-40df-9f0f-7f7495b9e46b width: "(64, 0)" - ! &2f6e5a2c-7e10-4c38-a0b8-009133c66229 name: CITY short-name: WRITERS.CITY full-name: PUBLIC.FOR_LINT.WRITERS.CITY attribute: true attributes: ! CHAR_OCTET_LENGTH: 50 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 6 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 50 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (50) - ! &e2660809-da82-4bbb-b74d-449d5c60f858 name: TOTALAMOUNT short-name: SALES.TOTALAMOUNT full-name: PUBLIC."PUBLISHER SALES".SALES.TOTALAMOUNT attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 8 auto-incremented: false column-data-type: *0950bbd8-8008-40df-9f0f-7f7495b9e46b column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 6 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: false size: 64 type: *0950bbd8-8008-40df-9f0f-7f7495b9e46b width: "(64, 0)" - ! &1df5cd07-8cdf-4233-8742-0a897358b87e name: STATE short-name: AUTHORS.STATE full-name: PUBLIC.BOOKS.AUTHORS.STATE attribute: true attributes: ! CHAR_OCTET_LENGTH: 2 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 1 auto-incremented: false column-data-type: ! &1d78a7aa-1d59-4185-a912-e32f6ae2b641 name: CHARACTER full-name: CHARACTER auto-incrementable: false case-sensitive: true create-parameters: LENGTH database-specific-type-name: CHARACTER enumerated: false fixed-precision-scale: false java-sql-type: ! &79ac68cf-a16f-4a0a-9639-e0de9cf6f26b name: CHAR default-mapped-class: java.lang.String java-sql-type-group: character vendor: java.sql vendor-type-number: 1 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable standard-type-name: CHAR type: system type-mapped-class-name: java.lang.String unsigned: false column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 7 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 2 type: *1d78a7aa-1d59-4185-a912-e32f6ae2b641 width: (2) - ! &ea2b1e3c-1ced-4e15-b8c0-f072e220ae10 name: PREVIOUSEDITIONID short-name: BOOKS.PREVIOUSEDITIONID full-name: PUBLIC.BOOKS.BOOKS.PREVIOUSEDITIONID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 7 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: true part-of-unique-index: true schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &c77103b0-2118-45ec-8361-a89f85b4f10d name: UPDATE short-name: PUBLICATIONS."UPDATE" full-name: PUBLIC.FOR_LINT.PUBLICATIONS."UPDATE" attribute: true attributes: ! CHAR_OCTET_LENGTH: 1073741824 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 40 auto-incremented: false column-data-type: *9cf061a4-08b4-4d8e-b6a3-acd547efa671 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 7 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 1073741824 type: *9cf061a4-08b4-4d8e-b6a3-acd547efa671 - ! &5c3e9084-7f2e-4d6a-bd5c-4afddfdfd916 name: STATE short-name: WRITERS.STATE full-name: PUBLIC.FOR_LINT.WRITERS.STATE attribute: true attributes: ! CHAR_OCTET_LENGTH: 2 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 7 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 2 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (2) - ! &3c7679e9-309f-4f17-b21c-c75afe145006 name: SALESDATAID short-name: SALES.SALESDATAID full-name: PUBLIC."PUBLISHER SALES".SALES.SALESDATAID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 7 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f significant: true size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &4ef52e23-aa67-4446-a1c2-3f72589e6819 name: POSTALCODE short-name: AUTHORS.POSTALCODE full-name: PUBLIC.BOOKS.AUTHORS.POSTALCODE attribute: true attributes: ! CHAR_OCTET_LENGTH: 10 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 8 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 10 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (10) - ! &3ab21215-9578-4b03-9185-79e2605b047e name: PRESS_RELEASE short-name: PUBLICATIONS.PRESS_RELEASE full-name: PUBLIC.FOR_LINT.PUBLICATIONS.PRESS_RELEASE attribute: true attributes: ! CHAR_OCTET_LENGTH: 1073741824 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 40 auto-incremented: false column-data-type: *9cf061a4-08b4-4d8e-b6a3-acd547efa671 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 8 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 1073741824 type: *9cf061a4-08b4-4d8e-b6a3-acd547efa671 - ! &c78869d1-9149-4772-8922-449422f13779 name: POSTALCODE short-name: WRITERS.POSTALCODE full-name: PUBLIC.FOR_LINT.WRITERS.POSTALCODE attribute: true attributes: ! CHAR_OCTET_LENGTH: 10 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 8 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 10 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (10) - ! &f23ec896-dddd-4842-8971-eecb737f31b0 name: COUNTRY short-name: AUTHORS.COUNTRY full-name: PUBLIC.BOOKS.AUTHORS.COUNTRY attribute: true attributes: ! CHAR_OCTET_LENGTH: 50 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 default-value: '''USA''' generated: false hidden: false nullable: true ordinal-position: 9 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 significant: true size: 50 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (50) - ! &4837f923-ff7d-4897-a5cd-71a55154698b name: COUNTRY short-name: WRITERS.COUNTRY full-name: PUBLIC.FOR_LINT.WRITERS.COUNTRY attribute: true attributes: ! CHAR_OCTET_LENGTH: 50 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 default-value: "NULL" generated: false hidden: false nullable: true ordinal-position: 9 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: true schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 50 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (50) - ! &a2a5de8c-ebfe-4344-b162-93672a722be1 name: PHONE1 short-name: WRITERS.PHONE1 full-name: PUBLIC.FOR_LINT.WRITERS.PHONE1 attribute: true attributes: ! CHAR_OCTET_LENGTH: 10 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 10 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 10 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (10) - ! &fb2bdb99-83a1-4556-889a-dade87810ec2 name: PHONE2 short-name: WRITERS.PHONE2 full-name: PUBLIC.FOR_LINT.WRITERS.PHONE2 attribute: true attributes: ! CHAR_OCTET_LENGTH: 15 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 11 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 15 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (15) - ! &931f37a7-5da0-4e1f-aeb3-655f585e7e26 name: EMAIL1 short-name: WRITERS.EMAIL1 full-name: PUBLIC.FOR_LINT.WRITERS.EMAIL1 attribute: true attributes: ! CHAR_OCTET_LENGTH: 10 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 12 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: true schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 10 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (10) - ! &6e2ac0ab-a35c-4766-a8cc-f36c177b9085 name: EMAIL2 short-name: WRITERS.EMAIL2 full-name: PUBLIC.FOR_LINT.WRITERS.EMAIL2 attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 13 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &2df6af0d-c8ff-4c9b-8085-fd68a048a016 name: FAX short-name: WRITERS.FAX full-name: PUBLIC.FOR_LINT.WRITERS.FAX attribute: true attributes: ! CHAR_OCTET_LENGTH: 10 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 14 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 10 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (10) - ! &ea5e66aa-778c-4d4d-8640-74796da98679 name: FAX3 short-name: WRITERS.FAX3 full-name: PUBLIC.FOR_LINT.WRITERS.FAX3 attribute: true attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "YES" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 4 auto-incremented: false column-data-type: *95ab46a8-7604-4de2-8b07-eabf736af81a column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 15 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 32 type: *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &c3776aa7-04df-49be-bb8c-c703ee177ae2 name: HOMEEMAIL11 short-name: WRITERS.HOMEEMAIL11 full-name: PUBLIC.FOR_LINT.WRITERS.HOMEEMAIL11 attribute: true attributes: ! CHAR_OCTET_LENGTH: 10 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 16 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 10 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (10) - ! &9b984ff0-88e6-4b4e-b436-739c302b8f5a name: HOMEEMAIL12 short-name: WRITERS.HOMEEMAIL12 full-name: PUBLIC.FOR_LINT.WRITERS.HOMEEMAIL12 attribute: true attributes: ! CHAR_OCTET_LENGTH: 10 IS_GENERATED: NEVER IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *563251d5-275e-453f-9b2d-113b04af8880 column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: true ordinal-position: 17 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: false size: 10 type: *563251d5-275e-453f-9b2d-113b04af8880 width: (10) - ! &81830292-b4af-42a4-9906-d13017db60ea name: PUBLICATION_ID short-name: WRITERS.PUBLICATION_ID full-name: PUBLIC.FOR_LINT.WRITERS.PUBLICATION_ID attribute: false attributes: ! CHAR_OCTET_LENGTH: 0 IS_GENERATED: NEVER IS_NULLABLE: "NO" NUM_PREC_RADIX: 2 REMARKS: "" SQL_DATA_TYPE: 25 auto-incremented: false column-data-type: *b22e5c40-f8f0-49bf-9f98-71acbc3f752d column-data-type-known: true decimal-digits: 0 generated: false hidden: false nullable: false ordinal-position: 18 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false schema: *50571370-29a6-46ba-af20-d540170d65cf significant: true size: 64 type: *b22e5c40-f8f0-49bf-9f98-71acbc3f752d catalog: ! &7826b41d-0353-4dd0-950f-90223f22a7b7 name: catalog full-name: catalog crawl-info: ! &dc1e6707-ad6e-46c9-b5a0-5a7f876b2925 crawl-timestamp: 2026-09-29 23:27:44 crawl-timestamp-instant: 2026-09-29T23:27:44.246150029Z database-server-fingerprint: ! ? &df6aec62-0c25-43f3-ac3c-19a7e543ee97 database-system-identifier : hsqldb host-classification: INTERNAL fingerprint: efc4948cfb1d9a17ea2bcb4a436cc5aad22ab646ffe9d67dbca1bfb3e38f9996 confidence: MEDIUM database-version: ! &3f666452-2db5-4f40-b685-e88875ec9dbd name: HSQL Database Engine product-name: HSQL Database Engine product-version: 2.7.4 value: 2.7.4 jdbc-driver-version: ! &c55decb5-19f3-4970-8b0f-6eff0f458e8f name: HSQL Database Engine Driver product-name: HSQL Database Engine Driver product-version: 2.7.4 value: 2.7.4 jvm-version: ! &21f99938-55fd-4412-874d-f3759e14d3ac name: Eclipse Adoptium OpenJDK 64-Bit Server VM product-name: Eclipse Adoptium OpenJDK 64-Bit Server VM product-version: 17.0.20.1+1 value: 17.0.20.1+1 operating-system-version: ! &690cb5d5-01ea-4b3e-837a-5574f6c95d3f name: Linux product-name: Linux product-version: 6.17.0-1022-azure value: 6.17.0-1022-azure run-id: 77917444-e238-4f0d-9bbb-3e01071d35b4 schema-crawler-version: ! &8c494735-4098-4364-93c4-65109644b84c name: SchemaCrawler product-name: SchemaCrawler product-version: 17.15.7 value: 17.15.7 title: Details of Example Database database-info: *3f666452-2db5-4f40-b685-e88875ec9dbd jdbc-driver-info: *c55decb5-19f3-4970-8b0f-6eff0f458e8f schemas: ! - *69115558-04df-4b38-bc27-b82c4e3e59a1 - *50571370-29a6-46ba-af20-d540170d65cf - ! &8f6c25b7-aa8f-42b3-911a-d90ec1a5b8d3 name: INFORMATION_SCHEMA full-name: PUBLIC.INFORMATION_SCHEMA catalog-name: PUBLIC - ! &8a199164-d638-4ab0-9629-2d76cf9986bf name: PUBLIC full-name: PUBLIC.PUBLIC catalog-name: PUBLIC - *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &2d9079fa-a0fa-4701-b343-ca71bdb137b1 name: SYSTEM_LOBS full-name: PUBLIC.SYSTEM_LOBS catalog-name: PUBLIC system-column-data-types: ! - *b22e5c40-f8f0-49bf-9f98-71acbc3f752d - ! &70615de9-c0d1-4c69-a255-aaf5b38eb55d name: BINARY full-name: BINARY auto-incrementable: false case-sensitive: false create-parameters: LENGTH database-specific-type-name: BINARY enumerated: false fixed-precision-scale: false java-sql-type: ! &f028c933-a5c5-4eae-8d93-540823443d6e name: BINARY default-mapped-class: "[B" java-sql-type-group: binary vendor: java.sql vendor-type-number: -2 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable standard-type-name: BINARY type: system type-mapped-class-name: "byte[]" unsigned: false - ! &3572d92d-6db4-459f-be00-98bbb489f418 name: BIT full-name: BIT auto-incrementable: false case-sensitive: false create-parameters: LENGTH database-specific-type-name: BIT enumerated: false fixed-precision-scale: false java-sql-type: ! &604e98ea-62a5-4569-a0e9-aa04470d1c95 name: BIT default-mapped-class: java.lang.Boolean java-sql-type-group: bit vendor: java.sql vendor-type-number: -7 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 1024 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: BIT type: system type-mapped-class-name: java.lang.Boolean unsigned: false - ! &0e605df5-c446-402e-b4fc-59827b6b49f1 name: BLOB full-name: BLOB auto-incrementable: false case-sensitive: false create-parameters: LENGTH database-specific-type-name: BLOB enumerated: false fixed-precision-scale: false java-sql-type: ! &8b8b1f01-d4fe-4268-af94-a77f8c0795f8 name: BLOB default-mapped-class: java.sql.Blob java-sql-type-group: large_object vendor: java.sql vendor-type-number: 2004 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: not searchable standard-type-name: BLOB type: system type-mapped-class-name: java.sql.Blob unsigned: false - ! &5a1e5dfb-ab5c-4fd4-9f25-573d8ebcb35d name: BOOLEAN full-name: BOOLEAN auto-incrementable: false case-sensitive: false database-specific-type-name: BOOLEAN enumerated: false fixed-precision-scale: false java-sql-type: ! &2c38254f-42ac-4fca-a8a1-8f87cf1eb85e name: BOOLEAN default-mapped-class: java.lang.Boolean java-sql-type-group: bit vendor: java.sql vendor-type-number: 16 maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: BOOLEAN type: system type-mapped-class-name: java.lang.Boolean unsigned: false - *1d78a7aa-1d59-4185-a912-e32f6ae2b641 - *9cf061a4-08b4-4d8e-b6a3-acd547efa671 - *089e74f2-493e-4796-b386-7465a861a76e - ! &292a42ab-bf95-4a2e-947a-b08364c4309d name: DECIMAL full-name: DECIMAL auto-incrementable: true case-sensitive: false create-parameters: "PRECISION,SCALE" database-specific-type-name: DECIMAL enumerated: false fixed-precision-scale: true java-sql-type: ! &9d71c51c-f562-41ca-867a-943c426920da name: DECIMAL default-mapped-class: java.math.BigDecimal java-sql-type-group: real vendor: java.sql vendor-type-number: 3 maximum-scale: 32767 minimum-scale: 0 nullable: true num-precision-radix: 10 precision: 2147483647 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: DECIMAL type: system type-mapped-class-name: java.math.BigDecimal unsigned: false - *0950bbd8-8008-40df-9f0f-7f7495b9e46b - ! &789f943e-35b8-411e-9003-79e058269daa name: FLOAT full-name: FLOAT auto-incrementable: false case-sensitive: false database-specific-type-name: FLOAT enumerated: false fixed-precision-scale: false java-sql-type: *adccb201-d133-4d62-96d2-2bb4559af626 maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 64 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: DOUBLE type: system type-mapped-class-name: java.lang.Double unsigned: false - *95ab46a8-7604-4de2-8b07-eabf736af81a - ! &b103aea0-998d-4cc1-877f-a5ba039f0a6d name: NUMERIC full-name: NUMERIC auto-incrementable: true case-sensitive: false create-parameters: "PRECISION,SCALE" database-specific-type-name: NUMERIC enumerated: false fixed-precision-scale: true java-sql-type: ! &8fa9b669-ae6a-45fb-9b02-027c19168d57 name: NUMERIC default-mapped-class: java.math.BigDecimal java-sql-type-group: real vendor: java.sql vendor-type-number: 2 maximum-scale: 32767 minimum-scale: 0 nullable: true num-precision-radix: 10 precision: 2147483647 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: NUMERIC type: system type-mapped-class-name: java.math.BigDecimal unsigned: false - ! &3a3ddce2-040e-4357-a12e-b2f617f9b1f2 name: NVARCHAR full-name: NVARCHAR auto-incrementable: false case-sensitive: true create-parameters: LENGTH database-specific-type-name: NVARCHAR enumerated: false fixed-precision-scale: false java-sql-type: *10cf783b-d5c7-467f-b920-80850deb3b21 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable standard-type-name: VARCHAR type: system type-mapped-class-name: java.lang.String unsigned: false - ! &b82e8c6d-c561-487c-af48-54b428cf1620 name: OTHER full-name: OTHER auto-incrementable: false case-sensitive: false database-specific-type-name: OTHER enumerated: false fixed-precision-scale: false java-sql-type: ! &bf984734-eabf-4ce8-9c5f-87798eca0af4 name: OTHER default-mapped-class: java.lang.Object java-sql-type-group: object vendor: java.sql vendor-type-number: 1111 maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: OTHER type: system type-mapped-class-name: java.lang.Object unsigned: false - ! &57baba1d-b00a-48af-835b-5a62ebd81507 name: REAL full-name: REAL auto-incrementable: false case-sensitive: false database-specific-type-name: REAL enumerated: false fixed-precision-scale: false java-sql-type: *adccb201-d133-4d62-96d2-2bb4559af626 maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 64 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: DOUBLE type: system type-mapped-class-name: java.lang.Float unsigned: false - *d7d53b23-90d2-40b4-9dfd-2c723f1217d8 - ! &707d8656-82dd-45aa-a553-d4dbe75555e3 name: TIME full-name: TIME auto-incrementable: false case-sensitive: false database-specific-type-name: TIME enumerated: false fixed-precision-scale: false java-sql-type: ! &d6ccf97f-65c5-4c3d-98bc-87b6edfb51c5 name: TIME default-mapped-class: java.sql.Time java-sql-type-group: temporal vendor: java.sql vendor-type-number: 92 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: TIME type: system type-mapped-class-name: java.sql.Time unsigned: false - ! &91e9ee95-7f8c-47f8-b8d0-435397b03c4e name: TIMESTAMP full-name: TIMESTAMP auto-incrementable: false case-sensitive: false database-specific-type-name: TIMESTAMP enumerated: false fixed-precision-scale: false java-sql-type: ! &ad94b589-7aba-459c-a5ce-f083b9a0e995 name: TIMESTAMP default-mapped-class: java.sql.Timestamp java-sql-type-group: temporal vendor: java.sql vendor-type-number: 93 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: TIMESTAMP type: system type-mapped-class-name: java.sql.Timestamp unsigned: false - ! &8e78e4c4-031b-464c-a5d9-59c1ef9693c5 name: TIMESTAMP WITH TIME ZONE full-name: TIMESTAMP WITH TIME ZONE auto-incrementable: false case-sensitive: false database-specific-type-name: TIMESTAMP WITH TIME ZONE enumerated: false fixed-precision-scale: false java-sql-type: ! &7ef05172-a201-42da-8dea-09a983302fa0 name: TIMESTAMP_WITH_TIMEZONE default-mapped-class: java.time.OffsetDateTime java-sql-type-group: temporal vendor: java.sql vendor-type-number: 2014 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: TIMESTAMP_WITH_TIMEZONE type: system type-mapped-class-name: java.time.OffsetDateTime unsigned: false - ! &f8786274-f75f-428f-835e-f4a127be7fcb name: TIME WITH TIME ZONE full-name: TIME WITH TIME ZONE auto-incrementable: false case-sensitive: false database-specific-type-name: TIME WITH TIME ZONE enumerated: false fixed-precision-scale: false java-sql-type: ! &ba081a44-ef71-4a55-af57-06c23afd824f name: TIME_WITH_TIMEZONE default-mapped-class: java.time.OffsetTime java-sql-type-group: temporal vendor: java.sql vendor-type-number: 2013 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: TIME_WITH_TIMEZONE type: system type-mapped-class-name: java.time.OffsetTime unsigned: false - ! &5b303afb-3a6c-4a97-bee4-b33eb49e2756 name: TINYINT full-name: TINYINT auto-incrementable: true case-sensitive: false database-specific-type-name: TINYINT enumerated: false fixed-precision-scale: false java-sql-type: ! &e6acf9f8-b7f8-438d-ac2a-3e7dafaae052 name: TINYINT default-mapped-class: java.lang.Integer java-sql-type-group: integer vendor: java.sql vendor-type-number: -6 maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 8 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable except with where .. like standard-type-name: TINYINT type: system type-mapped-class-name: java.lang.Integer unsigned: false - ! &cd5d2ba0-0c6a-4f82-b371-fbec94e3303e name: UUID full-name: UUID auto-incrementable: false case-sensitive: false database-specific-type-name: UUID enumerated: false fixed-precision-scale: false java-sql-type: *f028c933-a5c5-4eae-8d93-540823443d6e literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 16 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable standard-type-name: BINARY type: system type-mapped-class-name: "byte[]" unsigned: false - ! &c4ded0ac-589b-4a42-bdda-40c149563b39 name: VARBINARY full-name: VARBINARY auto-incrementable: false case-sensitive: false create-parameters: LENGTH database-specific-type-name: VARBINARY enumerated: false fixed-precision-scale: false java-sql-type: ! &6a238720-f2b6-4638-9bc6-589a17423b5e name: VARBINARY default-mapped-class: "[B" java-sql-type-group: binary vendor: java.sql vendor-type-number: -3 literal-prefix: '''' literal-suffix: '''' maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 schema: *265dd25e-d377-493c-970b-2f4d09f89b2e searchable: searchable standard-type-name: VARBINARY type: system type-mapped-class-name: "byte[]" unsigned: false - *563251d5-275e-453f-9b2d-113b04af8880 column-data-types: ! - *b22e5c40-f8f0-49bf-9f98-71acbc3f752d - *70615de9-c0d1-4c69-a255-aaf5b38eb55d - *3572d92d-6db4-459f-be00-98bbb489f418 - *0e605df5-c446-402e-b4fc-59827b6b49f1 - *5a1e5dfb-ab5c-4fd4-9f25-573d8ebcb35d - *1d78a7aa-1d59-4185-a912-e32f6ae2b641 - *9cf061a4-08b4-4d8e-b6a3-acd547efa671 - *089e74f2-493e-4796-b386-7465a861a76e - *292a42ab-bf95-4a2e-947a-b08364c4309d - *0950bbd8-8008-40df-9f0f-7f7495b9e46b - *789f943e-35b8-411e-9003-79e058269daa - *95ab46a8-7604-4de2-8b07-eabf736af81a - *b103aea0-998d-4cc1-877f-a5ba039f0a6d - *3a3ddce2-040e-4357-a12e-b2f617f9b1f2 - *b82e8c6d-c561-487c-af48-54b428cf1620 - *57baba1d-b00a-48af-835b-5a62ebd81507 - *d7d53b23-90d2-40b4-9dfd-2c723f1217d8 - *707d8656-82dd-45aa-a553-d4dbe75555e3 - *91e9ee95-7f8c-47f8-b8d0-435397b03c4e - *8e78e4c4-031b-464c-a5d9-59c1ef9693c5 - *f8786274-f75f-428f-835e-f4a127be7fcb - *5b303afb-3a6c-4a97-bee4-b33eb49e2756 - *cd5d2ba0-0c6a-4f82-b371-fbec94e3303e - *c4ded0ac-589b-4a42-bdda-40c149563b39 - *563251d5-275e-453f-9b2d-113b04af8880 - *5d14174d-364f-4b4e-8928-639f687349b9 - *c4654859-f317-4f67-9d25-9c1c6092f038 - *ba227aa4-5ce1-47b5-b1a9-8c60d4d36798 - *911952a3-50f4-4ea4-9531-141b085eb0f0 - *5ed5d2a2-ba47-415c-859e-179c0075101d database-users: ! - ! &1cedd142-f8bc-4fd7-8e8d-e16876543d27 name: OTHERUSER full-name: OTHERUSER attributes: ! ADMIN: false AUTHENTICATION: ANY PASSWORD_DIGEST: 3680cf0219b09398c34f2137f27a0c02 - ! &89ac497d-383c-40fe-894e-70130dbc1c71 name: SA full-name: SA attributes: ! ADMIN: true AUTHENTICATION: LOCAL PASSWORD_DIGEST: d41d8cd98f00b204e9800998ecf8427e tables: ! - ! &80d32bdb-8ff1-4270-ad8f-0f28b8c02880 name: AUTHORS full-name: PUBLIC.BOOKS.AUTHORS attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: Contact details for book authors columns: ! - *fc9097ca-bfb0-4bc3-9717-1a2ee3904552 - *d74c1228-66d8-443f-a693-368dbae4b002 - *8bd0e9be-3062-4dda-b238-74c4ed8a41e6 - *15ef2b47-8ad1-4967-b952-66d970ec6f6b - *4734be87-9fba-4978-bc0f-2a8d5cb7440a - *49f5407c-8ad2-4693-bc07-66be810dace1 - *1df5cd07-8cdf-4233-8742-0a897358b87e - *4ef52e23-aa67-4446-a1c2-3f72589e6819 - *f23ec896-dddd-4842-8971-eecb737f31b0 dependent-tables: ! - ! &5709402a-62e4-449c-8574-03d2e2edfb7b name: BOOKAUTHORS full-name: PUBLIC.BOOKS.BOOKAUTHORS attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "Relationship between books and their authors, \nalong with the\ \ latest updated information" columns: ! - *5c86d315-9295-4cf8-8292-b43802837ad8 - *015a13d1-df6f-4809-996c-11fb23497d71 - *3dbc6622-6f77-4bd3-90c7-7a015a7c1bfc foreign-keys: ! - ! &59e46999-2b49-40ca-b9e3-72764a61ebce name: Z_FK_AUTHOR short-name: BOOKAUTHORS.Z_FK_AUTHOR full-name: PUBLIC.BOOKS.BOOKAUTHORS.Z_FK_AUTHOR attributes: ! PK_NAME: PK_AUTHORS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS column-references: ! - ! &cf203541-9ce5-468c-9103-b899a385b4ba foreign-key-column: *015a13d1-df6f-4809-996c-11fb23497d71 key-sequence: 1 primary-key-column: *fc9097ca-bfb0-4bc3-9717-1a2ee3904552 self-referencing: false constrained-columns: ! - *015a13d1-df6f-4809-996c-11fb23497d71 deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *5709402a-62e4-449c-8574-03d2e2edfb7b foreign-key-table: *5709402a-62e4-449c-8574-03d2e2edfb7b initially-deferred: false optional: false parent-partial: false primary-key-table: *80d32bdb-8ff1-4270-ad8f-0f28b8c02880 referenced-table: *80d32bdb-8ff1-4270-ad8f-0f28b8c02880 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false type: foreign_key update-rule: no action - ! &d069309b-de62-4e81-a522-9025e66e06bf name: SYS_FK_10121 short-name: BOOKAUTHORS.SYS_FK_10121 full-name: PUBLIC.BOOKS.BOOKAUTHORS.SYS_FK_10121 attributes: ! PK_NAME: PK_BOOKS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS column-references: ! - ! &fb1e2bf1-79ec-4342-be83-0f2d4a24177e foreign-key-column: *5c86d315-9295-4cf8-8292-b43802837ad8 key-sequence: 1 primary-key-column: *9a441767-d861-4b18-bd07-c9766dbcdb2e self-referencing: false constrained-columns: ! - *5c86d315-9295-4cf8-8292-b43802837ad8 deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *5709402a-62e4-449c-8574-03d2e2edfb7b foreign-key-table: *5709402a-62e4-449c-8574-03d2e2edfb7b initially-deferred: false optional: false parent-partial: false primary-key-table: ! &8ff7cfd5-76b1-43d4-a291-aa91827e973f name: BOOKS full-name: PUBLIC.BOOKS.BOOKS attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: Details for published books columns: ! - *9a441767-d861-4b18-bd07-c9766dbcdb2e - *094771b9-67b2-4762-8a08-4b4a9706aad9 - *c1076f8c-6d20-4809-a8be-e2c32323df0f - *4ecd4746-6800-43f4-a7b3-a2f946dcc640 - *a89a79d2-8ea4-40c2-9ed5-1fc90982264e - *50a7c21f-18a5-42b9-9afb-cff234e4d53a - *ea2b1e3c-1ced-4e15-b8c0-f072e220ae10 dependent-tables: ! - *5709402a-62e4-449c-8574-03d2e2edfb7b - *8ff7cfd5-76b1-43d4-a291-aa91827e973f - ! &db454079-ffb5-4633-b0ce-a487e8c68303 name: SALES full-name: PUBLIC."PUBLISHER SALES".SALES attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *2bc97408-8ced-4806-bfb7-b97ed5735e56 - *53348b1d-451f-4be9-be60-8fcbb5a0af71 - *3c5f46ec-03ec-4113-8f9c-0da96677c2b7 - *eb2c0a61-fc55-48fc-8c83-8caa7530a097 - *7b2acba9-c8c0-4b0c-b287-a4fff25562c1 - *e2660809-da82-4bbb-b74d-449d5c60f858 - *3c7679e9-309f-4f17-b21c-c75afe145006 foreign-keys: ! - ! &abccda8b-10a3-46f0-a4c2-17353ad75ba4 name: FK_SALES_BOOK short-name: SALES.FK_SALES_BOOK full-name: PUBLIC."PUBLISHER SALES".SALES.FK_SALES_BOOK attributes: ! PK_NAME: PK_BOOKS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: PUBLISHER SALES column-references: ! - ! &fb3340c8-ea99-4050-b057-1cfe0168d632 foreign-key-column: *3c5f46ec-03ec-4113-8f9c-0da96677c2b7 key-sequence: 1 primary-key-column: *9a441767-d861-4b18-bd07-c9766dbcdb2e self-referencing: false constrained-columns: ! - *3c5f46ec-03ec-4113-8f9c-0da96677c2b7 deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *db454079-ffb5-4633-b0ce-a487e8c68303 foreign-key-table: *db454079-ffb5-4633-b0ce-a487e8c68303 initially-deferred: false optional: true parent-partial: false primary-key-table: *8ff7cfd5-76b1-43d4-a291-aa91827e973f referenced-table: *8ff7cfd5-76b1-43d4-a291-aa91827e973f schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f self-referencing: false type: foreign_key update-rule: no action - ! &f9d8ac32-072d-422a-9f7e-2107d6619c84 name: FK_SALES_SALESDATA short-name: SALES.FK_SALES_SALESDATA full-name: PUBLIC."PUBLISHER SALES".SALES.FK_SALES_SALESDATA attributes: ! PK_NAME: UQ_CUSTOMERS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: PUBLISHER SALES column-references: ! - ! &504fd1bb-5686-4494-b187-aa62147cb160 foreign-key-column: *3c7679e9-309f-4f17-b21c-c75afe145006 key-sequence: 1 primary-key-column: *0c4da277-4e50-4647-848f-bad21985c6b9 self-referencing: false constrained-columns: ! - *3c7679e9-309f-4f17-b21c-c75afe145006 deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *db454079-ffb5-4633-b0ce-a487e8c68303 foreign-key-table: *db454079-ffb5-4633-b0ce-a487e8c68303 initially-deferred: false optional: true parent-partial: false primary-key-table: ! &87378231-a2c9-453f-abf3-ed11ca07b944 name: SALESDATA full-name: PUBLIC."PUBLISHER SALES".SALESDATA attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *0c4da277-4e50-4647-848f-bad21985c6b9 - *f9a4c48b-5095-4299-bf2d-e07beb8051ec dependent-tables: ! - *db454079-ffb5-4633-b0ce-a487e8c68303 foreign-keys: ! - *f9d8ac32-072d-422a-9f7e-2107d6619c84 indexes: ! - ! &6621aa6d-85cb-4fd3-8114-d397bab27685 name: UQ_CUSTOMERS short-name: SALESDATA.UQ_CUSTOMERS full-name: PUBLIC."PUBLISHER SALES".SALESDATA.UQ_CUSTOMERS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: SALESDATA TABLE_SCHEM: PUBLISHER SALES cardinality: 0 columns: ! - *0c4da277-4e50-4647-848f-bad21985c6b9 index-type: other pages: 0 parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f type: other unique: true privileges: ! - ! &4d87ec17-2c72-4c7a-8ea3-a119cbbd5651 name: DELETE short-name: SALESDATA."DELETE" full-name: PUBLIC."PUBLISHER SALES".SALESDATA."DELETE" grants: ! - ! &af0ca111-ee85-4912-aa87-ccb5a0c5e3e9 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &125d2f93-0c36-4db5-b098-04b97944ceea name: INSERT short-name: SALESDATA."INSERT" full-name: PUBLIC."PUBLISHER SALES".SALESDATA."INSERT" grants: ! - ! &f08a170d-7a14-478f-abbd-823226a3bdee grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &646a31e1-5273-4f79-962c-cc65b9c4775e name: REFERENCES short-name: SALESDATA."REFERENCES" full-name: PUBLIC."PUBLISHER SALES".SALESDATA."REFERENCES" grants: ! - ! &e75eadf6-afff-4280-8db8-654cc530aeae grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &72bd5e29-a238-4f1d-8930-3130e71b5fc1 name: SELECT short-name: SALESDATA."SELECT" full-name: PUBLIC."PUBLISHER SALES".SALESDATA."SELECT" grants: ! - ! &058205e5-2a24-492c-be46-53f142c728c1 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &22b066bf-ddb7-4e9e-8fe2-aac6f261f36a name: TRIGGER short-name: SALESDATA."TRIGGER" full-name: PUBLIC."PUBLISHER SALES".SALESDATA."TRIGGER" grants: ! - ! &3617121a-7a54-4693-b8eb-a14164d9597f grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &8343e6f4-9445-4752-988d-f6b0e318d73d name: UPDATE short-name: SALESDATA."UPDATE" full-name: PUBLIC."PUBLISHER SALES".SALESDATA."UPDATE" grants: ! - ! &8e57437c-1c2d-4bbb-9b8c-44daf8932fa3 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f self-referencing: false table-constraints: ! - *6621aa6d-85cb-4fd3-8114-d397bab27685 table-type: ! &cf906f5e-1f8e-4065-b4d9-e2f4b890b37c name: TABLE simple-table-type: table table-type: TABLE view: false type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c used-by-objects: ! - *db454079-ffb5-4633-b0ce-a487e8c68303 referenced-table: *87378231-a2c9-453f-abf3-ed11ca07b944 schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f self-referencing: false type: foreign_key update-rule: no action - ! &d2b6425a-4d07-4b5b-9aae-ee30ae55ca15 name: FK_SALES_REGIONS short-name: SALES.FK_SALES_REGIONS full-name: PUBLIC."PUBLISHER SALES".SALES.FK_SALES_REGIONS attributes: ! PK_NAME: PK_CUSTOMERS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: PUBLISHER SALES column-references: ! - ! &84e253c2-d63a-4809-b65c-d358058b5fbf foreign-key-column: *2bc97408-8ced-4806-bfb7-b97ed5735e56 key-sequence: 1 primary-key-column: *382d482a-f6d8-4ac7-ab80-03c6be211cdd self-referencing: false - ! &398689e3-c63b-4b65-b8f4-9a9042a45294 foreign-key-column: *53348b1d-451f-4be9-be60-8fcbb5a0af71 key-sequence: 2 primary-key-column: *d41fea5c-1a31-4b1c-aac6-b985791db3eb self-referencing: false constrained-columns: ! - *2bc97408-8ced-4806-bfb7-b97ed5735e56 - *53348b1d-451f-4be9-be60-8fcbb5a0af71 deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *db454079-ffb5-4633-b0ce-a487e8c68303 foreign-key-table: *db454079-ffb5-4633-b0ce-a487e8c68303 initially-deferred: false optional: false parent-partial: false primary-key-table: ! &58b77bf4-0ae1-42dd-bd93-8f7a275401ff name: REGIONS full-name: PUBLIC."PUBLISHER SALES".REGIONS attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *72dde35b-3832-49b1-9aed-08aca391d9c9 - *ee4fcd34-e584-48ef-a132-50b00ebc8713 - *382d482a-f6d8-4ac7-ab80-03c6be211cdd - *d41fea5c-1a31-4b1c-aac6-b985791db3eb dependent-tables: ! - *db454079-ffb5-4633-b0ce-a487e8c68303 foreign-keys: ! - *d2b6425a-4d07-4b5b-9aae-ee30ae55ca15 indexes: ! - ! &ff051326-a7c6-479c-b1fc-4df3d5072d5d name: PK_CUSTOMERS short-name: REGIONS.PK_CUSTOMERS full-name: PUBLIC."PUBLISHER SALES".REGIONS.PK_CUSTOMERS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: REGIONS TABLE_SCHEM: PUBLISHER SALES cardinality: 0 columns: ! - *382d482a-f6d8-4ac7-ab80-03c6be211cdd - *d41fea5c-1a31-4b1c-aac6-b985791db3eb index-type: other pages: 0 parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f type: other unique: true primary-key: *ff051326-a7c6-479c-b1fc-4df3d5072d5d privileges: ! - ! &acb1895b-9405-4d48-b53f-baf76a012355 name: DELETE short-name: REGIONS."DELETE" full-name: PUBLIC."PUBLISHER SALES".REGIONS."DELETE" grants: ! - ! &b6271b8b-64a8-49bf-a99f-206a35b26a2b grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &2f4926df-66a5-46f4-9e4f-838047af17f8 name: INSERT short-name: REGIONS."INSERT" full-name: PUBLIC."PUBLISHER SALES".REGIONS."INSERT" grants: ! - ! &d0aea276-d433-4628-a8e2-344cba8bd8dd grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &255ec5b5-3ca8-4e14-8620-8c3af1002639 name: REFERENCES short-name: REGIONS."REFERENCES" full-name: PUBLIC."PUBLISHER SALES".REGIONS."REFERENCES" grants: ! - ! &d981f5e5-53c6-4abc-af64-e63340cb6305 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &c79e5f3b-0e1e-4afe-b160-e73b8a0b733a name: SELECT short-name: REGIONS."SELECT" full-name: PUBLIC."PUBLISHER SALES".REGIONS."SELECT" grants: ! - ! &8ef72ed5-eb43-4252-8266-7d4be8384761 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &08e609bd-83ef-4ab1-9e45-3b2617dce8fc name: TRIGGER short-name: REGIONS."TRIGGER" full-name: PUBLIC."PUBLISHER SALES".REGIONS."TRIGGER" grants: ! - ! &f55fd7f0-1289-45a7-90aa-73a5250534e7 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &19277a95-2c86-4aef-b0ae-91fa9f307859 name: UPDATE short-name: REGIONS."UPDATE" full-name: PUBLIC."PUBLISHER SALES".REGIONS."UPDATE" grants: ! - ! &2ec48bbb-3e8e-4915-9509-4e3ded0eee74 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f self-referencing: false table-constraints: ! - *ff051326-a7c6-479c-b1fc-4df3d5072d5d - ! &89baf9b0-eed2-4649-a836-651f105b1de9 name: SYS_CT_10207 short-name: REGIONS.SYS_CT_10207 full-name: PUBLIC."PUBLISHER SALES".REGIONS.SYS_CT_10207 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: PUBLISHER SALES constrained-columns: ! - *72dde35b-3832-49b1-9aed-08aca391d9c9 deferrable: false definition: '"PUBLISHER SALES".REGIONS.CITY IS NOT NULL' initially-deferred: false parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f type: check - ! &37433654-d466-45a5-995c-709ba7233958 name: SYS_CT_10208 short-name: REGIONS.SYS_CT_10208 full-name: PUBLIC."PUBLISHER SALES".REGIONS.SYS_CT_10208 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: PUBLISHER SALES constrained-columns: ! - *ee4fcd34-e584-48ef-a132-50b00ebc8713 deferrable: false definition: '"PUBLISHER SALES".REGIONS.STATE IS NOT NULL' initially-deferred: false parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f type: check - ! &f5203fef-7940-49a9-9e1f-113febdf5ca8 name: SYS_CT_10209 short-name: REGIONS.SYS_CT_10209 full-name: PUBLIC."PUBLISHER SALES".REGIONS.SYS_CT_10209 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: PUBLISHER SALES constrained-columns: ! - *382d482a-f6d8-4ac7-ab80-03c6be211cdd deferrable: false definition: '"PUBLISHER SALES".REGIONS.POSTALCODE IS NOT NULL' initially-deferred: false parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f type: check - ! &af59be15-7c84-4637-91ae-58db4482cd28 name: SYS_CT_10210 short-name: REGIONS.SYS_CT_10210 full-name: PUBLIC."PUBLISHER SALES".REGIONS.SYS_CT_10210 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: PUBLISHER SALES constrained-columns: ! - *d41fea5c-1a31-4b1c-aac6-b985791db3eb deferrable: false definition: '"PUBLISHER SALES".REGIONS.COUNTRY IS NOT NULL' initially-deferred: false parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c used-by-objects: ! - *db454079-ffb5-4633-b0ce-a487e8c68303 referenced-table: *58b77bf4-0ae1-42dd-bd93-8f7a275401ff schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f self-referencing: false type: foreign_key update-rule: no action indexes: ! - *abccda8b-10a3-46f0-a4c2-17353ad75ba4 - *f9d8ac32-072d-422a-9f7e-2107d6619c84 - *d2b6425a-4d07-4b5b-9aae-ee30ae55ca15 privileges: ! - ! &ad712058-7582-499c-a46a-d89c09c613d5 name: DELETE short-name: SALES."DELETE" full-name: PUBLIC."PUBLISHER SALES".SALES."DELETE" grants: ! - ! &5df61c83-5dfc-4c79-a757-9d6411580899 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &7dcff036-9c8f-4a84-9f42-dee45c437190 name: INSERT short-name: SALES."INSERT" full-name: PUBLIC."PUBLISHER SALES".SALES."INSERT" grants: ! - ! &d2a4f8e9-5847-41b5-85c4-4c0b187d07aa grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &f7d6b1cc-f217-42af-a3fb-4438fea7db69 name: REFERENCES short-name: SALES."REFERENCES" full-name: PUBLIC."PUBLISHER SALES".SALES."REFERENCES" grants: ! - ! &3e6835ed-7159-447c-ac9d-0b3a23e279a0 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &94563423-6d25-48e3-9e49-697f0c97a702 name: SELECT short-name: SALES."SELECT" full-name: PUBLIC."PUBLISHER SALES".SALES."SELECT" grants: ! - ! &6cfe7694-69d7-45da-9b98-7415fa962408 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &1add08ea-c2e3-48a8-a2c4-703e12a8431a name: TRIGGER short-name: SALES."TRIGGER" full-name: PUBLIC."PUBLISHER SALES".SALES."TRIGGER" grants: ! - ! &43a43a9b-50fa-4627-8978-9957dc51587d grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f - ! &3edd0433-d304-47c8-bfb1-86936a981ca5 name: UPDATE short-name: SALES."UPDATE" full-name: PUBLIC."PUBLISHER SALES".SALES."UPDATE" grants: ! - ! &5befebea-67e0-41ee-b9aa-286567344ef2 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f referenced-objects: ! - *8ff7cfd5-76b1-43d4-a291-aa91827e973f - *58b77bf4-0ae1-42dd-bd93-8f7a275401ff - *87378231-a2c9-453f-abf3-ed11ca07b944 referenced-tables: ! - *8ff7cfd5-76b1-43d4-a291-aa91827e973f - *58b77bf4-0ae1-42dd-bd93-8f7a275401ff - *87378231-a2c9-453f-abf3-ed11ca07b944 schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f self-referencing: false table-constraints: ! - *abccda8b-10a3-46f0-a4c2-17353ad75ba4 - *f9d8ac32-072d-422a-9f7e-2107d6619c84 - *d2b6425a-4d07-4b5b-9aae-ee30ae55ca15 - ! &ce21104a-f9c6-4689-9dec-fd7c8ee8ad3b name: SYS_CT_10216 short-name: SALES.SYS_CT_10216 full-name: PUBLIC."PUBLISHER SALES".SALES.SYS_CT_10216 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: PUBLISHER SALES constrained-columns: ! - *2bc97408-8ced-4806-bfb7-b97ed5735e56 deferrable: false definition: '"PUBLISHER SALES".SALES.POSTALCODE IS NOT NULL' initially-deferred: false parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f type: check - ! &cad58200-e311-4b78-accd-d6b4bccb6e1a name: SYS_CT_10217 short-name: SALES.SYS_CT_10217 full-name: PUBLIC."PUBLISHER SALES".SALES.SYS_CT_10217 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: PUBLISHER SALES constrained-columns: ! - *53348b1d-451f-4be9-be60-8fcbb5a0af71 deferrable: false definition: '"PUBLISHER SALES".SALES.COUNTRY IS NOT NULL' initially-deferred: false parent-partial: false schema: *1f19bea6-f03f-4259-be6c-2b1a8aad373f type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c foreign-keys: ! - ! &6cab2df2-448c-4db4-b18f-3e750e9720b1 name: FK_PREVIOUSEDITION short-name: BOOKS.FK_PREVIOUSEDITION full-name: PUBLIC.BOOKS.BOOKS.FK_PREVIOUSEDITION attributes: ! PK_NAME: PK_BOOKS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS column-references: ! - ! &ebb85f99-c926-47a5-b05a-88344550cc93 foreign-key-column: *ea2b1e3c-1ced-4e15-b8c0-f072e220ae10 key-sequence: 1 primary-key-column: *9a441767-d861-4b18-bd07-c9766dbcdb2e self-referencing: false constrained-columns: ! - *ea2b1e3c-1ced-4e15-b8c0-f072e220ae10 deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *8ff7cfd5-76b1-43d4-a291-aa91827e973f foreign-key-table: *8ff7cfd5-76b1-43d4-a291-aa91827e973f initially-deferred: false optional: true parent-partial: false primary-key-table: *8ff7cfd5-76b1-43d4-a291-aa91827e973f referenced-table: *8ff7cfd5-76b1-43d4-a291-aa91827e973f schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: true type: foreign_key update-rule: no action - *abccda8b-10a3-46f0-a4c2-17353ad75ba4 - *d069309b-de62-4e81-a522-9025e66e06bf indexes: ! - ! &cd971e8f-9c4b-4095-8391-9fe78e74a90b name: PK_BOOKS short-name: BOOKS.PK_BOOKS full-name: PUBLIC.BOOKS.BOOKS.PK_BOOKS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: BOOKS TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *9a441767-d861-4b18-bd07-c9766dbcdb2e index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: true - ! &943b5e13-8b24-4d35-a6b2-955810c1606d name: U_PREVIOUSEDITION short-name: BOOKS.U_PREVIOUSEDITION full-name: PUBLIC.BOOKS.BOOKS.U_PREVIOUSEDITION attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: BOOKS TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *ea2b1e3c-1ced-4e15-b8c0-f072e220ae10 index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: true - *6cab2df2-448c-4db4-b18f-3e750e9720b1 primary-key: *cd971e8f-9c4b-4095-8391-9fe78e74a90b privileges: ! - ! &b360d0dd-358b-4f62-95e1-bf7855bea01e name: DELETE short-name: BOOKS."DELETE" full-name: PUBLIC.BOOKS.BOOKS."DELETE" grants: ! - ! &4e7ecae5-0c72-4cbf-a319-e52062abafae grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &eef2fb25-3118-4629-a181-eb85c1758659 name: INSERT short-name: BOOKS."INSERT" full-name: PUBLIC.BOOKS.BOOKS."INSERT" grants: ! - ! &5e7356a2-ea9f-456c-af51-e15a37c66aeb grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &9bceb594-5ebc-4a5b-b28b-411fe1ffd948 name: REFERENCES short-name: BOOKS."REFERENCES" full-name: PUBLIC.BOOKS.BOOKS."REFERENCES" grants: ! - ! &4629e7a4-4df9-4d9f-a66c-355f336fefe2 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &0a5e53eb-78ff-4374-bbd6-fb2e764e4182 name: SELECT short-name: BOOKS."SELECT" full-name: PUBLIC.BOOKS.BOOKS."SELECT" grants: ! - ! &62f1dce6-ab52-4bbb-b7f4-fbde3901f707 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &3e3887d9-2011-48a3-83ae-676283f8829e name: TRIGGER short-name: BOOKS."TRIGGER" full-name: PUBLIC.BOOKS.BOOKS."TRIGGER" grants: ! - ! &e3f8551e-d2c3-42aa-8dff-ca735e773fe8 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &b6e25f2e-0c30-4968-b44f-ff7b1c84e641 name: UPDATE short-name: BOOKS."UPDATE" full-name: PUBLIC.BOOKS.BOOKS."UPDATE" grants: ! - ! &92015faa-355e-44b3-b150-a2bbe1d99a77 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 referenced-objects: ! - *8ff7cfd5-76b1-43d4-a291-aa91827e973f referenced-tables: ! - *8ff7cfd5-76b1-43d4-a291-aa91827e973f remarks: Details for published books schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: true table-constraints: ! - *cd971e8f-9c4b-4095-8391-9fe78e74a90b - *6cab2df2-448c-4db4-b18f-3e750e9720b1 - *943b5e13-8b24-4d35-a6b2-955810c1606d - ! &3a117cf8-9c6e-4b61-9ca6-020995560e44 name: SYS_CT_10112 short-name: BOOKS.SYS_CT_10112 full-name: PUBLIC.BOOKS.BOOKS.SYS_CT_10112 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *9a441767-d861-4b18-bd07-c9766dbcdb2e deferrable: false definition: BOOKS.BOOKS.ID IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check - ! &38ec6005-2d8b-40f3-95cf-a9e669ef2470 name: SYS_CT_10113 short-name: BOOKS.SYS_CT_10113 full-name: PUBLIC.BOOKS.BOOKS.SYS_CT_10113 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *094771b9-67b2-4762-8a08-4b4a9706aad9 deferrable: false definition: BOOKS.BOOKS.TITLE IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check - ! &f33a2103-a4a4-4957-becd-9bf4e4cef62a name: SYS_CT_10114 short-name: BOOKS.SYS_CT_10114 full-name: PUBLIC.BOOKS.BOOKS.SYS_CT_10114 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *4ecd4746-6800-43f4-a7b3-a2f946dcc640 deferrable: false definition: BOOKS.BOOKS.PUBLISHERID IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c used-by-objects: ! - *db454079-ffb5-4633-b0ce-a487e8c68303 - *5709402a-62e4-449c-8574-03d2e2edfb7b - *8ff7cfd5-76b1-43d4-a291-aa91827e973f referenced-table: *8ff7cfd5-76b1-43d4-a291-aa91827e973f schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false type: foreign_key update-rule: no action indexes: ! - *59e46999-2b49-40ca-b9e3-72764a61ebce - *d069309b-de62-4e81-a522-9025e66e06bf - ! &8fcea24e-c181-43f3-a95e-44c6cdcd6dfe name: UIDX_BOOKAUTHORS short-name: BOOKAUTHORS.UIDX_BOOKAUTHORS full-name: PUBLIC.BOOKS.BOOKAUTHORS.UIDX_BOOKAUTHORS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: BOOKAUTHORS TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *5c86d315-9295-4cf8-8292-b43802837ad8 - *015a13d1-df6f-4809-996c-11fb23497d71 index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: true privileges: ! - ! &4e001a4f-c2ca-480d-a824-e16a7a6070c1 name: DELETE short-name: BOOKAUTHORS."DELETE" full-name: PUBLIC.BOOKS.BOOKAUTHORS."DELETE" grants: ! - ! &b0ae9157-2c17-4d32-8d99-9a40e72f4647 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &dcc3865d-930a-4894-842f-8ea8b10eb4be name: INSERT short-name: BOOKAUTHORS."INSERT" full-name: PUBLIC.BOOKS.BOOKAUTHORS."INSERT" grants: ! - ! &eaf5b3e6-2b8e-440b-b6e0-cad688c683f9 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &758e8c54-8715-4a02-8e74-0e8aa0cb0990 name: REFERENCES short-name: BOOKAUTHORS."REFERENCES" full-name: PUBLIC.BOOKS.BOOKAUTHORS."REFERENCES" grants: ! - ! &df584f8f-9289-4b9d-973d-b0c0e016eaf2 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &7e763764-d2c4-4776-b125-f8be145924cc name: SELECT short-name: BOOKAUTHORS."SELECT" full-name: PUBLIC.BOOKS.BOOKAUTHORS."SELECT" grants: ! - ! &21530325-0f06-4ebe-b0fd-587005399a83 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &89f71543-c24c-484b-affa-1e7da7f72b3f name: TRIGGER short-name: BOOKAUTHORS."TRIGGER" full-name: PUBLIC.BOOKS.BOOKAUTHORS."TRIGGER" grants: ! - ! &b6a7fed4-ffbc-46b3-9757-9f1c22f1e655 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &39e276de-c3d1-485d-8674-6784281bb513 name: UPDATE short-name: BOOKAUTHORS."UPDATE" full-name: PUBLIC.BOOKS.BOOKAUTHORS."UPDATE" grants: ! - ! &f568f998-27e4-4efa-a9a8-cce2a82ff108 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 referenced-objects: ! - *80d32bdb-8ff1-4270-ad8f-0f28b8c02880 - *8ff7cfd5-76b1-43d4-a291-aa91827e973f referenced-tables: ! - *80d32bdb-8ff1-4270-ad8f-0f28b8c02880 - *8ff7cfd5-76b1-43d4-a291-aa91827e973f remarks: "Relationship between books and their authors, \nalong with the\ \ latest updated information" schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false table-constraints: ! - *59e46999-2b49-40ca-b9e3-72764a61ebce - *d069309b-de62-4e81-a522-9025e66e06bf - ! &c8dd801a-5db3-46b9-aaaf-f97cd795f169 name: SYS_CT_10119 short-name: BOOKAUTHORS.SYS_CT_10119 full-name: PUBLIC.BOOKS.BOOKAUTHORS.SYS_CT_10119 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *5c86d315-9295-4cf8-8292-b43802837ad8 deferrable: false definition: BOOKS.BOOKAUTHORS.BOOKID IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check - ! &6a6de8b8-bd3a-491b-9cb6-cb1965fdc58c name: SYS_CT_10120 short-name: BOOKAUTHORS.SYS_CT_10120 full-name: PUBLIC.BOOKS.BOOKAUTHORS.SYS_CT_10120 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *015a13d1-df6f-4809-996c-11fb23497d71 deferrable: false definition: BOOKS.BOOKAUTHORS.AUTHORID IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c foreign-keys: ! - *59e46999-2b49-40ca-b9e3-72764a61ebce indexes: ! - ! &ee4714fc-d50e-45c7-a44e-8833b29776f2 name: PK_AUTHORS short-name: AUTHORS.PK_AUTHORS full-name: PUBLIC.BOOKS.AUTHORS.PK_AUTHORS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: AUTHORS TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *fc9097ca-bfb0-4bc3-9717-1a2ee3904552 index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: true - ! &0331e088-96a6-4dae-a8ad-3444e24c2ff1 name: IDX_B_AUTHORS short-name: AUTHORS.IDX_B_AUTHORS full-name: PUBLIC.BOOKS.AUTHORS.IDX_B_AUTHORS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: AUTHORS TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *8bd0e9be-3062-4dda-b238-74c4ed8a41e6 - *d74c1228-66d8-443f-a693-368dbae4b002 index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: false - ! &2d84c4d3-2e31-4fb7-b7a3-b4c6a986b101 name: IDX_A_AUTHORS short-name: AUTHORS.IDX_A_AUTHORS full-name: PUBLIC.BOOKS.AUTHORS.IDX_A_AUTHORS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: AUTHORS TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *49f5407c-8ad2-4693-bc07-66be810dace1 - *1df5cd07-8cdf-4233-8742-0a897358b87e - *4ef52e23-aa67-4446-a1c2-3f72589e6819 - *f23ec896-dddd-4842-8971-eecb737f31b0 index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: false primary-key: *ee4714fc-d50e-45c7-a44e-8833b29776f2 privileges: ! - ! &52224d54-2a67-4d67-99ce-6d9cd7b4b15f name: DELETE short-name: AUTHORS."DELETE" full-name: PUBLIC.BOOKS.AUTHORS."DELETE" grants: ! - ! &86f55381-790a-470e-9383-ebaa9734c582 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &75b0d867-864d-4625-9ecf-4faf85d89e1c name: INSERT short-name: AUTHORS."INSERT" full-name: PUBLIC.BOOKS.AUTHORS."INSERT" grants: ! - ! &0668fbc1-47a3-4a89-8d2c-1889fb91a86c grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &98688648-3f6e-4344-a4df-2103a89470f8 name: REFERENCES short-name: AUTHORS."REFERENCES" full-name: PUBLIC.BOOKS.AUTHORS."REFERENCES" grants: ! - ! &666d4915-df6c-4334-9a22-3aa6cb5e1011 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &baab1364-a016-47ad-80ee-c156ece678b6 name: SELECT short-name: AUTHORS."SELECT" full-name: PUBLIC.BOOKS.AUTHORS."SELECT" grants: ! - ! &8c2e42e7-8a52-4581-8635-c4f9d92fa9c0 grantable: false grantee: OTHERUSER grantor: SA - ! &747b8661-8288-44eb-9d66-ee92f76a7397 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &dfdb64c6-8f67-4868-8f6f-714cf6540627 name: TRIGGER short-name: AUTHORS."TRIGGER" full-name: PUBLIC.BOOKS.AUTHORS."TRIGGER" grants: ! - ! &2a37cde6-836a-4195-b4b3-ca7bb08fc6db grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &5f2dcc3d-7187-471a-aace-b0f8ddb3645f name: UPDATE short-name: AUTHORS."UPDATE" full-name: PUBLIC.BOOKS.AUTHORS."UPDATE" grants: ! - ! &bbfcf927-37ec-42c9-9ff6-a6cd682e310a grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 remarks: Contact details for book authors schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false table-constraints: ! - *ee4714fc-d50e-45c7-a44e-8833b29776f2 - ! &e8ef14f7-3a04-441e-9e45-e556f0d3ddf2 name: CHECK_UPPERCASE_STATE short-name: AUTHORS.CHECK_UPPERCASE_STATE full-name: PUBLIC.BOOKS.AUTHORS.CHECK_UPPERCASE_STATE attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *1df5cd07-8cdf-4233-8742-0a897358b87e deferrable: false definition: BOOKS.AUTHORS.STATE=UPPER(BOOKS.AUTHORS.STATE) initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check - ! &b3889fb5-8bbe-4453-bafc-5ae7efe92d30 name: SYS_CT_10105 short-name: AUTHORS.SYS_CT_10105 full-name: PUBLIC.BOOKS.AUTHORS.SYS_CT_10105 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *fc9097ca-bfb0-4bc3-9717-1a2ee3904552 deferrable: false definition: BOOKS.AUTHORS.ID IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check - ! &1c0f1c55-f1f0-44a0-9a06-4fa50f9518f9 name: SYS_CT_10106 short-name: AUTHORS.SYS_CT_10106 full-name: PUBLIC.BOOKS.AUTHORS.SYS_CT_10106 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *d74c1228-66d8-443f-a693-368dbae4b002 deferrable: false definition: BOOKS.AUTHORS.FIRSTNAME IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check - ! &9e20ad2d-7aa5-4996-b5b5-657ab334f93b name: SYS_CT_10107 short-name: AUTHORS.SYS_CT_10107 full-name: PUBLIC.BOOKS.AUTHORS.SYS_CT_10107 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *8bd0e9be-3062-4dda-b238-74c4ed8a41e6 deferrable: false definition: BOOKS.AUTHORS.LASTNAME IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c triggers: ! - ! &0dd76ff1-205f-4e54-9543-d1c794115bba name: TRG_AUTHORS short-name: AUTHORS.TRG_AUTHORS full-name: PUBLIC.BOOKS.AUTHORS.TRG_AUTHORS action-order: 0 action-orientation: row action-statement: UPDATE BOOKS.PUBLISHERS SET PUBLISHER='Jacob'WHERE PUBLISHER='John' attributes: ! EVENT_OBJECT_CATALOG: PUBLIC EVENT_OBJECT_SCHEMA: BOOKS condition-timing: after event-manipulation-types: !> - delete parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c used-by-objects: ! - *5709402a-62e4-449c-8574-03d2e2edfb7b - ! &8137b8a6-419f-47ce-82b9-89f2c21a1f08 name: AUTHORSLIST full-name: PUBLIC.BOOKS.AUTHORSLIST attributes: ! INSERTABLE_INTO: "YES" IS_TRIGGER_DELETABLE: "NO" IS_TRIGGER_INSERTABLE_INTO: "NO" IS_TRIGGER_UPDATABLE: "NO" READ_ONLY: false REMARKS: "" check-option: none columns: ! - *516bd94e-0634-4370-be45-50c789e8729e - *77f128fc-e562-4ca4-bc42-a121c0a14b96 - *64e383ef-11c0-44a0-9189-74c51e8ab008 definition: "SELECT ID,FIRSTNAME,LASTNAME FROM BOOKS.AUTHORS" privileges: ! - ! &7a85ac64-7749-414c-8cc0-c335263425ed name: DELETE short-name: AUTHORSLIST."DELETE" full-name: PUBLIC.BOOKS.AUTHORSLIST."DELETE" grants: ! - ! &61fe7f34-2943-4fc9-baa0-708677a86126 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &0e232069-2db8-4e45-89fc-d198d9892f03 name: INSERT short-name: AUTHORSLIST."INSERT" full-name: PUBLIC.BOOKS.AUTHORSLIST."INSERT" grants: ! - ! &e1c6db47-275e-4a22-8242-370d8314602f grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &ac930e97-03a3-40e7-8b70-5c5ab0cef328 name: REFERENCES short-name: AUTHORSLIST."REFERENCES" full-name: PUBLIC.BOOKS.AUTHORSLIST."REFERENCES" grants: ! - ! &8545adbe-01d0-49f0-80c2-f81333959515 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &2966721c-2053-4527-a374-1206be62fe17 name: SELECT short-name: AUTHORSLIST."SELECT" full-name: PUBLIC.BOOKS.AUTHORSLIST."SELECT" grants: ! - ! &2b9a0732-60b4-4a75-8a9e-b08c8ca3491b grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &b65f0d78-9d1a-4a5f-a3ff-ae8a6f03576f name: TRIGGER short-name: AUTHORSLIST."TRIGGER" full-name: PUBLIC.BOOKS.AUTHORSLIST."TRIGGER" grants: ! - ! &1fbd122c-eae6-4d63-b0a4-0ae9fbfdd6da grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &9ee0108c-3acb-4786-a257-62b901ec37b4 name: UPDATE short-name: AUTHORSLIST."UPDATE" full-name: PUBLIC.BOOKS.AUTHORSLIST."UPDATE" grants: ! - ! &6cb1ca79-f564-46e9-8d14-8d492b13d30f grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 referenced-objects: ! - *80d32bdb-8ff1-4270-ad8f-0f28b8c02880 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false table-type: ! &33dc5f10-ea60-434b-ba46-3ba9318bbf5e name: VIEW simple-table-type: view table-type: VIEW view: true table-usage: ! - *80d32bdb-8ff1-4270-ad8f-0f28b8c02880 type: *33dc5f10-ea60-434b-ba46-3ba9318bbf5e updatable: true - *5709402a-62e4-449c-8574-03d2e2edfb7b - *8ff7cfd5-76b1-43d4-a291-aa91827e973f - ! &f0338029-95e9-4874-a751-28e3a4b7a569 name: Celebrities full-name: PUBLIC.BOOKS."Celebrities" attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *b7b068d1-fd57-4e85-a9b4-3b65cb2c8773 - *a2b6f7a2-b93c-4d47-ac58-a70f9233f7c0 dependent-tables: ! - ! &d44591c8-300e-4138-96c5-a8c26273b4c8 name: Celebrity Updates full-name: PUBLIC.BOOKS."Celebrity Updates" attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *af75a4dd-786d-4e4e-9719-9978cbd0aa94 - *2602964d-f34f-4aa6-b8d2-b69c51c5d60e foreign-keys: ! - ! &1ef6a357-9b62-4305-b548-bfe6936b5bed name: SYS_FK_10131 short-name: '"Celebrity Updates".SYS_FK_10131' full-name: PUBLIC.BOOKS."Celebrity Updates".SYS_FK_10131 attributes: ! PK_NAME: PK_Celebrities TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS column-references: ! - ! &c4104300-662b-46a4-815d-b46d1fa1cbb5 foreign-key-column: *af75a4dd-786d-4e4e-9719-9978cbd0aa94 key-sequence: 1 primary-key-column: *b7b068d1-fd57-4e85-a9b4-3b65cb2c8773 self-referencing: false constrained-columns: ! - *af75a4dd-786d-4e4e-9719-9978cbd0aa94 deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *d44591c8-300e-4138-96c5-a8c26273b4c8 foreign-key-table: *d44591c8-300e-4138-96c5-a8c26273b4c8 initially-deferred: false optional: false parent-partial: false primary-key-table: *f0338029-95e9-4874-a751-28e3a4b7a569 referenced-table: *f0338029-95e9-4874-a751-28e3a4b7a569 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false type: foreign_key update-rule: no action indexes: ! - ! &883160b6-ac87-4b03-a922-98f59f38bee0 name: PK Celebrity Updates short-name: '"Celebrity Updates"."PK Celebrity Updates"' full-name: PUBLIC.BOOKS."Celebrity Updates"."PK Celebrity Updates" attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: Celebrity Updates TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *af75a4dd-786d-4e4e-9719-9978cbd0aa94 index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: true - *1ef6a357-9b62-4305-b548-bfe6936b5bed primary-key: *883160b6-ac87-4b03-a922-98f59f38bee0 privileges: ! - ! &fd894a4f-0c23-48ea-89cb-26d8887c13e0 name: DELETE short-name: '"Celebrity Updates"."DELETE"' full-name: PUBLIC.BOOKS."Celebrity Updates"."DELETE" grants: ! - ! &63466b9e-a44e-4485-9dac-9828b4665004 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &b8c9d563-1d35-41a9-9580-25cd9c2c32ed name: INSERT short-name: '"Celebrity Updates"."INSERT"' full-name: PUBLIC.BOOKS."Celebrity Updates"."INSERT" grants: ! - ! &5c8503c7-0633-474a-9012-5f3744c1e713 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &1489f479-8b2c-45fe-84a9-8646443af17c name: REFERENCES short-name: '"Celebrity Updates"."REFERENCES"' full-name: PUBLIC.BOOKS."Celebrity Updates"."REFERENCES" grants: ! - ! &afcdbcf6-443a-47f4-899d-92d0c1073ee6 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &b384ea7d-cfc9-4d63-bc17-61f00af2587a name: SELECT short-name: '"Celebrity Updates"."SELECT"' full-name: PUBLIC.BOOKS."Celebrity Updates"."SELECT" grants: ! - ! &2d87455b-b113-4167-97e6-31df38b4cd35 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &5eaecb94-ea96-4f16-8a7a-1876bbe114e5 name: TRIGGER short-name: '"Celebrity Updates"."TRIGGER"' full-name: PUBLIC.BOOKS."Celebrity Updates"."TRIGGER" grants: ! - ! &f7138fdb-ab66-4606-978e-1d8ae4097b32 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - *2602964d-f34f-4aa6-b8d2-b69c51c5d60e referenced-objects: ! - *f0338029-95e9-4874-a751-28e3a4b7a569 referenced-tables: ! - *f0338029-95e9-4874-a751-28e3a4b7a569 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false table-constraints: ! - *883160b6-ac87-4b03-a922-98f59f38bee0 - *1ef6a357-9b62-4305-b548-bfe6936b5bed - ! &bef94b3e-0b81-4dba-851b-e56a1d49be31 name: SYS_CT_10130 short-name: '"Celebrity Updates".SYS_CT_10130' full-name: PUBLIC.BOOKS."Celebrity Updates".SYS_CT_10130 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *af75a4dd-786d-4e4e-9719-9978cbd0aa94 deferrable: false definition: BOOKS."Celebrity Updates"."Celebrity Id" IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c foreign-keys: ! - *1ef6a357-9b62-4305-b548-bfe6936b5bed indexes: ! - ! &3b5529d2-525b-4eab-8be9-be4e527533e6 name: PK_Celebrities short-name: '"Celebrities"."PK_Celebrities"' full-name: PUBLIC.BOOKS."Celebrities"."PK_Celebrities" attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: Celebrities TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *b7b068d1-fd57-4e85-a9b4-3b65cb2c8773 index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: true primary-key: *3b5529d2-525b-4eab-8be9-be4e527533e6 privileges: ! - ! &04bf8b7e-b69c-4f6a-9604-23b2cd86643c name: DELETE short-name: '"Celebrities"."DELETE"' full-name: PUBLIC.BOOKS."Celebrities"."DELETE" grants: ! - ! &db2dfc69-380e-4bec-873c-c150f11a3bff grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &a9d25222-1ac2-4fdc-9136-e5196a163813 name: INSERT short-name: '"Celebrities"."INSERT"' full-name: PUBLIC.BOOKS."Celebrities"."INSERT" grants: ! - ! &b89d2b9f-357f-4a15-9352-4d500f7d5d0f grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &a396ef4d-1c72-4c4b-996b-0cc6ebd06717 name: REFERENCES short-name: '"Celebrities"."REFERENCES"' full-name: PUBLIC.BOOKS."Celebrities"."REFERENCES" grants: ! - ! &ac686ea4-c5c7-4565-9ad7-f21a6639472a grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &af37835b-dbde-4369-979e-c302567bcc93 name: SELECT short-name: '"Celebrities"."SELECT"' full-name: PUBLIC.BOOKS."Celebrities"."SELECT" grants: ! - ! &62925506-1aca-4991-ae4a-3298efe2991f grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &9fb58f57-27f9-4631-b570-867f646c8c3d name: TRIGGER short-name: '"Celebrities"."TRIGGER"' full-name: PUBLIC.BOOKS."Celebrities"."TRIGGER" grants: ! - ! &92430a8b-1063-452c-89f4-57f0003b7999 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &5626b3cf-e2e7-477e-ae07-afb8d87c40c0 name: UPDATE short-name: '"Celebrities"."UPDATE"' full-name: PUBLIC.BOOKS."Celebrities"."UPDATE" grants: ! - ! &b28c1d6b-9262-4f27-be78-27517ae02da5 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false table-constraints: ! - *3b5529d2-525b-4eab-8be9-be4e527533e6 - ! &72b43ae7-9a73-4f12-a7a1-1c1a775a32e8 name: SYS_CT_10128 short-name: '"Celebrities".SYS_CT_10128' full-name: PUBLIC.BOOKS."Celebrities".SYS_CT_10128 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *b7b068d1-fd57-4e85-a9b4-3b65cb2c8773 deferrable: false definition: BOOKS."Celebrities"."Id" IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c used-by-objects: ! - *d44591c8-300e-4138-96c5-a8c26273b4c8 - *d44591c8-300e-4138-96c5-a8c26273b4c8 - ! &4174a8c3-60e9-43b1-b667-971f4e7d36d2 name: COUPONS full-name: PUBLIC.BOOKS.COUPONS attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *af39b184-264b-4ecf-8ba9-bd182f323546 - *957115f9-e344-45ee-bd49-4ae94182206d - *e9df2ab0-843e-44a7-9e9f-e2173c2d775a - *6a037254-c848-42d7-9e3e-ea8eb972bc6e indexes: ! - ! &e99452ed-90e9-432e-979b-5d4c030d1d06 name: PK_COUPONS short-name: COUPONS.PK_COUPONS full-name: PUBLIC.BOOKS.COUPONS.PK_COUPONS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: COUPONS TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *af39b184-264b-4ecf-8ba9-bd182f323546 index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: true primary-key: *e99452ed-90e9-432e-979b-5d4c030d1d06 privileges: ! - ! &fe3e1a77-e8bd-4dee-b5f6-479c6d3bfa9f name: DELETE short-name: COUPONS."DELETE" full-name: PUBLIC.BOOKS.COUPONS."DELETE" grants: ! - ! &cb73b4cb-c7d2-47e1-ba97-73e1a60d5360 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &728c7abe-24eb-425e-8a8e-6aff3047d435 name: INSERT short-name: COUPONS."INSERT" full-name: PUBLIC.BOOKS.COUPONS."INSERT" grants: ! - ! &2a17f448-f770-4048-a703-9eb2e3fdcfa1 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &ec46d4bb-8472-46a8-834e-2ec69403abaa name: REFERENCES short-name: COUPONS."REFERENCES" full-name: PUBLIC.BOOKS.COUPONS."REFERENCES" grants: ! - ! &58ba4893-eeb8-4be6-9603-18c652a269b4 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &d9f2cb9b-e290-4b28-aa99-70662ab4d05c name: SELECT short-name: COUPONS."SELECT" full-name: PUBLIC.BOOKS.COUPONS."SELECT" grants: ! - ! &38d8ac3c-e71e-4123-babf-fb4dd6a5665d grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &49f06eb6-c7ea-46a3-b85a-968f29a90ac8 name: TRIGGER short-name: COUPONS."TRIGGER" full-name: PUBLIC.BOOKS.COUPONS."TRIGGER" grants: ! - ! &5f906d93-5c69-46c2-af2d-b66271a6285f grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &2a6ec07a-7852-4b36-be43-e0d8a9d72a1f name: UPDATE short-name: COUPONS."UPDATE" full-name: PUBLIC.BOOKS.COUPONS."UPDATE" grants: ! - ! &e295beb2-429f-4f53-80ef-407f09abfb3d grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false table-constraints: ! - *e99452ed-90e9-432e-979b-5d4c030d1d06 - ! &de99b860-be5b-448d-b903-c6b3b6db8b1f name: SYS_CT_10091 short-name: COUPONS.SYS_CT_10091 full-name: PUBLIC.BOOKS.COUPONS.SYS_CT_10091 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *af39b184-264b-4ecf-8ba9-bd182f323546 deferrable: false definition: BOOKS.COUPONS.ID IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c - ! &5fac3dde-572d-4515-b11b-387d01f85cb6 name: CUSTOMERDATA full-name: PUBLIC.BOOKS.CUSTOMERDATA attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *aa1180ad-cffe-40c8-bcb0-c722962e7fca - *45c15214-0bf7-4fa6-bf47-528d0f0c3765 - *2723d231-87c0-415e-b7e1-2c05a0dfc489 foreign-keys: ! - ! &0052c261-bf93-4baa-b17a-677759ecdd5b name: FK_CUSTOMER short-name: CUSTOMERDATA.FK_CUSTOMER full-name: PUBLIC.BOOKS.CUSTOMERDATA.FK_CUSTOMER attributes: ! PK_NAME: PK_CUSTOMERS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS column-references: ! - ! &d3199c6b-ca6c-4691-a921-5c716698d125 foreign-key-column: *aa1180ad-cffe-40c8-bcb0-c722962e7fca key-sequence: 1 primary-key-column: *8ed58ef5-63df-4acc-8089-2444c8626774 self-referencing: false constrained-columns: ! - *aa1180ad-cffe-40c8-bcb0-c722962e7fca deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *5fac3dde-572d-4515-b11b-387d01f85cb6 foreign-key-table: *5fac3dde-572d-4515-b11b-387d01f85cb6 initially-deferred: false optional: false parent-partial: false primary-key-table: ! &ed8771c6-8d1d-4565-88b8-88bcc9f55332 name: CUSTOMERS full-name: PUBLIC.BOOKS.CUSTOMERS attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *8ed58ef5-63df-4acc-8089-2444c8626774 - *8852eab4-226b-4a59-bbef-d79d9ce33345 - *c38a2b8b-2505-49bd-b235-cb246d9263de - *10a34180-cc8a-478c-b3de-c4c2b7fbf806 dependent-tables: ! - *5fac3dde-572d-4515-b11b-387d01f85cb6 foreign-keys: ! - *0052c261-bf93-4baa-b17a-677759ecdd5b indexes: ! - ! &ca23b4f5-fcb2-4aa5-b2b3-be69d4382015 name: PK_CUSTOMERS short-name: CUSTOMERS.PK_CUSTOMERS full-name: PUBLIC.BOOKS.CUSTOMERS.PK_CUSTOMERS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: CUSTOMERS TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *8ed58ef5-63df-4acc-8089-2444c8626774 index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: true primary-key: *ca23b4f5-fcb2-4aa5-b2b3-be69d4382015 privileges: ! - ! &f99888c0-b0af-47cc-bbb8-45fb39a624e7 name: DELETE short-name: CUSTOMERS."DELETE" full-name: PUBLIC.BOOKS.CUSTOMERS."DELETE" grants: ! - ! &9d602a6a-e7d8-4de0-bdd5-6f4097d78d71 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &085bfb36-9e82-4533-a0e9-bfdff3878628 name: INSERT short-name: CUSTOMERS."INSERT" full-name: PUBLIC.BOOKS.CUSTOMERS."INSERT" grants: ! - ! &e4e9e67f-79e0-42b8-a53e-f8626807f976 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &1fdfcca2-c376-4735-b3bd-fb310b8b473b name: REFERENCES short-name: CUSTOMERS."REFERENCES" full-name: PUBLIC.BOOKS.CUSTOMERS."REFERENCES" grants: ! - ! &2a5d9876-2b45-4e28-b7a7-a7914914790e grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &1751a60b-ce67-4d7d-8397-4416acd2a83f name: SELECT short-name: CUSTOMERS."SELECT" full-name: PUBLIC.BOOKS.CUSTOMERS."SELECT" grants: ! - ! &1b74ae28-de34-4ac0-912c-fc62d424d503 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &f6e25ee5-a9d7-4117-9a04-fb7fa51adef4 name: TRIGGER short-name: CUSTOMERS."TRIGGER" full-name: PUBLIC.BOOKS.CUSTOMERS."TRIGGER" grants: ! - ! &9d8ac1f2-1d07-40ba-8956-765e2801d78a grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &427ce9c3-993a-4df3-91e1-b5e3d8f758d6 name: UPDATE short-name: CUSTOMERS."UPDATE" full-name: PUBLIC.BOOKS.CUSTOMERS."UPDATE" grants: ! - ! &17dc7294-ecaf-4297-bffc-d7348d1f4a50 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false table-constraints: ! - *ca23b4f5-fcb2-4aa5-b2b3-be69d4382015 - ! &b4d2f24a-1a13-4ead-9a95-88091592fc4b name: SYS_CT_10093 short-name: CUSTOMERS.SYS_CT_10093 full-name: PUBLIC.BOOKS.CUSTOMERS.SYS_CT_10093 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *8ed58ef5-63df-4acc-8089-2444c8626774 deferrable: false definition: BOOKS.CUSTOMERS.ID IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check - ! &abab5a70-17ce-4861-a4fe-414fe6ab118a name: SYS_CT_10094 short-name: CUSTOMERS.SYS_CT_10094 full-name: PUBLIC.BOOKS.CUSTOMERS.SYS_CT_10094 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *8852eab4-226b-4a59-bbef-d79d9ce33345 deferrable: false definition: BOOKS.CUSTOMERS.FIRSTNAME IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check - ! &31b6f302-3aa0-4b48-a226-f46ae91985c3 name: SYS_CT_10095 short-name: CUSTOMERS.SYS_CT_10095 full-name: PUBLIC.BOOKS.CUSTOMERS.SYS_CT_10095 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *c38a2b8b-2505-49bd-b235-cb246d9263de deferrable: false definition: BOOKS.CUSTOMERS.LASTNAME IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c used-by-objects: ! - *5fac3dde-572d-4515-b11b-387d01f85cb6 referenced-table: *ed8771c6-8d1d-4565-88b8-88bcc9f55332 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false type: foreign_key update-rule: no action indexes: ! - *0052c261-bf93-4baa-b17a-677759ecdd5b - ! &6b70f91b-c6ac-4221-a05d-f48016a6a463 name: PK_CUSTOMERDATA short-name: CUSTOMERDATA.PK_CUSTOMERDATA full-name: PUBLIC.BOOKS.CUSTOMERDATA.PK_CUSTOMERDATA attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: CUSTOMERDATA TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *aa1180ad-cffe-40c8-bcb0-c722962e7fca - *45c15214-0bf7-4fa6-bf47-528d0f0c3765 index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: true primary-key: *6b70f91b-c6ac-4221-a05d-f48016a6a463 privileges: ! - ! &0a34333e-2895-41ac-8842-2c35b72b0807 name: DELETE short-name: CUSTOMERDATA."DELETE" full-name: PUBLIC.BOOKS.CUSTOMERDATA."DELETE" grants: ! - ! &e9d162fb-4368-41b6-996e-7d487c6458da grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &f88fff0c-f651-467e-b4ae-8227bc3c5ecc name: INSERT short-name: CUSTOMERDATA."INSERT" full-name: PUBLIC.BOOKS.CUSTOMERDATA."INSERT" grants: ! - ! &df063621-5193-4e95-a5ed-1ea5827f7623 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &2bc564ed-f4af-4563-9410-0591927bf4e8 name: REFERENCES short-name: CUSTOMERDATA."REFERENCES" full-name: PUBLIC.BOOKS.CUSTOMERDATA."REFERENCES" grants: ! - ! &d76a5bd9-caf2-41e0-ac77-028f3dcac6d5 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &1286bb83-fcee-4b66-9230-ede9c798233d name: SELECT short-name: CUSTOMERDATA."SELECT" full-name: PUBLIC.BOOKS.CUSTOMERDATA."SELECT" grants: ! - ! &4a0cece1-403e-433c-b23e-435d6e2e1943 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &cd08f0f3-deaa-4583-8227-4a0e411f84c9 name: TRIGGER short-name: CUSTOMERDATA."TRIGGER" full-name: PUBLIC.BOOKS.CUSTOMERDATA."TRIGGER" grants: ! - ! &fccfc96b-d77d-4c60-8b1e-7f6b4f576740 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &1b693a41-0b35-49f2-92bd-0e6f53eac603 name: UPDATE short-name: CUSTOMERDATA."UPDATE" full-name: PUBLIC.BOOKS.CUSTOMERDATA."UPDATE" grants: ! - ! &64122d8f-69c3-4390-8c72-eb5ef0f0eb33 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 referenced-objects: ! - *ed8771c6-8d1d-4565-88b8-88bcc9f55332 referenced-tables: ! - *ed8771c6-8d1d-4565-88b8-88bcc9f55332 schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false table-constraints: ! - *6b70f91b-c6ac-4221-a05d-f48016a6a463 - *0052c261-bf93-4baa-b17a-677759ecdd5b - ! &18a988ab-257f-4a12-af6a-645f2bbf0a8c name: SYS_CT_10100 short-name: CUSTOMERDATA.SYS_CT_10100 full-name: PUBLIC.BOOKS.CUSTOMERDATA.SYS_CT_10100 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *aa1180ad-cffe-40c8-bcb0-c722962e7fca deferrable: false definition: BOOKS.CUSTOMERDATA.CUSTOMERID IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check - ! &de3ca3bc-73f7-44c7-b0e1-c0058d4d9ffc name: SYS_CT_10101 short-name: CUSTOMERDATA.SYS_CT_10101 full-name: PUBLIC.BOOKS.CUSTOMERDATA.SYS_CT_10101 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *45c15214-0bf7-4fa6-bf47-528d0f0c3765 deferrable: false definition: BOOKS.CUSTOMERDATA.DATAID IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c - *ed8771c6-8d1d-4565-88b8-88bcc9f55332 - ! &f86cb406-1082-48f1-8cc9-55f38074f04c name: PUBLISHERS full-name: PUBLIC.BOOKS.PUBLISHERS attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: List of book publishers columns: ! - *a18d596b-e302-432c-82df-bf8fbe00f08d - *0a64cba3-1e2d-4bda-a5b1-bebbe3bcb12d dependent-tables: ! - ! &6ae27ff4-ef85-4809-87fc-a0f8e5aaf4db name: ΒΙΒΛΊΑ full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *1f368400-9a4d-4df8-aeb3-2abe6d799cab - *762b1d21-0bae-476c-9122-5ef16f011b3c - *26e94b32-dc33-4536-9696-8699646d0a8c - *159f4082-50e0-4d60-b652-4ecdb7c16d1e foreign-keys: ! - ! &40271044-c35f-43c3-90c0-e7e484227e81 name: FK_ΒΙΒΛΊΑ_PUBLISHERS short-name: ΒΙΒΛΊΑ.FK_ΒΙΒΛΊΑ_PUBLISHERS full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ.FK_ΒΙΒΛΊΑ_PUBLISHERS attributes: ! PK_NAME: SYS_PK_10127 TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS column-references: ! - ! &824490bd-9b29-4750-8249-327783ae74d9 foreign-key-column: *159f4082-50e0-4d60-b652-4ecdb7c16d1e key-sequence: 1 primary-key-column: *a18d596b-e302-432c-82df-bf8fbe00f08d self-referencing: false constrained-columns: ! - *159f4082-50e0-4d60-b652-4ecdb7c16d1e deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *6ae27ff4-ef85-4809-87fc-a0f8e5aaf4db foreign-key-table: *6ae27ff4-ef85-4809-87fc-a0f8e5aaf4db initially-deferred: false optional: false parent-partial: false primary-key-table: *f86cb406-1082-48f1-8cc9-55f38074f04c referenced-table: *f86cb406-1082-48f1-8cc9-55f38074f04c schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false type: foreign_key update-rule: no action indexes: ! - *40271044-c35f-43c3-90c0-e7e484227e81 - ! &5d9fcd08-c059-4281-b557-f46847028975 name: PK_ΒΙΒΛΊΑ short-name: ΒΙΒΛΊΑ.PK_ΒΙΒΛΊΑ full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ.PK_ΒΙΒΛΊΑ attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: ΒΙΒΛΊΑ TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *1f368400-9a4d-4df8-aeb3-2abe6d799cab index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: true primary-key: *5d9fcd08-c059-4281-b557-f46847028975 privileges: ! - ! &5841547f-1ba3-40a4-9341-6a033e17a243 name: DELETE short-name: ΒΙΒΛΊΑ."DELETE" full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ."DELETE" grants: ! - ! &5ba19eb0-4f40-4d3e-9a99-c383c26791ac grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &9a9d7f4c-020a-4914-be63-4e3dccf3783f name: INSERT short-name: ΒΙΒΛΊΑ."INSERT" full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ."INSERT" grants: ! - ! &d3af583e-e392-457d-a8bc-871482ac846b grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &86702498-5d17-4b10-998f-de410cf1d602 name: REFERENCES short-name: ΒΙΒΛΊΑ."REFERENCES" full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ."REFERENCES" grants: ! - ! &7cee4da3-839b-4952-9150-300e3640bf79 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &6f4ea21f-6d50-47b0-8094-21b0004c4f83 name: SELECT short-name: ΒΙΒΛΊΑ."SELECT" full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ."SELECT" grants: ! - ! &d7b92138-5899-4622-86bf-c76a8536ce62 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &984c7477-4dc7-4845-a707-fdb9dd36e7c2 name: TRIGGER short-name: ΒΙΒΛΊΑ."TRIGGER" full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ."TRIGGER" grants: ! - ! &12151ea8-6569-4ce3-ba2e-abfac20ade88 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &75d39a69-5d60-4d77-a003-7b0bf5888a8f name: UPDATE short-name: ΒΙΒΛΊΑ."UPDATE" full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ."UPDATE" grants: ! - ! &0f00232e-00ab-4bfc-be0a-7a36e7aa1b53 grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 referenced-objects: ! - *f86cb406-1082-48f1-8cc9-55f38074f04c referenced-tables: ! - *f86cb406-1082-48f1-8cc9-55f38074f04c schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false table-constraints: ! - *5d9fcd08-c059-4281-b557-f46847028975 - *40271044-c35f-43c3-90c0-e7e484227e81 - ! &7cf4daf5-6213-49ef-9fa8-33677ef62936 name: SYS_CT_10134 short-name: ΒΙΒΛΊΑ.SYS_CT_10134 full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ.SYS_CT_10134 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *1f368400-9a4d-4df8-aeb3-2abe6d799cab deferrable: false definition: BOOKS.ΒΙΒΛΊΑ.ΜΟΝΑΔΙΚΌΣ IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check - ! &cb317072-e01a-4e65-bd37-93a2a067e3ed name: SYS_CT_10135 short-name: ΒΙΒΛΊΑ.SYS_CT_10135 full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ.SYS_CT_10135 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *762b1d21-0bae-476c-9122-5ef16f011b3c deferrable: false definition: BOOKS.ΒΙΒΛΊΑ.ΤΊΤΛΟΣ IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check - ! &054ee24f-3cbf-43b3-a261-38f6a93bb111 name: SYS_CT_10136 short-name: ΒΙΒΛΊΑ.SYS_CT_10136 full-name: PUBLIC.BOOKS.ΒΙΒΛΊΑ.SYS_CT_10136 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: BOOKS constrained-columns: ! - *159f4082-50e0-4d60-b652-4ecdb7c16d1e deferrable: false definition: BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ IS NOT NULL initially-deferred: false parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c foreign-keys: ! - *40271044-c35f-43c3-90c0-e7e484227e81 indexes: ! - ! &6322ac4c-e5b0-4448-832b-3da8a859162d name: SYS_PK_10127 short-name: PUBLISHERS.SYS_PK_10127 full-name: PUBLIC.BOOKS.PUBLISHERS.SYS_PK_10127 attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: PUBLISHERS TABLE_SCHEM: BOOKS cardinality: 0 columns: ! - *a18d596b-e302-432c-82df-bf8fbe00f08d index-type: other pages: 0 parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 type: other unique: true primary-key: *6322ac4c-e5b0-4448-832b-3da8a859162d privileges: ! - ! &16b77e46-dc63-480a-8a0f-4d216934be79 name: DELETE short-name: PUBLISHERS."DELETE" full-name: PUBLIC.BOOKS.PUBLISHERS."DELETE" grants: ! - ! &aac46dc3-7c5a-406f-93ac-95a08086343b grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &690fa6f2-35de-4505-8ab6-182870ef5cb6 name: INSERT short-name: PUBLISHERS."INSERT" full-name: PUBLIC.BOOKS.PUBLISHERS."INSERT" grants: ! - ! &2611c07c-6b22-4757-b658-b585242f127f grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &c044cef7-2e6c-43a0-ae2d-8b589a9b69d2 name: REFERENCES short-name: PUBLISHERS."REFERENCES" full-name: PUBLIC.BOOKS.PUBLISHERS."REFERENCES" grants: ! - ! &a9e20cb9-c47e-4646-be7a-17a215f4b4af grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &2f65cd86-ea41-4853-ae32-64cf142141a8 name: SELECT short-name: PUBLISHERS."SELECT" full-name: PUBLIC.BOOKS.PUBLISHERS."SELECT" grants: ! - ! &31030099-33ad-46a5-85d0-eebefa22fb7f grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &965b6708-7310-4e56-828a-92d37649d7a7 name: TRIGGER short-name: PUBLISHERS."TRIGGER" full-name: PUBLIC.BOOKS.PUBLISHERS."TRIGGER" grants: ! - ! &25ebac4e-195d-45ad-a6e9-9d14cfce97db grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 - ! &58c2f99b-3421-41c3-97dd-e3303dde639c name: UPDATE short-name: PUBLISHERS."UPDATE" full-name: PUBLIC.BOOKS.PUBLISHERS."UPDATE" grants: ! - ! &9b39d814-5e39-40df-9057-ece08b0524ce grantable: true grantee: SA grantor: _SYSTEM parent-partial: false schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 remarks: List of book publishers schema: *69115558-04df-4b38-bc27-b82c4e3e59a1 self-referencing: false table-constraints: ! - *6322ac4c-e5b0-4448-832b-3da8a859162d table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c used-by-objects: ! - *6ae27ff4-ef85-4809-87fc-a0f8e5aaf4db - *6ae27ff4-ef85-4809-87fc-a0f8e5aaf4db - *8137b8a6-419f-47ce-82b9-89f2c21a1f08 - ! &518fcef3-8680-4bc0-9942-a5d5d6e8d9d9 name: EXTRA_PK full-name: PUBLIC.FOR_LINT.EXTRA_PK attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: Extra table with just a primary key columns: ! - *df062cb2-d09c-4f35-a2f2-fca3d85a97fd - *718d4c6d-0a69-4a86-bf2e-ba284eca2ef5 - *6a2cdd5e-586b-48a0-bac5-35a9e9fd99bc foreign-keys: ! - ! &ff5b60f2-6b9f-4a2f-af1f-75f3374b7ef3 name: FK_PUBLICATION_JOIN short-name: EXTRA_PK.FK_PUBLICATION_JOIN full-name: PUBLIC.FOR_LINT.EXTRA_PK.FK_PUBLICATION_JOIN attributes: ! PK_NAME: PK_PUBLICATIONS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT column-references: ! - ! &60411de8-0647-42ef-b6d5-34d3cdc0fb9a foreign-key-column: *718d4c6d-0a69-4a86-bf2e-ba284eca2ef5 key-sequence: 1 primary-key-column: *c62241a4-53a6-461d-b153-a49498bfd57a self-referencing: false constrained-columns: ! - *718d4c6d-0a69-4a86-bf2e-ba284eca2ef5 deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *518fcef3-8680-4bc0-9942-a5d5d6e8d9d9 foreign-key-table: *518fcef3-8680-4bc0-9942-a5d5d6e8d9d9 initially-deferred: false optional: false parent-partial: false primary-key-table: ! &0a27c6f5-f94b-4830-ac7c-f14c19da0593 name: PUBLICATIONS full-name: PUBLIC.FOR_LINT.PUBLICATIONS attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *c62241a4-53a6-461d-b153-a49498bfd57a - *d695f683-4b0c-4914-bf1e-ee8bb9c81421 - *1de903b2-7a81-4ce1-9dd3-032a4f115a0b - *0853f52d-27f3-48c3-849a-4bda3f3fa8e5 - *2d446134-fae7-411c-9879-9f5dadbebcf1 - *506b7ec5-c1ea-4e85-acbe-52ddd06799a5 - *c77103b0-2118-45ec-8361-a89f85b4f10d - *3ab21215-9578-4b03-9185-79e2605b047e dependent-tables: ! - *518fcef3-8680-4bc0-9942-a5d5d6e8d9d9 - ! &a7d127e7-af96-4a09-8c67-09190e9dfb53 name: PUBLICATIONWRITERS full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *982641ae-4988-465f-b265-401f5ff3e10a - *887b1924-fa0b-4203-b08a-86b3a77753f6 foreign-keys: ! - ! &f39c037f-9abf-4ef1-8ec6-47c3e5aa1e19 name: FK_PUBLICATION short-name: PUBLICATIONWRITERS.FK_PUBLICATION full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS.FK_PUBLICATION attributes: ! PK_NAME: PK_PUBLICATIONS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT column-references: ! - ! &6a519ab0-814d-4cdc-925e-985a178f7ef7 foreign-key-column: *982641ae-4988-465f-b265-401f5ff3e10a key-sequence: 1 primary-key-column: *c62241a4-53a6-461d-b153-a49498bfd57a self-referencing: false constrained-columns: ! - *982641ae-4988-465f-b265-401f5ff3e10a deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *a7d127e7-af96-4a09-8c67-09190e9dfb53 foreign-key-table: *a7d127e7-af96-4a09-8c67-09190e9dfb53 initially-deferred: false optional: false parent-partial: false primary-key-table: *0a27c6f5-f94b-4830-ac7c-f14c19da0593 referenced-table: *0a27c6f5-f94b-4830-ac7c-f14c19da0593 schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: false type: foreign_key update-rule: no action - ! &1d3f7cc2-4cce-459c-9b57-27c015b5ea14 name: FK_WRITER short-name: PUBLICATIONWRITERS.FK_WRITER full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS.FK_WRITER attributes: ! PK_NAME: PK_WRITERS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT column-references: ! - ! &82e4f3a3-689e-4948-80cc-0b49e87f8037 foreign-key-column: *887b1924-fa0b-4203-b08a-86b3a77753f6 key-sequence: 1 primary-key-column: *81e96953-01be-4073-8d7a-21a52deeb1ec self-referencing: false constrained-columns: ! - *887b1924-fa0b-4203-b08a-86b3a77753f6 deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *a7d127e7-af96-4a09-8c67-09190e9dfb53 foreign-key-table: *a7d127e7-af96-4a09-8c67-09190e9dfb53 initially-deferred: false optional: false parent-partial: false primary-key-table: ! &a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 name: WRITERS full-name: PUBLIC.FOR_LINT.WRITERS attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *81e96953-01be-4073-8d7a-21a52deeb1ec - *47eb7efd-df59-4f14-a9d2-9bb47fe65391 - *6eb8c9b2-1956-483b-b382-2d5968bbdaf9 - *fe86e3dd-1b71-46d7-b6af-1d3c47eb144c - *49824beb-a915-429e-848a-d9a5c55fdaab - *2f6e5a2c-7e10-4c38-a0b8-009133c66229 - *5c3e9084-7f2e-4d6a-bd5c-4afddfdfd916 - *c78869d1-9149-4772-8922-449422f13779 - *4837f923-ff7d-4897-a5cd-71a55154698b - *a2a5de8c-ebfe-4344-b162-93672a722be1 - *fb2bdb99-83a1-4556-889a-dade87810ec2 - *931f37a7-5da0-4e1f-aeb3-655f585e7e26 - *6e2ac0ab-a35c-4766-a8cc-f36c177b9085 - *2df6af0d-c8ff-4c9b-8085-fd68a048a016 - *ea5e66aa-778c-4d4d-8640-74796da98679 - *c3776aa7-04df-49be-bb8c-c703ee177ae2 - *9b984ff0-88e6-4b4e-b436-739c302b8f5a - *81830292-b4af-42a4-9906-d13017db60ea dependent-tables: ! - *518fcef3-8680-4bc0-9942-a5d5d6e8d9d9 - *0a27c6f5-f94b-4830-ac7c-f14c19da0593 - *a7d127e7-af96-4a09-8c67-09190e9dfb53 foreign-keys: ! - ! &f7617779-e71b-4dfd-99bf-28bda9e67771 name: FK_WRITERS_PUBLICATION short-name: WRITERS.FK_WRITERS_PUBLICATION full-name: PUBLIC.FOR_LINT.WRITERS.FK_WRITERS_PUBLICATION attributes: ! PK_NAME: PK_PUBLICATIONS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT column-references: ! - ! &81e9629e-2f84-4783-b1c8-48ad1d45f4d2 foreign-key-column: *81830292-b4af-42a4-9906-d13017db60ea key-sequence: 1 primary-key-column: *c62241a4-53a6-461d-b153-a49498bfd57a self-referencing: false constrained-columns: ! - *81830292-b4af-42a4-9906-d13017db60ea deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 foreign-key-table: *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 initially-deferred: false optional: false parent-partial: false primary-key-table: *0a27c6f5-f94b-4830-ac7c-f14c19da0593 referenced-table: *0a27c6f5-f94b-4830-ac7c-f14c19da0593 schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: false type: foreign_key update-rule: no action - ! &e29753fc-dc78-47ee-80f2-8721b4b85b28 name: FK_WRITER_JOIN short-name: EXTRA_PK.FK_WRITER_JOIN full-name: PUBLIC.FOR_LINT.EXTRA_PK.FK_WRITER_JOIN attributes: ! PK_NAME: PK_WRITERS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT column-references: ! - ! &31fdc33e-d202-4146-88b4-d59f86e48cd9 foreign-key-column: *df062cb2-d09c-4f35-a2f2-fca3d85a97fd key-sequence: 1 primary-key-column: *81e96953-01be-4073-8d7a-21a52deeb1ec self-referencing: false constrained-columns: ! - *df062cb2-d09c-4f35-a2f2-fca3d85a97fd deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *518fcef3-8680-4bc0-9942-a5d5d6e8d9d9 foreign-key-table: *518fcef3-8680-4bc0-9942-a5d5d6e8d9d9 initially-deferred: false optional: false parent-partial: false primary-key-table: *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 referenced-table: *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: false type: foreign_key update-rule: no action - ! &ed347b53-b499-451f-93bc-481a2a60d48c name: FK_PUBLICATIONS_WRITER short-name: PUBLICATIONS.FK_PUBLICATIONS_WRITER full-name: PUBLIC.FOR_LINT.PUBLICATIONS.FK_PUBLICATIONS_WRITER attributes: ! PK_NAME: PK_WRITERS TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT column-references: ! - ! &6f982d5c-d5a7-4bb9-82c0-35c330c9281d foreign-key-column: *0853f52d-27f3-48c3-849a-4bda3f3fa8e5 key-sequence: 1 primary-key-column: *81e96953-01be-4073-8d7a-21a52deeb1ec self-referencing: false constrained-columns: ! - *0853f52d-27f3-48c3-849a-4bda3f3fa8e5 deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *0a27c6f5-f94b-4830-ac7c-f14c19da0593 foreign-key-table: *0a27c6f5-f94b-4830-ac7c-f14c19da0593 initially-deferred: false optional: false parent-partial: false primary-key-table: *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 referenced-table: *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: false type: foreign_key update-rule: no action - *1d3f7cc2-4cce-459c-9b57-27c015b5ea14 indexes: ! - ! &233186e1-8ad1-4cda-83f2-9de4a4b9cbb3 name: PK_WRITERS short-name: WRITERS.PK_WRITERS full-name: PUBLIC.FOR_LINT.WRITERS.PK_WRITERS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: WRITERS TABLE_SCHEM: FOR_LINT cardinality: 0 columns: ! - *81e96953-01be-4073-8d7a-21a52deeb1ec index-type: other pages: 0 parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: other unique: true - *f7617779-e71b-4dfd-99bf-28bda9e67771 - ! &cb726772-4cb3-406c-b96b-021da3b9adf1 name: IDX_A1_WRITERS short-name: WRITERS.IDX_A1_WRITERS full-name: PUBLIC.FOR_LINT.WRITERS.IDX_A1_WRITERS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: WRITERS TABLE_SCHEM: FOR_LINT cardinality: 0 columns: ! - *2f6e5a2c-7e10-4c38-a0b8-009133c66229 - *5c3e9084-7f2e-4d6a-bd5c-4afddfdfd916 index-type: other pages: 0 parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: other unique: false - ! &ccb7fd33-b9de-4b74-81a6-7de84e4d315c name: IDX_U_WRITERS short-name: WRITERS.IDX_U_WRITERS full-name: PUBLIC.FOR_LINT.WRITERS.IDX_U_WRITERS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: WRITERS TABLE_SCHEM: FOR_LINT cardinality: 0 columns: ! - *931f37a7-5da0-4e1f-aeb3-655f585e7e26 - *4837f923-ff7d-4897-a5cd-71a55154698b index-type: other pages: 0 parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: other unique: true - ! &3637716a-3bc2-43bf-a424-9b119c1482f4 name: IDX_B_WRITERS short-name: WRITERS.IDX_B_WRITERS full-name: PUBLIC.FOR_LINT.WRITERS.IDX_B_WRITERS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: WRITERS TABLE_SCHEM: FOR_LINT cardinality: 0 columns: ! - *6eb8c9b2-1956-483b-b382-2d5968bbdaf9 - *47eb7efd-df59-4f14-a9d2-9bb47fe65391 index-type: other pages: 0 parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: other unique: false - ! &144931c3-cd52-44eb-9318-8e6dfca9e1da name: IDX_A_WRITERS short-name: WRITERS.IDX_A_WRITERS full-name: PUBLIC.FOR_LINT.WRITERS.IDX_A_WRITERS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: WRITERS TABLE_SCHEM: FOR_LINT cardinality: 0 columns: ! - *2f6e5a2c-7e10-4c38-a0b8-009133c66229 - *5c3e9084-7f2e-4d6a-bd5c-4afddfdfd916 - *c78869d1-9149-4772-8922-449422f13779 - *4837f923-ff7d-4897-a5cd-71a55154698b index-type: other pages: 0 parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: other unique: false primary-key: *233186e1-8ad1-4cda-83f2-9de4a4b9cbb3 privileges: ! - ! &e2bc499b-93f8-4bb4-8403-99d16460d2fd name: DELETE short-name: WRITERS."DELETE" full-name: PUBLIC.FOR_LINT.WRITERS."DELETE" grants: ! - ! &c5c4323f-682d-446d-9dd2-c9e7b18cc31d grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &2d510028-3710-4291-8134-e7f0a91cfb63 name: INSERT short-name: WRITERS."INSERT" full-name: PUBLIC.FOR_LINT.WRITERS."INSERT" grants: ! - ! &2df65b43-3b21-4241-91da-2538d19f01dd grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &c71de062-6d80-4d33-979f-929c69ca6e42 name: REFERENCES short-name: WRITERS."REFERENCES" full-name: PUBLIC.FOR_LINT.WRITERS."REFERENCES" grants: ! - ! &7b7043fe-ec64-48f5-ba01-eb813ed9a8a6 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &cdeedfc5-3016-4cc5-890f-d8f4b0bba584 name: SELECT short-name: WRITERS."SELECT" full-name: PUBLIC.FOR_LINT.WRITERS."SELECT" grants: ! - ! &cf6c3795-ed2f-46da-90e1-4c6f38f10884 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &152cdc5e-7513-4448-ba26-5b40fc101b70 name: TRIGGER short-name: WRITERS."TRIGGER" full-name: PUBLIC.FOR_LINT.WRITERS."TRIGGER" grants: ! - ! &c3e7e137-037a-4bdc-96b6-8b018c931862 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &7050bb87-d35d-44a1-85b1-c6c6f06ec18d name: UPDATE short-name: WRITERS."UPDATE" full-name: PUBLIC.FOR_LINT.WRITERS."UPDATE" grants: ! - ! &8c51c62e-599c-42f0-b584-f36f40a4e58f grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf referenced-objects: ! - *0a27c6f5-f94b-4830-ac7c-f14c19da0593 referenced-tables: ! - *0a27c6f5-f94b-4830-ac7c-f14c19da0593 schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: false table-constraints: ! - *233186e1-8ad1-4cda-83f2-9de4a4b9cbb3 - *f7617779-e71b-4dfd-99bf-28bda9e67771 - ! &31651c09-011d-498b-a299-6cc7416f5834 name: CHECK_UPPERCASE_STATE short-name: WRITERS.CHECK_UPPERCASE_STATE full-name: PUBLIC.FOR_LINT.WRITERS.CHECK_UPPERCASE_STATE attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *5c3e9084-7f2e-4d6a-bd5c-4afddfdfd916 deferrable: false definition: FOR_LINT.WRITERS.STATE=UPPER(FOR_LINT.WRITERS.STATE) initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check - ! &0d5af658-7663-4f92-a0d2-b249a3aaea3d name: SYS_CT_10159 short-name: WRITERS.SYS_CT_10159 full-name: PUBLIC.FOR_LINT.WRITERS.SYS_CT_10159 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *81e96953-01be-4073-8d7a-21a52deeb1ec deferrable: false definition: FOR_LINT.WRITERS.ID IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check - ! &d575a9aa-d6db-42df-8a39-cec4b0a9debc name: SYS_CT_10160 short-name: WRITERS.SYS_CT_10160 full-name: PUBLIC.FOR_LINT.WRITERS.SYS_CT_10160 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *47eb7efd-df59-4f14-a9d2-9bb47fe65391 deferrable: false definition: FOR_LINT.WRITERS.FIRSTNAME IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check - ! &714b2b66-89f5-43c6-915c-6288e75ae072 name: SYS_CT_10161 short-name: WRITERS.SYS_CT_10161 full-name: PUBLIC.FOR_LINT.WRITERS.SYS_CT_10161 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *6eb8c9b2-1956-483b-b382-2d5968bbdaf9 deferrable: false definition: FOR_LINT.WRITERS.LASTNAME IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check - ! &e1790e2a-9de4-4737-93c6-925fe12b76a6 name: SYS_CT_10162 short-name: WRITERS.SYS_CT_10162 full-name: PUBLIC.FOR_LINT.WRITERS.SYS_CT_10162 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *49824beb-a915-429e-848a-d9a5c55fdaab deferrable: false definition: FOR_LINT.WRITERS.ADDRESS2 IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check - ! &becf64da-9cbc-4515-8b94-f23ee9c0c47c name: SYS_CT_10163 short-name: WRITERS.SYS_CT_10163 full-name: PUBLIC.FOR_LINT.WRITERS.SYS_CT_10163 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *81830292-b4af-42a4-9906-d13017db60ea deferrable: false definition: FOR_LINT.WRITERS.PUBLICATION_ID IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c used-by-objects: ! - *518fcef3-8680-4bc0-9942-a5d5d6e8d9d9 - *0a27c6f5-f94b-4830-ac7c-f14c19da0593 - *a7d127e7-af96-4a09-8c67-09190e9dfb53 referenced-table: *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: false type: foreign_key update-rule: no action indexes: ! - *1d3f7cc2-4cce-459c-9b57-27c015b5ea14 - *f39c037f-9abf-4ef1-8ec6-47c3e5aa1e19 privileges: ! - ! &efb75aab-f64d-458b-9b4c-e5733f30860b name: DELETE short-name: PUBLICATIONWRITERS."DELETE" full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS."DELETE" grants: ! - ! &15f3c666-6644-4feb-80d9-0c406aff26f5 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &174d3991-fe2c-4e9f-b30d-fee682b7a053 name: INSERT short-name: PUBLICATIONWRITERS."INSERT" full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS."INSERT" grants: ! - ! &3bb3ecc3-d9a0-4535-9b2c-368194abf371 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &b73fb086-28d3-4aa5-b273-74042481374c name: REFERENCES short-name: PUBLICATIONWRITERS."REFERENCES" full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS."REFERENCES" grants: ! - ! &91652984-117f-432b-a4fb-9b53623c67ea grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &9ed4af95-7c7d-4a75-ab85-20a5951c6ea8 name: SELECT short-name: PUBLICATIONWRITERS."SELECT" full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS."SELECT" grants: ! - ! &ea8624df-11c6-4fd0-921f-8f0a9355f852 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &31d935ab-9b8d-4e09-8a8d-a68b768a9c6a name: TRIGGER short-name: PUBLICATIONWRITERS."TRIGGER" full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS."TRIGGER" grants: ! - ! &24e2edbf-6276-49ef-84b8-bd6655ebff6b grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &a543d718-cac6-43d4-961a-6f2f774488f0 name: UPDATE short-name: PUBLICATIONWRITERS."UPDATE" full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS."UPDATE" grants: ! - ! &42d51e04-e09b-4be5-b2e5-a01b646794bd grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf referenced-objects: ! - *0a27c6f5-f94b-4830-ac7c-f14c19da0593 - *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 referenced-tables: ! - *0a27c6f5-f94b-4830-ac7c-f14c19da0593 - *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: false table-constraints: ! - *f39c037f-9abf-4ef1-8ec6-47c3e5aa1e19 - *1d3f7cc2-4cce-459c-9b57-27c015b5ea14 - ! &f78b8c88-5ca3-4e5e-8eef-b9c777636e06 name: SYS_CT_10177 short-name: PUBLICATIONWRITERS.SYS_CT_10177 full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS.SYS_CT_10177 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *982641ae-4988-465f-b265-401f5ff3e10a deferrable: false definition: FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check - ! &5543fc21-0e94-437e-a3da-adfe14c433c4 name: SYS_CT_10178 short-name: PUBLICATIONWRITERS.SYS_CT_10178 full-name: PUBLIC.FOR_LINT.PUBLICATIONWRITERS.SYS_CT_10178 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *887b1924-fa0b-4203-b08a-86b3a77753f6 deferrable: false definition: FOR_LINT.PUBLICATIONWRITERS.WRITERID IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c - *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 foreign-keys: ! - *ed347b53-b499-451f-93bc-481a2a60d48c - *ff5b60f2-6b9f-4a2f-af1f-75f3374b7ef3 - *f39c037f-9abf-4ef1-8ec6-47c3e5aa1e19 - *f7617779-e71b-4dfd-99bf-28bda9e67771 indexes: ! - *ed347b53-b499-451f-93bc-481a2a60d48c - ! &b06e265f-825b-4640-8135-b1ddf47b8cdb name: PK_PUBLICATIONS short-name: PUBLICATIONS.PK_PUBLICATIONS full-name: PUBLIC.FOR_LINT.PUBLICATIONS.PK_PUBLICATIONS attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: PUBLICATIONS TABLE_SCHEM: FOR_LINT cardinality: 0 columns: ! - *c62241a4-53a6-461d-b153-a49498bfd57a index-type: other pages: 0 parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: other unique: true primary-key: *b06e265f-825b-4640-8135-b1ddf47b8cdb privileges: ! - ! &7e410e00-6e55-4d3a-a2f2-dab1f9b2a0fb name: DELETE short-name: PUBLICATIONS."DELETE" full-name: PUBLIC.FOR_LINT.PUBLICATIONS."DELETE" grants: ! - ! &864d7ff8-93d1-408a-afba-71606097a0b3 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &5c96ee6b-f7af-4534-80ae-0e121249ca9a name: INSERT short-name: PUBLICATIONS."INSERT" full-name: PUBLIC.FOR_LINT.PUBLICATIONS."INSERT" grants: ! - ! &82d45268-e87d-4730-9578-5bce05973784 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &37ade7fb-b33a-49a3-ad20-054bdfeb49f3 name: REFERENCES short-name: PUBLICATIONS."REFERENCES" full-name: PUBLIC.FOR_LINT.PUBLICATIONS."REFERENCES" grants: ! - ! &842bfd1f-7160-4e2f-b577-c079b385178a grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &10493641-5678-491f-adf4-cbdaa24096bc name: SELECT short-name: PUBLICATIONS."SELECT" full-name: PUBLIC.FOR_LINT.PUBLICATIONS."SELECT" grants: ! - ! &6eaf219f-4855-4cca-b8d2-ae59167bdb1c grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &52d741fa-c1c6-42cd-9852-0c9867bb859c name: TRIGGER short-name: PUBLICATIONS."TRIGGER" full-name: PUBLIC.FOR_LINT.PUBLICATIONS."TRIGGER" grants: ! - ! &552c60c6-6389-48b9-b9db-d6328ea91d89 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - *c77103b0-2118-45ec-8361-a89f85b4f10d referenced-objects: ! - *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 referenced-tables: ! - *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: false table-constraints: ! - *b06e265f-825b-4640-8135-b1ddf47b8cdb - *ed347b53-b499-451f-93bc-481a2a60d48c - ! &a531796b-b2a8-452d-8ea8-4213f33f10fd name: SYS_CT_10170 short-name: PUBLICATIONS.SYS_CT_10170 full-name: PUBLIC.FOR_LINT.PUBLICATIONS.SYS_CT_10170 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *c62241a4-53a6-461d-b153-a49498bfd57a deferrable: false definition: FOR_LINT.PUBLICATIONS.ID IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check - ! &2ecbbe31-0d23-42d5-b98f-b2e515fc4c44 name: SYS_CT_10171 short-name: PUBLICATIONS.SYS_CT_10171 full-name: PUBLIC.FOR_LINT.PUBLICATIONS.SYS_CT_10171 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *d695f683-4b0c-4914-bf1e-ee8bb9c81421 deferrable: false definition: FOR_LINT.PUBLICATIONS.TITLE IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check - ! &e78a619d-22a4-4519-9733-4647e82994d7 name: SYS_CT_10172 short-name: PUBLICATIONS.SYS_CT_10172 full-name: PUBLIC.FOR_LINT.PUBLICATIONS.SYS_CT_10172 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *0853f52d-27f3-48c3-849a-4bda3f3fa8e5 deferrable: false definition: FOR_LINT.PUBLICATIONS.WRITERID IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c used-by-objects: ! - *518fcef3-8680-4bc0-9942-a5d5d6e8d9d9 - *a7d127e7-af96-4a09-8c67-09190e9dfb53 - *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 referenced-table: *0a27c6f5-f94b-4830-ac7c-f14c19da0593 schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: false type: foreign_key update-rule: no action - *e29753fc-dc78-47ee-80f2-8721b4b85b28 indexes: ! - *e29753fc-dc78-47ee-80f2-8721b4b85b28 - ! &e96b39cd-4aa7-4843-be34-e0ce623f93bc name: PK_EXTRA_PK short-name: EXTRA_PK.PK_EXTRA_PK full-name: PUBLIC.FOR_LINT.EXTRA_PK.PK_EXTRA_PK attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: EXTRA_PK TABLE_SCHEM: FOR_LINT cardinality: 0 columns: ! - *6a2cdd5e-586b-48a0-bac5-35a9e9fd99bc index-type: other pages: 0 parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: other unique: true - *ff5b60f2-6b9f-4a2f-af1f-75f3374b7ef3 primary-key: *e96b39cd-4aa7-4843-be34-e0ce623f93bc privileges: ! - ! &343820fa-5297-4263-ab3b-a7d5c724b617 name: DELETE short-name: EXTRA_PK."DELETE" full-name: PUBLIC.FOR_LINT.EXTRA_PK."DELETE" grants: ! - ! &b4df18f5-21ba-4e56-8a5e-71222248e049 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &2fbd8f87-a598-4823-9324-c000574bab69 name: INSERT short-name: EXTRA_PK."INSERT" full-name: PUBLIC.FOR_LINT.EXTRA_PK."INSERT" grants: ! - ! &403c223f-27ed-4893-a501-67ddef3dc3b9 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &9bbf421f-31b2-48c8-b379-4f1872a96294 name: REFERENCES short-name: EXTRA_PK."REFERENCES" full-name: PUBLIC.FOR_LINT.EXTRA_PK."REFERENCES" grants: ! - ! &8a72d856-9128-4943-9e85-bfc453a3f063 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &b67551bb-476f-4020-8c02-0e7b39f34c62 name: SELECT short-name: EXTRA_PK."SELECT" full-name: PUBLIC.FOR_LINT.EXTRA_PK."SELECT" grants: ! - ! &820482f6-07b7-49f5-ae90-79a6eb165ff1 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &56c14163-8b73-4bc7-a1ae-0160ad98df0a name: TRIGGER short-name: EXTRA_PK."TRIGGER" full-name: PUBLIC.FOR_LINT.EXTRA_PK."TRIGGER" grants: ! - ! &ac5b9d39-f09b-415e-bdcd-6e82f4512290 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &7706524c-ec83-468a-b692-1362c31b8659 name: UPDATE short-name: EXTRA_PK."UPDATE" full-name: PUBLIC.FOR_LINT.EXTRA_PK."UPDATE" grants: ! - ! &3af1bbc0-6cc3-4a64-9bdc-d1dbd66dd19a grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf referenced-objects: ! - *0a27c6f5-f94b-4830-ac7c-f14c19da0593 - *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 referenced-tables: ! - *0a27c6f5-f94b-4830-ac7c-f14c19da0593 - *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 remarks: Extra table with just a primary key schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: false table-constraints: ! - *e96b39cd-4aa7-4843-be34-e0ce623f93bc - *ff5b60f2-6b9f-4a2f-af1f-75f3374b7ef3 - *e29753fc-dc78-47ee-80f2-8721b4b85b28 - ! &ee4fe185-dbf7-4ccd-a0b4-b9b68999f6fb name: SYS_CT_10185 short-name: EXTRA_PK.SYS_CT_10185 full-name: PUBLIC.FOR_LINT.EXTRA_PK.SYS_CT_10185 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *df062cb2-d09c-4f35-a2f2-fca3d85a97fd deferrable: false definition: FOR_LINT.EXTRA_PK.WRITERID IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check - ! &753b417c-8138-4526-b1e4-02b0bc1dcb5b name: SYS_CT_10186 short-name: EXTRA_PK.SYS_CT_10186 full-name: PUBLIC.FOR_LINT.EXTRA_PK.SYS_CT_10186 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *718d4c6d-0a69-4a86-bf2e-ba284eca2ef5 deferrable: false definition: FOR_LINT.EXTRA_PK.PUBLICATIONID IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check - ! &04c997f1-36f8-4537-a75b-1773227fb330 name: SYS_CT_10187 short-name: EXTRA_PK.SYS_CT_10187 full-name: PUBLIC.FOR_LINT.EXTRA_PK.SYS_CT_10187 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *6a2cdd5e-586b-48a0-bac5-35a9e9fd99bc deferrable: false definition: FOR_LINT.EXTRA_PK.ID IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c - ! &da42bff1-563f-428b-8154-61256fbe2f26 name: Global Counts full-name: PUBLIC.FOR_LINT."Global Counts" attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *41cbf72d-96c0-47f1-8fa4-2fa2d3d6a7fe privileges: ! - ! &7b9e2b34-29d5-4a80-9719-6e4a3a91a3f9 name: DELETE short-name: '"Global Counts"."DELETE"' full-name: PUBLIC.FOR_LINT."Global Counts"."DELETE" grants: ! - ! &6edf9242-3d84-4d37-9a0a-942eaea63017 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &01a37948-7db5-4aa0-a7a0-dffcca7e70d4 name: INSERT short-name: '"Global Counts"."INSERT"' full-name: PUBLIC.FOR_LINT."Global Counts"."INSERT" grants: ! - ! &335c8dc7-6933-464e-9756-5c4eb005701c grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &cc7030c4-f11f-4ade-8434-525799b0f7ce name: REFERENCES short-name: '"Global Counts"."REFERENCES"' full-name: PUBLIC.FOR_LINT."Global Counts"."REFERENCES" grants: ! - ! &05df84c0-5c7c-4f45-877c-f0da665e5d2c grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &443a450f-90be-47c3-8735-ab577d62cd65 name: SELECT short-name: '"Global Counts"."SELECT"' full-name: PUBLIC.FOR_LINT."Global Counts"."SELECT" grants: ! - ! &620426a5-9e9d-45e0-b480-a12af2b03e40 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &93229efc-45a7-4128-a932-8f379e1b8f8d name: TRIGGER short-name: '"Global Counts"."TRIGGER"' full-name: PUBLIC.FOR_LINT."Global Counts"."TRIGGER" grants: ! - ! &bc7570dc-38fa-491e-b592-3fad0155e50e grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &6cfd78c2-d4bf-440f-97b3-7d21465d6e33 name: UPDATE short-name: '"Global Counts"."UPDATE"' full-name: PUBLIC.FOR_LINT."Global Counts"."UPDATE" grants: ! - ! &fa48771c-9902-4eb2-ae07-73c1202f9549 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: false table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c - *0a27c6f5-f94b-4830-ac7c-f14c19da0593 - *a7d127e7-af96-4a09-8c67-09190e9dfb53 - ! &db04adc9-4c45-4901-a260-7735b515a21c name: SELFREFERENCE full-name: PUBLIC.FOR_LINT.SELFREFERENCE attributes: ! HSQLDB_TYPE: MEMORY READ_ONLY: false REMARKS: "" columns: ! - *b2325c37-9956-4efb-9b42-2d1ecc07eb17 - *b56b8286-194b-430b-8efe-2a6278449454 dependent-tables: ! - *db04adc9-4c45-4901-a260-7735b515a21c foreign-keys: ! - ! &6e15153a-56ef-4c2b-9f04-2e2891767104 name: FK_SELFREFERENCE short-name: SELFREFERENCE.FK_SELFREFERENCE full-name: PUBLIC.FOR_LINT.SELFREFERENCE.FK_SELFREFERENCE attributes: ! PK_NAME: PK_SELFREFERENCE TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT column-references: ! - ! &e29ff98d-5881-401c-bb15-11919735ccfe foreign-key-column: *b2325c37-9956-4efb-9b42-2d1ecc07eb17 key-sequence: 1 primary-key-column: *b2325c37-9956-4efb-9b42-2d1ecc07eb17 self-referencing: true constrained-columns: ! - *b2325c37-9956-4efb-9b42-2d1ecc07eb17 deferrability: not deferrable deferrable: false delete-rule: no action dependent-table: *db04adc9-4c45-4901-a260-7735b515a21c foreign-key-table: *db04adc9-4c45-4901-a260-7735b515a21c initially-deferred: false optional: false parent-partial: false primary-key-table: *db04adc9-4c45-4901-a260-7735b515a21c referenced-table: *db04adc9-4c45-4901-a260-7735b515a21c schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: true type: foreign_key update-rule: no action indexes: ! - ! &a171637f-1f8d-4c7b-b00c-6b769ca27475 name: PK_SELFREFERENCE short-name: SELFREFERENCE.PK_SELFREFERENCE full-name: PUBLIC.FOR_LINT.SELFREFERENCE.PK_SELFREFERENCE attributes: ! INDEX_QUALIFIER: PUBLIC TABLE_CAT: PUBLIC TABLE_NAME: SELFREFERENCE TABLE_SCHEM: FOR_LINT cardinality: 0 columns: ! - *b2325c37-9956-4efb-9b42-2d1ecc07eb17 index-type: other pages: 0 parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: other unique: true - *6e15153a-56ef-4c2b-9f04-2e2891767104 primary-key: *a171637f-1f8d-4c7b-b00c-6b769ca27475 privileges: ! - ! &cd3484bc-5fce-4b8b-81b0-7b0a4e3d3295 name: DELETE short-name: SELFREFERENCE."DELETE" full-name: PUBLIC.FOR_LINT.SELFREFERENCE."DELETE" grants: ! - ! &e8ed785a-7ba0-41d3-867a-c2efe599d355 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &378fb637-f7be-4bc2-ab5f-866cd51dcc44 name: INSERT short-name: SELFREFERENCE."INSERT" full-name: PUBLIC.FOR_LINT.SELFREFERENCE."INSERT" grants: ! - ! &b9cbad10-7a45-4984-9273-b48c0eeaeefa grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &16cf179e-f223-4a94-a498-24b647bfe7b9 name: REFERENCES short-name: SELFREFERENCE."REFERENCES" full-name: PUBLIC.FOR_LINT.SELFREFERENCE."REFERENCES" grants: ! - ! &568f50c4-84f5-4556-b091-c3a3da17a4ef grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &fbfa3c49-d790-42f1-933d-fde185e424a3 name: SELECT short-name: SELFREFERENCE."SELECT" full-name: PUBLIC.FOR_LINT.SELFREFERENCE."SELECT" grants: ! - ! &f82db89f-1e29-4cd3-99ab-e189784c7764 grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &79fbabf2-c518-40c2-abf7-31731895aa55 name: TRIGGER short-name: SELFREFERENCE."TRIGGER" full-name: PUBLIC.FOR_LINT.SELFREFERENCE."TRIGGER" grants: ! - ! &e2347ed1-2f6e-49d1-af12-08db9f08ce8d grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf - ! &993cbd82-2009-445b-82c1-05186810203b name: UPDATE short-name: SELFREFERENCE."UPDATE" full-name: PUBLIC.FOR_LINT.SELFREFERENCE."UPDATE" grants: ! - ! &2a6c07e3-9df6-4e53-b0a4-f3cef731129f grantable: true grantee: DBA grantor: _SYSTEM parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf referenced-objects: ! - *db04adc9-4c45-4901-a260-7735b515a21c referenced-tables: ! - *db04adc9-4c45-4901-a260-7735b515a21c schema: *50571370-29a6-46ba-af20-d540170d65cf self-referencing: true table-constraints: ! - *a171637f-1f8d-4c7b-b00c-6b769ca27475 - *6e15153a-56ef-4c2b-9f04-2e2891767104 - ! &25256fc7-57c7-460f-aee9-58ed364572e4 name: SYS_CT_10193 short-name: SELFREFERENCE.SYS_CT_10193 full-name: PUBLIC.FOR_LINT.SELFREFERENCE.SYS_CT_10193 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *b2325c37-9956-4efb-9b42-2d1ecc07eb17 deferrable: false definition: FOR_LINT.SELFREFERENCE.ID IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check - ! &2477eb17-3ae4-4915-9cf2-ce8f9cd9350f name: SYS_CT_10194 short-name: SELFREFERENCE.SYS_CT_10194 full-name: PUBLIC.FOR_LINT.SELFREFERENCE.SYS_CT_10194 attributes: ! TABLE_CATALOG: PUBLIC TABLE_SCHEMA: FOR_LINT constrained-columns: ! - *b56b8286-194b-430b-8efe-2a6278449454 deferrable: false definition: FOR_LINT.SELFREFERENCE.TITLE IS NOT NULL initially-deferred: false parent-partial: false schema: *50571370-29a6-46ba-af20-d540170d65cf type: check table-type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c type: *cf906f5e-1f8e-4065-b4d9-e2f4b890b37c used-by-objects: ! - *db04adc9-4c45-4901-a260-7735b515a21c - *a2bbf76b-7d4d-489b-a984-c4d3b9f16bd0 - *58b77bf4-0ae1-42dd-bd93-8f7a275401ff - *db454079-ffb5-4633-b0ce-a487e8c68303 - *87378231-a2c9-453f-abf3-ed11ca07b944