PostgreSQL 建表语句

1 CREATE SEQUENCE "mic00001"."asset_list_move_id_seq"
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

2 CREATE TABLE "mic00001"."asset_list_move" (
  "id" int8 NOT NULL DEFAULT nextval('sasset_list_move_id_seq'::regclass),
"source_id" int8 NOT NULL,
"target_id" int8 NOT NULL,
 "started_by" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
 "started_time" timestamptz(6) NOT NULL,
"started_remarks" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
"finished_by" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
 "finished_time" timestamptz(6) NOT NULL,
"finished_remarks" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
PRIMARY KEY ("id")
)

3 ALTER SEQUENCE "mic00001"."asset_list_move_id_seq"
OWNED BY "mic00001"."asset_list_move"."id";
 
4ALTER TABLE "mic00001"."asset_list_move"
  OWNER TO "eam_admin";