--- ! &12771cef-2fd8-4350-86bc-04ceef8f2b90 all-table-columns: ! - ! &04292f60-7dd1-49e1-b51c-20c725e1d611 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: ! &1566f261-a200-4946-971d-4e1b3751f90f 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: ! &5dd500ab-de86-48d0-a727-cd625ea73e2b 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: ! &a3384295-70e8-4c7e-b8ec-142860c04a42 name: null full-name: "" catalog-name: null attributes: ! {} remarks: "" searchable: "searchable except with where .. like" standard-type-name: "INTEGER" type: "system" type-mapped-class: "java.lang.Integer" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: ! &4dfa5652-c2a4-4439-9cf5-c416083ebb78 name: "BOOKS" full-name: "PUBLIC.BOOKS" catalog-name: "PUBLIC" attributes: ! {} remarks: "" significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &94da9ce8-36e9-4534-8ae1-7ddbc6bbdbcf 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &15dcd557-c80f-44cb-b781-09dc0738c0b8 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &eade6771-e115-4ee7-b6f5-07269e9a468a 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &5376fded-cd28-4905-9ae9-4287edb3f84f 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &a3ccce28-3187-4414-9b70-dc0e4105300b 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &ba5f22c0-932b-4f8f-865f-06d8522ae136 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &5a096929-5fe6-4a3a-8a63-240d3be43a93 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &49fdca56-2b73-4994-8b83-eb55b86257c1 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &8595e15a-42f9-41fc-8f82-e936545b3607 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &c2f6d73f-9b1c-4d68-ba2e-2bc5737729a4 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: ! &64e12be2-fdbe-48b0-8abc-e0710386e489 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: ! &f7367c8e-887a-4343-9d45-8ed65ef1dc69 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "SMALLINT" type: "system" type-mapped-class: "java.lang.Integer" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: true part-of-self-referencing-relationship: false part-of-unique-index: true privileges: ! [] remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 16 type: *64e12be2-fdbe-48b0-8abc-e0710386e489 width: "" - ! &c5952316-ee67-4a85-834f-a9d66e5c99dc 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: ! &90985d02-0d8b-4ef9-a63e-b5dc40b4aecc 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: ! &72242094-dfbe-4c8c-8469-cc10e9a10136 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "BIGINT" type: "system" type-mapped-class: "java.lang.Long" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: true part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: ! &91410f91-9c9c-4de8-a841-ef760f03e8df name: "FOR_LINT" full-name: "PUBLIC.FOR_LINT" catalog-name: "PUBLIC" attributes: ! {} remarks: "" significant: true size: 64 type: *90985d02-0d8b-4ef9-a63e-b5dc40b4aecc width: "" - ! &94ddadaa-3105-4029-8010-0cf7435ba1e9 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: *90985d02-0d8b-4ef9-a63e-b5dc40b4aecc 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 64 type: *90985d02-0d8b-4ef9-a63e-b5dc40b4aecc width: "" - ! &0138b7d5-1448-4008-b94b-74c4e7695e6c 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &0e04c0c3-77ce-447e-bda5-df6b85609f3e 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &b74fdee1-c7c2-4ef7-8b8d-8678852f7258 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &412f830d-b3da-4dd7-be00-203e0ef01c7c 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &d856d334-5c5c-4ca3-940c-d1ce163f6a71 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: ! &e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 name: "PUBLISHER SALES" full-name: "PUBLIC.\"PUBLISHER SALES\"" catalog-name: "PUBLIC" attributes: ! {} remarks: "" significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &66e04c97-f3fa-4414-9f69-190df243686d 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: ! &f6ebf903-606c-48ce-8206-691740d55590 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: ! &bda254f2-e127-4fe3-b7a9-eaa7bcf5d285 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable" standard-type-name: "VARCHAR" type: "system" type-mapped-class: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: false ordinal-position: 1 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: false size: 50 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(50)" - ! &3be56c06-b3d9-45e0-915d-8516972c8c5b 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: true size: 10 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(10)" - ! &84b92f41-3a86-4f1f-86c6-c2f2c1d82f66 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: ! &95d8ef3d-a3b0-44a4-bdb4-5a31d4ce9029 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: ! &5ba7e0c8-deaa-4cea-9945-7a197c4e1353 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "not searchable" standard-type-name: "CLOB" type: "system" type-mapped-class: "java.sql.Clob" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: true ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 1073741824 type: *95d8ef3d-a3b0-44a4-bdb4-5a31d4ce9029 width: "" - ! &95a5c8a0-7378-4b2d-9df8-edd306553993 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &3f80eb2b-0c4d-47c0-b835-f2c9a14e3432 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &287d23d9-b702-4b9f-82ee-60142464c6f6 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 20 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(20)" - ! &550a9e00-256a-418f-a526-0b2d2aab1c25 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 20 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(20)" - ! &c0e31539-21cb-462b-baef-c95775140d78 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &5cf79e9c-aed1-40cd-8c96-c911f38dbb6e 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 20 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(20)" - ! &e9bfc8b1-16f9-4d1e-948e-d9ff2e05dea8 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 20 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(20)" - ! &b3615882-1938-4b78-b41d-febdcbe2be17 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &b1e1671d-b253-452e-8ff5-5a35450f71f3 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &0400e4ec-546d-48e6-907f-d0e7d0a63f6f 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: ! &de28af05-824e-46d9-852c-3834076eedf2 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: ! &7f573672-e1f1-442d-a142-d11153f8f820 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 searchable: "not searchable" standard-type-name: "DISTINCT" type: "user_defined" type-mapped-class: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: false ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 100 type: *de28af05-824e-46d9-852c-3834076eedf2 width: "" - ! &de9248eb-3610-47ed-af27-c642ca0df1f7 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: *90985d02-0d8b-4ef9-a63e-b5dc40b4aecc 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 64 type: *90985d02-0d8b-4ef9-a63e-b5dc40b4aecc width: "" - ! &6c5d5812-157e-461a-b515-5b66d39f8019 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &25ea0ac5-9509-4108-9155-4badc4577523 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &7ca83ff9-1bb6-4a04-bda5-c3b185043ef7 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &2c489647-cfc7-442a-8d49-6b54cf94127d 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 20 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(20)" - ! &e092db10-5d9d-41ce-98d8-a2091222406f 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: ! &a95c293a-f316-4965-a338-c7590c73a2a9 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: ! &e67ec2b3-0281-4b29-b61a-6d8a9db6c85a 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "DOUBLE" type: "system" type-mapped-class: "java.lang.Double" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: true ordinal-position: 2 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: false size: 64 type: *a95c293a-f316-4965-a338-c7590c73a2a9 width: "(64, 0)" - ! &7180959e-b634-4462-82d5-1157540d2eec 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: false size: 2 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(2)" - ! &0151cb51-51f5-45b2-a81f-38e82a40551f 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: true size: 50 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(50)" - ! &c792e591-8a24-42f5-b897-f8c7e37ce091 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 20 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(20)" - ! &a5f4d19b-f63e-4461-8877-59aa2da46ea0 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 20 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(20)" - ! &f5f723aa-99f8-4be9-b71d-3a37a0711dd9 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 30 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(30)" - ! &1e085766-b418-4283-a3c7-e1821c025922 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &5b0dbc61-7efe-4ab0-8fee-02760d9c2f84 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &9c371697-9980-456e-ab0f-ffd89b68a881 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: ! &bddc6442-c5d5-4cce-ad6f-71fe4ec38e46 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: ! &d498e94c-0eb9-4d87-ab4d-629e033f7ed9 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 searchable: "not searchable" standard-type-name: "ARRAY" type: "user_defined" type-mapped-class: "java.sql.Array" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: "ARRAY[]" generated: false hidden: false nullable: true ordinal-position: 3 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 0 type: *bddc6442-c5d5-4cce-ad6f-71fe4ec38e46 width: "" - ! &405c3b43-3651-420e-9dad-56a1fdea44eb 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: *de28af05-824e-46d9-852c-3834076eedf2 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 100 type: *de28af05-824e-46d9-852c-3834076eedf2 width: "" - ! &28c14388-459d-45aa-b7f6-48dd964deea8 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: ! &960a27aa-cbb2-4657-a2d2-25a76f82ac32 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: *bda254f2-e127-4fe3-b7a9-eaa7bcf5d285 literal-prefix: "" literal-suffix: "" local-type-name: "" maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 searchable: "not searchable" standard-type-name: "VARCHAR" type: "user_defined" type-mapped-class: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: true ordinal-position: 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 20 type: *960a27aa-cbb2-4657-a2d2-25a76f82ac32 width: "(20)" - ! &87457046-ddae-4ef0-b2f0-87dc8f70ac6f 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &8c2f81ee-391d-4165-b1ad-2f39a57c1d10 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &94b9e514-1795-4ae3-bc67-100f5f2e3b29 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 20 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(20)" - ! &7ed369e3-a2eb-4011-96a3-aca38e3281b2 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &0217c58f-ae21-4045-98d7-805b7e950e6b 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: true size: 10 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(10)" - ! &8bccabcb-1378-4081-9b41-7dcc12b2c701 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &705b89ea-4421-4e5e-9e46-dd6dcf87d2a3 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: *64e12be2-fdbe-48b0-8abc-e0710386e489 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 16 type: *64e12be2-fdbe-48b0-8abc-e0710386e489 width: "" - ! &dfcbec47-7158-484c-831b-7f68060ad3e0 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &f6af1b9d-7a74-4438-b233-fc9a4eb1658f 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: ! &846536e1-f76a-4ac2-a9f7-d1117d16733b name: "AGE_TYPE" full-name: "PUBLIC.BOOKS.AGE_TYPE" attributes: ! REMARKS: "" TYPE_CAT: "PUBLIC" TYPE_SCHEM: "BOOKS" auto-incrementable: false base-type: *64e12be2-fdbe-48b0-8abc-e0710386e489 case-sensitive: false create-parameters: "" database-specific-type-name: "AGE_TYPE" enum-values: ! [] enumerated: false fixed-precision-scale: false java-sql-type: *7f573672-e1f1-442d-a142-d11153f8f820 literal-prefix: "" literal-suffix: "" local-type-name: "" maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 searchable: "not searchable" standard-type-name: "DISTINCT" type: "user_defined" type-mapped-class: "java.lang.Integer" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: true ordinal-position: 4 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 16 type: *846536e1-f76a-4ac2-a9f7-d1117d16733b width: "" - ! &8bfab531-fd71-46b1-ba0c-9a60e8740b27 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: ! &7c99552d-e8ad-4f6b-aa72-342ec600cae3 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: *d498e94c-0eb9-4d87-ab4d-629e033f7ed9 literal-prefix: "" literal-suffix: "" local-type-name: "" maximum-scale: 0 minimum-scale: 0 nullable: false num-precision-radix: 0 precision: 0 remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 searchable: "not searchable" standard-type-name: "ARRAY" type: "user_defined" type-mapped-class: "java.sql.Array" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: true ordinal-position: 4 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 0 type: *7c99552d-e8ad-4f6b-aa72-342ec600cae3 width: "" - ! &8341945a-acbc-4fac-aa59-17773bd485f6 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: *90985d02-0d8b-4ef9-a63e-b5dc40b4aecc 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 64 type: *90985d02-0d8b-4ef9-a63e-b5dc40b4aecc width: "" - ! &93e5525e-26a5-4f2d-b0f7-a7868ebd127d 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &7d29a3ed-6858-4896-af35-249b8f364f59 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: false size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &5a95b875-ea8c-4b4d-bbfa-533ecbdc6e91 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: true size: 50 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(50)" - ! &c9bf902d-215c-471c-b601-27547d863b0d 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: ! &0c97f799-9d70-4bd3-85b1-f31d8e84295e 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: ! &acd0f8e3-fa9a-4a46-81d7-67ff6ae792db 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "DATE" type: "system" type-mapped-class: "java.sql.Date" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: true ordinal-position: 5 parent-partial: false part-of-foreign-key: false part-of-index: false part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "Book publication date" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 10 type: *0c97f799-9d70-4bd3-85b1-f31d8e84295e width: "" - ! &3e04edc6-df72-47c2-af2b-337fb376498d 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &aecb5a8f-abbb-498d-915d-d7d58829bda6 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: *0c97f799-9d70-4bd3-85b1-f31d8e84295e 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 10 type: *0c97f799-9d70-4bd3-85b1-f31d8e84295e width: "" - ! &80f7d1eb-1ef3-47ac-b4ce-7c96264ac23f 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 255 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(255)" - ! &b0ee3b08-2398-47f5-96af-e38fe559903f 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: *0c97f799-9d70-4bd3-85b1-f31d8e84295e 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: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: false size: 10 type: *0c97f799-9d70-4bd3-85b1-f31d8e84295e width: "" - ! &0272d0c3-600c-4430-a0d8-a781e98562e7 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: *a95c293a-f316-4965-a338-c7590c73a2a9 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: false size: 64 type: *a95c293a-f316-4965-a338-c7590c73a2a9 width: "(64, 0)" - ! &3660ea0d-3e12-469b-822c-aae9069139ea 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 50 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(50)" - ! &c734e1cd-6f88-49a5-89f5-b11d19711f8b 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: *a95c293a-f316-4965-a338-c7590c73a2a9 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 64 type: *a95c293a-f316-4965-a338-c7590c73a2a9 width: "(64, 0)" - ! &801f40b6-a05a-4d60-9367-ef4b90b8f880 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 50 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(50)" - ! &c9dd5ee1-3831-45b4-99af-d7641ca145fc 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: *a95c293a-f316-4965-a338-c7590c73a2a9 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: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: false size: 64 type: *a95c293a-f316-4965-a338-c7590c73a2a9 width: "(64, 0)" - ! &b152a3e5-42ee-4692-9cea-1aae3cc44f12 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: ! &746cc609-a01d-48df-87f6-2b3a0d493253 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: ! &0277501e-2ba2-42ee-a59c-fdbf9f61150e 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable" standard-type-name: "CHAR" type: "system" type-mapped-class: "java.lang.String" unsigned: false column-data-type-known: true decimal-digits: 0 default-value: null generated: false hidden: false nullable: true ordinal-position: 7 parent-partial: false part-of-foreign-key: false part-of-index: true part-of-primary-key: false part-of-self-referencing-relationship: false part-of-unique-index: false privileges: ! [] remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 2 type: *746cc609-a01d-48df-87f6-2b3a0d493253 width: "(2)" - ! &2a0fa3b2-246f-4334-a022-2348e8f9559e 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &fafc1275-33be-4d4f-aa07-814705f42eea 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: *95d8ef3d-a3b0-44a4-bdb4-5a31d4ce9029 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 1073741824 type: *95d8ef3d-a3b0-44a4-bdb4-5a31d4ce9029 width: "" - ! &af5dd347-c490-43ad-a664-65f3b5e441e1 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 2 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(2)" - ! &1295bc8d-2d25-4b76-9a9a-99d59ed7094a 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 significant: true size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &72f0d1d2-6282-4367-ac1f-c64d49b6842d 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 10 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(10)" - ! &dc4f4f24-37d5-4f48-9f38-bfe7d0dd9f9e 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: *95d8ef3d-a3b0-44a4-bdb4-5a31d4ce9029 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 1073741824 type: *95d8ef3d-a3b0-44a4-bdb4-5a31d4ce9029 width: "" - ! &9edfade4-8a9a-4bf4-b4bc-01ff05131269 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 10 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(10)" - ! &43858715-51d4-4897-b0da-3d47c39cc535 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 significant: true size: 50 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(50)" - ! &29402224-b724-4cec-993b-1d8040c57b7f 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 50 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(50)" - ! &e69cb4d3-95d9-4b90-8edf-cf9bd44e9a45 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 10 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(10)" - ! &27659ce6-69f2-4ad0-864a-30cb98aff5b1 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 15 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(15)" - ! &6862bdfa-d94c-4bcd-98fd-439965fdc72a 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 10 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(10)" - ! &93bd9eed-7963-47ef-9007-e485eb634368 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &05e50c15-e2b0-4b0b-a1f3-74c2f1ae314b 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 10 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(10)" - ! &79070f5f-e5ad-4e22-add2-c13bc8cda5ba 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: *1566f261-a200-4946-971d-4e1b3751f90f 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 32 type: *1566f261-a200-4946-971d-4e1b3751f90f width: "" - ! &0f581389-123f-4916-ae24-8f7183d1145f 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 10 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(10)" - ! &2677bddc-8060-48b3-8b4a-51dd838fbb03 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: *f6ebf903-606c-48ce-8206-691740d55590 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: false size: 10 type: *f6ebf903-606c-48ce-8206-691740d55590 width: "(10)" - ! &1674f6ad-df76-4c0d-bf0a-94866ae2f3e4 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: *90985d02-0d8b-4ef9-a63e-b5dc40b4aecc 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: *91410f91-9c9c-4de8-a841-ef760f03e8df significant: true size: 64 type: *90985d02-0d8b-4ef9-a63e-b5dc40b4aecc width: "" catalog: ! &3f1a8fb1-74f9-4376-a328-6f858352792f name: "catalog" full-name: "catalog" crawl-info: ! &de67bfcc-0577-4a81-bd2e-5fa6e66714d8 crawl-timestamp: "2026-04-12 19:03:17" crawl-timestamp-instant: "2026-04-12T19:03:17.936133395Z" database-version: ! &fb43f48c-cc70-404d-b50b-8a100ee89737 name: "HSQL Database Engine" description: "" product-name: "HSQL Database Engine" product-version: "2.7.4" value: "2.7.4" jdbc-driver-version: ! &0957f38e-c8b6-4743-b8e8-3d07a06a5668 name: "HSQL Database Engine Driver" description: "" product-name: "HSQL Database Engine Driver" product-version: "2.7.4" value: "2.7.4" jvm-version: ! &f22f4559-73f7-4154-b3eb-4dee972e3990 name: "Eclipse Adoptium OpenJDK 64-Bit\ \ Server VM" description: "" product-name: "Eclipse Adoptium OpenJDK 64-Bit Server VM" product-version: "17.0.18+8" value: "17.0.18+8" operating-system-version: ! &5dc24c3b-f2a7-4aab-82cd-6b4f53795dd1 name: "Linux" description: "" product-name: "Linux" product-version: "6.17.0-1010-azure" value: "6.17.0-1010-azure" run-id: "94593939-71b3-4862-9cb9-ef4f66689b14" schema-crawler-version: ! &8447bf0f-cf5e-43ee-b5ae-a976b691dc58 name: "SchemaCrawler" description: "" product-name: "SchemaCrawler" product-version: "17.10.1" value: "17.10.1" database-info: *fb43f48c-cc70-404d-b50b-8a100ee89737 jdbc-driver-info: *0957f38e-c8b6-4743-b8e8-3d07a06a5668 schemas: ! - *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &bbe93d37-7d6f-4a67-961e-826fbfd41c6a name: "INFORMATION_SCHEMA" full-name: "PUBLIC.INFORMATION_SCHEMA" catalog-name: "PUBLIC" attributes: ! {} remarks: "" - ! &d17674d8-1265-4c0e-bb7e-2cfc60b5fdc8 name: "PUBLIC" full-name: "PUBLIC.PUBLIC" catalog-name: "PUBLIC" attributes: ! {} remarks: "" - *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &0f23b245-99c5-4696-b834-2eb0b9294709 name: "SYSTEM_LOBS" full-name: "PUBLIC.SYSTEM_LOBS" catalog-name: "PUBLIC" attributes: ! {} remarks: "" system-column-data-types: ! - *90985d02-0d8b-4ef9-a63e-b5dc40b4aecc - ! &7c47dd9d-2764-4855-8cb9-a2f4bcaf556a 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: ! &006dc845-1773-40ea-a231-747644186b5e 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable" standard-type-name: "BINARY" type: "system" type-mapped-class: "[B" unsigned: false - ! &f8dba70c-6ac0-4f8c-b79d-fdcbf741f4b3 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: ! &70833652-d514-41aa-9cd0-6688d715f8f6 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "BIT" type: "system" type-mapped-class: "java.lang.Boolean" unsigned: false - ! &27254cd8-ba80-48c5-b275-6b196f4e9314 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: ! &66b91e9b-3979-471d-be21-9c70ba4a112b 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "not searchable" standard-type-name: "BLOB" type: "system" type-mapped-class: "java.sql.Blob" unsigned: false - ! &156aac7a-567c-4c4a-b5e6-11e4224209a7 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: ! &c477c19a-7bc7-4a1d-bbab-ce7a26205551 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "BOOLEAN" type: "system" type-mapped-class: "java.lang.Boolean" unsigned: false - *746cc609-a01d-48df-87f6-2b3a0d493253 - *95d8ef3d-a3b0-44a4-bdb4-5a31d4ce9029 - *0c97f799-9d70-4bd3-85b1-f31d8e84295e - ! &60dc66b7-898d-487d-9360-858755cd744d 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: ! &c5af6bf9-d680-442e-9683-2797ffeeb08d 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "DECIMAL" type: "system" type-mapped-class: "java.math.BigDecimal" unsigned: false - *a95c293a-f316-4965-a338-c7590c73a2a9 - ! &debbd345-9cf7-4c36-823e-d8268dc3ff15 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: *e67ec2b3-0281-4b29-b61a-6d8a9db6c85a 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "DOUBLE" type: "system" type-mapped-class: "java.lang.Double" unsigned: false - *1566f261-a200-4946-971d-4e1b3751f90f - ! &b62f3ffa-3ef4-4c2b-9822-cead3dd68f24 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: ! &e0cc1fee-9029-4e8e-9e5a-25c00694594f 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "NUMERIC" type: "system" type-mapped-class: "java.math.BigDecimal" unsigned: false - ! &dbf55577-c0f1-474f-b7a8-30cf14a37d5c 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: *bda254f2-e127-4fe3-b7a9-eaa7bcf5d285 literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 2147483647 remarks: "" schema: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable" standard-type-name: "VARCHAR" type: "system" type-mapped-class: "java.lang.String" unsigned: false - ! &9dd5a857-8f69-47dd-a808-55f767552949 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: ! &8791ae19-9d3a-4340-99d6-f6ad8ec9e37a 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "OTHER" type: "system" type-mapped-class: "java.lang.Object" unsigned: false - ! &c64ed673-28e5-4e9d-a5d5-e62e1649ad66 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: *e67ec2b3-0281-4b29-b61a-6d8a9db6c85a 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "DOUBLE" type: "system" type-mapped-class: "java.lang.Float" unsigned: false - *64e12be2-fdbe-48b0-8abc-e0710386e489 - ! &c0db5729-0cf8-4db5-ac55-3718663fa8c0 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: ! &4566855f-43a6-49d9-a5b2-57002dfc6004 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "TIME" type: "system" type-mapped-class: "java.sql.Time" unsigned: false - ! &8f95b17c-1a66-405f-ba4b-efccbc320c20 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: ! &848a28de-5318-4459-8551-96d6044067ee 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "TIMESTAMP" type: "system" type-mapped-class: "java.sql.Timestamp" unsigned: false - ! &d6842942-2e58-4262-8f1b-5d998402121d 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: ! &82b93270-56b9-45a0-a500-52215718f8f3 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "TIMESTAMP_WITH_TIMEZONE" type: "system" type-mapped-class: "java.time.OffsetDateTime" unsigned: false - ! &a59f76a6-a926-40f4-b757-d6d8fbf760ec 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: ! &2bc83b89-295f-4698-ad11-355c902d16b9 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "TIME_WITH_TIMEZONE" type: "system" type-mapped-class: "java.time.OffsetTime" unsigned: false - ! &bd0218fc-080a-4e9a-bf30-3b610b6bcca0 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: ! &071e0385-0970-4f10-aff7-8d09b335099d 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable except with where .. like" standard-type-name: "TINYINT" type: "system" type-mapped-class: "java.lang.Integer" unsigned: false - ! &c0e00016-6961-4325-92d7-08713bce5e1c 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: *006dc845-1773-40ea-a231-747644186b5e literal-prefix: "'" literal-suffix: "'" local-type-name: null maximum-scale: 0 minimum-scale: 0 nullable: true num-precision-radix: 0 precision: 16 remarks: "" schema: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable" standard-type-name: "BINARY" type: "system" type-mapped-class: "[B" unsigned: false - ! &7716f38c-f57f-49d4-ba84-7c8e841f6d21 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: ! &a110ca79-09a5-4183-b313-f8eb476b3cf4 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: *a3384295-70e8-4c7e-b8ec-142860c04a42 searchable: "searchable" standard-type-name: "VARBINARY" type: "system" type-mapped-class: "[B" unsigned: false - *f6ebf903-606c-48ce-8206-691740d55590 column-data-types: ! - *90985d02-0d8b-4ef9-a63e-b5dc40b4aecc - *7c47dd9d-2764-4855-8cb9-a2f4bcaf556a - *f8dba70c-6ac0-4f8c-b79d-fdcbf741f4b3 - *27254cd8-ba80-48c5-b275-6b196f4e9314 - *156aac7a-567c-4c4a-b5e6-11e4224209a7 - *746cc609-a01d-48df-87f6-2b3a0d493253 - *95d8ef3d-a3b0-44a4-bdb4-5a31d4ce9029 - *0c97f799-9d70-4bd3-85b1-f31d8e84295e - *60dc66b7-898d-487d-9360-858755cd744d - *a95c293a-f316-4965-a338-c7590c73a2a9 - *debbd345-9cf7-4c36-823e-d8268dc3ff15 - *1566f261-a200-4946-971d-4e1b3751f90f - *b62f3ffa-3ef4-4c2b-9822-cead3dd68f24 - *dbf55577-c0f1-474f-b7a8-30cf14a37d5c - *9dd5a857-8f69-47dd-a808-55f767552949 - *c64ed673-28e5-4e9d-a5d5-e62e1649ad66 - *64e12be2-fdbe-48b0-8abc-e0710386e489 - *c0db5729-0cf8-4db5-ac55-3718663fa8c0 - *8f95b17c-1a66-405f-ba4b-efccbc320c20 - *d6842942-2e58-4262-8f1b-5d998402121d - *a59f76a6-a926-40f4-b757-d6d8fbf760ec - *bd0218fc-080a-4e9a-bf30-3b610b6bcca0 - *c0e00016-6961-4325-92d7-08713bce5e1c - *7716f38c-f57f-49d4-ba84-7c8e841f6d21 - *f6ebf903-606c-48ce-8206-691740d55590 - *846536e1-f76a-4ac2-a9f7-d1117d16733b - *bddc6442-c5d5-4cce-ad6f-71fe4ec38e46 - *de28af05-824e-46d9-852c-3834076eedf2 - *960a27aa-cbb2-4657-a2d2-25a76f82ac32 - *7c99552d-e8ad-4f6b-aa72-342ec600cae3 attributes: ! {} database-users: ! - ! &3b6c6286-ba0b-453c-a080-ac77ef4ef73b name: "OTHERUSER" full-name: "OTHERUSER" attributes: ! ADMIN: false AUTHENTICATION: "ANY" PASSWORD_DIGEST: "3680cf0219b09398c34f2137f27a0c02" remarks: "" - ! &6b9132dd-b2e3-40c3-9c22-c8fb15a59a9c name: "SA" full-name: "SA" attributes: ! ADMIN: true AUTHENTICATION: "LOCAL" PASSWORD_DIGEST: "d41d8cd98f00b204e9800998ecf8427e" remarks: "" remarks: "" routines: ! [] sequences: ! [] synonyms: ! [] tables: ! - ! &ce14bc89-c22f-46da-b43a-c2fe4951a783 name: "AUTHORS" full-name: "PUBLIC.BOOKS.AUTHORS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "Contact details for book authors" columns: ! - *04292f60-7dd1-49e1-b51c-20c725e1d611 - *287d23d9-b702-4b9f-82ee-60142464c6f6 - *c792e591-8a24-42f5-b897-f8c7e37ce091 - *dfcbec47-7158-484c-831b-7f68060ad3e0 - *3e04edc6-df72-47c2-af2b-337fb376498d - *3660ea0d-3e12-469b-822c-aae9069139ea - *b152a3e5-42ee-4692-9cea-1aae3cc44f12 - *72f0d1d2-6282-4367-ac1f-c64d49b6842d - *43858715-51d4-4897-b0da-3d47c39cc535 definition: "" dependent-tables: ! - ! &51a4018a-aeab-446d-802e-c3ea683528f5 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: ! - *15dcd557-c80f-44cb-b781-09dc0738c0b8 - *95a5c8a0-7378-4b2d-9df8-edd306553993 - *f5f723aa-99f8-4be9-b71d-3a37a0711dd9 definition: "" dependent-tables: ! [] foreign-keys: ! - ! &1e537a55-705a-4675-a21d-5e968221d48f 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: ! - ! &252cac7f-966f-4820-8327-760ba5038c1b foreign-key-column: *95a5c8a0-7378-4b2d-9df8-edd306553993 key-sequence: 1 primary-key-column: *04292f60-7dd1-49e1-b51c-20c725e1d611 self-referencing: false constrained-columns: ! - *95a5c8a0-7378-4b2d-9df8-edd306553993 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *51a4018a-aeab-446d-802e-c3ea683528f5 foreign-key-table: *51a4018a-aeab-446d-802e-c3ea683528f5 initially-deferred: false optional: false parent-partial: false primary-key-table: *ce14bc89-c22f-46da-b43a-c2fe4951a783 referenced-table: *ce14bc89-c22f-46da-b43a-c2fe4951a783 remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false type: "foreign_key" update-rule: "no action" - ! &5e9aa64d-c481-48e2-8bec-9aa31e15d309 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: ! - ! &7bfe71b3-22b9-4950-bbdb-13b95f347b49 foreign-key-column: *15dcd557-c80f-44cb-b781-09dc0738c0b8 key-sequence: 1 primary-key-column: *eade6771-e115-4ee7-b6f5-07269e9a468a self-referencing: false constrained-columns: ! - *15dcd557-c80f-44cb-b781-09dc0738c0b8 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *51a4018a-aeab-446d-802e-c3ea683528f5 foreign-key-table: *51a4018a-aeab-446d-802e-c3ea683528f5 initially-deferred: false optional: false parent-partial: false primary-key-table: ! &116a4338-400e-4da6-b777-5695faefe65d name: "BOOKS" full-name: "PUBLIC.BOOKS.BOOKS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "Details for published books" columns: ! - *eade6771-e115-4ee7-b6f5-07269e9a468a - *c0e31539-21cb-462b-baef-c95775140d78 - *1e085766-b418-4283-a3c7-e1821c025922 - *8bccabcb-1378-4081-9b41-7dcc12b2c701 - *c9bf902d-215c-471c-b601-27547d863b0d - *0272d0c3-600c-4430-a0d8-a781e98562e7 - *2a0fa3b2-246f-4334-a022-2348e8f9559e definition: "" dependent-tables: ! - *51a4018a-aeab-446d-802e-c3ea683528f5 - *116a4338-400e-4da6-b777-5695faefe65d - ! &ae96aeff-22c4-4af9-ae4b-42a37970c15e name: "SALES" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *3be56c06-b3d9-45e0-915d-8516972c8c5b - *0151cb51-51f5-45b2-a81f-38e82a40551f - *7ed369e3-a2eb-4011-96a3-aca38e3281b2 - *7d29a3ed-6858-4896-af35-249b8f364f59 - *b0ee3b08-2398-47f5-96af-e38fe559903f - *c9dd5ee1-3831-45b4-99af-d7641ca145fc - *1295bc8d-2d25-4b76-9a9a-99d59ed7094a definition: "" dependent-tables: ! [] foreign-keys: ! - ! &62e370a9-d153-4a16-a339-b5aff3408e8a 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: ! - ! &55c312e7-1fcf-4473-97d8-017037dca691 foreign-key-column: *7ed369e3-a2eb-4011-96a3-aca38e3281b2 key-sequence: 1 primary-key-column: *eade6771-e115-4ee7-b6f5-07269e9a468a self-referencing: false constrained-columns: ! - *7ed369e3-a2eb-4011-96a3-aca38e3281b2 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *ae96aeff-22c4-4af9-ae4b-42a37970c15e foreign-key-table: *ae96aeff-22c4-4af9-ae4b-42a37970c15e initially-deferred: false optional: true parent-partial: false primary-key-table: *116a4338-400e-4da6-b777-5695faefe65d referenced-table: *116a4338-400e-4da6-b777-5695faefe65d remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 self-referencing: false type: "foreign_key" update-rule: "no action" - ! &172abbc4-b2b6-48e9-8c22-04c0b8aa0c59 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: ! - ! &a33d9b8e-e31e-4cb1-8919-1bd2eedc76e3 foreign-key-column: *1295bc8d-2d25-4b76-9a9a-99d59ed7094a key-sequence: 1 primary-key-column: *d856d334-5c5c-4ca3-940c-d1ce163f6a71 self-referencing: false constrained-columns: ! - *1295bc8d-2d25-4b76-9a9a-99d59ed7094a deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *ae96aeff-22c4-4af9-ae4b-42a37970c15e foreign-key-table: *ae96aeff-22c4-4af9-ae4b-42a37970c15e initially-deferred: false optional: true parent-partial: false primary-key-table: ! &40a4a098-b7a6-45d1-9035-f70517bd218f name: "SALESDATA" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *d856d334-5c5c-4ca3-940c-d1ce163f6a71 - *e092db10-5d9d-41ce-98d8-a2091222406f definition: "" dependent-tables: ! - *ae96aeff-22c4-4af9-ae4b-42a37970c15e foreign-keys: ! - *172abbc4-b2b6-48e9-8c22-04c0b8aa0c59 hidden-columns: ! [] indexes: ! - ! &31b7ddf5-848d-419f-9d45-40e08bec925c 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: ! - *d856d334-5c5c-4ca3-940c-d1ce163f6a71 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 type: "other" unique: true primary-key: null privileges: ! - ! &aeb81a27-24cf-4cba-9219-86be13623864 name: "DELETE" short-name: "SALESDATA.\"DELETE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"DELETE\"" attributes: ! {} grants: ! - ! &0f1b3c4f-955e-46d2-8b40-8cc35d176e2a grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &9a9c9201-2b29-4aeb-a47f-d8e3ab741069 name: "INSERT" short-name: "SALESDATA.\"INSERT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"INSERT\"" attributes: ! {} grants: ! - ! &efc3943d-29e6-41d7-8c29-502355f13e5a grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &4973f879-2272-40e8-b2bd-afbb85b26fac name: "REFERENCES" short-name: "SALESDATA.\"REFERENCES\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"REFERENCES\"" attributes: ! {} grants: ! - ! &d3ab5942-7a60-4f70-9cc6-83f0829dc0ce grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &dbaac106-7a38-4e30-9750-231a33c8c62d name: "SELECT" short-name: "SALESDATA.\"SELECT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"SELECT\"" attributes: ! {} grants: ! - ! &7ba93a8e-3a50-4050-b2ef-4d704bb803d0 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &1d1a46c6-8ed0-4678-a2bf-40e184ece939 name: "TRIGGER" short-name: "SALESDATA.\"TRIGGER\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"TRIGGER\"" attributes: ! {} grants: ! - ! &3aed0bae-7cb8-44fd-9dbf-36ea04fbfd75 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &62df540c-c1bb-4c5e-b092-b25a7dcaa888 name: "UPDATE" short-name: "SALESDATA.\"UPDATE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALESDATA.\"UPDATE\"" attributes: ! {} grants: ! - ! &75ccb8b0-61ba-4e49-9fe2-b67c2f9626eb grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 self-referencing: false table-constraints: ! - *31b7ddf5-848d-419f-9d45-40e08bec925c table-type: ! &a6974ca4-151c-4dfa-a413-6d8319e28ad2 table-type: "TABLE" view: false triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! - *ae96aeff-22c4-4af9-ae4b-42a37970c15e referenced-table: *40a4a098-b7a6-45d1-9035-f70517bd218f remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 self-referencing: false type: "foreign_key" update-rule: "no action" - ! &5d7a2698-e554-4449-8ee9-c19e3ed92bc3 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: ! - ! &7fa5641d-fdd2-4974-96ca-0e24dca9951e foreign-key-column: *3be56c06-b3d9-45e0-915d-8516972c8c5b key-sequence: 1 primary-key-column: *0217c58f-ae21-4045-98d7-805b7e950e6b self-referencing: false - ! &8d668e09-b95e-4f29-a0a4-cf605e302d66 foreign-key-column: *0151cb51-51f5-45b2-a81f-38e82a40551f key-sequence: 2 primary-key-column: *5a95b875-ea8c-4b4d-bbfa-533ecbdc6e91 self-referencing: false constrained-columns: ! - *3be56c06-b3d9-45e0-915d-8516972c8c5b - *0151cb51-51f5-45b2-a81f-38e82a40551f deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *ae96aeff-22c4-4af9-ae4b-42a37970c15e foreign-key-table: *ae96aeff-22c4-4af9-ae4b-42a37970c15e initially-deferred: false optional: false parent-partial: false primary-key-table: ! &0d3ccc54-97ce-4614-94e5-e165861b9658 name: "REGIONS" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *66e04c97-f3fa-4414-9f69-190df243686d - *7180959e-b634-4462-82d5-1157540d2eec - *0217c58f-ae21-4045-98d7-805b7e950e6b - *5a95b875-ea8c-4b4d-bbfa-533ecbdc6e91 definition: "" dependent-tables: ! - *ae96aeff-22c4-4af9-ae4b-42a37970c15e foreign-keys: ! - *5d7a2698-e554-4449-8ee9-c19e3ed92bc3 hidden-columns: ! [] indexes: ! - ! &fa2630c4-8fbf-4760-8156-d7fac2f2b251 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: ! - *0217c58f-ae21-4045-98d7-805b7e950e6b - *5a95b875-ea8c-4b4d-bbfa-533ecbdc6e91 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 type: "other" unique: true primary-key: *fa2630c4-8fbf-4760-8156-d7fac2f2b251 privileges: ! - ! &360217da-b361-4c46-b868-295d9dc60c65 name: "DELETE" short-name: "REGIONS.\"DELETE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"DELETE\"" attributes: ! {} grants: ! - ! &12234462-519f-4a38-8ac8-33fba30beebb grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &df8748c4-7a24-46d7-8487-6cddbd7e7cdb name: "INSERT" short-name: "REGIONS.\"INSERT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"INSERT\"" attributes: ! {} grants: ! - ! &edeac55d-6f51-4d6e-9aab-4a317e4dd335 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &e723f69f-5946-4a9c-8f93-18548e842b0f name: "REFERENCES" short-name: "REGIONS.\"REFERENCES\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &8b65299f-dfab-4fc0-9bd4-e865769ba710 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &8ed4d8be-6a25-441b-ab5f-76bd442c0700 name: "SELECT" short-name: "REGIONS.\"SELECT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"SELECT\"" attributes: ! {} grants: ! - ! &b48cb929-084e-4d26-b4ac-d52675339e0b grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &8a79808a-e666-4eb2-9f67-f1878ca40b67 name: "TRIGGER" short-name: "REGIONS.\"TRIGGER\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &933d0f22-95f2-4e93-a55e-d8a57bda126b grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &a45fccd7-61aa-45c6-9fe9-d277e2619149 name: "UPDATE" short-name: "REGIONS.\"UPDATE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".REGIONS.\"UPDATE\"" attributes: ! {} grants: ! - ! &a4998945-0905-4b2b-b963-7235217a1db5 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 self-referencing: false table-constraints: ! - *fa2630c4-8fbf-4760-8156-d7fac2f2b251 - ! &c6a0937b-9bfc-4c76-be34-6b9d4762db09 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: ! - *66e04c97-f3fa-4414-9f69-190df243686d deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.CITY IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 type: "check" - ! &e8cda5ac-5ed6-4ac6-94ff-723c7982b04d 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: ! - *7180959e-b634-4462-82d5-1157540d2eec deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.STATE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 type: "check" - ! &804e4fe5-0590-4d71-b1b7-095d048003c0 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: ! - *0217c58f-ae21-4045-98d7-805b7e950e6b deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.POSTALCODE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 type: "check" - ! &f9c6c116-aa9d-4d7a-b445-20b5a617675e 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: ! - *5a95b875-ea8c-4b4d-bbfa-533ecbdc6e91 deferrable: false definition: "\"PUBLISHER SALES\".REGIONS.COUNTRY IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! - *ae96aeff-22c4-4af9-ae4b-42a37970c15e referenced-table: *0d3ccc54-97ce-4614-94e5-e165861b9658 remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - *62e370a9-d153-4a16-a339-b5aff3408e8a - *172abbc4-b2b6-48e9-8c22-04c0b8aa0c59 - *5d7a2698-e554-4449-8ee9-c19e3ed92bc3 primary-key: null privileges: ! - ! &6d4cef95-0955-4097-b425-87c7e1e595ed name: "DELETE" short-name: "SALES.\"DELETE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"DELETE\"" attributes: ! {} grants: ! - ! &7424acf9-9238-46b8-b7c0-de29cb3aee21 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &137c95b2-0a3d-4395-baa9-09454c4c18d0 name: "INSERT" short-name: "SALES.\"INSERT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"INSERT\"" attributes: ! {} grants: ! - ! &5df86ff0-c172-4565-a66d-0a1df35cfe27 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &dcca2182-8a68-4cc0-9ebf-99a99fb559fa name: "REFERENCES" short-name: "SALES.\"REFERENCES\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"REFERENCES\"" attributes: ! {} grants: ! - ! &d4d99ebf-ccef-468f-8af7-ec6d2b88e37c grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &b21e10d5-42eb-4b13-893b-3aed62ae4cf8 name: "SELECT" short-name: "SALES.\"SELECT\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"SELECT\"" attributes: ! {} grants: ! - ! &6b0689b4-0cdb-41d1-94e8-66c4cfc90665 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &ea93c4b2-bfe0-4a2f-ab3e-25264461ffb0 name: "TRIGGER" short-name: "SALES.\"TRIGGER\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"TRIGGER\"" attributes: ! {} grants: ! - ! &960dbe01-4b34-48ee-9ee8-7a8769995e69 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 - ! &551da4aa-c889-46e2-b017-d439593451a3 name: "UPDATE" short-name: "SALES.\"UPDATE\"" full-name: "PUBLIC.\"PUBLISHER SALES\".SALES.\"UPDATE\"" attributes: ! {} grants: ! - ! &f02b2e52-835a-41ea-9911-f56219833c27 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 referenced-objects: ! - *116a4338-400e-4da6-b777-5695faefe65d - *0d3ccc54-97ce-4614-94e5-e165861b9658 - *40a4a098-b7a6-45d1-9035-f70517bd218f referenced-tables: ! - *116a4338-400e-4da6-b777-5695faefe65d - *0d3ccc54-97ce-4614-94e5-e165861b9658 - *40a4a098-b7a6-45d1-9035-f70517bd218f remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 self-referencing: false table-constraints: ! - *62e370a9-d153-4a16-a339-b5aff3408e8a - *172abbc4-b2b6-48e9-8c22-04c0b8aa0c59 - *5d7a2698-e554-4449-8ee9-c19e3ed92bc3 - ! &05d9b8f3-153f-42cb-b3f9-d53a5ade7564 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: ! - *3be56c06-b3d9-45e0-915d-8516972c8c5b deferrable: false definition: "\"PUBLISHER SALES\".SALES.POSTALCODE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 type: "check" - ! &5182b8e4-c154-42bd-bcf8-7519ac1161bc 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: ! - *0151cb51-51f5-45b2-a81f-38e82a40551f deferrable: false definition: "\"PUBLISHER SALES\".SALES.COUNTRY IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *e85bb1cc-7f9a-4bae-96f0-e3f968fc99c7 type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! [] foreign-keys: ! - ! &4eeceaf0-fc0a-4607-84f1-9832febb50ea 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: ! - ! &2d3ff072-71fb-436a-a298-e868cf39f1e1 foreign-key-column: *2a0fa3b2-246f-4334-a022-2348e8f9559e key-sequence: 1 primary-key-column: *eade6771-e115-4ee7-b6f5-07269e9a468a self-referencing: false constrained-columns: ! - *2a0fa3b2-246f-4334-a022-2348e8f9559e deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *116a4338-400e-4da6-b777-5695faefe65d foreign-key-table: *116a4338-400e-4da6-b777-5695faefe65d initially-deferred: false optional: true parent-partial: false primary-key-table: *116a4338-400e-4da6-b777-5695faefe65d referenced-table: *116a4338-400e-4da6-b777-5695faefe65d remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: true type: "foreign_key" update-rule: "no action" - *62e370a9-d153-4a16-a339-b5aff3408e8a - *5e9aa64d-c481-48e2-8bec-9aa31e15d309 hidden-columns: ! [] indexes: ! - ! &30acee5a-3ae7-4553-a5ff-8180c9f15713 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: ! - *eade6771-e115-4ee7-b6f5-07269e9a468a definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: true - ! &755e716c-eb36-482c-b67e-75c3e7cae162 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: ! - *2a0fa3b2-246f-4334-a022-2348e8f9559e definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: true - *4eeceaf0-fc0a-4607-84f1-9832febb50ea primary-key: *30acee5a-3ae7-4553-a5ff-8180c9f15713 privileges: ! - ! &2b69ca62-a710-4f60-af4f-2b67ace73fdd name: "DELETE" short-name: "BOOKS.\"DELETE\"" full-name: "PUBLIC.BOOKS.BOOKS.\"DELETE\"" attributes: ! {} grants: ! - ! &e8e73574-6118-4842-b0b0-1628e0a79671 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &c5afe294-b412-49a6-8d77-ca8fb9f4f5a8 name: "INSERT" short-name: "BOOKS.\"INSERT\"" full-name: "PUBLIC.BOOKS.BOOKS.\"INSERT\"" attributes: ! {} grants: ! - ! &48e6031e-b52a-4468-b627-7c9c8cf8f21a grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &ab554a2e-a1e4-4327-833f-457f7ef1d4e6 name: "REFERENCES" short-name: "BOOKS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.BOOKS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &a13f5ad7-8b01-47ea-af91-f432350673ba grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &ce0d981f-a1c8-483a-ac7c-7e276c680399 name: "SELECT" short-name: "BOOKS.\"SELECT\"" full-name: "PUBLIC.BOOKS.BOOKS.\"SELECT\"" attributes: ! {} grants: ! - ! &03c8e625-0e03-43f3-a9d4-712e65c63aed grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &70e2fdc5-f2d1-4281-bbba-0b5b1c63db1e name: "TRIGGER" short-name: "BOOKS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.BOOKS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &ffe5f160-ac3b-4edd-9cba-2ec1cc42d046 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &b2882d36-d1e2-4402-9154-6765c0ab6596 name: "UPDATE" short-name: "BOOKS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.BOOKS.\"UPDATE\"" attributes: ! {} grants: ! - ! &50313a80-ffe3-4266-8925-ef826ad64c67 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 referenced-objects: ! - *116a4338-400e-4da6-b777-5695faefe65d referenced-tables: ! - *116a4338-400e-4da6-b777-5695faefe65d remarks: "Details for published books" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: true table-constraints: ! - *30acee5a-3ae7-4553-a5ff-8180c9f15713 - *4eeceaf0-fc0a-4607-84f1-9832febb50ea - *755e716c-eb36-482c-b67e-75c3e7cae162 - ! &8c5f154e-5199-49d2-bf79-9782b2e54826 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: ! - *eade6771-e115-4ee7-b6f5-07269e9a468a deferrable: false definition: "BOOKS.BOOKS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" - ! &96a75a23-9c41-4555-ac44-a460e314eda7 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: ! - *c0e31539-21cb-462b-baef-c95775140d78 deferrable: false definition: "BOOKS.BOOKS.TITLE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" - ! &27f98c3f-d76b-4c4a-a331-ccd40095fbe9 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: ! - *8bccabcb-1378-4081-9b41-7dcc12b2c701 deferrable: false definition: "BOOKS.BOOKS.PUBLISHERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! - *116a4338-400e-4da6-b777-5695faefe65d - *51a4018a-aeab-446d-802e-c3ea683528f5 - *ae96aeff-22c4-4af9-ae4b-42a37970c15e referenced-table: *116a4338-400e-4da6-b777-5695faefe65d remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - *1e537a55-705a-4675-a21d-5e968221d48f - *5e9aa64d-c481-48e2-8bec-9aa31e15d309 - ! &888d44b0-8953-44ae-b35f-ad7764483d51 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: ! - *15dcd557-c80f-44cb-b781-09dc0738c0b8 - *95a5c8a0-7378-4b2d-9df8-edd306553993 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: true primary-key: null privileges: ! - ! &1fe3fab9-bf28-4a95-bbd0-b7fb0690f273 name: "DELETE" short-name: "BOOKAUTHORS.\"DELETE\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"DELETE\"" attributes: ! {} grants: ! - ! &50aa3495-a85e-462d-8582-d7b79dd19a78 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &83c140b7-95bb-4b9b-9c5e-c7a0c3712d0d name: "INSERT" short-name: "BOOKAUTHORS.\"INSERT\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"INSERT\"" attributes: ! {} grants: ! - ! &54d8fdce-64e5-441e-a473-6a2feae9aa17 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &d6f52bfc-1ac8-418b-9dfb-84b169b92578 name: "REFERENCES" short-name: "BOOKAUTHORS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &47e22c2a-3f92-447c-817b-7fe2dcf3cc4a grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &aa83a8dc-a7f0-4758-8b65-186db1d251fd name: "SELECT" short-name: "BOOKAUTHORS.\"SELECT\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"SELECT\"" attributes: ! {} grants: ! - ! &b8981a47-338c-4f64-8af5-eaf21cd5f4b4 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &6d8ec0ca-3eaa-45d2-85d6-c7c9fbf21421 name: "TRIGGER" short-name: "BOOKAUTHORS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &1920aeb8-3e0f-45e1-8ca1-3645b9b3e2d8 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &b2af749b-fa50-4787-87d7-335f83c06664 name: "UPDATE" short-name: "BOOKAUTHORS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.BOOKAUTHORS.\"UPDATE\"" attributes: ! {} grants: ! - ! &ee1ef293-62ea-4c27-a93f-cf6f5afcb13d grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 referenced-objects: ! - *ce14bc89-c22f-46da-b43a-c2fe4951a783 - *116a4338-400e-4da6-b777-5695faefe65d referenced-tables: ! - *ce14bc89-c22f-46da-b43a-c2fe4951a783 - *116a4338-400e-4da6-b777-5695faefe65d remarks: "Relationship between books and their authors, \nalong with the latest\ \ updated information" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false table-constraints: ! - *1e537a55-705a-4675-a21d-5e968221d48f - *5e9aa64d-c481-48e2-8bec-9aa31e15d309 - ! &d12e43f8-f860-48cf-9dd3-4924a67887d7 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: ! - *15dcd557-c80f-44cb-b781-09dc0738c0b8 deferrable: false definition: "BOOKS.BOOKAUTHORS.BOOKID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" - ! &0a83f4c4-047f-41f1-a9de-fddfabe742bd 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: ! - *95a5c8a0-7378-4b2d-9df8-edd306553993 deferrable: false definition: "BOOKS.BOOKAUTHORS.AUTHORID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! [] foreign-keys: ! - *1e537a55-705a-4675-a21d-5e968221d48f hidden-columns: ! [] indexes: ! - ! &20a29246-ce9a-4b38-985f-ba4db89eb418 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: ! - *04292f60-7dd1-49e1-b51c-20c725e1d611 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: true - ! &dac92448-f2a8-462d-b1e3-183740249d05 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: ! - *c792e591-8a24-42f5-b897-f8c7e37ce091 - *287d23d9-b702-4b9f-82ee-60142464c6f6 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: false - ! &e7dee9a7-5bc9-4796-b22a-2623186e1d14 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: ! - *3660ea0d-3e12-469b-822c-aae9069139ea - *b152a3e5-42ee-4692-9cea-1aae3cc44f12 - *72f0d1d2-6282-4367-ac1f-c64d49b6842d - *43858715-51d4-4897-b0da-3d47c39cc535 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: false primary-key: *20a29246-ce9a-4b38-985f-ba4db89eb418 privileges: ! - ! &c8fa3584-41ca-4e14-9e76-cc0397760c43 name: "DELETE" short-name: "AUTHORS.\"DELETE\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"DELETE\"" attributes: ! {} grants: ! - ! &86792aee-8b33-442c-8e84-b5a96efc8ce3 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &8fc5f997-22a3-475a-8c5a-9bb95c56d9aa name: "INSERT" short-name: "AUTHORS.\"INSERT\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"INSERT\"" attributes: ! {} grants: ! - ! &146edc2f-6fd4-4994-9f60-51bf5ef65088 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &f724a17c-1043-4ded-9fbf-aeb1a6e2242d name: "REFERENCES" short-name: "AUTHORS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &83e10477-cf99-4bfb-9035-7a2beb418d1a grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &00167379-23ba-4f27-831a-c665a497796e name: "SELECT" short-name: "AUTHORS.\"SELECT\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"SELECT\"" attributes: ! {} grants: ! - ! &40c83a67-eacc-473e-a960-6c7829ba8322 grantable: false grantee: "OTHERUSER" grantor: "SA" - ! &57ea67f6-a9d4-465b-9751-fe49d3691e15 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &82850934-be64-41f9-8c22-7c1beeb0f292 name: "TRIGGER" short-name: "AUTHORS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &06e0fef4-2ea5-4f10-b2b8-4b50eb3f018c grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &58fc31a7-c1b4-404e-8f73-7e6857dbde21 name: "UPDATE" short-name: "AUTHORS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.AUTHORS.\"UPDATE\"" attributes: ! {} grants: ! - ! &85b4955b-0cee-4319-ba69-a34a072fc6dc grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 referenced-objects: ! [] referenced-tables: ! [] remarks: "Contact details for book authors" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false table-constraints: ! - *20a29246-ce9a-4b38-985f-ba4db89eb418 - ! &051e58f0-d6fe-4303-8140-ac94901df635 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: ! - *b152a3e5-42ee-4692-9cea-1aae3cc44f12 deferrable: false definition: "BOOKS.AUTHORS.STATE=UPPER(BOOKS.AUTHORS.STATE)" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" - ! &01ca92ab-7413-4dd9-b697-7c442a3e9840 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: ! - *04292f60-7dd1-49e1-b51c-20c725e1d611 deferrable: false definition: "BOOKS.AUTHORS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" - ! &1832a55a-4665-4e55-a041-495ee6a43c6a 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: ! - *287d23d9-b702-4b9f-82ee-60142464c6f6 deferrable: false definition: "BOOKS.AUTHORS.FIRSTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" - ! &fc8f231b-fdc4-40e4-b178-0f7f262a53da 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: ! - *c792e591-8a24-42f5-b897-f8c7e37ce091 deferrable: false definition: "BOOKS.AUTHORS.LASTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! - ! &3ddbb491-f744-4b99-979b-241696369417 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: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! - *51a4018a-aeab-446d-802e-c3ea683528f5 - ! &e5838fcd-919a-400d-85cb-5ae30c8079cb 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: ! - *94da9ce8-36e9-4534-8ae1-7ddbc6bbdbcf - *550a9e00-256a-418f-a526-0b2d2aab1c25 - *a5f4d19b-f63e-4461-8877-59aa2da46ea0 definition: "SELECT ID,FIRSTNAME,LASTNAME FROM BOOKS.AUTHORS" dependent-tables: ! [] foreign-keys: ! [] hidden-columns: ! [] indexes: ! [] primary-key: null privileges: ! - ! &414a510a-6334-4fc0-9fa5-9e6585adb433 name: "DELETE" short-name: "AUTHORSLIST.\"DELETE\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"DELETE\"" attributes: ! {} grants: ! - ! &e4c94134-f635-493a-9bd1-88097796fd8e grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &473af68a-3355-457d-a3cf-d7f94a61711d name: "INSERT" short-name: "AUTHORSLIST.\"INSERT\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"INSERT\"" attributes: ! {} grants: ! - ! &7150fb78-2465-488c-9979-ce972387f580 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &202f31bd-ab2e-42e8-907b-863acc194ca1 name: "REFERENCES" short-name: "AUTHORSLIST.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"REFERENCES\"" attributes: ! {} grants: ! - ! &64b64f44-ca25-465c-ab78-2773e99eb99a grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &c8fc4bfe-22e6-4f1c-8974-4d4f8aa1d528 name: "SELECT" short-name: "AUTHORSLIST.\"SELECT\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"SELECT\"" attributes: ! {} grants: ! - ! &fc61cdfb-8765-46f0-a03f-0097e4bfafd7 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &743a809e-428a-413e-9d80-c290c0d12be2 name: "TRIGGER" short-name: "AUTHORSLIST.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"TRIGGER\"" attributes: ! {} grants: ! - ! &2392d2c6-1d6d-449b-9458-7c7403020059 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &bffee298-f2c4-4c35-accc-74c2e843d5a0 name: "UPDATE" short-name: "AUTHORSLIST.\"UPDATE\"" full-name: "PUBLIC.BOOKS.AUTHORSLIST.\"UPDATE\"" attributes: ! {} grants: ! - ! &a23a9793-f708-43bf-8f17-c07ba05d3483 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 referenced-objects: ! - *ce14bc89-c22f-46da-b43a-c2fe4951a783 referenced-tables: ! [] remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false table-constraints: ! [] table-type: ! &ed3a1fd2-47f3-4fae-934e-82dab87f7dc9 table-type: "VIEW" view: true table-usage: ! - *ce14bc89-c22f-46da-b43a-c2fe4951a783 triggers: ! [] type: *ed3a1fd2-47f3-4fae-934e-82dab87f7dc9 updatable: true used-by-objects: ! [] - *51a4018a-aeab-446d-802e-c3ea683528f5 - *116a4338-400e-4da6-b777-5695faefe65d - ! &7b923396-8676-4ade-b1c7-d4ebb4b01bf1 name: "Celebrities" full-name: "PUBLIC.BOOKS.\"Celebrities\"" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *5376fded-cd28-4905-9ae9-4287edb3f84f - *5cf79e9c-aed1-40cd-8c96-c911f38dbb6e definition: "" dependent-tables: ! - ! &900b44d3-dfe4-4348-8de2-e9b2c69b77c0 name: "Celebrity Updates" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\"" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *a3ccce28-3187-4414-9b70-dc0e4105300b - *e9bfc8b1-16f9-4d1e-948e-d9ff2e05dea8 definition: "" dependent-tables: ! [] foreign-keys: ! - ! &701047e4-3024-43c1-9bfd-9d1bae8b0f36 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: ! - ! &c59fbe3f-6974-4017-8264-6695af034948 foreign-key-column: *a3ccce28-3187-4414-9b70-dc0e4105300b key-sequence: 1 primary-key-column: *5376fded-cd28-4905-9ae9-4287edb3f84f self-referencing: false constrained-columns: ! - *a3ccce28-3187-4414-9b70-dc0e4105300b deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *900b44d3-dfe4-4348-8de2-e9b2c69b77c0 foreign-key-table: *900b44d3-dfe4-4348-8de2-e9b2c69b77c0 initially-deferred: false optional: false parent-partial: false primary-key-table: *7b923396-8676-4ade-b1c7-d4ebb4b01bf1 referenced-table: *7b923396-8676-4ade-b1c7-d4ebb4b01bf1 remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - ! &2c525f61-771a-40f3-a52d-236ee2bb49c2 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: ! - *a3ccce28-3187-4414-9b70-dc0e4105300b definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: true - *701047e4-3024-43c1-9bfd-9d1bae8b0f36 primary-key: *2c525f61-771a-40f3-a52d-236ee2bb49c2 privileges: ! - ! &936dcf55-0bb1-4e85-9664-09f9324157e0 name: "DELETE" short-name: "\"Celebrity Updates\".\"DELETE\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"DELETE\"" attributes: ! {} grants: ! - ! &7d4b1624-a7f7-46bf-9b47-0c8d19416918 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &1622b4aa-3be2-4ab9-9af0-7757757db8b4 name: "INSERT" short-name: "\"Celebrity Updates\".\"INSERT\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"INSERT\"" attributes: ! {} grants: ! - ! &20a85750-5c70-47ce-a2c6-55e6b2886956 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &07fdfbb3-3c8a-4011-9b6d-ced49c2d11f6 name: "REFERENCES" short-name: "\"Celebrity Updates\".\"REFERENCES\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"REFERENCES\"" attributes: ! {} grants: ! - ! &c3710927-94f9-4c29-80c8-07b06df52445 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &e5546d9f-667a-4e50-829e-31412d15046c name: "SELECT" short-name: "\"Celebrity Updates\".\"SELECT\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"SELECT\"" attributes: ! {} grants: ! - ! &c8d018a3-303a-462e-8409-c1b4e6abe565 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &6483e806-1794-434a-aadd-dfc09d95501e name: "TRIGGER" short-name: "\"Celebrity Updates\".\"TRIGGER\"" full-name: "PUBLIC.BOOKS.\"Celebrity Updates\".\"TRIGGER\"" attributes: ! {} grants: ! - ! &26bf0f62-e401-40b6-91c8-43e92d7ba1b3 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - *e9bfc8b1-16f9-4d1e-948e-d9ff2e05dea8 referenced-objects: ! - *7b923396-8676-4ade-b1c7-d4ebb4b01bf1 referenced-tables: ! - *7b923396-8676-4ade-b1c7-d4ebb4b01bf1 remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false table-constraints: ! - *2c525f61-771a-40f3-a52d-236ee2bb49c2 - *701047e4-3024-43c1-9bfd-9d1bae8b0f36 - ! &0d60b627-2f83-4f16-89e8-7fe72f088009 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: ! - *a3ccce28-3187-4414-9b70-dc0e4105300b deferrable: false definition: "BOOKS.\"Celebrity Updates\".\"Celebrity Id\" IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! [] foreign-keys: ! - *701047e4-3024-43c1-9bfd-9d1bae8b0f36 hidden-columns: ! [] indexes: ! - ! &71dd4449-9822-4c7f-9743-0203ece9ef43 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: ! - *5376fded-cd28-4905-9ae9-4287edb3f84f definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: true primary-key: *71dd4449-9822-4c7f-9743-0203ece9ef43 privileges: ! - ! &56e69787-d71f-4f4b-8f3d-f1b7e9def7ee name: "DELETE" short-name: "\"Celebrities\".\"DELETE\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"DELETE\"" attributes: ! {} grants: ! - ! &7e9eaf79-5fa5-4d3c-8243-ec3cd4169d90 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &b5a56642-26bb-4246-95ce-ab869719585d name: "INSERT" short-name: "\"Celebrities\".\"INSERT\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"INSERT\"" attributes: ! {} grants: ! - ! &aa5a26aa-fe07-4ebe-9402-8f3856da9146 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &72141d82-b270-46bb-91f5-5c2ce02f7f2d name: "REFERENCES" short-name: "\"Celebrities\".\"REFERENCES\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"REFERENCES\"" attributes: ! {} grants: ! - ! &35fd035f-3398-49c6-afca-454d217c9a1d grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &56d44834-02b3-4fc7-80b5-95d7f74a447c name: "SELECT" short-name: "\"Celebrities\".\"SELECT\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"SELECT\"" attributes: ! {} grants: ! - ! &cc63aecb-c52c-42ca-837c-418e9f1b51cc grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &f225771b-3b63-4b31-a96f-0bb47b89d724 name: "TRIGGER" short-name: "\"Celebrities\".\"TRIGGER\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"TRIGGER\"" attributes: ! {} grants: ! - ! &06d05aca-a804-4d91-a059-f1c09c73599e grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &56fee808-07b6-4021-85fb-a05077a6f896 name: "UPDATE" short-name: "\"Celebrities\".\"UPDATE\"" full-name: "PUBLIC.BOOKS.\"Celebrities\".\"UPDATE\"" attributes: ! {} grants: ! - ! &d99f6dcc-9a67-45f4-b117-196b9ef0d16f grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false table-constraints: ! - *71dd4449-9822-4c7f-9743-0203ece9ef43 - ! &ea2f6b7d-6384-4730-b011-c91998009562 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: ! - *5376fded-cd28-4905-9ae9-4287edb3f84f deferrable: false definition: "BOOKS.\"Celebrities\".\"Id\" IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! - *900b44d3-dfe4-4348-8de2-e9b2c69b77c0 - *900b44d3-dfe4-4348-8de2-e9b2c69b77c0 - ! &81ed6812-2e1e-4fc4-af1b-13b2739f5374 name: "COUPONS" full-name: "PUBLIC.BOOKS.COUPONS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *ba5f22c0-932b-4f8f-865f-06d8522ae136 - *84b92f41-3a86-4f1f-86c6-c2f2c1d82f66 - *9c371697-9980-456e-ab0f-ffd89b68a881 - *8bfab531-fd71-46b1-ba0c-9a60e8740b27 definition: "" dependent-tables: ! [] foreign-keys: ! [] hidden-columns: ! [] indexes: ! - ! &6561c149-61ef-4b79-9120-1a889f711073 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: ! - *ba5f22c0-932b-4f8f-865f-06d8522ae136 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: true primary-key: *6561c149-61ef-4b79-9120-1a889f711073 privileges: ! - ! &95b948a2-72de-4314-aaa4-5422bd555386 name: "DELETE" short-name: "COUPONS.\"DELETE\"" full-name: "PUBLIC.BOOKS.COUPONS.\"DELETE\"" attributes: ! {} grants: ! - ! &2b3859f5-680b-45f5-9abf-fab00b67ab90 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &90edc88d-0913-4e97-a7d2-346406db389e name: "INSERT" short-name: "COUPONS.\"INSERT\"" full-name: "PUBLIC.BOOKS.COUPONS.\"INSERT\"" attributes: ! {} grants: ! - ! &0da3fd1b-f579-4513-842d-fcce82479654 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &03315d50-5d13-459f-a174-f30fab007bdd name: "REFERENCES" short-name: "COUPONS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.COUPONS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &d06fd54c-a201-4874-ae28-690af8bc14ba grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &6ea1f117-de95-464b-a6f7-77e89006c16f name: "SELECT" short-name: "COUPONS.\"SELECT\"" full-name: "PUBLIC.BOOKS.COUPONS.\"SELECT\"" attributes: ! {} grants: ! - ! &a9f2abc5-d86c-4022-9d5d-f065c1aa13a6 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &fc1949c4-fdb9-4de3-97aa-d7249ce52514 name: "TRIGGER" short-name: "COUPONS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.COUPONS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &715c2715-fc76-4a72-8371-29f3ea354660 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &a6aecc3c-c735-4e21-9dac-e59b647068a0 name: "UPDATE" short-name: "COUPONS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.COUPONS.\"UPDATE\"" attributes: ! {} grants: ! - ! &da8e6f3d-2a64-4eff-b3ce-b5f0993e2968 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false table-constraints: ! - *6561c149-61ef-4b79-9120-1a889f711073 - ! &5d7b6b67-1517-42aa-b90a-c939d9e0753c 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: ! - *ba5f22c0-932b-4f8f-865f-06d8522ae136 deferrable: false definition: "BOOKS.COUPONS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! [] - ! &00f50354-0b5a-4908-aa9e-7e811562a099 name: "CUSTOMERDATA" full-name: "PUBLIC.BOOKS.CUSTOMERDATA" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *5a096929-5fe6-4a3a-8a63-240d3be43a93 - *3f80eb2b-0c4d-47c0-b835-f2c9a14e3432 - *28c14388-459d-45aa-b7f6-48dd964deea8 definition: "" dependent-tables: ! [] foreign-keys: ! - ! &cbf75858-498f-4d2c-9179-238fe55fb16a 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: ! - ! &cf277c89-cd0a-4232-83c7-e0241e9e169a foreign-key-column: *5a096929-5fe6-4a3a-8a63-240d3be43a93 key-sequence: 1 primary-key-column: *49fdca56-2b73-4994-8b83-eb55b86257c1 self-referencing: false constrained-columns: ! - *5a096929-5fe6-4a3a-8a63-240d3be43a93 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *00f50354-0b5a-4908-aa9e-7e811562a099 foreign-key-table: *00f50354-0b5a-4908-aa9e-7e811562a099 initially-deferred: false optional: false parent-partial: false primary-key-table: ! &de3d92ec-efe6-4a77-a645-cb99794bfff2 name: "CUSTOMERS" full-name: "PUBLIC.BOOKS.CUSTOMERS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *49fdca56-2b73-4994-8b83-eb55b86257c1 - *0400e4ec-546d-48e6-907f-d0e7d0a63f6f - *405c3b43-3651-420e-9dad-56a1fdea44eb - *f6af1b9d-7a74-4438-b233-fc9a4eb1658f definition: "" dependent-tables: ! - *00f50354-0b5a-4908-aa9e-7e811562a099 foreign-keys: ! - *cbf75858-498f-4d2c-9179-238fe55fb16a hidden-columns: ! [] indexes: ! - ! &fcb1c30a-ae70-4f1d-9618-c6ff95d5ae7d 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: ! - *49fdca56-2b73-4994-8b83-eb55b86257c1 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: true primary-key: *fcb1c30a-ae70-4f1d-9618-c6ff95d5ae7d privileges: ! - ! &29ada883-efd4-43d7-98a6-de3518143ab3 name: "DELETE" short-name: "CUSTOMERS.\"DELETE\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"DELETE\"" attributes: ! {} grants: ! - ! &1f2e3114-ba60-4c3d-8d46-7dbb74c5ef61 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &b83eb0d1-fe22-4852-a48a-ce28c1fd442a name: "INSERT" short-name: "CUSTOMERS.\"INSERT\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"INSERT\"" attributes: ! {} grants: ! - ! &d1547579-7b7f-47e2-a03b-39c0c0da3385 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &5fe570cd-ad21-4a03-9e4a-c0743351a55d name: "REFERENCES" short-name: "CUSTOMERS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &6ad3cd03-7036-41cc-b255-b22f2183f5cb grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &02f83667-52d7-4c7a-a89d-9cb2805cdee2 name: "SELECT" short-name: "CUSTOMERS.\"SELECT\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"SELECT\"" attributes: ! {} grants: ! - ! &6405d121-f7be-4a79-a48c-05bab67e74ca grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &b0f67f13-0c79-46f5-b4cc-4995f6c001a3 name: "TRIGGER" short-name: "CUSTOMERS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &bb7ff5b5-93bb-4fa7-9e93-c5e598fc1c30 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &90e20455-ebb6-470c-82c6-9ba89ba3d8bb name: "UPDATE" short-name: "CUSTOMERS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.CUSTOMERS.\"UPDATE\"" attributes: ! {} grants: ! - ! &6db60d7e-8663-4a66-af63-fd32444b002d grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false table-constraints: ! - *fcb1c30a-ae70-4f1d-9618-c6ff95d5ae7d - ! &0f292799-2a74-42d1-97c6-998bffa8e410 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: ! - *49fdca56-2b73-4994-8b83-eb55b86257c1 deferrable: false definition: "BOOKS.CUSTOMERS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" - ! &ba8823e5-27db-4311-94ee-44aa1b64f660 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: ! - *0400e4ec-546d-48e6-907f-d0e7d0a63f6f deferrable: false definition: "BOOKS.CUSTOMERS.FIRSTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" - ! &3a354178-adeb-4ceb-9fb7-b2f84149ba42 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: ! - *405c3b43-3651-420e-9dad-56a1fdea44eb deferrable: false definition: "BOOKS.CUSTOMERS.LASTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! - *00f50354-0b5a-4908-aa9e-7e811562a099 referenced-table: *de3d92ec-efe6-4a77-a645-cb99794bfff2 remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - *cbf75858-498f-4d2c-9179-238fe55fb16a - ! &24cc9694-08df-4160-b4f4-b6735c719322 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: ! - *5a096929-5fe6-4a3a-8a63-240d3be43a93 - *3f80eb2b-0c4d-47c0-b835-f2c9a14e3432 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: true primary-key: *24cc9694-08df-4160-b4f4-b6735c719322 privileges: ! - ! &ac872000-f4db-4cdb-b2e2-2757ebe98007 name: "DELETE" short-name: "CUSTOMERDATA.\"DELETE\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"DELETE\"" attributes: ! {} grants: ! - ! &eccdb994-9c61-44fe-980b-07498ae83256 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &c55835e9-ab05-47b9-9c5d-65ac1ac71fcb name: "INSERT" short-name: "CUSTOMERDATA.\"INSERT\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"INSERT\"" attributes: ! {} grants: ! - ! &b3e8aac3-9b68-46e7-a7bc-5603497edaa2 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &59834b68-9e5c-448e-ad30-038cb629bb87 name: "REFERENCES" short-name: "CUSTOMERDATA.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"REFERENCES\"" attributes: ! {} grants: ! - ! &e0ac109d-c843-4ba9-9f60-ef2fb19b60d5 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &81a52330-4c6d-4728-9d93-3d6a5bd049e7 name: "SELECT" short-name: "CUSTOMERDATA.\"SELECT\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"SELECT\"" attributes: ! {} grants: ! - ! &0aec0171-5bf4-421f-93b7-c3f72e6889ae grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &bff2c09f-d53f-4987-bcd6-80b9e62d9810 name: "TRIGGER" short-name: "CUSTOMERDATA.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"TRIGGER\"" attributes: ! {} grants: ! - ! &566da0af-5d50-4260-9429-1541fa7727ec grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &7d837640-ef97-4ca4-b28f-31987aab8efc name: "UPDATE" short-name: "CUSTOMERDATA.\"UPDATE\"" full-name: "PUBLIC.BOOKS.CUSTOMERDATA.\"UPDATE\"" attributes: ! {} grants: ! - ! &7c02d566-049a-48bb-98aa-b34629c33c07 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 referenced-objects: ! - *de3d92ec-efe6-4a77-a645-cb99794bfff2 referenced-tables: ! - *de3d92ec-efe6-4a77-a645-cb99794bfff2 remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false table-constraints: ! - *24cc9694-08df-4160-b4f4-b6735c719322 - *cbf75858-498f-4d2c-9179-238fe55fb16a - ! &3e55decc-2c86-42a7-bfc2-94dffa1d8ee5 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: ! - *5a096929-5fe6-4a3a-8a63-240d3be43a93 deferrable: false definition: "BOOKS.CUSTOMERDATA.CUSTOMERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" - ! &d5aac1eb-c8b9-4d7e-b078-78d893bbd6de 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: ! - *3f80eb2b-0c4d-47c0-b835-f2c9a14e3432 deferrable: false definition: "BOOKS.CUSTOMERDATA.DATAID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! [] - *de3d92ec-efe6-4a77-a645-cb99794bfff2 - ! &c50c4095-e9bf-4376-97d9-6ab7a9d7747d name: "PUBLISHERS" full-name: "PUBLIC.BOOKS.PUBLISHERS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "List of book publishers" columns: ! - *8595e15a-42f9-41fc-8f82-e936545b3607 - *b3615882-1938-4b78-b41d-febdcbe2be17 definition: "" dependent-tables: ! - ! &16872f68-fc64-4868-bcd9-e0cd02e41499 name: "ΒΙΒΛΊΑ" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *c2f6d73f-9b1c-4d68-ba2e-2bc5737729a4 - *b1e1671d-b253-452e-8ff5-5a35450f71f3 - *5b0dbc61-7efe-4ab0-8fee-02760d9c2f84 - *705b89ea-4421-4e5e-9e46-dd6dcf87d2a3 definition: "" dependent-tables: ! [] foreign-keys: ! - ! &edb2d1db-106b-4376-a881-743a83d46956 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: ! - ! &4824214e-7a6f-4dfc-8937-7d5ec731904f foreign-key-column: *705b89ea-4421-4e5e-9e46-dd6dcf87d2a3 key-sequence: 1 primary-key-column: *8595e15a-42f9-41fc-8f82-e936545b3607 self-referencing: false constrained-columns: ! - *705b89ea-4421-4e5e-9e46-dd6dcf87d2a3 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *16872f68-fc64-4868-bcd9-e0cd02e41499 foreign-key-table: *16872f68-fc64-4868-bcd9-e0cd02e41499 initially-deferred: false optional: false parent-partial: false primary-key-table: *c50c4095-e9bf-4376-97d9-6ab7a9d7747d referenced-table: *c50c4095-e9bf-4376-97d9-6ab7a9d7747d remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - *edb2d1db-106b-4376-a881-743a83d46956 - ! &08906c4f-b765-4d1d-81da-408b4214e27d 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: ! - *c2f6d73f-9b1c-4d68-ba2e-2bc5737729a4 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: true primary-key: *08906c4f-b765-4d1d-81da-408b4214e27d privileges: ! - ! &a08e05c0-feaf-434f-90e4-2c0ab169a80e name: "DELETE" short-name: "ΒΙΒΛΊΑ.\"DELETE\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"DELETE\"" attributes: ! {} grants: ! - ! &eb657a0d-9a14-4d0d-9df2-c7566f2c5664 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &b4b11571-2422-4d01-9758-54715c163661 name: "INSERT" short-name: "ΒΙΒΛΊΑ.\"INSERT\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"INSERT\"" attributes: ! {} grants: ! - ! &54f233ec-08e7-4d84-aa79-75bad6d608e2 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &992f4e08-5a08-4eb0-8726-56e5b8a890f5 name: "REFERENCES" short-name: "ΒΙΒΛΊΑ.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"REFERENCES\"" attributes: ! {} grants: ! - ! &dbabee7a-16c9-421d-9c41-3c8ca4484ab3 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &06ac2a7f-d35d-4945-9137-f6080a64994e name: "SELECT" short-name: "ΒΙΒΛΊΑ.\"SELECT\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"SELECT\"" attributes: ! {} grants: ! - ! &79d298d8-418b-4114-9791-5965c8cb78e6 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &d797045f-2560-4152-99e8-55328d300e27 name: "TRIGGER" short-name: "ΒΙΒΛΊΑ.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"TRIGGER\"" attributes: ! {} grants: ! - ! &186284a8-7f6c-46bf-a100-0118e55815f2 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &75f04b4f-c158-4fc6-afb1-3eef79afd502 name: "UPDATE" short-name: "ΒΙΒΛΊΑ.\"UPDATE\"" full-name: "PUBLIC.BOOKS.ΒΙΒΛΊΑ.\"UPDATE\"" attributes: ! {} grants: ! - ! &e3fb2eee-cbf9-4c7a-b4f5-6dd797999e76 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 referenced-objects: ! - *c50c4095-e9bf-4376-97d9-6ab7a9d7747d referenced-tables: ! - *c50c4095-e9bf-4376-97d9-6ab7a9d7747d remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false table-constraints: ! - *08906c4f-b765-4d1d-81da-408b4214e27d - *edb2d1db-106b-4376-a881-743a83d46956 - ! &51169218-9bd0-472c-8202-d445c773eb84 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: ! - *c2f6d73f-9b1c-4d68-ba2e-2bc5737729a4 deferrable: false definition: "BOOKS.ΒΙΒΛΊΑ.ΜΟΝΑΔΙΚΌΣ IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" - ! &478bd030-b08e-4d75-b0db-56c5a7ad9ed9 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: ! - *b1e1671d-b253-452e-8ff5-5a35450f71f3 deferrable: false definition: "BOOKS.ΒΙΒΛΊΑ.ΤΊΤΛΟΣ IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" - ! &cb7c05c4-ceda-4f85-92d2-1ba020b26766 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: ! - *705b89ea-4421-4e5e-9e46-dd6dcf87d2a3 deferrable: false definition: "BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! [] foreign-keys: ! - *edb2d1db-106b-4376-a881-743a83d46956 hidden-columns: ! [] indexes: ! - ! &914e1e61-0eec-4571-9cf7-897d82bbe338 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: ! - *8595e15a-42f9-41fc-8f82-e936545b3607 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 type: "other" unique: true primary-key: *914e1e61-0eec-4571-9cf7-897d82bbe338 privileges: ! - ! &527daa06-1db2-426f-9232-1ff6deb393e5 name: "DELETE" short-name: "PUBLISHERS.\"DELETE\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"DELETE\"" attributes: ! {} grants: ! - ! &71a42dd1-bad6-45e2-ba12-959350ba2d12 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &6e367f4d-17c4-4381-9f70-b5321f7a2212 name: "INSERT" short-name: "PUBLISHERS.\"INSERT\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"INSERT\"" attributes: ! {} grants: ! - ! &87efe0aa-171c-4421-bf18-d74394dac722 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &729a4566-fe74-4a8a-8111-d7926cc1cf2d name: "REFERENCES" short-name: "PUBLISHERS.\"REFERENCES\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &27eda17d-814d-4a5e-9e01-1c2aab225aef grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &ab226a6a-e6e1-452d-b22f-d609465ad17e name: "SELECT" short-name: "PUBLISHERS.\"SELECT\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"SELECT\"" attributes: ! {} grants: ! - ! &13b542ac-3f6f-4cd0-bd4a-212f57f2c771 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &d1321dc8-d95e-43ba-b7ae-7b0b26f47bd3 name: "TRIGGER" short-name: "PUBLISHERS.\"TRIGGER\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &41b4a3c1-ac1d-47d1-a04c-e9e943a83cea grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 - ! &216d8242-0506-4e2d-ae06-34c1869275ff name: "UPDATE" short-name: "PUBLISHERS.\"UPDATE\"" full-name: "PUBLIC.BOOKS.PUBLISHERS.\"UPDATE\"" attributes: ! {} grants: ! - ! &99614dc4-2aa0-4a38-bc13-ffec6addd1a2 grantable: true grantee: "SA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 referenced-objects: ! [] referenced-tables: ! [] remarks: "List of book publishers" schema: *4dfa5652-c2a4-4439-9cf5-c416083ebb78 self-referencing: false table-constraints: ! - *914e1e61-0eec-4571-9cf7-897d82bbe338 table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! - *16872f68-fc64-4868-bcd9-e0cd02e41499 - *16872f68-fc64-4868-bcd9-e0cd02e41499 - *e5838fcd-919a-400d-85cb-5ae30c8079cb - ! &2216dedd-57bd-4d7a-b54c-883964728141 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: ! - *c5952316-ee67-4a85-834f-a9d66e5c99dc - *6c5d5812-157e-461a-b515-5b66d39f8019 - *87457046-ddae-4ef0-b2f0-87dc8f70ac6f definition: "" dependent-tables: ! [] foreign-keys: ! - ! &4b953a93-040b-4670-abb1-40001c7c6df9 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: ! - ! &6e562d7f-762b-4846-9b75-ac3841644b3c foreign-key-column: *6c5d5812-157e-461a-b515-5b66d39f8019 key-sequence: 1 primary-key-column: *0e04c0c3-77ce-447e-bda5-df6b85609f3e self-referencing: false constrained-columns: ! - *6c5d5812-157e-461a-b515-5b66d39f8019 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *2216dedd-57bd-4d7a-b54c-883964728141 foreign-key-table: *2216dedd-57bd-4d7a-b54c-883964728141 initially-deferred: false optional: false parent-partial: false primary-key-table: ! &dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 name: "PUBLICATIONS" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *0e04c0c3-77ce-447e-bda5-df6b85609f3e - *25ea0ac5-9509-4108-9155-4badc4577523 - *8c2f81ee-391d-4165-b1ad-2f39a57c1d10 - *8341945a-acbc-4fac-aa59-17773bd485f6 - *aecb5a8f-abbb-498d-915d-d7d58829bda6 - *c734e1cd-6f88-49a5-89f5-b11d19711f8b - *fafc1275-33be-4d4f-aa07-814705f42eea - *dc4f4f24-37d5-4f48-9f38-bfe7d0dd9f9e definition: "" dependent-tables: ! - *2216dedd-57bd-4d7a-b54c-883964728141 - ! &ad68b66c-689e-4880-854f-46762df5fdba name: "PUBLICATIONWRITERS" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *b74fdee1-c7c2-4ef7-8b8d-8678852f7258 - *de9248eb-3610-47ed-af27-c642ca0df1f7 definition: "" dependent-tables: ! [] foreign-keys: ! - ! &12f70c83-6676-43ba-bca0-93b9cbf267f4 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: ! - ! &fcf25509-8d80-48b2-b486-598a5a5756e2 foreign-key-column: *b74fdee1-c7c2-4ef7-8b8d-8678852f7258 key-sequence: 1 primary-key-column: *0e04c0c3-77ce-447e-bda5-df6b85609f3e self-referencing: false constrained-columns: ! - *b74fdee1-c7c2-4ef7-8b8d-8678852f7258 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *ad68b66c-689e-4880-854f-46762df5fdba foreign-key-table: *ad68b66c-689e-4880-854f-46762df5fdba initially-deferred: false optional: false parent-partial: false primary-key-table: *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 referenced-table: *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: false type: "foreign_key" update-rule: "no action" - ! &3fe1d7ba-6550-470d-90b6-72aa7a1c295f 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: ! - ! &2e9a9903-bb87-45ce-9115-4984a0294044 foreign-key-column: *de9248eb-3610-47ed-af27-c642ca0df1f7 key-sequence: 1 primary-key-column: *94ddadaa-3105-4029-8010-0cf7435ba1e9 self-referencing: false constrained-columns: ! - *de9248eb-3610-47ed-af27-c642ca0df1f7 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *ad68b66c-689e-4880-854f-46762df5fdba foreign-key-table: *ad68b66c-689e-4880-854f-46762df5fdba initially-deferred: false optional: false parent-partial: false primary-key-table: ! &eb13d8c6-5832-4851-8971-b40d9483e834 name: "WRITERS" full-name: "PUBLIC.FOR_LINT.WRITERS" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *94ddadaa-3105-4029-8010-0cf7435ba1e9 - *2c489647-cfc7-442a-8d49-6b54cf94127d - *94b9e514-1795-4ae3-bc67-100f5f2e3b29 - *93e5525e-26a5-4f2d-b0f7-a7868ebd127d - *80f7d1eb-1ef3-47ac-b4ce-7c96264ac23f - *801f40b6-a05a-4d60-9367-ef4b90b8f880 - *af5dd347-c490-43ad-a664-65f3b5e441e1 - *9edfade4-8a9a-4bf4-b4bc-01ff05131269 - *29402224-b724-4cec-993b-1d8040c57b7f - *e69cb4d3-95d9-4b90-8edf-cf9bd44e9a45 - *27659ce6-69f2-4ad0-864a-30cb98aff5b1 - *6862bdfa-d94c-4bcd-98fd-439965fdc72a - *93bd9eed-7963-47ef-9007-e485eb634368 - *05e50c15-e2b0-4b0b-a1f3-74c2f1ae314b - *79070f5f-e5ad-4e22-add2-c13bc8cda5ba - *0f581389-123f-4916-ae24-8f7183d1145f - *2677bddc-8060-48b3-8b4a-51dd838fbb03 - *1674f6ad-df76-4c0d-bf0a-94866ae2f3e4 definition: "" dependent-tables: ! - *2216dedd-57bd-4d7a-b54c-883964728141 - *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 - *ad68b66c-689e-4880-854f-46762df5fdba foreign-keys: ! - ! &b25b4887-165a-490e-a9b9-f474ba95384b 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: ! - ! &79204bbe-347b-443b-b9a6-3c8550951e33 foreign-key-column: *1674f6ad-df76-4c0d-bf0a-94866ae2f3e4 key-sequence: 1 primary-key-column: *0e04c0c3-77ce-447e-bda5-df6b85609f3e self-referencing: false constrained-columns: ! - *1674f6ad-df76-4c0d-bf0a-94866ae2f3e4 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *eb13d8c6-5832-4851-8971-b40d9483e834 foreign-key-table: *eb13d8c6-5832-4851-8971-b40d9483e834 initially-deferred: false optional: false parent-partial: false primary-key-table: *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 referenced-table: *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: false type: "foreign_key" update-rule: "no action" - ! &c376632f-2a99-4dac-ba61-996c6840715d 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: ! - ! &6caa00bd-82c5-4bef-b8e1-afc38696cbf9 foreign-key-column: *c5952316-ee67-4a85-834f-a9d66e5c99dc key-sequence: 1 primary-key-column: *94ddadaa-3105-4029-8010-0cf7435ba1e9 self-referencing: false constrained-columns: ! - *c5952316-ee67-4a85-834f-a9d66e5c99dc deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *2216dedd-57bd-4d7a-b54c-883964728141 foreign-key-table: *2216dedd-57bd-4d7a-b54c-883964728141 initially-deferred: false optional: false parent-partial: false primary-key-table: *eb13d8c6-5832-4851-8971-b40d9483e834 referenced-table: *eb13d8c6-5832-4851-8971-b40d9483e834 remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: false type: "foreign_key" update-rule: "no action" - ! &96efe11d-3a4f-46e2-96c1-e5d2bb1b685c 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: ! - ! &f9a3f66a-25f7-4afc-b3b4-eafb5b2f15a1 foreign-key-column: *8341945a-acbc-4fac-aa59-17773bd485f6 key-sequence: 1 primary-key-column: *94ddadaa-3105-4029-8010-0cf7435ba1e9 self-referencing: false constrained-columns: ! - *8341945a-acbc-4fac-aa59-17773bd485f6 deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 foreign-key-table: *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 initially-deferred: false optional: false parent-partial: false primary-key-table: *eb13d8c6-5832-4851-8971-b40d9483e834 referenced-table: *eb13d8c6-5832-4851-8971-b40d9483e834 remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: false type: "foreign_key" update-rule: "no action" - *3fe1d7ba-6550-470d-90b6-72aa7a1c295f hidden-columns: ! [] indexes: ! - ! &35683718-f6ea-4ab5-bb10-94362da1ad2c 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: ! - *94ddadaa-3105-4029-8010-0cf7435ba1e9 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "other" unique: true - *b25b4887-165a-490e-a9b9-f474ba95384b - ! &64bb7b83-2468-489b-b45a-8b5e026c86e0 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: ! - *801f40b6-a05a-4d60-9367-ef4b90b8f880 - *af5dd347-c490-43ad-a664-65f3b5e441e1 definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "other" unique: false - ! &abafe9df-ffe8-45a2-853f-ed9b7edab659 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: ! - *6862bdfa-d94c-4bcd-98fd-439965fdc72a - *29402224-b724-4cec-993b-1d8040c57b7f definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "other" unique: true - ! &6bf3f9e5-d503-48b4-8831-89407a43f420 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: ! - *94b9e514-1795-4ae3-bc67-100f5f2e3b29 - *2c489647-cfc7-442a-8d49-6b54cf94127d definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "other" unique: false - ! &b457cfc8-b9a7-4956-a871-bac836f11e30 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: ! - *801f40b6-a05a-4d60-9367-ef4b90b8f880 - *af5dd347-c490-43ad-a664-65f3b5e441e1 - *9edfade4-8a9a-4bf4-b4bc-01ff05131269 - *29402224-b724-4cec-993b-1d8040c57b7f definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "other" unique: false primary-key: *35683718-f6ea-4ab5-bb10-94362da1ad2c privileges: ! - ! &83952c0a-9fe0-4352-8fea-33b24c820879 name: "DELETE" short-name: "WRITERS.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"DELETE\"" attributes: ! {} grants: ! - ! &7191b474-de29-45b8-9e98-b48a4796b741 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &00690771-6bb9-4658-baad-ff5d5f69bcf5 name: "INSERT" short-name: "WRITERS.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"INSERT\"" attributes: ! {} grants: ! - ! &a6ff67ba-b96d-4f1d-b5b2-58b521386f15 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &b9068451-e867-4d96-8536-eb5b69df27a0 name: "REFERENCES" short-name: "WRITERS.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &39142d7e-c3db-4718-8666-2a9d37db861d grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &d505f00e-bcc1-4294-a293-bfda864ef67b name: "SELECT" short-name: "WRITERS.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"SELECT\"" attributes: ! {} grants: ! - ! &0173699f-ec1b-4054-afdd-f8c1c8f15e67 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &be5f2c08-e0c3-4ee6-bd8b-f6f0cca55169 name: "TRIGGER" short-name: "WRITERS.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &35d2ae24-139d-4066-949e-2492b964a222 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &d4089a59-85f4-4e47-9c3c-9b420c288c84 name: "UPDATE" short-name: "WRITERS.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.WRITERS.\"UPDATE\"" attributes: ! {} grants: ! - ! &f3b400a1-0065-4266-8ad0-8748fe08480e grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df referenced-objects: ! - *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 referenced-tables: ! - *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: false table-constraints: ! - *35683718-f6ea-4ab5-bb10-94362da1ad2c - *b25b4887-165a-490e-a9b9-f474ba95384b - ! &5fabc462-b980-452a-b6bb-adfc1531bee7 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: ! - *af5dd347-c490-43ad-a664-65f3b5e441e1 deferrable: false definition: "FOR_LINT.WRITERS.STATE=UPPER(FOR_LINT.WRITERS.STATE)" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" - ! &41558034-d20f-47e9-81fa-6adffd843c86 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: ! - *94ddadaa-3105-4029-8010-0cf7435ba1e9 deferrable: false definition: "FOR_LINT.WRITERS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" - ! &0854176b-c469-4f73-b7f5-efbb695b9f98 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: ! - *2c489647-cfc7-442a-8d49-6b54cf94127d deferrable: false definition: "FOR_LINT.WRITERS.FIRSTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" - ! &0530032d-33f9-4ba1-a8fb-efc2f82bb8fa 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: ! - *94b9e514-1795-4ae3-bc67-100f5f2e3b29 deferrable: false definition: "FOR_LINT.WRITERS.LASTNAME IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" - ! &44ef6919-3560-4d35-9ae8-ddab21c2d5c3 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: ! - *80f7d1eb-1ef3-47ac-b4ce-7c96264ac23f deferrable: false definition: "FOR_LINT.WRITERS.ADDRESS2 IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" - ! &59ad137d-10bd-43ff-a3ba-0618d0e71ebb 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: ! - *1674f6ad-df76-4c0d-bf0a-94866ae2f3e4 deferrable: false definition: "FOR_LINT.WRITERS.PUBLICATION_ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! - *ad68b66c-689e-4880-854f-46762df5fdba - *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 - *2216dedd-57bd-4d7a-b54c-883964728141 referenced-table: *eb13d8c6-5832-4851-8971-b40d9483e834 remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: false type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - *3fe1d7ba-6550-470d-90b6-72aa7a1c295f - *12f70c83-6676-43ba-bca0-93b9cbf267f4 primary-key: null privileges: ! - ! &b5cf0b1f-6238-4669-8322-b7a4331d2cb7 name: "DELETE" short-name: "PUBLICATIONWRITERS.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"DELETE\"" attributes: ! {} grants: ! - ! &8d060e73-6d81-4836-bae8-88bca8bffc2c grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &814ee3a8-40cf-4fcf-aef9-288728836690 name: "INSERT" short-name: "PUBLICATIONWRITERS.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"INSERT\"" attributes: ! {} grants: ! - ! &2b369615-33be-4fe5-aca9-cebbb456b760 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &93a55df7-9f55-40c1-bea1-a0c263b6d34d name: "REFERENCES" short-name: "PUBLICATIONWRITERS.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &aa091821-9c14-4c56-bc58-d0e723f6af79 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &ff7bfe25-cf91-4492-8d55-b6c958f696d9 name: "SELECT" short-name: "PUBLICATIONWRITERS.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"SELECT\"" attributes: ! {} grants: ! - ! &7ef2d11d-a410-4a27-8d7a-58f11b3feb02 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &ebe1553b-1287-40a8-855f-173c7cb8d652 name: "TRIGGER" short-name: "PUBLICATIONWRITERS.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &c6633b9f-2cdd-447b-ab57-79aeb44c30a8 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &4cc0e650-8c44-47e1-9f7d-660c4c679840 name: "UPDATE" short-name: "PUBLICATIONWRITERS.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONWRITERS.\"UPDATE\"" attributes: ! {} grants: ! - ! &010ec462-f408-4bd5-a15d-29141d0364f4 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df referenced-objects: ! - *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 - *eb13d8c6-5832-4851-8971-b40d9483e834 referenced-tables: ! - *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 - *eb13d8c6-5832-4851-8971-b40d9483e834 remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: false table-constraints: ! - *12f70c83-6676-43ba-bca0-93b9cbf267f4 - *3fe1d7ba-6550-470d-90b6-72aa7a1c295f - ! &0b9f9571-f694-43fa-9f9b-82e69e6539d7 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: ! - *b74fdee1-c7c2-4ef7-8b8d-8678852f7258 deferrable: false definition: "FOR_LINT.PUBLICATIONWRITERS.PUBLICATIONID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" - ! &b1431a1d-39c7-40f7-a27f-01bfd8217ee5 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: ! - *de9248eb-3610-47ed-af27-c642ca0df1f7 deferrable: false definition: "FOR_LINT.PUBLICATIONWRITERS.WRITERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! [] - *eb13d8c6-5832-4851-8971-b40d9483e834 foreign-keys: ! - *96efe11d-3a4f-46e2-96c1-e5d2bb1b685c - *4b953a93-040b-4670-abb1-40001c7c6df9 - *12f70c83-6676-43ba-bca0-93b9cbf267f4 - *b25b4887-165a-490e-a9b9-f474ba95384b hidden-columns: ! [] indexes: ! - *96efe11d-3a4f-46e2-96c1-e5d2bb1b685c - ! &305be1a7-d4a7-4929-8dbf-e1a8ee1cfe19 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: ! - *0e04c0c3-77ce-447e-bda5-df6b85609f3e definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "other" unique: true primary-key: *305be1a7-d4a7-4929-8dbf-e1a8ee1cfe19 privileges: ! - ! &8a50ad4a-315c-4a67-8bb5-03e14b1a40a8 name: "DELETE" short-name: "PUBLICATIONS.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"DELETE\"" attributes: ! {} grants: ! - ! &792d7751-3cb9-43c0-99fc-c35e5cc3559c grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &4ef7f6b5-410f-4ea3-87c8-7705818c9f1c name: "INSERT" short-name: "PUBLICATIONS.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"INSERT\"" attributes: ! {} grants: ! - ! &244ad9bf-d620-4170-abb8-903e33caca2d grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &dc47da06-f1ed-4480-9919-4f46ede8c803 name: "REFERENCES" short-name: "PUBLICATIONS.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"REFERENCES\"" attributes: ! {} grants: ! - ! &109aacdf-4c9b-46cb-b1c4-b97b328232dd grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &8ed03827-6957-4400-a3db-478d964004f0 name: "SELECT" short-name: "PUBLICATIONS.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"SELECT\"" attributes: ! {} grants: ! - ! &433bb397-7ea1-4bef-a0c1-aa78e1e922c3 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &773b3be9-c3c8-4bb1-9584-408d3cb3de78 name: "TRIGGER" short-name: "PUBLICATIONS.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.PUBLICATIONS.\"TRIGGER\"" attributes: ! {} grants: ! - ! &d02c6b11-753c-4e0b-8035-df2583d9fafe grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - *fafc1275-33be-4d4f-aa07-814705f42eea referenced-objects: ! - *eb13d8c6-5832-4851-8971-b40d9483e834 referenced-tables: ! - *eb13d8c6-5832-4851-8971-b40d9483e834 remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: false table-constraints: ! - *305be1a7-d4a7-4929-8dbf-e1a8ee1cfe19 - *96efe11d-3a4f-46e2-96c1-e5d2bb1b685c - ! &400a49af-7bf0-4f5f-be44-dd20a59f03c0 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: ! - *0e04c0c3-77ce-447e-bda5-df6b85609f3e deferrable: false definition: "FOR_LINT.PUBLICATIONS.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" - ! &bb646939-7d4e-40eb-9e1d-eb10a7d540a5 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: ! - *25ea0ac5-9509-4108-9155-4badc4577523 deferrable: false definition: "FOR_LINT.PUBLICATIONS.TITLE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" - ! &cc2a3c11-e425-42c8-9b89-e635eae7f3cd 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: ! - *8341945a-acbc-4fac-aa59-17773bd485f6 deferrable: false definition: "FOR_LINT.PUBLICATIONS.WRITERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! - *eb13d8c6-5832-4851-8971-b40d9483e834 - *2216dedd-57bd-4d7a-b54c-883964728141 - *ad68b66c-689e-4880-854f-46762df5fdba referenced-table: *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: false type: "foreign_key" update-rule: "no action" - *c376632f-2a99-4dac-ba61-996c6840715d hidden-columns: ! [] indexes: ! - *c376632f-2a99-4dac-ba61-996c6840715d - ! &40828e49-ce74-4ebb-9aba-c9ecaadf6181 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: ! - *87457046-ddae-4ef0-b2f0-87dc8f70ac6f definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "other" unique: true - *4b953a93-040b-4670-abb1-40001c7c6df9 primary-key: *40828e49-ce74-4ebb-9aba-c9ecaadf6181 privileges: ! - ! &32575973-b9fa-4ec7-a336-4e45455f76fd name: "DELETE" short-name: "EXTRA_PK.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"DELETE\"" attributes: ! {} grants: ! - ! &46f8fbf0-2dac-4140-b648-53621ef57435 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &f29629db-391e-4463-bf1d-1917dc27c5cc name: "INSERT" short-name: "EXTRA_PK.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"INSERT\"" attributes: ! {} grants: ! - ! &8f2fa830-d3b9-4a4e-ae6d-a54b63bb2eca grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &1d4bd2d7-e8ab-44ea-b725-aae897bc4fb4 name: "REFERENCES" short-name: "EXTRA_PK.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"REFERENCES\"" attributes: ! {} grants: ! - ! &06e79b86-3d25-45ce-b2d4-62774d0af62b grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &eb1a5e9e-1368-4ac9-a54c-d387ebe72373 name: "SELECT" short-name: "EXTRA_PK.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"SELECT\"" attributes: ! {} grants: ! - ! &63a4b37c-76cb-45c5-9c95-eddaa355ab17 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &3ecd4a04-3517-48e0-9f56-e9ca4dfc9b42 name: "TRIGGER" short-name: "EXTRA_PK.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"TRIGGER\"" attributes: ! {} grants: ! - ! &6ea972d0-95ff-488d-b497-2d8e6c2da1f4 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &bac14373-f93f-45ec-833e-955bf4387bd9 name: "UPDATE" short-name: "EXTRA_PK.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.EXTRA_PK.\"UPDATE\"" attributes: ! {} grants: ! - ! &ef2c482f-2f7b-449e-9178-ab4a21fbf32d grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df referenced-objects: ! - *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 - *eb13d8c6-5832-4851-8971-b40d9483e834 referenced-tables: ! - *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 - *eb13d8c6-5832-4851-8971-b40d9483e834 remarks: "Extra table with just a primary key" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: false table-constraints: ! - *40828e49-ce74-4ebb-9aba-c9ecaadf6181 - *4b953a93-040b-4670-abb1-40001c7c6df9 - *c376632f-2a99-4dac-ba61-996c6840715d - ! &ad6ed20f-64d9-48e1-85ae-6a900662b1c2 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: ! - *c5952316-ee67-4a85-834f-a9d66e5c99dc deferrable: false definition: "FOR_LINT.EXTRA_PK.WRITERID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" - ! &9ec360a6-b001-472a-bdea-e4b4c575d613 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: ! - *6c5d5812-157e-461a-b515-5b66d39f8019 deferrable: false definition: "FOR_LINT.EXTRA_PK.PUBLICATIONID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" - ! &6cc2cb6b-1582-42c5-9532-f1dc8749e5a1 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: ! - *87457046-ddae-4ef0-b2f0-87dc8f70ac6f deferrable: false definition: "FOR_LINT.EXTRA_PK.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! [] - ! &1fba7e77-8401-4e0b-9dd5-314c583cde54 name: "Global Counts" full-name: "PUBLIC.FOR_LINT.\"Global Counts\"" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *0138b7d5-1448-4008-b94b-74c4e7695e6c definition: "" dependent-tables: ! [] foreign-keys: ! [] hidden-columns: ! [] indexes: ! [] primary-key: null privileges: ! - ! &d6952df4-ad4c-4b82-b5a6-c1c1d3b543f3 name: "DELETE" short-name: "\"Global Counts\".\"DELETE\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"DELETE\"" attributes: ! {} grants: ! - ! &e1945b31-f1f1-47d2-8d05-dcd3af476025 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &9a74cb34-83a0-4432-a599-31e21f722d68 name: "INSERT" short-name: "\"Global Counts\".\"INSERT\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"INSERT\"" attributes: ! {} grants: ! - ! &6f9e8a76-ce2d-4661-8026-4c6f7f2a30c7 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &5a18a6e9-019b-4ca6-a213-fe78f1471da4 name: "REFERENCES" short-name: "\"Global Counts\".\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"REFERENCES\"" attributes: ! {} grants: ! - ! &dd40cf0c-897d-4c38-92a7-550b4c2d3ffd grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &549a918f-f597-456f-a6f3-94639c7ac5dc name: "SELECT" short-name: "\"Global Counts\".\"SELECT\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"SELECT\"" attributes: ! {} grants: ! - ! &ca10efdd-8e40-43fd-9402-d031ef98486d grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &9d177cba-fe67-4c11-9c0f-0a90db5f5016 name: "TRIGGER" short-name: "\"Global Counts\".\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"TRIGGER\"" attributes: ! {} grants: ! - ! &c68eeb38-8338-4789-9a8e-c65523bdec7d grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &34dc90df-72fc-4564-8f1d-f8ba9c002997 name: "UPDATE" short-name: "\"Global Counts\".\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.\"Global Counts\".\"UPDATE\"" attributes: ! {} grants: ! - ! &8c1fe672-0873-431f-89c6-ad6fbeb1bc87 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df referenced-objects: ! [] referenced-tables: ! [] remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: false table-constraints: ! [] table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! [] - *dc0476a0-32d4-41f7-9e95-ed78bb6fefc2 - *ad68b66c-689e-4880-854f-46762df5fdba - ! &54f71adb-e000-4fce-aed1-5d26b42fdb75 name: "SELFREFERENCE" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE" attributes: ! HSQLDB_TYPE: "MEMORY" READ_ONLY: false REMARKS: "" columns: ! - *412f830d-b3da-4dd7-be00-203e0ef01c7c - *7ca83ff9-1bb6-4a04-bda5-c3b185043ef7 definition: "" dependent-tables: ! - *54f71adb-e000-4fce-aed1-5d26b42fdb75 foreign-keys: ! - ! &689e7a7a-80d5-4136-8f17-0def4fd926bd 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: ! - ! &fa3e54e6-6692-4b93-b371-f0282cb708dd foreign-key-column: *412f830d-b3da-4dd7-be00-203e0ef01c7c key-sequence: 1 primary-key-column: *412f830d-b3da-4dd7-be00-203e0ef01c7c self-referencing: true constrained-columns: ! - *412f830d-b3da-4dd7-be00-203e0ef01c7c deferrability: "not deferrable" deferrable: false definition: "" delete-rule: "no action" dependent-table: *54f71adb-e000-4fce-aed1-5d26b42fdb75 foreign-key-table: *54f71adb-e000-4fce-aed1-5d26b42fdb75 initially-deferred: false optional: false parent-partial: false primary-key-table: *54f71adb-e000-4fce-aed1-5d26b42fdb75 referenced-table: *54f71adb-e000-4fce-aed1-5d26b42fdb75 remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: true type: "foreign_key" update-rule: "no action" hidden-columns: ! [] indexes: ! - ! &bb85cd8e-7873-4a6c-a81a-436c592e824d 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: ! - *412f830d-b3da-4dd7-be00-203e0ef01c7c definition: "" filter-condition: "" index-type: "other" pages: 0 parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "other" unique: true - *689e7a7a-80d5-4136-8f17-0def4fd926bd primary-key: *bb85cd8e-7873-4a6c-a81a-436c592e824d privileges: ! - ! &41d3a46a-d715-4e65-a3ff-5f6a969fa83a name: "DELETE" short-name: "SELFREFERENCE.\"DELETE\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"DELETE\"" attributes: ! {} grants: ! - ! &d26a0848-a6ab-4920-9c27-7b593e34fcee grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &c414ebe4-dc1d-45c9-a254-cc923c9a5575 name: "INSERT" short-name: "SELFREFERENCE.\"INSERT\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"INSERT\"" attributes: ! {} grants: ! - ! &e24ed587-1ca5-44b4-9eae-c20d4c341a0d grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &e9379d5b-de4d-4b4b-9bf3-2e4e7273deb4 name: "REFERENCES" short-name: "SELFREFERENCE.\"REFERENCES\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"REFERENCES\"" attributes: ! {} grants: ! - ! &3dc850b2-70ef-4222-921c-f0e3695fb89c grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &b84e1e25-8e98-4163-880b-de28233f29fd name: "SELECT" short-name: "SELFREFERENCE.\"SELECT\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"SELECT\"" attributes: ! {} grants: ! - ! &955ee07f-2d78-464c-bcd0-51b7b4562c43 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &27293b7d-af38-486d-9de0-8f8bf7183217 name: "TRIGGER" short-name: "SELFREFERENCE.\"TRIGGER\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"TRIGGER\"" attributes: ! {} grants: ! - ! &3dd4684a-aa5c-4d48-82da-f7e437f5b306 grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df - ! &cc277f96-ca5a-46c6-8ee1-16dfcde3f1ab name: "UPDATE" short-name: "SELFREFERENCE.\"UPDATE\"" full-name: "PUBLIC.FOR_LINT.SELFREFERENCE.\"UPDATE\"" attributes: ! {} grants: ! - ! &4020e779-8c42-4896-be2b-6446fa6513db grantable: true grantee: "DBA" grantor: "_SYSTEM" parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df referenced-objects: ! - *54f71adb-e000-4fce-aed1-5d26b42fdb75 referenced-tables: ! - *54f71adb-e000-4fce-aed1-5d26b42fdb75 remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df self-referencing: true table-constraints: ! - *bb85cd8e-7873-4a6c-a81a-436c592e824d - *689e7a7a-80d5-4136-8f17-0def4fd926bd - ! &d90ebaf8-c94c-4192-88a5-00a75422026f 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: ! - *412f830d-b3da-4dd7-be00-203e0ef01c7c deferrable: false definition: "FOR_LINT.SELFREFERENCE.ID IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" - ! &75ab37a5-0f1c-4c27-bb40-f337e0ae6fd1 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: ! - *7ca83ff9-1bb6-4a04-bda5-c3b185043ef7 deferrable: false definition: "FOR_LINT.SELFREFERENCE.TITLE IS NOT NULL" initially-deferred: false parent-partial: false remarks: "" schema: *91410f91-9c9c-4de8-a841-ef760f03e8df type: "check" table-type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 triggers: ! [] type: *a6974ca4-151c-4dfa-a413-6d8319e28ad2 used-by-objects: ! - *54f71adb-e000-4fce-aed1-5d26b42fdb75 - *eb13d8c6-5832-4851-8971-b40d9483e834 - *0d3ccc54-97ce-4614-94e5-e165861b9658 - *ae96aeff-22c4-4af9-ae4b-42a37970c15e - *40a4a098-b7a6-45d1-9035-f70517bd218f