--- ! &851012b7-f1dc-4ee1-8097-0eff268241bc all-table-columns: ! - ! &8b093e85-0060-40d5-94ad-491528f183b5 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: ! &a47ca776-4956-4a4f-8a9e-cf06be39d8df 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: ! &bcf08e39-2e31-43a2-8912-67229bf3b7fd 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: ! &145bb334-e001-4ba0-b514-11ddc45830b5 name: null full-name: "" catalog-name: null attributes: ! {} remarks: "" searchable: "searchable except with where .. like" standard-type-name: "INTEGER" type: "system" type-mapped-class-name: "java.lang.Integer" unsigned: false column-data-type-known: true decimal-digits: 0 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: ! &8a74f414-e10c-4b8e-a3a5-727594590127 name: "BOOKS" full-name: "PUBLIC.BOOKS" catalog-name: "PUBLIC" attributes: ! {} remarks: "" significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &b1fdc7e9-925a-4be1-b306-500b7e42b560 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &0a3ef741-d1f3-424f-b672-683c0b43d9fd 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &8d2694b4-80de-4dd1-af40-ab4840a5acad 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "Unique (internal) id for book" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &989f19ac-4497-43be-81a8-632ecd890468 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &617e4c71-996a-43a3-9204-58697ab28042 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &69d7adb5-7e33-4712-a569-adc18732adf8 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &75ccb53f-8b84-401c-80c4-671e864b0489 name: "CUSTOMERID" short-name: "CUSTOMERDATA.CUSTOMERID" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.CUSTOMERID" 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &377e8a0c-f4b0-466a-abe1-313a3d43ff36 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &a3204aae-446a-4dd6-abc9-6f22e177443b 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "Unique (internal) id for book publisher" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &93900315-4fda-4b25-8e12-034d9c2a6963 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: ! &b93184dc-f13f-4a68-8b31-d2aacd37e12c 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: ! &38edb4d3-e6c7-4449-812c-a9061b3ceaba 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "SMALLINT" type: "system" type-mapped-class-name: "java.lang.Integer" unsigned: false column-data-type-known: true decimal-digits: 0 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 16 type: *b93184dc-f13f-4a68-8b31-d2aacd37e12c width: "" - ! &3de8216d-a1d4-4c0b-8021-0c1fada9a386 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: ! &4ff74bf3-b80d-4ede-b206-e6155057f93e 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: ! &fbf7b3a8-54bd-4239-90c8-d27ccf2e24fb 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "BIGINT" type: "system" type-mapped-class-name: "java.lang.Long" unsigned: false column-data-type-known: true decimal-digits: 0 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: ! &12de9804-bcf2-41ee-a408-5ffdec4fd8f9 name: "FOR_LINT" full-name: "PUBLIC.FOR_LINT" catalog-name: "PUBLIC" attributes: ! {} remarks: "" significant: true size: 64 type: *4ff74bf3-b80d-4ede-b206-e6155057f93e width: "" - ! &a855b555-9a21-4e48-8135-00eb0eff4ac3 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: *4ff74bf3-b80d-4ede-b206-e6155057f93e 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 64 type: *4ff74bf3-b80d-4ede-b206-e6155057f93e width: "" - ! &bd863f3a-6c94-4bed-9813-e36410d4290b 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &66c1eeb9-acc8-4848-9fb2-747e680395de 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &a0a446a3-b9e7-4d3a-99fa-e5e21f6d6dee 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &f3a707ef-9343-42b2-ab63-deef4b31ae7d 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: true part-of-unique-index: true privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &b7c33725-b60f-4478-b428-a214c431af11 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: ! &da2319aa-86c6-4ebb-b6b9-5c8936bd9271 name: "PUBLISHER SALES" full-name: "PUBLIC.\"PUBLISHER SALES\"" catalog-name: "PUBLIC" attributes: ! {} remarks: "" significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &611fa020-103b-4cc9-89c2-e59ada1446aa 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: ! &c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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: ! &2a187ef4-2787-45a1-b4e1-b5d49857511f 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable" standard-type-name: "VARCHAR" type: "system" type-mapped-class-name: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: false size: 50 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(50)" - ! &ba9def58-4c7e-4eee-a239-8632046d4f2b 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: true size: 10 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(10)" - ! &fd521e01-ec48-462f-aee9-1d31afd73e0d 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: ! &73492c56-cab1-4ffd-82c4-52a69764c3fd 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: ! &e15c40dc-4f3c-4e8b-8d85-45a09c37bc89 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "not searchable" standard-type-name: "CLOB" type: "system" type-mapped-class-name: "java.sql.Clob" unsigned: false column-data-type-known: true decimal-digits: 0 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 1073741824 type: *73492c56-cab1-4ffd-82c4-52a69764c3fd width: "" - ! &02830c30-a2ac-4240-9486-11b401476555 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &8c46d186-75aa-4605-b211-1b146b9980b0 name: "DATAID" short-name: "CUSTOMERDATA.DATAID" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.DATAID" 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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: true part-of-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &f647f9d4-6a43-4e74-92eb-2c0a255c94e7 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 20 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(20)" - ! &94552b3f-4e4e-4df9-a29d-e1ac36ad057d 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 20 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(20)" - ! &6c697fda-ed40-456e-8095-82f1809962e3 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "Book title" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &2efb1d29-4d6d-45a3-849f-4aa65a2f5f20 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 20 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(20)" - ! &1d353f9a-5e6c-47bf-8239-80878e6e398c 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 20 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(20)" - ! &8c03552f-5c58-4be1-ad7e-1a48812f5a8c 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "Name of book publisher" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &4566b948-958a-49e4-ad8e-d6fb03e3fc93 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &6b44dd62-60ef-4b9f-9cfb-be60c2b40ca8 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: ! &12eb0058-a437-4e42-ada9-7d1cf12e1b9a 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: ! &c1de127d-1c75-4308-ab7c-c0f5761d3b1f 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: *8a74f414-e10c-4b8e-a3a5-727594590127 searchable: "not searchable" standard-type-name: "DISTINCT" type: "user_defined" type-mapped-class-name: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 100 type: *12eb0058-a437-4e42-ada9-7d1cf12e1b9a width: "" - ! &f9e114b0-45b7-4361-9b2a-2432d7b832d4 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: *4ff74bf3-b80d-4ede-b206-e6155057f93e 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 64 type: *4ff74bf3-b80d-4ede-b206-e6155057f93e width: "" - ! &9ba294ed-4d58-418d-9e38-1607117f2ba6 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &f944517a-edfd-4de9-bcc8-ccc29adb5a0a 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "Publication title" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &13cfd632-59d0-4334-913d-84e49ea355b2 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &68736f2f-d5e0-45f4-871c-5aa603ba8db1 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 20 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(20)" - ! &61f98cc3-c565-4b91-be22-0994739e6fa2 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: ! &f7157ac1-79d4-48d6-ac8b-29ac9b349841 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: ! &16916c27-932d-4806-8f2e-eeb7867f5b76 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "DOUBLE" type: "system" type-mapped-class-name: "java.lang.Double" unsigned: false column-data-type-known: true decimal-digits: 0 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: false size: 64 type: *f7157ac1-79d4-48d6-ac8b-29ac9b349841 width: "(64, 0)" - ! &b6535ce8-3422-46fc-aef1-97ed5d28e04b 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: false size: 2 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(2)" - ! &b3c6e2ff-239a-45d8-8a78-2eeb1dcd485f 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: true size: 50 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(50)" - ! &800a848d-c804-4d26-aa12-1c45560cb693 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 20 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(20)" - ! &df5c56ec-4ab5-4333-93c3-800400a5a7cd 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 20 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(20)" - ! &1b2eec16-69bc-4db0-aca0-2c6a138b202f 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 30 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(30)" - ! &217a1b8e-2126-4c0f-aa8a-7d12fb01413d 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "Book description\n(Usually the blurb from the book jacket or promotional\ \ materials)" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &d686041b-bbd9-48cd-98e1-7021dd2e2e25 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &55008e26-459b-4ae6-b3ba-40949e8e05da 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: ! &6f680eb5-005c-4abe-a102-a3638988b4dc 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: ! &4ef4cc4f-0119-40de-9811-8693565ffb09 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: *8a74f414-e10c-4b8e-a3a5-727594590127 searchable: "not searchable" standard-type-name: "ARRAY" type: "user_defined" type-mapped-class-name: "java.sql.Array" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: "ARRAY[]" generated: false hidden: false nullable: true ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 0 type: *6f680eb5-005c-4abe-a102-a3638988b4dc width: "" - ! &f64509af-dfce-4f42-9a6c-e811f6e5cb0a 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: *12eb0058-a437-4e42-ada9-7d1cf12e1b9a 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 100 type: *12eb0058-a437-4e42-ada9-7d1cf12e1b9a width: "" - ! &627ac30f-ddb1-4978-8a8b-549eb7514ef3 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: ! &565cc2f3-df33-48eb-8fcd-a815285da6f0 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: *2a187ef4-2787-45a1-b4e1-b5d49857511f literal-prefix: "" literal-suffix: "" local-type-name: "" maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 searchable: "not searchable" standard-type-name: "VARCHAR" type: "user_defined" type-mapped-class-name: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 20 type: *565cc2f3-df33-48eb-8fcd-a815285da6f0 width: "(20)" - ! &de483bfc-b00f-4fab-a4c3-bcb8b9504fa6 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &e0f434c6-dd35-4e53-8662-e8f82f49deec 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &b97dc25c-57a7-4149-9811-d912e8b20ca1 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 20 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(20)" - ! &0b263f73-64e8-4700-8183-18bc840f0c02 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &1163b132-fe33-4cf3-b27a-ebd8ec51ee13 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: true size: 10 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(10)" - ! &942d31aa-1949-4ed9-bfbd-bd4afd3fb2de 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "Foreign key to the book publisher" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &3b671b8f-87fd-4fcb-81ef-4d5fd4cddbad 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: *b93184dc-f13f-4a68-8b31-d2aacd37e12c 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 16 type: *b93184dc-f13f-4a68-8b31-d2aacd37e12c width: "" - ! &ea82ed79-6f52-4438-8002-c160885497c0 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &c69404bb-ac9a-451e-85ae-5e80fe1d4d79 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: ! &de7e6353-42ff-4c54-8194-b38d8e17e4bf name: "AGE_TYPE" full-name: "PUBLIC.BOOKS.AGE_TYPE" attributes: ! REMARKS: "" TYPE_CAT: "PUBLIC" TYPE_SCHEM: "BOOKS" auto-incrementable: false base-type: *b93184dc-f13f-4a68-8b31-d2aacd37e12c case-sensitive: false create-parameters: "" database-specific-type-name: "AGE_TYPE" enum-values: ! [] enumerated: false fixed-precision-scale: false java-sql-type: *c1de127d-1c75-4308-ab7c-c0f5761d3b1f literal-prefix: "" literal-suffix: "" local-type-name: "" maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 searchable: "not searchable" standard-type-name: "DISTINCT" type: "user_defined" type-mapped-class-name: "java.lang.Integer" unsigned: false column-data-type-known: true decimal-digits: 0 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 16 type: *de7e6353-42ff-4c54-8194-b38d8e17e4bf width: "" - ! &41d4bd7f-f73d-4cb1-9e4a-050f059adc4b 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: ! &f910ceef-0e0c-49e6-b03f-03fbb655c1e7 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: *4ef4cc4f-0119-40de-9811-8693565ffb09 literal-prefix: "" literal-suffix: "" local-type-name: "" maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 searchable: "not searchable" standard-type-name: "ARRAY" type: "user_defined" type-mapped-class-name: "java.sql.Array" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 0 type: *f910ceef-0e0c-49e6-b03f-03fbb655c1e7 width: "" - ! &4cf3802d-59a4-4a97-a10b-41a0d60f58fc 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: *4ff74bf3-b80d-4ede-b206-e6155057f93e 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 64 type: *4ff74bf3-b80d-4ede-b206-e6155057f93e width: "" - ! &f3eeab9c-8d49-4800-af4e-34a2d1d224a5 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &70b5c4b5-408b-4f17-bf1e-63337144d895 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: false size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &1b9b8983-9cc7-4db1-9dd7-a2e6a1dc0670 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: true size: 50 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(50)" - ! &7bd79813-6776-4993-87b2-d76e891829a7 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: ! &c4a0759e-1249-4bb0-b101-8c3ea16bf57b 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: ! &bd70a6ee-caf7-410b-a209-77dd893d645d 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "DATE" type: "system" type-mapped-class-name: "java.sql.Date" unsigned: false column-data-type-known: true decimal-digits: 0 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "Book publication date" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 10 type: *c4a0759e-1249-4bb0-b101-8c3ea16bf57b width: "" - ! &b11ccd1e-f678-4539-ba04-229131764937 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &0763781d-6f20-4c72-b643-2105e7910cd6 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: *c4a0759e-1249-4bb0-b101-8c3ea16bf57b 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 10 type: *c4a0759e-1249-4bb0-b101-8c3ea16bf57b width: "" - ! &a6322280-9744-49a9-8030-468fdc245c31 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 column-data-type-known: true decimal-digits: 0 default-value: "NULL" generated: false hidden: false nullable: false ordinal-position: 5 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 255 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(255)" - ! &116b2204-a271-44b8-98b0-bf98a35ff494 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: *c4a0759e-1249-4bb0-b101-8c3ea16bf57b 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: false size: 10 type: *c4a0759e-1249-4bb0-b101-8c3ea16bf57b width: "" - ! &d569e6be-360a-436c-a02e-3856d538d48f 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: *f7157ac1-79d4-48d6-ac8b-29ac9b349841 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "Current price for the book" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: false size: 64 type: *f7157ac1-79d4-48d6-ac8b-29ac9b349841 width: "(64, 0)" - ! &20be8e93-1eb5-4321-bb85-02b92d76f31e 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 50 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(50)" - ! &06a600cf-6bf0-4924-b26e-f9908b5e3a38 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: *f7157ac1-79d4-48d6-ac8b-29ac9b349841 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 64 type: *f7157ac1-79d4-48d6-ac8b-29ac9b349841 width: "(64, 0)" - ! &62347d20-e806-4c85-9e53-76fd0b4124ce 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 50 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(50)" - ! &75c4c9eb-798f-42e6-81ac-cd8b39528158 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: *f7157ac1-79d4-48d6-ac8b-29ac9b349841 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: false size: 64 type: *f7157ac1-79d4-48d6-ac8b-29ac9b349841 width: "(64, 0)" - ! &a26d50ce-5e0e-4677-b928-06d270afb008 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: ! &26e3ef8e-5ef1-4192-9a29-32c9b64bcbc9 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: ! &ab194b53-a14a-4cf7-ad05-19e1c977fad3 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable" standard-type-name: "CHAR" type: "system" type-mapped-class-name: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 2 type: *26e3ef8e-5ef1-4192-9a29-32c9b64bcbc9 width: "(2)" - ! &650550d8-ba1b-43e8-a3f2-51aab9e3c97e 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: true part-of-unique-index: true privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &b7ea0aa1-5836-4886-854e-5e22b79a7cce 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: *73492c56-cab1-4ffd-82c4-52a69764c3fd 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 1073741824 type: *73492c56-cab1-4ffd-82c4-52a69764c3fd width: "" - ! &89119879-1815-4ea0-9de4-5746bb2dca95 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 2 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(2)" - ! &45b736b5-90e9-433a-965a-9c4457f57a41 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 significant: true size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &5688bd29-74bd-45a0-85ec-932a39f6f746 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 10 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(10)" - ! &7e1de9e9-8fbb-41bb-b2cd-eb7f8aca8080 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: *73492c56-cab1-4ffd-82c4-52a69764c3fd 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 1073741824 type: *73492c56-cab1-4ffd-82c4-52a69764c3fd width: "" - ! &aae2e5ac-09ba-4f32-b94d-fbba773efb55 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 10 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(10)" - ! &52f5648c-a92d-4e69-94c7-133546845eb4 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 column-data-type-known: true decimal-digits: 0 default-value: "'USA'" generated: false hidden: false nullable: true ordinal-position: 9 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 significant: true size: 50 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(50)" - ! &57001323-a527-4e62-b83f-e20ba6fa1377 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 column-data-type-known: true decimal-digits: 0 default-value: "NULL" generated: false hidden: false nullable: true ordinal-position: 9 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 50 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(50)" - ! &67d16515-141a-4f40-9892-90589419450c 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 10 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(10)" - ! &64149585-54ab-41ff-92da-e68c7982c0ed 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 15 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(15)" - ! &feb2338c-1763-48bf-bafb-d0c9b0272013 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 10 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(10)" - ! &bbdd6b8d-22bb-49d4-a202-51aff02ab55d 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &d518a1b0-74d8-46da-853d-9ffc19b73a66 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 10 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(10)" - ! &0edb52b8-4d31-4d96-8854-9ce2f0abc96e 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: *a47ca776-4956-4a4f-8a9e-cf06be39d8df 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 32 type: *a47ca776-4956-4a4f-8a9e-cf06be39d8df width: "" - ! &f5942620-e9c0-43af-8fcc-7a6dcfe371ec 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 10 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(10)" - ! &60039c4f-8a66-4bce-997f-c531998e4581 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: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: false size: 10 type: *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 width: "(10)" - ! &6d0207ea-8b26-4c69-bef4-63e5eaa3356f 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: *4ff74bf3-b80d-4ede-b206-e6155057f93e 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-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 significant: true size: 64 type: *4ff74bf3-b80d-4ede-b206-e6155057f93e width: "" catalog: ! &4ac3100a-98b7-437c-93d5-f8531e2765f5 name: "catalog" full-name: "catalog" crawl-info: ! &2a04df4d-5287-40f3-bbc1-9fd1a6bae7e6 crawl-timestamp: "2026-07-14 23:47:56" crawl-timestamp-instant: "2026-07-14T23:47:56.502559938Z" database-version: ! &57ef99b1-c220-41e1-8ce8-b6b206b40ead name: "HSQL Database Engine" description: "" product-name: "HSQL Database Engine" product-version: "2.7.4" value: "2.7.4" jdbc-driver-version: ! &cb1a46ae-7011-40c6-b393-6bdb43813b5f name: "HSQL Database Engine Driver" description: "" product-name: "HSQL Database Engine Driver" product-version: "2.7.4" value: "2.7.4" jvm-version: ! &6901cdbd-4078-42c4-b00b-dd152735dd3a name: "Eclipse Adoptium OpenJDK 64-Bit\ \ Server VM" description: "" product-name: "Eclipse Adoptium OpenJDK 64-Bit Server VM" product-version: "17.0.19+10" value: "17.0.19+10" operating-system-version: ! &148052a9-35bb-4bb1-91ea-3857fa066883 name: "Linux" description: "" product-name: "Linux" product-version: "6.17.0-1018-azure" value: "6.17.0-1018-azure" run-id: "9b7c928f-4e26-4e8c-8cc9-98f64992643e" schema-crawler-version: ! &f32b4991-e024-4769-a2a1-ee63b54a3f3b name: "SchemaCrawler" description: "" product-name: "SchemaCrawler" product-version: "17.12.1" value: "17.12.1" database-info: *57ef99b1-c220-41e1-8ce8-b6b206b40ead jdbc-driver-info: *cb1a46ae-7011-40c6-b393-6bdb43813b5f schemas: ! - *8a74f414-e10c-4b8e-a3a5-727594590127 - *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &2f77725d-a132-44eb-9ffc-e7fb2a0ffad2 name: "INFORMATION_SCHEMA" full-name: "PUBLIC.INFORMATION_SCHEMA" catalog-name: "PUBLIC" attributes: ! {} remarks: "" - ! &a46aa036-a484-4cd4-8997-2f4fc9971f58 name: "PUBLIC" full-name: "PUBLIC.PUBLIC" catalog-name: "PUBLIC" attributes: ! {} remarks: "" - *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &82247d2e-0a8a-40bc-a6d0-e9cc8c7aaabe name: "SYSTEM_LOBS" full-name: "PUBLIC.SYSTEM_LOBS" catalog-name: "PUBLIC" attributes: ! {} remarks: "" system-column-data-types: ! - *4ff74bf3-b80d-4ede-b206-e6155057f93e - ! &6a9c24f6-724a-4226-876d-04adeafe3a77 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: ! &2bb6fc10-be47-4a7d-99c7-9f9898ade198 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable" standard-type-name: "BINARY" type: "system" type-mapped-class-name: "byte[]" unsigned: false - ! &aec80cf9-19ab-460f-9df1-ff357c95afa8 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: ! &9d5a4c51-fede-42bb-ab80-c542f94f4836 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "BIT" type: "system" type-mapped-class-name: "java.lang.Boolean" unsigned: false - ! &738a447d-2b1b-43dd-836e-2c89c70d09c8 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: ! &7edfecc6-f419-4352-a143-4ce9b931408b 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "not searchable" standard-type-name: "BLOB" type: "system" type-mapped-class-name: "java.sql.Blob" unsigned: false - ! &d41f3d82-f955-427d-9461-5eedf8e1c86a 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: ! &7e4c95ce-a0af-47ca-9e3d-301c09144b75 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "BOOLEAN" type: "system" type-mapped-class-name: "java.lang.Boolean" unsigned: false - *26e3ef8e-5ef1-4192-9a29-32c9b64bcbc9 - *73492c56-cab1-4ffd-82c4-52a69764c3fd - *c4a0759e-1249-4bb0-b101-8c3ea16bf57b - ! &55f91b2e-0764-4496-9042-5dab363ab461 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: ! &edee7ecd-d897-4e36-9943-38fb312c606a 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "DECIMAL" type: "system" type-mapped-class-name: "java.math.BigDecimal" unsigned: false - *f7157ac1-79d4-48d6-ac8b-29ac9b349841 - ! &ab5722da-a3d1-44ad-afa4-1dc5b3262cbb 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: *16916c27-932d-4806-8f2e-eeb7867f5b76 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "DOUBLE" type: "system" type-mapped-class-name: "java.lang.Double" unsigned: false - *a47ca776-4956-4a4f-8a9e-cf06be39d8df - ! &7893f8ea-3031-47ae-be5b-54d0a4660499 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: ! &e335922d-9f2b-422a-a47a-86939162b397 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "NUMERIC" type: "system" type-mapped-class-name: "java.math.BigDecimal" unsigned: false - ! &a34ee551-7016-495e-9c7c-c29983c605e5 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: *2a187ef4-2787-45a1-b4e1-b5d49857511f literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 remarks: "" schema: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable" standard-type-name: "VARCHAR" type: "system" type-mapped-class-name: "java.lang.String" unsigned: false - ! &620e74c9-2539-4d9c-8fd7-63a47d109f8d 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: ! &97f1b15e-1ca2-4ae8-911a-8e3632164fa4 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "OTHER" type: "system" type-mapped-class-name: "java.lang.Object" unsigned: false - ! &30d3ed66-4aa0-4c58-9d94-9ad720ef2753 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: *16916c27-932d-4806-8f2e-eeb7867f5b76 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "DOUBLE" type: "system" type-mapped-class-name: "java.lang.Float" unsigned: false - *b93184dc-f13f-4a68-8b31-d2aacd37e12c - ! &2b8cccf5-f6d2-463e-b8f0-12abe6cd7460 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: ! &89af9adb-dce9-43e8-b9ac-21fe718f87fc 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "TIME" type: "system" type-mapped-class-name: "java.sql.Time" unsigned: false - ! &42b99927-5abd-4d4b-8d3a-202e3b105f6f 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: ! &1b695041-9c39-428a-b4b5-6b49b05ef618 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "TIMESTAMP" type: "system" type-mapped-class-name: "java.sql.Timestamp" unsigned: false - ! &a1afac01-3268-40b6-b1c1-b7a5277ef962 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: ! &d5e59576-43d7-42d9-bc6e-53a12718e501 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "TIMESTAMP_WITH_TIMEZONE" type: "system" type-mapped-class-name: "java.time.OffsetDateTime" unsigned: false - ! &c32a91a3-e8cf-406f-8982-be70cf3faaa7 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: ! &7402e0ae-524a-42f6-aa0a-a968e584f22d 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "TIME_WITH_TIMEZONE" type: "system" type-mapped-class-name: "java.time.OffsetTime" unsigned: false - ! &ca710f2a-8632-49e3-bf4c-5eb394dee328 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: ! &06a53cde-d74c-4582-a00a-f411b63a38f0 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable except with where .. like" standard-type-name: "TINYINT" type: "system" type-mapped-class-name: "java.lang.Integer" unsigned: false - ! &6e0ef73e-d23c-4573-8ff9-1fc83a5ec351 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: *2bb6fc10-be47-4a7d-99c7-9f9898ade198 literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 16 remarks: "" schema: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable" standard-type-name: "BINARY" type: "system" type-mapped-class-name: "byte[]" unsigned: false - ! &d2f881a0-b288-47fd-b8f6-d9f4baa5aaa9 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: ! &d4fea0ca-204d-4047-8391-14ee52669973 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: *145bb334-e001-4ba0-b514-11ddc45830b5 searchable: "searchable" standard-type-name: "VARBINARY" type: "system" type-mapped-class-name: "byte[]" unsigned: false - *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 column-data-types: ! - *4ff74bf3-b80d-4ede-b206-e6155057f93e - *6a9c24f6-724a-4226-876d-04adeafe3a77 - *aec80cf9-19ab-460f-9df1-ff357c95afa8 - *738a447d-2b1b-43dd-836e-2c89c70d09c8 - *d41f3d82-f955-427d-9461-5eedf8e1c86a - *26e3ef8e-5ef1-4192-9a29-32c9b64bcbc9 - *73492c56-cab1-4ffd-82c4-52a69764c3fd - *c4a0759e-1249-4bb0-b101-8c3ea16bf57b - *55f91b2e-0764-4496-9042-5dab363ab461 - *f7157ac1-79d4-48d6-ac8b-29ac9b349841 - *ab5722da-a3d1-44ad-afa4-1dc5b3262cbb - *a47ca776-4956-4a4f-8a9e-cf06be39d8df - *7893f8ea-3031-47ae-be5b-54d0a4660499 - *a34ee551-7016-495e-9c7c-c29983c605e5 - *620e74c9-2539-4d9c-8fd7-63a47d109f8d - *30d3ed66-4aa0-4c58-9d94-9ad720ef2753 - *b93184dc-f13f-4a68-8b31-d2aacd37e12c - *2b8cccf5-f6d2-463e-b8f0-12abe6cd7460 - *42b99927-5abd-4d4b-8d3a-202e3b105f6f - *a1afac01-3268-40b6-b1c1-b7a5277ef962 - *c32a91a3-e8cf-406f-8982-be70cf3faaa7 - *ca710f2a-8632-49e3-bf4c-5eb394dee328 - *6e0ef73e-d23c-4573-8ff9-1fc83a5ec351 - *d2f881a0-b288-47fd-b8f6-d9f4baa5aaa9 - *c3745b8e-4e94-4d3f-8faa-6d93a1eeaa02 - *de7e6353-42ff-4c54-8194-b38d8e17e4bf - *6f680eb5-005c-4abe-a102-a3638988b4dc - *12eb0058-a437-4e42-ada9-7d1cf12e1b9a - *565cc2f3-df33-48eb-8fcd-a815285da6f0 - *f910ceef-0e0c-49e6-b03f-03fbb655c1e7 attributes: ! {} database-users: ! - ! &01964665-5284-4fbb-ae17-26f99979811d name: "OTHERUSER" full-name: "OTHERUSER" attributes: ! ADMIN: false AUTHENTICATION: "ANY" PASSWORD_DIGEST: "3680cf0219b09398c34f2137f27a0c02" remarks: "" - ! &01dd712d-6701-4325-a646-ec17ca8df4f5 name: "SA" full-name: "SA" attributes: ! ADMIN: true AUTHENTICATION: "LOCAL" PASSWORD_DIGEST: "d41d8cd98f00b204e9800998ecf8427e" remarks: "" remarks: "" routines: ! [] sequences: ! [] synonyms: ! [] tables: ! - ! &8d8ba623-288e-48bb-9a20-8d5fa413cde8 name: "AUTHORS" full-name: "PUBLIC.BOOKS.AUTHORS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "Contact details for book authors" columns: ! - *8b093e85-0060-40d5-94ad-491528f183b5 - *f647f9d4-6a43-4e74-92eb-2c0a255c94e7 - *800a848d-c804-4d26-aa12-1c45560cb693 - *ea82ed79-6f52-4438-8002-c160885497c0 - *b11ccd1e-f678-4539-ba04-229131764937 - *20be8e93-1eb5-4321-bb85-02b92d76f31e - *a26d50ce-5e0e-4677-b928-06d270afb008 - *5688bd29-74bd-45a0-85ec-932a39f6f746 - *52f5648c-a92d-4e69-94c7-133546845eb4 definition: "" dependent-tables: ! - ! &a840d743-96f2-47a5-9fee-fcab4b21c39a name: "BOOKAUTHORS" full-name: "PUBLIC.BOOKS.BOOKAUTHORS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "Relationship between books and their authors, \nalong with the latest\ \ updated information" columns: ! - *0a3ef741-d1f3-424f-b672-683c0b43d9fd - *02830c30-a2ac-4240-9486-11b401476555 - *1b2eec16-69bc-4db0-aca0-2c6a138b202f definition: "" dependent-tables: ! [] foreign-keys: ! - ! &b7693e20-d347-4d28-aea1-43b8b31ea006 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: ! - ! &dc54a470-bc21-4916-a096-1a389a04de7c foreign-key-column: *02830c30-a2ac-4240-9486-11b401476555 key-sequence: 1 primary-key-column: *8b093e85-0060-40d5-94ad-491528f183b5 self-referencing: false constrained-columns: ! - *02830c30-a2ac-4240-9486-11b401476555 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *a840d743-96f2-47a5-9fee-fcab4b21c39a foreign-key-table: *a840d743-96f2-47a5-9fee-fcab4b21c39a initially-deferred: false optional: false parent-partial: false primary-key-table: *8d8ba623-288e-48bb-9a20-8d5fa413cde8 referenced-table: *8d8ba623-288e-48bb-9a20-8d5fa413cde8 remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false type: "foreign_key" update-rule: "no action" - ! &4471bf2c-8c41-4403-b364-da676dfc547d name: "SYS_FK_10121" short-name: "BOOKAUTHORS.SYS_FK_10121" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.SYS_FK_10121" attributes: ! PK_NAME: "PK_BOOKS" TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" column-references: ! - ! &eaf4ea17-11ae-4cd3-9887-9e68439a0033 foreign-key-column: *0a3ef741-d1f3-424f-b672-683c0b43d9fd key-sequence: 1 primary-key-column: *8d2694b4-80de-4dd1-af40-ab4840a5acad self-referencing: false constrained-columns: ! - *0a3ef741-d1f3-424f-b672-683c0b43d9fd deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *a840d743-96f2-47a5-9fee-fcab4b21c39a foreign-key-table: *a840d743-96f2-47a5-9fee-fcab4b21c39a initially-deferred: false optional: false parent-partial: false primary-key-table: ! &baddd0b2-08e1-42de-98d4-3b9464a0572c name: "BOOKS" full-name: "PUBLIC.BOOKS.BOOKS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "Details for published books" columns: ! - *8d2694b4-80de-4dd1-af40-ab4840a5acad - *6c697fda-ed40-456e-8095-82f1809962e3 - *217a1b8e-2126-4c0f-aa8a-7d12fb01413d - *942d31aa-1949-4ed9-bfbd-bd4afd3fb2de - *7bd79813-6776-4993-87b2-d76e891829a7 - *d569e6be-360a-436c-a02e-3856d538d48f - *650550d8-ba1b-43e8-a3f2-51aab9e3c97e definition: "" dependent-tables: ! - *a840d743-96f2-47a5-9fee-fcab4b21c39a - *baddd0b2-08e1-42de-98d4-3b9464a0572c - ! &e5d82cd0-d802-46e6-81bd-6d68ae3f577b name: "SALES" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *ba9def58-4c7e-4eee-a239-8632046d4f2b - *b3c6e2ff-239a-45d8-8a78-2eeb1dcd485f - *0b263f73-64e8-4700-8183-18bc840f0c02 - *70b5c4b5-408b-4f17-bf1e-63337144d895 - *116b2204-a271-44b8-98b0-bf98a35ff494 - *75c4c9eb-798f-42e6-81ac-cd8b39528158 - *45b736b5-90e9-433a-965a-9c4457f57a41 definition: "" dependent-tables: ! [] foreign-keys: ! - ! &f1d307f7-33cc-4318-ba24-01ea349d0a29 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: ! - ! &e1df2839-12e8-4d9d-b70a-f5f77a3c5145 foreign-key-column: *0b263f73-64e8-4700-8183-18bc840f0c02 key-sequence: 1 primary-key-column: *8d2694b4-80de-4dd1-af40-ab4840a5acad self-referencing: false constrained-columns: ! - *0b263f73-64e8-4700-8183-18bc840f0c02 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *e5d82cd0-d802-46e6-81bd-6d68ae3f577b foreign-key-table: *e5d82cd0-d802-46e6-81bd-6d68ae3f577b initially-deferred: false optional: true parent-partial: false primary-key-table: *baddd0b2-08e1-42de-98d4-3b9464a0572c referenced-table: *baddd0b2-08e1-42de-98d4-3b9464a0572c remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 self-referencing: false type: "foreign_key" update-rule: "no action" - ! &37b43567-a472-4f4a-9d3f-c93955a51dc2 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: ! - ! &7fe702fb-bd76-4437-b61b-4657e5a2100f foreign-key-column: *45b736b5-90e9-433a-965a-9c4457f57a41 key-sequence: 1 primary-key-column: *b7c33725-b60f-4478-b428-a214c431af11 self-referencing: false constrained-columns: ! - *45b736b5-90e9-433a-965a-9c4457f57a41 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *e5d82cd0-d802-46e6-81bd-6d68ae3f577b foreign-key-table: *e5d82cd0-d802-46e6-81bd-6d68ae3f577b initially-deferred: false optional: true parent-partial: false primary-key-table: ! &2da18d85-6e7b-4e86-9aa5-bece2fc12115 name: "SALESDATA" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *b7c33725-b60f-4478-b428-a214c431af11 - *61f98cc3-c565-4b91-be22-0994739e6fa2 definition: "" dependent-tables: ! - *e5d82cd0-d802-46e6-81bd-6d68ae3f577b foreign-keys: ! - *37b43567-a472-4f4a-9d3f-c93955a51dc2 hidden-columns: ! [] indexes: ! - ! &2cdbd900-3c2a-402a-bae5-f7ed01c96736 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: ! - *b7c33725-b60f-4478-b428-a214c431af11 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 type: "other" unique: true primary-key: null privileges: ! - ! &6ffac24d-ecd4-425a-bdea-e4076eca1832 name: "DELETE" short-name: "SALESDATA.\"DELETE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"DELETE\"" attributes: ! {} grants: ! - ! &9c77a528-77c0-42ee-b503-e4708b841567 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &f6e427e8-079b-4eca-9fa8-9e2b3c37707d name: "INSERT" short-name: "SALESDATA.\"INSERT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"INSERT\"" attributes: ! {} grants: ! - ! &d18bd0fd-6de8-4ea2-a407-329e65706e23 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &7a24f040-05b1-495b-94fb-6705dac35437 name: "REFERENCES" short-name: "SALESDATA.\"REFERENCES\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"REFERENCES\"" attributes: ! {} grants: ! - ! &ed09be51-5343-4869-a7d5-d80a2018b047 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &7368aea1-91b1-4ca3-845b-521150921c22 name: "SELECT" short-name: "SALESDATA.\"SELECT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"SELECT\"" attributes: ! {} grants: ! - ! &e38d03ae-b71d-4009-aa26-4c0adc3c12fd grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &a3a35726-de0f-4429-9c28-72bd4ad58824 name: "TRIGGER" short-name: "SALESDATA.\"TRIGGER\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"TRIGGER\"" attributes: ! {} grants: ! - ! &2299150f-a8bc-406e-b062-7f539653c335 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &4cff7811-370b-4a34-b323-64ea5667f5aa name: "UPDATE" short-name: "SALESDATA.\"UPDATE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"UPDATE\"" attributes: ! {} grants: ! - ! &b0cda69e-51b4-4452-bc79-285616d8e680 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 self-referencing: false table-constraints: ! - *2cdbd900-3c2a-402a-bae5-f7ed01c96736 table-type: ! &79c9c3d1-4e90-4780-bbbf-ddf2319160ed table-type: "TABLE" view: false triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! - *e5d82cd0-d802-46e6-81bd-6d68ae3f577b referenced-table: *2da18d85-6e7b-4e86-9aa5-bece2fc12115 remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 self-referencing: false type: "foreign_key" update-rule: "no action" - ! &08d081e7-fc21-4b11-8af0-7a94343b31d2 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: ! - ! &c5a680b4-0774-4edc-a7a3-b56f2bbef230 foreign-key-column: *ba9def58-4c7e-4eee-a239-8632046d4f2b key-sequence: 1 primary-key-column: *1163b132-fe33-4cf3-b27a-ebd8ec51ee13 self-referencing: false - ! &8b0b8028-d2a9-4da4-a315-6edfbd1fb537 foreign-key-column: *b3c6e2ff-239a-45d8-8a78-2eeb1dcd485f key-sequence: 2 primary-key-column: *1b9b8983-9cc7-4db1-9dd7-a2e6a1dc0670 self-referencing: false constrained-columns: ! - *ba9def58-4c7e-4eee-a239-8632046d4f2b - *b3c6e2ff-239a-45d8-8a78-2eeb1dcd485f deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *e5d82cd0-d802-46e6-81bd-6d68ae3f577b foreign-key-table: *e5d82cd0-d802-46e6-81bd-6d68ae3f577b initially-deferred: false optional: false parent-partial: false primary-key-table: ! &a92fc35e-a065-4a61-92e2-ae8679c57ed4 name: "REGIONS" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *611fa020-103b-4cc9-89c2-e59ada1446aa - *b6535ce8-3422-46fc-aef1-97ed5d28e04b - *1163b132-fe33-4cf3-b27a-ebd8ec51ee13 - *1b9b8983-9cc7-4db1-9dd7-a2e6a1dc0670 definition: "" dependent-tables: ! - *e5d82cd0-d802-46e6-81bd-6d68ae3f577b foreign-keys: ! - *08d081e7-fc21-4b11-8af0-7a94343b31d2 hidden-columns: ! [] indexes: ! - ! &6440fcab-9a86-4807-9592-ababcd63e31b 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: ! - *1163b132-fe33-4cf3-b27a-ebd8ec51ee13 - *1b9b8983-9cc7-4db1-9dd7-a2e6a1dc0670 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 type: "other" unique: true primary-key: *6440fcab-9a86-4807-9592-ababcd63e31b privileges: ! - ! &6e06b9b2-4a7e-44a7-b3ac-c8cb35518476 name: "DELETE" short-name: "REGIONS.\"DELETE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"DELETE\"" attributes: ! {} grants: ! - ! &e7a2323a-2f30-41d0-95c2-063314a15e14 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &f7050748-967a-4e77-a409-397df0e1e55c name: "INSERT" short-name: "REGIONS.\"INSERT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"INSERT\"" attributes: ! {} grants: ! - ! &a09f62ff-54e3-4f3a-9214-d2fd38b451d3 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &566255df-acbe-4250-80a3-767de94a318e name: "REFERENCES" short-name: "REGIONS.\"REFERENCES\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &68ee2d9a-4f8d-4631-8f6f-4176becbd225 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &ba9f5fac-647d-4da7-a909-aa14d3389eb8 name: "SELECT" short-name: "REGIONS.\"SELECT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"SELECT\"" attributes: ! {} grants: ! - ! &d7f81d43-12a9-4a29-934d-553a89a4bf2b grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &ecc817e7-77d0-40cd-97f0-3216871e5b06 name: "TRIGGER" short-name: "REGIONS.\"TRIGGER\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &a89353e4-a22d-4866-853b-32b2089ca9fa grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &545c746a-a0fd-4593-a779-a4f73d840de6 name: "UPDATE" short-name: "REGIONS.\"UPDATE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"UPDATE\"" attributes: ! {} grants: ! - ! &d1083d9b-5074-4466-b31d-5f4e97250619 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 self-referencing: false table-constraints: ! - *6440fcab-9a86-4807-9592-ababcd63e31b - ! &05b1036a-b26c-4c69-b1c3-43f4a3660ee4 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: ! - *611fa020-103b-4cc9-89c2-e59ada1446aa deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.CITY IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 type: "check" - ! &2bf70573-cac6-4bba-bd0a-534f04d3b29f name: "SYS_CT_10208" short-name: "REGIONS.SYS_CT_10208" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.SYS_CT_10208" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "PUBLISHER SALES" constrained-columns: ! - *b6535ce8-3422-46fc-aef1-97ed5d28e04b deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.STATE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 type: "check" - ! &bd897970-2430-4a89-b3b4-011aa430f20f name: "SYS_CT_10209" short-name: "REGIONS.SYS_CT_10209" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.SYS_CT_10209" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "PUBLISHER SALES" constrained-columns: ! - *1163b132-fe33-4cf3-b27a-ebd8ec51ee13 deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.POSTALCODE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 type: "check" - ! &d9883698-6ab8-4b27-b620-3a02cfe42b1f name: "SYS_CT_10210" short-name: "REGIONS.SYS_CT_10210" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.SYS_CT_10210" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "PUBLISHER SALES" constrained-columns: ! - *1b9b8983-9cc7-4db1-9dd7-a2e6a1dc0670 deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.COUNTRY IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! - *e5d82cd0-d802-46e6-81bd-6d68ae3f577b referenced-table: *a92fc35e-a065-4a61-92e2-ae8679c57ed4 remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - *f1d307f7-33cc-4318-ba24-01ea349d0a29 - *37b43567-a472-4f4a-9d3f-c93955a51dc2 - *08d081e7-fc21-4b11-8af0-7a94343b31d2 primary-key: null privileges: ! - ! &4e77e2fc-597e-45f3-9114-c9f6d6658890 name: "DELETE" short-name: "SALES.\"DELETE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"DELETE\"" attributes: ! {} grants: ! - ! &53d6c809-1272-4bec-884b-068319fadb8a grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &3fde84c0-e732-4659-b31a-d1615d10941c name: "INSERT" short-name: "SALES.\"INSERT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"INSERT\"" attributes: ! {} grants: ! - ! &622a082d-5348-45d6-9d05-bcdb840436f9 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &971a2252-b9b7-44f0-b154-2333a855047a name: "REFERENCES" short-name: "SALES.\"REFERENCES\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"REFERENCES\"" attributes: ! {} grants: ! - ! &0e871507-f96c-4bc9-9892-f6e9b4c96e44 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &9539cb75-0122-4006-9aef-727b5520cbd1 name: "SELECT" short-name: "SALES.\"SELECT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"SELECT\"" attributes: ! {} grants: ! - ! &411d8062-24a6-450c-94f2-8bfce1ba6ae2 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &0665c263-95a6-49e5-9e15-fdad22f05158 name: "TRIGGER" short-name: "SALES.\"TRIGGER\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"TRIGGER\"" attributes: ! {} grants: ! - ! &b0fca140-1e1e-40ec-bddd-81aedc069dde grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 - ! &34373bf1-09ea-4c19-a96f-237b2b745e7f name: "UPDATE" short-name: "SALES.\"UPDATE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"UPDATE\"" attributes: ! {} grants: ! - ! &ef86df22-f2eb-4403-b464-30b731a48023 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 referenced-objects: ! - *baddd0b2-08e1-42de-98d4-3b9464a0572c - *a92fc35e-a065-4a61-92e2-ae8679c57ed4 - *2da18d85-6e7b-4e86-9aa5-bece2fc12115 referenced-tables: ! - *baddd0b2-08e1-42de-98d4-3b9464a0572c - *a92fc35e-a065-4a61-92e2-ae8679c57ed4 - *2da18d85-6e7b-4e86-9aa5-bece2fc12115 remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 self-referencing: false table-constraints: ! - *f1d307f7-33cc-4318-ba24-01ea349d0a29 - *37b43567-a472-4f4a-9d3f-c93955a51dc2 - *08d081e7-fc21-4b11-8af0-7a94343b31d2 - ! &126bee5b-2a85-4cd0-91e1-8405868eea3d name: "SYS_CT_10216" short-name: "SALES.SYS_CT_10216" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.SYS_CT_10216" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "PUBLISHER SALES" constrained-columns: ! - *ba9def58-4c7e-4eee-a239-8632046d4f2b deferrable: false definition: "\"PUBLISHER SALES\".SALES.POSTALCODE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 type: "check" - ! &046ba550-cd1c-46a7-95ee-31bb9bd4a3aa name: "SYS_CT_10217" short-name: "SALES.SYS_CT_10217" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.SYS_CT_10217" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "PUBLISHER SALES" constrained-columns: ! - *b3c6e2ff-239a-45d8-8a78-2eeb1dcd485f deferrable: false definition: "\"PUBLISHER SALES\".SALES.COUNTRY IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *da2319aa-86c6-4ebb-b6b9-5c8936bd9271 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! [] foreign-keys: ! - ! &aba56122-174d-4e28-88a1-f51e3b380c6a 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: ! - ! &810cb4cf-89f9-44ad-8731-7f7df46ce337 foreign-key-column: *650550d8-ba1b-43e8-a3f2-51aab9e3c97e key-sequence: 1 primary-key-column: *8d2694b4-80de-4dd1-af40-ab4840a5acad self-referencing: false constrained-columns: ! - *650550d8-ba1b-43e8-a3f2-51aab9e3c97e deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *baddd0b2-08e1-42de-98d4-3b9464a0572c foreign-key-table: *baddd0b2-08e1-42de-98d4-3b9464a0572c initially-deferred: false optional: true parent-partial: false primary-key-table: *baddd0b2-08e1-42de-98d4-3b9464a0572c referenced-table: *baddd0b2-08e1-42de-98d4-3b9464a0572c remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: true type: "foreign_key" update-rule: "no action" - *f1d307f7-33cc-4318-ba24-01ea349d0a29 - *4471bf2c-8c41-4403-b364-da676dfc547d hidden-columns: ! [] indexes: ! - ! &607692e9-80b8-46af-aa79-f7ec94d3400c 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: ! - *8d2694b4-80de-4dd1-af40-ab4840a5acad definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: true - ! &22d124d6-310e-4bd0-ae4b-f5764fe22c9e 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: ! - *650550d8-ba1b-43e8-a3f2-51aab9e3c97e definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: true - *aba56122-174d-4e28-88a1-f51e3b380c6a primary-key: *607692e9-80b8-46af-aa79-f7ec94d3400c privileges: ! - ! &31cc8411-b1e9-4bf0-a08b-026349fdc449 name: "DELETE" short-name: "BOOKS.\"DELETE\"" full-name: "PUBLIC.BOOKS.BOOKS.\"DELETE\"" attributes: ! {} grants: ! - ! &e74a1928-a89a-4b60-8cdb-eea2a083db4d grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &270441b8-4e6b-4fb2-a2e5-f11f65ad3086 name: "INSERT" short-name: "BOOKS.\"INSERT\"" full-name: "PUBLIC.BOOKS.BOOKS.\"INSERT\"" attributes: ! {} grants: ! - ! &cc094e7c-3bf2-4611-9189-8693f8836e9e grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &10c3f7f1-509c-4713-85ff-c02b35850281 name: "REFERENCES" short-name: "BOOKS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.BOOKS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &365a62f6-19c8-45a5-ba64-19c9b2da87ba grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &02a1975f-b4b3-4488-a351-831519b923ae name: "SELECT" short-name: "BOOKS.\"SELECT\"" full-name: "PUBLIC.BOOKS.BOOKS.\"SELECT\"" attributes: ! {} grants: ! - ! &85d8747d-f2ae-4217-92d7-f5a807d853bd grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &81239273-6822-4186-a599-d315fbd068b0 name: "TRIGGER" short-name: "BOOKS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.BOOKS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &ceb8a3b8-3a84-4b49-9231-d79bfb2be5f6 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &9135e53b-93b6-4a1d-8a83-86cbabf41cb2 name: "UPDATE" short-name: "BOOKS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.BOOKS.\"UPDATE\"" attributes: ! {} grants: ! - ! &52e7e415-e903-4c21-981b-477188219f30 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 referenced-objects: ! - *baddd0b2-08e1-42de-98d4-3b9464a0572c referenced-tables: ! - *baddd0b2-08e1-42de-98d4-3b9464a0572c remarks: "Details for published books" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: true table-constraints: ! - *607692e9-80b8-46af-aa79-f7ec94d3400c - *aba56122-174d-4e28-88a1-f51e3b380c6a - *22d124d6-310e-4bd0-ae4b-f5764fe22c9e - ! &9ea7ec96-36c5-447a-9009-353696a9aaaa 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: ! - *8d2694b4-80de-4dd1-af40-ab4840a5acad deferrable: false definition: "BOOKS.BOOKS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" - ! &eb441bad-0ba5-45ff-988c-5675786b3d03 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: ! - *6c697fda-ed40-456e-8095-82f1809962e3 deferrable: false definition: "BOOKS.BOOKS.TITLE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" - ! &6266b35f-5716-4f10-a8d1-8d95535ff339 name: "SYS_CT_10114" short-name: "BOOKS.SYS_CT_10114" full-name: "PUBLIC.BOOKS.BOOKS.SYS_CT_10114" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: ! - *942d31aa-1949-4ed9-bfbd-bd4afd3fb2de deferrable: false definition: "BOOKS.BOOKS.PUBLISHERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! - *e5d82cd0-d802-46e6-81bd-6d68ae3f577b - *a840d743-96f2-47a5-9fee-fcab4b21c39a - *baddd0b2-08e1-42de-98d4-3b9464a0572c referenced-table: *baddd0b2-08e1-42de-98d4-3b9464a0572c remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - *b7693e20-d347-4d28-aea1-43b8b31ea006 - *4471bf2c-8c41-4403-b364-da676dfc547d - ! &d7957039-b342-452c-be4e-e9e107f38306 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: ! - *0a3ef741-d1f3-424f-b672-683c0b43d9fd - *02830c30-a2ac-4240-9486-11b401476555 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: true primary-key: null privileges: ! - ! &fe4a93f8-1ee2-4651-a530-c694dbe1209a name: "DELETE" short-name: "BOOKAUTHORS.\"DELETE\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"DELETE\"" attributes: ! {} grants: ! - ! &be75f439-6357-4067-9db9-05b0c903d7dd grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &56f02825-2d3a-458d-a649-1c7d6a573d38 name: "INSERT" short-name: "BOOKAUTHORS.\"INSERT\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"INSERT\"" attributes: ! {} grants: ! - ! &d45a4a1c-8e6f-40ee-be5a-22437c05acaa grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &dfc8164c-345d-47c2-a86b-9cd11f5729bc name: "REFERENCES" short-name: "BOOKAUTHORS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &6aa3b3b4-e0f1-4842-aca6-1d9d6e7c5ba9 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &806d6487-7f52-4ed7-98fe-9b9e7bf77ce2 name: "SELECT" short-name: "BOOKAUTHORS.\"SELECT\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"SELECT\"" attributes: ! {} grants: ! - ! &4ee1cb52-d848-47f2-9bc0-8c271875c3f2 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &3ec81b4f-3c9e-4f42-b5c7-034640f169ae name: "TRIGGER" short-name: "BOOKAUTHORS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &3c71a94e-7e28-42ac-b3be-688fa7e250f7 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &8447b9f2-69ca-4803-aa68-7441aa41d27c name: "UPDATE" short-name: "BOOKAUTHORS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"UPDATE\"" attributes: ! {} grants: ! - ! &933649d6-2269-4f84-8af4-f1f5a6b05b4f grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 referenced-objects: ! - *8d8ba623-288e-48bb-9a20-8d5fa413cde8 - *baddd0b2-08e1-42de-98d4-3b9464a0572c referenced-tables: ! - *8d8ba623-288e-48bb-9a20-8d5fa413cde8 - *baddd0b2-08e1-42de-98d4-3b9464a0572c remarks: "Relationship between books and their authors, \nalong with the latest\ \ updated information" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false table-constraints: ! - *b7693e20-d347-4d28-aea1-43b8b31ea006 - *4471bf2c-8c41-4403-b364-da676dfc547d - ! &c397f21d-afd3-4acd-a4c4-4c0cff5ba4ce 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: ! - *0a3ef741-d1f3-424f-b672-683c0b43d9fd deferrable: false definition: "BOOKS.BOOKAUTHORS.BOOKID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" - ! &6e025507-7dcf-4067-9d52-761e1538fc09 name: "SYS_CT_10120" short-name: "BOOKAUTHORS.SYS_CT_10120" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.SYS_CT_10120" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: ! - *02830c30-a2ac-4240-9486-11b401476555 deferrable: false definition: "BOOKS.BOOKAUTHORS.AUTHORID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! [] foreign-keys: ! - *b7693e20-d347-4d28-aea1-43b8b31ea006 hidden-columns: ! [] indexes: ! - ! &521b7b2a-3daa-44db-be0a-03bcb989b691 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: ! - *8b093e85-0060-40d5-94ad-491528f183b5 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: true - ! &1b97c6b3-a629-4bfa-8b3a-28557cd6668c 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: ! - *800a848d-c804-4d26-aa12-1c45560cb693 - *f647f9d4-6a43-4e74-92eb-2c0a255c94e7 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: false - ! &2595a833-0d54-4d23-9205-d84879af2005 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: ! - *20be8e93-1eb5-4321-bb85-02b92d76f31e - *a26d50ce-5e0e-4677-b928-06d270afb008 - *5688bd29-74bd-45a0-85ec-932a39f6f746 - *52f5648c-a92d-4e69-94c7-133546845eb4 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: false primary-key: *521b7b2a-3daa-44db-be0a-03bcb989b691 privileges: ! - ! &2ee38bb3-e5ee-4fc3-b5f1-25baa33ff7f0 name: "DELETE" short-name: "AUTHORS.\"DELETE\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"DELETE\"" attributes: ! {} grants: ! - ! &e4e3ef80-ec67-4fbd-abd8-c23b7e474cb1 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &462dce97-cbaf-4801-91a9-a7226d6534db name: "INSERT" short-name: "AUTHORS.\"INSERT\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"INSERT\"" attributes: ! {} grants: ! - ! &87acf3c1-19f3-4aa5-b7f7-7f543cc1186b grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &b4a52a29-b16d-4515-a8b6-34376db1651b name: "REFERENCES" short-name: "AUTHORS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &732d51dd-eecd-4514-8218-45d0d4240339 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &6a48b439-b6d3-4685-b78d-10a8dd2c714d name: "SELECT" short-name: "AUTHORS.\"SELECT\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"SELECT\"" attributes: ! {} grants: ! - ! &7a2d6be0-aae8-4b3f-8a2f-e45dca5094d6 grantable: false grantee: "OTHERUSER" grantor: "SA" - ! &3790e8a2-469e-402e-80aa-9dba3bd3c7fd grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &1cae64ee-0ca5-4c6b-b3de-0855b471878f name: "TRIGGER" short-name: "AUTHORS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &8c8c51b9-74ae-428f-8a03-636718ece79d grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &68748444-0559-497b-bc96-1ced162c8b6e name: "UPDATE" short-name: "AUTHORS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"UPDATE\"" attributes: ! {} grants: ! - ! &e3fea1e3-bf57-42b2-ab9b-272351d4fefb grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 referenced-objects: ! [] referenced-tables: ! [] remarks: "Contact details for book authors" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false table-constraints: ! - *521b7b2a-3daa-44db-be0a-03bcb989b691 - ! &559a7884-5f8a-44e8-a12e-a10977316cd5 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: ! - *a26d50ce-5e0e-4677-b928-06d270afb008 deferrable: false definition: "BOOKS.AUTHORS.STATE=UPPER(BOOKS.AUTHORS.STATE)" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" - ! &4b53434d-60e2-4ad0-8df3-68562d48531e 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: ! - *8b093e85-0060-40d5-94ad-491528f183b5 deferrable: false definition: "BOOKS.AUTHORS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" - ! &1666b992-1e07-459f-83a5-87946c448304 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: ! - *f647f9d4-6a43-4e74-92eb-2c0a255c94e7 deferrable: false definition: "BOOKS.AUTHORS.FIRSTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" - ! &257fe9ba-ddcb-434f-9b74-2121a8b0ed61 name: "SYS_CT_10107" short-name: "AUTHORS.SYS_CT_10107" full-name: "PUBLIC.BOOKS.AUTHORS.SYS_CT_10107" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: ! - *800a848d-c804-4d26-aa12-1c45560cb693 deferrable: false definition: "BOOKS.AUTHORS.LASTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! - ! &33981c6d-983a-48e9-b151-6e4d9e220558 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: *8a74f414-e10c-4b8e-a3a5-727594590127 type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! - *a840d743-96f2-47a5-9fee-fcab4b21c39a - ! &13c34dfd-9115-4887-929e-b026e9030efa name: "AUTHORSLIST" full-name: "PUBLIC.BOOKS.AUTHORSLIST" attributes: ! INSERTABLE_INTO: "YES" IS_TRIGGER_DELETABLE: "NO" IS_TRIGGER_INSERTABLE_INTO: "NO" IS_TRIGGER_UPDATABLE: "NO" READ_ONLY: false REMARKS: "" check-option: "none" columns: ! - *b1fdc7e9-925a-4be1-b306-500b7e42b560 - *94552b3f-4e4e-4df9-a29d-e1ac36ad057d - *df5c56ec-4ab5-4333-93c3-800400a5a7cd definition: "SELECT ID,FIRSTNAME,LASTNAME FROM BOOKS.AUTHORS" dependent-tables: ! [] foreign-keys: ! [] hidden-columns: ! [] indexes: ! [] primary-key: null privileges: ! - ! &316ca4b7-7a6a-4af4-b28a-0d09a7464652 name: "DELETE" short-name: "AUTHORSLIST.\"DELETE\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"DELETE\"" attributes: ! {} grants: ! - ! &81520540-a033-4868-bb79-cfea6ffd7c32 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &acd930c0-7822-4206-94a3-3ef1af6103fc name: "INSERT" short-name: "AUTHORSLIST.\"INSERT\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"INSERT\"" attributes: ! {} grants: ! - ! &14672507-9bb6-400c-bb50-01ed6539ffa2 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &9f2b0d02-acf8-4228-af86-91b786ac269a name: "REFERENCES" short-name: "AUTHORSLIST.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"REFERENCES\"" attributes: ! {} grants: ! - ! &057aa1f0-1c58-4d24-954b-02dc7c2e00c1 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &8921d4a6-d46f-4ee0-b231-0f90865a37e4 name: "SELECT" short-name: "AUTHORSLIST.\"SELECT\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"SELECT\"" attributes: ! {} grants: ! - ! &bdc3549e-ec80-4cc8-909d-f22405bda24d grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &def685ee-fc76-4afc-9ad4-815037a50db0 name: "TRIGGER" short-name: "AUTHORSLIST.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"TRIGGER\"" attributes: ! {} grants: ! - ! &64a5d166-3096-498b-b1c4-6bb07443bed1 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &4aaf3511-49d6-4dd7-963b-12f503b78b97 name: "UPDATE" short-name: "AUTHORSLIST.\"UPDATE\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"UPDATE\"" attributes: ! {} grants: ! - ! &b50d301b-4ddb-434a-b3cf-4eb18749a700 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 referenced-objects: ! - *8d8ba623-288e-48bb-9a20-8d5fa413cde8 referenced-tables: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false table-constraints: ! [] table-type: ! &77041b35-8768-4307-b78f-c815b77a2dba table-type: "VIEW" view: true table-usage: ! - *8d8ba623-288e-48bb-9a20-8d5fa413cde8 triggers: ! [] type: *77041b35-8768-4307-b78f-c815b77a2dba updatable: true used-by-objects: ! [] - *a840d743-96f2-47a5-9fee-fcab4b21c39a - *baddd0b2-08e1-42de-98d4-3b9464a0572c - ! &1ecb5041-b81a-4d03-908c-16336c12f2a3 name: "Celebrities" full-name: "PUBLIC.BOOKS.\"Celebrities\"" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *989f19ac-4497-43be-81a8-632ecd890468 - *2efb1d29-4d6d-45a3-849f-4aa65a2f5f20 definition: "" dependent-tables: ! - ! &e847103c-a8d7-4e1d-9f78-fd1a0c89d1a9 name: "Celebrity Updates" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\"" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *617e4c71-996a-43a3-9204-58697ab28042 - *1d353f9a-5e6c-47bf-8239-80878e6e398c definition: "" dependent-tables: ! [] foreign-keys: ! - ! &5580361d-4bec-4fa1-b795-1efbaf33da52 name: "SYS_FK_10131" short-name: "\"Celebrity Updates\".SYS_FK_10131" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".SYS_FK_10131" attributes: ! PK_NAME: "PK_Celebrities" TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" column-references: ! - ! &af02cf14-ba80-41fb-b314-1bb0327ef600 foreign-key-column: *617e4c71-996a-43a3-9204-58697ab28042 key-sequence: 1 primary-key-column: *989f19ac-4497-43be-81a8-632ecd890468 self-referencing: false constrained-columns: ! - *617e4c71-996a-43a3-9204-58697ab28042 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *e847103c-a8d7-4e1d-9f78-fd1a0c89d1a9 foreign-key-table: *e847103c-a8d7-4e1d-9f78-fd1a0c89d1a9 initially-deferred: false optional: false parent-partial: false primary-key-table: *1ecb5041-b81a-4d03-908c-16336c12f2a3 referenced-table: *1ecb5041-b81a-4d03-908c-16336c12f2a3 remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - ! &2499a85b-0942-4a83-8d4b-46017cf5f8ce 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: ! - *617e4c71-996a-43a3-9204-58697ab28042 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: true - *5580361d-4bec-4fa1-b795-1efbaf33da52 primary-key: *2499a85b-0942-4a83-8d4b-46017cf5f8ce privileges: ! - ! &6b7a94cd-a3e4-42af-b821-50905ce2db09 name: "DELETE" short-name: "\"Celebrity Updates\".\"DELETE\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"DELETE\"" attributes: ! {} grants: ! - ! &1748b895-5b4f-4f5e-a906-e1a9fa6d386a grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &5b342a92-ed38-4702-b996-6840a1c87380 name: "INSERT" short-name: "\"Celebrity Updates\".\"INSERT\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"INSERT\"" attributes: ! {} grants: ! - ! &683f987f-830f-4795-85f9-0722e16e6ac8 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &c10aef2e-9591-4a32-aae9-0d126db68521 name: "REFERENCES" short-name: "\"Celebrity Updates\".\"REFERENCES\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"REFERENCES\"" attributes: ! {} grants: ! - ! &7c437e14-a461-46c3-bf67-786f2efc1ff6 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &37ccdcb8-34c9-44a7-a523-31ed43f3f722 name: "SELECT" short-name: "\"Celebrity Updates\".\"SELECT\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"SELECT\"" attributes: ! {} grants: ! - ! &ea617771-c66a-4236-8a4a-540a0ed91e63 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &c05e715f-21a1-4ff7-8d4c-2c090ab20a29 name: "TRIGGER" short-name: "\"Celebrity Updates\".\"TRIGGER\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"TRIGGER\"" attributes: ! {} grants: ! - ! &2050f432-3c8d-440a-a1bb-c954c002a9a6 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - *1d353f9a-5e6c-47bf-8239-80878e6e398c referenced-objects: ! - *1ecb5041-b81a-4d03-908c-16336c12f2a3 referenced-tables: ! - *1ecb5041-b81a-4d03-908c-16336c12f2a3 remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false table-constraints: ! - *2499a85b-0942-4a83-8d4b-46017cf5f8ce - *5580361d-4bec-4fa1-b795-1efbaf33da52 - ! &e7e48cb1-d3ce-4448-aba1-b28685477179 name: "SYS_CT_10130" short-name: "\"Celebrity Updates\".SYS_CT_10130" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".SYS_CT_10130" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: ! - *617e4c71-996a-43a3-9204-58697ab28042 deferrable: false definition: "BOOKS.\"Celebrity Updates\".\"Celebrity Id\" IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! [] foreign-keys: ! - *5580361d-4bec-4fa1-b795-1efbaf33da52 hidden-columns: ! [] indexes: ! - ! &6c1dec45-84c5-4d85-b531-f183ff02fb38 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: ! - *989f19ac-4497-43be-81a8-632ecd890468 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: true primary-key: *6c1dec45-84c5-4d85-b531-f183ff02fb38 privileges: ! - ! &ee987c1b-2229-4325-a51d-2ba8a9a90003 name: "DELETE" short-name: "\"Celebrities\".\"DELETE\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"DELETE\"" attributes: ! {} grants: ! - ! &5b1d8760-d06b-4815-ab44-7c36d28e10e4 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &7569f17a-83fc-4f38-b0fe-a7240f7b1821 name: "INSERT" short-name: "\"Celebrities\".\"INSERT\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"INSERT\"" attributes: ! {} grants: ! - ! &2aa47cdc-0569-4f6f-b841-ef33a4c5b580 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &a6ef00d5-94cc-4ad9-a29e-223a8792925e name: "REFERENCES" short-name: "\"Celebrities\".\"REFERENCES\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"REFERENCES\"" attributes: ! {} grants: ! - ! &a1fa78b5-4c1b-4e92-b56b-50c310f113f4 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &d07149e2-4bcf-49d5-8593-a6a13d80e8c0 name: "SELECT" short-name: "\"Celebrities\".\"SELECT\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"SELECT\"" attributes: ! {} grants: ! - ! &0ef9a504-d4f9-43fb-b8b4-20ac9e647a85 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &df97e012-da40-4df1-973c-010feb58ee65 name: "TRIGGER" short-name: "\"Celebrities\".\"TRIGGER\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"TRIGGER\"" attributes: ! {} grants: ! - ! &eaf21d1c-c12d-420c-98ac-4f87d6b622c5 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &da098a0c-bdad-4df5-a443-17ef26652828 name: "UPDATE" short-name: "\"Celebrities\".\"UPDATE\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"UPDATE\"" attributes: ! {} grants: ! - ! &5bfc3d82-0a3c-463e-9d72-29e1c88f4725 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false table-constraints: ! - *6c1dec45-84c5-4d85-b531-f183ff02fb38 - ! &1885f11a-1d2b-4822-982f-ae7186ce6f77 name: "SYS_CT_10128" short-name: "\"Celebrities\".SYS_CT_10128" full-name: "PUBLIC.BOOKS.\"Celebrities\".SYS_CT_10128" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: ! - *989f19ac-4497-43be-81a8-632ecd890468 deferrable: false definition: "BOOKS.\"Celebrities\".\"Id\" IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! - *e847103c-a8d7-4e1d-9f78-fd1a0c89d1a9 - *e847103c-a8d7-4e1d-9f78-fd1a0c89d1a9 - ! &7605f4d6-4965-4bfc-a790-95bf5a78a4cc name: "COUPONS" full-name: "PUBLIC.BOOKS.COUPONS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *69d7adb5-7e33-4712-a569-adc18732adf8 - *fd521e01-ec48-462f-aee9-1d31afd73e0d - *55008e26-459b-4ae6-b3ba-40949e8e05da - *41d4bd7f-f73d-4cb1-9e4a-050f059adc4b definition: "" dependent-tables: ! [] foreign-keys: ! [] hidden-columns: ! [] indexes: ! - ! &6c352e8f-b47a-4c87-ad28-509774d44155 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: ! - *69d7adb5-7e33-4712-a569-adc18732adf8 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: true primary-key: *6c352e8f-b47a-4c87-ad28-509774d44155 privileges: ! - ! &a9df06d7-3871-4e42-a92b-7844deaf3bd4 name: "DELETE" short-name: "COUPONS.\"DELETE\"" full-name: "PUBLIC.BOOKS.COUPONS.\"DELETE\"" attributes: ! {} grants: ! - ! &2cf41f8f-6650-409e-974a-ff9f0a721e1b grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &b0c7a298-1512-4b86-a2d2-f4a0f7b94fb8 name: "INSERT" short-name: "COUPONS.\"INSERT\"" full-name: "PUBLIC.BOOKS.COUPONS.\"INSERT\"" attributes: ! {} grants: ! - ! &9187ccfb-b1ae-482a-be83-8eb1e8dbfaec grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &99f283f7-927d-4412-9cc3-0ad98b110c50 name: "REFERENCES" short-name: "COUPONS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.COUPONS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &55d93181-3d6c-48ab-9157-6e91e0eae305 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &2a62e271-29b3-4af6-a4a1-947c1794f37f name: "SELECT" short-name: "COUPONS.\"SELECT\"" full-name: "PUBLIC.BOOKS.COUPONS.\"SELECT\"" attributes: ! {} grants: ! - ! &7adb415e-57de-443e-9298-1e9f0e8a3ce1 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &bb2d087f-9db3-4b99-86aa-441802a3ef90 name: "TRIGGER" short-name: "COUPONS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.COUPONS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &ddd10394-c80c-4633-bb4e-a575c5c8bc87 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &792d77bf-3ce4-4cea-b091-870125516eed name: "UPDATE" short-name: "COUPONS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.COUPONS.\"UPDATE\"" attributes: ! {} grants: ! - ! &cdcf7760-a830-4e3a-a1b8-5b057ce32cba grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false table-constraints: ! - *6c352e8f-b47a-4c87-ad28-509774d44155 - ! &0504874a-b8f2-486b-82ad-eac847b0c263 name: "SYS_CT_10091" short-name: "COUPONS.SYS_CT_10091" full-name: "PUBLIC.BOOKS.COUPONS.SYS_CT_10091" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: ! - *69d7adb5-7e33-4712-a569-adc18732adf8 deferrable: false definition: "BOOKS.COUPONS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! [] - ! &85fad2ce-27b0-4c16-9045-717b8e836844 name: "CUSTOMERDATA" full-name: "PUBLIC.BOOKS.CUSTOMERDATA" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *75ccb53f-8b84-401c-80c4-671e864b0489 - *8c46d186-75aa-4605-b211-1b146b9980b0 - *627ac30f-ddb1-4978-8a8b-549eb7514ef3 definition: "" dependent-tables: ! [] foreign-keys: ! - ! &74073532-64d4-4f00-b1be-ad4301d71766 name: "FK_CUSTOMER" short-name: "CUSTOMERDATA.FK_CUSTOMER" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.FK_CUSTOMER" attributes: ! PK_NAME: "PK_CUSTOMERS" TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" column-references: ! - ! &5d50a7d6-243b-4d9a-a38c-283279948e66 foreign-key-column: *75ccb53f-8b84-401c-80c4-671e864b0489 key-sequence: 1 primary-key-column: *377e8a0c-f4b0-466a-abe1-313a3d43ff36 self-referencing: false constrained-columns: ! - *75ccb53f-8b84-401c-80c4-671e864b0489 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *85fad2ce-27b0-4c16-9045-717b8e836844 foreign-key-table: *85fad2ce-27b0-4c16-9045-717b8e836844 initially-deferred: false optional: false parent-partial: false primary-key-table: ! &c45047fa-9ec1-4e8a-ba06-c9ad2b886670 name: "CUSTOMERS" full-name: "PUBLIC.BOOKS.CUSTOMERS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *377e8a0c-f4b0-466a-abe1-313a3d43ff36 - *6b44dd62-60ef-4b9f-9cfb-be60c2b40ca8 - *f64509af-dfce-4f42-9a6c-e811f6e5cb0a - *c69404bb-ac9a-451e-85ae-5e80fe1d4d79 definition: "" dependent-tables: ! - *85fad2ce-27b0-4c16-9045-717b8e836844 foreign-keys: ! - *74073532-64d4-4f00-b1be-ad4301d71766 hidden-columns: ! [] indexes: ! - ! &7e803160-b516-4bf0-8f01-7313d91b9fe7 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: ! - *377e8a0c-f4b0-466a-abe1-313a3d43ff36 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: true primary-key: *7e803160-b516-4bf0-8f01-7313d91b9fe7 privileges: ! - ! &231efe36-f31c-46f8-bdff-1759de21b24e name: "DELETE" short-name: "CUSTOMERS.\"DELETE\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"DELETE\"" attributes: ! {} grants: ! - ! &0f087af9-f6dd-4f3a-8cf4-38ad4d0a4998 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &775a9bc7-e579-4c0f-bf68-0b07fb00d672 name: "INSERT" short-name: "CUSTOMERS.\"INSERT\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"INSERT\"" attributes: ! {} grants: ! - ! &580a39e8-b862-4c66-8e5c-c731c0e8d532 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &6636a482-2f0d-4a53-b7ff-b38886f85878 name: "REFERENCES" short-name: "CUSTOMERS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &70a165bc-4945-45f1-a196-1de70e9cc185 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &5795ef8f-47a8-4741-9459-152e87e63329 name: "SELECT" short-name: "CUSTOMERS.\"SELECT\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"SELECT\"" attributes: ! {} grants: ! - ! &9e7595a6-e69d-4c3a-9f8b-9713dad1f252 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &24d25f85-dd29-4e26-825c-bce7a5b58540 name: "TRIGGER" short-name: "CUSTOMERS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &81138f60-640e-4159-9683-c3b789f12884 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &842e9ede-e16a-4b5b-b1be-4836f7d505d4 name: "UPDATE" short-name: "CUSTOMERS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"UPDATE\"" attributes: ! {} grants: ! - ! &0c092064-8cad-4f39-8653-d8ce61b7224f grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false table-constraints: ! - *7e803160-b516-4bf0-8f01-7313d91b9fe7 - ! &99a8b236-2e6f-4200-a259-e93c746d2000 name: "SYS_CT_10093" short-name: "CUSTOMERS.SYS_CT_10093" full-name: "PUBLIC.BOOKS.CUSTOMERS.SYS_CT_10093" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: ! - *377e8a0c-f4b0-466a-abe1-313a3d43ff36 deferrable: false definition: "BOOKS.CUSTOMERS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" - ! &e5870f02-d68a-4029-9555-c5fcae891a34 name: "SYS_CT_10094" short-name: "CUSTOMERS.SYS_CT_10094" full-name: "PUBLIC.BOOKS.CUSTOMERS.SYS_CT_10094" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: ! - *6b44dd62-60ef-4b9f-9cfb-be60c2b40ca8 deferrable: false definition: "BOOKS.CUSTOMERS.FIRSTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" - ! &2e93a646-a9aa-40b9-9da1-13480b1e300c 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: ! - *f64509af-dfce-4f42-9a6c-e811f6e5cb0a deferrable: false definition: "BOOKS.CUSTOMERS.LASTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! - *85fad2ce-27b0-4c16-9045-717b8e836844 referenced-table: *c45047fa-9ec1-4e8a-ba06-c9ad2b886670 remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - *74073532-64d4-4f00-b1be-ad4301d71766 - ! &29711b05-5964-466d-858b-3bdf87f15221 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: ! - *75ccb53f-8b84-401c-80c4-671e864b0489 - *8c46d186-75aa-4605-b211-1b146b9980b0 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: true primary-key: *29711b05-5964-466d-858b-3bdf87f15221 privileges: ! - ! &3303cb12-268c-4f0f-8686-238a6d2836f9 name: "DELETE" short-name: "CUSTOMERDATA.\"DELETE\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"DELETE\"" attributes: ! {} grants: ! - ! &89fa9559-eaeb-4a1a-a096-0c1ac487b844 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &82ce2f71-81f3-461a-aefa-df527984e19a name: "INSERT" short-name: "CUSTOMERDATA.\"INSERT\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"INSERT\"" attributes: ! {} grants: ! - ! &cd8f2a39-ecd6-4417-9b4a-92e4a530763d grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &43f70027-b85c-47b1-9f66-51c5279aa549 name: "REFERENCES" short-name: "CUSTOMERDATA.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"REFERENCES\"" attributes: ! {} grants: ! - ! &3aba863c-bb85-412d-b0c0-ddf0cc2f0557 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &26568207-b254-42f3-9419-63f78faf401b name: "SELECT" short-name: "CUSTOMERDATA.\"SELECT\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"SELECT\"" attributes: ! {} grants: ! - ! &44bc54ba-a274-484f-b558-c4dc2de5ed1b grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &09b0763d-c7fb-4618-823b-004a53bda751 name: "TRIGGER" short-name: "CUSTOMERDATA.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"TRIGGER\"" attributes: ! {} grants: ! - ! &0bb6ac0c-2220-4a91-a0dc-0942b2885e99 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &77b1d8b3-209f-4c36-80b3-6b57fbc62d44 name: "UPDATE" short-name: "CUSTOMERDATA.\"UPDATE\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"UPDATE\"" attributes: ! {} grants: ! - ! &7071f88a-a7b3-4f41-829a-446a114e8389 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 referenced-objects: ! - *c45047fa-9ec1-4e8a-ba06-c9ad2b886670 referenced-tables: ! - *c45047fa-9ec1-4e8a-ba06-c9ad2b886670 remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false table-constraints: ! - *29711b05-5964-466d-858b-3bdf87f15221 - *74073532-64d4-4f00-b1be-ad4301d71766 - ! &990ffd97-fd5b-45be-908d-755fc3d0a60d name: "SYS_CT_10100" short-name: "CUSTOMERDATA.SYS_CT_10100" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.SYS_CT_10100" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: ! - *75ccb53f-8b84-401c-80c4-671e864b0489 deferrable: false definition: "BOOKS.CUSTOMERDATA.CUSTOMERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" - ! &87b07446-6a26-4b58-b937-0101f3cd4153 name: "SYS_CT_10101" short-name: "CUSTOMERDATA.SYS_CT_10101" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.SYS_CT_10101" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: ! - *8c46d186-75aa-4605-b211-1b146b9980b0 deferrable: false definition: "BOOKS.CUSTOMERDATA.DATAID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! [] - *c45047fa-9ec1-4e8a-ba06-c9ad2b886670 - ! &58962847-b930-4c1e-a4d7-230b7dfdfbde name: "PUBLISHERS" full-name: "PUBLIC.BOOKS.PUBLISHERS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "List of book publishers" columns: ! - *a3204aae-446a-4dd6-abc9-6f22e177443b - *8c03552f-5c58-4be1-ad7e-1a48812f5a8c definition: "" dependent-tables: ! - ! &4ab12146-f1ba-4971-9913-b98afbb2c6b3 name: "ΒΙΒΛΊΑ" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *93900315-4fda-4b25-8e12-034d9c2a6963 - *4566b948-958a-49e4-ad8e-d6fb03e3fc93 - *d686041b-bbd9-48cd-98e1-7021dd2e2e25 - *3b671b8f-87fd-4fcb-81ef-4d5fd4cddbad definition: "" dependent-tables: ! [] foreign-keys: ! - ! &319005d3-a158-4798-9376-be7619d58af9 name: "FK_ΒΙΒΛΊΑ_PUBLISHERS" short-name: "ΒΙΒΛΊΑ.FK_ΒΙΒΛΊΑ_PUBLISHERS" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.FK_ΒΙΒΛΊΑ_PUBLISHERS" attributes: ! PK_NAME: "SYS_PK_10127" TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" column-references: ! - ! &10ab080f-ff14-44f8-898b-9708224a6382 foreign-key-column: *3b671b8f-87fd-4fcb-81ef-4d5fd4cddbad key-sequence: 1 primary-key-column: *a3204aae-446a-4dd6-abc9-6f22e177443b self-referencing: false constrained-columns: ! - *3b671b8f-87fd-4fcb-81ef-4d5fd4cddbad deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *4ab12146-f1ba-4971-9913-b98afbb2c6b3 foreign-key-table: *4ab12146-f1ba-4971-9913-b98afbb2c6b3 initially-deferred: false optional: false parent-partial: false primary-key-table: *58962847-b930-4c1e-a4d7-230b7dfdfbde referenced-table: *58962847-b930-4c1e-a4d7-230b7dfdfbde remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - *319005d3-a158-4798-9376-be7619d58af9 - ! &91a031ee-7aa5-4164-b2d4-0434be3f63e8 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: ! - *93900315-4fda-4b25-8e12-034d9c2a6963 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: true primary-key: *91a031ee-7aa5-4164-b2d4-0434be3f63e8 privileges: ! - ! &ea2881d4-4e06-43b7-b9fb-aebb8c2cc27d name: "DELETE" short-name: "ΒΙΒΛΊΑ.\"DELETE\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"DELETE\"" attributes: ! {} grants: ! - ! &947a7a4a-d306-4870-858b-75b8839edc6e grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &c9fa4ba1-c4d5-452e-98f3-6dd1fa659977 name: "INSERT" short-name: "ΒΙΒΛΊΑ.\"INSERT\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"INSERT\"" attributes: ! {} grants: ! - ! &fc97ab00-a8fc-4c83-8307-76505d8d78c8 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &868584da-ab83-411a-89a5-485294d270f7 name: "REFERENCES" short-name: "ΒΙΒΛΊΑ.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"REFERENCES\"" attributes: ! {} grants: ! - ! &5abab3f1-f73c-4795-91e8-0866c5b2e86e grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &8938bf97-fc28-4c81-8fdb-4008177ea8a0 name: "SELECT" short-name: "ΒΙΒΛΊΑ.\"SELECT\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"SELECT\"" attributes: ! {} grants: ! - ! &a6884f3e-1a7f-4602-a20e-d98c6633841a grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &df548daf-9416-41d8-92ea-4961894e25ab name: "TRIGGER" short-name: "ΒΙΒΛΊΑ.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"TRIGGER\"" attributes: ! {} grants: ! - ! &3d6416ea-c642-4795-8e01-9683b1745cf7 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &51815144-b438-4270-b76d-c510ee90ada9 name: "UPDATE" short-name: "ΒΙΒΛΊΑ.\"UPDATE\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"UPDATE\"" attributes: ! {} grants: ! - ! &03dfd118-f162-4694-92b7-18c7df6b1452 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 referenced-objects: ! - *58962847-b930-4c1e-a4d7-230b7dfdfbde referenced-tables: ! - *58962847-b930-4c1e-a4d7-230b7dfdfbde remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false table-constraints: ! - *91a031ee-7aa5-4164-b2d4-0434be3f63e8 - *319005d3-a158-4798-9376-be7619d58af9 - ! &eb1da800-03e2-43e1-a10d-6df0b1265d12 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: ! - *93900315-4fda-4b25-8e12-034d9c2a6963 deferrable: false definition: "BOOKS.ΒΙΒΛΊΑ.ΜΟΝΑΔΙΚΌΣ IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" - ! &4169d84e-a3dc-4499-a524-b5b2d6e6d6ea 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: ! - *4566b948-958a-49e4-ad8e-d6fb03e3fc93 deferrable: false definition: "BOOKS.ΒΙΒΛΊΑ.ΤΊΤΛΟΣ IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" - ! &e453afce-4407-4f9b-9745-87030434ec15 name: "SYS_CT_10136" short-name: "ΒΙΒΛΊΑ.SYS_CT_10136" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.SYS_CT_10136" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "BOOKS" constrained-columns: ! - *3b671b8f-87fd-4fcb-81ef-4d5fd4cddbad deferrable: false definition: "BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! [] foreign-keys: ! - *319005d3-a158-4798-9376-be7619d58af9 hidden-columns: ! [] indexes: ! - ! &0fd63828-1936-4d0f-8d3e-70791dcf855d name: "SYS_PK_10127" short-name: "PUBLISHERS.SYS_PK_10127" full-name: "PUBLIC.BOOKS.PUBLISHERS.SYS_PK_10127" attributes: ! INDEX_QUALIFIER: "PUBLIC" TABLE_CAT: "PUBLIC" TABLE_NAME: "PUBLISHERS" TABLE_SCHEM: "BOOKS" cardinality: 0 columns: ! - *a3204aae-446a-4dd6-abc9-6f22e177443b definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 type: "other" unique: true primary-key: *0fd63828-1936-4d0f-8d3e-70791dcf855d privileges: ! - ! &ec1882be-fcf1-45f8-9204-fbba76664717 name: "DELETE" short-name: "PUBLISHERS.\"DELETE\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"DELETE\"" attributes: ! {} grants: ! - ! &614bc37a-cd95-4642-9e00-830405bbd697 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &d1f00db2-bc55-4e25-8ca7-9f9bcf6294de name: "INSERT" short-name: "PUBLISHERS.\"INSERT\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"INSERT\"" attributes: ! {} grants: ! - ! &a8c24e9a-bd7d-4b4a-b5c1-a0f9a15fc554 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &dc2e5691-46bb-47c1-8910-df84a8f8a01f name: "REFERENCES" short-name: "PUBLISHERS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &19690fff-db64-4d80-8125-627174eaccaa grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &00364d0c-b49f-4710-9c74-969f64fe8055 name: "SELECT" short-name: "PUBLISHERS.\"SELECT\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"SELECT\"" attributes: ! {} grants: ! - ! &042b404d-bc98-40b0-b830-e8d4d21bd2c9 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &3e0545ef-a948-46e7-8bc0-85d6c4edd9e5 name: "TRIGGER" short-name: "PUBLISHERS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &8cb20723-9ed8-48ad-b23a-83c071b7090b grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 - ! &e9b1274f-0fe1-41af-9fe5-0d1172be538d name: "UPDATE" short-name: "PUBLISHERS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"UPDATE\"" attributes: ! {} grants: ! - ! &b5ec0c0f-cfc1-4bec-9cb9-9cb0ca29814a grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 referenced-objects: ! [] referenced-tables: ! [] remarks: "List of book publishers" schema: *8a74f414-e10c-4b8e-a3a5-727594590127 self-referencing: false table-constraints: ! - *0fd63828-1936-4d0f-8d3e-70791dcf855d table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! - *4ab12146-f1ba-4971-9913-b98afbb2c6b3 - *4ab12146-f1ba-4971-9913-b98afbb2c6b3 - *13c34dfd-9115-4887-929e-b026e9030efa - ! &d4988923-711f-41df-9a2d-b1a86492da49 name: "EXTRA_PK" full-name: "PUBLIC.FOR_LINT.EXTRA_PK" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "Extra table with just a primary key" columns: ! - *3de8216d-a1d4-4c0b-8021-0c1fada9a386 - *9ba294ed-4d58-418d-9e38-1607117f2ba6 - *de483bfc-b00f-4fab-a4c3-bcb8b9504fa6 definition: "" dependent-tables: ! [] foreign-keys: ! - ! &47f441c2-a19a-481f-b4f9-2b68b00e653a 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: ! - ! &a7a6ddb3-764c-4db2-83f6-18a61cc4d163 foreign-key-column: *9ba294ed-4d58-418d-9e38-1607117f2ba6 key-sequence: 1 primary-key-column: *66c1eeb9-acc8-4848-9fb2-747e680395de self-referencing: false constrained-columns: ! - *9ba294ed-4d58-418d-9e38-1607117f2ba6 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *d4988923-711f-41df-9a2d-b1a86492da49 foreign-key-table: *d4988923-711f-41df-9a2d-b1a86492da49 initially-deferred: false optional: false parent-partial: false primary-key-table: ! &69205c21-91b9-41f6-a37a-592b9cfca29a name: "PUBLICATIONS" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *66c1eeb9-acc8-4848-9fb2-747e680395de - *f944517a-edfd-4de9-bcc8-ccc29adb5a0a - *e0f434c6-dd35-4e53-8662-e8f82f49deec - *4cf3802d-59a4-4a97-a10b-41a0d60f58fc - *0763781d-6f20-4c72-b643-2105e7910cd6 - *06a600cf-6bf0-4924-b26e-f9908b5e3a38 - *b7ea0aa1-5836-4886-854e-5e22b79a7cce - *7e1de9e9-8fbb-41bb-b2cd-eb7f8aca8080 definition: "" dependent-tables: ! - *d4988923-711f-41df-9a2d-b1a86492da49 - ! &be4773c0-72d0-428a-9b79-e0a82d9c9327 name: "PUBLICATIONWRITERS" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *a0a446a3-b9e7-4d3a-99fa-e5e21f6d6dee - *f9e114b0-45b7-4361-9b2a-2432d7b832d4 definition: "" dependent-tables: ! [] foreign-keys: ! - ! &dddfb3d6-4e04-4012-98d2-da300c7481a5 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: ! - ! &afb71f08-d9e5-42c2-ae34-db3ee7f9c5f4 foreign-key-column: *a0a446a3-b9e7-4d3a-99fa-e5e21f6d6dee key-sequence: 1 primary-key-column: *66c1eeb9-acc8-4848-9fb2-747e680395de self-referencing: false constrained-columns: ! - *a0a446a3-b9e7-4d3a-99fa-e5e21f6d6dee deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *be4773c0-72d0-428a-9b79-e0a82d9c9327 foreign-key-table: *be4773c0-72d0-428a-9b79-e0a82d9c9327 initially-deferred: false optional: false parent-partial: false primary-key-table: *69205c21-91b9-41f6-a37a-592b9cfca29a referenced-table: *69205c21-91b9-41f6-a37a-592b9cfca29a remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: false type: "foreign_key" update-rule: "no action" - ! &21e6838a-897f-4b95-95da-2464f3d7028c 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: ! - ! &4fbec64c-569b-41d9-9e9b-2ccf321eeed0 foreign-key-column: *f9e114b0-45b7-4361-9b2a-2432d7b832d4 key-sequence: 1 primary-key-column: *a855b555-9a21-4e48-8135-00eb0eff4ac3 self-referencing: false constrained-columns: ! - *f9e114b0-45b7-4361-9b2a-2432d7b832d4 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *be4773c0-72d0-428a-9b79-e0a82d9c9327 foreign-key-table: *be4773c0-72d0-428a-9b79-e0a82d9c9327 initially-deferred: false optional: false parent-partial: false primary-key-table: ! &61934777-d2b8-469a-9c02-a8a388555d3e name: "WRITERS" full-name: "PUBLIC.FOR_LINT.WRITERS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *a855b555-9a21-4e48-8135-00eb0eff4ac3 - *68736f2f-d5e0-45f4-871c-5aa603ba8db1 - *b97dc25c-57a7-4149-9811-d912e8b20ca1 - *f3eeab9c-8d49-4800-af4e-34a2d1d224a5 - *a6322280-9744-49a9-8030-468fdc245c31 - *62347d20-e806-4c85-9e53-76fd0b4124ce - *89119879-1815-4ea0-9de4-5746bb2dca95 - *aae2e5ac-09ba-4f32-b94d-fbba773efb55 - *57001323-a527-4e62-b83f-e20ba6fa1377 - *67d16515-141a-4f40-9892-90589419450c - *64149585-54ab-41ff-92da-e68c7982c0ed - *feb2338c-1763-48bf-bafb-d0c9b0272013 - *bbdd6b8d-22bb-49d4-a202-51aff02ab55d - *d518a1b0-74d8-46da-853d-9ffc19b73a66 - *0edb52b8-4d31-4d96-8854-9ce2f0abc96e - *f5942620-e9c0-43af-8fcc-7a6dcfe371ec - *60039c4f-8a66-4bce-997f-c531998e4581 - *6d0207ea-8b26-4c69-bef4-63e5eaa3356f definition: "" dependent-tables: ! - *d4988923-711f-41df-9a2d-b1a86492da49 - *69205c21-91b9-41f6-a37a-592b9cfca29a - *be4773c0-72d0-428a-9b79-e0a82d9c9327 foreign-keys: ! - ! &fb448eeb-c84f-4ab4-8a0f-4cefd1c6eb58 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: ! - ! &a2a5434a-f70e-481f-ad84-4a00d1210a4d foreign-key-column: *6d0207ea-8b26-4c69-bef4-63e5eaa3356f key-sequence: 1 primary-key-column: *66c1eeb9-acc8-4848-9fb2-747e680395de self-referencing: false constrained-columns: ! - *6d0207ea-8b26-4c69-bef4-63e5eaa3356f deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *61934777-d2b8-469a-9c02-a8a388555d3e foreign-key-table: *61934777-d2b8-469a-9c02-a8a388555d3e initially-deferred: false optional: false parent-partial: false primary-key-table: *69205c21-91b9-41f6-a37a-592b9cfca29a referenced-table: *69205c21-91b9-41f6-a37a-592b9cfca29a remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: false type: "foreign_key" update-rule: "no action" - ! &8012ab08-4642-4208-9089-f7d8c3dfb744 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: ! - ! &94b4f8c2-4bce-4d81-b48c-89e07978afcc foreign-key-column: *3de8216d-a1d4-4c0b-8021-0c1fada9a386 key-sequence: 1 primary-key-column: *a855b555-9a21-4e48-8135-00eb0eff4ac3 self-referencing: false constrained-columns: ! - *3de8216d-a1d4-4c0b-8021-0c1fada9a386 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *d4988923-711f-41df-9a2d-b1a86492da49 foreign-key-table: *d4988923-711f-41df-9a2d-b1a86492da49 initially-deferred: false optional: false parent-partial: false primary-key-table: *61934777-d2b8-469a-9c02-a8a388555d3e referenced-table: *61934777-d2b8-469a-9c02-a8a388555d3e remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: false type: "foreign_key" update-rule: "no action" - ! &7f2652b7-2df5-4626-995b-ebb1ab2a0321 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: ! - ! &d7bacc82-8bde-4e5a-ada1-c23a140bcfba foreign-key-column: *4cf3802d-59a4-4a97-a10b-41a0d60f58fc key-sequence: 1 primary-key-column: *a855b555-9a21-4e48-8135-00eb0eff4ac3 self-referencing: false constrained-columns: ! - *4cf3802d-59a4-4a97-a10b-41a0d60f58fc deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *69205c21-91b9-41f6-a37a-592b9cfca29a foreign-key-table: *69205c21-91b9-41f6-a37a-592b9cfca29a initially-deferred: false optional: false parent-partial: false primary-key-table: *61934777-d2b8-469a-9c02-a8a388555d3e referenced-table: *61934777-d2b8-469a-9c02-a8a388555d3e remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: false type: "foreign_key" update-rule: "no action" - *21e6838a-897f-4b95-95da-2464f3d7028c hidden-columns: ! [] indexes: ! - ! &9508b0ad-c58f-4249-84f9-1b9d2fea2ca0 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: ! - *a855b555-9a21-4e48-8135-00eb0eff4ac3 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "other" unique: true - *fb448eeb-c84f-4ab4-8a0f-4cefd1c6eb58 - ! &bdda2a74-5fcb-4468-a99c-166c8d57edfb 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: ! - *62347d20-e806-4c85-9e53-76fd0b4124ce - *89119879-1815-4ea0-9de4-5746bb2dca95 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "other" unique: false - ! &33ef63d6-c886-4452-b926-09555e4da264 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: ! - *feb2338c-1763-48bf-bafb-d0c9b0272013 - *57001323-a527-4e62-b83f-e20ba6fa1377 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "other" unique: true - ! &4681c8f7-5ea1-4cff-899b-f97446c4c995 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: ! - *b97dc25c-57a7-4149-9811-d912e8b20ca1 - *68736f2f-d5e0-45f4-871c-5aa603ba8db1 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "other" unique: false - ! &5736839f-6447-4db4-9e7c-d5699fe2daa0 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: ! - *62347d20-e806-4c85-9e53-76fd0b4124ce - *89119879-1815-4ea0-9de4-5746bb2dca95 - *aae2e5ac-09ba-4f32-b94d-fbba773efb55 - *57001323-a527-4e62-b83f-e20ba6fa1377 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "other" unique: false primary-key: *9508b0ad-c58f-4249-84f9-1b9d2fea2ca0 privileges: ! - ! &966271c3-bd4a-44ce-ac1d-fb188f3ff567 name: "DELETE" short-name: "WRITERS.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"DELETE\"" attributes: ! {} grants: ! - ! &88b47cf8-3515-40e4-9d2e-d8d9a186f209 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &f37759e9-c391-4b46-bcd3-db6fd7993f6c name: "INSERT" short-name: "WRITERS.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"INSERT\"" attributes: ! {} grants: ! - ! &88e1c96e-eab1-469b-bbe5-fc84bb20a590 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &0debc842-913b-488e-b884-6e4fd32012ed name: "REFERENCES" short-name: "WRITERS.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &8b20f18b-d781-44ee-ba9a-ef248df3631f grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &47e045d6-cdef-45f4-a329-1ccce1629aae name: "SELECT" short-name: "WRITERS.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"SELECT\"" attributes: ! {} grants: ! - ! &7513eaed-81f7-49e1-b7fa-9936f7e1fd38 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &d505e889-13a3-4d11-8f43-04f4d06360d9 name: "TRIGGER" short-name: "WRITERS.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &58f640ac-1bce-4b01-b004-069ae0b4bd44 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &4c70d631-d72f-4040-91ec-3ecb1b8fe08a name: "UPDATE" short-name: "WRITERS.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"UPDATE\"" attributes: ! {} grants: ! - ! &8a2a5079-0f45-4a98-a41d-5d36d5dd4727 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 referenced-objects: ! - *69205c21-91b9-41f6-a37a-592b9cfca29a referenced-tables: ! - *69205c21-91b9-41f6-a37a-592b9cfca29a remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: false table-constraints: ! - *9508b0ad-c58f-4249-84f9-1b9d2fea2ca0 - *fb448eeb-c84f-4ab4-8a0f-4cefd1c6eb58 - ! &9ee5cda5-f20c-4835-a2e9-17380db2ca94 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: ! - *89119879-1815-4ea0-9de4-5746bb2dca95 deferrable: false definition: "FOR_LINT.WRITERS.STATE=UPPER(FOR_LINT.WRITERS.STATE)" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" - ! &deb2203b-e5f9-4cbf-8788-fe3c975c2012 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: ! - *a855b555-9a21-4e48-8135-00eb0eff4ac3 deferrable: false definition: "FOR_LINT.WRITERS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" - ! &136ff334-6d2f-4a9f-bcc7-31f0770f88db 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: ! - *68736f2f-d5e0-45f4-871c-5aa603ba8db1 deferrable: false definition: "FOR_LINT.WRITERS.FIRSTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" - ! &fb2f8826-c7f3-4a11-baef-3011cd86a1bd name: "SYS_CT_10161" short-name: "WRITERS.SYS_CT_10161" full-name: "PUBLIC.FOR_LINT.WRITERS.SYS_CT_10161" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *b97dc25c-57a7-4149-9811-d912e8b20ca1 deferrable: false definition: "FOR_LINT.WRITERS.LASTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" - ! &a831f8a0-e458-41ec-a68a-ed65d6be8f5b name: "SYS_CT_10162" short-name: "WRITERS.SYS_CT_10162" full-name: "PUBLIC.FOR_LINT.WRITERS.SYS_CT_10162" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *a6322280-9744-49a9-8030-468fdc245c31 deferrable: false definition: "FOR_LINT.WRITERS.ADDRESS2 IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" - ! &83773696-b42b-49ff-96d5-77951f085937 name: "SYS_CT_10163" short-name: "WRITERS.SYS_CT_10163" full-name: "PUBLIC.FOR_LINT.WRITERS.SYS_CT_10163" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *6d0207ea-8b26-4c69-bef4-63e5eaa3356f deferrable: false definition: "FOR_LINT.WRITERS.PUBLICATION_ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! - *d4988923-711f-41df-9a2d-b1a86492da49 - *69205c21-91b9-41f6-a37a-592b9cfca29a - *be4773c0-72d0-428a-9b79-e0a82d9c9327 referenced-table: *61934777-d2b8-469a-9c02-a8a388555d3e remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - *21e6838a-897f-4b95-95da-2464f3d7028c - *dddfb3d6-4e04-4012-98d2-da300c7481a5 primary-key: null privileges: ! - ! &11cbb4c1-0050-45a2-877a-7dd795aeb9d9 name: "DELETE" short-name: "PUBLICATIONWRITERS.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"DELETE\"" attributes: ! {} grants: ! - ! &2aa6d917-507f-4b22-b4ec-d913a076e081 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &6f9dae36-db3e-4767-83eb-c722d849cdb7 name: "INSERT" short-name: "PUBLICATIONWRITERS.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"INSERT\"" attributes: ! {} grants: ! - ! &adc88650-aaea-4914-b2b7-db978f8bd01a grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &24ba0b14-5223-4d50-896a-9db75cdeda87 name: "REFERENCES" short-name: "PUBLICATIONWRITERS.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &1b5a4f94-c392-4313-bea0-c325d446a30f grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &3a7fbc89-2009-41b8-b252-9ca15df8d87b name: "SELECT" short-name: "PUBLICATIONWRITERS.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"SELECT\"" attributes: ! {} grants: ! - ! &a05d7292-5126-4c70-8c27-5295c1d68a38 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &f22837fe-a903-44e6-ba61-53d27f0aef7f name: "TRIGGER" short-name: "PUBLICATIONWRITERS.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &fcfc8f55-3394-4c29-8ebf-328f93741f9f grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &17211746-c427-46ed-bbca-eaa601031654 name: "UPDATE" short-name: "PUBLICATIONWRITERS.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"UPDATE\"" attributes: ! {} grants: ! - ! &ab623a5b-4b91-4f14-9e66-ec30a357310b grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 referenced-objects: ! - *69205c21-91b9-41f6-a37a-592b9cfca29a - *61934777-d2b8-469a-9c02-a8a388555d3e referenced-tables: ! - *69205c21-91b9-41f6-a37a-592b9cfca29a - *61934777-d2b8-469a-9c02-a8a388555d3e remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: false table-constraints: ! - *dddfb3d6-4e04-4012-98d2-da300c7481a5 - *21e6838a-897f-4b95-95da-2464f3d7028c - ! &c0e65fc6-854f-4e97-ab6d-39c9f809cd1c name: "SYS_CT_10177" short-name: "PUBLICATIONWRITERS.SYS_CT_10177" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.SYS_CT_10177" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *a0a446a3-b9e7-4d3a-99fa-e5e21f6d6dee deferrable: false definition: "FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" - ! &f402c810-ae1e-405b-8dec-5478be8486da name: "SYS_CT_10178" short-name: "PUBLICATIONWRITERS.SYS_CT_10178" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.SYS_CT_10178" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *f9e114b0-45b7-4361-9b2a-2432d7b832d4 deferrable: false definition: "FOR_LINT.PUBLICATIONWRITERS.WRITERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! [] - *61934777-d2b8-469a-9c02-a8a388555d3e foreign-keys: ! - *7f2652b7-2df5-4626-995b-ebb1ab2a0321 - *47f441c2-a19a-481f-b4f9-2b68b00e653a - *dddfb3d6-4e04-4012-98d2-da300c7481a5 - *fb448eeb-c84f-4ab4-8a0f-4cefd1c6eb58 hidden-columns: ! [] indexes: ! - *7f2652b7-2df5-4626-995b-ebb1ab2a0321 - ! &f50642f1-e054-489e-a6b1-e762e16b1553 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: ! - *66c1eeb9-acc8-4848-9fb2-747e680395de definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "other" unique: true primary-key: *f50642f1-e054-489e-a6b1-e762e16b1553 privileges: ! - ! &4012e464-39d5-45be-a24f-bb30d042732d name: "DELETE" short-name: "PUBLICATIONS.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"DELETE\"" attributes: ! {} grants: ! - ! &1c4d1277-239a-486e-93fa-6d623c0ab4c2 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &6dcb8928-3129-4dff-aca6-194b4c3a36d5 name: "INSERT" short-name: "PUBLICATIONS.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"INSERT\"" attributes: ! {} grants: ! - ! &6cf1ccfc-a67b-4f48-86b0-b6a81dd7165d grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &c68ef700-8345-42d4-a68d-3e3ebe576f59 name: "REFERENCES" short-name: "PUBLICATIONS.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &529a6329-7b99-4a85-8a92-1407097259a0 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &85bc530e-ac72-4023-ba1c-e58fca17d8c6 name: "SELECT" short-name: "PUBLICATIONS.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"SELECT\"" attributes: ! {} grants: ! - ! &c6d7a2a9-a476-412e-b0d6-721bfd4c5884 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &91918931-5d87-4c1c-bbfe-0e5260f64ada name: "TRIGGER" short-name: "PUBLICATIONS.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &44ec76bc-fc6b-435c-bdd2-bc942df3d1a6 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - *b7ea0aa1-5836-4886-854e-5e22b79a7cce referenced-objects: ! - *61934777-d2b8-469a-9c02-a8a388555d3e referenced-tables: ! - *61934777-d2b8-469a-9c02-a8a388555d3e remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: false table-constraints: ! - *f50642f1-e054-489e-a6b1-e762e16b1553 - *7f2652b7-2df5-4626-995b-ebb1ab2a0321 - ! &babe4863-3740-44a4-8af4-95d62d7c62cf name: "SYS_CT_10170" short-name: "PUBLICATIONS.SYS_CT_10170" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.SYS_CT_10170" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *66c1eeb9-acc8-4848-9fb2-747e680395de deferrable: false definition: "FOR_LINT.PUBLICATIONS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" - ! &7187a16f-c3cb-463f-af22-71b17e7f442e name: "SYS_CT_10171" short-name: "PUBLICATIONS.SYS_CT_10171" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.SYS_CT_10171" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *f944517a-edfd-4de9-bcc8-ccc29adb5a0a deferrable: false definition: "FOR_LINT.PUBLICATIONS.TITLE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" - ! &b0d349d8-c77d-498c-9d1d-20ed5727a3d3 name: "SYS_CT_10172" short-name: "PUBLICATIONS.SYS_CT_10172" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.SYS_CT_10172" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *4cf3802d-59a4-4a97-a10b-41a0d60f58fc deferrable: false definition: "FOR_LINT.PUBLICATIONS.WRITERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! - *d4988923-711f-41df-9a2d-b1a86492da49 - *be4773c0-72d0-428a-9b79-e0a82d9c9327 - *61934777-d2b8-469a-9c02-a8a388555d3e referenced-table: *69205c21-91b9-41f6-a37a-592b9cfca29a remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: false type: "foreign_key" update-rule: "no action" - *8012ab08-4642-4208-9089-f7d8c3dfb744 hidden-columns: ! [] indexes: ! - *8012ab08-4642-4208-9089-f7d8c3dfb744 - ! &7c61c898-a1d6-4421-9ef8-5896464aa011 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: ! - *de483bfc-b00f-4fab-a4c3-bcb8b9504fa6 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "other" unique: true - *47f441c2-a19a-481f-b4f9-2b68b00e653a primary-key: *7c61c898-a1d6-4421-9ef8-5896464aa011 privileges: ! - ! &a3c8c955-7d83-440b-8c58-fa03162628ca name: "DELETE" short-name: "EXTRA_PK.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"DELETE\"" attributes: ! {} grants: ! - ! &a74d3499-6387-4176-be67-a33bc377e336 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &72dfc5de-7fb0-4e21-92a4-e9c8ade7d3d5 name: "INSERT" short-name: "EXTRA_PK.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"INSERT\"" attributes: ! {} grants: ! - ! &7461cdd8-bcc2-4cb3-90c9-adf37d2a85e4 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &a46eb414-4254-4227-bf49-b9a2a5889841 name: "REFERENCES" short-name: "EXTRA_PK.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"REFERENCES\"" attributes: ! {} grants: ! - ! &e51a49ba-d54e-4e90-b144-7d5ed08b9f45 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &e99e352d-277d-4709-aa6f-6d374a2e0422 name: "SELECT" short-name: "EXTRA_PK.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"SELECT\"" attributes: ! {} grants: ! - ! &26f25861-15db-4416-8e2b-2d7290036d33 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &811254da-eb42-4530-b6f7-8f0c81ca47f5 name: "TRIGGER" short-name: "EXTRA_PK.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"TRIGGER\"" attributes: ! {} grants: ! - ! &ff3342ee-1d3b-4b8f-8722-ea2192ce6a3a grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &d8bafd64-b0d9-4441-9561-cad4df85e781 name: "UPDATE" short-name: "EXTRA_PK.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"UPDATE\"" attributes: ! {} grants: ! - ! &719dbcd2-e471-4b06-a5ba-813245db16bb grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 referenced-objects: ! - *69205c21-91b9-41f6-a37a-592b9cfca29a - *61934777-d2b8-469a-9c02-a8a388555d3e referenced-tables: ! - *69205c21-91b9-41f6-a37a-592b9cfca29a - *61934777-d2b8-469a-9c02-a8a388555d3e remarks: "Extra table with just a primary key" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: false table-constraints: ! - *7c61c898-a1d6-4421-9ef8-5896464aa011 - *47f441c2-a19a-481f-b4f9-2b68b00e653a - *8012ab08-4642-4208-9089-f7d8c3dfb744 - ! &f40816f5-598b-41b0-be40-502d9a744447 name: "SYS_CT_10185" short-name: "EXTRA_PK.SYS_CT_10185" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.SYS_CT_10185" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *3de8216d-a1d4-4c0b-8021-0c1fada9a386 deferrable: false definition: "FOR_LINT.EXTRA_PK.WRITERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" - ! &97c9e5a3-ec83-4c61-bbde-dac417cdaf24 name: "SYS_CT_10186" short-name: "EXTRA_PK.SYS_CT_10186" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.SYS_CT_10186" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *9ba294ed-4d58-418d-9e38-1607117f2ba6 deferrable: false definition: "FOR_LINT.EXTRA_PK.PUBLICATIONID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" - ! &ce5a1e9e-3497-4cd6-acf7-745062c709bb name: "SYS_CT_10187" short-name: "EXTRA_PK.SYS_CT_10187" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.SYS_CT_10187" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *de483bfc-b00f-4fab-a4c3-bcb8b9504fa6 deferrable: false definition: "FOR_LINT.EXTRA_PK.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! [] - ! &3709928e-3bba-469e-9a23-42f99f9c0e38 name: "Global Counts" full-name: "PUBLIC.FOR_LINT.\"Global Counts\"" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *bd863f3a-6c94-4bed-9813-e36410d4290b definition: "" dependent-tables: ! [] foreign-keys: ! [] hidden-columns: ! [] indexes: ! [] primary-key: null privileges: ! - ! &19ceeaff-b11e-483f-8a88-53ab1ffbf171 name: "DELETE" short-name: "\"Global Counts\".\"DELETE\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"DELETE\"" attributes: ! {} grants: ! - ! &c1a15a2a-aed1-4d2e-a735-3db67e14c8dd grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &44c2f24b-1197-4065-8685-db582c9008f6 name: "INSERT" short-name: "\"Global Counts\".\"INSERT\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"INSERT\"" attributes: ! {} grants: ! - ! &bd2879dc-a40e-46d8-87ad-8c4a12703681 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &f728891d-df08-473b-846e-908b283915af name: "REFERENCES" short-name: "\"Global Counts\".\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"REFERENCES\"" attributes: ! {} grants: ! - ! &93ff5e4b-8286-4a9d-93c1-7d9a5450fcf7 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &7320a749-5c25-4cb3-960b-499bf7a771b3 name: "SELECT" short-name: "\"Global Counts\".\"SELECT\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"SELECT\"" attributes: ! {} grants: ! - ! &b95e12b9-93c3-435c-888b-806a1079998c grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &ba72bb92-16b0-4b6e-ad37-73f9700ae7b9 name: "TRIGGER" short-name: "\"Global Counts\".\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"TRIGGER\"" attributes: ! {} grants: ! - ! &b04c3268-9e0e-4554-837d-54046d2a18ed grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &5336d95f-ca2f-4198-aaf6-7131a74bb38d name: "UPDATE" short-name: "\"Global Counts\".\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"UPDATE\"" attributes: ! {} grants: ! - ! &49a27e00-9763-45ca-9933-592b00f34724 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: false table-constraints: ! [] table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! [] - *69205c21-91b9-41f6-a37a-592b9cfca29a - *be4773c0-72d0-428a-9b79-e0a82d9c9327 - ! &e6e39243-40d2-464b-ae21-58e2cd1932e3 name: "SELFREFERENCE" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *f3a707ef-9343-42b2-ab63-deef4b31ae7d - *13cfd632-59d0-4334-913d-84e49ea355b2 definition: "" dependent-tables: ! - *e6e39243-40d2-464b-ae21-58e2cd1932e3 foreign-keys: ! - ! &c42c40bc-39c9-4812-8d0e-1ed127e2b5bd 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: ! - ! &c9e0f710-c1f4-463b-a359-9fefbe3da498 foreign-key-column: *f3a707ef-9343-42b2-ab63-deef4b31ae7d key-sequence: 1 primary-key-column: *f3a707ef-9343-42b2-ab63-deef4b31ae7d self-referencing: true constrained-columns: ! - *f3a707ef-9343-42b2-ab63-deef4b31ae7d deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *e6e39243-40d2-464b-ae21-58e2cd1932e3 foreign-key-table: *e6e39243-40d2-464b-ae21-58e2cd1932e3 initially-deferred: false optional: false parent-partial: false primary-key-table: *e6e39243-40d2-464b-ae21-58e2cd1932e3 referenced-table: *e6e39243-40d2-464b-ae21-58e2cd1932e3 remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: true type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - ! &48e732f4-10f1-4364-bd90-9c9fc5a3b537 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: ! - *f3a707ef-9343-42b2-ab63-deef4b31ae7d definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "other" unique: true - *c42c40bc-39c9-4812-8d0e-1ed127e2b5bd primary-key: *48e732f4-10f1-4364-bd90-9c9fc5a3b537 privileges: ! - ! &78cd63bf-7d5a-41f7-9de7-be78fe001dc1 name: "DELETE" short-name: "SELFREFERENCE.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"DELETE\"" attributes: ! {} grants: ! - ! &42abab5a-425a-4a44-9c4b-291d5a311a6d grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &60c3d131-fc7e-4d69-8a1e-1d8953cd451c name: "INSERT" short-name: "SELFREFERENCE.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"INSERT\"" attributes: ! {} grants: ! - ! &e5868041-7ac1-43bb-bc97-ce5f3c1e1fba grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &cf6201c0-338a-417b-bcfe-3e938885bc71 name: "REFERENCES" short-name: "SELFREFERENCE.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"REFERENCES\"" attributes: ! {} grants: ! - ! &3ca92b8d-551b-467a-aed3-eae27d503218 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &72cc5c26-9d46-488e-a40b-0265a7705904 name: "SELECT" short-name: "SELFREFERENCE.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"SELECT\"" attributes: ! {} grants: ! - ! &e5d807f2-add6-4f52-99f3-75ad98dc2e2d grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &feb2d97e-f9b8-457d-92da-e7ae9a414778 name: "TRIGGER" short-name: "SELFREFERENCE.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"TRIGGER\"" attributes: ! {} grants: ! - ! &e9eb4458-9c0c-44f0-85c2-583f2ccb1d6b grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 - ! &737dedc9-6766-49ed-8693-56770140a5d8 name: "UPDATE" short-name: "SELFREFERENCE.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"UPDATE\"" attributes: ! {} grants: ! - ! &4b59f463-fef4-42b2-9610-7d5aeb839e6e grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 referenced-objects: ! - *e6e39243-40d2-464b-ae21-58e2cd1932e3 referenced-tables: ! - *e6e39243-40d2-464b-ae21-58e2cd1932e3 remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 self-referencing: true table-constraints: ! - *48e732f4-10f1-4364-bd90-9c9fc5a3b537 - *c42c40bc-39c9-4812-8d0e-1ed127e2b5bd - ! &e7e752f5-9853-403d-8600-188a23308803 name: "SYS_CT_10193" short-name: "SELFREFERENCE.SYS_CT_10193" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.SYS_CT_10193" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *f3a707ef-9343-42b2-ab63-deef4b31ae7d deferrable: false definition: "FOR_LINT.SELFREFERENCE.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" - ! &babccb9c-d942-4951-ba7f-05990fe9c57d name: "SYS_CT_10194" short-name: "SELFREFERENCE.SYS_CT_10194" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.SYS_CT_10194" attributes: ! TABLE_CATALOG: "PUBLIC" TABLE_SCHEMA: "FOR_LINT" constrained-columns: ! - *13cfd632-59d0-4334-913d-84e49ea355b2 deferrable: false definition: "FOR_LINT.SELFREFERENCE.TITLE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *12de9804-bcf2-41ee-a408-5ffdec4fd8f9 type: "check" table-type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed triggers: ! [] type: *79c9c3d1-4e90-4780-bbbf-ddf2319160ed used-by-objects: ! - *e6e39243-40d2-464b-ae21-58e2cd1932e3 - *61934777-d2b8-469a-9c02-a8a388555d3e - *a92fc35e-a065-4a61-92e2-ae8679c57ed4 - *e5d82cd0-d802-46e6-81bd-6d68ae3f577b - *2da18d85-6e7b-4e86-9aa5-bece2fc12115