{"version":"91200","data":{"id":"8b0d20d9-0b68-4170-86e9-0c8d84041cb1","offsetX":444.3271619365606,"offsetY":228.18711101836385,"zoom":58.05000000000003,"gridSize":15,"layers":[{"id":"5daebfad-7c01-4534-910d-552a29e219bc","type":"diagram-links","isSvg":true,"transformed":true,"models":{"cf8685f6-c212-42eb-b077-082029afeb0b":{"id":"cf8685f6-c212-42eb-b077-082029afeb0b","locked":true,"type":"onetomany","source":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","sourcePort":"341d387b-1931-4a99-ad54-6f0a5c8cba9d","target":"7514ec27-fddf-4ad0-b63c-747cd5c2aa21","targetPort":"e2df5f3f-1ab8-406b-ac70-b0ef740244c1","points":[{"id":"d5a6f025-0dfd-46ad-924b-abb81cc3a8bd","type":"point","x":340.9999397356834,"y":219.24221074436662},{"id":"85433c55-3dbd-487b-9468-18abc4ed19c8","type":"point","x":340.9999397356834,"y":988.6172191557573},{"id":"d9ebd77d-c694-4b66-a855-4981d9da9f3e","type":"point","x":233.99997169896952,"y":988.6172191557573}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"7514ec27-fddf-4ad0-b63c-747cd5c2aa21","local_column_attnum":2,"referenced_table_uid":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced_column_attnum":1}},"8cc3f54d-3d9c-4a2b-bfa7-2c2a706ca81b":{"id":"8cc3f54d-3d9c-4a2b-bfa7-2c2a706ca81b","locked":true,"type":"onetomany","source":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","sourcePort":"35fc9763-0912-46d2-b65d-fee5010bf914","target":"c421084b-7b83-484b-83e6-4a141c5d7130","targetPort":"c408eebd-7e58-4340-a970-46a4af4bd91c","points":[{"id":"90fb3f6f-634f-4974-8e3f-34ef2f3fc702","type":"point","x":578.999904407841,"y":219.24221074436662},{"id":"4bac5018-aaab-480d-9cb8-cf847db319dd","type":"point","x":578.999904407841,"y":1600.3281675905653},{"id":"3a2ce0be-b4ff-4be9-9389-bc52b1a5da38","type":"point","x":1101.0000322609844,"y":1600.3281675905653}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"c421084b-7b83-484b-83e6-4a141c5d7130","local_column_attnum":4,"referenced_table_uid":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced_column_attnum":1}},"e6d260b8-8f1b-4a19-ace8-c5c6ccee61a5":{"id":"e6d260b8-8f1b-4a19-ace8-c5c6ccee61a5","locked":true,"type":"onetomany","source":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","sourcePort":"030cf3b3-3665-44f7-8852-5043a2b39a3b","target":"c421084b-7b83-484b-83e6-4a141c5d7130","targetPort":"1a0bb908-09a3-4f11-95a3-59cfd29573ae","points":[{"id":"eaffa371-3139-4285-bb04-52fe6df8dbdc","type":"point","x":2353.500107963503,"y":852.4375341791746},{"id":"ebd5b8f6-2960-4611-a1ab-e8e416d21ef8","type":"point","x":2353.500107963503,"y":1548.2500913766335},{"id":"911b6048-e9f7-4851-a668-c08af85612a3","type":"point","x":1338.999996933142,"y":1548.2500913766335}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"c421084b-7b83-484b-83e6-4a141c5d7130","local_column_attnum":2,"referenced_table_uid":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","referenced_column_attnum":1}},"c10c4bca-f183-45f6-87be-7458652da0b1":{"id":"c10c4bca-f183-45f6-87be-7458652da0b1","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"9951c26d-4834-496e-8a27-a9b975576c53","target":"c421084b-7b83-484b-83e6-4a141c5d7130","targetPort":"347692f3-0c4f-4231-bb2d-5ead6a1c6795","points":[{"id":"ef404342-9e79-451b-be79-f9bb18c7787c","type":"point","x":2031.000015438202,"y":99.59374801019356},{"id":"14ca4095-79ce-443c-82a8-ff1350dc3acc","type":"point","x":2031.000015438202,"y":1574.2890243412112},{"id":"ddc1c374-6de6-4b83-8e31-79caf33fe9be","type":"point","x":1338.999996933142,"y":1574.2890243412112}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"c421084b-7b83-484b-83e6-4a141c5d7130","local_column_attnum":3,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"208d606a-b532-46eb-a67e-fe8a9782d197":{"id":"208d606a-b532-46eb-a67e-fe8a9782d197","locked":true,"type":"onetomany","source":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","sourcePort":"35fc9763-0912-46d2-b65d-fee5010bf914","target":"615c4925-fd7c-4107-80d2-e72a533429ca","targetPort":"c831f11c-8d29-4302-94c2-3ecddca14908","points":[{"id":"c7380dd7-e961-44ec-ab97-2fd2c775de1e","type":"point","x":578.999904407841,"y":219.24221074436662},{"id":"4493eb22-8772-4d9c-8029-695c3a34bebb","type":"point","x":578.999904407841,"y":1027.6797191557573},{"id":"642a0f4a-8f2b-4117-87da-51adcb2578ac","type":"point","x":483.9999716989694,"y":1027.6797191557573}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"615c4925-fd7c-4107-80d2-e72a533429ca","local_column_attnum":2,"referenced_table_uid":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced_column_attnum":1}},"0078da13-c09f-445b-8379-ef511169b065":{"id":"0078da13-c09f-445b-8379-ef511169b065","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"9951c26d-4834-496e-8a27-a9b975576c53","target":"aed317c1-d1b1-4e3a-a4f4-aa867d6b0752","targetPort":"e984c6f3-640e-457a-8764-9136fe7390a8","points":[{"id":"e09ca580-8ec8-4a2b-81b9-87712d6841c3","type":"point","x":2031.000015438202,"y":99.59374801019356},{"id":"994d27f3-fcdb-450c-9acf-85c3a1a8c318","type":"point","x":2031.000015438202,"y":934.0703996709382},{"id":"f90bfe83-8abc-4c52-b657-a6a9b8748d38","type":"point","x":733.9999716989693,"y":934.0703996709382}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"aed317c1-d1b1-4e3a-a4f4-aa867d6b0752","local_column_attnum":2,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"090c2db5-18f3-48d0-97d5-ec9d47ce383e":{"id":"090c2db5-18f3-48d0-97d5-ec9d47ce383e","locked":true,"type":"onetomany","source":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","sourcePort":"35fc9763-0912-46d2-b65d-fee5010bf914","target":"aed317c1-d1b1-4e3a-a4f4-aa867d6b0752","targetPort":"abce7d03-14cf-433e-acde-5875c31acb18","points":[{"id":"286f69c4-fd01-429d-b348-373e0f180538","type":"point","x":578.999904407841,"y":219.24221074436662},{"id":"403f9d2a-d95c-4e12-8ddd-ac79b3adcb72","type":"point","x":578.999904407841,"y":1064.265695348156},{"id":"228cf635-832a-4b38-9c5f-4ff6aa31fc81","type":"point","x":733.9999716989693,"y":1064.265695348156}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"aed317c1-d1b1-4e3a-a4f4-aa867d6b0752","local_column_attnum":7,"referenced_table_uid":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced_column_attnum":1}},"baa10baa-cd87-4c39-9b0a-9c85f1f8f2ff":{"id":"baa10baa-cd87-4c39-9b0a-9c85f1f8f2ff","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"9951c26d-4834-496e-8a27-a9b975576c53","target":"00de2eae-54f6-42b3-9046-0646dfa88420","targetPort":"57404386-2b99-425c-9874-cb191fec4d1d","points":[{"id":"4cfcb1ca-cea9-4855-8222-a65cacd0bc61","type":"point","x":2031.000015438202,"y":99.59374801019356},{"id":"3e0e6f8b-ea7f-4cf5-8a4b-a365342cb639","type":"point","x":2031.000015438202,"y":1046.687570348156},{"id":"ec383770-f6fb-485d-b01f-a1be1e2c85af","type":"point","x":1213.999996933142,"y":1046.687570348156}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"00de2eae-54f6-42b3-9046-0646dfa88420","local_column_attnum":2,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"14769689-d9e2-49b9-91cb-4c1e43b45789":{"id":"14769689-d9e2-49b9-91cb-4c1e43b45789","locked":true,"type":"onetomany","source":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","sourcePort":"35fc9763-0912-46d2-b65d-fee5010bf914","target":"00de2eae-54f6-42b3-9046-0646dfa88420","targetPort":"2b8cff91-531b-49c5-97d6-83a32c6a2ffe","points":[{"id":"414c25ac-b960-462e-8d3e-4e268210d273","type":"point","x":578.999904407841,"y":219.24221074436662},{"id":"aa8479b8-c519-46c4-9d44-e4e9e08cd6ab","type":"point","x":578.999904407841,"y":1072.726608455122},{"id":"d2c1d607-2482-47d5-b901-adf458a92933","type":"point","x":976.0000322609845,"y":1072.726608455122}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"00de2eae-54f6-42b3-9046-0646dfa88420","local_column_attnum":3,"referenced_table_uid":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced_column_attnum":1}},"a30db3dd-85cf-4c03-a630-3699ef989311":{"id":"a30db3dd-85cf-4c03-a630-3699ef989311","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"9951c26d-4834-496e-8a27-a9b975576c53","target":"2614216b-1183-4b03-b1ee-b0b1300f3288","targetPort":"7dd6671c-ffe4-45ba-ac96-83256211331d","points":[{"id":"654a6fcc-2d41-4b52-b5c5-1edd2ca0ea31","type":"point","x":2031.000015438202,"y":99.59374801019356},{"id":"829ebe4c-2331-4cd2-80b0-ca8f1bd2274c","type":"point","x":2031.000015438202,"y":953.078145720949},{"id":"7e9ebd99-1e34-4512-a7a3-4ca0ef6f48fe","type":"point","x":1694.000022167315,"y":953.078145720949}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"2614216b-1183-4b03-b1ee-b0b1300f3288","local_column_attnum":2,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"5470ce32-ccf0-4fea-b096-e81064daae33":{"id":"5470ce32-ccf0-4fea-b096-e81064daae33","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"9951c26d-4834-496e-8a27-a9b975576c53","target":"5fcabcef-6ccc-4008-bc18-546ff6a846a9","targetPort":"312e27e2-137f-497d-b54f-7c83558873d3","points":[{"id":"ef219c6b-45f7-4dc6-a311-61aa37cb6d4c","type":"point","x":2031.000015438202,"y":99.59374801019356},{"id":"e06cd843-9f19-4c78-b260-348781c5f174","type":"point","x":2031.000015438202,"y":921.0469377779042},{"id":"783edf7e-9b78-43ee-ae41-fb32dccc06f8","type":"point","x":1924.000047401488,"y":921.0469377779042}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"5fcabcef-6ccc-4008-bc18-546ff6a846a9","local_column_attnum":2,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"d1456e8b-fd56-4cc7-9b12-e65c284ebbd0":{"id":"d1456e8b-fd56-4cc7-9b12-e65c284ebbd0","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"9951c26d-4834-496e-8a27-a9b975576c53","target":"37c0b99a-d1b9-491e-99a2-bb37798375f2","targetPort":"e7b14378-496b-46fa-b614-12282476d39b","points":[{"id":"4b0b8975-a68e-4927-a234-aef189c64869","type":"point","x":2031.000015438202,"y":99.59374801019356},{"id":"40045c74-27ba-48d9-ae73-4eeffd5b0cb9","type":"point","x":2031.000015438202,"y":1082.2265625},{"id":"ac45bee2-7ddb-4caa-8543-0ce3084a32ad","type":"point","x":964,"y":1082.2265625}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"37c0b99a-d1b9-491e-99a2-bb37798375f2","local_column_attnum":1,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"0b0254cd-c78e-4085-8ec1-80cd34a091fb":{"id":"0b0254cd-c78e-4085-8ec1-80cd34a091fb","locked":true,"type":"onetomany","source":"14e78b9c-c338-48a8-beaf-a2ace5fd5158","sourcePort":"6d5caada-c246-41f2-9618-1b6e0584f3f4","target":"37c0b99a-d1b9-491e-99a2-bb37798375f2","targetPort":"efc6e0d2-c8df-4aee-b062-9b68e58f5400","points":[{"id":"126c9308-1577-4e5a-ad52-8853ae715422","type":"point","x":213.99999693314265,"y":338.89067347853967},{"id":"eec8dcff-d3a3-43b0-a0e2-2d8c36d99f9f","type":"point","x":213.99999693314265,"y":1108.265625},{"id":"5be471e8-c8af-4713-9a6f-4082eb1f5d10","type":"point","x":726,"y":1108.265625}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"37c0b99a-d1b9-491e-99a2-bb37798375f2","local_column_attnum":2,"referenced_table_uid":"14e78b9c-c338-48a8-beaf-a2ace5fd5158","referenced_column_attnum":1}},"a6c73c4d-70a4-4d9d-a4db-37db68e81e2a":{"id":"a6c73c4d-70a4-4d9d-a4db-37db68e81e2a","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"44e62f92-2a77-4012-933d-43051e4663a1","target":"80fb15db-c539-4dcb-bdc8-6921b68805c6","targetPort":"b93a3448-6820-4990-9798-cfcb51459b74","points":[{"id":"00ac3034-7312-4648-bf60-67d74b0c01e5","type":"point","x":2268.9999801103595,"y":99.59374801019356},{"id":"947e223d-d647-4e73-b3e0-40dd6e6bdc73","type":"point","x":2268.9999801103595,"y":2094.8672822411895},{"id":"9a4e114b-59d9-4249-9dd9-9d5f024902bb","type":"point","x":2246.4999296420133,"y":2094.8672822411895}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"80fb15db-c539-4dcb-bdc8-6921b68805c6","local_column_attnum":3,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"f2515855-4b0f-4860-8677-b297c9b34c4a":{"id":"f2515855-4b0f-4860-8677-b297c9b34c4a","locked":true,"type":"onetomany","source":"0d6ef88b-4dac-4524-8c59-807af87879bd","sourcePort":"4e35dcd2-de06-4c9f-9086-9ffb5a954473","target":"80fb15db-c539-4dcb-bdc8-6921b68805c6","targetPort":"c398d20f-0948-478c-a9b1-91beb2f0eb69","points":[{"id":"e499e86d-2015-4a1b-ae41-cfa65123a89b","type":"point","x":2406.000015438202,"y":1574.2890243412112},{"id":"c6c48876-0b36-45a4-a3f3-89732902f47e","type":"point","x":2406.000015438202,"y":2042.7892060272575},{"id":"945b24ed-2df1-43d3-91c1-269030ff27d0","type":"point","x":2246.4999296420133,"y":2042.7892060272575}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"80fb15db-c539-4dcb-bdc8-6921b68805c6","local_column_attnum":1,"referenced_table_uid":"0d6ef88b-4dac-4524-8c59-807af87879bd","referenced_column_attnum":1}},"235b07ce-0b44-4191-b301-59bee7039c53":{"id":"235b07ce-0b44-4191-b301-59bee7039c53","locked":true,"type":"onetomany","source":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","sourcePort":"35fc9763-0912-46d2-b65d-fee5010bf914","target":"80fb15db-c539-4dcb-bdc8-6921b68805c6","targetPort":"b06b62cc-f8b0-4af8-a882-3eb50242ecd1","points":[{"id":"a25bf184-a496-4de6-b651-b4acb3d93c32","type":"point","x":578.999904407841,"y":219.24221074436662},{"id":"4ac97ae7-9247-4e05-bf30-02951a4307a6","type":"point","x":578.999904407841,"y":2068.8281389918357},{"id":"fddf263a-d21a-47bf-9fd6-90c882145ab9","type":"point","x":2008.4999649698557,"y":2068.8281389918357}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"80fb15db-c539-4dcb-bdc8-6921b68805c6","local_column_attnum":2,"referenced_table_uid":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced_column_attnum":1}},"50dfe1a5-c33a-4620-b58b-0e2e00cea15a":{"id":"50dfe1a5-c33a-4620-b58b-0e2e00cea15a","locked":true,"type":"onetomany","source":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","sourcePort":"cf77aa55-67a5-4a11-89ad-717dd8dd125b","target":"0d6ef88b-4dac-4524-8c59-807af87879bd","targetPort":"5a58640a-12a0-4111-964a-868b82f6a13e","points":[{"id":"b2bcf250-7605-4fc8-b137-271af18a4cd3","type":"point","x":2591.5000726356607,"y":852.4375341791746},{"id":"9634081c-6560-4235-8e29-6c2277d67148","type":"point","x":2591.5000726356607,"y":1626.3671005551432},{"id":"65f61b9e-001a-487a-ba3e-c655232b3aff","type":"point","x":2643.9999801103595,"y":1626.3671005551432}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"0d6ef88b-4dac-4524-8c59-807af87879bd","local_column_attnum":3,"referenced_table_uid":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","referenced_column_attnum":1}},"32fcff10-3202-45ab-9f06-5ea70164f690":{"id":"32fcff10-3202-45ab-9f06-5ea70164f690","locked":true,"type":"onetomany","source":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","sourcePort":"35fc9763-0912-46d2-b65d-fee5010bf914","target":"16c6ed7c-d6b4-4918-acae-a341d92c9e83","targetPort":"adf20ff6-3056-4c65-b6ed-4e13fd2e1ec7","points":[{"id":"817ae7ce-ca25-46ec-876c-8df35e7e5ff7","type":"point","x":578.999904407841,"y":219.24221074436662},{"id":"b58a76ef-9204-48e8-9a07-69b78b3a290f","type":"point","x":578.999904407841,"y":1072.726608455122},{"id":"98f58ae6-901e-41de-b283-6586298be580","type":"point","x":1226.0000322609844,"y":1072.726608455122}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"16c6ed7c-d6b4-4918-acae-a341d92c9e83","local_column_attnum":2,"referenced_table_uid":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced_column_attnum":1}},"14ba28fc-9957-4693-986e-851bd649925e":{"id":"14ba28fc-9957-4693-986e-851bd649925e","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"9951c26d-4834-496e-8a27-a9b975576c53","target":"16c6ed7c-d6b4-4918-acae-a341d92c9e83","targetPort":"6d8286c7-ed26-4f2d-bb12-ce2219cde623","points":[{"id":"d8499397-5e62-4ac1-a6dd-f407f533373c","type":"point","x":2031.000015438202,"y":99.59374801019356},{"id":"8d256e55-b07d-44b6-9dba-77632647f389","type":"point","x":2031.000015438202,"y":1098.765646562088},{"id":"436c69d3-bcfc-4b01-a847-4320c9e27d7c","type":"point","x":1463.9999969331418,"y":1098.765646562088}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"16c6ed7c-d6b4-4918-acae-a341d92c9e83","local_column_attnum":3,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"261fb7eb-ce51-461a-93a1-dbb99ccfc162":{"id":"261fb7eb-ce51-461a-93a1-dbb99ccfc162","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"44e62f92-2a77-4012-933d-43051e4663a1","target":"41fe5b39-5a69-4ecc-a5a4-a8caba988d25","targetPort":"0f08c825-ff17-4a74-9cd6-6ef1ba763224","points":[{"id":"c27b9e91-1a3a-40fb-bc17-f9be295fac33","type":"point","x":2268.9999801103595,"y":99.59374801019356},{"id":"ff39eda6-7c0a-4967-b099-b34964246527","type":"point","x":2268.9999801103595,"y":1522.2109481272794},{"id":"b50a1894-2793-45da-b3f2-20f40bf973fd","type":"point","x":2413.999954876186,"y":1522.2109481272794}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"41fe5b39-5a69-4ecc-a5a4-a8caba988d25","local_column_attnum":2,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"e572db0e-7cff-430b-922d-fa9a7a635586":{"id":"e572db0e-7cff-430b-922d-fa9a7a635586","locked":true,"type":"onetomany","source":"0d6ef88b-4dac-4524-8c59-807af87879bd","sourcePort":"8b1053aa-fc77-4fd4-85af-2d336315ff64","target":"8845c46b-a94c-469c-bb2e-f122716e091c","targetPort":"a281a06f-10c6-48cb-9c85-118afaf4a8ed","points":[{"id":"23102f77-529e-4396-8f2d-eff627e78728","type":"point","x":2643.9999801103595,"y":1574.2890243412112},{"id":"e1555545-75ae-467d-8534-af31bc39edda","type":"point","x":2643.9999801103595,"y":2042.7892060272575},{"id":"1c799bac-f10a-4a5f-9b0c-eeb0fd785a8a","type":"point","x":2476.499954876186,"y":2042.7892060272575}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"8845c46b-a94c-469c-bb2e-f122716e091c","local_column_attnum":2,"referenced_table_uid":"0d6ef88b-4dac-4524-8c59-807af87879bd","referenced_column_attnum":1}},"69ec6779-b1b9-4d67-b4f1-ab1847450c4c":{"id":"69ec6779-b1b9-4d67-b4f1-ab1847450c4c","locked":true,"type":"onetomany","source":"41fe5b39-5a69-4ecc-a5a4-a8caba988d25","sourcePort":"01001877-725a-4de7-88b2-ca43faa793ba","target":"8845c46b-a94c-469c-bb2e-f122716e091c","targetPort":"7efeee26-1492-41bc-8d0a-820440f67fba","points":[{"id":"00946546-1a67-4252-87fd-119c8efc6c59","type":"point","x":2413.999954876186,"y":1496.1718048779253},{"id":"e864ef17-76a8-458c-a3fd-728f181171b1","type":"point","x":2413.999954876186,"y":2146.9453584551215},{"id":"482a2fd2-9cda-4c48-ba55-dd5e09eee60b","type":"point","x":2476.499954876186,"y":2146.9453584551215}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"8845c46b-a94c-469c-bb2e-f122716e091c","local_column_attnum":6,"referenced_table_uid":"41fe5b39-5a69-4ecc-a5a4-a8caba988d25","referenced_column_attnum":1}},"563c5255-f09e-430d-a52f-1398deec20a3":{"id":"563c5255-f09e-430d-a52f-1398deec20a3","locked":true,"type":"onetomany","source":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","sourcePort":"35fc9763-0912-46d2-b65d-fee5010bf914","target":"8845c46b-a94c-469c-bb2e-f122716e091c","targetPort":"43b91a86-5584-40c7-8690-d3959bd39a83","points":[{"id":"3f4bafe4-90ee-4477-8482-e6d14db4b965","type":"point","x":578.999904407841,"y":219.24221074436662},{"id":"6af0cbed-a282-43d0-866b-6a856ca1e900","type":"point","x":578.999904407841,"y":2068.8281389918357},{"id":"3de58fdb-1678-422d-a10b-fb3f53f4b05f","type":"point","x":2238.4999902040286,"y":2068.8281389918357}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"8845c46b-a94c-469c-bb2e-f122716e091c","local_column_attnum":3,"referenced_table_uid":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced_column_attnum":1}},"11af2c94-3e9d-48c5-b42a-b4071a96df4b":{"id":"11af2c94-3e9d-48c5-b42a-b4071a96df4b","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"44e62f92-2a77-4012-933d-43051e4663a1","target":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","targetPort":"d862a01b-fd7e-4f75-9f62-9f0a282f4bd7","points":[{"id":"f0b6d334-ab7f-44d7-8c52-94dd84591301","type":"point","x":2268.9999801103595,"y":99.59374801019356},{"id":"85ca32b5-c20d-4f3f-b0ac-c196c89415ab","type":"point","x":2268.9999801103595,"y":878.4765722861406},{"id":"18e0247f-a4c2-4ca8-9e90-d193e57f4b39","type":"point","x":2353.500107963503,"y":878.4765722861406}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","local_column_attnum":2,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"d086e859-0391-4c8b-93b6-3b8c804cba62":{"id":"d086e859-0391-4c8b-93b6-3b8c804cba62","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"44e62f92-2a77-4012-933d-43051e4663a1","target":"e86b6ccb-ea2f-4d38-b154-aee9ae4388ee","targetPort":"eff85311-98d8-4049-b7df-4fd8f3d390f7","points":[{"id":"919eea1f-7053-4e3b-9430-a6881341e8ad","type":"point","x":2268.9999801103595,"y":99.59374801019356},{"id":"dc51d5f2-7bf6-4f53-a930-f4b581e8c3ed","type":"point","x":2268.9999801103595,"y":966.0938270772689},{"id":"8502af18-9f5b-4b44-a178-89fa0ab79018","type":"point","x":2583.4999229129003,"y":966.0938270772689}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"e86b6ccb-ea2f-4d38-b154-aee9ae4388ee","local_column_attnum":2,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"fa98925d-afd1-4f09-accd-f2574f32e80d":{"id":"fa98925d-afd1-4f09-accd-f2574f32e80d","locked":true,"type":"onetomany","source":"3d1d166a-5460-4f51-adcd-7cb5c8609036","sourcePort":"44e62f92-2a77-4012-933d-43051e4663a1","target":"18d4cdd1-501f-41f1-b978-c516f5f2371e","targetPort":"66fc35db-995a-4e5f-a4f1-8f92f0bd92a0","points":[{"id":"729365a1-664f-47d0-8110-eab6d0e0b311","type":"point","x":2268.9999801103595,"y":99.59374801019356},{"id":"81821edf-c52c-482d-bf16-b9ffab49e19e","type":"point","x":2268.9999801103595,"y":1050.2032163766337},{"id":"fadb0067-cc45-47b2-994b-62647ee82efd","type":"point","x":2154.000072635661,"y":1050.2032163766337}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"18d4cdd1-501f-41f1-b978-c516f5f2371e","local_column_attnum":3,"referenced_table_uid":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced_column_attnum":1}},"643e7c04-0ace-41e3-a7b2-abc5fd0626df":{"id":"643e7c04-0ace-41e3-a7b2-abc5fd0626df","locked":true,"type":"onetomany","source":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","sourcePort":"35fc9763-0912-46d2-b65d-fee5010bf914","target":"18d4cdd1-501f-41f1-b978-c516f5f2371e","targetPort":"f4b8109a-b71e-4b92-8af3-9857fe723f82","points":[{"id":"3ee3965a-a922-45a9-9be8-0c8dc269fe3f","type":"point","x":578.999904407841,"y":219.24221074436662},{"id":"92a51b6a-9bbd-4e49-b9b2-fe77310ae157","type":"point","x":578.999904407841,"y":1024.1640731272796},{"id":"f760cdfe-6e90-4cb6-8ff1-553a30f336c1","type":"point","x":1915.9998976787274,"y":1024.1640731272796}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"18d4cdd1-501f-41f1-b978-c516f5f2371e","local_column_attnum":2,"referenced_table_uid":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced_column_attnum":1}}}},{"id":"624ef0bd-ae7d-4c6d-96fe-e76b0f4626e4","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"7514ec27-fddf-4ad0-b63c-747cd5c2aa21":{"id":"7514ec27-fddf-4ad0-b63c-747cd5c2aa21","type":"table","x":25,"y":867.984375,"ports":[{"id":"b353b996-65c8-48bf-bbdd-153dda3a525b","type":"onetomany","x":25.99995445561798,"y":988.6172191557573,"name":"coll-port-2-left","alignment":"left","parentNode":"7514ec27-fddf-4ad0-b63c-747cd5c2aa21","links":[]},{"id":"e2df5f3f-1ab8-406b-ac70-b0ef740244c1","type":"onetomany","x":203.99997169896952,"y":988.6172191557573,"name":"coll-port-2-right","alignment":"right","parentNode":"7514ec27-fddf-4ad0-b63c-747cd5c2aa21","links":["cf8685f6-c212-42eb-b077-082029afeb0b"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["b353b996-65c8-48bf-bbdd-153dda3a525b","e2df5f3f-1ab8-406b-ac70-b0ef740244c1"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"audit_logs","is_view_only":false,"attcompression":null,"seqrelid":114939,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"actor_user_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"audit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"action","atttypid":1043,"attlen":"100","attnum":3,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"audit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"target_type","atttypid":1043,"attlen":"50","attnum":4,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"audit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"target_id","atttypid":23,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"audit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"old_data","atttypid":3802,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"jsonb","displaytypname":"jsonb","cltype":"jsonb","inheritedfrom":null,"inheritedid":null,"elemoid":3802,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"audit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["json","jsonb"]},{"name":"new_data","atttypid":3802,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"jsonb","displaytypname":"jsonb","cltype":"jsonb","inheritedfrom":null,"inheritedid":null,"elemoid":3802,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"audit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["json","jsonb","jsonb"]},{"name":"remark","atttypid":25,"attlen":null,"attnum":8,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"audit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":9,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"audit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"audit_logs","schema":"public","description":"审核与操作日志表：记录后台审核、管理操作和关键数据变更。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114946,"name":"audit_logs_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"audit_logs_actor_user_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114577,"fknsp":"public","fktab":"audit_logs","refnspoid":2200,"refnsp":"public","reftab":"users","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"actor_user_id","references":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced":"id","references_table_name":"public.users"}],"remote_schema":"public","remote_table":"users","coveringindex":"idx_audit_logs_actor_user_id","autoindex":true,"hasindex":true}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"c421084b-7b83-484b-83e6-4a141c5d7130":{"id":"c421084b-7b83-484b-83e6-4a141c5d7130","type":"table","x":1130,"y":1427.6171875,"ports":[{"id":"c408eebd-7e58-4340-a970-46a4af4bd91c","type":"onetomany","x":1131.0000322609844,"y":1600.3281675905653,"name":"coll-port-4-left","alignment":"left","parentNode":"c421084b-7b83-484b-83e6-4a141c5d7130","links":["8cc3f54d-3d9c-4a2b-bfa7-2c2a706ca81b"]},{"id":"b61eb666-8773-4b3d-be4a-ebdfd9b91ea4","type":"onetomany","x":1308.999996933142,"y":1600.3281675905653,"name":"coll-port-4-right","alignment":"right","parentNode":"c421084b-7b83-484b-83e6-4a141c5d7130","links":[]},{"id":"7a3a62a5-eac1-4c60-a129-b7e88ad873fa","type":"onetomany","x":1131.0000322609844,"y":1548.2500913766335,"name":"coll-port-2-left","alignment":"left","parentNode":"c421084b-7b83-484b-83e6-4a141c5d7130","links":[]},{"id":"1a0bb908-09a3-4f11-95a3-59cfd29573ae","type":"onetomany","x":1308.999996933142,"y":1548.2500913766335,"name":"coll-port-2-right","alignment":"right","parentNode":"c421084b-7b83-484b-83e6-4a141c5d7130","links":["e6d260b8-8f1b-4a19-ace8-c5c6ccee61a5"]},{"id":"edab8eff-d180-4b6d-afc4-46b24b051e71","type":"onetomany","x":1131.0000322609844,"y":1574.2890243412112,"name":"coll-port-3-left","alignment":"left","parentNode":"c421084b-7b83-484b-83e6-4a141c5d7130","links":[]},{"id":"347692f3-0c4f-4231-bb2d-5ead6a1c6795","type":"onetomany","x":1308.999996933142,"y":1574.2890243412112,"name":"coll-port-3-right","alignment":"right","parentNode":"c421084b-7b83-484b-83e6-4a141c5d7130","links":["c10c4bca-f183-45f6-87be-7458652da0b1"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["c408eebd-7e58-4340-a970-46a4af4bd91c","b61eb666-8773-4b3d-be4a-ebdfd9b91ea4","7a3a62a5-eac1-4c60-a129-b7e88ad873fa","1a0bb908-09a3-4f11-95a3-59cfd29573ae","edab8eff-d180-4b6d-afc4-46b24b051e71","347692f3-0c4f-4231-bb2d-5ead6a1c6795"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"bids","is_view_only":false,"attcompression":null,"seqrelid":114785,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"request_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"bids","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"supplier_company_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"bids","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"contact_user_id","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"bids","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"quote_amount","atttypid":1700,"attlen":"18","attnum":5,"attndims":0,"atttypmod":1179654,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(18,2)","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"bids","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":"2","coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]},{"name":"quote_description","atttypid":25,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"bids","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"delivery_days","atttypid":23,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"bids","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"status","atttypid":114536,"attlen":null,"attnum":8,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':submitted'::bid_status","typname":"bid_status","displaytypname":"bid_status","cltype":"bid_status","inheritedfrom":null,"inheritedid":null,"elemoid":114536,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"bids","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bid_status"]},{"name":"submitted_at","atttypid":1184,"attlen":null,"attnum":9,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"bids","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updated_at","atttypid":1184,"attlen":null,"attnum":10,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"bids","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"bids","schema":"public","description":"投标表：供应商针对采购需求提交的报价或投标记录。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114796,"name":"bids_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"bids_contact_user_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[4],"confkey":[1],"confrelid":114577,"fknsp":"public","fktab":"bids","refnspoid":2200,"refnsp":"public","reftab":"users","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"contact_user_id","references":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced":"id","references_table_name":"public.users"}],"remote_schema":"public","remote_table":"users","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"bids_request_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114764,"fknsp":"public","fktab":"bids","refnspoid":2200,"refnsp":"public","reftab":"procurement_requests","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"request_id","references":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","referenced":"id","references_table_name":"public.procurement_requests"}],"remote_schema":"public","remote_table":"procurement_requests","coveringindex":"idx_bids_request_id","autoindex":true,"hasindex":true},{"name":"bids_supplier_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"bids","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"supplier_company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":"idx_bids_supplier_company_id","autoindex":true,"hasindex":true}],"unique_constraint":[{"oid":114798,"name":"bids_request_id_supplier_company_id_key","col_count":2,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"request_id"},{"column":"supplier_company_id"}],"include":[]}]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"615c4925-fd7c-4107-80d2-e72a533429ca":{"id":"615c4925-fd7c-4107-80d2-e72a533429ca","type":"table","x":275,"y":907.046875,"ports":[{"id":"b949631c-c862-44c9-a087-460c3ffc381a","type":"onetomany","x":276.00000702681183,"y":1027.6797191557573,"name":"coll-port-2-left","alignment":"left","parentNode":"615c4925-fd7c-4107-80d2-e72a533429ca","links":[]},{"id":"c831f11c-8d29-4302-94c2-3ecddca14908","type":"onetomany","x":453.9999716989694,"y":1027.6797191557573,"name":"coll-port-2-right","alignment":"right","parentNode":"615c4925-fd7c-4107-80d2-e72a533429ca","links":["208d606a-b532-46eb-a67e-fe8a9782d197"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["b949631c-c862-44c9-a087-460c3ffc381a","c831f11c-8d29-4302-94c2-3ecddca14908"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"browse_logs","is_view_only":false,"attcompression":null,"seqrelid":114860,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"user_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"browse_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"target_type","atttypid":1043,"attlen":"50","attnum":3,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"browse_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"target_id","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"browse_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"source","atttypid":1043,"attlen":"100","attnum":5,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"browse_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"browsed_at","atttypid":1184,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"browse_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"browse_logs","schema":"public","description":"浏览记录表：记录用户看过的公司、产品、采购需求、动态等对象。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114865,"name":"browse_logs_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"browse_logs_user_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114577,"fknsp":"public","fktab":"browse_logs","refnspoid":2200,"refnsp":"public","reftab":"users","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"user_id","references":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced":"id","references_table_name":"public.users"}],"remote_schema":"public","remote_table":"users","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"3d1d166a-5460-4f51-adcd-7cb5c8609036":{"id":"3d1d166a-5460-4f51-adcd-7cb5c8609036","type":"table","x":2060,"y":5,"ports":[{"id":"9951c26d-4834-496e-8a27-a9b975576c53","type":"onetomany","x":2061.000015438202,"y":99.59374801019356,"name":"coll-port-1-left","alignment":"left","parentNode":"3d1d166a-5460-4f51-adcd-7cb5c8609036","links":["c10c4bca-f183-45f6-87be-7458652da0b1","0078da13-c09f-445b-8379-ef511169b065","baa10baa-cd87-4c39-9b0a-9c85f1f8f2ff","a30db3dd-85cf-4c03-a630-3699ef989311","5470ce32-ccf0-4fea-b096-e81064daae33","d1456e8b-fd56-4cc7-9b12-e65c284ebbd0","14ba28fc-9957-4693-986e-851bd649925e"]},{"id":"44e62f92-2a77-4012-933d-43051e4663a1","type":"onetomany","x":2238.9999801103595,"y":99.59374801019356,"name":"coll-port-1-right","alignment":"right","parentNode":"3d1d166a-5460-4f51-adcd-7cb5c8609036","links":["a6c73c4d-70a4-4d9d-a4db-37db68e81e2a","261fb7eb-ce51-461a-93a1-dbb99ccfc162","11af2c94-3e9d-48c5-b42a-b4071a96df4b","d086e859-0391-4c8b-93b6-3b8c804cba62","fa98925d-afd1-4f09-accd-f2574f32e80d"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["9951c26d-4834-496e-8a27-a9b975576c53","44e62f92-2a77-4012-933d-43051e4663a1"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":114594,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"name","atttypid":1043,"attlen":"200","attnum":2,"attndims":0,"atttypmod":204,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(200)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"company_type","atttypid":114474,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':supplier'::company_type","typname":"company_type","displaytypname":"company_type","cltype":"company_type","inheritedfrom":null,"inheritedid":null,"elemoid":114474,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["company_type"]},{"name":"logo_url","atttypid":25,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"intro","atttypid":25,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text","text"]},{"name":"province","atttypid":1043,"attlen":"100","attnum":6,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"city","atttypid":1043,"attlen":"100","attnum":7,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"district","atttypid":1043,"attlen":"100","attnum":8,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"address","atttypid":25,"attlen":null,"attnum":9,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text","text","text"]},{"name":"industry","atttypid":1043,"attlen":"100","attnum":10,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"business_scope","atttypid":25,"attlen":null,"attnum":11,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text","text","text","text"]},{"name":"founded_year","atttypid":23,"attlen":null,"attnum":12,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"employee_count","atttypid":23,"attlen":null,"attnum":13,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"main_products","atttypid":25,"attlen":null,"attnum":14,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text","text","text","text","text"]},{"name":"certification_status","atttypid":114494,"attlen":null,"attnum":15,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':unverified'::certification_status","typname":"certification_status","displaytypname":"certification_status","cltype":"certification_status","inheritedfrom":null,"inheritedid":null,"elemoid":114494,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["certification_status"]},{"name":"status","atttypid":114482,"attlen":null,"attnum":16,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':draft'::company_status","typname":"company_status","displaytypname":"company_status","cltype":"company_status","inheritedfrom":null,"inheritedid":null,"elemoid":114482,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["company_status"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":17,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updated_at","atttypid":1184,"attlen":null,"attnum":18,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"companies","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"companies","schema":"public","description":"公司主体表：采购方公司和供应商公司统一存放。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114607,"name":"companies_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"aed317c1-d1b1-4e3a-a4f4-aa867d6b0752":{"id":"aed317c1-d1b1-4e3a-a4f4-aa867d6b0752","type":"table","x":525,"y":813.4375,"ports":[{"id":"2b5bb3c9-aded-4a77-8e72-a189adc33508","type":"onetomany","x":526.0000070268117,"y":934.0703996709382,"name":"coll-port-2-left","alignment":"left","parentNode":"aed317c1-d1b1-4e3a-a4f4-aa867d6b0752","links":[]},{"id":"e984c6f3-640e-457a-8764-9136fe7390a8","type":"onetomany","x":703.9999716989693,"y":934.0703996709382,"name":"coll-port-2-right","alignment":"right","parentNode":"aed317c1-d1b1-4e3a-a4f4-aa867d6b0752","links":["0078da13-c09f-445b-8379-ef511169b065"]},{"id":"4c0f45f6-5229-4138-8ef7-96d6f9bab336","type":"onetomany","x":526.0000070268117,"y":1064.265695348156,"name":"coll-port-7-left","alignment":"left","parentNode":"aed317c1-d1b1-4e3a-a4f4-aa867d6b0752","links":[]},{"id":"abce7d03-14cf-433e-acde-5875c31acb18","type":"onetomany","x":703.9999716989693,"y":1064.265695348156,"name":"coll-port-7-right","alignment":"right","parentNode":"aed317c1-d1b1-4e3a-a4f4-aa867d6b0752","links":["090c2db5-18f3-48d0-97d5-ec9d47ce383e"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["2b5bb3c9-aded-4a77-8e72-a189adc33508","e984c6f3-640e-457a-8764-9136fe7390a8","4c0f45f6-5229-4138-8ef7-96d6f9bab336","abce7d03-14cf-433e-acde-5875c31acb18"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"company_certifications","is_view_only":false,"attcompression":null,"seqrelid":114636,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"company_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_certifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"legal_name","atttypid":1043,"attlen":"200","attnum":3,"attndims":0,"atttypmod":204,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(200)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_certifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"unified_social_credit_code","atttypid":1043,"attlen":"64","attnum":4,"attndims":0,"atttypmod":68,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(64)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_certifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"legal_representative","atttypid":1043,"attlen":"100","attnum":5,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_certifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"status","atttypid":114494,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':pending'::certification_status","typname":"certification_status","displaytypname":"certification_status","cltype":"certification_status","inheritedfrom":null,"inheritedid":null,"elemoid":114494,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_certifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["certification_status"]},{"name":"reviewed_by","atttypid":23,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_certifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"reviewed_at","atttypid":1184,"attlen":null,"attnum":8,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_certifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"reject_reason","atttypid":25,"attlen":null,"attnum":9,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_certifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":10,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_certifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updated_at","atttypid":1184,"attlen":null,"attnum":11,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_certifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"company_certifications","schema":"public","description":"公司认证表：保存企业实名认证资料和审核结果。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114645,"name":"company_certifications_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"company_certifications_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"company_certifications","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":"idx_company_certifications_company_id","autoindex":true,"hasindex":true},{"name":"company_certifications_reviewed_by_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[7],"confkey":[1],"confrelid":114577,"fknsp":"public","fktab":"company_certifications","refnspoid":2200,"refnsp":"public","reftab":"users","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"reviewed_by","references":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced":"id","references_table_name":"public.users"}],"remote_schema":"public","remote_table":"users","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"00de2eae-54f6-42b3-9046-0646dfa88420":{"id":"00de2eae-54f6-42b3-9046-0646dfa88420","type":"table","x":1005,"y":926.0546875,"ports":[{"id":"584f6bb4-29fa-43ce-b980-784618e52c0b","type":"onetomany","x":1006.0000322609845,"y":1046.687570348156,"name":"coll-port-2-left","alignment":"left","parentNode":"00de2eae-54f6-42b3-9046-0646dfa88420","links":[]},{"id":"57404386-2b99-425c-9874-cb191fec4d1d","type":"onetomany","x":1183.999996933142,"y":1046.687570348156,"name":"coll-port-2-right","alignment":"right","parentNode":"00de2eae-54f6-42b3-9046-0646dfa88420","links":["baa10baa-cd87-4c39-9b0a-9c85f1f8f2ff"]},{"id":"2b8cff91-531b-49c5-97d6-83a32c6a2ffe","type":"onetomany","x":1006.0000322609845,"y":1072.726608455122,"name":"coll-port-3-left","alignment":"left","parentNode":"00de2eae-54f6-42b3-9046-0646dfa88420","links":["14769689-d9e2-49b9-91cb-4c1e43b45789"]},{"id":"373398da-8115-469f-9631-ede6e33c10e5","type":"onetomany","x":1183.999996933142,"y":1072.726608455122,"name":"coll-port-3-right","alignment":"right","parentNode":"00de2eae-54f6-42b3-9046-0646dfa88420","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["584f6bb4-29fa-43ce-b980-784618e52c0b","57404386-2b99-425c-9874-cb191fec4d1d","2b8cff91-531b-49c5-97d6-83a32c6a2ffe","373398da-8115-469f-9631-ede6e33c10e5"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"company_members","is_view_only":false,"attcompression":null,"seqrelid":114613,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"company_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_members","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"user_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_members","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"role","atttypid":114506,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':member'::member_role","typname":"member_role","displaytypname":"member_role","cltype":"member_role","inheritedfrom":null,"inheritedid":null,"elemoid":114506,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_members","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["member_role"]},{"name":"is_primary","atttypid":16,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"false","typname":"boolean","displaytypname":"boolean","cltype":"boolean","inheritedfrom":null,"inheritedid":null,"elemoid":16,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_members","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["boolean","character","character varying","text"]},{"name":"joined_at","atttypid":1184,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_members","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"company_members","schema":"public","description":"公司成员表：记录用户和公司的归属关系及成员权限。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114620,"name":"company_members_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"company_members_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"company_members","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":"idx_company_members_company_id","autoindex":true,"hasindex":true},{"name":"company_members_user_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":114577,"fknsp":"public","fktab":"company_members","refnspoid":2200,"refnsp":"public","reftab":"users","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"user_id","references":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced":"id","references_table_name":"public.users"}],"remote_schema":"public","remote_table":"users","coveringindex":"idx_company_members_user_id","autoindex":true,"hasindex":true}],"unique_constraint":[{"oid":114622,"name":"company_members_company_id_user_id_key","col_count":2,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"company_id"},{"column":"user_id"}],"include":[]}]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"2614216b-1183-4b03-b1ee-b0b1300f3288":{"id":"2614216b-1183-4b03-b1ee-b0b1300f3288","type":"table","selected":true,"x":1485,"y":832.4453125,"ports":[{"id":"503a3af7-4032-4317-8521-94665e869988","type":"onetomany","x":1486.0000574951573,"y":953.078145720949,"name":"coll-port-2-left","alignment":"left","parentNode":"2614216b-1183-4b03-b1ee-b0b1300f3288","links":[]},{"id":"7dd6671c-ffe4-45ba-ac96-83256211331d","type":"onetomany","x":1664.000022167315,"y":953.078145720949,"name":"coll-port-2-right","alignment":"right","parentNode":"2614216b-1183-4b03-b1ee-b0b1300f3288","links":["a30db3dd-85cf-4c03-a630-3699ef989311"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["503a3af7-4032-4317-8521-94665e869988","7dd6671c-ffe4-45ba-ac96-83256211331d"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"company_posts","is_view_only":false,"attcompression":null,"seqrelid":114723,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"company_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_posts","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"post_type","atttypid":1043,"attlen":"50","attnum":3,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":"'text'::character varying","typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_posts","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"content","atttypid":25,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_posts","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"status","atttypid":114514,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':draft'::content_status","typname":"content_status","displaytypname":"content_status","cltype":"content_status","inheritedfrom":null,"inheritedid":null,"elemoid":114514,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_posts","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["content_status"]},{"name":"view_count","atttypid":23,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"0","typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_posts","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"like_count","atttypid":23,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"0","typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_posts","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"comment_count","atttypid":23,"attlen":null,"attnum":8,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"0","typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_posts","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"published_at","atttypid":1184,"attlen":null,"attnum":9,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_posts","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":10,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_posts","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updated_at","atttypid":1184,"attlen":null,"attnum":11,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_posts","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"company_posts","schema":"public","description":"公司动态表：公司发布的图文、视频、产品动态等内容。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114736,"name":"company_posts_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"company_posts_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"company_posts","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":"idx_company_posts_company_id","autoindex":true,"hasindex":true}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"5fcabcef-6ccc-4008-bc18-546ff6a846a9":{"id":"5fcabcef-6ccc-4008-bc18-546ff6a846a9","type":"table","x":1715,"y":800.4140625,"ports":[{"id":"5c665d83-0de6-448b-8718-cd1c052346aa","type":"onetomany","x":1715.9998724445543,"y":921.0469377779042,"name":"coll-port-2-left","alignment":"left","parentNode":"5fcabcef-6ccc-4008-bc18-546ff6a846a9","links":[]},{"id":"312e27e2-137f-497d-b54f-7c83558873d3","type":"onetomany","x":1894.000047401488,"y":921.0469377779042,"name":"coll-port-2-right","alignment":"right","parentNode":"5fcabcef-6ccc-4008-bc18-546ff6a846a9","links":["5470ce32-ccf0-4fea-b096-e81064daae33"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["5c665d83-0de6-448b-8718-cd1c052346aa","312e27e2-137f-497d-b54f-7c83558873d3"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":114660,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"company_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"qualification_name","atttypid":1043,"attlen":"200","attnum":3,"attndims":0,"atttypmod":204,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(200)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"qualification_type","atttypid":1043,"attlen":"100","attnum":4,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"certificate_no","atttypid":1043,"attlen":"100","attnum":5,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"issuer","atttypid":1043,"attlen":"200","attnum":6,"attndims":0,"atttypmod":204,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(200)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"issued_at","atttypid":1082,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"]},{"name":"expires_at","atttypid":1082,"attlen":null,"attnum":8,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","date","timestamp with time zone","timestamp without time zone"]},{"name":"file_url","atttypid":25,"attlen":null,"attnum":9,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"status","atttypid":114494,"attlen":null,"attnum":10,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':pending'::certification_status","typname":"certification_status","displaytypname":"certification_status","cltype":"certification_status","inheritedfrom":null,"inheritedid":null,"elemoid":114494,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["certification_status"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":11,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updated_at","atttypid":1184,"attlen":null,"attnum":12,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_qualifications","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"company_qualifications","schema":"public","description":"公司资质表：保存营业执照、认证证书、资质文件等。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114669,"name":"company_qualifications_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"company_qualifications_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"company_qualifications","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":"idx_company_qualifications_company_id","autoindex":true,"hasindex":true}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"37c0b99a-d1b9-491e-99a2-bb37798375f2":{"id":"37c0b99a-d1b9-491e-99a2-bb37798375f2","type":"table","x":755,"y":987.6328125,"ports":[{"id":"8c3844ee-93ff-4573-921b-7b0f040cee30","type":"onetomany","x":756,"y":1082.2265625,"name":"coll-port-1-left","alignment":"left","parentNode":"37c0b99a-d1b9-491e-99a2-bb37798375f2","links":[]},{"id":"e7b14378-496b-46fa-b614-12282476d39b","type":"onetomany","x":934,"y":1082.2265625,"name":"coll-port-1-right","alignment":"right","parentNode":"37c0b99a-d1b9-491e-99a2-bb37798375f2","links":["d1456e8b-fd56-4cc7-9b12-e65c284ebbd0"]},{"id":"efc6e0d2-c8df-4aee-b062-9b68e58f5400","type":"onetomany","x":756,"y":1108.265625,"name":"coll-port-2-left","alignment":"left","parentNode":"37c0b99a-d1b9-491e-99a2-bb37798375f2","links":["0b0254cd-c78e-4085-8ec1-80cd34a091fb"]},{"id":"ea49e1dd-abd2-4f64-b326-9847a8757d12","type":"onetomany","x":934,"y":1108.265625,"name":"coll-port-2-right","alignment":"right","parentNode":"37c0b99a-d1b9-491e-99a2-bb37798375f2","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["8c3844ee-93ff-4573-921b-7b0f040cee30","e7b14378-496b-46fa-b614-12282476d39b","efc6e0d2-c8df-4aee-b062-9b68e58f5400","ea49e1dd-abd2-4f64-b326-9847a8757d12"],"otherInfo":{"data":{"columns":[{"name":"company_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_tags","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"tag_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"company_tags","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]}],"name":"company_tags","schema":"public","description":"公司标签关联表：记录公司拥有哪些标签。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114691,"name":"company_tags_pkey","col_count":2,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"company_id"},{"column":"tag_id"}],"include":[]}],"foreign_key":[{"name":"company_tags_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[1],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"company_tags","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"company_tags_tag_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114679,"fknsp":"public","fktab":"company_tags","refnspoid":2200,"refnsp":"public","reftab":"tags","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"tag_id","references":"14e78b9c-c338-48a8-beaf-a2ace5fd5158","referenced":"id","references_table_name":"public.tags"}],"remote_schema":"public","remote_table":"tags","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"80fb15db-c539-4dcb-bdc8-6921b68805c6":{"id":"80fb15db-c539-4dcb-bdc8-6921b68805c6","type":"table","x":2037.5,"y":1948.1953125,"ports":[{"id":"4df10855-fba2-46df-be2a-4e7418f40f21","type":"onetomany","x":2038.4999649698557,"y":2094.8672822411895,"name":"coll-port-3-left","alignment":"left","parentNode":"80fb15db-c539-4dcb-bdc8-6921b68805c6","links":[]},{"id":"b93a3448-6820-4990-9798-cfcb51459b74","type":"onetomany","x":2216.4999296420133,"y":2094.8672822411895,"name":"coll-port-3-right","alignment":"right","parentNode":"80fb15db-c539-4dcb-bdc8-6921b68805c6","links":["a6c73c4d-70a4-4d9d-a4db-37db68e81e2a"]},{"id":"d8f1bbb0-350d-4ce4-98b0-e720d22386f1","type":"onetomany","x":2038.4999649698557,"y":2042.7892060272575,"name":"coll-port-1-left","alignment":"left","parentNode":"80fb15db-c539-4dcb-bdc8-6921b68805c6","links":[]},{"id":"c398d20f-0948-478c-a9b1-91beb2f0eb69","type":"onetomany","x":2216.4999296420133,"y":2042.7892060272575,"name":"coll-port-1-right","alignment":"right","parentNode":"80fb15db-c539-4dcb-bdc8-6921b68805c6","links":["f2515855-4b0f-4860-8677-b297c9b34c4a"]},{"id":"b06b62cc-f8b0-4af8-a882-3eb50242ecd1","type":"onetomany","x":2038.4999649698557,"y":2068.8281389918357,"name":"coll-port-2-left","alignment":"left","parentNode":"80fb15db-c539-4dcb-bdc8-6921b68805c6","links":["235b07ce-0b44-4191-b301-59bee7039c53"]},{"id":"2e8c41f6-2cd1-498f-8417-31bf8b942c7f","type":"onetomany","x":2216.4999296420133,"y":2068.8281389918357,"name":"coll-port-2-right","alignment":"right","parentNode":"80fb15db-c539-4dcb-bdc8-6921b68805c6","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["4df10855-fba2-46df-be2a-4e7418f40f21","b93a3448-6820-4990-9798-cfcb51459b74","d8f1bbb0-350d-4ce4-98b0-e720d22386f1","c398d20f-0948-478c-a9b1-91beb2f0eb69","b06b62cc-f8b0-4af8-a882-3eb50242ecd1","2e8c41f6-2cd1-498f-8417-31bf8b942c7f"],"otherInfo":{"data":{"columns":[{"name":"conversation_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"conversation_participants","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"user_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"conversation_participants","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"company_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"conversation_participants","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"joined_at","atttypid":1184,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"conversation_participants","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"last_read_at","atttypid":1184,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"conversation_participants","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"conversation_participants","schema":"public","description":"会话参与人表：记录每个会话有哪些用户参与，以及已读时间。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114894,"name":"conversation_participants_pkey","col_count":2,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"conversation_id"},{"column":"user_id"}],"include":[]}],"foreign_key":[{"name":"conversation_participants_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"conversation_participants","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"conversation_participants_conversation_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[1],"confkey":[1],"confrelid":114875,"fknsp":"public","fktab":"conversation_participants","refnspoid":2200,"refnsp":"public","reftab":"conversations","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"conversation_id","references":"0d6ef88b-4dac-4524-8c59-807af87879bd","referenced":"id","references_table_name":"public.conversations"}],"remote_schema":"public","remote_table":"conversations","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"conversation_participants_user_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114577,"fknsp":"public","fktab":"conversation_participants","refnspoid":2200,"refnsp":"public","reftab":"users","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"user_id","references":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced":"id","references_table_name":"public.users"}],"remote_schema":"public","remote_table":"users","coveringindex":"idx_conversation_participants_user_id","autoindex":true,"hasindex":true}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"0d6ef88b-4dac-4524-8c59-807af87879bd":{"id":"0d6ef88b-4dac-4524-8c59-807af87879bd","type":"table","x":2435,"y":1479.6953125,"ports":[{"id":"4e35dcd2-de06-4c9f-9086-9ffb5a954473","type":"onetomany","x":2436.000015438202,"y":1574.2890243412112,"name":"coll-port-1-left","alignment":"left","parentNode":"0d6ef88b-4dac-4524-8c59-807af87879bd","links":["f2515855-4b0f-4860-8677-b297c9b34c4a"]},{"id":"8b1053aa-fc77-4fd4-85af-2d336315ff64","type":"onetomany","x":2613.9999801103595,"y":1574.2890243412112,"name":"coll-port-1-right","alignment":"right","parentNode":"0d6ef88b-4dac-4524-8c59-807af87879bd","links":["e572db0e-7cff-430b-922d-fa9a7a635586"]},{"id":"5d6fc1a1-dee0-474a-a87d-64187f3b35a6","type":"onetomany","x":2436.000015438202,"y":1626.3671005551432,"name":"coll-port-3-left","alignment":"left","parentNode":"0d6ef88b-4dac-4524-8c59-807af87879bd","links":[]},{"id":"5a58640a-12a0-4111-964a-868b82f6a13e","type":"onetomany","x":2613.9999801103595,"y":1626.3671005551432,"name":"coll-port-3-right","alignment":"right","parentNode":"0d6ef88b-4dac-4524-8c59-807af87879bd","links":["50dfe1a5-c33a-4620-b58b-0e2e00cea15a"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["4e35dcd2-de06-4c9f-9086-9ffb5a954473","8b1053aa-fc77-4fd4-85af-2d336315ff64","5d6fc1a1-dee0-474a-a87d-64187f3b35a6","5a58640a-12a0-4111-964a-868b82f6a13e"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"conversations","is_view_only":false,"attcompression":null,"seqrelid":114874,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"conversation_type","atttypid":114568,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':direct'::conversation_type","typname":"conversation_type","displaytypname":"conversation_type","cltype":"conversation_type","inheritedfrom":null,"inheritedid":null,"elemoid":114568,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"conversations","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["conversation_type"]},{"name":"procurement_request_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"conversations","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"title","atttypid":1043,"attlen":"200","attnum":4,"attndims":0,"atttypmod":204,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(200)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"conversations","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"conversations","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updated_at","atttypid":1184,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"conversations","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"conversations","schema":"public","description":"会话表：私聊、采购沟通、系统通知等会话主表。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114881,"name":"conversations_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"conversations_procurement_request_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":114764,"fknsp":"public","fktab":"conversations","refnspoid":2200,"refnsp":"public","reftab":"procurement_requests","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"procurement_request_id","references":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","referenced":"id","references_table_name":"public.procurement_requests"}],"remote_schema":"public","remote_table":"procurement_requests","coveringindex":"idx_conversations_procurement_request_id","autoindex":true,"hasindex":true}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"16c6ed7c-d6b4-4918-acae-a341d92c9e83":{"id":"16c6ed7c-d6b4-4918-acae-a341d92c9e83","type":"table","x":1255,"y":952.09375,"ports":[{"id":"adf20ff6-3056-4c65-b6ed-4e13fd2e1ec7","type":"onetomany","x":1256.0000322609844,"y":1072.726608455122,"name":"coll-port-2-left","alignment":"left","parentNode":"16c6ed7c-d6b4-4918-acae-a341d92c9e83","links":["32fcff10-3202-45ab-9f06-5ea70164f690"]},{"id":"0f024ff4-423a-45b4-842f-b159bad4bca7","type":"onetomany","x":1433.9999969331418,"y":1072.726608455122,"name":"coll-port-2-right","alignment":"right","parentNode":"16c6ed7c-d6b4-4918-acae-a341d92c9e83","links":[]},{"id":"97fe0af4-0af3-4028-993e-f4571e0c9ef9","type":"onetomany","x":1256.0000322609844,"y":1098.765646562088,"name":"coll-port-3-left","alignment":"left","parentNode":"16c6ed7c-d6b4-4918-acae-a341d92c9e83","links":[]},{"id":"6d8286c7-ed26-4f2d-bb12-ce2219cde623","type":"onetomany","x":1433.9999969331418,"y":1098.765646562088,"name":"coll-port-3-right","alignment":"right","parentNode":"16c6ed7c-d6b4-4918-acae-a341d92c9e83","links":["14ba28fc-9957-4693-986e-851bd649925e"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["adf20ff6-3056-4c65-b6ed-4e13fd2e1ec7","0f024ff4-423a-45b4-842f-b159bad4bca7","97fe0af4-0af3-4028-993e-f4571e0c9ef9","6d8286c7-ed26-4f2d-bb12-ce2219cde623"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"follows","is_view_only":false,"attcompression":null,"seqrelid":114819,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"follower_user_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"follows","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"target_company_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"follows","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"follows","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"follows","schema":"public","description":"关注表：记录用户关注了哪些公司。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114824,"name":"follows_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"follows_follower_user_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114577,"fknsp":"public","fktab":"follows","refnspoid":2200,"refnsp":"public","reftab":"users","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"follower_user_id","references":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced":"id","references_table_name":"public.users"}],"remote_schema":"public","remote_table":"users","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"follows_target_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"follows","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"target_company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":"idx_follows_target_company_id","autoindex":true,"hasindex":true}],"unique_constraint":[{"oid":114826,"name":"follows_follower_user_id_target_company_id_key","col_count":2,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"follower_user_id"},{"column":"target_company_id"}],"include":[]}]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"41fe5b39-5a69-4ecc-a5a4-a8caba988d25":{"id":"41fe5b39-5a69-4ecc-a5a4-a8caba988d25","type":"table","x":2205,"y":1401.578125,"ports":[{"id":"436169ec-4188-4856-983a-1dd51b1cd729","type":"onetomany","x":2205.999990204029,"y":1522.2109481272794,"name":"coll-port-2-left","alignment":"left","parentNode":"41fe5b39-5a69-4ecc-a5a4-a8caba988d25","links":[]},{"id":"0f08c825-ff17-4a74-9cd6-6ef1ba763224","type":"onetomany","x":2383.999954876186,"y":1522.2109481272794,"name":"coll-port-2-right","alignment":"right","parentNode":"41fe5b39-5a69-4ecc-a5a4-a8caba988d25","links":["261fb7eb-ce51-461a-93a1-dbb99ccfc162"]},{"id":"d32037b4-900a-402d-8e96-7a97ef44998f","type":"onetomany","x":2205.999990204029,"y":1496.1718048779253,"name":"coll-port-1-left","alignment":"left","parentNode":"41fe5b39-5a69-4ecc-a5a4-a8caba988d25","links":[]},{"id":"01001877-725a-4de7-88b2-ca43faa793ba","type":"onetomany","x":2383.999954876186,"y":1496.1718048779253,"name":"coll-port-1-right","alignment":"right","parentNode":"41fe5b39-5a69-4ecc-a5a4-a8caba988d25","links":["69ec6779-b1b9-4d67-b4f1-ab1847450c4c"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["436169ec-4188-4856-983a-1dd51b1cd729","0f08c825-ff17-4a74-9cd6-6ef1ba763224","d32037b4-900a-402d-8e96-7a97ef44998f","01001877-725a-4de7-88b2-ca43faa793ba"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":114746,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"company_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"owner_type","atttypid":1043,"attlen":"50","attnum":3,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"owner_id","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"media_type","atttypid":114548,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"media_type","displaytypname":"media_type","cltype":"media_type","inheritedfrom":null,"inheritedid":null,"elemoid":114548,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["media_type"]},{"name":"url","atttypid":25,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"thumbnail_url","atttypid":25,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text","text"]},{"name":"file_name","atttypid":1043,"attlen":"255","attnum":8,"attndims":0,"atttypmod":259,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(255)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"file_size","atttypid":20,"attlen":null,"attnum":9,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"bigint","displaytypname":"bigint","cltype":"bigint","inheritedfrom":null,"inheritedid":null,"elemoid":20,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"mime_type","atttypid":1043,"attlen":"100","attnum":10,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"sort_order","atttypid":23,"attlen":null,"attnum":11,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"0","typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":12,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"media_assets","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"media_assets","schema":"public","description":"媒体资源表：统一保存图片、视频、文档、资质附件等文件信息。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114754,"name":"media_assets_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"media_assets_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"media_assets","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":"idx_media_assets_company_id","autoindex":true,"hasindex":true}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"8845c46b-a94c-469c-bb2e-f122716e091c":{"id":"8845c46b-a94c-469c-bb2e-f122716e091c","type":"table","x":2267.5,"y":1922.15625,"ports":[{"id":"e0fecb18-2904-4330-91b4-a967449af1d0","type":"onetomany","x":2268.4999902040286,"y":2042.7892060272575,"name":"coll-port-2-left","alignment":"left","parentNode":"8845c46b-a94c-469c-bb2e-f122716e091c","links":[]},{"id":"a281a06f-10c6-48cb-9c85-118afaf4a8ed","type":"onetomany","x":2446.499954876186,"y":2042.7892060272575,"name":"coll-port-2-right","alignment":"right","parentNode":"8845c46b-a94c-469c-bb2e-f122716e091c","links":["e572db0e-7cff-430b-922d-fa9a7a635586"]},{"id":"8836a652-25a5-49f7-8c1c-3c25a1175ac3","type":"onetomany","x":2268.4999902040286,"y":2146.9453584551215,"name":"coll-port-6-left","alignment":"left","parentNode":"8845c46b-a94c-469c-bb2e-f122716e091c","links":[]},{"id":"7efeee26-1492-41bc-8d0a-820440f67fba","type":"onetomany","x":2446.499954876186,"y":2146.9453584551215,"name":"coll-port-6-right","alignment":"right","parentNode":"8845c46b-a94c-469c-bb2e-f122716e091c","links":["69ec6779-b1b9-4d67-b4f1-ab1847450c4c"]},{"id":"43b91a86-5584-40c7-8690-d3959bd39a83","type":"onetomany","x":2268.4999902040286,"y":2068.8281389918357,"name":"coll-port-3-left","alignment":"left","parentNode":"8845c46b-a94c-469c-bb2e-f122716e091c","links":["563c5255-f09e-430d-a52f-1398deec20a3"]},{"id":"a947437e-27dd-40ef-8cf3-3d1bb477a4fa","type":"onetomany","x":2446.499954876186,"y":2068.8281389918357,"name":"coll-port-3-right","alignment":"right","parentNode":"8845c46b-a94c-469c-bb2e-f122716e091c","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["e0fecb18-2904-4330-91b4-a967449af1d0","a281a06f-10c6-48cb-9c85-118afaf4a8ed","8836a652-25a5-49f7-8c1c-3c25a1175ac3","7efeee26-1492-41bc-8d0a-820440f67fba","43b91a86-5584-40c7-8690-d3959bd39a83","a947437e-27dd-40ef-8cf3-3d1bb477a4fa"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"messages","is_view_only":false,"attcompression":null,"seqrelid":114912,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"conversation_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"messages","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"sender_user_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"messages","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"message_type","atttypid":114558,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':text'::message_type","typname":"message_type","displaytypname":"message_type","cltype":"message_type","inheritedfrom":null,"inheritedid":null,"elemoid":114558,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"messages","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["message_type"]},{"name":"content","atttypid":25,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"messages","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"media_asset_id","atttypid":23,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"messages","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"messages","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"messages","schema":"public","description":"消息表：保存会话中的文本、图片、文件、系统消息。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114920,"name":"messages_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"messages_conversation_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114875,"fknsp":"public","fktab":"messages","refnspoid":2200,"refnsp":"public","reftab":"conversations","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"conversation_id","references":"0d6ef88b-4dac-4524-8c59-807af87879bd","referenced":"id","references_table_name":"public.conversations"}],"remote_schema":"public","remote_table":"conversations","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"messages_media_asset_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[6],"confkey":[1],"confrelid":114747,"fknsp":"public","fktab":"messages","refnspoid":2200,"refnsp":"public","reftab":"media_assets","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"media_asset_id","references":"41fe5b39-5a69-4ecc-a5a4-a8caba988d25","referenced":"id","references_table_name":"public.media_assets"}],"remote_schema":"public","remote_table":"media_assets","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"messages_sender_user_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":114577,"fknsp":"public","fktab":"messages","refnspoid":2200,"refnsp":"public","reftab":"users","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"sender_user_id","references":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced":"id","references_table_name":"public.users"}],"remote_schema":"public","remote_table":"users","coveringindex":"idx_messages_sender_user_id","autoindex":true,"hasindex":true}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"bc6b9914-c21c-49ff-9d79-ee481bcd92d6":{"id":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","type":"table","x":2382.5,"y":757.84375,"ports":[{"id":"030cf3b3-3665-44f7-8852-5043a2b39a3b","type":"onetomany","x":2383.500107963503,"y":852.4375341791746,"name":"coll-port-1-left","alignment":"left","parentNode":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","links":["e6d260b8-8f1b-4a19-ace8-c5c6ccee61a5"]},{"id":"cf77aa55-67a5-4a11-89ad-717dd8dd125b","type":"onetomany","x":2561.5000726356607,"y":852.4375341791746,"name":"coll-port-1-right","alignment":"right","parentNode":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","links":["50dfe1a5-c33a-4620-b58b-0e2e00cea15a"]},{"id":"d862a01b-fd7e-4f75-9f62-9f0a282f4bd7","type":"onetomany","x":2383.500107963503,"y":878.4765722861406,"name":"coll-port-2-left","alignment":"left","parentNode":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","links":["11af2c94-3e9d-48c5-b42a-b4071a96df4b"]},{"id":"a978cf25-2efc-48cc-b4ac-f184acba4eda","type":"onetomany","x":2561.5000726356607,"y":878.4765722861406,"name":"coll-port-2-right","alignment":"right","parentNode":"bc6b9914-c21c-49ff-9d79-ee481bcd92d6","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["030cf3b3-3665-44f7-8852-5043a2b39a3b","cf77aa55-67a5-4a11-89ad-717dd8dd125b","d862a01b-fd7e-4f75-9f62-9f0a282f4bd7","a978cf25-2efc-48cc-b4ac-f184acba4eda"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":114763,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"company_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"title","atttypid":1043,"attlen":"200","attnum":3,"attndims":0,"atttypmod":204,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(200)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"description","atttypid":25,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"category","atttypid":1043,"attlen":"100","attnum":5,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"quantity","atttypid":1700,"attlen":"18","attnum":6,"attndims":0,"atttypmod":1179656,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(18,4)","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":"4","coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]},{"name":"unit","atttypid":1043,"attlen":"50","attnum":7,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"budget_min","atttypid":1700,"attlen":"18","attnum":8,"attndims":0,"atttypmod":1179654,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(18,2)","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":"2","coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","numeric","real","smallint"]},{"name":"budget_max","atttypid":1700,"attlen":"18","attnum":9,"attndims":0,"atttypmod":1179654,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(18,2)","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":"2","coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","numeric","numeric","real","smallint"]},{"name":"delivery_location","atttypid":25,"attlen":null,"attnum":10,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text","text"]},{"name":"deadline_at","atttypid":1184,"attlen":null,"attnum":11,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"status","atttypid":114524,"attlen":null,"attnum":12,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':draft'::procurement_status","typname":"procurement_status","displaytypname":"procurement_status","cltype":"procurement_status","inheritedfrom":null,"inheritedid":null,"elemoid":114524,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["procurement_status"]},{"name":"view_count","atttypid":23,"attlen":null,"attnum":13,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"0","typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"published_at","atttypid":1184,"attlen":null,"attnum":14,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":15,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updated_at","atttypid":1184,"attlen":null,"attnum":16,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"procurement_requests","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"procurement_requests","schema":"public","description":"采购需求表：采购方发布的需求、招标、询价信息。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114774,"name":"procurement_requests_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"procurement_requests_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"procurement_requests","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":"idx_procurement_requests_company_id","autoindex":true,"hasindex":true}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"e86b6ccb-ea2f-4d38-b154-aee9ae4388ee":{"id":"e86b6ccb-ea2f-4d38-b154-aee9ae4388ee","type":"table","x":2612.5,"y":845.4609375,"ports":[{"id":"eff85311-98d8-4049-b7df-4fd8f3d390f7","type":"onetomany","x":2613.4999229129003,"y":966.0938270772689,"name":"coll-port-2-left","alignment":"left","parentNode":"e86b6ccb-ea2f-4d38-b154-aee9ae4388ee","links":["d086e859-0391-4c8b-93b6-3b8c804cba62"]},{"id":"9e00e596-b8a2-4200-9b81-29ddc00602c2","type":"onetomany","x":2791.500097869834,"y":966.0938270772689,"name":"coll-port-2-right","alignment":"right","parentNode":"e86b6ccb-ea2f-4d38-b154-aee9ae4388ee","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["eff85311-98d8-4049-b7df-4fd8f3d390f7","9e00e596-b8a2-4200-9b81-29ddc00602c2"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"products","is_view_only":false,"attcompression":null,"seqrelid":114703,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"company_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"products","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"name","atttypid":1043,"attlen":"200","attnum":3,"attndims":0,"atttypmod":204,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(200)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"products","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"category","atttypid":1043,"attlen":"100","attnum":4,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"products","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"description","atttypid":25,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"products","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"cover_url","atttypid":25,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"products","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text","text"]},{"name":"status","atttypid":114514,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':draft'::content_status","typname":"content_status","displaytypname":"content_status","cltype":"content_status","inheritedfrom":null,"inheritedid":null,"elemoid":114514,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"products","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["content_status"]},{"name":"sort_order","atttypid":23,"attlen":null,"attnum":8,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"0","typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"products","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":9,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"products","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updated_at","atttypid":1184,"attlen":null,"attnum":10,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"products","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"products","schema":"public","description":"产品表：供应商展示的产品或服务。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114713,"name":"products_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"products_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"products","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":"idx_products_company_id","autoindex":true,"hasindex":true}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"14e78b9c-c338-48a8-beaf-a2ace5fd5158":{"id":"14e78b9c-c338-48a8-beaf-a2ace5fd5158","type":"table","x":5,"y":244.296875,"ports":[{"id":"0fc8ac58-07a7-454c-8d6b-a3a5d91e2a14","type":"onetomany","x":5.999979689791119,"y":338.89067347853967,"name":"coll-port-1-left","alignment":"left","parentNode":"14e78b9c-c338-48a8-beaf-a2ace5fd5158","links":[]},{"id":"6d5caada-c246-41f2-9618-1b6e0584f3f4","type":"onetomany","x":183.99999693314265,"y":338.89067347853967,"name":"coll-port-1-right","alignment":"right","parentNode":"14e78b9c-c338-48a8-beaf-a2ace5fd5158","links":["0b0254cd-c78e-4085-8ec1-80cd34a091fb"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["0fc8ac58-07a7-454c-8d6b-a3a5d91e2a14","6d5caada-c246-41f2-9618-1b6e0584f3f4"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"tags","is_view_only":false,"attcompression":null,"seqrelid":114678,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"name","atttypid":1043,"attlen":"80","attnum":2,"attndims":0,"atttypmod":84,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(80)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tags","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"tag_type","atttypid":1043,"attlen":"50","attnum":3,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":"'company'::character varying","typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tags","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"tags","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"tags","schema":"public","description":"标签表：公司、产品、内容等可复用的标签字典。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114684,"name":"tags_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"unique_constraint":[{"oid":114686,"name":"tags_name_key","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"name"}],"include":[]}],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"d5a30e8a-3615-4457-bafd-8c3b79f22d99":{"id":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","type":"table","x":370,"y":124.6484375,"ports":[{"id":"341d387b-1931-4a99-ad54-6f0a5c8cba9d","type":"onetomany","x":370.9999397356834,"y":219.24221074436662,"name":"coll-port-1-left","alignment":"left","parentNode":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","links":["cf8685f6-c212-42eb-b077-082029afeb0b"]},{"id":"35fc9763-0912-46d2-b65d-fee5010bf914","type":"onetomany","x":548.999904407841,"y":219.24221074436662,"name":"coll-port-1-right","alignment":"right","parentNode":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","links":["8cc3f54d-3d9c-4a2b-bfa7-2c2a706ca81b","208d606a-b532-46eb-a67e-fe8a9782d197","090c2db5-18f3-48d0-97d5-ec9d47ce383e","14769689-d9e2-49b9-91cb-4c1e43b45789","235b07ce-0b44-4191-b301-59bee7039c53","32fcff10-3202-45ab-9f06-5ea70164f690","563c5255-f09e-430d-a52f-1398deec20a3","643e7c04-0ace-41e3-a7b2-abc5fd0626df"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["341d387b-1931-4a99-ad54-6f0a5c8cba9d","35fc9763-0912-46d2-b65d-fee5010bf914"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"users","is_view_only":false,"attcompression":null,"seqrelid":114576,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"phone","atttypid":1043,"attlen":"32","attnum":2,"attndims":0,"atttypmod":36,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(32)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"users","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"email","atttypid":1043,"attlen":"255","attnum":3,"attndims":0,"atttypmod":259,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(255)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"users","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"password_hash","atttypid":25,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"users","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"nickname","atttypid":1043,"attlen":"100","attnum":5,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"users","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"avatar_url","atttypid":25,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"users","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text","text"]},{"name":"role","atttypid":114459,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':buyer'::user_role","typname":"user_role","displaytypname":"user_role","cltype":"user_role","inheritedfrom":null,"inheritedid":null,"elemoid":114459,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"users","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["user_role"]},{"name":"status","atttypid":114466,"attlen":null,"attnum":8,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"':active'::user_status","typname":"user_status","displaytypname":"user_status","cltype":"user_status","inheritedfrom":null,"inheritedid":null,"elemoid":114466,"typnspname":"public","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"users","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["user_status"]},{"name":"last_login_at","atttypid":1184,"attlen":null,"attnum":9,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"users","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"created_at","atttypid":1184,"attlen":null,"attnum":10,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"users","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]},{"name":"updated_at","atttypid":1184,"attlen":null,"attnum":11,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"users","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"users","schema":"public","description":"用户账号表：保存登录账号、角色、头像、联系方式等基础信息。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114587,"name":"users_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"unique_constraint":[{"oid":114591,"name":"users_email_key","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"email"}],"include":[]},{"oid":114589,"name":"users_phone_key","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"phone"}],"include":[]}],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"18d4cdd1-501f-41f1-b978-c516f5f2371e":{"id":"18d4cdd1-501f-41f1-b978-c516f5f2371e","type":"table","x":1945,"y":903.53125,"ports":[{"id":"e00f1405-ec75-4398-adb8-0481bfa0de2e","type":"onetomany","x":1945.9998976787274,"y":1050.2032163766337,"name":"coll-port-3-left","alignment":"left","parentNode":"18d4cdd1-501f-41f1-b978-c516f5f2371e","links":[]},{"id":"66fc35db-995a-4e5f-a4f1-8f92f0bd92a0","type":"onetomany","x":2124.000072635661,"y":1050.2032163766337,"name":"coll-port-3-right","alignment":"right","parentNode":"18d4cdd1-501f-41f1-b978-c516f5f2371e","links":["fa98925d-afd1-4f09-accd-f2574f32e80d"]},{"id":"f4b8109a-b71e-4b92-8af3-9857fe723f82","type":"onetomany","x":1945.9998976787274,"y":1024.1640731272796,"name":"coll-port-2-left","alignment":"left","parentNode":"18d4cdd1-501f-41f1-b978-c516f5f2371e","links":["643e7c04-0ace-41e3-a7b2-abc5fd0626df"]},{"id":"c85d7aa9-bb36-45bd-a8b4-3e46a9bae3aa","type":"onetomany","x":2124.000072635661,"y":1024.1640731272796,"name":"coll-port-2-right","alignment":"right","parentNode":"18d4cdd1-501f-41f1-b978-c516f5f2371e","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["e00f1405-ec75-4398-adb8-0481bfa0de2e","66fc35db-995a-4e5f-a4f1-8f92f0bd92a0","f4b8109a-b71e-4b92-8af3-9857fe723f82","c85d7aa9-bb36-45bd-a8b4-3e46a9bae3aa"],"otherInfo":{"data":{"columns":[{"name":"id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"d","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"i","genexpr":null,"relname":"visit_logs","is_view_only":false,"attcompression":null,"seqrelid":114839,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"visitor_user_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"visit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"visited_company_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"visit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"source","atttypid":1043,"attlen":"100","attnum":4,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"visit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"ip","atttypid":869,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"m","attidentity":"","defval":null,"typname":"inet","displaytypname":"inet","cltype":"inet","inheritedfrom":null,"inheritedid":null,"elemoid":869,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"visit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["character","character varying","cidr","inet","text"]},{"name":"user_agent","atttypid":25,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"visit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"visited_at","atttypid":1184,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":null,"attstorage":"p","attidentity":"","defval":"now()","typname":"timestamp with time zone","displaytypname":"timestamp with time zone","cltype":"timestamp with time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1184,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"visit_logs","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","information_schema.time_stamp","time with time zone","time without time zone","timestamp with time zone","timestamp with time zone","timestamp without time zone"]}],"name":"visit_logs","schema":"public","description":"访客记录表：记录谁访问了某个公司主页。","rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":114846,"name":"visit_logs_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"id"}],"include":[]}],"foreign_key":[{"name":"visit_logs_visited_company_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":114595,"fknsp":"public","fktab":"visit_logs","refnspoid":2200,"refnsp":"public","reftab":"companies","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"visited_company_id","references":"3d1d166a-5460-4f51-adcd-7cb5c8609036","referenced":"id","references_table_name":"public.companies"}],"remote_schema":"public","remote_table":"companies","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"visit_logs_visitor_user_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":114577,"fknsp":"public","fktab":"visit_logs","refnspoid":2200,"refnsp":"public","reftab":"users","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"visitor_user_id","references":"d5a30e8a-3615-4457-bafd-8c3b79f22d99","referenced":"id","references_table_name":"public.users"}],"remote_schema":"public","remote_table":"users","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}}}}]}}