From 0b34ad848972943d0225fce7fdde1ff0ed0307c4 Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期五, 30 五月 2025 18:00:25 +0800 Subject: [PATCH] 供应商 --- ruoyi-common/src/main/resources/db/migration/postgresql/V20250530152701__create_table_supply.sql | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 57 insertions(+), 0 deletions(-) diff --git a/ruoyi-common/src/main/resources/db/migration/postgresql/V20250530152701__create_table_supply.sql b/ruoyi-common/src/main/resources/db/migration/postgresql/V20250530152701__create_table_supply.sql new file mode 100644 index 0000000..e96683a --- /dev/null +++ b/ruoyi-common/src/main/resources/db/migration/postgresql/V20250530152701__create_table_supply.sql @@ -0,0 +1,57 @@ +DROP TABLE IF EXISTS supply; + +CREATE TABLE supply +( + id BIGSERIAL PRIMARY KEY, + supplier_name VARCHAR(255) NOT NULL, -- 渚涘簲鍟嗗悕绉� + taxpayer_id VARCHAR(255) NOT NULL, -- 绾崇◣浜鸿瘑鍒彿 + business_address VARCHAR(255) NOT NULL DEFAULT '', -- 缁忚惀鍦板潃 + bank_account VARCHAR(255) NOT NULL DEFAULT '', -- 閾惰璐﹀彿 + bank_name VARCHAR(255) NOT NULL DEFAULT '', -- 寮�鎴疯 + contact_person VARCHAR(255) NOT NULL DEFAULT '', -- 鑱旂郴浜� + contact_address VARCHAR(255) NOT NULL DEFAULT '', -- 鑱旂郴鍦板潃 + province_id BIGINT NOT NULL DEFAULT 0, + city_id BIGINT NOT NULL DEFAULT 0, + district_id BIGINT NOT NULL DEFAULT 0, + create_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP -- 鑷姩濉厖鍒涘缓鏃堕棿 +); + +-- 琛ㄦ敞閲婏細渚涘簲鍟嗕俊鎭〃锛屽瓨鍌ㄤ緵搴斿晢鍩烘湰淇℃伅锛堝惈鍦板潃灞傜骇鍏宠仈锛� +COMMENT ON TABLE supply IS '渚涘簲鍟嗕俊鎭〃'; + +-- 瀛楁娉ㄩ噴锛氫富閿紙鑷澶ф暣鏁帮級 +COMMENT ON COLUMN supply.id IS '渚涘簲鍟嗗敮涓�鏍囪瘑锛岄噰鐢˙IGSERIAL鑷涓婚敭锛岀‘淇濇暟鎹敮涓�鎬�'; + +-- 渚涘簲鍟嗗悕绉帮紙闈炵┖锛� +COMMENT ON COLUMN supply.supplier_name IS '渚涘簲鍟嗗叏绉帮紝涓氬姟鍦烘櫙涓敮涓�璇嗗埆鐨勫悕绉帮紝'; + +-- 绾崇◣浜鸿瘑鍒彿锛堥潪绌猴級 +COMMENT ON COLUMN supply.taxpayer_id IS '渚涘簲鍟嗙◣鍔＄櫥璁板敮涓�鏍囪瘑锛堝缁熶竴绀句細淇＄敤浠ｇ爜锛夛紝鐢ㄤ簬璐㈢◣绠＄悊'; + +-- 缁忚惀鍦板潃锛堥粯璁ょ┖瀛楃涓诧紝闈炵┖锛� +COMMENT ON COLUMN supply.business_address IS '渚涘簲鍟嗚惀涓氭墽鐓ф敞鍐屽湴鍧�鎴栦富瑕佺粡钀ュ満鎵�锛岄粯璁ょ┖瀛楃涓�'; + +-- 閾惰璐﹀彿锛堥粯璁ょ┖瀛楃涓诧紝闈炵┖锛� +COMMENT ON COLUMN supply.bank_account IS '渚涘簲鍟嗘敹娆鹃摱琛岃处鎴蜂俊鎭紝榛樿绌哄瓧绗︿覆锛岀敤浜庤祫閲戝線鏉�'; + +-- 寮�鎴疯锛堥粯璁ょ┖瀛楃涓诧紝闈炵┖锛� +COMMENT ON COLUMN supply.bank_name IS '渚涘簲鍟嗛摱琛岃处鎴风殑寮�鎴锋満鏋勫悕绉帮紝榛樿绌哄瓧绗︿覆锛�'; + +-- 鑱旂郴浜猴紙榛樿绌哄瓧绗︿覆锛岄潪绌猴級 +COMMENT ON COLUMN supply.contact_person IS '渚涘簲鍟嗕笟鍔″鎺ヤ汉濮撳悕'; + +-- 鑱旂郴鍦板潃锛堥粯璁ょ┖瀛楃涓诧紝闈炵┖锛� +COMMENT ON COLUMN supply.contact_address IS '渚涘簲鍟嗚仈绯讳汉鐨勮仈绯诲湴鍧�'; + +-- 鐪佷唤ID锛堥粯璁�0锛岄潪绌猴紝鍏宠仈鍦板潃瀛楀吀锛� +COMMENT ON COLUMN supply.province_id IS '渚涘簲鍟嗘墍鍦ㄧ渷浠界殑ID锛堝叧鑱斿湴鍧�瀛楀吀琛級锛岄粯璁�0'; + +-- 鍩庡競ID锛堥粯璁�0锛岄潪绌猴紝鍏宠仈鍦板潃瀛楀吀锛� +COMMENT ON COLUMN supply.city_id IS '渚涘簲鍟嗘墍鍦ㄥ煄甯傜殑ID锛堝叧鑱斿湴鍧�瀛楀吀琛級锛岄粯璁�0'; + +-- 鍖哄幙ID锛堥粯璁�0锛岄潪绌猴紝鍏宠仈鍦板潃瀛楀吀锛� +COMMENT ON COLUMN supply.district_id IS '渚涘簲鍟嗘墍鍦ㄥ尯鍘跨殑ID锛堝叧鑱斿湴鍧�瀛楀吀琛級锛岄粯璁�0锛岀敤浜庡湴鍧�灞傜骇鍒掑垎'; + +-- 鍒涘缓鏃堕棿锛堝甫鏃跺尯锛岃嚜鍔ㄥ～鍏咃級 +COMMENT ON COLUMN supply.create_time IS '璁板綍鏁版嵁鍒涘缓鐨勬椂闂存埑锛堝甫鏃跺尯锛夛紝绯荤粺鑷姩濉厖褰撳墠鏃堕棿'; + -- Gitblit v1.9.3