CREATE TABLE "public"."t_knowledge_base" (
  "Fid" char(36) COLLATE "pg_catalog"."default" NOT NULL,
  "Fhost_name" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "Fname" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "Fuser_id" char(32) COLLATE "pg_catalog"."default" NOT NULL,
  "Flast_accessed_timestamp" timestamp(6),
  "Flast_changed_timestamp" timestamp(6),
  "Flast_published_timestamp" timestamp(6),
  CONSTRAINT "t_knowledge_base_pkey" PRIMARY KEY ("Fid")
)
;

ALTER TABLE "public"."t_knowledge_base" 
  OWNER TO "root";


COMMENT ON TABLE "public"."t_knowledge_base" IS '֪ʶ¿â´æ´¢±í';

CREATE TABLE "public"."t_answer" (
  "Fid" int8 NOT NULL,
  "Fkb_id" char(36) COLLATE "pg_catalog"."default" NOT NULL,
  "Fanswer" text COLLATE "pg_catalog"."default" NOT NULL,
  "Fanswer_id" int4,
  "Fstatus" int2 DEFAULT 0,
  CONSTRAINT "t_answer_pkey" PRIMARY KEY ("Fid"),
  CONSTRAINT "t_answer_Fkb_id_fkey" FOREIGN KEY ("Fkb_id") REFERENCES "public"."t_knowledge_base" ("Fid") ON DELETE NO ACTION ON UPDATE NO ACTION
)
;

ALTER TABLE "public"."t_answer" 
  OWNER TO "root";


CREATE TABLE "public"."t_metadata" (
  "Fid" int8 NOT NULL,
  "Fanswer_id" int8 NOT NULL,
  "Fmetadata" json NOT NULL,
  CONSTRAINT "f_metadata_pkey" PRIMARY KEY ("Fid"),
  CONSTRAINT "f_metadata_Fanswer_id_fkey" FOREIGN KEY ("Fanswer_id") REFERENCES "public"."t_answer" ("Fid") ON DELETE NO ACTION ON UPDATE NO ACTION
)
;

ALTER TABLE "public"."t_metadata" 
  OWNER TO "root";


CREATE TABLE "public"."t_question" (
  "Fid" int8 NOT NULL,
  "Fanswer_id" int8 NOT NULL,
  "Fquestion" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  CONSTRAINT "t_question_pkey" PRIMARY KEY ("Fid"),
  CONSTRAINT "t_question_Fanswer_id_fkey" FOREIGN KEY ("Fanswer_id") REFERENCES "public"."t_answer" ("Fid") ON DELETE NO ACTION ON UPDATE NO ACTION
)
;

ALTER TABLE "public"."t_question" 
  OWNER TO "root";