{"id":2022,"date":"2026-08-07T07:04:34","date_gmt":"2026-08-07T07:04:34","guid":{"rendered":"https:\/\/www.vpascode.com\/ja\/docs\/uncategorized\/dbml-visualizer-guide\/"},"modified":"2026-08-07T07:04:34","modified_gmt":"2026-08-07T07:04:34","slug":"dbml-visualizer-guide","status":"publish","type":"ld_docs","link":"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/","title":{"rendered":"DBML"},"content":{"rendered":"<p>\u7269\u6d41\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3001\u30b5\u30d7\u30e9\u30a4\u30c1\u30a7\u30fc\u30f3\u904b\u7528\u3001\u307e\u305f\u306f\u53d7\u6ce8\u51e6\u7406\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u8a2d\u8a08\u3059\u308b\u969b\u3001Raw\u306aDBML\u30b9\u30ad\u30fc\u30de\u5ba3\u8a00\u3092\u8aad\u3080\u3068\u3001\u30c6\u30fc\u30d6\u30eb\u3001\u5217\u6319\u578b\u3001\u30b9\u30ad\u30fc\u30de\u3001\u53c2\u7167\u304c\u3069\u306e\u3088\u3046\u306b\u63a5\u7d9a\u3055\u308c\u3066\u3044\u308b\u304b\u3092\u628a\u63e1\u3059\u308b\u306e\u304c\u96e3\u3057\u304f\u306a\u308b\u3053\u3068\u304c\u3042\u308a\u307e\u3059\u3002<strong>DBML\u30b9\u30ad\u30fc\u30de\u30d3\u30b8\u30e5\u30a2\u30e9\u30a4\u30b6\u30fc<\/strong>\u3042\u306a\u305f\u306eDBML\u5b9a\u7fa9\u3092\u660e\u78ba\u3067\u30a4\u30f3\u30bf\u30e9\u30af\u30c6\u30a3\u30d6\u306a\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u95a2\u4fc2\u56f3\uff08ERD\uff09\u306b\u5909\u63db\u3057\u307e\u3059\u3002\u30c6\u30fc\u30d6\u30eb\u69cb\u9020\u3001\u30b9\u30ad\u30fc\u30de\u63a5\u982d\u8f9e\u3001\u5217\u6319\u578b\u3001\u30c6\u30fc\u30d6\u30eb\u30b0\u30eb\u30fc\u30d7\u3001\u53c2\u7167\u95a2\u4fc2\uff08<code>&gt;<\/code>, <code>&lt;<\/code>, <code>-<\/code>, <code>&lt;&gt;<\/code>\uff09\u3092\u89e3\u6790\u3059\u308b\u3053\u3068\u3067\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7ba1\u7406\u8005\u3084\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u30a2\u30fc\u30ad\u30c6\u30af\u30c8\u306f\u3001\u8907\u96d1\u306a\u8ffd\u8de1\u30b7\u30b9\u30c6\u30e0\u3092\u4e00\u76ee\u3067\u78ba\u8a8d\u3067\u304d\u307e\u3059\u3002<\/p>\n<h2>DBML\u30d3\u30b8\u30e5\u30a2\u30e9\u30a4\u30bc\u30fc\u30b7\u30e7\u30f3\u306e\u4ed5\u7d44\u307f<\/h2>\n<p>VPasCode\u3067\u306f\u3001DBML\u30ec\u30f3\u30c0\u30ea\u30f3\u30b0\u304c<code>Project<\/code>\u8a2d\u5b9a\u3001<code>Enum<\/code>\u5ba3\u8a00\u3001<code>TableGroup<\/code>\u30d6\u30ed\u30c3\u30af\u3001\u304a\u3088\u3073<code>Table<\/code>\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u3092\u8996\u899a\u7684\u306aERD\u30ce\u30fc\u30c9\u306b\u5909\u63db\u3057\u307e\u3059\u3002\u30b9\u30ad\u30fc\u30de\u540d\u524d\u7a7a\u9593\u3092\u6301\u3064\u30c6\u30fc\u30d6\u30eb\uff08\u4f8b\uff1a<code>logistics.drivers<\/code>\uff09\u306f\u30d5\u30eb\u30d1\u30b9\u3067\u8868\u793a\u3055\u308c\u3001\u30ab\u30b9\u30bf\u30e0\u5217\u6319\u578b\u306f\u53b3\u5bc6\u306a\u30ab\u30e9\u30e0\u30bf\u30a4\u30d7\u3068\u3057\u3066\u6a5f\u80fd\u3057\u3001\u5916\u90e8\u30ad\u30fc\u53c2\u7167\u306f\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u9593\u306e\u8996\u899a\u7684\u30ea\u30f3\u30af\u3092\u81ea\u52d5\u7684\u306b\u751f\u6210\u3057\u307e\u3059\u3002<\/p>\n<h3>1. \u5fc5\u9808\u8a2d\u5b9a\uff1aFleetLogix\u7269\u6d41\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b9\u30ad\u30fc\u30de\u306e\u5b8c\u5168\u69cb\u7bc9<\/h3>\n<p>\u5168\u4f53\u306e\u7269\u6d41\u30a8\u30b3\u30b7\u30b9\u30c6\u30e0\u3092\u53ef\u8996\u5316\u3059\u308b\u305f\u3081\u3001\u6709\u52b9\u306aDBML\u69cb\u6587\u3067\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30d1\u30e9\u30e1\u30fc\u30bf\u3001\u5f93\u696d\u54e1\u5f79\u5272\u3001\u53d7\u6ce8\u51e6\u7406\u30a8\u30f3\u30c6\u30a3\u30c6\u30a3\u3001\u51fa\u8377\u30ed\u30b0\u3001\u53c2\u7167\u5236\u7d04\u3092\u5b9a\u7fa9\u3057\u3066\u304f\u3060\u3055\u3044\uff1a<\/p>\n<div class=\"vpascode-viewer-container vpascode-fancy-active\">\n<div class=\"vpascode-header\">\n<span class=\"vpascode-lang-label\">DBML<\/span><br \/>\n<a class=\"vpascode-fancy-btn\" href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqtVE1r20AQvRv8H\/aWGFyTBFJKCL6VUugh\/biFsKylsTTxane7O3JsSv57ZyXZki3FbqC3\/Zo38968nQdvnyEhsdQApG2GG\/FnPBIiVaQWKoCkrYM7cfFgA2Uefn7\/djEevY5H49FnUxYCCqftFkB6q6GOTGzpEXwFgsEpSvJ6VyijsrhswwMpKoNcK1020Q5MiiaLy2A9NUvyygSkChM0rsFDGjewScARWtOA\/lILDV+8LZ1YlnqJWhdgqEaO5AJhEmZO+QR0ODxcQ46JhqPTvFyELnbnKvWxjlCDYyqQEz261ZQXiYeY96kqsVCoxZpT5spf3tzeTsSjsSRMqfVUlAZ\/l1A95IK1NKqA\/ePrm6tJvKm0PVS6A5HCUpWauEeN8hcV3LNFA6lUJAgLYKELNxxl7MvlJMYMskQTShY\/AemsxgThLOFaF7l7sEv5VHuDr9gE0mllWlGuJkfvYOPQQ5DWRCPC0a0qyUoPBl7EwrIaDDXEjHyl7CCtxgLnuLDvkhV7ULJZF+A7FfdKZqc0nOPuBTDLSa6y3QF3AAumkspUbcPuNIBfI2urYQ2tSa5j2wfL3pn0XN3cKTChkpk6fvrYq1qrQLKpopL6jcTxH5xLeuDdT1fDPh\/+SvWf3koeEbhkqc7mqvs3bLJTBqwHzuHcObJoDsnK2Rja7XZF0BJLT7ChSEKIryaFza4ZQlzui5q2NbAKnT\/++oYABJq5ESuQ84n122YIn2BySgEGzt7394fo7LNPW8BJl8UPWN6dHBWzlsC8PzlnmPYw+k6YtUTn\/Q\/8jxjvrqPXkP8B8W4m8dfxubgfeF7Pm15Iiybu5wOTY1CwPQnx4XQ\/Mf0L6qPEEw==\" rel=\"noopener noreferrer\" target=\"_blank\"><br \/>\n<svg fill=\"none\" height=\"14\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2.5\" style=\"margin-right: 8px;\" viewbox=\"0 0 24 24\" width=\"14\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg><br \/>\n<span>VPasCode\u3067DBML\u3092\u7de8\u96c6<\/span><br \/>\n<\/a>\n<\/div>\n<div class=\"vpascode-code-wrapper\">\n            <div class=\"vpascode-viewer-container vpascode-fancy-active\">\r\n                                <div class=\"vpascode-header\">\r\n                    <span class=\"vpascode-lang-label\">DBML<\/span>\r\n                    <a href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqtVE1r20AQvRv8H\/aWGFyTBFJKCL6VUugh\/biFsKylsTTxane7O3JsSv57ZyXZki3FbqC3\/Zo38968nQdvnyEhsdQApG2GG\/FnPBIiVaQWKoCkrYM7cfFgA2Uefn7\/djEevY5H49FnUxYCCqftFkB6q6GOTGzpEXwFgsEpSvJ6VyijsrhswwMpKoNcK1020Q5MiiaLy2A9NUvyygSkChM0rsFDGjewScARWtOA\/lILDV+8LZ1YlnqJWhdgqEaO5AJhEmZO+QR0ODxcQ46JhqPTvFyELnbnKvWxjlCDYyqQEz261ZQXiYeY96kqsVCoxZpT5spf3tzeTsSjsSRMqfVUlAZ\/l1A95IK1NKqA\/ePrm6tJvKm0PVS6A5HCUpWauEeN8hcV3LNFA6lUJAgLYKELNxxl7MvlJMYMskQTShY\/AemsxgThLOFaF7l7sEv5VHuDr9gE0mllWlGuJkfvYOPQQ5DWRCPC0a0qyUoPBl7EwrIaDDXEjHyl7CCtxgLnuLDvkhV7ULJZF+A7FfdKZqc0nOPuBTDLSa6y3QF3AAumkspUbcPuNIBfI2urYQ2tSa5j2wfL3pn0XN3cKTChkpk6fvrYq1qrQLKpopL6jcTxH5xLeuDdT1fDPh\/+SvWf3koeEbhkqc7mqvs3bLJTBqwHzuHcObJoDsnK2Rja7XZF0BJLT7ChSEKIryaFza4ZQlzui5q2NbAKnT\/++oYABJq5ESuQ84n122YIn2BySgEGzt7394fo7LNPW8BJl8UPWN6dHBWzlsC8PzlnmPYw+k6YtUTn\/Q\/8jxjvrqPXkP8B8W4m8dfxubgfeF7Pm15Iiybu5wOTY1CwPQnx4XQ\/Mf0L6qPEEw==\" \r\n                       target=\"_blank\" \r\n                       rel=\"noopener noreferrer\" \r\n                       class=\"vpascode-fancy-btn\">\r\n                        <svg width=\"14\" height=\"14\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"margin-right: 8px;\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg>\r\n                        <span>Edit DBML in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n                                <div class=\"vpascode-code-wrapper\">\r\n                    <pre class=\"lang-dbml\"><code class=\"language-dbml\" data-language=\"dbml\" class=\"language-dbml\">Project fleetlogix {\r\n  database_type: 'PostgreSQL'\r\n}\r\n\r\nEnum employee_role {\r\n  courier\r\n  dispatcher\r\n  manager\r\n}\r\n\r\nEnum status_value {\r\n  pending\r\n  sorting\r\n  transit\r\n  delivered\r\n  exception\r\n}\r\n\r\nTableGroup fulfillment {\r\n  logistics.parcels\r\n  logistics.vehicles\r\n  logistics.hubs\r\n}\r\n\r\nTable logistics.drivers {\r\n  id int [pk, increment]\r\n  email varchar(255) [not null, unique]\r\n  full_name varchar(120)\r\n  role employee_role [not null, default: 'courier']\r\n  joined_at timestamp [not null, default: 'now()']\r\n}\r\n\r\nTable logistics.insurance_policies {\r\n  id int [pk, increment]\r\n  driver_id int [not null]\r\n  coverage_plan varchar(20) [not null]\r\n  expires_on date [not null]\r\n  auto_renew boolean [not null, default: true]\r\n}\r\n\r\nTable logistics.parcels {\r\n  id int [pk, increment]\r\n  tracking_number varchar(200) [not null]\r\n  hub_id int\r\n  weight_kg int\r\n  estimated_days int\r\n  service_level varchar(10)\r\n}\r\n\r\nTable logistics.vehicles {\r\n  id int [pk, increment]\r\n  license_plate varchar(160) [not null]\r\n  last_service date\r\n}\r\n\r\nTable logistics.hubs {\r\n  id int [pk, increment]\r\n  name varchar(80) [not null, unique]\r\n}\r\n\r\nTable logistics.delivery_manifests {\r\n  id int [pk, increment]\r\n  parcel_id int [not null]\r\n  driver_id int [not null]\r\n  status status_value [not null]\r\n  checkpoint varchar(200)\r\n  notes text\r\n\r\n  Indexes {\r\n    (parcel_id, driver_id) [unique]\r\n  }\r\n}\r\n\r\nTable logistics.telemetry_history {\r\n  driver_id int [not null]\r\n  parcel_id int [not null]\r\n  logged_at timestamp [not null, default: 'now()']\r\n\r\n  Indexes {\r\n    (driver_id, logged_at)\r\n  }\r\n}\r\n\r\nRef: logistics.insurance_policies.driver_id &gt; logistics.drivers.id\r\nRef: logistics.delivery_manifests.parcel_id &gt; logistics.parcels.id\r\nRef: logistics.delivery_manifests.driver_id &gt; logistics.drivers.id\r\nRef: logistics.telemetry_history.driver_id &gt; logistics.drivers.id\r\nRef: logistics.telemetry_history.parcel_id &gt; logistics.parcels.id\r\nRef: logistics.hubs.id &lt; logistics.parcels.hub_id\r\nRef: logistics.parcels.id &lt;&gt; logistics.vehicles.id\r\nRef: logistics.drivers.id - logistics.insurance_policies.id<\/code><\/pre>                <\/div>\r\n                <div class=\"vpascode-actions\">\r\n                    <a href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqtVE1r20AQvRv8H\/aWGFyTBFJKCL6VUugh\/biFsKylsTTxane7O3JsSv57ZyXZki3FbqC3\/Zo38968nQdvnyEhsdQApG2GG\/FnPBIiVaQWKoCkrYM7cfFgA2Uefn7\/djEevY5H49FnUxYCCqftFkB6q6GOTGzpEXwFgsEpSvJ6VyijsrhswwMpKoNcK1020Q5MiiaLy2A9NUvyygSkChM0rsFDGjewScARWtOA\/lILDV+8LZ1YlnqJWhdgqEaO5AJhEmZO+QR0ODxcQ46JhqPTvFyELnbnKvWxjlCDYyqQEz261ZQXiYeY96kqsVCoxZpT5spf3tzeTsSjsSRMqfVUlAZ\/l1A95IK1NKqA\/ePrm6tJvKm0PVS6A5HCUpWauEeN8hcV3LNFA6lUJAgLYKELNxxl7MvlJMYMskQTShY\/AemsxgThLOFaF7l7sEv5VHuDr9gE0mllWlGuJkfvYOPQQ5DWRCPC0a0qyUoPBl7EwrIaDDXEjHyl7CCtxgLnuLDvkhV7ULJZF+A7FfdKZqc0nOPuBTDLSa6y3QF3AAumkspUbcPuNIBfI2urYQ2tSa5j2wfL3pn0XN3cKTChkpk6fvrYq1qrQLKpopL6jcTxH5xLeuDdT1fDPh\/+SvWf3koeEbhkqc7mqvs3bLJTBqwHzuHcObJoDsnK2Rja7XZF0BJLT7ChSEKIryaFza4ZQlzui5q2NbAKnT\/++oYABJq5ESuQ84n122YIn2BySgEGzt7394fo7LNPW8BJl8UPWN6dHBWzlsC8PzlnmPYw+k6YtUTn\/Q\/8jxjvrqPXkP8B8W4m8dfxubgfeF7Pm15Iiybu5wOTY1CwPQnx4XQ\/Mf0L6qPEEw==\" \r\n                       target=\"_blank\" \r\n                       rel=\"noopener noreferrer\" \r\n                       class=\"vpascode-fancy-btn\">\r\n                        <svg width=\"14\" height=\"14\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"margin-right: 6px;\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg>\r\n                        <span>Edit DBML in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n            <\/div>\r\n            \n<\/p><\/div>\n<div class=\"vpascode-actions\">\n<a class=\"vpascode-fancy-btn\" href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqtVE1r20AQvRv8H\/aWGFyTBFJKCL6VUugh\/biFsKylsTTxane7O3JsSv57ZyXZki3FbqC3\/Zo38968nQdvnyEhsdQApG2GG\/FnPBIiVaQWKoCkrYM7cfFgA2Uefn7\/djEevY5H49FnUxYCCqftFkB6q6GOTGzpEXwFgsEpSvJ6VyijsrhswwMpKoNcK1020Q5MiiaLy2A9NUvyygSkChM0rsFDGjewScARWtOA\/lILDV+8LZ1YlnqJWhdgqEaO5AJhEmZO+QR0ODxcQ46JhqPTvFyELnbnKvWxjlCDYyqQEz261ZQXiYeY96kqsVCoxZpT5spf3tzeTsSjsSRMqfVUlAZ\/l1A95IK1NKqA\/ePrm6tJvKm0PVS6A5HCUpWauEeN8hcV3LNFA6lUJAgLYKELNxxl7MvlJMYMskQTShY\/AemsxgThLOFaF7l7sEv5VHuDr9gE0mllWlGuJkfvYOPQQ5DWRCPC0a0qyUoPBl7EwrIaDDXEjHyl7CCtxgLnuLDvkhV7ULJZF+A7FfdKZqc0nOPuBTDLSa6y3QF3AAumkspUbcPuNIBfI2urYQ2tSa5j2wfL3pn0XN3cKTChkpk6fvrYq1qrQLKpopL6jcTxH5xLeuDdT1fDPh\/+SvWf3koeEbhkqc7mqvs3bLJTBqwHzuHcObJoDsnK2Rja7XZF0BJLT7ChSEKIryaFza4ZQlzui5q2NbAKnT\/++oYABJq5ESuQ84n122YIn2BySgEGzt7394fo7LNPW8BJl8UPWN6dHBWzlsC8PzlnmPYw+k6YtUTn\/Q\/8jxjvrqPXkP8B8W4m8dfxubgfeF7Pm15Iiybu5wOTY1CwPQnx4XQ\/Mf0L6qPEEw==\" rel=\"noopener noreferrer\" target=\"_blank\"><br \/>\n<svg fill=\"none\" height=\"14\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2.5\" style=\"margin-right: 6px;\" viewbox=\"0 0 24 24\" width=\"14\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg><br \/>\n<span>VPasCode\u3067DBML\u3092\u7de8\u96c6<\/span><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p id=\"loamZJe\"><img fetchpriority=\"high\" alt=\"Complete FleetLogix Logistics Database ERD Diagram\" class=\"alignnone wp-image-1952 size-full\" decoding=\"async\" fetchpriority=\"high\" height=\"987\" sizes=\"(max-width: 1458px) 100vw, 1458px\" src=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587d56acff.png\" srcset=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587d56acff.png 1458w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587d56acff-300x203.png 300w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587d56acff-1024x693.png 1024w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587d56acff-768x520.png 768w\" width=\"1458\"\/><\/p>\n<p>\u00a0<\/p>\n<h2>FleetLogix\u306b\u304a\u3051\u308b\u9ad8\u5ea6\u306a\u69cb\u9020\u6280\u8853<\/h2>\n<p>DBML\u30b3\u30fc\u30c9\u306e\u7279\u5b9a\u306e\u30bb\u30af\u30b7\u30e7\u30f3\u3092\u5206\u89e3\u3059\u308b\u3053\u3068\u3067\u3001\u7570\u306a\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u6a5f\u80fd\u304c\u3069\u306e\u3088\u3046\u306b\u9023\u643a\u3057\u3066\u3044\u308b\u304b\u3092\u660e\u78ba\u306b\u793a\u3059\u3053\u3068\u304c\u3067\u304d\u308b\u3002<\/p>\n<h3>1. \u30c9\u30e9\u30a4\u30d0\u30fc\u7ba1\u7406\u3001\u4fdd\u967a\u304a\u3088\u3073\u30ab\u30b9\u30bf\u30e0\u5217\u6319\u578b<\/h3>\n<p>\u30c9\u30e9\u30a4\u30d0\u30fc\u767b\u9332\u304a\u3088\u3073\u4fdd\u8b77\u30e2\u30c7\u30eb\u306f\u30ab\u30b9\u30bf\u30e0\u5217\u6319\u578b\uff08<code>employee_role<\/code>\uff09\u3001\u53b3\u683c\u306a\u5236\u7d04\uff08<code>unique<\/code>, <code>not null<\/code>\uff09\u3001\u304a\u3088\u30732\u3064\u306e\u95a2\u4fc2\u30bf\u30a4\u30d7\uff1a\u6a19\u6e96\u306e1\u5bfe\u591a\u306e\u691c\u7d22\u3068\u660e\u793a\u7684\u306a1\u5bfe1\u306e\u30ea\u30f3\u30af\uff08<code>-<\/code>).<\/p>\n<div class=\"vpascode-viewer-container vpascode-fancy-active\">\n<div class=\"vpascode-header\">\n<span class=\"vpascode-lang-label\">DBML<\/span><br \/>\n<a class=\"vpascode-fancy-btn\" href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqFUstuAjEMvK+0\/+AbrMSrSFx66K3nSlVvCK1M1oDbrJMmXiiq+u\/dB5RCEb05mfHYM8mjVCVQ6a3bE+XBWYLPNAEwrgpMoSkLjh7VbLpTiYLrpvxKkzR5wWXdYd2ao7KJoyLwlkLsNLgAFoW5fxvUhQlUkuiiQahEtrDFYDYY+tPZLIO5OAWprB1AJfxeUUtc1Re5YEk\/5LvpJGuQdtXzxX9JFLTCyuo99A5Geq3cq2OhIkcF5ZKiYumvd4nb9bOm56pLllgFFEO5d5YN07+Gu1zyI+E4ctFFXUN1prm3KKdQJtkFjz48B4q5EyhQ6QLFSl0eSGgHS1enUUtdc6ahTba1NR7Dk9BQ3bB+1P1hRwhkUdlJ3LBPk2da3d90PjpZe\/j7EUZcnE9yQsdBxokGNHp74kkIhrcX4eIbUzj0lQ==\" rel=\"noopener noreferrer\" target=\"_blank\"><br \/>\n<svg fill=\"none\" height=\"14\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2.5\" style=\"margin-right: 8px;\" viewbox=\"0 0 24 24\" width=\"14\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg><br \/>\n<span>VPasCode\u3067DBML\u3092\u7de8\u96c6\u3059\u308b<\/span><br \/>\n<\/a>\n<\/div>\n<div class=\"vpascode-code-wrapper\">\n            <div class=\"vpascode-viewer-container vpascode-fancy-active\">\r\n                                <div class=\"vpascode-header\">\r\n                    <span class=\"vpascode-lang-label\">DBML<\/span>\r\n                    <a href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqNkl9PE0EUxd+b9DvcN2hSCiXhhQe\/CDGbYfcWR2dn1tnZAjE8dMcCio0SoY0+EPljjDbRFx4gIfBhrgP2W7jdphYoNrzec+ac\/Z2s2+5cv\/vkDnYAw0iodURPK4HwqlgAoLRL9oLS016z1WvsuY+H+dVuUXpM6TnZXbKWbIPsceYbaAdkW\/mjs+F1o1goFshu9q+2TbYLQq3w2HA\/rgSa11HHgzoeAJcGlqIXZfiz9cPt7Lujjnv75WlfxJBxAXWm\/WdMT88vLJRgSSoDMhGiDInkLxPMjbXs4EkW4j9zdX6u1FdysLuYtyICrLFEmEWYGseeypOfKy4x8JgBw0OMDQujhwOkWp0u9d9MQucyTjSTPnqREtzn+JgVBnt5Q8+wPNd8lUlsJcsTTI6Wmivd8+FaxDXGnpIQMIP3VJYY5WmUuArLKpsoi3qI0eh87hxwdhaq7telO\/lMjZ9k35D9TukJ2Q8Zdq999PsqLRbc+\/Sm+W1xIn9lRPdk\/B+p8OBWWXW8yn3dvTl9\/f\/CUQ7MTP4OHvwF7yxONQ==\" \r\n                       target=\"_blank\" \r\n                       rel=\"noopener noreferrer\" \r\n                       class=\"vpascode-fancy-btn\">\r\n                        <svg width=\"14\" height=\"14\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"margin-right: 8px;\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg>\r\n                        <span>Edit DBML in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n                                <div class=\"vpascode-code-wrapper\">\r\n                    <pre class=\"lang-dbml\"><code class=\"language-dbml\" data-language=\"dbml\" class=\"language-dbml\">\u5217\u6319\u578b employee_role {\r\n  \u30ab\u30fc\u30b4\u914d\u9054\u54e1\r\n  \u30c7\u30a3\u30b9\u30d1\u30c3\u30c1\u30e3\u30fc\r\n  \u30de\u30cd\u30fc\u30b8\u30e3\u30fc\r\n}\r\n\r\n\u30c6\u30fc\u30d6\u30eb logistics.drivers {\r\n  id int [pk, \u81ea\u52d5\u5897\u52a0]\r\n  email varchar(255) [not null, unique]\r\n  full_name varchar(120)\r\n  role employee_role [not null, default: '\u30ab\u30fc\u30b4\u914d\u9054\u54e1']\r\n  joined_at timestamp [not null, default: 'now()']\r\n}\r\n\r\n\u30c6\u30fc\u30d6\u30eb logistics.insurance_policies {\r\n  id int [pk, \u81ea\u52d5\u5897\u52a0]\r\n  driver_id int [not null]\r\n  coverage_plan varchar(20) [not null]\r\n  expires_on date [not null]\r\n  auto_renew boolean [not null, default: true]\r\n}\r\n\r\n\/\/ 1\u5bfe\u591a\u306e\u30c9\u30e9\u30a4\u30d0\u30fc\u95a2\u4fc2\r\n\u53c2\u7167: logistics.insurance_policies.driver_id &gt; logistics.drivers.id\r\n\r\n\/\/ 1\u5bfe1\u306e\u30c9\u30e9\u30a4\u30d0\u30fc\u5951\u7d04\u95a2\u4fc2\r\n\u53c2\u7167: logistics.drivers.id - logistics.insurance_policies.id<\/code><\/pre>                <\/div>\r\n                <div class=\"vpascode-actions\">\r\n                    <a href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqNkl9PE0EUxd+b9DvcN2hSCiXhhQe\/CDGbYfcWR2dn1tnZAjE8dMcCio0SoY0+EPljjDbRFx4gIfBhrgP2W7jdphYoNrzec+ac\/Z2s2+5cv\/vkDnYAw0iodURPK4HwqlgAoLRL9oLS016z1WvsuY+H+dVuUXpM6TnZXbKWbIPsceYbaAdkW\/mjs+F1o1goFshu9q+2TbYLQq3w2HA\/rgSa11HHgzoeAJcGlqIXZfiz9cPt7Lujjnv75WlfxJBxAXWm\/WdMT88vLJRgSSoDMhGiDInkLxPMjbXs4EkW4j9zdX6u1FdysLuYtyICrLFEmEWYGseeypOfKy4x8JgBw0OMDQujhwOkWp0u9d9MQucyTjSTPnqREtzn+JgVBnt5Q8+wPNd8lUlsJcsTTI6Wmivd8+FaxDXGnpIQMIP3VJYY5WmUuArLKpsoi3qI0eh87hxwdhaq7telO\/lMjZ9k35D9TukJ2Q8Zdq999PsqLRbc+\/Sm+W1xIn9lRPdk\/B+p8OBWWXW8yn3dvTl9\/f\/CUQ7MTP4OHvwF7yxONQ==\" \r\n                       target=\"_blank\" \r\n                       rel=\"noopener noreferrer\" \r\n                       class=\"vpascode-fancy-btn\">\r\n                        <svg width=\"14\" height=\"14\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"margin-right: 6px;\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg>\r\n                        <span>Edit DBML in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n            <\/div>\r\n            \n<\/p><\/div>\n<div class=\"vpascode-actions\">\n<a class=\"vpascode-fancy-btn\" href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqFUstuAjEMvK+0\/+AbrMSrSFx66K3nSlVvCK1M1oDbrJMmXiiq+u\/dB5RCEb05mfHYM8mjVCVQ6a3bE+XBWYLPNAEwrgpMoSkLjh7VbLpTiYLrpvxKkzR5wWXdYd2ao7KJoyLwlkLsNLgAFoW5fxvUhQlUkuiiQahEtrDFYDYY+tPZLIO5OAWprB1AJfxeUUtc1Re5YEk\/5LvpJGuQdtXzxX9JFLTCyuo99A5Geq3cq2OhIkcF5ZKiYumvd4nb9bOm56pLllgFFEO5d5YN07+Gu1zyI+E4ctFFXUN1prm3KKdQJtkFjz48B4q5EyhQ6QLFSl0eSGgHS1enUUtdc6ahTba1NR7Dk9BQ3bB+1P1hRwhkUdlJ3LBPk2da3d90PjpZe\/j7EUZcnE9yQsdBxokGNHp74kkIhrcX4eIbUzj0lQ==\" rel=\"noopener noreferrer\" target=\"_blank\"><br \/>\n<svg fill=\"none\" height=\"14\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2.5\" style=\"margin-right: 6px;\" viewbox=\"0 0 24 24\" width=\"14\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg><br \/>\n<span>VPasCode\u3067DBML\u3092\u7de8\u96c6\u3059\u308b<\/span><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p id=\"yRxuqkm\"><img alt=\"FleetLogix Drivers and Insurance ERD Layout\" class=\"alignnone wp-image-1953 size-full\" decoding=\"async\" height=\"630\" sizes=\"(max-width: 318px) 100vw, 318px\" src=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587f391dec.png\" srcset=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587f391dec.png 318w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587f391dec-151x300.png 151w\" width=\"318\"\/><\/p>\n<p>\u00a0<\/p>\n<h3>2. \u8abf\u9054\u30b0\u30eb\u30fc\u30d7\u5316\u304a\u3088\u3073\u591a\u5bfe\u591a\u95a2\u4fc2<\/h3>\n<p>\u7269\u7406\u8cc7\u7523\u5c64\u306b\u306f\u3001<code>TableGroup<\/code>\u3092\u542b\u3080<code>logistics.parcels<\/code>, <code>logistics.vehicles<\/code>\u3001\u304a\u3088\u3073<code>logistics.hubs<\/code>\u3002\u3053\u308c\u306f\u9006\u95a2\u4fc2\u6f14\u7b97\u5b50\uff08<code>&lt;<\/code>\uff09\u3092\u5730\u57df\u914d\u9001\u30cf\u30d6\u306b\u4f7f\u7528\u3057\u3001\u30d1\u30c3\u30b1\u30fc\u30b8\u3068\u914d\u9001\u8eca\u4e21\u306e\u9593\u306b\u306f\u591a\u5bfe\u591a\u95a2\u4fc2\u6f14\u7b97\u5b50\uff08<code>&lt;&gt;<\/code>\uff09\u3092\u4f7f\u7528\u3057\u3066\u3044\u308b\u3002<\/p>\n<div class=\"vpascode-viewer-container vpascode-fancy-active\">\n<div class=\"vpascode-header\">\n<span class=\"vpascode-lang-label\">DBML<\/span><br \/>\n<a class=\"vpascode-fancy-btn\" href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqFkctuwjAQRfdI\/MMsQeLVLqqqQmy7qipV7BCyjDMkFhMnHdtBqOq\/d9IQaAmIXTK2z7m+XuoN4SsXsYRtpK0lytEF+Or3AKhIrQ\/W+Emp2SD5\/8MKM2sIL6ZZ3Mjku9\/r95Y1u0tp4DYBK6JVuRvJh2Gsvet6JbA2O+tS5WK+QYZKjmWaB4+z2RBWrgjgItHvVpGpBlT\/7dGmWVC7tB2geHMdMFGJPvh26pEra1ARVkgn+sNseCN2e897uUmgzqMqSZRn7lMnNWkf1DEFJLL5hriu8p7U6fzsev6rGkF09jPi+kifTuHd4TgU41y7A0QvFQNLB+wRNHOxh8QymmALB4O5tPGB25eLOBNJMu8+6aR5iKPmTfgnD6PU0SAXXWZ7vsYurnQuCz8rM9\/A\" rel=\"noopener noreferrer\" target=\"_blank\"><br \/>\n<svg fill=\"none\" height=\"14\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2.5\" style=\"margin-right: 8px;\" viewbox=\"0 0 24 24\" width=\"14\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg><br \/>\n<span>VPasCode\u3067DBML\u3092\u7de8\u96c6<\/span><br \/>\n<\/a>\n<\/div>\n<div class=\"vpascode-code-wrapper\">\n            <div class=\"vpascode-viewer-container vpascode-fancy-active\">\r\n                                <div class=\"vpascode-header\">\r\n                    <span class=\"vpascode-lang-label\">DBML<\/span>\r\n                    <a href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqFkT1LAzEYx\/eD+w4ZLZS+OIhI6eou3UoJ6d3Tu9Dn0jP3IiKC7SA6iC9DBxexCDqpq1Dqh6ln7dSvYM72bO1ZuiX\/JL\/fP0mF1RF2ZStwSSPABkd0QPjkSNcIwZbFPZ8bXs5l0gD0\/oYh2NxAWErtoK6SY13TtUrMTlOmcG4SrkRVt5lVA0NC7K3FK75kRpMLi4rAqYMkoTpmM7mxWShkSFW0fCICxJ+tSkanoHh2ANyyfdq0kgCU12E+mNRkh16SeiBDbgBFCAF\/6cVCZkXt5J7reqOCCg+oi0o5526lWiPzfDprQUy1eYU4fsp1UsGcuWt7UZUlgeD7AdRm9HyeFKOXQfRwO+72Pt47w87N+OT0s\/sWXV0P28+ju1508Trpn5Um\/fNh+\/Hr\/ml0OdC1PWjsLHXKqTql9L\/mpr8xcynPoi0GlxU5BUwOx8zyP6+uFr4BCV34vA==\" \r\n                       target=\"_blank\" \r\n                       rel=\"noopener noreferrer\" \r\n                       class=\"vpascode-fancy-btn\">\r\n                        <svg width=\"14\" height=\"14\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"margin-right: 8px;\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg>\r\n                        <span>Edit DBML in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n                                <div class=\"vpascode-code-wrapper\">\r\n                    <pre class=\"lang-dbml\"><code class=\"language-dbml\" data-language=\"dbml\" class=\"language-dbml\">TableGroup fulfillment {\r\n  logistics.parcels\r\n  logistics.vehicles\r\n  logistics.hubs\r\n}\r\n\r\nTable logistics.parcels {\r\n  id int [pk, increment]\r\n  tracking_number varchar(200) [not null]\r\n  hub_id int\r\n  weight_kg int\r\n  estimated_days int\r\n  service_level varchar(10)\r\n}\r\n\r\nTable logistics.vehicles {\r\n  id int [pk, increment]\r\n  license_plate varchar(160) [not null]\r\n  last_service date\r\n}\r\n\r\nTable logistics.hubs {\r\n  id int [pk, increment]\r\n  name varchar(80) [not null, unique]\r\n}\r\n\r\n\/\/ 1\u5bfe\u591a\u95a2\u4fc2\u3092\u9006\u65b9\u5411\u306e\u77e2\u5370\uff08&lt;\uff09\u3067\u8868\u73fe\r\nRef: logistics.hubs.id &lt; logistics.parcels.hub_id\r\n\r\n\/\/ \u591a\u5bfe\u591a\u95a2\u4fc2\uff08&lt;&gt;\uff09\r\nRef: logistics.parcels.id &lt;&gt; logistics.vehicles.id<\/code><\/pre>                <\/div>\r\n                <div class=\"vpascode-actions\">\r\n                    <a href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqFkT1LAzEYx\/eD+w4ZLZS+OIhI6eou3UoJ6d3Tu9Dn0jP3IiKC7SA6iC9DBxexCDqpq1Dqh6ln7dSvYM72bO1ZuiX\/JL\/fP0mF1RF2ZStwSSPABkd0QPjkSNcIwZbFPZ8bXs5l0gD0\/oYh2NxAWErtoK6SY13TtUrMTlOmcG4SrkRVt5lVA0NC7K3FK75kRpMLi4rAqYMkoTpmM7mxWShkSFW0fCICxJ+tSkanoHh2ANyyfdq0kgCU12E+mNRkh16SeiBDbgBFCAF\/6cVCZkXt5J7reqOCCg+oi0o5526lWiPzfDprQUy1eYU4fsp1UsGcuWt7UZUlgeD7AdRm9HyeFKOXQfRwO+72Pt47w87N+OT0s\/sWXV0P28+ju1508Trpn5Um\/fNh+\/Hr\/ml0OdC1PWjsLHXKqTql9L\/mpr8xcynPoi0GlxU5BUwOx8zyP6+uFr4BCV34vA==\" \r\n                       target=\"_blank\" \r\n                       rel=\"noopener noreferrer\" \r\n                       class=\"vpascode-fancy-btn\">\r\n                        <svg width=\"14\" height=\"14\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"margin-right: 6px;\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg>\r\n                        <span>Edit DBML in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n            <\/div>\r\n            \n<\/p><\/div>\n<div class=\"vpascode-actions\">\n<a class=\"vpascode-fancy-btn\" href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqFkctuwjAQRfdI\/MMsQeLVLqqqQmy7qipV7BCyjDMkFhMnHdtBqOq\/d9IQaAmIXTK2z7m+XuoN4SsXsYRtpK0lytEF+Or3AKhIrQ\/W+Emp2SD5\/8MKM2sIL6ZZ3Mjku9\/r95Y1u0tp4DYBK6JVuRvJh2Gsvet6JbA2O+tS5WK+QYZKjmWaB4+z2RBWrgjgItHvVpGpBlT\/7dGmWVC7tB2geHMdMFGJPvh26pEra1ARVkgn+sNseCN2e897uUmgzqMqSZRn7lMnNWkf1DEFJLL5hriu8p7U6fzsev6rGkF09jPi+kifTuHd4TgU41y7A0QvFQNLB+wRNHOxh8QymmALB4O5tPGB25eLOBNJMu8+6aR5iKPmTfgnD6PU0SAXXWZ7vsYurnQuCz8rM9\/A\" rel=\"noopener noreferrer\" target=\"_blank\"><br \/>\n<svg fill=\"none\" height=\"14\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2.5\" style=\"margin-right: 6px;\" viewbox=\"0 0 24 24\" width=\"14\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg><br \/>\n<span>VPasCode\u3067DBML\u3092\u7de8\u96c6<\/span><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p id=\"LmaoFsI\"><img alt=\"FleetLogix Fulfillment TableGroup ERD\" class=\"alignnone wp-image-1954 size-full\" decoding=\"async\" height=\"816\" sizes=\"(max-width: 344px) 100vw, 344px\" src=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a75880d339d0.png\" srcset=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a75880d339d0.png 344w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a75880d339d0-126x300.png 126w\" width=\"344\"\/><\/p>\n<p>\u00a0<\/p>\n<h3>3. \u5b9f\u6642\u9593\u8ffd\u8de1\u3001\u8907\u5408\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3001\u30b9\u30c6\u30fc\u30bf\u30b9\u5217\u6319\u578b<\/h3>\n<p>\u30de\u30cb\u30d5\u30a7\u30b9\u30c8\u3068\u30c6\u30ec\u30e1\u30c8\u30ea\u30e2\u30b8\u30e5\u30fc\u30eb\u306f\u3001\u30a2\u30af\u30c6\u30a3\u30d6\u306a\u914d\u9001\u7269\u306e\u53d6\u308a\u6271\u3044\u3092\u76e3\u8996\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u3089\u306f\u8ffd\u8de1\u72b6\u614b\u306e\u5217\u6319\u578b\uff08<code>status_value<\/code>\uff09\u3092\u4f7f\u7528\u3057\u3001\u5358\u4e00\u306e\u8907\u5408\u4e00\u610f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff08\u4f8b\uff1a<code>(parcel_id, driver_id) [unique]<\/code>\uff09\u306b\u3088\u308a\u30ec\u30b3\u30fc\u30c9\u306e\u6574\u5408\u6027\u3092\u4fdd\u3061\u3001\u9ad8\u901f\u306a\u6642\u7cfb\u5217\u30b9\u30ad\u30e3\u30f3\u306e\u305f\u3081\u306b\u8907\u6570\u30ab\u30e9\u30e0\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3092\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<div class=\"vpascode-viewer-container vpascode-fancy-active\">\n<div class=\"vpascode-header\">\n<span class=\"vpascode-lang-label\">DBML<\/span><br \/>\n<a class=\"vpascode-fancy-btn\" href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqtkk1uwjAQhfeRcofZARKKKEsW7HqBqjuEImNPwMKxU3tMQRV375hQAuJ30d0kHn\/z3hu\/21hDIEExlBthIsJPngE0aJW2y1QG5+lYkhc2aEqlQqM36FGlD9xKbEg7m2f7PMuzT7EwCMYtdSAtQ9EIL9GEFq0VaEswa9ZDLqTHGi3Nj3i55lEla1qghw1fWwnfH49GA5hZR2CjMfM7Q5RPgp4OqRhRWlHjCf82fgnfGt6VtbC6wkBPJ7Wuy7+GswEc30Hs7bN2G5dLueyQK5TrxqWr5xmlI+7DAIRbSiZYnlW4xaNWgP5J1LDTwO6j1V8RD\/D9nQAIDXsjTmDFf5zftcxHTh4lwOAlqlIQkK45TlE3XQeLw0pEQxPoWffdH\/Tmt+2cpg874ODcxQdWk4dbLDqR0+snW2j1CqMLYXr9Im8xrsL8D8QzJ7+ozVOT\" rel=\"noopener noreferrer\" target=\"_blank\"><br \/>\n<svg fill=\"none\" height=\"14\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2.5\" style=\"margin-right: 8px;\" viewbox=\"0 0 24 24\" width=\"14\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg><br \/>\n<span>VPasCode\u3067DBML\u3092\u7de8\u96c6<\/span><br \/>\n<\/a>\n<\/div>\n<div class=\"vpascode-code-wrapper\">\n            <div class=\"vpascode-viewer-container vpascode-fancy-active\">\r\n                                <div class=\"vpascode-header\">\r\n                    <span class=\"vpascode-lang-label\">DBML<\/span>\r\n                    <a href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqtkk1uwjAQhfeRcofZARKKKEsW7HqBqjuEImNPwMKxU3tMQRV375hQAuJ30d0kHn\/z3hu\/21hDIEExlBthIsJPngE0aJW2y1QG5+lYkhc2aEqlQqM36FGlD9xKbEg7m2f7PMuzT7EwCMYtdSAtQ9EIL9GEFq0VaEswa9ZDLqTHGi3Nj3i55lEla1qghw1fWwnfH49GA5hZR2CjMfM7Q5RPgp4OqRhRWlHjCf82fgnfGt6VtbC6wkBPJ7Wuy7+GswEc30Hs7bN2G5dLueyQK5TrxqWr5xmlI+7DAIRbSiZYnlW4xaNWgP5J1LDTwO6j1V8RD\/D9nQAIDXsjTmDFf5zftcxHTh4lwOAlqlIQkK45TlE3XQeLw0pEQxPoWffdH\/Tmt+2cpg874ODcxQdWk4dbLDqR0+snW2j1CqMLYXr9Im8xrsL8D8QzJ7+ozVOT\" \r\n                       target=\"_blank\" \r\n                       rel=\"noopener noreferrer\" \r\n                       class=\"vpascode-fancy-btn\">\r\n                        <svg width=\"14\" height=\"14\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"margin-right: 8px;\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg>\r\n                        <span>Edit DBML in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n                                <div class=\"vpascode-code-wrapper\">\r\n                    <pre class=\"lang-dbml\"><code class=\"language-dbml\" data-language=\"dbml\" class=\"language-dbml\">Enum status_value {\r\n  pending\r\n  sorting\r\n  transit\r\n  delivered\r\n  exception\r\n}\r\n\r\nTable logistics.parcels {\r\n  id int [pk, increment]\r\n  tracking_number varchar(200) [not null]\r\n}\r\n\r\nTable logistics.drivers {\r\n  id int [pk, increment]\r\n  full_name varchar(120) [not null]\r\n}\r\n\r\nTable logistics.delivery_manifests {\r\n  id int [pk, increment]\r\n  parcel_id int [not null]\r\n  driver_id int [not null]\r\n  status status_value [not null]\r\n  checkpoint varchar(200)\r\n  notes text\r\n\r\n  indexes {\r\n    (parcel_id, driver_id) [unique]\r\n  }\r\n}\r\n\r\nTable logistics.telemetry_history {\r\n  driver_id int [not null]\r\n  parcel_id int [not null]\r\n  logged_at timestamp [not null, default: 'now()']\r\n\r\n  indexes {\r\n    (driver_id, logged_at)\r\n  }\r\n}\r\n\r\nRef: logistics.delivery_manifests.parcel_id &gt; logistics.parcels.id\r\nRef: logistics.delivery_manifests.driver_id &gt; logistics.drivers.id\r\nRef: logistics.telemetry_history.driver_id &gt; logistics.drivers.id\r\nRef: logistics.telemetry_history.parcel_id &gt; logistics.parcels.id<\/code><\/pre>                <\/div>\r\n                <div class=\"vpascode-actions\">\r\n                    <a href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqtkk1uwjAQhfeRcofZARKKKEsW7HqBqjuEImNPwMKxU3tMQRV375hQAuJ30d0kHn\/z3hu\/21hDIEExlBthIsJPngE0aJW2y1QG5+lYkhc2aEqlQqM36FGlD9xKbEg7m2f7PMuzT7EwCMYtdSAtQ9EIL9GEFq0VaEswa9ZDLqTHGi3Nj3i55lEla1qghw1fWwnfH49GA5hZR2CjMfM7Q5RPgp4OqRhRWlHjCf82fgnfGt6VtbC6wkBPJ7Wuy7+GswEc30Hs7bN2G5dLueyQK5TrxqWr5xmlI+7DAIRbSiZYnlW4xaNWgP5J1LDTwO6j1V8RD\/D9nQAIDXsjTmDFf5zftcxHTh4lwOAlqlIQkK45TlE3XQeLw0pEQxPoWffdH\/Tmt+2cpg874ODcxQdWk4dbLDqR0+snW2j1CqMLYXr9Im8xrsL8D8QzJ7+ozVOT\" \r\n                       target=\"_blank\" \r\n                       rel=\"noopener noreferrer\" \r\n                       class=\"vpascode-fancy-btn\">\r\n                        <svg width=\"14\" height=\"14\" viewBox=\"0 0 24 24\" fill=\"none\" stroke=\"currentColor\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\" style=\"margin-right: 6px;\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg>\r\n                        <span>Edit DBML in VPasCode<\/span>\r\n                    <\/a>\r\n                <\/div>\r\n            <\/div>\r\n            \n<\/p><\/div>\n<div class=\"vpascode-actions\">\n<a class=\"vpascode-fancy-btn\" href=\"https:\/\/www.vpascode.com\/editor\/#dbml:eNqtkk1uwjAQhfeRcofZARKKKEsW7HqBqjuEImNPwMKxU3tMQRV375hQAuJ30d0kHn\/z3hu\/21hDIEExlBthIsJPngE0aJW2y1QG5+lYkhc2aEqlQqM36FGlD9xKbEg7m2f7PMuzT7EwCMYtdSAtQ9EIL9GEFq0VaEswa9ZDLqTHGi3Nj3i55lEla1qghw1fWwnfH49GA5hZR2CjMfM7Q5RPgp4OqRhRWlHjCf82fgnfGt6VtbC6wkBPJ7Wuy7+GswEc30Hs7bN2G5dLueyQK5TrxqWr5xmlI+7DAIRbSiZYnlW4xaNWgP5J1LDTwO6j1V8RD\/D9nQAIDXsjTmDFf5zftcxHTh4lwOAlqlIQkK45TlE3XQeLw0pEQxPoWffdH\/Tmt+2cpg874ODcxQdWk4dbLDqR0+snW2j1CqMLYXr9Im8xrsL8D8QzJ7+ozVOT\" rel=\"noopener noreferrer\" target=\"_blank\"><br \/>\n<svg fill=\"none\" height=\"14\" stroke=\"currentColor\" stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2.5\" style=\"margin-right: 6px;\" viewbox=\"0 0 24 24\" width=\"14\"><path d=\"M11 4H4a2 2 0 0 0-2 2v14a2 2 0 0 0 2 2h14a2 2 0 0 0 2-2v-7\"><\/path><path d=\"M18.5 2.5a2.121 2.121 0 0 1 3 3L12 15l-4 1 1-4 9.5-9.5z\"><\/path><\/svg><br \/>\n<span>VPasCode\u3067DBML\u3092\u7de8\u96c6<\/span><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p id=\"ITtmmgt\"><img loading=\"lazy\" alt=\"\" class=\"alignnone size-full wp-image-1955\" decoding=\"async\" height=\"544\" loading=\"lazy\" sizes=\"auto, (max-width: 765px) 100vw, 765px\" src=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7588ae93ae9.png\" srcset=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7588ae93ae9.png 765w, https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7588ae93ae9-300x213.png 300w\" width=\"765\"\/><\/p>\n<h2>DBML\u306e\u6226\u7565\u7684\u30d9\u30b9\u30c8\u30d7\u30e9\u30af\u30c6\u30a3\u30b9<\/h2>\n<ul>\n<li><strong>TableGroup\u3067\u30b3\u30a2\u30b3\u30ec\u30af\u30b7\u30e7\u30f3\u3092\u6574\u7406\u3059\u308b\uff1a<\/strong> \u5bc6\u63a5\u306b\u9023\u643a\u3059\u308b\u30c6\u30fc\u30d6\u30eb\uff08\u4f8b\uff1a<code>logistics.parcels<\/code>, <code>logistics.vehicles<\/code>\u3001\u304a\u3088\u3073<code>logistics.hubs<\/code>\uff09\u3092<code>TableGroup<\/code>\u306b\u30b0\u30eb\u30fc\u30d7\u5316\u3059\u308b\u3053\u3068\u3067\u3001\u8996\u899a\u7684\u306a\u30ec\u30a4\u30a2\u30a6\u30c8\u3092\u6574\u7406\u3067\u304d\u307e\u3059\u3002<\/li>\n<li><strong>\u95a2\u4fc2\u306e\u65b9\u5411\u6027\u3092\u6b63\u3057\u304f\u4fdd\u3064\uff1a<\/strong> \u6a19\u6e96\u5316\u3057\u3066<code>&gt;<\/code>\uff08\u591a\u5bfe\u4e00\uff09\u307e\u305f\u306f<code>&lt;<\/code>(1\u5bfe\u591a) \u305d\u306e\u305f\u3081\u3001\u8996\u899a\u7684\u306a\u5916\u90e8\u30ad\u30fc\u306e\u77e2\u5370\u306f\u3001\u5b50\u30d5\u30a3\u30fc\u30eb\u30c9\u304b\u3089\u4e3b\u30ad\u30fc\u3078\u660e\u78ba\u306b\u6307\u5411\u3059\u308b\u3002<\/li>\n<li><strong>\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\u3068\u5217\u6319\u578b\u3092\u4f7f\u3063\u3066\u3001\u30d3\u30b8\u30cd\u30b9\u30eb\u30fc\u30eb\u3092\u5f37\u5236\u3059\u308b\uff1a<\/strong> \u8907\u5408\u4e00\u610f\u30a4\u30f3\u30c7\u30c3\u30af\u30b9\uff08\u4f8b\uff1a<code>(\u30d1\u30c3\u30b1\u30fc\u30b8ID\u3001\u30c9\u30e9\u30a4\u30d0\u30fcID) [\u4e00\u610f]<\/code>\uff09\u304a\u3088\u3073\u30ab\u30b9\u30bf\u30e0\u5217\u6319\u578b\uff08\u4f8b\uff1a<code>\u30b9\u30c6\u30fc\u30bf\u30b9\u5024<\/code>\uff09\u3092\u7528\u3044\u3066\u3001\u30b9\u30ad\u30fc\u30de\u30ec\u30d9\u30eb\u3067\u30d3\u30b8\u30cd\u30b9\u5236\u7d04\u3092\u5f37\u5236\u3059\u308b\u3002<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>\u7269\u6d41\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3001\u30b5\u30d7\u30e9\u30a4\u30c1\u30a7\u30fc\u30f3\u904b\u7528\u3001\u307e\u305f\u306f\u53d7\u6ce8\u51e6\u7406\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u8a2d\u8a08\u3059\u308b&#8230;<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":999,"template":"","meta":{"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"ld_collection":[14],"class_list":["post-2022","ld_docs","type-ld_docs","status-publish","hentry","ld_collection-vpascode-docs"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DBML to Diagram Guide | Text to Diagram with VPasCode<\/title>\n<meta name=\"description\" content=\"Learn how to transform DBML files, table constraints, composite indexes, relationships, and table groups into clear interactive entity-relationship diagrams (ERDs) using VPasCode.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DBML to Diagram Guide | Text to Diagram with VPasCode\" \/>\n<meta property=\"og:description\" content=\"Learn how to transform DBML files, table constraints, composite indexes, relationships, and table groups into clear interactive entity-relationship diagrams (ERDs) using VPasCode.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"VPasCode\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587d56acff.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data1\" content=\"3\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/docs\\\/vpascode-docs\\\/data-and-schemas\\\/dbml-visualizer-guide\\\/\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/docs\\\/vpascode-docs\\\/data-and-schemas\\\/dbml-visualizer-guide\\\/\",\"name\":\"DBML to Diagram Guide | Text to Diagram with VPasCode\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/docs\\\/vpascode-docs\\\/data-and-schemas\\\/dbml-visualizer-guide\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/docs\\\/vpascode-docs\\\/data-and-schemas\\\/dbml-visualizer-guide\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.vpascode.com\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/img_6a7587d56acff.png\",\"datePublished\":\"2026-08-07T07:04:34+00:00\",\"description\":\"Learn how to transform DBML files, table constraints, composite indexes, relationships, and table groups into clear interactive entity-relationship diagrams (ERDs) using VPasCode.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/docs\\\/vpascode-docs\\\/data-and-schemas\\\/dbml-visualizer-guide\\\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/docs\\\/vpascode-docs\\\/data-and-schemas\\\/dbml-visualizer-guide\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/docs\\\/vpascode-docs\\\/data-and-schemas\\\/dbml-visualizer-guide\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/img_6a7587d56acff.png\",\"contentUrl\":\"https:\\\/\\\/www.vpascode.com\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/img_6a7587d56acff.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/docs\\\/vpascode-docs\\\/data-and-schemas\\\/dbml-visualizer-guide\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Lean Docs\",\"item\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/docs\\\/%ld_collection%\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DBML\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/#website\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/\",\"name\":\"VPasCode\",\"description\":\"by Visual Paradigm\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/#organization\",\"name\":\"VPasCode\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/wp-content\\\/uploads\\\/sites\\\/8\\\/2026\\\/06\\\/cropped-vp-online-logo-v1.png\",\"contentUrl\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/wp-content\\\/uploads\\\/sites\\\/8\\\/2026\\\/06\\\/cropped-vp-online-logo-v1.png\",\"width\":128,\"height\":138,\"caption\":\"VPasCode\"},\"image\":{\"@id\":\"https:\\\/\\\/www.vpascode.com\\\/ja\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DBML to Diagram Guide | Text to Diagram with VPasCode","description":"Learn how to transform DBML files, table constraints, composite indexes, relationships, and table groups into clear interactive entity-relationship diagrams (ERDs) using VPasCode.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/","og_locale":"ja_JP","og_type":"article","og_title":"DBML to Diagram Guide | Text to Diagram with VPasCode","og_description":"Learn how to transform DBML files, table constraints, composite indexes, relationships, and table groups into clear interactive entity-relationship diagrams (ERDs) using VPasCode.","og_url":"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/","og_site_name":"VPasCode","og_image":[{"url":"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587d56acff.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"3\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/","url":"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/","name":"DBML to Diagram Guide | Text to Diagram with VPasCode","isPartOf":{"@id":"https:\/\/www.vpascode.com\/ja\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/#primaryimage"},"image":{"@id":"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/#primaryimage"},"thumbnailUrl":"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587d56acff.png","datePublished":"2026-08-07T07:04:34+00:00","description":"Learn how to transform DBML files, table constraints, composite indexes, relationships, and table groups into clear interactive entity-relationship diagrams (ERDs) using VPasCode.","breadcrumb":{"@id":"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/#primaryimage","url":"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587d56acff.png","contentUrl":"https:\/\/www.vpascode.com\/wp-content\/uploads\/2026\/08\/img_6a7587d56acff.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.vpascode.com\/ja\/docs\/vpascode-docs\/data-and-schemas\/dbml-visualizer-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vpascode.com\/ja\/"},{"@type":"ListItem","position":2,"name":"Lean Docs","item":"https:\/\/www.vpascode.com\/ja\/docs\/%ld_collection%\/"},{"@type":"ListItem","position":3,"name":"DBML"}]},{"@type":"WebSite","@id":"https:\/\/www.vpascode.com\/ja\/#website","url":"https:\/\/www.vpascode.com\/ja\/","name":"VPasCode","description":"by Visual Paradigm","publisher":{"@id":"https:\/\/www.vpascode.com\/ja\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vpascode.com\/ja\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":"Organization","@id":"https:\/\/www.vpascode.com\/ja\/#organization","name":"VPasCode","url":"https:\/\/www.vpascode.com\/ja\/","logo":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/www.vpascode.com\/ja\/#\/schema\/logo\/image\/","url":"https:\/\/www.vpascode.com\/ja\/wp-content\/uploads\/sites\/8\/2026\/06\/cropped-vp-online-logo-v1.png","contentUrl":"https:\/\/www.vpascode.com\/ja\/wp-content\/uploads\/sites\/8\/2026\/06\/cropped-vp-online-logo-v1.png","width":128,"height":138,"caption":"VPasCode"},"image":{"@id":"https:\/\/www.vpascode.com\/ja\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.vpascode.com\/ja\/wp-json\/wp\/v2\/ld_docs\/2022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vpascode.com\/ja\/wp-json\/wp\/v2\/ld_docs"}],"about":[{"href":"https:\/\/www.vpascode.com\/ja\/wp-json\/wp\/v2\/types\/ld_docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.vpascode.com\/ja\/wp-json\/wp\/v2\/users\/3"}],"wp:attachment":[{"href":"https:\/\/www.vpascode.com\/ja\/wp-json\/wp\/v2\/media?parent=2022"}],"wp:term":[{"taxonomy":"ld_collection","embeddable":true,"href":"https:\/\/www.vpascode.com\/ja\/wp-json\/wp\/v2\/ld_collection?post=2022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}