SiWei-Cloud/sql/postgres/t_project.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 60.220
 Source Server Type    : PostgreSQL
 Source Server Version : 170003 (170003)
 Source Host           : 192.168.60.220:5432
 Source Catalog        : one_code
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 170003 (170003)
 File Encoding         : 65001

 apply 工程中的数据库结构

 Date: 19/07/2025 09:09:57
*/


-- ----------------------------
-- Table structure for t_project
-- ----------------------------
DROP TABLE IF EXISTS "public"."t_project";
CREATE TABLE "public"."t_project" (
  "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "name" varchar(255) COLLATE "pg_catalog"."default",
  "code" varchar(255) COLLATE "pg_catalog"."default",
  "company" varchar(255) COLLATE "pg_catalog"."default",
  "created_at" timestamp(6),
  "updated_at" timestamp(6),
  "project_type" int2,
  "creator_id" varchar(255) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."t_project"."company" IS '单位';
COMMENT ON COLUMN "public"."t_project"."project_type" IS '1:单独选址，2:批次报批';
COMMENT ON TABLE "public"."t_project" IS '项目表';

-- ----------------------------
-- Primary Key structure for table t_project
-- ----------------------------
ALTER TABLE "public"."t_project" ADD CONSTRAINT "t_project_pkey" PRIMARY KEY ("id");