diff options
Diffstat (limited to 'db/migrations/0360_dear_medusa.sql')
| -rw-r--r-- | db/migrations/0360_dear_medusa.sql | 137 |
1 files changed, 137 insertions, 0 deletions
diff --git a/db/migrations/0360_dear_medusa.sql b/db/migrations/0360_dear_medusa.sql new file mode 100644 index 00000000..9a095fdd --- /dev/null +++ b/db/migrations/0360_dear_medusa.sql @@ -0,0 +1,137 @@ +CREATE TABLE "avl_list" ( + "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "avl_list_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1), + "is_template" boolean DEFAULT false, + "construction_sector" varchar(10) NOT NULL, + "project_code" varchar(50), + "ship_type" varchar(50), + "avl_kind" varchar(50), + "ht_division" varchar(10), + "rev" integer DEFAULT 1, + "created_at" timestamp DEFAULT now(), + "created_by" varchar(50), + "updated_at" timestamp DEFAULT now(), + "updated_by" varchar(50) +); +--> statement-breakpoint +CREATE TABLE "avl_vendor_info" ( + "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "avl_vendor_info_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1), + "project_code" varchar(50), + "avl_list_id" integer, + "owner_suggestion" boolean DEFAULT false, + "shi_suggestion" boolean DEFAULT false, + "equip_bulk_division" varchar(1), + "discipline_code" varchar(10), + "discipline_name" varchar(50), + "material_name_customer_side" varchar(100), + "package_code" varchar(50), + "package_name" varchar(100), + "material_group_code" varchar(50), + "material_group_name" varchar(100), + "vendor_id" integer, + "vendor_name" varchar(100), + "vendor_code" varchar(50), + "avl_vendor_name" varchar(100), + "tier" varchar(20), + "fa_target" boolean DEFAULT false, + "fa_status" varchar(50), + "is_agent" boolean DEFAULT false, + "contract_signer_id" integer, + "contract_signer_name" varchar(100), + "contract_signer_code" varchar(50), + "headquarter_location" varchar(50), + "manufacturing_location" varchar(50), + "has_avl" boolean DEFAULT false, + "is_blacklist" boolean DEFAULT false, + "is_bcc" boolean DEFAULT false, + "tech_quote_number" varchar(50), + "quote_code" varchar(50), + "quote_vendor_id" integer, + "quote_vendor_name" varchar(100), + "quote_vendor_code" varchar(50), + "quote_country" varchar(50), + "quote_total_amount" numeric(15, 2), + "quote_received_date" varchar(10), + "recent_quote_date" varchar(10), + "recent_quote_number" varchar(50), + "recent_order_date" varchar(10), + "recent_order_number" varchar(50), + "remark" varchar(1000), + "created_at" timestamp DEFAULT now(), + "updated_at" timestamp DEFAULT now() +); +--> statement-breakpoint +CREATE TABLE "vendor_pool" ( + "id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "vendor_pool_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1), + "construction_sector" varchar(10) NOT NULL, + "ht_division" varchar(10) NOT NULL, + "design_category_code" varchar(2) NOT NULL, + "design_category" varchar(50) NOT NULL, + "equip_bulk_division" varchar(1) NOT NULL, + "package_code" varchar(50), + "package_name" varchar(100), + "material_group_code" varchar(50), + "material_group_name" varchar(100), + "sm_code" varchar(50), + "similar_material_name_purchase" varchar(100), + "similar_material_name_other" varchar(100), + "vendor_code" varchar(50), + "vendor_name" varchar(100), + "tax_id" varchar(50), + "fa_target" boolean DEFAULT false, + "fa_status" varchar(50), + "fa_remark" varchar(200), + "tier" varchar(20), + "is_agent" boolean DEFAULT false, + "contract_signer_code" varchar(50), + "contract_signer_name" varchar(100), + "headquarter_location" varchar(50), + "manufacturing_location" varchar(50), + "avl_vendor_name" varchar(100), + "similar_vendor_name" varchar(100), + "has_avl" boolean DEFAULT false, + "is_blacklist" boolean DEFAULT false, + "is_bcc" boolean DEFAULT false, + "purchase_opinion" varchar(500), + "ship_type_common" boolean DEFAULT false, + "ship_type_amax" boolean DEFAULT false, + "ship_type_smax" boolean DEFAULT false, + "ship_type_vlcc" boolean DEFAULT false, + "ship_type_lngc" boolean DEFAULT false, + "ship_type_cont" boolean DEFAULT false, + "offshore_type_common" boolean DEFAULT false, + "offshore_type_fpso" boolean DEFAULT false, + "offshore_type_flng" boolean DEFAULT false, + "offshore_type_fpu" boolean DEFAULT false, + "offshore_type_platform" boolean DEFAULT false, + "offshore_type_wtiv" boolean DEFAULT false, + "offshore_type_gom" boolean DEFAULT false, + "pic_name" varchar(50), + "pic_email" varchar(100), + "pic_phone" varchar(20), + "agent_name" varchar(50), + "agent_email" varchar(100), + "agent_phone" varchar(20), + "recent_quote_date" varchar(10), + "recent_quote_number" varchar(50), + "recent_order_date" varchar(10), + "recent_order_number" varchar(50), + "registration_date" timestamp DEFAULT now(), + "registrant" varchar(50), + "last_modified_date" timestamp DEFAULT now(), + "last_modifier" varchar(50) +); +--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_EquipInfo" CASCADE;--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_MainternanceBOM" CASCADE;--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_MaterialInfo" CASCADE;--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_MaterialPurchase" CASCADE;--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_MaterialReceiving" CASCADE;--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_MaterialRelease" CASCADE;--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_MaterialRepair" CASCADE;--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_MaterialStock" CASCADE;--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_Order" CASCADE;--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_OrderBreakdown" CASCADE;--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_OrderConfirm" CASCADE;--> statement-breakpoint +DROP TABLE "S-ERP"."TB_SAP_OrderNotice" CASCADE;--> statement-breakpoint +ALTER TABLE "avl_vendor_info" ADD CONSTRAINT "avl_vendor_info_avl_list_id_avl_list_id_fk" FOREIGN KEY ("avl_list_id") REFERENCES "public"."avl_list"("id") ON DELETE no action ON UPDATE no action;--> statement-breakpoint +DROP SCHEMA "S-ERP"; |