-- ----------------------------
-- 表结构: sys_driver_info
-- ----------------------------
DROP TABLE IF EXISTS "public"."sys_driver_info";
CREATE TABLE "public"."sys_driver_info" (
    "user_id" int8 NOT NULL,
    "license_type" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
    "create_by" varchar(64) COLLATE "pg_catalog"."default",
    "create_time" timestamp(6),
    "update_by" varchar(64) COLLATE "pg_catalog"."default",
    "update_time" timestamp(6),
    "remark" varchar(500) COLLATE "pg_catalog"."default"
);
COMMENT ON COLUMN "public"."sys_driver_info"."user_id" IS '用户ID';
COMMENT ON COLUMN "public"."sys_driver_info"."license_type" IS '驾驶证类型';
COMMENT ON COLUMN "public"."sys_driver_info"."create_by" IS '创建者';
COMMENT ON COLUMN "public"."sys_driver_info"."create_time" IS '创建时间';
COMMENT ON COLUMN "public"."sys_driver_info"."update_by" IS '更新者';
COMMENT ON COLUMN "public"."sys_driver_info"."update_time" IS '更新时间';
COMMENT ON COLUMN "public"."sys_driver_info"."remark" IS '备注';
COMMENT ON TABLE "public"."sys_driver_info" IS '驾驶员信息表';

-- ----------------------------
-- 主键结构: table sys_driver_info
-- ----------------------------
ALTER TABLE "public"."sys_driver_info" ADD CONSTRAINT "sys_driver_info_pkey" PRIMARY KEY ("user_id");

-- ----------------------------
-- 外键结构: table sys_driver_info
-- ----------------------------
ALTER TABLE "public"."sys_driver_info" ADD CONSTRAINT "sys_driver_info_fk1" FOREIGN KEY ("user_id") REFERENCES "public"."sys_user" ("user_id") ON DELETE NO ACTION ON UPDATE NO ACTION; 