You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
585 lines
18 KiB
585 lines
18 KiB
-- ----------------------------
|
|
-- Sequence structure for t_exam_paper_answer_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_exam_paper_answer_id_seq";
|
|
CREATE SEQUENCE "public"."t_exam_paper_answer_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_exam_paper_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_exam_paper_id_seq";
|
|
CREATE SEQUENCE "public"."t_exam_paper_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_exam_paper_question_customer_answer_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_exam_paper_question_customer_answer_id_seq";
|
|
CREATE SEQUENCE "public"."t_exam_paper_question_customer_answer_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_message_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_message_id_seq";
|
|
CREATE SEQUENCE "public"."t_message_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_message_user_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_message_user_id_seq";
|
|
CREATE SEQUENCE "public"."t_message_user_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_question_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_question_id_seq";
|
|
CREATE SEQUENCE "public"."t_question_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_subject_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_subject_id_seq";
|
|
CREATE SEQUENCE "public"."t_subject_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_task_exam_customer_answer_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_task_exam_customer_answer_id_seq";
|
|
CREATE SEQUENCE "public"."t_task_exam_customer_answer_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_task_exam_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_task_exam_id_seq";
|
|
CREATE SEQUENCE "public"."t_task_exam_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_text_content_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_text_content_id_seq";
|
|
CREATE SEQUENCE "public"."t_text_content_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_user_event_log_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_user_event_log_id_seq";
|
|
CREATE SEQUENCE "public"."t_user_event_log_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_user_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_user_id_seq";
|
|
CREATE SEQUENCE "public"."t_user_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Sequence structure for t_user_token_id_seq
|
|
-- ----------------------------
|
|
DROP SEQUENCE IF EXISTS "public"."t_user_token_id_seq";
|
|
CREATE SEQUENCE "public"."t_user_token_id_seq"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_exam_paper
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_exam_paper";
|
|
CREATE TABLE "public"."t_exam_paper" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_exam_paper_id_seq'::regclass),
|
|
"name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"subject_id" int4,
|
|
"paper_type" int4,
|
|
"grade_level" int4,
|
|
"score" int4,
|
|
"question_count" int4,
|
|
"suggest_time" int4,
|
|
"limit_start_time" timestamp(6),
|
|
"limit_end_time" timestamp(6),
|
|
"frame_text_content_id" int4,
|
|
"create_user" int4,
|
|
"create_time" timestamp(6),
|
|
"deleted" bool,
|
|
"task_exam_id" int4
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_exam_paper
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_exam_paper_answer
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_exam_paper_answer";
|
|
CREATE TABLE "public"."t_exam_paper_answer" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_exam_paper_answer_id_seq'::regclass),
|
|
"exam_paper_id" int4,
|
|
"paper_name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"paper_type" int4,
|
|
"subject_id" int4,
|
|
"system_score" int4,
|
|
"user_score" int4,
|
|
"paper_score" int4,
|
|
"question_correct" int4,
|
|
"question_count" int4,
|
|
"do_time" int4,
|
|
"status" int4,
|
|
"create_user" int4,
|
|
"create_time" timestamp(6),
|
|
"task_exam_id" int4
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_exam_paper_answer
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_exam_paper_question_customer_answer
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_exam_paper_question_customer_answer";
|
|
CREATE TABLE "public"."t_exam_paper_question_customer_answer" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_exam_paper_question_customer_answer_id_seq'::regclass),
|
|
"question_id" int4,
|
|
"exam_paper_id" int4,
|
|
"exam_paper_answer_id" int4,
|
|
"question_type" int4,
|
|
"subject_id" int4,
|
|
"customer_score" int4,
|
|
"question_score" int4,
|
|
"question_text_content_id" int4,
|
|
"answer" varchar(255) COLLATE "pg_catalog"."default",
|
|
"text_content_id" int4,
|
|
"do_right" bool,
|
|
"create_user" int4,
|
|
"create_time" timestamp(6),
|
|
"item_order" int4
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_exam_paper_question_customer_answer
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_message
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_message";
|
|
CREATE TABLE "public"."t_message" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_message_id_seq'::regclass),
|
|
"title" varchar(255) COLLATE "pg_catalog"."default",
|
|
"content" varchar(500) COLLATE "pg_catalog"."default",
|
|
"send_user_id" int4,
|
|
"send_user_name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"send_real_name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"read_count" int4,
|
|
"receive_user_count" int4,
|
|
"create_time" timestamp(6)
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_message
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_message_user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_message_user";
|
|
CREATE TABLE "public"."t_message_user" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_message_user_id_seq'::regclass),
|
|
"message_id" int4,
|
|
"receive_user_id" int4,
|
|
"receive_user_name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"receive_real_name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"readed" bool,
|
|
"read_time" timestamp(6),
|
|
"create_time" timestamp(6)
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_message_user
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_question
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_question";
|
|
CREATE TABLE "public"."t_question" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_question_id_seq'::regclass),
|
|
"question_type" int4,
|
|
"subject_id" int4,
|
|
"score" int4,
|
|
"grade_level" int4,
|
|
"difficult" int4,
|
|
"correct" text COLLATE "pg_catalog"."default",
|
|
"info_text_content_id" int4,
|
|
"create_user" int4,
|
|
"status" int4,
|
|
"create_time" timestamp(6),
|
|
"deleted" bool
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_question
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_subject
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_subject";
|
|
CREATE TABLE "public"."t_subject" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_subject_id_seq'::regclass),
|
|
"name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"level" int4,
|
|
"level_name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"item_order" int4,
|
|
"deleted" bool
|
|
)
|
|
;
|
|
|
|
|
|
-- ----------------------------
|
|
-- Records of t_subject
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_task_exam
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_task_exam";
|
|
CREATE TABLE "public"."t_task_exam" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_task_exam_id_seq'::regclass),
|
|
"title" varchar(255) COLLATE "pg_catalog"."default",
|
|
"grade_level" int4,
|
|
"frame_text_content_id" int4,
|
|
"create_user" int4,
|
|
"create_user_name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"create_time" timestamp(6),
|
|
"deleted" bool
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_task_exam
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_task_exam_customer_answer
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_task_exam_customer_answer";
|
|
CREATE TABLE "public"."t_task_exam_customer_answer" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_task_exam_customer_answer_id_seq'::regclass),
|
|
"task_exam_id" int4,
|
|
"text_content_id" int4,
|
|
"create_user" int4,
|
|
"create_time" timestamp(6)
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_task_exam_customer_answer
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_text_content
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_text_content";
|
|
CREATE TABLE "public"."t_text_content" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_text_content_id_seq'::regclass),
|
|
"content" text COLLATE "pg_catalog"."default",
|
|
"create_time" timestamp(6)
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_text_content
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_user
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_user";
|
|
CREATE TABLE "public"."t_user" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_user_id_seq'::regclass),
|
|
"user_uuid" uuid,
|
|
"user_name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"password" varchar(255) COLLATE "pg_catalog"."default",
|
|
"real_name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"age" int4,
|
|
"sex" int4,
|
|
"birth_day" timestamp(6),
|
|
"user_level" int4,
|
|
"phone" varchar(255) COLLATE "pg_catalog"."default",
|
|
"role" int4,
|
|
"status" int4,
|
|
"image_path" varchar(255) COLLATE "pg_catalog"."default",
|
|
"create_time" timestamp(6),
|
|
"modify_time" timestamp(6),
|
|
"last_active_time" timestamp(6),
|
|
"deleted" bool,
|
|
"wx_open_id" varchar COLLATE "pg_catalog"."default"
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_user
|
|
-- ----------------------------
|
|
INSERT INTO "public"."t_user" VALUES (2, '55bad52c-cdf7-4321-87b8-e37d958b24cf', 'admin', 'D1AGFL+Gx37t0NPG4d6biYP5Z31cNbwhK5w1lUeiHB2zagqbk8efYfSjYoh1Z/j1dkiRjHU+b0EpwzCh8IGsksJjzD65ci5LsnodQVf4Uj6D3pwoscXGqmkjjpzvSJbx42swwNTA+QoDU8YLo7JhtbUK2X0qCjFGpd+8eJ5BGvk=', '管理员', 18, 1, '2019-09-02 00:00:00', 13, '1561651651616156', 3, 1, NULL, '2019-07-23 07:17:16.923', '2020-02-08 10:52:42.234', '2019-07-23 07:17:16.923', 'f', NULL);
|
|
INSERT INTO "public"."t_user" VALUES (1, 'b41eaab1-926a-4824-94e8-da9259986ab6', 'student', 'RA6atJcbedAQUA/3jTcC85RuVuedZEgkeWUCiagtwhz6SjEKerC4IvFQe1OGSvbk+tPZGfkInRrmipPgHU6tzcpaQfdJkV9cXSGoxyldrWSFxblfpGGDxVisQrtrH7N1AEyi6u3h4iYrwkf4sPV8xoU8ZpOhlKmLEjDEq/an6rQ=', '学生', 16, 2, '1979-06-05 00:00:00', 1, '19171171610', 1, 1, 'https://www.mindskip.net:9008/image/ba607a75-83ba-4530-8e23-660b72dc4953/头像.jpg', '2019-07-23 05:02:29.027', '2020-02-05 09:36:52.138', '2019-07-23 05:02:29.027', 'f', NULL);
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_user_event_log
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_user_event_log";
|
|
CREATE TABLE "public"."t_user_event_log" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_user_event_log_id_seq'::regclass),
|
|
"user_id" int4,
|
|
"user_name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"real_name" varchar(255) COLLATE "pg_catalog"."default",
|
|
"content" text COLLATE "pg_catalog"."default",
|
|
"create_time" timestamp(6)
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_user_event_log
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Table structure for t_user_token
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."t_user_token";
|
|
CREATE TABLE "public"."t_user_token" (
|
|
"id" int4 NOT NULL DEFAULT nextval('t_user_token_id_seq'::regclass),
|
|
"token" uuid,
|
|
"user_id" int4,
|
|
"wx_open_id" varchar(255) COLLATE "pg_catalog"."default",
|
|
"create_time" timestamp(6),
|
|
"end_time" timestamp(6),
|
|
"user_name" varchar(255) COLLATE "pg_catalog"."default"
|
|
)
|
|
;
|
|
|
|
-- ----------------------------
|
|
-- Records of t_user_token
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_exam_paper_answer_id_seq"
|
|
OWNED BY "public"."t_exam_paper_answer"."id";
|
|
SELECT setval('"public"."t_exam_paper_answer_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_exam_paper_id_seq"
|
|
OWNED BY "public"."t_exam_paper"."id";
|
|
SELECT setval('"public"."t_exam_paper_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_exam_paper_question_customer_answer_id_seq"
|
|
OWNED BY "public"."t_exam_paper_question_customer_answer"."id";
|
|
SELECT setval('"public"."t_exam_paper_question_customer_answer_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_message_id_seq"
|
|
OWNED BY "public"."t_message"."id";
|
|
SELECT setval('"public"."t_message_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_message_user_id_seq"
|
|
OWNED BY "public"."t_message_user"."id";
|
|
SELECT setval('"public"."t_message_user_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_question_id_seq"
|
|
OWNED BY "public"."t_question"."id";
|
|
SELECT setval('"public"."t_question_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_subject_id_seq"
|
|
OWNED BY "public"."t_subject"."id";
|
|
SELECT setval('"public"."t_subject_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_task_exam_customer_answer_id_seq"
|
|
OWNED BY "public"."t_task_exam_customer_answer"."id";
|
|
SELECT setval('"public"."t_task_exam_customer_answer_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_task_exam_id_seq"
|
|
OWNED BY "public"."t_task_exam"."id";
|
|
SELECT setval('"public"."t_task_exam_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_text_content_id_seq"
|
|
OWNED BY "public"."t_text_content"."id";
|
|
SELECT setval('"public"."t_text_content_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_user_event_log_id_seq"
|
|
OWNED BY "public"."t_user_event_log"."id";
|
|
SELECT setval('"public"."t_user_event_log_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_user_id_seq"
|
|
OWNED BY "public"."t_user"."id";
|
|
SELECT setval('"public"."t_user_id_seq"', 3, true);
|
|
|
|
-- ----------------------------
|
|
-- Alter sequences owned by
|
|
-- ----------------------------
|
|
ALTER SEQUENCE "public"."t_user_token_id_seq"
|
|
OWNED BY "public"."t_user_token"."id";
|
|
SELECT setval('"public"."t_user_token_id_seq"', 1, true);
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_exam_paper
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_exam_paper" ADD CONSTRAINT "t_exam_paper_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_exam_paper_answer
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_exam_paper_answer" ADD CONSTRAINT "t_exam_paper_answer_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_exam_paper_question_customer_answer
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_exam_paper_question_customer_answer" ADD CONSTRAINT "t_exam_paper_question_customer_answer_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_message
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_message" ADD CONSTRAINT "t_message_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_message_user
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_message_user" ADD CONSTRAINT "t_message_user_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_question
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_question" ADD CONSTRAINT "t_question_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_subject
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_subject" ADD CONSTRAINT "t_subject_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_task_exam
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_task_exam" ADD CONSTRAINT "t_task_exam_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_task_exam_customer_answer
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_task_exam_customer_answer" ADD CONSTRAINT "t_task_exam_customer_answer_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_text_content
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_text_content" ADD CONSTRAINT "t_text_content_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_user
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_user" ADD CONSTRAINT "t_user_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_user_event_log
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_user_event_log" ADD CONSTRAINT "t_user_event_log_pkey" PRIMARY KEY ("id");
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table t_user_token
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."t_user_token" ADD CONSTRAINT "t_user_token_pkey" PRIMARY KEY ("id");
|