创建一个表,表名为 t_users_maintain, 模式为public(默认模式)。
创建表时,如果不指定模式,则默认表属于public模式。
DROP TABLE IF EXISTS "public"."t_users_maintain";
CREATE TABLE "public"."t_users_maintain"
(
"id" serial,
"username" varchar(255) COLLATE "pg_catalog"."default",
"password" varchar(255) COLLATE "pg_catalog"."default",
"rightlevel" int4 DEFAULT 2,
"enable" int4 DEFAULT 0,
"last_login_at" timestamp(6),
"created_at" timestamp(6),
"updated_at" timestamp(6),
"remarks" varchar(255) COLLATE "pg_catalog"."default",
CONSTRAINT "t_users_maintain_pkey" PRIMARY KEY ("id")
);
ALTER TABLE "public"."t_users_maintain" OWNER TO "postgres";
COMMENT ON COLUMN "public"."t_users_maintain"."rightlevel" IS '运维人员账户等级
serial 类型会自动生成一个序列,且在删除表后,此序列会一起被删除