--- &f0204f74-44e6-418f-9d3c-c11477ae5ff7 all-table-columns: - &8620660f-c14c-4225-8082-3f564059cbbe name: "ID" short-name: "AUTHORS.ID" full-name: "PUBLIC.BOOKS.AUTHORS.ID" 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: &f4f636c3-3f79-4cf1-b9bc-0182150a25ab name: "INTEGER" full-name: "INTEGER" attributes: {} auto-incrementable: true base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "INTEGER" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &ef4963e1-6271-4efc-905d-c3eff952d8d0 name: "INTEGER" default-mapped-class: "java.lang.Integer" java-sql-type-group: "integer" vendor: "java.sql" vendor-type-number: 4 literal-prefix: null literal-suffix: null local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 32 remarks: "" schema: &89f00b17-f1d7-4f6f-a736-ddc124ae8c57 name: null full-name: "" attributes: {} catalog-name: null remarks: "" searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.lang.Integer" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: &68885dda-4857-405a-9011-535efc7e73b9 name: "BOOKS" full-name: "PUBLIC.BOOKS" attributes: {} catalog-name: "PUBLIC" remarks: "" size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &fafe546e-27eb-4c1d-9a66-1d9a003813cc name: "ID" short-name: "AUTHORSLIST.ID" full-name: "PUBLIC.BOOKS.AUTHORSLIST.ID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &0ea2674c-92ec-40c5-b534-969521cddeac name: "BOOKID" short-name: "BOOKAUTHORS.BOOKID" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.BOOKID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &3d0e98a7-a907-42f8-adc4-e422d13cf6f8 name: "ID" short-name: "BOOKS.ID" full-name: "PUBLIC.BOOKS.BOOKS.ID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "Unique (internal) id for book" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &d32433de-3e05-4356-a5b0-fc4306f550f3 name: "Id" short-name: "\"Celebrities\".\"Id\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"Id\"" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &ddff5076-668b-475a-83dd-40d6554350ca name: "Celebrity Id" short-name: "\"Celebrity Updates\".\"Celebrity Id\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"Celebrity Id\"" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &9c2dfb11-fcc2-40ea-b8a5-5fd349312ad0 name: "ID" short-name: "COUPONS.ID" full-name: "PUBLIC.BOOKS.COUPONS.ID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &11c8b427-bb2e-439d-874c-718b3713dc2b name: "ID" short-name: "CUSTOMERDATA.ID" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.ID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &7ee04bb4-801d-4728-b877-3213178485cf name: "ID" short-name: "CUSTOMERS.ID" full-name: "PUBLIC.BOOKS.CUSTOMERS.ID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &3b504be2-072b-4f97-9af9-53f7b779198e name: "ID" short-name: "PUBLISHERS.ID" full-name: "PUBLIC.BOOKS.PUBLISHERS.ID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "Unique (internal) id for book publisher" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &50a34d32-6c48-4c5a-9052-7fea82f21b1c name: "ΜΟΝΑΔΙΚΌΣ" short-name: "ΒΙΒΛΊΑ.ΜΟΝΑΔΙΚΌΣ" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΜΟΝΑΔΙΚΌΣ" 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: &688a578b-cbe6-4846-a3b3-945797b4f2a3 name: "SMALLINT" full-name: "SMALLINT" attributes: {} auto-incrementable: true base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "SMALLINT" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &e8ac12c9-3de6-471c-8430-b8b002348a86 name: "SMALLINT" default-mapped-class: "java.lang.Integer" java-sql-type-group: "integer" vendor: "java.sql" vendor-type-number: 5 literal-prefix: null literal-suffix: null local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 16 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.lang.Integer" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 16 type: *688a578b-cbe6-4846-a3b3-945797b4f2a3 width: "" - &08b6b92f-c297-4e08-9411-7666d4105639 name: "WRITERID" short-name: "EXTRA_PK.WRITERID" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.WRITERID" 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: &250cb17c-c37c-4a89-a9e2-b6d54de597b0 name: "BIGINT" full-name: "BIGINT" attributes: {} auto-incrementable: true base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "BIGINT" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &f9fd712a-d37a-44d7-8571-503ec66798b9 name: "BIGINT" default-mapped-class: "java.lang.Long" java-sql-type-group: "integer" vendor: "java.sql" vendor-type-number: -5 literal-prefix: null literal-suffix: null local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 64 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.lang.Long" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: &47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d name: "FOR_LINT" full-name: "PUBLIC.FOR_LINT" attributes: {} catalog-name: "PUBLIC" remarks: "" size: 64 type: *250cb17c-c37c-4a89-a9e2-b6d54de597b0 width: "" - &2949cc91-d31a-4bf9-86f6-519ab05804fe name: "ID" short-name: "WRITERS.ID" full-name: "PUBLIC.FOR_LINT.WRITERS.ID" 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: *250cb17c-c37c-4a89-a9e2-b6d54de597b0 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 64 type: *250cb17c-c37c-4a89-a9e2-b6d54de597b0 width: "" - &b65403ed-8b6f-4c5b-b603-45d079637399 name: "Global Count" short-name: "\"Global Counts\".\"Global Count\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"Global Count\"" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &d4c0280f-c218-4dcb-bae8-d096b823634a name: "ID" short-name: "PUBLICATIONS.ID" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.ID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &6165f946-f35b-4be9-baee-274d079e3dc2 name: "PUBLICATIONID" short-name: "PUBLICATIONWRITERS.PUBLICATIONID" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &72251d8a-c72c-4078-b176-e0dcfb003976 name: "ID" short-name: "SELFREFERENCE.ID" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.ID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &5b6bf706-af3f-4f75-a446-4a0095f4ac36 name: "SALESDATAID" short-name: "SALESDATA.SALESDATAID" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.SALESDATAID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: &4308eb4a-58d4-44d5-9780-8ee25ea4dec2 name: "PUBLISHER SALES" full-name: "PUBLIC.\"PUBLISHER SALES\"" attributes: {} catalog-name: "PUBLIC" remarks: "" size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &e0d3695d-2adb-430c-baca-bf87e641b722 name: "CITY" short-name: "REGIONS.CITY" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.CITY" attributes: CHAR_OCTET_LENGTH: 50 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: &172781b6-2281-47c9-a009-afa041bc6163 name: "VARCHAR" full-name: "VARCHAR" attributes: {} auto-incrementable: false base-type: null case-sensitive: true create-parameters: "LENGTH" database-specific-type-name: "VARCHAR" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &20b7d449-23a2-468f-9e51-608139933124 name: "VARCHAR" default-mapped-class: "java.lang.String" java-sql-type-group: "character" vendor: "java.sql" vendor-type-number: 12 literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable" type: "system" type-mapped-class: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 50 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(50)" - &f117ae54-fa00-4828-a568-d0a16dad988b name: "POSTALCODE" short-name: "SALES.POSTALCODE" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.POSTALCODE" attributes: CHAR_OCTET_LENGTH: 10 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 10 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(10)" - &6912abfd-3546-43d2-b286-deb6ed627d94 name: "DATA" short-name: "COUPONS.DATA" full-name: "PUBLIC.BOOKS.COUPONS.DATA" attributes: CHAR_OCTET_LENGTH: 1073741824 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 40 auto-incremented: false column-data-type: &507bba9d-8aeb-40e7-83ad-c88e1a97545a name: "CLOB" full-name: "CLOB" attributes: {} auto-incrementable: false base-type: null case-sensitive: true create-parameters: "LENGTH" database-specific-type-name: "CLOB" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &194276c5-7c98-420c-935d-608995406be2 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: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "not searchable" type: "system" type-mapped-class: "java.sql.Clob" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 1073741824 type: *507bba9d-8aeb-40e7-83ad-c88e1a97545a width: "" - &7d5fc016-e8c5-4576-a6e0-77fa7e1871fa name: "AUTHORID" short-name: "BOOKAUTHORS.AUTHORID" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.AUTHORID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &7f91c7ef-51d2-4224-ac5a-8adacc4cfb89 name: "FIRSTNAME" short-name: "AUTHORS.FIRSTNAME" full-name: "PUBLIC.BOOKS.AUTHORS.FIRSTNAME" attributes: CHAR_OCTET_LENGTH: 20 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 20 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(20)" - &7ccd2a72-bac3-4214-837a-6e3e7837c19e name: "FIRSTNAME" short-name: "AUTHORSLIST.FIRSTNAME" full-name: "PUBLIC.BOOKS.AUTHORSLIST.FIRSTNAME" attributes: CHAR_OCTET_LENGTH: 20 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 20 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(20)" - &a1b5484e-993d-4d6c-821c-aa4385cc435d name: "TITLE" short-name: "BOOKS.TITLE" full-name: "PUBLIC.BOOKS.BOOKS.TITLE" attributes: CHAR_OCTET_LENGTH: 255 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "Book title" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "Book title" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &221f74fb-9309-440a-8ca9-8ce5f90abba3 name: "NAME" short-name: "\"Celebrities\".NAME" full-name: "PUBLIC.BOOKS.\"Celebrities\".NAME" attributes: CHAR_OCTET_LENGTH: 20 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 20 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(20)" - &e293a141-8ca1-496b-9e49-827546c46e8b name: "UPDATE" short-name: "\"Celebrity Updates\".\"UPDATE\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"UPDATE\"" attributes: CHAR_OCTET_LENGTH: 20 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 20 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(20)" - &8af5a6ac-e405-4e7b-88fc-4050f7c22be7 name: "PUBLISHER" short-name: "PUBLISHERS.PUBLISHER" full-name: "PUBLIC.BOOKS.PUBLISHERS.PUBLISHER" 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: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "Name of book publisher" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &0d976223-673c-49d1-a1f6-1298fedb8015 name: "ΤΊΤΛΟΣ" short-name: "ΒΙΒΛΊΑ.ΤΊΤΛΟΣ" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΤΊΤΛΟΣ" attributes: CHAR_OCTET_LENGTH: 255 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &2bf02a01-eca3-49f3-aa1f-52df00c3a29e name: "FIRSTNAME" short-name: "CUSTOMERS.FIRSTNAME" full-name: "PUBLIC.BOOKS.CUSTOMERS.FIRSTNAME" 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: &01ac2033-6b93-40d0-802b-7d1c5b3d487f name: "NAME_TYPE" full-name: "PUBLIC.BOOKS.NAME_TYPE" attributes: REMARKS: "" TYPE_CAT: "PUBLIC" TYPE_SCHEM: "BOOKS" auto-incrementable: false base-type: null case-sensitive: false create-parameters: "" database-specific-type-name: "NAME_TYPE" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &70950668-5fd0-45f4-84e2-3c3cb2222f95 name: "DISTINCT" default-mapped-class: "java.lang.Object" java-sql-type-group: "object" vendor: "java.sql" vendor-type-number: 2001 literal-prefix: "" literal-suffix: "" local-type-name: "" maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 searchable: "not searchable" type: "user_defined" type-mapped-class: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 100 type: *01ac2033-6b93-40d0-802b-7d1c5b3d487f width: "" - &d956e174-ed35-4007-9d90-17f0538c789f name: "DATA" short-name: "CUSTOMERDATA.DATA" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.DATA" 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: &6cc37d05-f749-4987-a164-862f2e2e3db6 name: "VALID_STRING" full-name: "PUBLIC.BOOKS.VALID_STRING" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: "" database-specific-type-name: "VALID_STRING" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: *20b7d449-23a2-468f-9e51-608139933124 literal-prefix: "" literal-suffix: "" local-type-name: "" maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 searchable: "not searchable" type: "user_defined" type-mapped-class: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 20 type: *6cc37d05-f749-4987-a164-862f2e2e3db6 width: "(20)" - &6336baae-3336-453e-b12d-67e06b2b757e name: "WRITERID" short-name: "PUBLICATIONWRITERS.WRITERID" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.WRITERID" 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: *250cb17c-c37c-4a89-a9e2-b6d54de597b0 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 64 type: *250cb17c-c37c-4a89-a9e2-b6d54de597b0 width: "" - &1f956340-4f70-474b-a62f-e67257729c01 name: "PUBLICATIONID" short-name: "EXTRA_PK.PUBLICATIONID" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.PUBLICATIONID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &19e9fdb3-1f90-4dec-9b77-f79bb9423630 name: "TITLE" short-name: "PUBLICATIONS.TITLE" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.TITLE" attributes: CHAR_OCTET_LENGTH: 255 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "Publication title" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "Publication title" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &aad3ac31-b9e5-44ee-b76f-3ad3b0a23d60 name: "TITLE" short-name: "SELFREFERENCE.TITLE" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.TITLE" attributes: CHAR_OCTET_LENGTH: 255 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &bc9d9242-07e0-452f-ba80-1ad75778afea name: "FIRSTNAME" short-name: "WRITERS.FIRSTNAME" full-name: "PUBLIC.FOR_LINT.WRITERS.FIRSTNAME" attributes: CHAR_OCTET_LENGTH: 20 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 20 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(20)" - &3f437f04-56ef-4cb0-80e6-93398d75233e name: "YEARLYAMOUNT" short-name: "SALESDATA.YEARLYAMOUNT" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.YEARLYAMOUNT" 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: &5cb2c7bd-d28a-41d1-ba5e-06360ee78259 name: "DOUBLE" full-name: "DOUBLE" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "DOUBLE" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &8e6ec223-88d0-4ccb-9426-4357c39079e2 name: "DOUBLE" default-mapped-class: "java.lang.Double" java-sql-type-group: "real" vendor: "java.sql" vendor-type-number: 8 literal-prefix: null literal-suffix: null local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 64 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.lang.Double" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 64 type: *5cb2c7bd-d28a-41d1-ba5e-06360ee78259 width: "(64, 0)" - &009affa4-8456-4ab6-a7fc-565340810e7c name: "STATE" short-name: "REGIONS.STATE" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.STATE" attributes: CHAR_OCTET_LENGTH: 2 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 2 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(2)" - &229789e7-b83c-469f-8154-a3428b41f6b2 name: "COUNTRY" short-name: "SALES.COUNTRY" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.COUNTRY" attributes: CHAR_OCTET_LENGTH: 50 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 50 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(50)" - &c90f980e-70df-4358-8923-fe18f69a0313 name: "LASTNAME" short-name: "AUTHORS.LASTNAME" full-name: "PUBLIC.BOOKS.AUTHORS.LASTNAME" attributes: CHAR_OCTET_LENGTH: 20 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 20 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(20)" - &ea4e3666-cc9b-4480-adfe-e97cc8c0fad3 name: "LASTNAME" short-name: "AUTHORSLIST.LASTNAME" full-name: "PUBLIC.BOOKS.AUTHORSLIST.LASTNAME" attributes: CHAR_OCTET_LENGTH: 20 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 20 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(20)" - &87895c73-5d86-4f98-ba74-4036df8070c8 name: "SOMEDATA" short-name: "BOOKAUTHORS.SOMEDATA" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.SOMEDATA" attributes: CHAR_OCTET_LENGTH: 30 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 30 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(30)" - &21074e10-2c22-45d3-b4bc-78390d4cc4ef name: "DESCRIPTION" short-name: "BOOKS.DESCRIPTION" full-name: "PUBLIC.BOOKS.BOOKS.DESCRIPTION" attributes: CHAR_OCTET_LENGTH: 255 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "Book description\n(Usually the blurb from the book jacket or promotional\ \ materials)" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "Book description\n(Usually the blurb from the book jacket or promotional\ \ materials)" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &516b9cff-b481-4a4c-b212-fba2245c0723 name: "ΠΕΡΙΓΡΑΦΉ" short-name: "ΒΙΒΛΊΑ.ΠΕΡΙΓΡΑΦΉ" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΠΕΡΙΓΡΑΦΉ" attributes: CHAR_OCTET_LENGTH: 255 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &0e4998e7-3330-486a-aea3-8d903a37fa73 name: "COUPONS" short-name: "COUPONS.COUPONS" full-name: "PUBLIC.BOOKS.COUPONS.COUPONS" attributes: CHAR_OCTET_LENGTH: 0 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 50 auto-incremented: false column-data-type: &b99a1ba2-1865-4629-9d72-512e2894e88d name: "INTEGER ARRAY" full-name: "PUBLIC.BOOKS.\"INTEGER ARRAY\"" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: "" database-specific-type-name: "INTEGER ARRAY" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &f6abde88-6e9d-454e-9975-90f788a35010 name: "ARRAY" default-mapped-class: "java.sql.Array" java-sql-type-group: "object" vendor: "java.sql" vendor-type-number: 2003 literal-prefix: "" literal-suffix: "" local-type-name: "" maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 searchable: "not searchable" type: "user_defined" type-mapped-class: "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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 0 type: *b99a1ba2-1865-4629-9d72-512e2894e88d width: "" - &41c3e677-33e7-4997-ae99-b21479b1a341 name: "LASTNAME" short-name: "CUSTOMERS.LASTNAME" full-name: "PUBLIC.BOOKS.CUSTOMERS.LASTNAME" 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: *01ac2033-6b93-40d0-802b-7d1c5b3d487f column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 100 type: *01ac2033-6b93-40d0-802b-7d1c5b3d487f width: "" - &323720b3-0bad-4eda-b3ea-a61f71782332 name: "ID" short-name: "EXTRA_PK.ID" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.ID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &95c35433-ec0c-4d4d-91e3-83c76afead98 name: "DESCRIPTION" short-name: "PUBLICATIONS.DESCRIPTION" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.DESCRIPTION" attributes: CHAR_OCTET_LENGTH: 255 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &f368cba1-1fe4-41c5-9a1e-8b1e8f75530d name: "LASTNAME" short-name: "WRITERS.LASTNAME" full-name: "PUBLIC.FOR_LINT.WRITERS.LASTNAME" attributes: CHAR_OCTET_LENGTH: 20 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 20 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(20)" - &c4c21e9b-9062-469b-a98d-6bc6ac0b1831 name: "BOOKID" short-name: "SALES.BOOKID" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.BOOKID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &6befdb42-8ea2-4ced-9301-ea4b3f656cd3 name: "POSTALCODE" short-name: "REGIONS.POSTALCODE" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.POSTALCODE" attributes: CHAR_OCTET_LENGTH: 10 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 10 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(10)" - &74929c26-1c03-490a-88c3-c8f58f3c616f name: "PUBLISHERID" short-name: "BOOKS.PUBLISHERID" full-name: "PUBLIC.BOOKS.BOOKS.PUBLISHERID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "Foreign key to the book publisher" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &a6c9d700-7ca9-4c0d-894c-7b27ef6034a9 name: "ΕΚΔΌΤΗΣ" short-name: "ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ" 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: *688a578b-cbe6-4846-a3b3-945797b4f2a3 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 16 type: *688a578b-cbe6-4846-a3b3-945797b4f2a3 width: "" - &66395e0e-2924-41a5-b8bf-8b645cdbec5b name: "ADDRESS1" short-name: "AUTHORS.ADDRESS1" full-name: "PUBLIC.BOOKS.AUTHORS.ADDRESS1" attributes: CHAR_OCTET_LENGTH: 255 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &f925bf6a-b58e-49e3-a4e5-9292cb828ce6 name: "AGE" short-name: "CUSTOMERS.AGE" full-name: "PUBLIC.BOOKS.CUSTOMERS.AGE" 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: &0e27eff0-d231-406f-b49e-c1a16f7930d1 name: "AGE_TYPE" full-name: "PUBLIC.BOOKS.AGE_TYPE" attributes: REMARKS: "" TYPE_CAT: "PUBLIC" TYPE_SCHEM: "BOOKS" auto-incrementable: false base-type: *688a578b-cbe6-4846-a3b3-945797b4f2a3 case-sensitive: false create-parameters: "" database-specific-type-name: "AGE_TYPE" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: *70950668-5fd0-45f4-84e2-3c3cb2222f95 literal-prefix: "" literal-suffix: "" local-type-name: "" maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 searchable: "not searchable" type: "user_defined" type-mapped-class: "java.lang.Integer" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 16 type: *0e27eff0-d231-406f-b49e-c1a16f7930d1 width: "" - &78d6d8b7-1d2b-4ab5-b27a-03f7b6357591 name: "BOOKS" short-name: "COUPONS.BOOKS" full-name: "PUBLIC.BOOKS.COUPONS.BOOKS" attributes: CHAR_OCTET_LENGTH: 0 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 50 auto-incremented: false column-data-type: &4fd16078-65b2-4286-b309-4d440c918cec name: "VARCHAR(20) ARRAY[10]" full-name: "PUBLIC.BOOKS.\"VARCHAR(20) ARRAY[10]\"" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: "" database-specific-type-name: "VARCHAR(20) ARRAY[10]" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: *f6abde88-6e9d-454e-9975-90f788a35010 literal-prefix: "" literal-suffix: "" local-type-name: "" maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 searchable: "not searchable" type: "user_defined" type-mapped-class: "java.sql.Array" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 0 type: *4fd16078-65b2-4286-b309-4d440c918cec width: "" - &637aa922-3279-44e6-8150-badb2eb4b9cc name: "WRITERID" short-name: "PUBLICATIONS.WRITERID" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.WRITERID" 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: *250cb17c-c37c-4a89-a9e2-b6d54de597b0 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 64 type: *250cb17c-c37c-4a89-a9e2-b6d54de597b0 width: "" - &7cfe2243-e6f1-4e88-befd-456578cafa94 name: "ADDRESS1" short-name: "WRITERS.ADDRESS1" full-name: "PUBLIC.FOR_LINT.WRITERS.ADDRESS1" attributes: CHAR_OCTET_LENGTH: 255 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &0ce7f80b-1fbd-49bc-a25c-0a72744dd3a1 name: "COUPON_ID" short-name: "SALES.COUPON_ID" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.COUPON_ID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &be8e2d7c-c3c7-42cb-b34a-6d0a21ded9eb name: "COUNTRY" short-name: "REGIONS.COUNTRY" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.COUNTRY" attributes: CHAR_OCTET_LENGTH: 50 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 50 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(50)" - &c9d62130-0d1a-4014-9d85-65e7f31d72d4 name: "PUBLICATIONDATE" short-name: "BOOKS.PUBLICATIONDATE" full-name: "PUBLIC.BOOKS.BOOKS.PUBLICATIONDATE" 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: &a3a338ae-80af-46a5-8124-f4304b7d88bd name: "DATE" full-name: "DATE" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "DATE" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &74b24739-f5a2-4658-922e-616193bee178 name: "DATE" default-mapped-class: "java.sql.Date" java-sql-type-group: "temporal" vendor: "java.sql" vendor-type-number: 91 literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.sql.Date" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "Book publication date" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 10 type: *a3a338ae-80af-46a5-8124-f4304b7d88bd width: "" - &bb0b24c4-2a84-459f-b30b-b0331ce3e37a name: "ADDRESS2" short-name: "AUTHORS.ADDRESS2" full-name: "PUBLIC.BOOKS.AUTHORS.ADDRESS2" attributes: CHAR_OCTET_LENGTH: 255 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &e002c5e2-d162-413b-af4a-ac8636120c28 name: "PUBLICATIONDATE" short-name: "PUBLICATIONS.PUBLICATIONDATE" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.PUBLICATIONDATE" 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: *a3a338ae-80af-46a5-8124-f4304b7d88bd column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 10 type: *a3a338ae-80af-46a5-8124-f4304b7d88bd width: "" - &0e41b547-992f-4042-9aea-5ff4c819243f name: "ADDRESS2" short-name: "WRITERS.ADDRESS2" full-name: "PUBLIC.FOR_LINT.WRITERS.ADDRESS2" attributes: CHAR_OCTET_LENGTH: 255 IS_GENERATED: "NEVER" IS_NULLABLE: "NO" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 255 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(255)" - &954904c5-bd9e-4288-b6c0-85b616c25fc4 name: "PERIODENDDATE" short-name: "SALES.PERIODENDDATE" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.PERIODENDDATE" 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: *a3a338ae-80af-46a5-8124-f4304b7d88bd column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 10 type: *a3a338ae-80af-46a5-8124-f4304b7d88bd width: "" - &2c6cca8f-bc59-4ca0-b463-0d94e5e0edd8 name: "PRICE" short-name: "BOOKS.PRICE" full-name: "PUBLIC.BOOKS.BOOKS.PRICE" 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: *5cb2c7bd-d28a-41d1-ba5e-06360ee78259 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "Current price for the book" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 64 type: *5cb2c7bd-d28a-41d1-ba5e-06360ee78259 width: "(64, 0)" - &0b722643-63c3-4fe5-8248-bcb68a79f3d2 name: "CITY" short-name: "AUTHORS.CITY" full-name: "PUBLIC.BOOKS.AUTHORS.CITY" attributes: CHAR_OCTET_LENGTH: 50 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 50 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(50)" - &1d5dd639-2706-4a4e-8554-d36e0674a6e4 name: "PRICE" short-name: "PUBLICATIONS.PRICE" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.PRICE" 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: *5cb2c7bd-d28a-41d1-ba5e-06360ee78259 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 64 type: *5cb2c7bd-d28a-41d1-ba5e-06360ee78259 width: "(64, 0)" - &dbfc77d6-5272-453b-a9e2-f42a3940cac8 name: "CITY" short-name: "WRITERS.CITY" full-name: "PUBLIC.FOR_LINT.WRITERS.CITY" attributes: CHAR_OCTET_LENGTH: 50 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 50 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(50)" - &1f26262a-374f-4ad8-934d-a4af5cbe9403 name: "TOTALAMOUNT" short-name: "SALES.TOTALAMOUNT" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.TOTALAMOUNT" 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: *5cb2c7bd-d28a-41d1-ba5e-06360ee78259 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 64 type: *5cb2c7bd-d28a-41d1-ba5e-06360ee78259 width: "(64, 0)" - &488b2bc3-a419-4a43-8c62-f3a012154145 name: "STATE" short-name: "AUTHORS.STATE" full-name: "PUBLIC.BOOKS.AUTHORS.STATE" attributes: CHAR_OCTET_LENGTH: 2 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 1 auto-incremented: false column-data-type: &b6c9ac06-7364-456a-a525-9b69fb635f65 name: "CHARACTER" full-name: "CHARACTER" attributes: {} auto-incrementable: false base-type: null case-sensitive: true create-parameters: "LENGTH" database-specific-type-name: "CHARACTER" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &ba62ddfc-2175-4afd-8575-8643da8c7bf6 name: "CHAR" default-mapped-class: "java.lang.String" java-sql-type-group: "character" vendor: "java.sql" vendor-type-number: 1 literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable" type: "system" type-mapped-class: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 2 type: *b6c9ac06-7364-456a-a525-9b69fb635f65 width: "(2)" - &a2e39798-2c72-4fbd-8f34-755dd4c16d6e name: "PREVIOUSEDITIONID" short-name: "BOOKS.PREVIOUSEDITIONID" full-name: "PUBLIC.BOOKS.BOOKS.PREVIOUSEDITIONID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &a6c6809c-7d4a-472b-92a9-f64cc52a6288 name: "UPDATE" short-name: "PUBLICATIONS.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"UPDATE\"" attributes: CHAR_OCTET_LENGTH: 1073741824 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 40 auto-incremented: false column-data-type: *507bba9d-8aeb-40e7-83ad-c88e1a97545a column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 1073741824 type: *507bba9d-8aeb-40e7-83ad-c88e1a97545a width: "" - &ecf6f2f8-1cc8-452f-bdd7-078e29851c1c name: "STATE" short-name: "WRITERS.STATE" full-name: "PUBLIC.FOR_LINT.WRITERS.STATE" attributes: CHAR_OCTET_LENGTH: 2 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 2 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(2)" - &f932940f-c716-4786-9a83-3853f16fbad5 name: "SALESDATAID" short-name: "SALES.SALESDATAID" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.SALESDATAID" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &2d4ab0c2-228f-4130-9739-5194c4efaf45 name: "POSTALCODE" short-name: "AUTHORS.POSTALCODE" full-name: "PUBLIC.BOOKS.AUTHORS.POSTALCODE" attributes: CHAR_OCTET_LENGTH: 10 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 10 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(10)" - &668c2cc8-4e83-4e97-8d7b-53a3733d4059 name: "PRESS_RELEASE" short-name: "PUBLICATIONS.PRESS_RELEASE" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.PRESS_RELEASE" attributes: CHAR_OCTET_LENGTH: 1073741824 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 40 auto-incremented: false column-data-type: *507bba9d-8aeb-40e7-83ad-c88e1a97545a column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 1073741824 type: *507bba9d-8aeb-40e7-83ad-c88e1a97545a width: "" - &465223d8-d3e6-46d7-bceb-f9acd51489a1 name: "POSTALCODE" short-name: "WRITERS.POSTALCODE" full-name: "PUBLIC.FOR_LINT.WRITERS.POSTALCODE" attributes: CHAR_OCTET_LENGTH: 10 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 10 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(10)" - &1b78561b-b155-48ca-9b02-f6b5bf9e19ce name: "COUNTRY" short-name: "AUTHORS.COUNTRY" full-name: "PUBLIC.BOOKS.AUTHORS.COUNTRY" attributes: CHAR_OCTET_LENGTH: 50 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 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-unique-index: false privileges: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 size: 50 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(50)" - &f88b80fc-c2e2-4ae2-9f0d-7b4a7eb75906 name: "COUNTRY" short-name: "WRITERS.COUNTRY" full-name: "PUBLIC.FOR_LINT.WRITERS.COUNTRY" attributes: CHAR_OCTET_LENGTH: 50 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 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-unique-index: true privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 50 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(50)" - &1431c7a4-ac87-44f7-bb93-647f35599064 name: "PHONE1" short-name: "WRITERS.PHONE1" full-name: "PUBLIC.FOR_LINT.WRITERS.PHONE1" attributes: CHAR_OCTET_LENGTH: 10 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 10 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(10)" - &f30409eb-353c-4050-9e0e-14eb6df04d9e name: "PHONE2" short-name: "WRITERS.PHONE2" full-name: "PUBLIC.FOR_LINT.WRITERS.PHONE2" attributes: CHAR_OCTET_LENGTH: 15 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 15 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(15)" - &31233b82-1f43-4505-aa5d-e88870b646dd name: "EMAIL1" short-name: "WRITERS.EMAIL1" full-name: "PUBLIC.FOR_LINT.WRITERS.EMAIL1" attributes: CHAR_OCTET_LENGTH: 10 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: true privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 10 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(10)" - &3628f920-3257-4ac3-92a2-689f3ff323dc name: "EMAIL2" short-name: "WRITERS.EMAIL2" full-name: "PUBLIC.FOR_LINT.WRITERS.EMAIL2" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &69402c6f-0e11-44ff-8fca-7c27b2ac24b4 name: "FAX" short-name: "WRITERS.FAX" full-name: "PUBLIC.FOR_LINT.WRITERS.FAX" attributes: CHAR_OCTET_LENGTH: 10 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 10 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(10)" - &ca846041-1965-4459-8c78-698801c92e69 name: "FAX3" short-name: "WRITERS.FAX3" full-name: "PUBLIC.FOR_LINT.WRITERS.FAX3" 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: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 32 type: *f4f636c3-3f79-4cf1-b9bc-0182150a25ab width: "" - &c7b0edf2-583f-43c9-aaf5-ea80c39ff720 name: "HOMEEMAIL11" short-name: "WRITERS.HOMEEMAIL11" full-name: "PUBLIC.FOR_LINT.WRITERS.HOMEEMAIL11" attributes: CHAR_OCTET_LENGTH: 10 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 10 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(10)" - &84d0e647-8eed-4ace-bde8-1c8bfb34b909 name: "HOMEEMAIL12" short-name: "WRITERS.HOMEEMAIL12" full-name: "PUBLIC.FOR_LINT.WRITERS.HOMEEMAIL12" attributes: CHAR_OCTET_LENGTH: 10 IS_GENERATED: "NEVER" IS_NULLABLE: "YES" REMARKS: "" SQL_DATA_TYPE: 12 auto-incremented: false column-data-type: *172781b6-2281-47c9-a009-afa041bc6163 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 10 type: *172781b6-2281-47c9-a009-afa041bc6163 width: "(10)" - &70658a1f-04a2-4e0a-9bc9-96ff19bd996d name: "PUBLICATION_ID" short-name: "WRITERS.PUBLICATION_ID" full-name: "PUBLIC.FOR_LINT.WRITERS.PUBLICATION_ID" 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: *250cb17c-c37c-4a89-a9e2-b6d54de597b0 column-data-type-known: true decimal-digits: 0 default-value: null 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-unique-index: false privileges: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d size: 64 type: *250cb17c-c37c-4a89-a9e2-b6d54de597b0 width: "" catalog: &1dff19a6-6b64-4847-a7a8-7b300c7f1a96 name: "catalog" full-name: "catalog" crawl-info: &2b3894bf-42a2-4c81-96b6-e99cec3ba455 crawl-timestamp: "2024-03-16 21:59:47" crawl-timestamp-instant: 1710626387.315000000 database-version: &4d19b88b-95f6-4c63-8e2e-d8a091b4b883 product-name: "HSQL Database Engine" product-version: "2.7.2" jdbc-driver-version: &37b8f24a-e25e-481b-8da9-54377afb1f2e product-name: "HSQL Database Engine Driver" product-version: "2.7.2" jvm-version: &51ea4c26-bdd7-4474-9380-a76390bbdacb product-name: "Temurin OpenJDK 64-Bit\ \ Server VM" product-version: "1.8.0_402-b06" operating-system-version: &b2f075c0-fe6e-4ff9-9332-950ee2621f6b product-name: "Linux" product-version: "6.5.0-1016-azure" run-id: "1676749b-474e-4969-8f7d-f5b7d852214a" schema-crawler-version: &e8d182ee-79cc-4d52-8619-65964cbc6134 product-name: "SchemaCrawler" product-version: "16.21.2" database-info: *4d19b88b-95f6-4c63-8e2e-d8a091b4b883 jdbc-driver-info: *37b8f24a-e25e-481b-8da9-54377afb1f2e schemas: - *68885dda-4857-405a-9011-535efc7e73b9 - *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &1d0cb011-75bc-4b07-9f91-d59b1a741e1f name: "INFORMATION_SCHEMA" full-name: "PUBLIC.INFORMATION_SCHEMA" attributes: {} catalog-name: "PUBLIC" remarks: "" - &c15acc0f-6847-415d-bb8a-35964d9e008c name: "PUBLIC" full-name: "PUBLIC.PUBLIC" attributes: {} catalog-name: "PUBLIC" remarks: "" - *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &fe1f57f1-ba92-44ba-a47a-e1ff6dd32243 name: "SYSTEM_LOBS" full-name: "PUBLIC.SYSTEM_LOBS" attributes: {} catalog-name: "PUBLIC" remarks: "" system-column-data-types: - *250cb17c-c37c-4a89-a9e2-b6d54de597b0 - &41472148-997f-4de1-a5f3-e027ea475eb2 name: "BINARY" full-name: "BINARY" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: "LENGTH" database-specific-type-name: "BINARY" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &88657916-f9b6-4183-8334-a21e8e8da68c name: "BINARY" default-mapped-class: "[B" java-sql-type-group: "binary" vendor: "java.sql" vendor-type-number: -2 literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable" type: "system" type-mapped-class: "[B" unsigned: false - &336a8e9c-025f-47e9-8afd-89d892cf5c48 name: "BIT" full-name: "BIT" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: "LENGTH" database-specific-type-name: "BIT" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &d98c41b1-56ec-4952-816d-50af89a61949 name: "BIT" default-mapped-class: "java.lang.Boolean" java-sql-type-group: "bit" vendor: "java.sql" vendor-type-number: -7 literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 1024 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.lang.Boolean" unsigned: false - &367a5152-9d3c-4e75-8819-006da403fe45 name: "BLOB" full-name: "BLOB" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: "LENGTH" database-specific-type-name: "BLOB" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &a73eebcd-e69b-4d3c-baf3-e00b68c1b5e6 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: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "not searchable" type: "system" type-mapped-class: "java.sql.Blob" unsigned: false - &48f57ac3-0152-4e54-afa4-c2beaab5ed9d name: "BOOLEAN" full-name: "BOOLEAN" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "BOOLEAN" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &079fcdaf-c8db-4abf-9d4c-8077f0702d92 name: "BOOLEAN" default-mapped-class: "java.lang.Boolean" java-sql-type-group: "bit" vendor: "java.sql" vendor-type-number: 16 literal-prefix: null literal-suffix: null local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.lang.Boolean" unsigned: false - *b6c9ac06-7364-456a-a525-9b69fb635f65 - *507bba9d-8aeb-40e7-83ad-c88e1a97545a - *a3a338ae-80af-46a5-8124-f4304b7d88bd - &54b022db-2685-4416-83a4-a82af2625fbb name: "DECIMAL" full-name: "DECIMAL" attributes: {} auto-incrementable: true base-type: null case-sensitive: false create-parameters: "PRECISION,SCALE" database-specific-type-name: "DECIMAL" enum-values: [] enumerated: false fixed-precision-scale: true java-sql-type: &91f34f6a-ef8a-433e-b0da-6d8809fb3018 name: "DECIMAL" default-mapped-class: "java.math.BigDecimal" java-sql-type-group: "real" vendor: "java.sql" vendor-type-number: 3 literal-prefix: null literal-suffix: null local-type-name: null maximum-scale: 32767 minimum-scale: 0 nullable: true num-precision-radix: 10 precision: 2147483647 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.math.BigDecimal" unsigned: false - *5cb2c7bd-d28a-41d1-ba5e-06360ee78259 - &fd68ce0e-dc92-4685-a145-cd85e30b8bd0 name: "FLOAT" full-name: "FLOAT" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "FLOAT" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: *8e6ec223-88d0-4ccb-9426-4357c39079e2 literal-prefix: null literal-suffix: null local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 64 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.lang.Double" unsigned: false - *f4f636c3-3f79-4cf1-b9bc-0182150a25ab - &abc60748-3a8d-4759-9018-d943f8997aaf name: "NUMERIC" full-name: "NUMERIC" attributes: {} auto-incrementable: true base-type: null case-sensitive: false create-parameters: "PRECISION,SCALE" database-specific-type-name: "NUMERIC" enum-values: [] enumerated: false fixed-precision-scale: true java-sql-type: &a995fa68-1c00-4e85-8a69-1e3142c304d1 name: "NUMERIC" default-mapped-class: "java.math.BigDecimal" java-sql-type-group: "real" vendor: "java.sql" vendor-type-number: 2 literal-prefix: null literal-suffix: null local-type-name: null maximum-scale: 32767 minimum-scale: 0 nullable: true num-precision-radix: 10 precision: 2147483647 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.math.BigDecimal" unsigned: false - &019325bb-45d4-4868-a8b2-6300b8f4ad44 name: "NVARCHAR" full-name: "NVARCHAR" attributes: {} auto-incrementable: false base-type: null case-sensitive: true create-parameters: "LENGTH" database-specific-type-name: "NVARCHAR" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: *20b7d449-23a2-468f-9e51-608139933124 literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable" type: "system" type-mapped-class: "java.lang.String" unsigned: false - &810af13f-c14c-411a-867f-d4cf6c3a7e8d name: "OTHER" full-name: "OTHER" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "OTHER" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &c69fe1ec-184c-4ada-8e9f-658e9529928f name: "OTHER" default-mapped-class: "java.lang.Object" java-sql-type-group: "object" vendor: "java.sql" vendor-type-number: 1111 literal-prefix: null literal-suffix: null local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.lang.Object" unsigned: false - &c292b105-1c3f-4f8d-97ab-b9e984990a62 name: "REAL" full-name: "REAL" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "REAL" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: *8e6ec223-88d0-4ccb-9426-4357c39079e2 literal-prefix: null literal-suffix: null local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 64 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.lang.Float" unsigned: false - *688a578b-cbe6-4846-a3b3-945797b4f2a3 - &7f56a703-8f37-4689-bd4d-7f62032d9091 name: "TIME" full-name: "TIME" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "TIME" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &7a8e4a8f-a2b9-405e-8646-dfd86734de95 name: "TIME" default-mapped-class: "java.sql.Time" java-sql-type-group: "temporal" vendor: "java.sql" vendor-type-number: 92 literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.sql.Time" unsigned: false - &6103f383-a7ed-414a-8d96-27241fd4c995 name: "TIMESTAMP" full-name: "TIMESTAMP" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "TIMESTAMP" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &76abe647-8eb5-442a-b08c-82c825852faa name: "TIMESTAMP" default-mapped-class: "java.sql.Timestamp" java-sql-type-group: "temporal" vendor: "java.sql" vendor-type-number: 93 literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.sql.Timestamp" unsigned: false - &5abc39b6-84ec-44c0-91f8-1071d63d1d43 name: "TIMESTAMP WITH TIME ZONE" full-name: "TIMESTAMP WITH TIME ZONE" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "TIMESTAMP WITH TIME ZONE" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &5bacc27d-2dd0-4907-a347-623224c1b9d7 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: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.time.OffsetDateTime" unsigned: false - &8df0f983-0c38-4ad7-b9a5-413f75be4442 name: "TIME WITH TIME ZONE" full-name: "TIME WITH TIME ZONE" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "TIME WITH TIME ZONE" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &20ecc7c3-9613-4a65-bc35-8bf63afcb2aa 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: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 0 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.time.OffsetTime" unsigned: false - &91ea38d5-fff2-4b40-aaff-4f2eeaa42a8b name: "TINYINT" full-name: "TINYINT" attributes: {} auto-incrementable: true base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "TINYINT" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &e7f3baac-93b1-458b-a57f-2545e7ce623c name: "TINYINT" default-mapped-class: "java.lang.Integer" java-sql-type-group: "integer" vendor: "java.sql" vendor-type-number: -6 literal-prefix: null literal-suffix: null local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 2 precision: 8 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable except with where .. like" type: "system" type-mapped-class: "java.lang.Integer" unsigned: false - &da0c9d59-0fff-4358-9197-285956c5decc name: "UUID" full-name: "UUID" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: null database-specific-type-name: "UUID" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: *88657916-f9b6-4183-8334-a21e8e8da68c literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 16 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable" type: "system" type-mapped-class: "[B" unsigned: false - &dea9dbdc-d312-487a-9127-d64783608f00 name: "VARBINARY" full-name: "VARBINARY" attributes: {} auto-incrementable: false base-type: null case-sensitive: false create-parameters: "LENGTH" database-specific-type-name: "VARBINARY" enum-values: [] enumerated: false fixed-precision-scale: false java-sql-type: &de5f6d54-7037-456d-9b9a-d85a820d3db1 name: "VARBINARY" default-mapped-class: "[B" java-sql-type-group: "binary" vendor: "java.sql" vendor-type-number: -3 literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 remarks: "" schema: *89f00b17-f1d7-4f6f-a736-ddc124ae8c57 searchable: "searchable" type: "system" type-mapped-class: "[B" unsigned: false - *172781b6-2281-47c9-a009-afa041bc6163 column-data-types: - *250cb17c-c37c-4a89-a9e2-b6d54de597b0 - *41472148-997f-4de1-a5f3-e027ea475eb2 - *336a8e9c-025f-47e9-8afd-89d892cf5c48 - *367a5152-9d3c-4e75-8819-006da403fe45 - *48f57ac3-0152-4e54-afa4-c2beaab5ed9d - *b6c9ac06-7364-456a-a525-9b69fb635f65 - *507bba9d-8aeb-40e7-83ad-c88e1a97545a - *a3a338ae-80af-46a5-8124-f4304b7d88bd - *54b022db-2685-4416-83a4-a82af2625fbb - *5cb2c7bd-d28a-41d1-ba5e-06360ee78259 - *fd68ce0e-dc92-4685-a145-cd85e30b8bd0 - *f4f636c3-3f79-4cf1-b9bc-0182150a25ab - *abc60748-3a8d-4759-9018-d943f8997aaf - *019325bb-45d4-4868-a8b2-6300b8f4ad44 - *810af13f-c14c-411a-867f-d4cf6c3a7e8d - *c292b105-1c3f-4f8d-97ab-b9e984990a62 - *688a578b-cbe6-4846-a3b3-945797b4f2a3 - *7f56a703-8f37-4689-bd4d-7f62032d9091 - *6103f383-a7ed-414a-8d96-27241fd4c995 - *5abc39b6-84ec-44c0-91f8-1071d63d1d43 - *8df0f983-0c38-4ad7-b9a5-413f75be4442 - *91ea38d5-fff2-4b40-aaff-4f2eeaa42a8b - *da0c9d59-0fff-4358-9197-285956c5decc - *dea9dbdc-d312-487a-9127-d64783608f00 - *172781b6-2281-47c9-a009-afa041bc6163 - *0e27eff0-d231-406f-b49e-c1a16f7930d1 - *b99a1ba2-1865-4629-9d72-512e2894e88d - *01ac2033-6b93-40d0-802b-7d1c5b3d487f - *6cc37d05-f749-4987-a164-862f2e2e3db6 - *4fd16078-65b2-4286-b309-4d440c918cec attributes: {} database-users: - &eef6d430-6e9e-4389-990b-28c0fc09fafe name: "OTHERUSER" full-name: "OTHERUSER" attributes: ADMIN: false AUTHENTICATION: "ANY" PASSWORD_DIGEST: "3680cf0219b09398c34f2137f27a0c02" remarks: "" - &d5b7102a-bcf3-4701-ba44-b06c81c7d230 name: "SA" full-name: "SA" attributes: ADMIN: true AUTHENTICATION: "LOCAL" PASSWORD_DIGEST: "d41d8cd98f00b204e9800998ecf8427e" remarks: "" remarks: "" routines: [] sequences: [] synonyms: [] tables: - &9519f0c8-09b2-4f68-adc8-5d264f661c76 name: "AUTHORS" full-name: "PUBLIC.BOOKS.AUTHORS" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "Contact details for book authors" columns: - *8620660f-c14c-4225-8082-3f564059cbbe - *7f91c7ef-51d2-4224-ac5a-8adacc4cfb89 - *c90f980e-70df-4358-8923-fe18f69a0313 - *66395e0e-2924-41a5-b8bf-8b645cdbec5b - *bb0b24c4-2a84-459f-b30b-b0331ce3e37a - *0b722643-63c3-4fe5-8248-bcb68a79f3d2 - *488b2bc3-a419-4a43-8c62-f3a012154145 - *2d4ab0c2-228f-4130-9739-5194c4efaf45 - *1b78561b-b155-48ca-9b02-f6b5bf9e19ce definition: "" dependent-tables: - &060001db-3f82-4006-9478-0ac9d73232ce name: "BOOKAUTHORS" full-name: "PUBLIC.BOOKS.BOOKAUTHORS" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "Relationship between books and their authors, \nalong with the latest\ \ updated information" columns: - *0ea2674c-92ec-40c5-b534-969521cddeac - *7d5fc016-e8c5-4576-a6e0-77fa7e1871fa - *87895c73-5d86-4f98-ba74-4036df8070c8 definition: "" dependent-tables: [] foreign-keys: - &4bb812e1-beb2-4659-83b5-7b5981b96ebd 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: - &2b0f2018-15d6-44e4-8d30-67bdf76add2a foreign-key-column: *7d5fc016-e8c5-4576-a6e0-77fa7e1871fa key-sequence: 1 primary-key-column: *8620660f-c14c-4225-8082-3f564059cbbe constrained-columns: - *7d5fc016-e8c5-4576-a6e0-77fa7e1871fa deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *060001db-3f82-4006-9478-0ac9d73232ce foreign-key-table: *060001db-3f82-4006-9478-0ac9d73232ce initially-deferred: false parent-partial: false primary-key-table: *9519f0c8-09b2-4f68-adc8-5d264f661c76 referenced-table: *9519f0c8-09b2-4f68-adc8-5d264f661c76 referencing-table: *060001db-3f82-4006-9478-0ac9d73232ce remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 specific-name: "Z_FK_AUTHOR" type: "foreign_key" update-rule: "no action" - &b342ec5a-e59a-4104-b620-e2fec2594e6a name: "SYS_FK_10120" short-name: "BOOKAUTHORS.SYS_FK_10120" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.SYS_FK_10120" attributes: PK_NAME: "PK_BOOKS" TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" column-references: - &0796eedb-9388-4491-ba01-7b7a88333a97 foreign-key-column: *0ea2674c-92ec-40c5-b534-969521cddeac key-sequence: 1 primary-key-column: *3d0e98a7-a907-42f8-adc4-e422d13cf6f8 constrained-columns: - *0ea2674c-92ec-40c5-b534-969521cddeac deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *060001db-3f82-4006-9478-0ac9d73232ce foreign-key-table: *060001db-3f82-4006-9478-0ac9d73232ce initially-deferred: false parent-partial: false primary-key-table: &f8317ef3-634b-48f2-9936-c6306cd089af name: "BOOKS" full-name: "PUBLIC.BOOKS.BOOKS" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "Details for published books" columns: - *3d0e98a7-a907-42f8-adc4-e422d13cf6f8 - *a1b5484e-993d-4d6c-821c-aa4385cc435d - *21074e10-2c22-45d3-b4bc-78390d4cc4ef - *74929c26-1c03-490a-88c3-c8f58f3c616f - *c9d62130-0d1a-4014-9d85-65e7f31d72d4 - *2c6cca8f-bc59-4ca0-b463-0d94e5e0edd8 - *a2e39798-2c72-4fbd-8f34-755dd4c16d6e definition: "" dependent-tables: - *060001db-3f82-4006-9478-0ac9d73232ce - *f8317ef3-634b-48f2-9936-c6306cd089af - &85c98d67-e8f3-45e6-be7c-ef38808fd0a7 name: "SALES" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *f117ae54-fa00-4828-a568-d0a16dad988b - *229789e7-b83c-469f-8154-a3428b41f6b2 - *c4c21e9b-9062-469b-a98d-6bc6ac0b1831 - *0ce7f80b-1fbd-49bc-a25c-0a72744dd3a1 - *954904c5-bd9e-4288-b6c0-85b616c25fc4 - *1f26262a-374f-4ad8-934d-a4af5cbe9403 - *f932940f-c716-4786-9a83-3853f16fbad5 definition: "" dependent-tables: [] foreign-keys: - &8db67e16-7e91-4da7-b03c-79a6cbd45a5c 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: - &886f94fb-4558-483c-a953-11ec59620911 foreign-key-column: *c4c21e9b-9062-469b-a98d-6bc6ac0b1831 key-sequence: 1 primary-key-column: *3d0e98a7-a907-42f8-adc4-e422d13cf6f8 constrained-columns: - *c4c21e9b-9062-469b-a98d-6bc6ac0b1831 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 foreign-key-table: *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 initially-deferred: false parent-partial: false primary-key-table: *f8317ef3-634b-48f2-9936-c6306cd089af referenced-table: *f8317ef3-634b-48f2-9936-c6306cd089af referencing-table: *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 specific-name: "FK_SALES_BOOK" type: "foreign_key" update-rule: "no action" - &0bdb1453-1f9e-468c-ba82-2e9ac81bf3a8 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: - &d1bb8b13-0f9a-4bde-9d62-e0ad01781d9c foreign-key-column: *f932940f-c716-4786-9a83-3853f16fbad5 key-sequence: 1 primary-key-column: *5b6bf706-af3f-4f75-a446-4a0095f4ac36 constrained-columns: - *f932940f-c716-4786-9a83-3853f16fbad5 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 foreign-key-table: *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 initially-deferred: false parent-partial: false primary-key-table: &37550520-eadd-4a37-ac20-dc49cba0c6c0 name: "SALESDATA" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *5b6bf706-af3f-4f75-a446-4a0095f4ac36 - *3f437f04-56ef-4cb0-80e6-93398d75233e definition: "" dependent-tables: - *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 foreign-keys: - *0bdb1453-1f9e-468c-ba82-2e9ac81bf3a8 hidden-columns: [] indexes: - &ec04a29e-f5e1-4a08-907f-8dd8c5daebb1 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: - *5b6bf706-af3f-4f75-a446-4a0095f4ac36 definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 type: "other" unique: true primary-key: null privileges: - &542cd8bc-28aa-4f0e-8152-af7292f72bc6 name: "DELETE" short-name: "SALESDATA.\"DELETE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"DELETE\"" attributes: {} grants: - &849ba4a4-1172-45fc-8f0d-8b039232b721 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &1b0a5043-ca28-4025-acd2-c66e0bfb807c name: "INSERT" short-name: "SALESDATA.\"INSERT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"INSERT\"" attributes: {} grants: - &0637e3fe-c086-4341-9c53-ec51c23ebdae grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &f239f039-2a1a-4c09-a0c8-ac31cb49209d name: "REFERENCES" short-name: "SALESDATA.\"REFERENCES\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"REFERENCES\"" attributes: {} grants: - &9a1adbc3-35cf-4d1f-aa16-4e8072df34d4 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &0f60afa0-2fd9-4272-aed1-cc743226cb47 name: "SELECT" short-name: "SALESDATA.\"SELECT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"SELECT\"" attributes: {} grants: - &c7d5e951-9dbd-4b7a-8b4b-8545cb7f3616 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &897781d7-24ea-448b-9bf1-45a73fb34f1d name: "TRIGGER" short-name: "SALESDATA.\"TRIGGER\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"TRIGGER\"" attributes: {} grants: - &aa67a9d7-01e0-4f23-8b21-35dd494772eb grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &3a15a38c-35e7-4968-a769-8e9e55317c48 name: "UPDATE" short-name: "SALESDATA.\"UPDATE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"UPDATE\"" attributes: {} grants: - &e875a4db-c859-43bd-abc3-0fe398d0f462 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 referenced-tables: [] referencing-tables: - *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 table-constraints: - *ec04a29e-f5e1-4a08-907f-8dd8c5daebb1 table-type: &d330142d-210a-4997-a57f-a25b3ad46908 table-type: "TABLE" view: false triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] referenced-table: *37550520-eadd-4a37-ac20-dc49cba0c6c0 referencing-table: *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 specific-name: "FK_SALES_SALESDATA" type: "foreign_key" update-rule: "no action" - &d4a72b1d-63e1-4222-b447-c5ec8e809a84 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: - &9d4ee5aa-d19c-4ce1-bb49-a2974e242d16 foreign-key-column: *f117ae54-fa00-4828-a568-d0a16dad988b key-sequence: 1 primary-key-column: *6befdb42-8ea2-4ced-9301-ea4b3f656cd3 - &26f44bc3-affe-43f3-948e-b3b738c6bfda foreign-key-column: *229789e7-b83c-469f-8154-a3428b41f6b2 key-sequence: 2 primary-key-column: *be8e2d7c-c3c7-42cb-b34a-6d0a21ded9eb constrained-columns: - *f117ae54-fa00-4828-a568-d0a16dad988b - *229789e7-b83c-469f-8154-a3428b41f6b2 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 foreign-key-table: *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 initially-deferred: false parent-partial: false primary-key-table: &dc1ca164-b17c-4539-8af6-1743a8391a3e name: "REGIONS" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *e0d3695d-2adb-430c-baca-bf87e641b722 - *009affa4-8456-4ab6-a7fc-565340810e7c - *6befdb42-8ea2-4ced-9301-ea4b3f656cd3 - *be8e2d7c-c3c7-42cb-b34a-6d0a21ded9eb definition: "" dependent-tables: - *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 foreign-keys: - *d4a72b1d-63e1-4222-b447-c5ec8e809a84 hidden-columns: [] indexes: - &148b26b5-c646-41ad-be99-276561d97ed7 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: - *6befdb42-8ea2-4ced-9301-ea4b3f656cd3 - *be8e2d7c-c3c7-42cb-b34a-6d0a21ded9eb definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 type: "other" unique: true primary-key: *148b26b5-c646-41ad-be99-276561d97ed7 privileges: - &fc8bb652-12b2-4d37-99ce-38d95246860d name: "DELETE" short-name: "REGIONS.\"DELETE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"DELETE\"" attributes: {} grants: - &b2bed453-e196-459d-9d9e-bad3f6fdd562 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &ecf65f21-9c87-49ca-a915-a6ba2064d82c name: "INSERT" short-name: "REGIONS.\"INSERT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"INSERT\"" attributes: {} grants: - &c8645b9e-55dd-47b5-b533-5d844074369d grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &a28a87ed-1ae6-40ce-a9ad-a5070aebf02a name: "REFERENCES" short-name: "REGIONS.\"REFERENCES\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"REFERENCES\"" attributes: {} grants: - &9d983ca0-e5f0-4341-9fdb-bcaf1660116b grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &8d09ece7-6d8c-477e-a4d2-8cd45eaa56e1 name: "SELECT" short-name: "REGIONS.\"SELECT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"SELECT\"" attributes: {} grants: - &30b3e730-cdc3-47c0-bcd1-6907480de8ae grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &cddac9a7-43e0-4b70-a076-9abfebd1ad50 name: "TRIGGER" short-name: "REGIONS.\"TRIGGER\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"TRIGGER\"" attributes: {} grants: - &7f87cbd5-7fa4-4067-8a94-9fff3f8eb5b2 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &e0ea6122-d8a9-4b63-a91c-b8926754b6f9 name: "UPDATE" short-name: "REGIONS.\"UPDATE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"UPDATE\"" attributes: {} grants: - &65a07356-8889-411e-9317-7e9a9bb74c4c grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 referenced-tables: [] referencing-tables: - *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 table-constraints: - *148b26b5-c646-41ad-be99-276561d97ed7 - &5e80c4b7-efa5-474d-8054-1d986f927bfc name: "SYS_CT_10204" short-name: "REGIONS.SYS_CT_10204" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.SYS_CT_10204" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "PUBLISHER SALES" constrained-columns: - *e0d3695d-2adb-430c-baca-bf87e641b722 deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.CITY IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 type: "check" - &c90ae1cc-02eb-497e-9d46-b59714574342 name: "SYS_CT_10205" short-name: "REGIONS.SYS_CT_10205" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.SYS_CT_10205" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "PUBLISHER SALES" constrained-columns: - *009affa4-8456-4ab6-a7fc-565340810e7c deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.STATE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 type: "check" - &834b1bbb-afce-4222-9f7e-770cc288ee31 name: "SYS_CT_10206" short-name: "REGIONS.SYS_CT_10206" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.SYS_CT_10206" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "PUBLISHER SALES" constrained-columns: - *6befdb42-8ea2-4ced-9301-ea4b3f656cd3 deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.POSTALCODE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 type: "check" - &3c9a3c7a-5598-4304-8296-19f41f14a0ef 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: - *be8e2d7c-c3c7-42cb-b34a-6d0a21ded9eb deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.COUNTRY IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] referenced-table: *dc1ca164-b17c-4539-8af6-1743a8391a3e referencing-table: *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 specific-name: "FK_SALES_REGIONS" type: "foreign_key" update-rule: "no action" hidden-columns: [] indexes: - *8db67e16-7e91-4da7-b03c-79a6cbd45a5c - *0bdb1453-1f9e-468c-ba82-2e9ac81bf3a8 - *d4a72b1d-63e1-4222-b447-c5ec8e809a84 primary-key: null privileges: - &c00e0299-edc2-4c34-b3b0-064d526cb913 name: "DELETE" short-name: "SALES.\"DELETE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"DELETE\"" attributes: {} grants: - &ac1b007f-db04-4bf3-bac9-a2ded9c77c68 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &1b4aca9b-222a-4415-88f1-d4d599ae93e6 name: "INSERT" short-name: "SALES.\"INSERT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"INSERT\"" attributes: {} grants: - &2b4f10b9-00e0-4153-8619-e556eff7a1ba grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &654c92ab-cde3-4c13-963f-41518c2487b5 name: "REFERENCES" short-name: "SALES.\"REFERENCES\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"REFERENCES\"" attributes: {} grants: - &47813c0e-9b4d-432b-9f18-ed16e14cbe90 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &c6f1bdca-a0f8-4cca-bab6-98e28ca696b1 name: "SELECT" short-name: "SALES.\"SELECT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"SELECT\"" attributes: {} grants: - &889ff4ea-c0d4-4805-8ea1-a82aa7ec3457 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &d9bfdf80-5102-4897-abd0-5477426c30d7 name: "TRIGGER" short-name: "SALES.\"TRIGGER\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"TRIGGER\"" attributes: {} grants: - &d0300a72-8eb1-45fd-82cc-062634dbea32 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 - &f72e4377-f7f9-44f9-b074-01eba1893c5e name: "UPDATE" short-name: "SALES.\"UPDATE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"UPDATE\"" attributes: {} grants: - &8bfac0c6-fb30-4503-8141-75d639eef054 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 referenced-tables: - *f8317ef3-634b-48f2-9936-c6306cd089af - *dc1ca164-b17c-4539-8af6-1743a8391a3e - *37550520-eadd-4a37-ac20-dc49cba0c6c0 referencing-tables: [] remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 table-constraints: - *8db67e16-7e91-4da7-b03c-79a6cbd45a5c - *0bdb1453-1f9e-468c-ba82-2e9ac81bf3a8 - *d4a72b1d-63e1-4222-b447-c5ec8e809a84 - &cb8b446e-5608-4d6a-80e9-4784ccacd804 name: "SYS_CT_10213" short-name: "SALES.SYS_CT_10213" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.SYS_CT_10213" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "PUBLISHER SALES" constrained-columns: - *f117ae54-fa00-4828-a568-d0a16dad988b deferrable: false definition: "\"PUBLISHER SALES\".SALES.POSTALCODE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 type: "check" - &bd6a3d6b-101c-43e3-b916-90b83741cee3 name: "SYS_CT_10214" short-name: "SALES.SYS_CT_10214" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.SYS_CT_10214" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "PUBLISHER SALES" constrained-columns: - *229789e7-b83c-469f-8154-a3428b41f6b2 deferrable: false definition: "\"PUBLISHER SALES\".SALES.COUNTRY IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4308eb4a-58d4-44d5-9780-8ee25ea4dec2 type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] foreign-keys: - &5c99f6eb-1712-4119-a5ae-ca49d72cf8b7 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: - &93521b95-09b9-4d79-9fcc-188211503f3b foreign-key-column: *a2e39798-2c72-4fbd-8f34-755dd4c16d6e key-sequence: 1 primary-key-column: *3d0e98a7-a907-42f8-adc4-e422d13cf6f8 constrained-columns: - *a2e39798-2c72-4fbd-8f34-755dd4c16d6e deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *f8317ef3-634b-48f2-9936-c6306cd089af foreign-key-table: *f8317ef3-634b-48f2-9936-c6306cd089af initially-deferred: false parent-partial: false primary-key-table: *f8317ef3-634b-48f2-9936-c6306cd089af referenced-table: *f8317ef3-634b-48f2-9936-c6306cd089af referencing-table: *f8317ef3-634b-48f2-9936-c6306cd089af remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 specific-name: "FK_PREVIOUSEDITION" type: "foreign_key" update-rule: "no action" - *8db67e16-7e91-4da7-b03c-79a6cbd45a5c - *b342ec5a-e59a-4104-b620-e2fec2594e6a hidden-columns: [] indexes: - &a1f46970-7ae8-407b-b959-5551dc792743 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: - *3d0e98a7-a907-42f8-adc4-e422d13cf6f8 definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: true - &80e89b4b-1bc4-4730-b3ae-8135afbfc69a 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: - *a2e39798-2c72-4fbd-8f34-755dd4c16d6e definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: true - *5c99f6eb-1712-4119-a5ae-ca49d72cf8b7 primary-key: *a1f46970-7ae8-407b-b959-5551dc792743 privileges: - &3445c0ef-0b22-4d1b-b3d1-b82c55c5c3c1 name: "DELETE" short-name: "BOOKS.\"DELETE\"" full-name: "PUBLIC.BOOKS.BOOKS.\"DELETE\"" attributes: {} grants: - &44de5395-e1ea-41b8-a94f-eed2acac6004 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &8dbba984-0216-4271-a6f6-fd4128bc7b34 name: "INSERT" short-name: "BOOKS.\"INSERT\"" full-name: "PUBLIC.BOOKS.BOOKS.\"INSERT\"" attributes: {} grants: - &5d8f9d84-e842-40ae-94c0-bb1d9a28d295 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &1411e83b-47c7-476c-b55a-8f52a49c82fd name: "REFERENCES" short-name: "BOOKS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.BOOKS.\"REFERENCES\"" attributes: {} grants: - &18de3c6d-b640-4f9c-b5e6-7f81fb1d2bde grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &f56afb91-bad5-4e19-acc5-e9814cb023cb name: "SELECT" short-name: "BOOKS.\"SELECT\"" full-name: "PUBLIC.BOOKS.BOOKS.\"SELECT\"" attributes: {} grants: - &0d597527-ae22-45e6-8344-4fbf956ca1e6 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &2d1b1e30-2ed8-4465-bc37-ce9741d01579 name: "TRIGGER" short-name: "BOOKS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.BOOKS.\"TRIGGER\"" attributes: {} grants: - &c8c173a9-4590-44df-a878-04a7e31b1e04 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &6e432357-9f0f-4dab-8b16-01a1469bde24 name: "UPDATE" short-name: "BOOKS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.BOOKS.\"UPDATE\"" attributes: {} grants: - &87ca3de1-a8bd-4e27-8d8e-04ae75ce54db grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 referenced-tables: - *f8317ef3-634b-48f2-9936-c6306cd089af referencing-tables: - *060001db-3f82-4006-9478-0ac9d73232ce - *f8317ef3-634b-48f2-9936-c6306cd089af - *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 remarks: "Details for published books" schema: *68885dda-4857-405a-9011-535efc7e73b9 table-constraints: - *a1f46970-7ae8-407b-b959-5551dc792743 - *5c99f6eb-1712-4119-a5ae-ca49d72cf8b7 - *80e89b4b-1bc4-4730-b3ae-8135afbfc69a - &225c4490-5e11-4900-b61a-04ef0bba604d name: "SYS_CT_10111" short-name: "BOOKS.SYS_CT_10111" full-name: "PUBLIC.BOOKS.BOOKS.SYS_CT_10111" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: - *3d0e98a7-a907-42f8-adc4-e422d13cf6f8 deferrable: false definition: "BOOKS.BOOKS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" - &7c0f4bac-5e19-416c-aa3f-fc81fae43e2e 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: - *a1b5484e-993d-4d6c-821c-aa4385cc435d deferrable: false definition: "BOOKS.BOOKS.TITLE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" - &1133e981-708f-4d3b-a5d6-2708f849a058 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: - *74929c26-1c03-490a-88c3-c8f58f3c616f deferrable: false definition: "BOOKS.BOOKS.PUBLISHERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] referenced-table: *f8317ef3-634b-48f2-9936-c6306cd089af referencing-table: *060001db-3f82-4006-9478-0ac9d73232ce remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 specific-name: "SYS_FK_10120" type: "foreign_key" update-rule: "no action" hidden-columns: [] indexes: - *4bb812e1-beb2-4659-83b5-7b5981b96ebd - *b342ec5a-e59a-4104-b620-e2fec2594e6a - &8a65b20c-de5e-42d4-a129-632b1fdf0818 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: - *0ea2674c-92ec-40c5-b534-969521cddeac - *7d5fc016-e8c5-4576-a6e0-77fa7e1871fa definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: true primary-key: null privileges: - &0cd51bd9-6d46-45af-9fdd-90d218d13cd8 name: "DELETE" short-name: "BOOKAUTHORS.\"DELETE\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"DELETE\"" attributes: {} grants: - &ba3af5ef-301f-4481-a3c6-d2b04dc7063a grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &7ae86fdf-aa01-4557-98ac-45f88c4141d0 name: "INSERT" short-name: "BOOKAUTHORS.\"INSERT\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"INSERT\"" attributes: {} grants: - &c3a8fa74-9767-4e73-b253-1fb4a79b3380 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &485a369f-b466-42ab-9565-d7fd2db1ab15 name: "REFERENCES" short-name: "BOOKAUTHORS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"REFERENCES\"" attributes: {} grants: - &e6c224d8-2ca9-4cc9-96e5-174259aabe2f grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &327dccbc-562b-4ab1-aa0c-d99d08e3960a name: "SELECT" short-name: "BOOKAUTHORS.\"SELECT\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"SELECT\"" attributes: {} grants: - &3d712cc0-8650-4ed6-8747-1735508095d3 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &3ecc3516-b2b0-45d0-9756-f41a1bb57f9f name: "TRIGGER" short-name: "BOOKAUTHORS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"TRIGGER\"" attributes: {} grants: - &60563d89-79f9-42be-a654-90cd032ef777 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &dd84a939-c1d9-44ed-a475-9765f0be03cf name: "UPDATE" short-name: "BOOKAUTHORS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"UPDATE\"" attributes: {} grants: - &d957bd06-a77f-4daf-ad73-c21ef2ce3ea0 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 referenced-tables: - *9519f0c8-09b2-4f68-adc8-5d264f661c76 - *f8317ef3-634b-48f2-9936-c6306cd089af referencing-tables: [] remarks: "Relationship between books and their authors, \nalong with the latest\ \ updated information" schema: *68885dda-4857-405a-9011-535efc7e73b9 table-constraints: - *4bb812e1-beb2-4659-83b5-7b5981b96ebd - *b342ec5a-e59a-4104-b620-e2fec2594e6a - &72adfde4-10bc-46b3-a4a7-05d0e905a73d name: "SYS_CT_10118" short-name: "BOOKAUTHORS.SYS_CT_10118" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.SYS_CT_10118" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: - *0ea2674c-92ec-40c5-b534-969521cddeac deferrable: false definition: "BOOKS.BOOKAUTHORS.BOOKID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" - &34c40a45-b351-417f-90c8-a760dd165946 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: - *7d5fc016-e8c5-4576-a6e0-77fa7e1871fa deferrable: false definition: "BOOKS.BOOKAUTHORS.AUTHORID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] foreign-keys: - *4bb812e1-beb2-4659-83b5-7b5981b96ebd hidden-columns: [] indexes: - &ab092602-73e3-4d54-8ac4-530138c84f1d 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: - *8620660f-c14c-4225-8082-3f564059cbbe definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: true - &f9fbf35b-cce5-4c86-83fb-e99618a4d7f9 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: - *c90f980e-70df-4358-8923-fe18f69a0313 - *7f91c7ef-51d2-4224-ac5a-8adacc4cfb89 definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: false - &b5eca1e2-9bc7-42b4-924f-8d0d1768603a 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: - *0b722643-63c3-4fe5-8248-bcb68a79f3d2 - *488b2bc3-a419-4a43-8c62-f3a012154145 - *2d4ab0c2-228f-4130-9739-5194c4efaf45 - *1b78561b-b155-48ca-9b02-f6b5bf9e19ce definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: false primary-key: *ab092602-73e3-4d54-8ac4-530138c84f1d privileges: - &400d4beb-55a5-4789-af70-a6f30650e766 name: "DELETE" short-name: "AUTHORS.\"DELETE\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"DELETE\"" attributes: {} grants: - &cdef2aa8-9d7b-4492-883a-eba8eb4eff92 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &796a9d05-eb83-428b-a658-44bf049a4db9 name: "INSERT" short-name: "AUTHORS.\"INSERT\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"INSERT\"" attributes: {} grants: - &266b54b2-f9ac-4b3d-a614-b4b00896097c grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &64c3d289-f56a-4214-8797-4500c3ad20a5 name: "REFERENCES" short-name: "AUTHORS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"REFERENCES\"" attributes: {} grants: - &81660e95-09be-4f1f-b62d-c2388e73f2a3 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &47e1dd07-fb5b-4a21-9c52-fb68e2aac099 name: "SELECT" short-name: "AUTHORS.\"SELECT\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"SELECT\"" attributes: {} grants: - &2583b771-eb44-49b7-8995-35cfa250b234 grantable: false grantee: "OTHERUSER" grantor: "SA" - &07e8522d-739a-440e-b60a-0a149ebd3e93 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &ef4a6d77-6132-4adc-9148-e8d99765447e name: "TRIGGER" short-name: "AUTHORS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"TRIGGER\"" attributes: {} grants: - &58a1c804-4ab1-4453-902a-eadf909ce288 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &93f95676-c049-4b86-8add-3ac1fef07200 name: "UPDATE" short-name: "AUTHORS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"UPDATE\"" attributes: {} grants: - &792979dd-296b-43b1-9544-ce8856ca60f4 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 referenced-tables: [] referencing-tables: - *060001db-3f82-4006-9478-0ac9d73232ce remarks: "Contact details for book authors" schema: *68885dda-4857-405a-9011-535efc7e73b9 table-constraints: - *ab092602-73e3-4d54-8ac4-530138c84f1d - &7b56209f-daf6-4a00-b2b0-7a08932ebfc1 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: - *488b2bc3-a419-4a43-8c62-f3a012154145 deferrable: false definition: "BOOKS.AUTHORS.STATE=UPPER(BOOKS.AUTHORS.STATE)" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" - &c9ab4ca3-c436-4753-beb4-891b13e88e8f name: "SYS_CT_10104" short-name: "AUTHORS.SYS_CT_10104" full-name: "PUBLIC.BOOKS.AUTHORS.SYS_CT_10104" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: - *8620660f-c14c-4225-8082-3f564059cbbe deferrable: false definition: "BOOKS.AUTHORS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" - &32fb0566-bcbe-466a-8f36-06581730a26a 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: - *7f91c7ef-51d2-4224-ac5a-8adacc4cfb89 deferrable: false definition: "BOOKS.AUTHORS.FIRSTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" - &570d834f-c851-41b2-915d-7faccc4dc30d 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: - *c90f980e-70df-4358-8923-fe18f69a0313 deferrable: false definition: "BOOKS.AUTHORS.LASTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: - &10b92398-2237-4f95-8615-e0efeffc762e name: "TRG_AUTHORS" short-name: "AUTHORS.TRG_AUTHORS" full-name: "PUBLIC.BOOKS.AUTHORS.TRG_AUTHORS" action-condition: "" 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 remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] - *060001db-3f82-4006-9478-0ac9d73232ce - *f8317ef3-634b-48f2-9936-c6306cd089af - &9d96da77-d355-4871-b2b2-1f900dbb8eb7 name: "Celebrities" full-name: "PUBLIC.BOOKS.\"Celebrities\"" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *d32433de-3e05-4356-a5b0-fc4306f550f3 - *221f74fb-9309-440a-8ca9-8ce5f90abba3 definition: "" dependent-tables: - &a6c34776-935e-47de-b572-776cbdcc1a9d name: "Celebrity Updates" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\"" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *ddff5076-668b-475a-83dd-40d6554350ca - *e293a141-8ca1-496b-9e49-827546c46e8b definition: "" dependent-tables: [] foreign-keys: - &800bbb89-6b7e-43a6-83de-4da77536350c name: "SYS_FK_10130" short-name: "\"Celebrity Updates\".SYS_FK_10130" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".SYS_FK_10130" attributes: PK_NAME: "PK_Celebrities" TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" column-references: - &34ec40e9-6bb7-4ade-a3da-b2c621cd613f foreign-key-column: *ddff5076-668b-475a-83dd-40d6554350ca key-sequence: 1 primary-key-column: *d32433de-3e05-4356-a5b0-fc4306f550f3 constrained-columns: - *ddff5076-668b-475a-83dd-40d6554350ca deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *a6c34776-935e-47de-b572-776cbdcc1a9d foreign-key-table: *a6c34776-935e-47de-b572-776cbdcc1a9d initially-deferred: false parent-partial: false primary-key-table: *9d96da77-d355-4871-b2b2-1f900dbb8eb7 referenced-table: *9d96da77-d355-4871-b2b2-1f900dbb8eb7 referencing-table: *a6c34776-935e-47de-b572-776cbdcc1a9d remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 specific-name: "SYS_FK_10130" type: "foreign_key" update-rule: "no action" hidden-columns: [] indexes: - &d969753c-1818-4062-92f5-af0ee93e059d 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: - *ddff5076-668b-475a-83dd-40d6554350ca definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: true - *800bbb89-6b7e-43a6-83de-4da77536350c primary-key: *d969753c-1818-4062-92f5-af0ee93e059d privileges: - &e20b76fd-54cb-4cab-8517-3f96e3b684fa name: "DELETE" short-name: "\"Celebrity Updates\".\"DELETE\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"DELETE\"" attributes: {} grants: - &21fdbd56-e05d-468f-b8ec-b47dcc811ab2 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &e38b0567-0c5f-4fc8-a7b6-dff35ae87ef2 name: "INSERT" short-name: "\"Celebrity Updates\".\"INSERT\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"INSERT\"" attributes: {} grants: - &725bd145-47d4-4426-8449-faf3cba6964a grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &be119290-59e8-416c-8862-91c7a26a7bb5 name: "REFERENCES" short-name: "\"Celebrity Updates\".\"REFERENCES\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"REFERENCES\"" attributes: {} grants: - &cb3a3cd4-45a0-4d42-9346-f92dda4bd7a8 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &ebc56f7f-f206-4c3e-8555-104c928447ac name: "SELECT" short-name: "\"Celebrity Updates\".\"SELECT\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"SELECT\"" attributes: {} grants: - &df7f78bc-cdbf-4e7f-817a-1d258b632d9e grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &0c16df72-8795-4ade-bbaf-95783d46d87f name: "TRIGGER" short-name: "\"Celebrity Updates\".\"TRIGGER\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"TRIGGER\"" attributes: {} grants: - &fe82fd52-8c35-4367-9521-a19fa04ba28f grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - *e293a141-8ca1-496b-9e49-827546c46e8b referenced-tables: - *9d96da77-d355-4871-b2b2-1f900dbb8eb7 referencing-tables: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 table-constraints: - *d969753c-1818-4062-92f5-af0ee93e059d - *800bbb89-6b7e-43a6-83de-4da77536350c - &fe10e4a7-ee8b-4c4d-b1dc-b4d8671dfbf8 name: "SYS_CT_10129" short-name: "\"Celebrity Updates\".SYS_CT_10129" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".SYS_CT_10129" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: - *ddff5076-668b-475a-83dd-40d6554350ca deferrable: false definition: "BOOKS.\"Celebrity Updates\".\"Celebrity Id\" IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] foreign-keys: - *800bbb89-6b7e-43a6-83de-4da77536350c hidden-columns: [] indexes: - &fc4f3c67-0310-474b-b061-a172d6dee153 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: - *d32433de-3e05-4356-a5b0-fc4306f550f3 definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: true primary-key: *fc4f3c67-0310-474b-b061-a172d6dee153 privileges: - &e93b4e76-f816-4818-9308-4952e2de2660 name: "DELETE" short-name: "\"Celebrities\".\"DELETE\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"DELETE\"" attributes: {} grants: - &92fa4941-70fb-47e4-bab2-c9ccd773c41f grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &8530b84d-551a-4d3f-bf4c-6119ad1da6e4 name: "INSERT" short-name: "\"Celebrities\".\"INSERT\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"INSERT\"" attributes: {} grants: - &ec94bf05-5422-42e8-acb2-31d0385c8d4e grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &51d257f2-316a-4232-af7b-a310464f590b name: "REFERENCES" short-name: "\"Celebrities\".\"REFERENCES\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"REFERENCES\"" attributes: {} grants: - &a1876d67-d85f-4ac7-9e7e-076812c0782b grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &46377574-380e-4d7d-aa25-2402fe06e6ff name: "SELECT" short-name: "\"Celebrities\".\"SELECT\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"SELECT\"" attributes: {} grants: - &5383624e-62f7-4109-91b0-3a11d38d2968 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &e9e409f1-51bd-4d97-b043-c197c2ae7ce5 name: "TRIGGER" short-name: "\"Celebrities\".\"TRIGGER\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"TRIGGER\"" attributes: {} grants: - &ab56ec52-7505-49f3-8e1d-22ae99eb6858 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &d30696c5-649f-49a6-b760-243c261e2116 name: "UPDATE" short-name: "\"Celebrities\".\"UPDATE\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"UPDATE\"" attributes: {} grants: - &719b01b2-4a8a-449c-8a66-b04a26877a2b grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 referenced-tables: [] referencing-tables: - *a6c34776-935e-47de-b572-776cbdcc1a9d remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 table-constraints: - *fc4f3c67-0310-474b-b061-a172d6dee153 - &e94ec8c6-15b0-40ea-b7c7-9fcc959fb08b name: "SYS_CT_10127" short-name: "\"Celebrities\".SYS_CT_10127" full-name: "PUBLIC.BOOKS.\"Celebrities\".SYS_CT_10127" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: - *d32433de-3e05-4356-a5b0-fc4306f550f3 deferrable: false definition: "BOOKS.\"Celebrities\".\"Id\" IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] - *a6c34776-935e-47de-b572-776cbdcc1a9d - &3e7fbbf9-96db-4c6a-8e9c-a628da17285c name: "COUPONS" full-name: "PUBLIC.BOOKS.COUPONS" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *9c2dfb11-fcc2-40ea-b8a5-5fd349312ad0 - *6912abfd-3546-43d2-b286-deb6ed627d94 - *0e4998e7-3330-486a-aea3-8d903a37fa73 - *78d6d8b7-1d2b-4ab5-b27a-03f7b6357591 definition: "" dependent-tables: [] foreign-keys: [] hidden-columns: [] indexes: - &50e3ea81-4d87-4101-98e4-5f5f4385cfc5 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: - *9c2dfb11-fcc2-40ea-b8a5-5fd349312ad0 definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: true primary-key: *50e3ea81-4d87-4101-98e4-5f5f4385cfc5 privileges: - &a9a9c213-910b-4ff3-bdf4-4c167a7c3f5f name: "DELETE" short-name: "COUPONS.\"DELETE\"" full-name: "PUBLIC.BOOKS.COUPONS.\"DELETE\"" attributes: {} grants: - &09101eb9-aaf4-42d8-823b-8661e583bba4 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &f0a98889-6887-4100-9e34-764c94f31511 name: "INSERT" short-name: "COUPONS.\"INSERT\"" full-name: "PUBLIC.BOOKS.COUPONS.\"INSERT\"" attributes: {} grants: - &dfc5d657-453c-4cd2-8fe3-926b9e5c41ff grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &28d3f68b-2d6b-4134-a097-d81c62d7c81c name: "REFERENCES" short-name: "COUPONS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.COUPONS.\"REFERENCES\"" attributes: {} grants: - &c38c85f4-1717-4575-9f91-0c8624d41bc3 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &24c7682d-5d8e-4e10-bcf6-51e22369989e name: "SELECT" short-name: "COUPONS.\"SELECT\"" full-name: "PUBLIC.BOOKS.COUPONS.\"SELECT\"" attributes: {} grants: - &357ec8bd-90dc-415e-b3ce-1494acc507b2 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &cdcfecbc-9202-43e6-b528-ad46948b169b name: "TRIGGER" short-name: "COUPONS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.COUPONS.\"TRIGGER\"" attributes: {} grants: - &c617a0d6-64f1-4bbe-b4f5-82324d1bc28b grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &2463f694-19af-4a3e-8441-a604c33df634 name: "UPDATE" short-name: "COUPONS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.COUPONS.\"UPDATE\"" attributes: {} grants: - &7a756eaf-c3f1-4ddd-b1ab-b00167daf0dc grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 referenced-tables: [] referencing-tables: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 table-constraints: - *50e3ea81-4d87-4101-98e4-5f5f4385cfc5 - &2d531251-291e-49da-aedf-cdf7e341ef01 name: "SYS_CT_10093" short-name: "COUPONS.SYS_CT_10093" full-name: "PUBLIC.BOOKS.COUPONS.SYS_CT_10093" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: - *9c2dfb11-fcc2-40ea-b8a5-5fd349312ad0 deferrable: false definition: "BOOKS.COUPONS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] - &5d90f0d4-c635-4ac3-a1eb-62a5f6431de0 name: "CUSTOMERDATA" full-name: "PUBLIC.BOOKS.CUSTOMERDATA" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *11c8b427-bb2e-439d-874c-718b3713dc2b - *d956e174-ed35-4007-9d90-17f0538c789f definition: "" dependent-tables: [] foreign-keys: [] hidden-columns: [] indexes: - &a9f2c951-cfc9-463d-a681-ae01ea63b0da 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: - *11c8b427-bb2e-439d-874c-718b3713dc2b definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: true primary-key: *a9f2c951-cfc9-463d-a681-ae01ea63b0da privileges: - &343bf17f-dfe4-4f9e-a0c6-d8decf277150 name: "DELETE" short-name: "CUSTOMERDATA.\"DELETE\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"DELETE\"" attributes: {} grants: - &4d516ed2-4f5b-4e46-adaf-2cc519f45480 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &2bcdb6ce-0da3-45a7-84c3-14a2f32a60af name: "INSERT" short-name: "CUSTOMERDATA.\"INSERT\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"INSERT\"" attributes: {} grants: - &c3d98622-41d9-496b-81bd-dc11fe8cd990 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &a9a29e2c-f7c5-4ead-b90f-b1ec7b3b9186 name: "REFERENCES" short-name: "CUSTOMERDATA.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"REFERENCES\"" attributes: {} grants: - &2299b36a-e920-4c71-b409-93dfe7029350 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &57d69292-e375-4bb6-a153-11830c10b0fe name: "SELECT" short-name: "CUSTOMERDATA.\"SELECT\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"SELECT\"" attributes: {} grants: - &1bfe6bfb-eb86-44d2-8817-bfda042216b2 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &f7c63d21-4158-4b14-a70b-e29531ae7516 name: "TRIGGER" short-name: "CUSTOMERDATA.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"TRIGGER\"" attributes: {} grants: - &d2247122-8c1d-47e8-bc54-98570ef732a1 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &dc657fea-ff3b-468d-b920-fa85d3acd0d5 name: "UPDATE" short-name: "CUSTOMERDATA.\"UPDATE\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"UPDATE\"" attributes: {} grants: - &a5310076-494d-49a4-9298-b3acc26105d3 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 referenced-tables: [] referencing-tables: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 table-constraints: - *a9f2c951-cfc9-463d-a681-ae01ea63b0da - &142fd612-accd-4fea-92db-4540d5657d13 name: "SYS_CT_10102" short-name: "CUSTOMERDATA.SYS_CT_10102" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.SYS_CT_10102" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: - *11c8b427-bb2e-439d-874c-718b3713dc2b deferrable: false definition: "BOOKS.CUSTOMERDATA.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] - &19443d3f-02b6-4a29-99c5-4006cd6d3c19 name: "CUSTOMERS" full-name: "PUBLIC.BOOKS.CUSTOMERS" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *7ee04bb4-801d-4728-b877-3213178485cf - *2bf02a01-eca3-49f3-aa1f-52df00c3a29e - *41c3e677-33e7-4997-ae99-b21479b1a341 - *f925bf6a-b58e-49e3-a4e5-9292cb828ce6 definition: "" dependent-tables: [] foreign-keys: [] hidden-columns: [] indexes: - &fb250335-2753-4106-8306-35faaca04136 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: - *7ee04bb4-801d-4728-b877-3213178485cf definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: true primary-key: *fb250335-2753-4106-8306-35faaca04136 privileges: - &3a7c57bc-aa1e-409d-9040-5dae6ea71cb0 name: "DELETE" short-name: "CUSTOMERS.\"DELETE\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"DELETE\"" attributes: {} grants: - &6ce55154-dcda-4938-8571-e037cca705fe grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &d2df1398-3c4a-4509-bcf2-857ce3c830c3 name: "INSERT" short-name: "CUSTOMERS.\"INSERT\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"INSERT\"" attributes: {} grants: - &f21b56ba-43e5-41da-9cca-675df76faf18 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &eb4e7677-bcaf-4858-ba33-14e57eb6281a name: "REFERENCES" short-name: "CUSTOMERS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"REFERENCES\"" attributes: {} grants: - &03cbb77f-ae68-4039-8ed0-43f07eab93ff grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &4164189c-7dd9-42ee-8d7e-20227e365876 name: "SELECT" short-name: "CUSTOMERS.\"SELECT\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"SELECT\"" attributes: {} grants: - &e5b2f252-1521-4c47-8383-20c71a376b3a grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &e82d41e7-fb29-4fe6-969f-26e857581064 name: "TRIGGER" short-name: "CUSTOMERS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"TRIGGER\"" attributes: {} grants: - &1084efaa-aa9b-4fe6-a531-542d4bb6babc grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &cc5dcc27-fba1-408b-849a-a33bd117b278 name: "UPDATE" short-name: "CUSTOMERS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"UPDATE\"" attributes: {} grants: - &903de040-71df-4412-8e0b-16555be60bfd grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 referenced-tables: [] referencing-tables: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 table-constraints: - *fb250335-2753-4106-8306-35faaca04136 - &64798db4-edcf-42bc-85ac-05bddcb0d303 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: - *7ee04bb4-801d-4728-b877-3213178485cf deferrable: false definition: "BOOKS.CUSTOMERS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" - &37d37c31-45d0-4e0d-a88a-e39c0f9782ff name: "SYS_CT_10096" short-name: "CUSTOMERS.SYS_CT_10096" full-name: "PUBLIC.BOOKS.CUSTOMERS.SYS_CT_10096" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: - *2bf02a01-eca3-49f3-aa1f-52df00c3a29e deferrable: false definition: "BOOKS.CUSTOMERS.FIRSTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" - &a1bf7984-e2ad-498d-b6bb-a875ce2f1456 name: "SYS_CT_10097" short-name: "CUSTOMERS.SYS_CT_10097" full-name: "PUBLIC.BOOKS.CUSTOMERS.SYS_CT_10097" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: - *41c3e677-33e7-4997-ae99-b21479b1a341 deferrable: false definition: "BOOKS.CUSTOMERS.LASTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] - &d7ded314-c783-483f-ace4-010eef16ba67 name: "PUBLISHERS" full-name: "PUBLIC.BOOKS.PUBLISHERS" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "List of book publishers" columns: - *3b504be2-072b-4f97-9af9-53f7b779198e - *8af5a6ac-e405-4e7b-88fc-4050f7c22be7 definition: "" dependent-tables: - &525779e6-b6c2-4a24-a07f-b597ee457866 name: "ΒΙΒΛΊΑ" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *50a34d32-6c48-4c5a-9052-7fea82f21b1c - *0d976223-673c-49d1-a1f6-1298fedb8015 - *516b9cff-b481-4a4c-b212-fba2245c0723 - *a6c9d700-7ca9-4c0d-894c-7b27ef6034a9 definition: "" dependent-tables: [] foreign-keys: - &beafad5b-9168-4b22-abc7-501d682b52b6 name: "FK_ΒΙΒΛΊΑ_PUBLISHERS" short-name: "ΒΙΒΛΊΑ.FK_ΒΙΒΛΊΑ_PUBLISHERS" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.FK_ΒΙΒΛΊΑ_PUBLISHERS" attributes: PK_NAME: "SYS_PK_10126" TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" column-references: - &688997bf-d07b-4fc2-a14a-be25c1ffb5d5 foreign-key-column: *a6c9d700-7ca9-4c0d-894c-7b27ef6034a9 key-sequence: 1 primary-key-column: *3b504be2-072b-4f97-9af9-53f7b779198e constrained-columns: - *a6c9d700-7ca9-4c0d-894c-7b27ef6034a9 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *525779e6-b6c2-4a24-a07f-b597ee457866 foreign-key-table: *525779e6-b6c2-4a24-a07f-b597ee457866 initially-deferred: false parent-partial: false primary-key-table: *d7ded314-c783-483f-ace4-010eef16ba67 referenced-table: *d7ded314-c783-483f-ace4-010eef16ba67 referencing-table: *525779e6-b6c2-4a24-a07f-b597ee457866 remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 specific-name: "FK_ΒΙΒΛΊΑ_PUBLISHERS" type: "foreign_key" update-rule: "no action" hidden-columns: [] indexes: - *beafad5b-9168-4b22-abc7-501d682b52b6 - &4c0ccb45-3ebb-478e-9318-adf5851cb7f4 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: - *50a34d32-6c48-4c5a-9052-7fea82f21b1c definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: true primary-key: *4c0ccb45-3ebb-478e-9318-adf5851cb7f4 privileges: - &6d03cf71-b28e-4d60-ba3c-3afe7fa91e47 name: "DELETE" short-name: "ΒΙΒΛΊΑ.\"DELETE\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"DELETE\"" attributes: {} grants: - &74857a27-27f7-48bb-a17b-6795ad813b29 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &2e083cf8-8e41-406b-8fbc-9c53b18cd24a name: "INSERT" short-name: "ΒΙΒΛΊΑ.\"INSERT\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"INSERT\"" attributes: {} grants: - &5ce01073-60bb-44e8-868f-56ae54f036d0 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &e97617e8-3433-4185-8dcd-408b87161e5c name: "REFERENCES" short-name: "ΒΙΒΛΊΑ.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"REFERENCES\"" attributes: {} grants: - &c4734f9f-8ab9-4478-b2ba-5f8f0575ebef grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &18a93394-30e8-4f5f-9711-b9ef2855cb0c name: "SELECT" short-name: "ΒΙΒΛΊΑ.\"SELECT\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"SELECT\"" attributes: {} grants: - &334597b1-1071-4107-ba89-d3e99c960497 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &9fb13eeb-65a9-440a-a168-05f2f985c105 name: "TRIGGER" short-name: "ΒΙΒΛΊΑ.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"TRIGGER\"" attributes: {} grants: - &592c0c13-3e5a-4824-8b22-5494645175c5 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &d800d58c-9f30-43a2-bc58-85844d5969e5 name: "UPDATE" short-name: "ΒΙΒΛΊΑ.\"UPDATE\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"UPDATE\"" attributes: {} grants: - &6e297b64-4412-4cbc-9bc6-d14d75366282 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 referenced-tables: - *d7ded314-c783-483f-ace4-010eef16ba67 referencing-tables: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 table-constraints: - *4c0ccb45-3ebb-478e-9318-adf5851cb7f4 - *beafad5b-9168-4b22-abc7-501d682b52b6 - &6d30115d-bf18-4c77-ae37-ae030ca90456 name: "SYS_CT_10133" short-name: "ΒΙΒΛΊΑ.SYS_CT_10133" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.SYS_CT_10133" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: - *50a34d32-6c48-4c5a-9052-7fea82f21b1c deferrable: false definition: "BOOKS.ΒΙΒΛΊΑ.ΜΟΝΑΔΙΚΌΣ IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" - &50a9bde8-0f1e-484b-8f4e-76af05098cb0 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: - *0d976223-673c-49d1-a1f6-1298fedb8015 deferrable: false definition: "BOOKS.ΒΙΒΛΊΑ.ΤΊΤΛΟΣ IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" - &826bb624-372f-4764-8324-d3b24d7aad1e 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: - *a6c9d700-7ca9-4c0d-894c-7b27ef6034a9 deferrable: false definition: "BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] foreign-keys: - *beafad5b-9168-4b22-abc7-501d682b52b6 hidden-columns: [] indexes: - &97d6e49a-79b4-4530-878a-4aca0a1da8ff name: "SYS_PK_10126" short-name: "PUBLISHERS.SYS_PK_10126" full-name: "PUBLIC.BOOKS.PUBLISHERS.SYS_PK_10126" attributes: INDEX_QUALIFIER: "PUBLIC" TABLE_CAT: "PUBLIC" TABLE_NAME: "PUBLISHERS" TABLE_SCHEM: "BOOKS" cardinality: 0 columns: - *3b504be2-072b-4f97-9af9-53f7b779198e definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 type: "other" unique: true primary-key: *97d6e49a-79b4-4530-878a-4aca0a1da8ff privileges: - &a9743373-7e16-4899-a0b8-660385f62ef5 name: "DELETE" short-name: "PUBLISHERS.\"DELETE\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"DELETE\"" attributes: {} grants: - &663914cc-4e6e-434e-a860-f65df088c7db grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &8620309a-8255-4d37-90cc-cd54a0ee5dcf name: "INSERT" short-name: "PUBLISHERS.\"INSERT\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"INSERT\"" attributes: {} grants: - &ae5a774e-3115-4531-98a4-7a530436a6fa grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &407dc05e-1991-491c-92f7-71f5a22c5ff0 name: "REFERENCES" short-name: "PUBLISHERS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"REFERENCES\"" attributes: {} grants: - &5611be2e-9c7a-4cb7-ba90-e456e0b24506 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &9b99a3e7-96c5-4af1-ac4c-a02fd595c470 name: "SELECT" short-name: "PUBLISHERS.\"SELECT\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"SELECT\"" attributes: {} grants: - &9fbaf8a7-8eee-4fab-9e61-610997e01be0 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &dee11cbb-78ca-499d-a527-65cbb16323e3 name: "TRIGGER" short-name: "PUBLISHERS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"TRIGGER\"" attributes: {} grants: - &3afb8ec7-2ea4-4fa4-8cda-274566c9cc5b grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &0ea27614-a730-48da-b094-dbdf2631e4a3 name: "UPDATE" short-name: "PUBLISHERS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"UPDATE\"" attributes: {} grants: - &3cccd9c2-bf38-465d-9f57-64dfa3149721 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 referenced-tables: [] referencing-tables: - *525779e6-b6c2-4a24-a07f-b597ee457866 remarks: "List of book publishers" schema: *68885dda-4857-405a-9011-535efc7e73b9 table-constraints: - *97d6e49a-79b4-4530-878a-4aca0a1da8ff table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] - *525779e6-b6c2-4a24-a07f-b597ee457866 - &a30909b6-6a17-454d-b9d3-93d1178cfa4e name: "AUTHORSLIST" full-name: "PUBLIC.BOOKS.AUTHORSLIST" alternate-keys: [] 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: - *fafe546e-27eb-4c1d-9a66-1d9a003813cc - *7ccd2a72-bac3-4214-837a-6e3e7837c19e - *ea4e3666-cc9b-4480-adfe-e97cc8c0fad3 definition: "SELECT ID,FIRSTNAME,LASTNAME FROM BOOKS.AUTHORS" dependent-tables: [] foreign-keys: [] hidden-columns: [] indexes: [] primary-key: null privileges: - &2201e85a-23eb-4c95-ae0f-bb461bf12034 name: "DELETE" short-name: "AUTHORSLIST.\"DELETE\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"DELETE\"" attributes: {} grants: - &8942f5d4-950c-4b6e-87fa-13f778426b88 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &44a30d10-1432-4f72-894d-4af5742098e7 name: "INSERT" short-name: "AUTHORSLIST.\"INSERT\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"INSERT\"" attributes: {} grants: - &5f528420-5dc4-4866-a321-b3c2dbe075cb grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &1e6b637f-afb1-4337-af6f-332d0bed7f78 name: "REFERENCES" short-name: "AUTHORSLIST.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"REFERENCES\"" attributes: {} grants: - &a6d710a3-01a6-46f4-ada6-5d4164495872 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &997b4f22-3e4c-46ff-9621-7ecdeeee94e4 name: "SELECT" short-name: "AUTHORSLIST.\"SELECT\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"SELECT\"" attributes: {} grants: - &b117f5a6-d272-418e-b1c3-d033746d9e63 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &42f94eaf-2f37-4a8b-ba0d-be5693d4f8e5 name: "TRIGGER" short-name: "AUTHORSLIST.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"TRIGGER\"" attributes: {} grants: - &3fe46a15-aa51-4209-be54-8f755542fb5e grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 - &4aecbf79-6d27-472e-b0af-c75f86f384ad name: "UPDATE" short-name: "AUTHORSLIST.\"UPDATE\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"UPDATE\"" attributes: {} grants: - &d1ffb9b3-3aaf-41ba-851b-2e93e32b0250 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 referenced-tables: [] referencing-tables: [] remarks: "" schema: *68885dda-4857-405a-9011-535efc7e73b9 table-constraints: [] table-type: &9b331ad4-8396-4967-80e0-898281f15813 table-type: "VIEW" view: true table-usage: - *9519f0c8-09b2-4f68-adc8-5d264f661c76 triggers: [] type: *9b331ad4-8396-4967-80e0-898281f15813 updatable: true weak-associations: [] - &73743be9-0574-4b12-9000-3938a896f050 name: "EXTRA_PK" full-name: "PUBLIC.FOR_LINT.EXTRA_PK" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "Extra table with just a primary key" columns: - *08b6b92f-c297-4e08-9411-7666d4105639 - *1f956340-4f70-474b-a62f-e67257729c01 - *323720b3-0bad-4eda-b3ea-a61f71782332 definition: "" dependent-tables: [] foreign-keys: - &8ea7f891-3865-4a5c-8043-cb24ec3ad62f 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: - &9a822c14-e580-4514-ab5f-7dbe3f838cbe foreign-key-column: *1f956340-4f70-474b-a62f-e67257729c01 key-sequence: 1 primary-key-column: *d4c0280f-c218-4dcb-bae8-d096b823634a constrained-columns: - *1f956340-4f70-474b-a62f-e67257729c01 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *73743be9-0574-4b12-9000-3938a896f050 foreign-key-table: *73743be9-0574-4b12-9000-3938a896f050 initially-deferred: false parent-partial: false primary-key-table: &57baa100-ee18-42cb-9b8f-1ba8225c0fe8 name: "PUBLICATIONS" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *d4c0280f-c218-4dcb-bae8-d096b823634a - *19e9fdb3-1f90-4dec-9b77-f79bb9423630 - *95c35433-ec0c-4d4d-91e3-83c76afead98 - *637aa922-3279-44e6-8150-badb2eb4b9cc - *e002c5e2-d162-413b-af4a-ac8636120c28 - *1d5dd639-2706-4a4e-8554-d36e0674a6e4 - *a6c6809c-7d4a-472b-92a9-f64cc52a6288 - *668c2cc8-4e83-4e97-8d7b-53a3733d4059 definition: "" dependent-tables: - *73743be9-0574-4b12-9000-3938a896f050 - &3a442b14-23af-40af-b020-aba55de66ce6 name: "PUBLICATIONWRITERS" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *6165f946-f35b-4be9-baee-274d079e3dc2 - *6336baae-3336-453e-b12d-67e06b2b757e definition: "" dependent-tables: [] foreign-keys: - &1f0a072b-7597-4e61-8b8b-edab99c53b41 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: - &751d9153-32a7-413b-b65b-4b4370d3dfac foreign-key-column: *6165f946-f35b-4be9-baee-274d079e3dc2 key-sequence: 1 primary-key-column: *d4c0280f-c218-4dcb-bae8-d096b823634a constrained-columns: - *6165f946-f35b-4be9-baee-274d079e3dc2 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *3a442b14-23af-40af-b020-aba55de66ce6 foreign-key-table: *3a442b14-23af-40af-b020-aba55de66ce6 initially-deferred: false parent-partial: false primary-key-table: *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 referenced-table: *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 referencing-table: *3a442b14-23af-40af-b020-aba55de66ce6 remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d specific-name: "FK_PUBLICATION" type: "foreign_key" update-rule: "no action" - &efbcb70b-3101-447f-aa0f-ab84d2325890 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: - &93388176-f3d4-4713-99ad-156878fc10eb foreign-key-column: *6336baae-3336-453e-b12d-67e06b2b757e key-sequence: 1 primary-key-column: *2949cc91-d31a-4bf9-86f6-519ab05804fe constrained-columns: - *6336baae-3336-453e-b12d-67e06b2b757e deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *3a442b14-23af-40af-b020-aba55de66ce6 foreign-key-table: *3a442b14-23af-40af-b020-aba55de66ce6 initially-deferred: false parent-partial: false primary-key-table: &697c3857-7dc4-4a59-b706-ee09db3c7bb2 name: "WRITERS" full-name: "PUBLIC.FOR_LINT.WRITERS" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *2949cc91-d31a-4bf9-86f6-519ab05804fe - *bc9d9242-07e0-452f-ba80-1ad75778afea - *f368cba1-1fe4-41c5-9a1e-8b1e8f75530d - *7cfe2243-e6f1-4e88-befd-456578cafa94 - *0e41b547-992f-4042-9aea-5ff4c819243f - *dbfc77d6-5272-453b-a9e2-f42a3940cac8 - *ecf6f2f8-1cc8-452f-bdd7-078e29851c1c - *465223d8-d3e6-46d7-bceb-f9acd51489a1 - *f88b80fc-c2e2-4ae2-9f0d-7b4a7eb75906 - *1431c7a4-ac87-44f7-bb93-647f35599064 - *f30409eb-353c-4050-9e0e-14eb6df04d9e - *31233b82-1f43-4505-aa5d-e88870b646dd - *3628f920-3257-4ac3-92a2-689f3ff323dc - *69402c6f-0e11-44ff-8fca-7c27b2ac24b4 - *ca846041-1965-4459-8c78-698801c92e69 - *c7b0edf2-583f-43c9-aaf5-ea80c39ff720 - *84d0e647-8eed-4ace-bde8-1c8bfb34b909 - *70658a1f-04a2-4e0a-9bc9-96ff19bd996d definition: "" dependent-tables: - *73743be9-0574-4b12-9000-3938a896f050 - *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 - *3a442b14-23af-40af-b020-aba55de66ce6 foreign-keys: - &9c4fcf9c-89d1-4442-a3b5-551dfcdd05bd 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: - &c3e661d0-2065-4a5e-b68e-a1d9ec04cedb foreign-key-column: *70658a1f-04a2-4e0a-9bc9-96ff19bd996d key-sequence: 1 primary-key-column: *d4c0280f-c218-4dcb-bae8-d096b823634a constrained-columns: - *70658a1f-04a2-4e0a-9bc9-96ff19bd996d deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *697c3857-7dc4-4a59-b706-ee09db3c7bb2 foreign-key-table: *697c3857-7dc4-4a59-b706-ee09db3c7bb2 initially-deferred: false parent-partial: false primary-key-table: *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 referenced-table: *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 referencing-table: *697c3857-7dc4-4a59-b706-ee09db3c7bb2 remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d specific-name: "FK_WRITERS_PUBLICATION" type: "foreign_key" update-rule: "no action" - &eef8139d-cdba-4e34-b0d5-ac674dedeb25 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: - &22def63a-0dc2-4dac-a333-ca22fcb7c531 foreign-key-column: *08b6b92f-c297-4e08-9411-7666d4105639 key-sequence: 1 primary-key-column: *2949cc91-d31a-4bf9-86f6-519ab05804fe constrained-columns: - *08b6b92f-c297-4e08-9411-7666d4105639 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *73743be9-0574-4b12-9000-3938a896f050 foreign-key-table: *73743be9-0574-4b12-9000-3938a896f050 initially-deferred: false parent-partial: false primary-key-table: *697c3857-7dc4-4a59-b706-ee09db3c7bb2 referenced-table: *697c3857-7dc4-4a59-b706-ee09db3c7bb2 referencing-table: *73743be9-0574-4b12-9000-3938a896f050 remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d specific-name: "FK_WRITER_JOIN" type: "foreign_key" update-rule: "no action" - &72dd7f45-42ed-401a-8b8d-08be58c9f42c 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: - &879d20f6-1891-4af8-91f0-4720a4a95cfd foreign-key-column: *637aa922-3279-44e6-8150-badb2eb4b9cc key-sequence: 1 primary-key-column: *2949cc91-d31a-4bf9-86f6-519ab05804fe constrained-columns: - *637aa922-3279-44e6-8150-badb2eb4b9cc deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 foreign-key-table: *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 initially-deferred: false parent-partial: false primary-key-table: *697c3857-7dc4-4a59-b706-ee09db3c7bb2 referenced-table: *697c3857-7dc4-4a59-b706-ee09db3c7bb2 referencing-table: *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d specific-name: "FK_PUBLICATIONS_WRITER" type: "foreign_key" update-rule: "no action" - *efbcb70b-3101-447f-aa0f-ab84d2325890 hidden-columns: [] indexes: - &09291507-810c-40fc-9788-4006bee71d03 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: - *2949cc91-d31a-4bf9-86f6-519ab05804fe definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "other" unique: true - *9c4fcf9c-89d1-4442-a3b5-551dfcdd05bd - &a8076c43-bd80-4ee3-988e-f93bf7472242 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: - *dbfc77d6-5272-453b-a9e2-f42a3940cac8 - *ecf6f2f8-1cc8-452f-bdd7-078e29851c1c definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "other" unique: false - &acb99b3c-8df4-4818-ab83-79b7b8f6b1ac 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: - *31233b82-1f43-4505-aa5d-e88870b646dd - *f88b80fc-c2e2-4ae2-9f0d-7b4a7eb75906 definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "other" unique: true - &f2663042-85e7-45b3-b187-ab92ea977a6c 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: - *f368cba1-1fe4-41c5-9a1e-8b1e8f75530d - *bc9d9242-07e0-452f-ba80-1ad75778afea definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "other" unique: false - &9de1224a-64f2-4acc-903f-a8bc07884cca 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: - *dbfc77d6-5272-453b-a9e2-f42a3940cac8 - *ecf6f2f8-1cc8-452f-bdd7-078e29851c1c - *465223d8-d3e6-46d7-bceb-f9acd51489a1 - *f88b80fc-c2e2-4ae2-9f0d-7b4a7eb75906 definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "other" unique: false primary-key: *09291507-810c-40fc-9788-4006bee71d03 privileges: - &533a0909-26de-4108-b79d-1a511e310c53 name: "DELETE" short-name: "WRITERS.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"DELETE\"" attributes: {} grants: - &c2b3c609-bd38-402d-bc35-b1f63c7a6f87 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &5f204eee-b38e-4e4a-bb2f-3a4fe0a8004f name: "INSERT" short-name: "WRITERS.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"INSERT\"" attributes: {} grants: - &47c01376-2bb8-4137-8cba-4fb714870513 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &0666151e-4e3b-4343-9288-5459eb270115 name: "REFERENCES" short-name: "WRITERS.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"REFERENCES\"" attributes: {} grants: - &19015756-cab5-4497-8099-a256a2fb1b64 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &c0423797-b999-47c0-8e99-b9b09a38f8a5 name: "SELECT" short-name: "WRITERS.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"SELECT\"" attributes: {} grants: - &f573b9de-3a7a-43ae-b5ea-df4786f474f0 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &124c6662-760d-4dc9-b25c-5abe35f1623d name: "TRIGGER" short-name: "WRITERS.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"TRIGGER\"" attributes: {} grants: - &25cee736-7a0b-4d02-8e4f-a8db07f7f975 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &cb1d0444-9c57-4bfe-8523-ae3dd9cf0326 name: "UPDATE" short-name: "WRITERS.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"UPDATE\"" attributes: {} grants: - &2aa8bbb0-cdd8-40d1-9317-13f48af3e999 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d referenced-tables: - *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 referencing-tables: - *73743be9-0574-4b12-9000-3938a896f050 - *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 - *3a442b14-23af-40af-b020-aba55de66ce6 remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d table-constraints: - *09291507-810c-40fc-9788-4006bee71d03 - *9c4fcf9c-89d1-4442-a3b5-551dfcdd05bd - &a02c4220-8168-4a44-9404-d3b58eb4a30e 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: - *ecf6f2f8-1cc8-452f-bdd7-078e29851c1c deferrable: false definition: "FOR_LINT.WRITERS.STATE=UPPER(FOR_LINT.WRITERS.STATE)" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" - &7e26116b-d535-4469-9857-c3aada18ba15 name: "SYS_CT_10156" short-name: "WRITERS.SYS_CT_10156" full-name: "PUBLIC.FOR_LINT.WRITERS.SYS_CT_10156" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *2949cc91-d31a-4bf9-86f6-519ab05804fe deferrable: false definition: "FOR_LINT.WRITERS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" - &448edb37-f1f6-4849-883d-12d5db221379 name: "SYS_CT_10157" short-name: "WRITERS.SYS_CT_10157" full-name: "PUBLIC.FOR_LINT.WRITERS.SYS_CT_10157" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *bc9d9242-07e0-452f-ba80-1ad75778afea deferrable: false definition: "FOR_LINT.WRITERS.FIRSTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" - &020e5227-6e91-4d52-917d-07990ce38ec9 name: "SYS_CT_10158" short-name: "WRITERS.SYS_CT_10158" full-name: "PUBLIC.FOR_LINT.WRITERS.SYS_CT_10158" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *f368cba1-1fe4-41c5-9a1e-8b1e8f75530d deferrable: false definition: "FOR_LINT.WRITERS.LASTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" - &fe1b8696-1b6e-4251-9789-8909cf14aa35 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: - *0e41b547-992f-4042-9aea-5ff4c819243f deferrable: false definition: "FOR_LINT.WRITERS.ADDRESS2 IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" - &02eb472c-5bfe-4668-a6dd-40ff9151e1b2 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: - *70658a1f-04a2-4e0a-9bc9-96ff19bd996d deferrable: false definition: "FOR_LINT.WRITERS.PUBLICATION_ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] referenced-table: *697c3857-7dc4-4a59-b706-ee09db3c7bb2 referencing-table: *3a442b14-23af-40af-b020-aba55de66ce6 remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d specific-name: "FK_WRITER" type: "foreign_key" update-rule: "no action" hidden-columns: [] indexes: - *efbcb70b-3101-447f-aa0f-ab84d2325890 - *1f0a072b-7597-4e61-8b8b-edab99c53b41 primary-key: null privileges: - &9bf555c4-70b2-4ca0-9243-e4ff33c30e12 name: "DELETE" short-name: "PUBLICATIONWRITERS.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"DELETE\"" attributes: {} grants: - &ed79707b-3217-4052-9762-1558104273a9 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &f1bd6a05-71ee-42f0-b85a-c7677d1e34ff name: "INSERT" short-name: "PUBLICATIONWRITERS.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"INSERT\"" attributes: {} grants: - &68cc43f5-60e3-449b-8c33-8f38b998bd98 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &56219ce2-6cd6-494e-8283-3ad55a59ca61 name: "REFERENCES" short-name: "PUBLICATIONWRITERS.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"REFERENCES\"" attributes: {} grants: - &f63fa838-5512-4c6a-819f-44296f8f3ec2 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &52594524-08a2-4138-9ae5-de31cb34e508 name: "SELECT" short-name: "PUBLICATIONWRITERS.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"SELECT\"" attributes: {} grants: - &223b9a2f-67d0-4b7f-9bf1-c315c6854653 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &018b227d-b050-4db2-88b8-9e20ea2bb8e4 name: "TRIGGER" short-name: "PUBLICATIONWRITERS.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"TRIGGER\"" attributes: {} grants: - &fd21ba83-7c48-4abe-be6d-cead0cd8ce9e grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &833390c9-c895-4e1d-974a-12ef4a822fd3 name: "UPDATE" short-name: "PUBLICATIONWRITERS.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"UPDATE\"" attributes: {} grants: - &d46e72e4-408e-40eb-801a-49428ea06515 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d referenced-tables: - *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 - *697c3857-7dc4-4a59-b706-ee09db3c7bb2 referencing-tables: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d table-constraints: - *1f0a072b-7597-4e61-8b8b-edab99c53b41 - *efbcb70b-3101-447f-aa0f-ab84d2325890 - &4bbf9aca-3ff1-4f54-a771-dee0879906f7 name: "SYS_CT_10174" short-name: "PUBLICATIONWRITERS.SYS_CT_10174" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.SYS_CT_10174" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *6165f946-f35b-4be9-baee-274d079e3dc2 deferrable: false definition: "FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" - &f2c234ac-6404-4cad-b9c2-bc3b99aa7cc4 name: "SYS_CT_10175" short-name: "PUBLICATIONWRITERS.SYS_CT_10175" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.SYS_CT_10175" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *6336baae-3336-453e-b12d-67e06b2b757e deferrable: false definition: "FOR_LINT.PUBLICATIONWRITERS.WRITERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] - *697c3857-7dc4-4a59-b706-ee09db3c7bb2 foreign-keys: - *72dd7f45-42ed-401a-8b8d-08be58c9f42c - *8ea7f891-3865-4a5c-8043-cb24ec3ad62f - *1f0a072b-7597-4e61-8b8b-edab99c53b41 - *9c4fcf9c-89d1-4442-a3b5-551dfcdd05bd hidden-columns: [] indexes: - *72dd7f45-42ed-401a-8b8d-08be58c9f42c - &d68e11a7-d709-4953-9c67-72df8930b068 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: - *d4c0280f-c218-4dcb-bae8-d096b823634a definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "other" unique: true primary-key: *d68e11a7-d709-4953-9c67-72df8930b068 privileges: - &2831e2a7-d965-43db-a8c8-30414b27fbd0 name: "DELETE" short-name: "PUBLICATIONS.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"DELETE\"" attributes: {} grants: - &c80b179f-b0a3-4b75-a17f-b6d1d13e5bca grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &d82ab72e-b17f-4bbb-a3de-32d1a5b4e5c8 name: "INSERT" short-name: "PUBLICATIONS.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"INSERT\"" attributes: {} grants: - &2e90a6db-a86e-4770-9df8-8f5d8c3e41d2 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &f189d45b-88a1-4fec-b96b-f06267b68bec name: "REFERENCES" short-name: "PUBLICATIONS.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"REFERENCES\"" attributes: {} grants: - &995af0d2-a040-4aa9-82f6-e90b7fce7e2e grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &f40918df-81af-4ea2-bd2e-bf90d9f812b4 name: "SELECT" short-name: "PUBLICATIONS.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"SELECT\"" attributes: {} grants: - &abb77d99-62db-4066-9910-8bc24d4f9018 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &1c5f1b66-ce20-45aa-85be-dce142e352c9 name: "TRIGGER" short-name: "PUBLICATIONS.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"TRIGGER\"" attributes: {} grants: - &369e8869-bad3-4f73-a3f6-b4e8857e8e9d grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - *a6c6809c-7d4a-472b-92a9-f64cc52a6288 referenced-tables: - *697c3857-7dc4-4a59-b706-ee09db3c7bb2 referencing-tables: - *73743be9-0574-4b12-9000-3938a896f050 - *3a442b14-23af-40af-b020-aba55de66ce6 - *697c3857-7dc4-4a59-b706-ee09db3c7bb2 remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d table-constraints: - *d68e11a7-d709-4953-9c67-72df8930b068 - *72dd7f45-42ed-401a-8b8d-08be58c9f42c - &6a662b61-1940-4eb0-926d-62663d7bfa11 name: "SYS_CT_10167" short-name: "PUBLICATIONS.SYS_CT_10167" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.SYS_CT_10167" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *d4c0280f-c218-4dcb-bae8-d096b823634a deferrable: false definition: "FOR_LINT.PUBLICATIONS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" - &5d340130-b62f-40f1-b1fe-435fcd4cc93d name: "SYS_CT_10168" short-name: "PUBLICATIONS.SYS_CT_10168" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.SYS_CT_10168" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *19e9fdb3-1f90-4dec-9b77-f79bb9423630 deferrable: false definition: "FOR_LINT.PUBLICATIONS.TITLE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" - &c2d4a662-6b9e-41cd-a616-6a3065e0c9b4 name: "SYS_CT_10169" short-name: "PUBLICATIONS.SYS_CT_10169" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.SYS_CT_10169" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *637aa922-3279-44e6-8150-badb2eb4b9cc deferrable: false definition: "FOR_LINT.PUBLICATIONS.WRITERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] referenced-table: *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 referencing-table: *73743be9-0574-4b12-9000-3938a896f050 remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d specific-name: "FK_PUBLICATION_JOIN" type: "foreign_key" update-rule: "no action" - *eef8139d-cdba-4e34-b0d5-ac674dedeb25 hidden-columns: [] indexes: - *eef8139d-cdba-4e34-b0d5-ac674dedeb25 - &9764a16c-3f06-490c-bd9e-0c4e61d8462a 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: - *323720b3-0bad-4eda-b3ea-a61f71782332 definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "other" unique: true - *8ea7f891-3865-4a5c-8043-cb24ec3ad62f primary-key: *9764a16c-3f06-490c-bd9e-0c4e61d8462a privileges: - &63f493fa-e872-445a-bc00-f1839e72635a name: "DELETE" short-name: "EXTRA_PK.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"DELETE\"" attributes: {} grants: - &7df3843f-edfb-464c-8d7b-49a4c9ee9b74 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &b0e914eb-ae7b-46a2-a65c-aba45977c228 name: "INSERT" short-name: "EXTRA_PK.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"INSERT\"" attributes: {} grants: - &81cc1f94-6c8f-4c97-9a74-886c9f77f8bd grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &7ad29d1d-c5bc-4678-8024-f8073e278a06 name: "REFERENCES" short-name: "EXTRA_PK.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"REFERENCES\"" attributes: {} grants: - &e392ffff-7b3c-4d76-b505-11383a8e9906 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &cfd92d03-68d7-443d-bfd2-e762de55f28c name: "SELECT" short-name: "EXTRA_PK.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"SELECT\"" attributes: {} grants: - &93dd5e04-ee06-455b-a224-2c5398963419 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &fc60bed1-c944-4af5-b368-6c7f1fcb0f47 name: "TRIGGER" short-name: "EXTRA_PK.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"TRIGGER\"" attributes: {} grants: - &2496fbd3-01e8-46b8-88bc-6aa436cfa6f6 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &39c85b3c-4abf-483d-b05a-da362ad7dcad name: "UPDATE" short-name: "EXTRA_PK.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"UPDATE\"" attributes: {} grants: - &bb6d6d04-29a6-4f41-bad9-7a011cf1d835 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d referenced-tables: - *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 - *697c3857-7dc4-4a59-b706-ee09db3c7bb2 referencing-tables: [] remarks: "Extra table with just a primary key" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d table-constraints: - *9764a16c-3f06-490c-bd9e-0c4e61d8462a - *8ea7f891-3865-4a5c-8043-cb24ec3ad62f - *eef8139d-cdba-4e34-b0d5-ac674dedeb25 - &c11a8f0f-4077-481c-ab68-b6468dbba9b0 name: "SYS_CT_10182" short-name: "EXTRA_PK.SYS_CT_10182" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.SYS_CT_10182" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *08b6b92f-c297-4e08-9411-7666d4105639 deferrable: false definition: "FOR_LINT.EXTRA_PK.WRITERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" - &782ffe5b-3cce-4a97-8f4c-d1a8c3faa90a name: "SYS_CT_10183" short-name: "EXTRA_PK.SYS_CT_10183" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.SYS_CT_10183" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *1f956340-4f70-474b-a62f-e67257729c01 deferrable: false definition: "FOR_LINT.EXTRA_PK.PUBLICATIONID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" - &75d31ae4-826a-454e-ba90-c4ef50c95af3 name: "SYS_CT_10184" short-name: "EXTRA_PK.SYS_CT_10184" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.SYS_CT_10184" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *323720b3-0bad-4eda-b3ea-a61f71782332 deferrable: false definition: "FOR_LINT.EXTRA_PK.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] - &7f070efd-9109-4876-bcf8-9b67613ebe1e name: "Global Counts" full-name: "PUBLIC.FOR_LINT.\"Global Counts\"" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *b65403ed-8b6f-4c5b-b603-45d079637399 definition: "" dependent-tables: [] foreign-keys: [] hidden-columns: [] indexes: [] primary-key: null privileges: - &703f6252-1732-4f78-8d62-3885d6b52a5f name: "DELETE" short-name: "\"Global Counts\".\"DELETE\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"DELETE\"" attributes: {} grants: - &1561c2dd-f869-40c3-aab3-d4c610923ffc grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &7cfdd77b-d2b9-4971-9c1e-b116eadf318d name: "INSERT" short-name: "\"Global Counts\".\"INSERT\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"INSERT\"" attributes: {} grants: - &6a6bdbbd-e6ef-4de9-bf6f-c1994d3009c9 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &65cb8d18-d956-4c09-b7c8-dc33769c8a59 name: "REFERENCES" short-name: "\"Global Counts\".\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"REFERENCES\"" attributes: {} grants: - &10e9db9f-6464-4b09-997d-212a3aa873f2 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &751c07cd-7bc4-4d4f-8df5-eacf9b09daf4 name: "SELECT" short-name: "\"Global Counts\".\"SELECT\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"SELECT\"" attributes: {} grants: - &f0529693-f0ad-4a91-b275-8822e1c3213f grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &90f4e38f-17a7-4ba9-987e-e46022f2dfa5 name: "TRIGGER" short-name: "\"Global Counts\".\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"TRIGGER\"" attributes: {} grants: - &e1e84699-c227-4be4-8202-fe3dd23af8ce grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &728354ce-54a4-4ef2-be72-54aa88d6f999 name: "UPDATE" short-name: "\"Global Counts\".\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"UPDATE\"" attributes: {} grants: - &5b0f9da0-8b94-4d51-ab6f-c7cbc7bcb480 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d referenced-tables: [] referencing-tables: [] remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d table-constraints: [] table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] - *57baa100-ee18-42cb-9b8f-1ba8225c0fe8 - *3a442b14-23af-40af-b020-aba55de66ce6 - &981e44f5-5b4d-4b74-93cc-f4e867f952c7 name: "SELFREFERENCE" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE" alternate-keys: [] attributes: HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: - *72251d8a-c72c-4078-b176-e0dcfb003976 - *aad3ac31-b9e5-44ee-b76f-3ad3b0a23d60 definition: "" dependent-tables: - *981e44f5-5b4d-4b74-93cc-f4e867f952c7 foreign-keys: - &0b3c3a59-f4e4-41f3-96c6-ab109859e1a7 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: - &287b2c38-dc99-4527-81e6-a8782a50f7d0 foreign-key-column: *72251d8a-c72c-4078-b176-e0dcfb003976 key-sequence: 1 primary-key-column: *72251d8a-c72c-4078-b176-e0dcfb003976 constrained-columns: - *72251d8a-c72c-4078-b176-e0dcfb003976 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *981e44f5-5b4d-4b74-93cc-f4e867f952c7 foreign-key-table: *981e44f5-5b4d-4b74-93cc-f4e867f952c7 initially-deferred: false parent-partial: false primary-key-table: *981e44f5-5b4d-4b74-93cc-f4e867f952c7 referenced-table: *981e44f5-5b4d-4b74-93cc-f4e867f952c7 referencing-table: *981e44f5-5b4d-4b74-93cc-f4e867f952c7 remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d specific-name: "FK_SELFREFERENCE" type: "foreign_key" update-rule: "no action" hidden-columns: [] indexes: - &9ab694fc-8c59-40bc-82ab-41c76dcad797 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: - *72251d8a-c72c-4078-b176-e0dcfb003976 definition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "other" unique: true - *0b3c3a59-f4e4-41f3-96c6-ab109859e1a7 primary-key: *9ab694fc-8c59-40bc-82ab-41c76dcad797 privileges: - &93efffc1-e721-4be2-bb3b-52008868bdfe name: "DELETE" short-name: "SELFREFERENCE.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"DELETE\"" attributes: {} grants: - &afe98ede-6146-4cb0-9ec2-3732fd57eb63 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &096e7000-a6b0-483d-9d7f-b9074bb308b5 name: "INSERT" short-name: "SELFREFERENCE.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"INSERT\"" attributes: {} grants: - &e05a8535-21ad-4355-a992-4768ac4aecc7 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &d9d498ef-6555-40c7-987d-2ea59338b98a name: "REFERENCES" short-name: "SELFREFERENCE.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"REFERENCES\"" attributes: {} grants: - &c6395d51-31a0-49de-b20b-728db56a7ef8 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &10d781f9-d735-4372-a76c-ba584875d35c name: "SELECT" short-name: "SELFREFERENCE.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"SELECT\"" attributes: {} grants: - &5ef6c2a2-3c9b-4af8-b9d4-ec4c48717173 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &89e6c3a7-32da-42d2-9d1d-c30ae5da561f name: "TRIGGER" short-name: "SELFREFERENCE.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"TRIGGER\"" attributes: {} grants: - &49b9a200-a197-4820-888a-50c7f2a9f02f grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d - &69c881d5-34f9-4f44-a664-022d3d46d33f name: "UPDATE" short-name: "SELFREFERENCE.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"UPDATE\"" attributes: {} grants: - &280502ff-3cee-4d7b-bffa-d97bec944dca grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d referenced-tables: - *981e44f5-5b4d-4b74-93cc-f4e867f952c7 referencing-tables: - *981e44f5-5b4d-4b74-93cc-f4e867f952c7 remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d table-constraints: - *9ab694fc-8c59-40bc-82ab-41c76dcad797 - *0b3c3a59-f4e4-41f3-96c6-ab109859e1a7 - &96831e03-50c4-4500-a2a4-11b83fc2e670 name: "SYS_CT_10190" short-name: "SELFREFERENCE.SYS_CT_10190" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.SYS_CT_10190" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *72251d8a-c72c-4078-b176-e0dcfb003976 deferrable: false definition: "FOR_LINT.SELFREFERENCE.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" - &ca55b52a-13ec-4d4c-a445-6af5807365de name: "SYS_CT_10191" short-name: "SELFREFERENCE.SYS_CT_10191" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.SYS_CT_10191" attributes: TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: - *aad3ac31-b9e5-44ee-b76f-3ad3b0a23d60 deferrable: false definition: "FOR_LINT.SELFREFERENCE.TITLE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *47f4d5b2-8ad7-4c7f-b43c-7d535f11b61d type: "check" table-type: *d330142d-210a-4997-a57f-a25b3ad46908 triggers: [] type: *d330142d-210a-4997-a57f-a25b3ad46908 weak-associations: [] - *697c3857-7dc4-4a59-b706-ee09db3c7bb2 - *dc1ca164-b17c-4539-8af6-1743a8391a3e - *85c98d67-e8f3-45e6-be7c-ef38808fd0a7 - *37550520-eadd-4a37-ac20-dc49cba0c6c0