CREATE SEQUENCE "public"."resource_table_role_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;



CREATE TABLE "public"."role" (
  "id" int4 NOT NULL DEFAULT nextval('resource_table_role_seq'::regclass),
  "name" varchar(255) COLLATE "pg_catalog"."default",
  "data_range" int4,
  "delete" bool NOT NULL,
  PRIMARY KEY ("id")
)
;


COMMENT ON COLUMN "public"."role"."name" IS '角色名称';

COMMENT ON COLUMN "public"."role"."data_range" IS '1全公司2本部门';

COMMENT ON COLUMN "public"."role"."delete" IS '收否删除';