- backend: 25 张表 schema/seed,config 指向 127.0.0.1:15432 opc 库 - docs: 尚数网七维融合方案、行业老炮切入方案、竞品分析等 - db/0824/opc_0824.sql(.gz): pg_dump 全量备份(25 表,含数据)
2343 lines
141 KiB
SQL
2343 lines
141 KiB
SQL
--
|
||
-- PostgreSQL database dump
|
||
--
|
||
|
||
\restrict 0tjN1wfDpIxsfRbT4CdUTaSTVGi5StRuuWf7VhXTrIfjj6sIXObAW6eRep4DjlV
|
||
|
||
-- Dumped from database version 16.14
|
||
-- Dumped by pg_dump version 16.14
|
||
|
||
SET statement_timeout = 0;
|
||
SET lock_timeout = 0;
|
||
SET idle_in_transaction_session_timeout = 0;
|
||
SET client_encoding = 'UTF8';
|
||
SET standard_conforming_strings = on;
|
||
SELECT pg_catalog.set_config('search_path', '', false);
|
||
SET check_function_bodies = false;
|
||
SET xmloption = content;
|
||
SET client_min_messages = warning;
|
||
SET row_security = off;
|
||
|
||
ALTER TABLE IF EXISTS ONLY public.trainings DROP CONSTRAINT IF EXISTS trainings_cohort_id_fkey;
|
||
ALTER TABLE IF EXISTS ONLY public.team_members DROP CONSTRAINT IF EXISTS team_members_project_id_fkey;
|
||
ALTER TABLE IF EXISTS ONLY public.scenario_mappings DROP CONSTRAINT IF EXISTS scenario_mappings_scenario_id_fkey;
|
||
ALTER TABLE IF EXISTS ONLY public.scenario_mappings DROP CONSTRAINT IF EXISTS scenario_mappings_project_id_fkey;
|
||
ALTER TABLE IF EXISTS ONLY public.products DROP CONSTRAINT IF EXISTS products_project_id_fkey;
|
||
ALTER TABLE IF EXISTS ONLY public.policy_applications DROP CONSTRAINT IF EXISTS policy_applications_project_id_fkey;
|
||
ALTER TABLE IF EXISTS ONLY public.policy_applications DROP CONSTRAINT IF EXISTS policy_applications_policy_id_fkey;
|
||
ALTER TABLE IF EXISTS ONLY public.milestones DROP CONSTRAINT IF EXISTS milestones_project_id_fkey;
|
||
ALTER TABLE IF EXISTS ONLY public.compliance_logs DROP CONSTRAINT IF EXISTS compliance_logs_resource_id_fkey;
|
||
ALTER TABLE IF EXISTS ONLY public.compliance_logs DROP CONSTRAINT IF EXISTS compliance_logs_project_id_fkey;
|
||
ALTER TABLE IF EXISTS ONLY public.coachings DROP CONSTRAINT IF EXISTS coachings_project_id_fkey;
|
||
DROP INDEX IF EXISTS public.idx_tool_runs_tool;
|
||
DROP INDEX IF EXISTS public.idx_tool_runs_created;
|
||
DROP INDEX IF EXISTS public.idx_team_members_project;
|
||
DROP INDEX IF EXISTS public.idx_projects_stage;
|
||
DROP INDEX IF EXISTS public.idx_projects_direction;
|
||
DROP INDEX IF EXISTS public.idx_kpi_snapshots_date;
|
||
DROP INDEX IF EXISTS public.idx_data_resources_category;
|
||
ALTER TABLE IF EXISTS ONLY public.users DROP CONSTRAINT IF EXISTS users_username_key;
|
||
ALTER TABLE IF EXISTS ONLY public.users DROP CONSTRAINT IF EXISTS users_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.trainings DROP CONSTRAINT IF EXISTS trainings_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.tools DROP CONSTRAINT IF EXISTS tools_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.tool_runs DROP CONSTRAINT IF EXISTS tool_runs_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.team_members DROP CONSTRAINT IF EXISTS team_members_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.spaces DROP CONSTRAINT IF EXISTS spaces_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.scenarios DROP CONSTRAINT IF EXISTS scenarios_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.scenario_mappings DROP CONSTRAINT IF EXISTS scenario_mappings_project_id_scenario_id_key;
|
||
ALTER TABLE IF EXISTS ONLY public.scenario_mappings DROP CONSTRAINT IF EXISTS scenario_mappings_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.projects DROP CONSTRAINT IF EXISTS projects_slug_key;
|
||
ALTER TABLE IF EXISTS ONLY public.projects DROP CONSTRAINT IF EXISTS projects_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.products DROP CONSTRAINT IF EXISTS products_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.policy_applications DROP CONSTRAINT IF EXISTS policy_applications_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.policies DROP CONSTRAINT IF EXISTS policies_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.partners DROP CONSTRAINT IF EXISTS partners_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.news DROP CONSTRAINT IF EXISTS news_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.milestones DROP CONSTRAINT IF EXISTS milestones_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.mentors DROP CONSTRAINT IF EXISTS mentors_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.kpi_snapshots DROP CONSTRAINT IF EXISTS kpi_snapshots_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.events DROP CONSTRAINT IF EXISTS events_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.data_resources DROP CONSTRAINT IF EXISTS data_resources_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.compliance_logs DROP CONSTRAINT IF EXISTS compliance_logs_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.cohorts DROP CONSTRAINT IF EXISTS cohorts_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.coachings DROP CONSTRAINT IF EXISTS coachings_pkey;
|
||
ALTER TABLE IF EXISTS ONLY public.announcements DROP CONSTRAINT IF EXISTS announcements_pkey;
|
||
ALTER TABLE IF EXISTS public.users ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.trainings ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.tools ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.tool_runs ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.team_members ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.spaces ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.scenarios ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.scenario_mappings ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.projects ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.products ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.policy_applications ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.policies ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.partners ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.news ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.milestones ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.mentors ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.kpi_snapshots ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.events ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.data_resources ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.compliance_logs ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.cohorts ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.coachings ALTER COLUMN id DROP DEFAULT;
|
||
ALTER TABLE IF EXISTS public.announcements ALTER COLUMN id DROP DEFAULT;
|
||
DROP SEQUENCE IF EXISTS public.users_id_seq;
|
||
DROP TABLE IF EXISTS public.users;
|
||
DROP SEQUENCE IF EXISTS public.trainings_id_seq;
|
||
DROP TABLE IF EXISTS public.trainings;
|
||
DROP SEQUENCE IF EXISTS public.tools_id_seq;
|
||
DROP TABLE IF EXISTS public.tools;
|
||
DROP SEQUENCE IF EXISTS public.tool_runs_id_seq;
|
||
DROP TABLE IF EXISTS public.tool_runs;
|
||
DROP SEQUENCE IF EXISTS public.team_members_id_seq;
|
||
DROP TABLE IF EXISTS public.team_members;
|
||
DROP SEQUENCE IF EXISTS public.spaces_id_seq;
|
||
DROP TABLE IF EXISTS public.spaces;
|
||
DROP SEQUENCE IF EXISTS public.scenarios_id_seq;
|
||
DROP TABLE IF EXISTS public.scenarios;
|
||
DROP SEQUENCE IF EXISTS public.scenario_mappings_id_seq;
|
||
DROP TABLE IF EXISTS public.scenario_mappings;
|
||
DROP SEQUENCE IF EXISTS public.projects_id_seq;
|
||
DROP TABLE IF EXISTS public.projects;
|
||
DROP SEQUENCE IF EXISTS public.products_id_seq;
|
||
DROP TABLE IF EXISTS public.products;
|
||
DROP SEQUENCE IF EXISTS public.policy_applications_id_seq;
|
||
DROP TABLE IF EXISTS public.policy_applications;
|
||
DROP SEQUENCE IF EXISTS public.policies_id_seq;
|
||
DROP TABLE IF EXISTS public.policies;
|
||
DROP SEQUENCE IF EXISTS public.partners_id_seq;
|
||
DROP TABLE IF EXISTS public.partners;
|
||
DROP SEQUENCE IF EXISTS public.news_id_seq;
|
||
DROP TABLE IF EXISTS public.news;
|
||
DROP SEQUENCE IF EXISTS public.milestones_id_seq;
|
||
DROP TABLE IF EXISTS public.milestones;
|
||
DROP SEQUENCE IF EXISTS public.mentors_id_seq;
|
||
DROP TABLE IF EXISTS public.mentors;
|
||
DROP SEQUENCE IF EXISTS public.kpi_snapshots_id_seq;
|
||
DROP TABLE IF EXISTS public.kpi_snapshots;
|
||
DROP SEQUENCE IF EXISTS public.events_id_seq;
|
||
DROP TABLE IF EXISTS public.events;
|
||
DROP SEQUENCE IF EXISTS public.data_resources_id_seq;
|
||
DROP TABLE IF EXISTS public.data_resources;
|
||
DROP SEQUENCE IF EXISTS public.compliance_logs_id_seq;
|
||
DROP TABLE IF EXISTS public.compliance_logs;
|
||
DROP SEQUENCE IF EXISTS public.cohorts_id_seq;
|
||
DROP TABLE IF EXISTS public.cohorts;
|
||
DROP SEQUENCE IF EXISTS public.coachings_id_seq;
|
||
DROP TABLE IF EXISTS public.coachings;
|
||
DROP SEQUENCE IF EXISTS public.announcements_id_seq;
|
||
DROP TABLE IF EXISTS public.announcements;
|
||
-- *not* dropping schema, since initdb creates it
|
||
--
|
||
-- Name: public; Type: SCHEMA; Schema: -; Owner: -
|
||
--
|
||
|
||
-- *not* creating schema, since initdb creates it
|
||
|
||
|
||
SET default_tablespace = '';
|
||
|
||
SET default_table_access_method = heap;
|
||
|
||
--
|
||
-- Name: announcements; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.announcements (
|
||
id bigint NOT NULL,
|
||
title character varying(255) NOT NULL,
|
||
content text,
|
||
pinned boolean DEFAULT false NOT NULL,
|
||
published_at timestamp with time zone DEFAULT now() NOT NULL,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: announcements_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.announcements_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: announcements_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.announcements_id_seq OWNED BY public.announcements.id;
|
||
|
||
|
||
--
|
||
-- Name: coachings; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.coachings (
|
||
id bigint NOT NULL,
|
||
project_id bigint NOT NULL,
|
||
mentor_name character varying(80) NOT NULL,
|
||
mentor_org character varying(120),
|
||
topic character varying(64) NOT NULL,
|
||
scheduled_at timestamp with time zone,
|
||
duration_min integer DEFAULT 60,
|
||
status character varying(32) DEFAULT 'scheduled'::character varying NOT NULL,
|
||
notes text,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: coachings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.coachings_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: coachings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.coachings_id_seq OWNED BY public.coachings.id;
|
||
|
||
|
||
--
|
||
-- Name: cohorts; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.cohorts (
|
||
id bigint NOT NULL,
|
||
name character varying(120) NOT NULL,
|
||
theme character varying(120),
|
||
start_date timestamp with time zone,
|
||
end_date timestamp with time zone,
|
||
capacity integer DEFAULT 30 NOT NULL,
|
||
enrolled integer DEFAULT 0 NOT NULL,
|
||
status character varying(32) DEFAULT 'planning'::character varying NOT NULL,
|
||
description text,
|
||
created_at timestamp with time zone DEFAULT now()
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: cohorts_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.cohorts_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: cohorts_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.cohorts_id_seq OWNED BY public.cohorts.id;
|
||
|
||
|
||
--
|
||
-- Name: compliance_logs; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.compliance_logs (
|
||
id bigint NOT NULL,
|
||
project_id bigint,
|
||
resource_id bigint,
|
||
action character varying(64) NOT NULL,
|
||
operator character varying(80) NOT NULL,
|
||
result character varying(32) NOT NULL,
|
||
notes text,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: compliance_logs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.compliance_logs_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: compliance_logs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.compliance_logs_id_seq OWNED BY public.compliance_logs.id;
|
||
|
||
|
||
--
|
||
-- Name: data_resources; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.data_resources (
|
||
id bigint NOT NULL,
|
||
title character varying(160) NOT NULL,
|
||
category character varying(64) NOT NULL,
|
||
domain character varying(64) NOT NULL,
|
||
size_gb numeric(12,2) DEFAULT 0,
|
||
rows_count bigint DEFAULT 0,
|
||
license character varying(64) DEFAULT '授权使用'::character varying NOT NULL,
|
||
description text,
|
||
apply_count integer DEFAULT 0 NOT NULL,
|
||
available boolean DEFAULT true NOT NULL,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: data_resources_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.data_resources_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: data_resources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.data_resources_id_seq OWNED BY public.data_resources.id;
|
||
|
||
|
||
--
|
||
-- Name: events; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.events (
|
||
id bigint NOT NULL,
|
||
title character varying(160) NOT NULL,
|
||
type character varying(32) NOT NULL,
|
||
host character varying(120),
|
||
event_date date,
|
||
location character varying(120),
|
||
projects integer DEFAULT 0 NOT NULL,
|
||
leads integer DEFAULT 0 NOT NULL,
|
||
deals integer DEFAULT 0 NOT NULL,
|
||
summary text,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: events_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.events_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: events_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.events_id_seq OWNED BY public.events.id;
|
||
|
||
|
||
--
|
||
-- Name: kpi_snapshots; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.kpi_snapshots (
|
||
id bigint NOT NULL,
|
||
metric_key character varying(64) NOT NULL,
|
||
metric_name character varying(120) NOT NULL,
|
||
value numeric(14,2) NOT NULL,
|
||
target numeric(14,2),
|
||
unit character varying(32),
|
||
snap_date date NOT NULL,
|
||
category character varying(32) NOT NULL,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: kpi_snapshots_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.kpi_snapshots_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: kpi_snapshots_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.kpi_snapshots_id_seq OWNED BY public.kpi_snapshots.id;
|
||
|
||
|
||
--
|
||
-- Name: mentors; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.mentors (
|
||
id bigint NOT NULL,
|
||
name character varying(80) NOT NULL,
|
||
title character varying(120),
|
||
org character varying(120),
|
||
domain character varying(64) NOT NULL,
|
||
years_exp integer DEFAULT 0,
|
||
bio text,
|
||
avatar character varying(255),
|
||
rating numeric(3,1) DEFAULT 5.0,
|
||
cases integer DEFAULT 0 NOT NULL,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: mentors_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.mentors_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: mentors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.mentors_id_seq OWNED BY public.mentors.id;
|
||
|
||
|
||
--
|
||
-- Name: milestones; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.milestones (
|
||
id bigint NOT NULL,
|
||
project_id bigint NOT NULL,
|
||
title character varying(160) NOT NULL,
|
||
stage character varying(32) NOT NULL,
|
||
happened_at date,
|
||
evidence text,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: milestones_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.milestones_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: milestones_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.milestones_id_seq OWNED BY public.milestones.id;
|
||
|
||
|
||
--
|
||
-- Name: news; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.news (
|
||
id bigint NOT NULL,
|
||
title character varying(255) NOT NULL,
|
||
category character varying(64) NOT NULL,
|
||
summary text,
|
||
cover_url character varying(255),
|
||
author character varying(80),
|
||
published_at timestamp with time zone DEFAULT now() NOT NULL,
|
||
views integer DEFAULT 0 NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: news_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.news_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: news_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.news_id_seq OWNED BY public.news.id;
|
||
|
||
|
||
--
|
||
-- Name: partners; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.partners (
|
||
id bigint NOT NULL,
|
||
name character varying(120) NOT NULL,
|
||
short_name character varying(64),
|
||
type character varying(32) NOT NULL,
|
||
logo character varying(255),
|
||
homepage character varying(255),
|
||
description text,
|
||
capabilities text,
|
||
scenarios text,
|
||
featured boolean DEFAULT false NOT NULL,
|
||
contact character varying(255),
|
||
status character varying(32) DEFAULT 'active'::character varying NOT NULL,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: partners_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.partners_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: partners_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.partners_id_seq OWNED BY public.partners.id;
|
||
|
||
|
||
--
|
||
-- Name: policies; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.policies (
|
||
id bigint NOT NULL,
|
||
title character varying(160) NOT NULL,
|
||
region character varying(64) NOT NULL,
|
||
category character varying(64) NOT NULL,
|
||
amount_max numeric(14,2),
|
||
intro text,
|
||
apply_url character varying(255),
|
||
status character varying(32) DEFAULT 'open'::character varying NOT NULL,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: policies_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.policies_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: policies_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.policies_id_seq OWNED BY public.policies.id;
|
||
|
||
|
||
--
|
||
-- Name: policy_applications; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.policy_applications (
|
||
id bigint NOT NULL,
|
||
project_id bigint NOT NULL,
|
||
policy_id bigint NOT NULL,
|
||
status character varying(32) DEFAULT 'submitted'::character varying NOT NULL,
|
||
submitted_at date,
|
||
granted_at date,
|
||
amount numeric(14,2),
|
||
notes text,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: policy_applications_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.policy_applications_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: policy_applications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.policy_applications_id_seq OWNED BY public.policy_applications.id;
|
||
|
||
|
||
--
|
||
-- Name: products; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.products (
|
||
id bigint NOT NULL,
|
||
project_id bigint NOT NULL,
|
||
name character varying(160) NOT NULL,
|
||
tagline character varying(255),
|
||
category character varying(64),
|
||
cover_url character varying(255),
|
||
demo_url character varying(255),
|
||
status character varying(32) DEFAULT 'prototyping'::character varying NOT NULL,
|
||
compliance character varying(32) DEFAULT 'pending'::character varying NOT NULL,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: products_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.products_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: products_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.products_id_seq OWNED BY public.products.id;
|
||
|
||
|
||
--
|
||
-- Name: projects; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.projects (
|
||
id bigint NOT NULL,
|
||
name character varying(120) NOT NULL,
|
||
slug character varying(120),
|
||
stage character varying(32) DEFAULT 'recruit'::character varying NOT NULL,
|
||
direction character varying(64) NOT NULL,
|
||
team_type character varying(32) DEFAULT 'oneperson'::character varying NOT NULL,
|
||
founder character varying(80) NOT NULL,
|
||
phone character varying(32),
|
||
email character varying(120),
|
||
intro text,
|
||
progress integer DEFAULT 0 NOT NULL,
|
||
space_id bigint,
|
||
cohort_id bigint,
|
||
package character varying(32) DEFAULT 'basic'::character varying NOT NULL,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL,
|
||
updated_at timestamp with time zone DEFAULT now() NOT NULL,
|
||
partners text[]
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: projects_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.projects_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: projects_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.projects_id_seq OWNED BY public.projects.id;
|
||
|
||
|
||
--
|
||
-- Name: scenario_mappings; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.scenario_mappings (
|
||
id bigint NOT NULL,
|
||
project_id bigint NOT NULL,
|
||
scenario_id bigint NOT NULL,
|
||
status character varying(32) DEFAULT 'pending'::character varying NOT NULL,
|
||
started_at date,
|
||
closed_at date,
|
||
feedback text,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: scenario_mappings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.scenario_mappings_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: scenario_mappings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.scenario_mappings_id_seq OWNED BY public.scenario_mappings.id;
|
||
|
||
|
||
--
|
||
-- Name: scenarios; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.scenarios (
|
||
id bigint NOT NULL,
|
||
name character varying(160) NOT NULL,
|
||
domain character varying(64) NOT NULL,
|
||
publisher character varying(120),
|
||
intro text,
|
||
partner_org character varying(120),
|
||
opened_at date,
|
||
status character varying(32) DEFAULT 'open'::character varying NOT NULL,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: scenarios_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.scenarios_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: scenarios_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.scenarios_id_seq OWNED BY public.scenarios.id;
|
||
|
||
|
||
--
|
||
-- Name: spaces; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.spaces (
|
||
id bigint NOT NULL,
|
||
name character varying(120) NOT NULL,
|
||
location character varying(120) NOT NULL,
|
||
capacity integer DEFAULT 0 NOT NULL,
|
||
occupied integer DEFAULT 0 NOT NULL,
|
||
type character varying(32) DEFAULT 'offline'::character varying NOT NULL,
|
||
features text,
|
||
status character varying(32) DEFAULT 'open'::character varying NOT NULL,
|
||
created_at timestamp with time zone DEFAULT now()
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: spaces_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.spaces_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: spaces_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.spaces_id_seq OWNED BY public.spaces.id;
|
||
|
||
|
||
--
|
||
-- Name: team_members; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.team_members (
|
||
id bigint NOT NULL,
|
||
project_id bigint NOT NULL,
|
||
name character varying(64) NOT NULL,
|
||
role character varying(64) NOT NULL,
|
||
bio text,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: team_members_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.team_members_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: team_members_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.team_members_id_seq OWNED BY public.team_members.id;
|
||
|
||
|
||
--
|
||
-- Name: tool_runs; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.tool_runs (
|
||
id bigint NOT NULL,
|
||
tool_id bigint NOT NULL,
|
||
user_name character varying(80) DEFAULT 'demo@opc'::character varying NOT NULL,
|
||
input jsonb,
|
||
output jsonb,
|
||
score numeric(5,2),
|
||
duration_ms integer,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: tool_runs_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.tool_runs_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: tool_runs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.tool_runs_id_seq OWNED BY public.tool_runs.id;
|
||
|
||
|
||
--
|
||
-- Name: tools; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.tools (
|
||
id bigint NOT NULL,
|
||
name character varying(120) NOT NULL,
|
||
category character varying(64) NOT NULL,
|
||
description text,
|
||
version character varying(32),
|
||
homepage character varying(255),
|
||
free_quota character varying(120),
|
||
status character varying(32) DEFAULT 'available'::character varying NOT NULL,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL,
|
||
domain character varying(32) DEFAULT 'platform'::character varying NOT NULL,
|
||
template jsonb
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: tools_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.tools_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: tools_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.tools_id_seq OWNED BY public.tools.id;
|
||
|
||
|
||
--
|
||
-- Name: trainings; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.trainings (
|
||
id bigint NOT NULL,
|
||
cohort_id bigint,
|
||
title character varying(160) NOT NULL,
|
||
topic character varying(64) NOT NULL,
|
||
speaker character varying(120),
|
||
speaker_org character varying(120),
|
||
train_date date,
|
||
location character varying(120),
|
||
attendees integer DEFAULT 0 NOT NULL,
|
||
format character varying(32) DEFAULT 'offline'::character varying NOT NULL,
|
||
summary text,
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: trainings_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.trainings_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: trainings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.trainings_id_seq OWNED BY public.trainings.id;
|
||
|
||
|
||
--
|
||
-- Name: users; Type: TABLE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE TABLE public.users (
|
||
id bigint NOT NULL,
|
||
username character varying(64) NOT NULL,
|
||
password character varying(255) NOT NULL,
|
||
name character varying(80) NOT NULL,
|
||
role character varying(32) DEFAULT 'guest'::character varying NOT NULL,
|
||
phone character varying(32),
|
||
email character varying(120),
|
||
created_at timestamp with time zone DEFAULT now() NOT NULL
|
||
);
|
||
|
||
|
||
--
|
||
-- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE SEQUENCE public.users_id_seq
|
||
START WITH 1
|
||
INCREMENT BY 1
|
||
NO MINVALUE
|
||
NO MAXVALUE
|
||
CACHE 1;
|
||
|
||
|
||
--
|
||
-- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id;
|
||
|
||
|
||
--
|
||
-- Name: announcements id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.announcements ALTER COLUMN id SET DEFAULT nextval('public.announcements_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: coachings id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.coachings ALTER COLUMN id SET DEFAULT nextval('public.coachings_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: cohorts id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.cohorts ALTER COLUMN id SET DEFAULT nextval('public.cohorts_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: compliance_logs id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.compliance_logs ALTER COLUMN id SET DEFAULT nextval('public.compliance_logs_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: data_resources id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.data_resources ALTER COLUMN id SET DEFAULT nextval('public.data_resources_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: events id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.events ALTER COLUMN id SET DEFAULT nextval('public.events_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: kpi_snapshots id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.kpi_snapshots ALTER COLUMN id SET DEFAULT nextval('public.kpi_snapshots_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: mentors id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.mentors ALTER COLUMN id SET DEFAULT nextval('public.mentors_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: milestones id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.milestones ALTER COLUMN id SET DEFAULT nextval('public.milestones_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: news id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.news ALTER COLUMN id SET DEFAULT nextval('public.news_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: partners id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.partners ALTER COLUMN id SET DEFAULT nextval('public.partners_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: policies id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.policies ALTER COLUMN id SET DEFAULT nextval('public.policies_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: policy_applications id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.policy_applications ALTER COLUMN id SET DEFAULT nextval('public.policy_applications_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: products id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.products ALTER COLUMN id SET DEFAULT nextval('public.products_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: projects id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.projects ALTER COLUMN id SET DEFAULT nextval('public.projects_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: scenario_mappings id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.scenario_mappings ALTER COLUMN id SET DEFAULT nextval('public.scenario_mappings_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: scenarios id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.scenarios ALTER COLUMN id SET DEFAULT nextval('public.scenarios_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: spaces id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.spaces ALTER COLUMN id SET DEFAULT nextval('public.spaces_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: team_members id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.team_members ALTER COLUMN id SET DEFAULT nextval('public.team_members_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: tool_runs id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.tool_runs ALTER COLUMN id SET DEFAULT nextval('public.tool_runs_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: tools id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.tools ALTER COLUMN id SET DEFAULT nextval('public.tools_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: trainings id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.trainings ALTER COLUMN id SET DEFAULT nextval('public.trainings_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Name: users id; Type: DEFAULT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass);
|
||
|
||
|
||
--
|
||
-- Data for Name: announcements; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.announcements (id, title, content, pinned, published_at, created_at) FROM stdin;
|
||
1 尚数网 AI-DATA-OPC 创业孵化合作平台正式上线 欢迎使用尚数网 AI-DATA-OPC 创业孵化合作平台。平台已上线项目管理、训练营、数据资源、场景对接等核心功能。 t 2026-08-11 15:18:16.588283+00 2026-08-11 15:18:16.588283+00
|
||
2 2026 秋季数据要素特训营开启招募 秋季数据要素特训营开启招募,聚焦数据资源 × 行业模型,欢迎 OPC 团队报名。 f 2026-08-11 15:18:16.588283+00 2026-08-11 15:18:16.588283+00
|
||
3 平台接口文档 v2.4 发布 《OPC 平台接口文档 v2.4》已发布,包含 38 个核心接口与认证说明。 f 2026-08-11 15:18:16.588283+00 2026-08-11 15:18:16.588283+00
|
||
4 OPC 工具箱上线 - 15 件即用工具 15 件即用即得工具覆盖跨境数据 / 法律 / 设计 / 通用 4 类,正式上线。 t 2026-08-10 09:00:00+00 2026-08-12 00:50:46.122722+00
|
||
5 2026 秋季数据要素特训营开启招募 秋季数据要素特训营 9 月 1 日开营,聚焦数据资源 × 行业模型,欢迎 OPC 团队报名。 f 2026-08-08 09:00:00+00 2026-08-12 00:50:46.122722+00
|
||
6 平台接口文档 v2.5 发布 《OPC 平台接口文档 v2.5》已发布,新增 4 个工具运行接口与 13 个引擎说明。 f 2026-08-05 09:00:00+00 2026-08-12 00:50:46.122722+00
|
||
7 系统升级:单端口一体化服务 平台前端已集成到 Go 后端,18080 端口一体化访问。 f 2026-08-12 08:00:00+00 2026-08-12 00:50:46.122722+00
|
||
8 上海·市北高新 AI-DATA-OPC 孵化空间正式启动 上海市静安区市北高新园区 AI-DATA-OPC 孵化空间正式启动,首批 92 个团队入驻,开放共享办公 / 路演厅 / 数据沙盒 / 边缘 GPU 算力。 t 2026-08-12 09:00:00+00 2026-08-12 01:12:59.864326+00
|
||
9 青岛·城阳数据要素产业园 跨境数据沙盒开放 青岛市城阳区峪云谷数字经济产业园开放跨境数据沙盒 / 隐私计算 / 算力网络能力,首批 56 个团队入驻。 t 2026-08-11 09:00:00+00 2026-08-12 01:12:59.864326+00
|
||
10 武汉·光谷 AI-DATA 创业孵化空间 开放 武汉市东湖高新区光谷生物城 AI-DATA 创业孵化空间开放,聚焦生物医药 / 工业数据方向,首批 78 个团队入驻。 f 2026-08-10 09:00:00+00 2026-08-12 01:12:59.864326+00
|
||
11 深圳·深投控南山智谷 一周年 深圳深投控南山智谷开园一周年,117 个 OPC 团队入驻,累计促成签约 2080 万元。 f 2026-08-09 09:00:00+00 2026-08-12 01:12:59.864326+00
|
||
12 八爪鱼 / 九鑫智能 入驻尚数网 OPC 平台 数据采集与超级自动化双合作伙伴入驻平台。壹心、易法通等真实项目已融合双方能力。 t 2026-08-12 09:00:00+00 2026-08-12 01:17:14.484928+00
|
||
13 八爪鱼 / 九鑫智能 入驻尚数网 OPC 平台 数据采集与超级自动化双合作伙伴入驻平台。壹心、易法通等真实项目已融合双方能力。 t 2026-08-12 09:00:00+00 2026-08-12 01:18:22.851924+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: coachings; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.coachings (id, project_id, mentor_name, mentor_org, topic, scheduled_at, duration_min, status, notes, created_at) FROM stdin;
|
||
1 1 林岚 尚数网法务研究院 合规 2026-04-08 02:00:00+00 60 done 城市部件数据合规审查通过 2026-08-11 15:32:16.860307+00
|
||
2 1 陈哲 清华 AI 研究院 技术 2026-04-15 06:00:00+00 90 done 巡查模型精度优化 2026-08-11 15:32:16.860307+00
|
||
3 1 王砚 极客公园 商业 2026-05-12 07:00:00+00 60 scheduled 商业模式画布梳理 2026-08-11 15:32:16.860307+00
|
||
4 3 林岚 尚数网法务研究院 合规 2026-04-02 02:00:00+00 60 done 财税数据合规路径 2026-08-11 15:32:16.860307+00
|
||
5 3 Vivian 一线 AI 公司 产品 2026-04-20 06:00:00+00 60 done 产品定价策略 2026-08-11 15:32:16.860307+00
|
||
6 3 陈哲 清华 AI 研究院 技术 2026-05-18 02:00:00+00 90 done OCR 模型迭代建议 2026-08-11 15:32:16.860307+00
|
||
7 6 林岚 尚数网法务研究院 合规 2026-03-25 06:00:00+00 60 done 政务语料合规审查 2026-08-11 15:32:16.860307+00
|
||
8 6 Bryan OSS 社区 技术 2026-04-15 02:00:00+00 90 done 智能体架构优化 2026-08-11 15:32:16.860307+00
|
||
9 6 王砚 极客公园 商业 2026-05-20 07:00:00+00 60 done 政府采购路径 2026-08-11 15:32:16.860307+00
|
||
10 12 陈哲 清华 AI 研究院 技术 2026-04-08 06:00:00+00 90 done 工业质检模型精调 2026-08-11 15:32:16.860307+00
|
||
11 12 Vivian 一线 AI 公司 产品 2026-05-10 02:00:00+00 60 done SaaS 化设计 2026-08-11 15:32:16.860307+00
|
||
12 8 林岚 尚数网法务研究院 合规 2026-05-25 06:00:00+00 60 done 合同审查数据合规 2026-08-11 15:32:16.860307+00
|
||
13 8 Bryan OSS 社区 技术 2026-06-08 02:00:00+00 90 done Agent 测试建议 2026-08-11 15:32:16.860307+00
|
||
14 4 陈哲 清华 AI 研究院 技术 2026-05-15 06:00:00+00 90 done 低空识别模型迁移 2026-08-11 15:32:16.860307+00
|
||
15 4 林岚 尚数网法务研究院 合规 2026-06-12 02:00:00+00 60 scheduled 低空空域事件合规 2026-08-11 15:32:16.860307+00
|
||
16 2 林岚 尚数网法务研究院 合规 2026-04-20 02:00:00+00 60 done 医疗数据脱敏规范 2026-08-11 15:32:16.860307+00
|
||
17 2 Vivian 一线 AI 公司 产品 2026-05-15 06:00:00+00 60 scheduled 基层医生画像 2026-08-11 15:32:16.860307+00
|
||
18 13 林岚 尚数网法务研究院 合规 2026-06-05 02:00:00+00 60 done 海关清关数据合规 2026-08-12 00:50:21.810545+00
|
||
19 14 李娟 翻译社区 技术 2026-06-15 06:00:00+00 90 done 多语种翻译技术 2026-08-12 00:50:21.810545+00
|
||
20 15 陈哲 清华 AI 研究院 技术 2026-07-15 02:00:00+00 90 done 数据中台架构 2026-08-12 00:50:21.810545+00
|
||
21 16 Vivian 一线 AI 公司 产品 2026-07-20 06:00:00+00 60 done 法务 SaaS 商业模式 2026-08-12 00:50:21.810545+00
|
||
22 17 Vivian 一线 AI 公司 产品 2026-07-25 02:00:00+00 60 scheduled 财税 Agent 定价 2026-08-12 00:50:21.810545+00
|
||
23 18 陈哲 清华 AI 研究院 技术 2026-08-05 06:00:00+00 90 done 工业小模型微调 2026-08-12 00:50:21.810545+00
|
||
24 19 Vivian Z. 数据交易所 政策 2026-08-08 02:00:00+00 60 done 跨境支付合规 2026-08-12 00:50:21.810545+00
|
||
25 20 Bryan OSS 社区 技术 2026-08-10 06:00:00+00 90 scheduled 农业 Agent 框架 2026-08-12 00:50:21.810545+00
|
||
26 21 陈哲 清华 AI 研究院 技术 2026-08-12 02:00:00+00 90 scheduled 医疗影像 AI 架构 2026-08-12 00:50:21.810545+00
|
||
27 24 王砚 极客公园 商业 2026-08-15 06:00:00+00 60 scheduled 政策速递商业化 2026-08-12 00:50:21.810545+00
|
||
28 25 林岚 尚数网法务研究院 合规 2026-08-18 02:00:00+00 60 scheduled 数据出境合规策略 2026-08-12 00:50:21.810545+00
|
||
29 26 陈哲 清华 AI 研究院 技术 2026-08-20 06:00:00+00 90 scheduled 园区安全 AI 架构 2026-08-12 00:50:21.810545+00
|
||
30 27 Vivian 一线 AI 公司 产品 2026-08-22 02:00:00+00 60 scheduled 低代码合规产品策略 2026-08-12 00:50:21.810545+00
|
||
33 28 Vivian 一线 AI 公司 商业 2026-07-20 06:00:00+00 60 done 亚马逊运营策略 2026-08-12 01:18:22.836977+00
|
||
34 28 王砚 极客公园 商业 2026-08-10 02:00:00+00 60 scheduled 品牌孵化商业模式 2026-08-12 01:18:22.836977+00
|
||
35 28 Bryan OSS 社区 技术 2026-08-15 06:00:00+00 90 scheduled AI 选品系统架构 2026-08-12 01:18:22.836977+00
|
||
36 29 林岚 尚数网法务研究院 合规 2026-05-10 02:00:00+00 60 done 不良资产处置合规路径 2026-08-12 01:18:22.845969+00
|
||
37 29 Vivian Z. 数据交易所 政策 2026-06-20 06:00:00+00 60 done 资产管理公司合规 2026-08-12 01:18:22.845969+00
|
||
38 29 王砚 极客公园 商业 2026-07-25 02:00:00+00 60 done 客户复购策略 2026-08-12 01:18:22.845969+00
|
||
39 29 陈哲 清华 AI 研究院 技术 2026-08-10 06:00:00+00 90 scheduled AI 尽调系统架构 2026-08-12 01:18:22.845969+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: cohorts; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.cohorts (id, name, theme, start_date, end_date, capacity, enrolled, status, description, created_at) FROM stdin;
|
||
1 2026 春季·OPC 黄埔 1 期 一人公司从 0 到 1 2026-02-28 16:00:00+00 2026-05-30 16:00:00+00 30 28 ongoing 聚焦 AI 创业团队的合规、模型与产品启动 2026-08-11 15:18:16.528015+00
|
||
2 2026 夏季·智能体专训 Agent 商业化实战 2026-05-31 16:00:00+00 2026-08-30 16:00:00+00 30 25 ongoing 智能体从原型到商业化全流程 2026-08-11 15:18:16.528015+00
|
||
3 2026 秋季·数据要素特训 数据资源 × 行业模型 2026-08-31 16:00:00+00 2026-11-29 16:00:00+00 40 12 recruiting 行业数据 + 行业模型 + 场景验证 2026-08-11 15:18:16.528015+00
|
||
4 2026 冬季·场景验证特训 场景为王·试点验证 2026-11-30 16:00:00+00 2027-02-27 16:00:00+00 30 0 planning 从原型到场景测试的特训 2026-08-11 15:18:16.528015+00
|
||
5 2026 春季·黄埔 2 期 跨境数据合规专项 2026-04-15 00:00:00+00 2026-06-15 00:00:00+00 30 30 finished 面向跨境数据业务的合规专项训练 2026-08-12 00:50:21.778884+00
|
||
6 2026 夏季·智能体 2 期 产研结合智能体 2026-07-01 00:00:00+00 2026-09-30 00:00:00+00 35 28 ongoing 智能体产研结合专项 2026-08-12 00:50:21.778884+00
|
||
7 2026 秋季·市北高新 黄埔 3 期 AI-DATA 产研结合 2026-09-15 00:00:00+00 2026-11-15 00:00:00+00 30 18 recruiting 上海市北高新 + 尚数网联合举办 2026-08-12 01:12:59.866595+00
|
||
8 2026 秋季·城阳产业园 跨境数据 跨境数据合规实战 2026-09-01 00:00:00+00 2026-11-30 00:00:00+00 30 12 recruiting 青岛城阳 + 跨境数据沙盒联合举办 2026-08-12 01:12:59.866595+00
|
||
9 2026 秋季·光谷生物城 专项 生物医药 AI 2026-09-20 00:00:00+00 2026-11-20 00:00:00+00 25 9 recruiting 武汉光谷 + 医药数据联合举办 2026-08-12 01:12:59.866595+00
|
||
10 2026 秋季·南山智谷 加速 智能体专项 2026-09-10 00:00:00+00 2026-11-10 00:00:00+00 30 22 recruiting 深投控南山智谷 + 智能体联合举办 2026-08-12 01:12:59.866595+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: compliance_logs; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.compliance_logs (id, project_id, resource_id, action, operator, result, notes, created_at) FROM stdin;
|
||
1 1 1 apply 陈墨 pass 申请城市治理标注集 2026-08-11 15:18:16.571082+00
|
||
2 1 1 grant 尚数网 pass 授权使用 6 个月 2026-08-11 15:18:16.571082+00
|
||
3 2 3 apply 苏婉 pass 申请医疗问诊语料 2026-08-11 15:18:16.571082+00
|
||
4 2 3 grant 尚数网 pass 脱敏授权 3 个月 2026-08-11 15:18:16.571082+00
|
||
5 3 4 apply 王砚 pass 申请金融票据 OCR 训练集 2026-08-11 15:18:16.571082+00
|
||
6 3 4 grant 尚数网 pass 授权使用 12 个月 2026-08-11 15:18:16.571082+00
|
||
7 4 9 apply 周扬 pass 申请低空目标检测集 2026-08-11 15:18:16.571082+00
|
||
8 8 4 audit 尚数网 pass 四季度合规审查合格 2026-08-11 15:18:16.571082+00
|
||
9 6 8 audit 尚数网 pass 公文语料使用审查 2026-08-11 15:18:16.571082+00
|
||
10 5 7 apply 李远 pass 申请供应链关系图谱 2026-08-11 15:18:16.571082+00
|
||
11 12 2 grant 尚数网 pass 工业质检数据授权 12 个月 2026-08-11 15:18:16.571082+00
|
||
12 7 6 apply Vivian risk 视频数据需补充授权链 2026-08-11 15:18:16.571082+00
|
||
13 13 3 apply 赵磊 pass 申请海关数据 2026-08-12 00:50:21.812997+00
|
||
14 14 16 apply 李娟 pass 申请多语种翻译语料 2026-08-12 00:50:21.812997+00
|
||
15 15 7 apply 小于 pass 申请供应链数据 2026-08-12 00:50:21.812997+00
|
||
16 16 4 apply Aimee pass 申请金融票据 2026-08-12 00:50:21.812997+00
|
||
17 17 4 apply 老郑 pass 申请金融票据 2026-08-12 00:50:21.812997+00
|
||
18 18 2 apply Echo pass 申请工业质检数据 2026-08-12 00:50:21.812997+00
|
||
19 19 4 apply 秦岚 pass 申请金融数据 2026-08-12 00:50:21.812997+00
|
||
20 20 11 apply 老农 pass 申请农业数据 2026-08-12 00:50:21.812997+00
|
||
21 21 3 apply 苏婉 pass 申请医疗数据 2026-08-12 00:50:21.812997+00
|
||
22 24 8 audit 尚数网 pass 公文数据年度审查 2026-08-12 00:50:21.812997+00
|
||
23 25 8 audit 尚数网 pass 政策数据合规审查 2026-08-12 00:50:21.812997+00
|
||
24 26 1 audit 尚数网 pass 城市部件数据合规 2026-08-12 00:50:21.812997+00
|
||
25 27 4 apply 林岚 pass 申请金融数据 2026-08-12 00:50:21.812997+00
|
||
26 25 4 audit 尚数网 pass 跨境数据合规审查 2026-08-12 00:50:21.812997+00
|
||
27 13 3 audit 尚数网 pass 海关数据半年审查 2026-08-12 00:50:21.812997+00
|
||
28 16 4 audit 尚数网 risk 法务 SaaS 需补充授权 2026-08-12 00:50:21.812997+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: data_resources; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.data_resources (id, title, category, domain, size_gb, rows_count, license, description, apply_count, available, created_at) FROM stdin;
|
||
1 城市治理事件多模态标注集 图像 政务 1280.50 1800000 授权使用 覆盖城市部件、违规事件、应急场景的多模态标注数据 42 t 2026-08-11 15:18:16.521794+00
|
||
2 工业质检缺陷图像库 图像 制造 580.20 750000 授权使用 钢铁、3C、新能源电池等表面缺陷+标注 35 t 2026-08-11 15:18:16.521794+00
|
||
3 医疗问诊对话语料 文本 医疗 64.80 1200000 脱敏授权 脱敏后的医患对话语料,附合规审查号 18 t 2026-08-11 15:18:16.521794+00
|
||
4 金融票据 OCR 训练集 图像 金融 96.30 320000 授权使用 增值税发票、银行票据 OCR 标注 26 t 2026-08-11 15:18:16.521794+00
|
||
5 政务热线语音转写集 语音 政务 720.00 600000 脱敏授权 12345 热线语音转写+情绪标注 12 t 2026-08-11 15:18:16.521794+00
|
||
6 短视频内容理解数据集 视频 文娱 3200.00 480000 授权使用 覆盖 18 类垂类的视频理解标签 21 t 2026-08-11 15:18:16.521794+00
|
||
7 供应链企业关系图谱 行业专题 产业协同 12.40 85000 授权使用 覆盖 30 万企业的工商、交易、招投标关系 15 t 2026-08-11 15:18:16.521794+00
|
||
8 公文写作模板语料 文本 政务 4.20 120000 授权使用 公文、报告、讲话稿模板+合规校对 38 t 2026-08-11 15:18:16.521794+00
|
||
9 低空经济目标检测集 图像 城市治理 410.00 260000 授权使用 无人机视角目标检测与跟踪 9 t 2026-08-11 15:18:16.521794+00
|
||
10 供应链风险指标库 行业专题 金融 6.80 42000 授权使用 近 5 年供应链风险指标 7 t 2026-08-11 15:18:16.521794+00
|
||
11 农业农村产销数据 行业专题 产业协同 86.20 280000 授权使用 覆盖 30 省主要农产品产销数据 11 t 2026-08-12 00:50:21.776027+00
|
||
12 气象观测数据集 行业专题 公共服务 220.00 950000 公开 近 10 年气象观测数据,已脱敏 18 t 2026-08-12 00:50:21.776027+00
|
||
13 企业征信数据集 文本 金融 12.80 350000 脱敏授权 企业工商、税务、信贷多维度数据 9 t 2026-08-12 00:50:21.776027+00
|
||
14 医疗影像 CT 三维重建 图像 医疗 1840.00 480000 脱敏授权 覆盖 12 类疾病 CT 三维影像 6 t 2026-08-12 00:50:21.776027+00
|
||
15 城市交通卡口数据 图像 城市治理 320.00 1200000 授权使用 城市主要道路卡口数据 14 t 2026-08-12 00:50:21.776027+00
|
||
16 医疗知识图谱 行业专题 医疗 4.80 85000 授权使用 基于权威医学文献构建的知识图谱 8 t 2026-08-12 00:50:21.776027+00
|
||
17 工业互联网设备日志 文本 制造 460.00 2400000 授权使用 高端装备设备运行日志 7 t 2026-08-12 00:50:21.776027+00
|
||
18 电商评论情感数据 文本 文娱 36.00 1800000 公开 电商多品类评论数据 + 情感标注 22 t 2026-08-12 00:50:21.776027+00
|
||
19 应急事件多源融合集 行业专题 公共服务 28.00 145000 授权使用 包含气象/交通/舆情多源数据 5 t 2026-08-12 00:50:21.776027+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: events; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.events (id, title, type, host, event_date, location, projects, leads, deals, summary, created_at) FROM stdin;
|
||
1 2026 春季 OPC 黄埔 1期 Demo Day pitching 尚数网 2026-05-25 北京·中关村 22 35 7 22 个项目集中路演,35 条客户线索,7 个签约意向 2026-08-11 15:18:16.558567+00
|
||
2 数据要素 × 智能体 供需对接会 match 高新区+尚数网 2026-04-20 深圳·南山 18 28 5 智能体供需对接会 2026-08-11 15:18:16.558567+00
|
||
3 OPC 创业者开放日 launch 上海杨浦 2026-06-08 上海·杨浦 12 18 3 OPC 创业者开放日 2026-08-11 15:18:16.558567+00
|
||
4 数据合规专题培训 compliance 尚数网 2026-03-08 北京·中关村 28 0 0 面向 28 个项目的数据合规培训 2026-08-11 15:18:16.558567+00
|
||
5 2026 春季黄埔 2 期 Demo Day pitching 尚数网 2026-06-15 北京·中关村 25 42 9 25 个跨境数据项目集中路演 2026-08-12 00:50:21.801166+00
|
||
6 数据要素 × 智能体 供需对接会 match 尚数网 + 上海经委 2026-07-20 上海·徐汇 22 35 6 智能体专项供需对接 2026-08-12 00:50:21.801166+00
|
||
7 AIGC 合规专题 compliance 尚数网 2026-08-05 线上 50 0 0 AIGC 合规专题培训 2026-08-12 00:50:21.801166+00
|
||
8 2026 智能体 2 期启动 launch 尚数网 2026-07-01 上海·杨浦 28 0 0 智能体 2 期启动 2026-08-12 00:50:21.801166+00
|
||
9 数据出境合规一条龙 compliance 南沙粤港澳 2026-06-08 广州·南沙 35 18 4 数据出境合规培训 + 签约 2026-08-12 00:50:21.801166+00
|
||
10 财税 Agent 闭门会 match 尚数网 2026-08-10 上海·徐汇 12 24 5 财税 Agent 与企业闭门对接 2026-08-12 00:50:21.801166+00
|
||
11 政策速递 公众开放日 launch 市政务办 2026-07-25 市政务办 8 15 3 政策速递公众开放日 2026-08-12 00:50:21.801166+00
|
||
12 园区安全大脑 第一期交付 launch 高新区 2026-08-15 高新区 5 12 2 园区安全大脑第一期交付 2026-08-12 00:50:21.801166+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: kpi_snapshots; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.kpi_snapshots (id, metric_key, metric_name, value, target, unit, snap_date, category, created_at) FROM stdin;
|
||
14 month_recruit 本月新增招募 8.00 10.00 个 2026-08-12 incubate 2026-08-12 01:01:25.8953+00
|
||
15 month_prototype 本月新增原型 5.00 5.00 个 2026-08-12 incubate 2026-08-12 01:01:25.8953+00
|
||
16 month_pilot 本月新增试点 3.00 5.00 个 2026-08-12 incubate 2026-08-12 01:01:25.8953+00
|
||
17 month_revenue 项目签约总金额 720.00 0.00 万元 2026-08-12 conversion 2026-08-12 01:01:25.8953+00
|
||
18 month_tool_runs 本月工具运行次数 47.00 0.00 次 2026-08-12 service 2026-08-12 01:01:25.8953+00
|
||
19 month_data_apply 本月数据申请数 28.00 0.00 次 2026-08-12 service 2026-08-12 01:01:25.8953+00
|
||
20 month_user_active 本月活跃用户 86.00 0.00 人 2026-08-12 service 2026-08-12 01:01:25.8953+00
|
||
21 total_cumulative_revenue 累计促成签约 2080.00 0.00 万元 2026-08-12 conversion 2026-08-12 01:01:25.8953+00
|
||
1 recruit_count 首批招募项目数量 52.00 50.00 个 2026-08-12 incubate 2026-08-11 15:18:16.581807+00
|
||
2 onboard_count 完成入驻项目数量 38.00 30.00 个 2026-08-12 incubate 2026-08-11 15:18:16.581807+00
|
||
3 prototype_count 完成原型开发项目数量 22.00 15.00 个 2026-08-12 incubate 2026-08-11 15:18:16.581807+00
|
||
4 pilot_count 进入场景测试项目数量 8.00 5.00 个 2026-08-12 incubate 2026-08-11 15:18:16.581807+00
|
||
5 benchmark_count 形成标杆案例数量 6.00 5.00 个 2026-08-12 incubate 2026-08-11 15:18:16.581807+00
|
||
6 train_count 创业训练营/专题培训场次 12.00 6.00 场 2026-08-12 service 2026-08-11 15:18:16.581807+00
|
||
7 coaching_count 一对一辅导项目数量 30.00 20.00 个 2026-08-12 service 2026-08-11 15:18:16.581807+00
|
||
8 compliance_count 合规咨询/数据匹配服务次数 76.00 50.00 次 2026-08-12 service 2026-08-11 15:18:16.581807+00
|
||
9 event_count 供需对接/路演活动次数 8.00 4.00 场 2026-08-12 service 2026-08-11 15:18:16.581807+00
|
||
10 listed_count 产品上架/展示项目数量 18.00 10.00 个 2026-08-12 conversion 2026-08-11 15:18:16.581807+00
|
||
11 scenario_count 场景合作意向数量 9.00 5.00 项 2026-08-12 conversion 2026-08-11 15:18:16.581807+00
|
||
12 lead_count 市场合作线索/客户对接数量 35.00 20.00 条 2026-08-12 conversion 2026-08-11 15:18:16.581807+00
|
||
13 policy_count 政策申报/资源对接成功案例 18.00 5.00 个 2026-08-12 conversion 2026-08-11 15:18:16.581807+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: mentors; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.mentors (id, name, title, org, domain, years_exp, bio, avatar, rating, cases, created_at) FROM stdin;
|
||
1 林岚 尚数网法务研究院 院长 尚数网 合规 15 数据合规与隐私计算专家,参与多项国家标准制定 \N 4.9 38 2026-08-11 15:18:16.578956+00
|
||
2 陈哲 清华 AI 研究院 研究员 清华 AI 研究院 技术 12 多模态大模型与行业模型微调 \N 4.9 26 2026-08-11 15:18:16.578956+00
|
||
3 王砚 极客公园 创始合伙人 极客公园 商业 18 AI 创业商业模式与融资 \N 4.8 52 2026-08-11 15:18:16.578956+00
|
||
4 Bryan OSS 社区 Maintainer OSS 社区 技术 10 智能体工程化与开源治理 \N 4.8 22 2026-08-11 15:18:16.578956+00
|
||
5 Vivian 前 AI 一线公司产品 VP 一线 AI 公司 产品 14 AI 产品商业化与定价 \N 4.9 31 2026-08-11 15:18:16.578956+00
|
||
6 Vivian Z. 数据要素流通专家 数据交易所 政策 16 数据要素流通政策与交易 \N 4.7 19 2026-08-11 15:18:16.578956+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: milestones; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.milestones (id, project_id, title, stage, happened_at, evidence, created_at) FROM stdin;
|
||
1 1 原型评审通过 prototyping 2026-04-10 专家组评审通过 2026-08-11 15:18:16.567818+00
|
||
2 1 场景测试启动 pilot 2026-04-15 市城管局测试启动 2026-08-11 15:18:16.567818+00
|
||
3 1 首批客户签约 market 2026-06-20 首批 3 个园区签约 2026-08-11 15:18:16.567818+00
|
||
4 3 财税模型上线 prototyping 2026-03-15 财税模型 V1.0 上线 2026-08-11 15:18:16.567818+00
|
||
5 3 试点合格 pilot 2026-04-30 税务局试点合格 2026-08-11 15:18:16.567818+00
|
||
6 6 V2.0 升级 market 2026-05-30 支持 12 类公文 2026-08-11 15:18:16.567818+00
|
||
7 6 3 部门推广 market 2026-06-20 3 个部门启动使用 2026-08-11 15:18:16.567818+00
|
||
8 12 客户验收 market 2026-06-30 试点客户验收 2026-08-11 15:18:16.567818+00
|
||
9 8 签约 5 家律所 market 2026-06-15 签约 5 家律所 2026-08-11 15:18:16.567818+00
|
||
10 13 原型 V1.0 prototyping 2026-06-15 海关清关 AI V1.0 完成 2026-08-12 00:50:21.807852+00
|
||
11 13 海关场景测试 pilot 2026-07-01 海关场景测试 2026-08-12 00:50:21.807852+00
|
||
12 14 MVP 上线 prototyping 2026-06-15 MVP 上线 2026-08-12 00:50:21.807852+00
|
||
13 14 首批客户 pilot 2026-07-15 首批 5 家律所签约 2026-08-12 00:50:21.807852+00
|
||
14 15 团队组建 incubating 2026-06-01 核心团队组建 2026-08-12 00:50:21.807852+00
|
||
15 16 需求评审 prototyping 2026-07-15 需求评审通过 2026-08-12 00:50:21.807852+00
|
||
16 17 产品 MVP incubating 2026-07-15 产品 MVP 完成 2026-08-12 00:50:21.807852+00
|
||
17 18 模型微调 prototyping 2026-07-20 模型微调完成 2026-08-12 00:50:21.807852+00
|
||
18 19 央行对接 prototyping 2026-07-25 央行跨境支付对接 2026-08-12 00:50:21.807852+00
|
||
19 20 种子轮 incubating 2026-07-10 种子轮融资完成 2026-08-12 00:50:21.807852+00
|
||
20 21 卫健委对接 prototyping 2026-07-20 卫健委对接启动 2026-08-12 00:50:21.807852+00
|
||
21 22 MVP 启动 incubating 2026-07-15 MVP 启动 2026-08-12 00:50:21.807852+00
|
||
22 23 项目启动 recruit 2026-07-30 项目立项 2026-08-12 00:50:21.807852+00
|
||
23 24 签约 pilot 2026-07-30 首批 3 个机构签约 2026-08-12 00:50:21.807852+00
|
||
24 25 首批上线 market 2026-06-30 首批 5 个城市上线 2026-08-12 00:50:21.807852+00
|
||
25 25 第二批城市 market 2026-07-30 第二批 5 个城市上线 2026-08-12 00:50:21.807852+00
|
||
26 26 一期交付 pilot 2026-08-15 一期交付 2026-08-12 00:50:21.807852+00
|
||
27 27 原型评审 prototyping 2026-08-10 原型评审通过 2026-08-12 00:50:21.807852+00
|
||
28 1 海外市场拓展 market 2026-07-15 新加坡市场拓展 2026-08-12 01:01:25.910046+00
|
||
29 3 海外签约 market 2026-07-25 海外签约 3 单 2026-08-12 01:01:25.910046+00
|
||
30 6 广东推广 market 2026-07-28 广东 5 个市级部门推广 2026-08-12 01:01:25.910046+00
|
||
31 12 二期签约 market 2026-08-05 二期签约 5 单 2026-08-12 01:01:25.910046+00
|
||
32 13 深圳试点 pilot 2026-08-10 深圳海关试点 2026-08-12 01:01:25.910046+00
|
||
33 14 律所扩张 pilot 2026-08-12 律所签约 12 家 2026-08-12 01:01:25.910046+00
|
||
34 25 10 城市上线 market 2026-08-15 10 城市上线 2026-08-12 01:01:25.910046+00
|
||
35 26 二期交付 pilot 2026-08-20 二期交付 2026-08-12 01:01:25.910046+00
|
||
38 28 工商注册完成 recruit 2026-06-15 OPC 工商注册 2026-08-12 01:18:22.835387+00
|
||
39 28 亚马逊 / Etsy 入驻 incubating 2026-07-10 欧美主流平台入驻 2026-08-12 01:18:22.835387+00
|
||
40 28 首批 10 款打样 incubating 2026-07-30 首批 10 款核心产品打样 2026-08-12 01:18:22.835387+00
|
||
41 28 AI 选品系统上线 incubating 2026-08-08 基于八爪鱼 + 九鑫智能 AI 的选品看板 2026-08-12 01:18:22.835387+00
|
||
42 29 OPC 注册完成 recruit 2026-04-25 OPC 工商注册 + 律师执业证备案 2026-08-12 01:18:22.845151+00
|
||
43 29 首批 100+ 客户 incubating 2026-06-15 首批 100+ 中小微企业 / 个人客户 2026-08-12 01:18:22.845151+00
|
||
44 29 AI 尽调助手上线 incubating 2026-07-20 AI 尽调助手 V1.0 上线 2026-08-12 01:18:22.845151+00
|
||
45 29 首单千万级处置 pilot 2026-08-05 首单 3000 万不良债权处置启动 2026-08-12 01:18:22.845151+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: news; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.news (id, title, category, summary, cover_url, author, published_at, views) FROM stdin;
|
||
1 尚数网 AI-DATA-OPC 创业孵化合作方案(试点版)正式发布 平台 面向人工智能领域的 OPC 创业团队的孵化服务体系正式启动 \N 尚数网 2026-08-11 15:18:16.576038+00 1280
|
||
2 2026 春季黄埔 1 期 28 个项目全员入驻 活动 首批 28 个 OPC 项目正式入驻 AI-DATA-OPC 创业空间 \N 尚数网 2026-08-11 15:18:16.576038+00 920
|
||
3 智城慧眼获批 60 万中关村 AI 创业扶持 行业 智城慧眼获得中关村 AI 创业扶持资金 \N 吴桐 2026-08-11 15:18:16.576038+00 480
|
||
4 云公文 V2.0 在 3 个市级部门正式上线 平台 云公文 V2.0 已在 3 个市级部门正式上线 \N 吴桐 2026-08-11 15:18:16.576038+00 360
|
||
5 数据要素流通新政解读 政策 数据要素流通新政解读会成功举办 \N 李梦 2026-08-11 15:18:16.576038+00 285
|
||
6 OPC 从 0 到 1:合规、模型与场景三步走 行业 OPC 创业的合规、模型与场景三步走深度文章 \N 陈墨 2026-08-11 15:18:16.576038+00 198
|
||
7 2026 秋季「数据要素 × 智能体」特训营开始招募 平台 面向 OPC 创业团队,聚焦数据资源与行业模型结合 \N 尚数网 2026-08-08 10:00:00+00 1850
|
||
8 数据出境合规 AI 已在 5 个城市上线 行业 数据出境合规 AI 在 5 个城市正式上线 \N 吴桐 2026-08-05 10:00:00+00 1320
|
||
9 政策速递 3.0:AI 政策匹配上线 平台 政策速递 3.0 上线 AI 政策匹配引擎 \N 李梦 2026-08-02 10:00:00+00 980
|
||
10 13 个跨境数据项目完成 PIPL 实战培训 行业 13 个跨境数据项目完成 PIPL 实战培训 \N 林岚 2026-07-30 10:00:00+00 720
|
||
11 智能体 2 期启动,首日招生破 30 人 活动 夏季智能体 2 期启动,首日招生破 30 人 \N Bryan 2026-07-25 10:00:00+00 850
|
||
12 园区安全大脑首期交付,安全事件识别准确率 95% 行业 园区安全大脑首期交付,安全事件识别准确率 95% \N 周扬 2026-07-20 10:00:00+00 612
|
||
13 数据资产入表 8 号文深度解读 政策 财政部 8 号文数据资产入表深度解读 \N Vivian Z. 2026-07-15 10:00:00+00 1480
|
||
14 广州南沙跨境数据合作区正式落地 政策 广州南沙跨境数据合作区正式落地 \N 李娟 2026-07-10 10:00:00+00 2120
|
||
15 壹心系 OPC 跨境电商项目入驻深投控南山智谷 平台 壹心跨境电商运营工作室入驻深投控南山智谷,融合八爪鱼数据采集 + 九鑫智能 RPA \N 尚数网 2026-08-08 09:00:00+00 1320
|
||
16 易法通律所 OPC 入驻上海·市北高新,首单 3000 万处置启动 平台 易法通律所 OPC 入驻上海·市北高新,首单 3000 万不良债权处置启动 \N 尚数网 2026-08-05 09:00:00+00 1180
|
||
17 八爪鱼 MCP 服务上线:让 AI 智能体直接调用采集能力 行业 八爪鱼 MCP 服务上线,让 AI 智能体直接调用 5000 台云采集节点 \N 八爪鱼 2026-08-01 09:00:00+00 2890
|
||
18 九鑫智能 9Xin 全球商贸行业 AI 模型入选工信部典型案例 行业 九鑫智能 9Xin 全球商贸行业 AI 模型(内外贸一体化)入选工信部"人工智能赋能新型工业化典型应用案例" \N 九鑫智能 2026-07-28 09:00:00+00 3120
|
||
19 壹心系 OPC 跨境电商项目入驻深投控南山智谷 平台 壹心跨境电商运营工作室入驻深投控南山智谷,融合八爪鱼数据采集 + 九鑫智能 RPA \N 尚数网 2026-08-08 09:00:00+00 1320
|
||
20 易法通律所 OPC 入驻上海·市北高新,首单 3000 万处置启动 平台 易法通律所 OPC 入驻上海·市北高新,首单 3000 万不良债权处置启动 \N 尚数网 2026-08-05 09:00:00+00 1180
|
||
21 八爪鱼 MCP 服务上线:让 AI 智能体直接调用采集能力 行业 八爪鱼 MCP 服务上线,让 AI 智能体直接调用 5000 台云采集节点 \N 八爪鱼 2026-08-01 09:00:00+00 2890
|
||
22 九鑫智能 9Xin 全球商贸行业 AI 模型入选工信部典型案例 行业 九鑫智能 9Xin 全球商贸行业 AI 模型入选工信部"人工智能赋能新型工业化典型应用案例" \N 九鑫智能 2026-07-28 09:00:00+00 3120
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: partners; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.partners (id, name, short_name, type, logo, homepage, description, capabilities, scenarios, featured, contact, status, created_at) FROM stdin;
|
||
1 深圳市数阔信息技术有限公司·八爪鱼 八爪鱼 data-source https://www.bazhuayu.com/favicon.ico https://www.bazhuayu.com 八爪鱼采集器 / 八爪鱼 RPA / 八爪鱼云采集 / AI 开放平台(MCP / OpenAPI / CLI)。450 万+ 用户,1 万+ 品牌 / 国央企,覆盖电商、社媒、新闻、招投标、舆情、市场研究。 ["可视化零代码爬取","智能识别 + 异构数据处理","5000 台云服务器 7×24 采集","OpenAPI / MCP / CLI 集成","300+ 主流网站采集模板","RPA 自动化办公"] ["跨境电商 SKU / 评论采集","社媒舆情监测","招投标信息聚合","竞品价格监控","海外品牌市场调研","企业 RPA 自动化"] t liaosijin@skieer.com active 2026-08-12 01:17:14.455798+00
|
||
2 浙江九鑫智能科技有限公司·九鑫智能 九鑫智能 ai-provider https://9xinai.com/favicon.ico https://9xinai.com 九鑫智能致力于"超级自动化 × 商业智能 × 智慧大脑"。RPA 设计器 / RPA 机器人 / 数据仓库 / NLP / 行业 AI 模型。9Xin 全球商贸行业 AI 模型(嘉兴唯一入选浙江省经信厅推荐至工信部"人工智能赋能新型工业化典型应用案例")。累计成功运行 3 万+ 电商店铺。 ["超级自动化(业务系统登录/查询/录入/读取)","跨系统数据迁移(ERP / WMS / CRM / 数据库)","多渠道信息汇集(邮件 / 聊天 / 语音)","商业智能与企业数据挖掘","行业大脑定制化(内贸 / 外贸一体化)"] ["跨境电商全流程自动化","企业数据治理与 BI","外贸获客与市场分析","智能客服与销售 RPA","出海企业内贸外贸一体化"] t huangniannian@9xin.ai active 2026-08-12 01:17:14.455798+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: policies; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.policies (id, title, region, category, amount_max, intro, apply_url, status, created_at) FROM stdin;
|
||
1 中关村 AI 创业扶持资金 北京 研发支持 1000000.00 面向人工智能早期创业团队,单项目最高 100 万 https://shangshuwang.cn/policies/zgc-ai open 2026-08-11 15:18:16.561122+00
|
||
2 杨浦区 OPC 创业租金减免 上海 租金减免 300000.00 杨浦区 OPC 创业团队前三年租金 50% 减免 https://shangshuwang.cn/policies/yp-rent open 2026-08-11 15:18:16.561122+00
|
||
3 南山数据要素产业专项 深圳 创业补贴 500000.00 面向数据要素应用项目的补贴 https://shangshuwang.cn/policies/ns-data open 2026-08-11 15:18:16.561122+00
|
||
4 北京市 AI 人才引进 北京 人才扶持 200000.00 AI 方向高端人才一次性补贴 https://shangshuwang.cn/policies/bj-talent open 2026-08-11 15:18:16.561122+00
|
||
5 深圳创业补贴 深圳 创业补贴 100000.00 高校毕业生创业一次性补贴 https://shangshuwang.cn/policies/sz-startup open 2026-08-11 15:18:16.561122+00
|
||
6 中关村研发费用加计扣除 北京 研发支持 2000000.00 研发费用加计扣除政策 https://shangshuwang.cn/policies/zgc-rnd open 2026-08-11 15:18:16.561122+00
|
||
7 北京·中关村 AI 模型专项 北京 研发支持 800000.00 面向 AI 模型微调项目 https://shangshuwang.cn/policies/zgc-model open 2026-08-12 00:50:21.802969+00
|
||
8 上海·AI 人才租房补贴 上海 人才扶持 100000.00 AI 人才租房补贴 https://shangshuwang.cn/policies/sh-talent open 2026-08-12 00:50:21.802969+00
|
||
9 南山·数据资产入表补贴 深圳 研发支持 500000.00 数据资产入表专项补贴 https://shangshuwang.cn/policies/ns-asset open 2026-08-12 00:50:21.802969+00
|
||
10 杭州·OPC 一人公司专项 杭州 创业补贴 300000.00 OPC 一人公司专项补贴 https://shangshuwang.cn/policies/hz-opc open 2026-08-12 00:50:21.802969+00
|
||
11 广州·跨境数据合作区专项 广州 研发支持 1500000.00 南沙跨境数据合作区专项 https://shangshuwang.cn/policies/gz-cross open 2026-08-12 00:50:21.802969+00
|
||
12 苏州·工业园制造业 AI 苏州 研发支持 400000.00 制造业 AI 专项 https://shangshuwang.cn/policies/sz-mfg open 2026-08-12 00:50:21.802969+00
|
||
13 杨浦·智能体专项 上海 研发支持 600000.00 杨浦智能体专项 https://shangshuwang.cn/policies/yp-agent open 2026-08-12 00:50:21.802969+00
|
||
14 全国·中小企业数字化补贴 全国 创业补贴 200000.00 中小企业数字化转型补贴 https://shangshuwang.cn/policies/national-digital open 2026-08-12 00:50:21.802969+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: policy_applications; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.policy_applications (id, project_id, policy_id, status, submitted_at, granted_at, amount, notes, created_at) FROM stdin;
|
||
1 1 1 granted 2026-03-20 2026-05-10 600000.00 中关村 AI 创业扶持资金 2026-08-11 15:18:16.563902+00
|
||
2 3 2 granted 2026-04-01 2026-04-30 300000.00 杨浦租金减免 2026-08-11 15:18:16.563902+00
|
||
3 6 1 granted 2026-03-15 2026-04-15 800000.00 中关村 AI 创业扶持资金 2026-08-11 15:18:16.563902+00
|
||
4 12 3 granted 2026-03-10 2026-04-20 500000.00 南山数据要素专项 2026-08-11 15:18:16.563902+00
|
||
5 8 1 reviewing 2026-06-15 \N \N 智审官申请中关村扶持 2026-08-11 15:18:16.563902+00
|
||
6 4 3 submitted 2026-07-01 \N \N 低空哨兵申请 2026-08-11 15:18:16.563902+00
|
||
7 2 1 granted 2026-04-10 2026-05-30 400000.00 医言通申请 2026-08-11 15:18:16.563902+00
|
||
8 13 6 granted 2026-05-15 2026-06-30 800000.00 海关清关 AI 申请 2026-08-12 00:50:21.804687+00
|
||
9 14 5 granted 2026-05-20 2026-07-01 1200000.00 翻译官 AI 申请 2026-08-12 00:50:21.804687+00
|
||
10 15 1 reviewing 2026-07-15 \N \N 数据中台申请 2026-08-12 00:50:21.804687+00
|
||
11 16 1 submitted 2026-08-01 \N \N 法务 SaaS 申请 2026-08-12 00:50:21.804687+00
|
||
12 18 7 submitted 2026-07-25 \N \N 工业小模型申请 2026-08-12 00:50:21.804687+00
|
||
13 20 9 granted 2026-06-10 2026-07-15 600000.00 农业数智申请 2026-08-12 00:50:21.804687+00
|
||
14 21 1 granted 2026-05-25 2026-06-30 500000.00 医疗影像 AI 申请 2026-08-12 00:50:21.804687+00
|
||
15 24 10 granted 2026-05-20 2026-06-25 300000.00 政策速递申请 2026-08-12 00:50:21.804687+00
|
||
16 25 11 granted 2026-06-15 2026-07-30 1500000.00 跨境合规 AI 申请 2026-08-12 00:50:21.804687+00
|
||
17 26 1 granted 2026-06-20 2026-08-05 400000.00 园区安全大脑申请 2026-08-12 00:50:21.804687+00
|
||
18 27 10 submitted 2026-08-15 \N \N 低代码合规申请 2026-08-12 00:50:21.804687+00
|
||
21 28 12 submitted 2026-08-10 \N \N 深圳·南山数字创意出口补贴申请 2026-08-12 01:18:22.840411+00
|
||
22 29 1 granted 2026-04-30 2026-06-15 200000.00 中关村 AI 创业扶持 2026-08-12 01:18:22.847876+00
|
||
23 29 8 submitted 2026-08-01 \N \N 国家中小企业数字化补贴 2026-08-12 01:18:22.847876+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: products; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.products (id, project_id, name, tagline, category, cover_url, demo_url, status, compliance, created_at) FROM stdin;
|
||
1 1 智城慧眼·城市部件巡查 Agent 用 AI 守住城市每一处 智能体 \N \N listed passed 2026-08-11 15:18:16.554849+00
|
||
2 3 大账房 Pro AI 财税把企业账本理清楚 SaaS \N \N listed passed 2026-08-11 15:18:16.554849+00
|
||
3 6 云公文 政务公文写作智能助手 SaaS \N \N certified passed 2026-08-11 15:18:16.554849+00
|
||
4 12 智检云 工业质检 SaaS 平台 SaaS \N \N certified passed 2026-08-11 15:18:16.554849+00
|
||
5 2 医言通 基层医生辅助问诊 智能体 \N \N prototyping pending 2026-08-11 15:18:16.554849+00
|
||
6 4 低空哨兵 低空事件智能识别 智能体 \N \N prototyping pending 2026-08-11 15:18:16.554849+00
|
||
7 7 金声合成 行业语音合成平台 API \N \N prototyping pending 2026-08-11 15:18:16.554849+00
|
||
8 8 智审官 智能合同审查 SaaS \N \N listed passed 2026-08-11 15:18:16.554849+00
|
||
9 5 金枢链 供应链关系图谱 API \N \N prototyping pending 2026-08-11 15:18:16.554849+00
|
||
10 10 链上合规 跨境数据合规 API \N \N prototyping pending 2026-08-11 15:18:16.554849+00
|
||
11 13 海关清关 AI Pro 让跨境贸易更高效 智能体 \N \N prototyping pending 2026-08-12 00:50:21.798585+00
|
||
12 14 翻译官 AI 专业领域多语种翻译 API \N \N listed passed 2026-08-12 00:50:21.798585+00
|
||
13 15 数据中台·小微版 小微企业用得起的数据中台 SaaS \N \N prototyping pending 2026-08-12 00:50:21.798585+00
|
||
14 16 法务 SaaS 合同审查自动化 SaaS \N \N prototyping pending 2026-08-12 00:50:21.798585+00
|
||
15 17 财税 Agent 中小微企业财税助手 智能体 \N \N prototyping pending 2026-08-12 00:50:21.798585+00
|
||
16 18 工业小模型 工业场景小模型 API \N \N prototyping pending 2026-08-12 00:50:21.798585+00
|
||
17 19 跨境支付通 跨境支付结算 AI API \N \N prototyping pending 2026-08-12 00:50:21.798585+00
|
||
18 20 农业数智 农业智能决策 API \N \N prototyping pending 2026-08-12 00:50:21.798585+00
|
||
19 21 医疗影像 AI 放射影像 AI 辅助 API \N \N prototyping pending 2026-08-12 00:50:21.798585+00
|
||
20 22 翻译助手·PCB PCB 行业术语翻译 API \N \N prototyping pending 2026-08-12 00:50:21.798585+00
|
||
21 23 AI 配音 多语种 AI 配音 API \N \N prototyping pending 2026-08-12 00:50:21.798585+00
|
||
22 24 政策速递 公司级政策速递 SaaS \N \N listed passed 2026-08-12 00:50:21.798585+00
|
||
23 25 数据出境合规 AI 跨境数据合规 AI SaaS \N \N certified passed 2026-08-12 00:50:21.798585+00
|
||
24 26 园区安全大脑 园区安全事件预警 智能体 \N \N listed passed 2026-08-12 00:50:21.798585+00
|
||
25 27 低代码合规 低代码合规审查 SaaS \N \N prototyping pending 2026-08-12 00:50:21.798585+00
|
||
28 28 壹心·AI 选品看板 数据驱动爆品率 85%+ SaaS \N \N prototyping pending 2026-08-12 01:18:22.838645+00
|
||
29 28 壹心·3D 智能打样 缩短打样周期 40% API \N \N listed passed 2026-08-12 01:18:22.838645+00
|
||
30 29 易法通·AI 尽调助手 债权凭证智能识别 + 风险评估 API \N \N listed passed 2026-08-12 01:18:22.846987+00
|
||
31 29 易法通·不良资产处置平台 全流程处置可视化 SaaS \N \N prototyping pending 2026-08-12 01:18:22.846987+00
|
||
32 29 易法通·债务纠纷律师匹配 精准律师画像 + 智能匹配 SaaS \N \N prototyping pending 2026-08-12 01:18:22.846987+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: projects; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.projects (id, name, slug, stage, direction, team_type, founder, phone, email, intro, progress, space_id, cohort_id, package, created_at, updated_at, partners) FROM stdin;
|
||
1 智城慧眼 zhicheng-huiyan pilot 城市治理 microteam 陈墨 13800000001 chenmo@zhicheng.com 城市部件智能巡查 Agent,融合多模态识别与低空视角 72 4 1 advanced 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
3 大账房 dazhangfang pilot 金融 microteam 王砚 13800000003 wangyan@dazhangfang.com 中小企业票据 OCR + 财税合规 68 4 1 advanced 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
4 低空哨兵 dikong-shaobing prototyping 城市治理 earlyteam 周扬 13800000004 zhouyang@dikong.cn 无人机视角城市事件识别 52 4 2 advanced 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
5 金枢链 jinshulian incubating 产业协同 microteam 李远 13800000005 liyuan@jinshu.cn 供应链关系图谱 + 风险预警 35 4 1 basic 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
7 金声合成 jinsheng prototype 文娱 oneperson Vivian 13800000007 vivian@jinsheng.cn 行业语音合成与定制声纹 55 4 2 basic 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
9 街景问数 jiejing recruit 城市治理 oneperson 唐清 13800000009 tangqing@jiejing.cn 街景视频多模态问数 12 4 \N basic 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
10 链上合规 lian-shang incubating 金融 oneperson 秦岚 13800000010 qinlan@lianshang.cn 跨境数据合规与隐私计算 28 4 1 basic 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
11 智乡游 zhixiangyou recruit 文娱 microteam Aimee 13800000011 aimee@zhixiangyou.cn 乡村文旅 AI 导览 8 4 \N basic 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
18 工业小模型 industry-mini prototyping 制造 oneperson Echo 13800000018 echo@ind.cn 工业场景小模型微调 28 2 6 basic 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
6 云公文 yungongwen market 政务 oneperson 林岚 13800000006 linlan@yungongwen.cn 政务公文写作助手 85 2 1 custom 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
8 智审官 zhishenguan pilot 金融 earlyteam Bryan 13800000008 bryan@zhishen.cn 智能合同审查助手 65 2 2 advanced 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
12 智检云 zhijianyun market 制造 microteam 老郑 13800000012 laozheng@zhijian.cn 工业质检 SaaS 88 2 1 custom 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
22 翻译助手·PCB pcb-trans incubating 制造 oneperson 老李 13800000022 laoli@pcb.cn PCB 行业术语翻译 28 2 8 basic 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
16 法务 SaaS fa-saas prototyping 金融 oneperson Aimee 13800000016 aimee@fasaas.cn 合同审查 / 法规速递 32 3 5 basic 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
20 农业数智 agri-smart recruit 产业协同 oneperson 老农 13800000020 laonong@agri.cn 农业生产智能决策 18 3 8 basic 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
2 医言通 yiyantong prototyping 医疗 oneperson 苏婉 13800000002 suwan@yiyantong.cn 面向基层医生的辅助问诊智能体 45 3 1 basic 2026-08-11 15:18:16.535217+00 2026-08-11 15:18:16.535217+00 \N
|
||
26 园区安全大脑 park-safety pilot 城市治理 oneperson 周扬 13800000026 zhouyang@park.cn 园区安全事件智能预警 58 4 6 advanced 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
24 政策速递 policy-fast pilot 政务 oneperson 唐清 13800000024 tangqing@policy.cn 公司级政策速递服务 68 4 1 advanced 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
27 低代码合规 lowcode-comp prototyping 金融 oneperson 林岚 13800000027 linlan@lc.cn 低代码合规审查工具 38 4 5 basic 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
14 翻译官 AI translator-ai pilot 文娱 oneperson 李娟 13800000014 lijuan@trans.cn 法律 / 跨境多语种专业翻译 62 1 5 advanced 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
15 数据中台·小微版 micro-dm incubating 产业协同 microteam 小于 13800000015 xiaoyu@microdm.cn 一站式数据采集加工中台 45 1 1 basic 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
19 跨境支付通 cross-pay prototyping 金融 microteam 秦岚 13800000019 qinlan@pay.cn 跨境电商支付清算助手 35 1 5 advanced 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
21 医疗影像 AI med-img-ai prototyping 医疗 microteam 苏婉 13800000021 suwan@med.cn 放射影像 AI 辅助诊断 42 1 1 advanced 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
17 财税 Agent caishui-agent incubating 金融 oneperson 老郑 13800000017 laozheng@cs.cn 中小微企业财税助手 48 3 6 basic 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
23 AI 配音 ai-dubbing recruit 文娱 oneperson Vivian 13800000023 vivian@dub.cn 多语种 AI 配音 12 3 8 basic 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
13 海关清关 AI customs-ai prototyping 产业协同 oneperson 赵磊 13800000013 zhaolei@customs.cn 跨境贸易商品智能归类与风险识别 38 4 5 basic 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
25 数据出境合规 AI dataexport-ai market 金融 microteam 赵磊 13800000025 zhaolei@export.ai 跨境数据出境合规 AI 85 4 5 custom 2026-08-12 00:50:21.786032+00 2026-08-12 00:50:21.786032+00 \N
|
||
28 壹心·欧美跨境内衣品牌 yixin-cross-border-lingerie incubating 文娱 oneperson 周小姐 13900000028 zhou@yixinlingerie.com 壹心品牌孵化与跨境电商运营工作室(OPC):依托创始人 16 年内衣行业深耕经验与欧美跨境顶级操盘战绩(曾主导 Momcozy / Luvlette / 芬怡等头部品牌文胸品类全案运营,年销售额 3.6 亿,年增长 20.5%,新品爆品率 80%),以轻资产个人公司为起步载体,聚焦中高端欧美功能性内衣品类,AI + 数据驱动优化全链路效率。 42 4 10 advanced 2026-08-12 01:17:56.818994+00 2026-08-12 01:17:56.818994+00 {1,2}
|
||
29 易法通·不良资产处置与债务纠纷 yifatong-debt-asset incubating 金融 oneperson 易先生 13900000029 yi@yifatonglaw.com 易法通不良资产处置与债务纠纷专项咨询工作室(OPC):依托中国政法大学法学硕士易先生 12 年法律从业经验 + 8 年不良资产处置深耕(曾主导 / 参与处置银行 / 企业不良资产包 12 个,涉及债权金额累计超 8 亿元,平均资产回收率 65% 远超行业 45%,累计代理债务纠纷案件 200+ 起,成功为客户挽回经济损失累计超 3 亿元),以个人公司为轻资产起步载体,聚焦不良资产处置、各类债务纠纷化解两大核心领域。 48 1 7 advanced 2026-08-12 01:17:56.823076+00 2026-08-12 01:17:56.823076+00 {1,2}
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: scenario_mappings; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.scenario_mappings (id, project_id, scenario_id, status, started_at, closed_at, feedback, created_at) FROM stdin;
|
||
1 1 1 testing 2026-04-01 \N 已识别 12 类城市部件,准确率 93% 2026-08-11 15:18:16.549813+00
|
||
2 4 1 testing 2026-04-20 \N 低空视角识别准确率 88% 2026-08-11 15:18:16.549813+00
|
||
3 2 4 testing 2026-04-15 \N 基层医生反馈良好 2026-08-11 15:18:16.549813+00
|
||
4 3 5 passed 2026-04-01 2026-06-15 试点结束,决定采购 2026-08-11 15:18:16.549813+00
|
||
5 6 7 passed 2026-03-01 2026-05-30 已在 3 个部门推广 2026-08-11 15:18:16.549813+00
|
||
6 12 1 passed 2026-03-15 2026-06-30 试点合格,进入采购 2026-08-11 15:18:16.549813+00
|
||
7 1 6 pending \N \N 已提交申请 2026-08-11 15:18:16.549813+00
|
||
8 8 5 testing 2026-06-15 \N 合同审查准确率 95% 2026-08-11 15:18:16.549813+00
|
||
9 5 3 pending \N \N 已对接园区招商 2026-08-11 15:18:16.549813+00
|
||
10 13 11 testing 2026-06-01 \N 清关商品分类准确率 92% 2026-08-12 00:50:21.794439+00
|
||
11 14 16 testing 2026-06-15 \N 多语种翻译质量高 2026-08-12 00:50:21.794439+00
|
||
12 15 3 pending \N \N 待启动 2026-08-12 00:50:21.794439+00
|
||
13 16 9 testing 2026-07-01 \N 合同审查准确率 95% 2026-08-12 00:50:21.794439+00
|
||
14 17 5 testing 2026-07-15 \N 财税合规表现良好 2026-08-12 00:50:21.794439+00
|
||
15 18 4 pending \N \N 待启动 2026-08-12 00:50:21.794439+00
|
||
16 19 11 pending \N \N 待启动 2026-08-12 00:50:21.794439+00
|
||
17 20 18 testing 2026-07-10 \N 产业链数据初步验证 2026-08-12 00:50:21.794439+00
|
||
18 21 13 testing 2026-07-15 \N 医学影像 AI 表现良好 2026-08-12 00:50:21.794439+00
|
||
19 22 5 pending \N \N 待启动 2026-08-12 00:50:21.794439+00
|
||
20 23 17 pending \N \N 待启动 2026-08-12 00:50:21.794439+00
|
||
21 24 8 passed 2026-06-01 2026-07-30 已在 3 个政府机关推广 2026-08-12 00:50:21.794439+00
|
||
22 25 11 passed 2026-05-01 2026-07-30 已在 5 个城市上线 2026-08-12 00:50:21.794439+00
|
||
23 26 12 testing 2026-07-15 \N 园区安全事件识别准确 2026-08-12 00:50:21.794439+00
|
||
24 27 9 testing 2026-07-20 \N 合同审查初测 95% 2026-08-12 00:50:21.794439+00
|
||
25 13 16 pending \N \N 准备启动 2026-08-12 00:50:21.794439+00
|
||
26 14 9 pending \N \N 准备启动 2026-08-12 00:50:21.794439+00
|
||
27 17 1 pending \N \N 准备启动 2026-08-12 00:50:21.794439+00
|
||
28 25 16 passed 2026-06-01 2026-07-30 已商用 2026-08-12 00:50:21.794439+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: scenarios; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.scenarios (id, name, domain, publisher, intro, partner_org, opened_at, status, created_at) FROM stdin;
|
||
1 市级城市部件巡查 城市治理 市级城管局 面向城市部件、违规事件的高频巡查需求 市城管局 2026-03-01 open 2026-08-11 15:18:16.546914+00
|
||
2 政务热线智能分派 公共服务 市政务服务管理局 12345 热线智能分派与处置 市政务办 2026-03-15 open 2026-08-11 15:18:16.546914+00
|
||
3 产业园区招商评估 产业协同 高新区招商局 园区招商企业评估与匹配 高新区 2026-04-01 open 2026-08-11 15:18:16.546914+00
|
||
4 基层医疗辅助问诊 公共服务 市卫健委 基层医疗辅助问诊 市卫健委 2026-04-15 open 2026-08-11 15:18:16.546914+00
|
||
5 中小企业财税合规 企业服务 市税务局 中小企业财税合规 市税务局 2026-05-01 open 2026-08-11 15:18:16.546914+00
|
||
6 重点车辆监管 城市治理 市交通局 重点车辆实时监管 市交通局 2026-05-15 pilot 2026-08-11 15:18:16.546914+00
|
||
7 政务公文写作 公共服务 市政府办公厅 政务公文写作辅助 市政府办公厅 2026-06-01 open 2026-08-11 15:18:16.546914+00
|
||
8 低空空域事件 城市治理 市城管局 低空空域事件识别 市城管局 2026-06-15 open 2026-08-11 15:18:16.546914+00
|
||
9 海关清关 AI 产业协同 海关总署 跨境商品智能归类 海关总署 2026-04-01 open 2026-08-12 00:50:21.792939+00
|
||
10 城市应急联动 公共服务 市应急局 城市应急事件联动处置 市应急局 2026-05-01 open 2026-08-12 00:50:21.792939+00
|
||
11 园区安全监管 城市治理 高新区 园区安全事件监管 高新区 2026-04-15 open 2026-08-12 00:50:21.792939+00
|
||
12 智慧农业试点 产业协同 市农业农村局 农业生产智能决策试点 市农业农村局 2026-06-01 open 2026-08-12 00:50:21.792939+00
|
||
13 医院放射影像 公共服务 市卫健委 医院放射影像 AI 辅助 市卫健委 2026-05-15 open 2026-08-12 00:50:21.792939+00
|
||
14 跨境贸易结算 企业服务 自贸区 跨境贸易结算 自贸区 2026-04-15 open 2026-08-12 00:50:21.792939+00
|
||
15 AIGC 内容审核 公共服务 市网信办 AIGC 内容审核 市网信办 2026-06-15 open 2026-08-12 00:50:21.792939+00
|
||
16 政务热���智能分派 公共服务 市政务办 政务热线智能分派 市政务办 2026-07-01 open 2026-08-12 00:50:21.792939+00
|
||
17 电子合同存证 企业服务 市司法局 电子合同存证 市司法局 2026-05-15 open 2026-08-12 00:50:21.792939+00
|
||
18 农业产业链 产业协同 市农业农村局 农业产业链数据 市农业农村局 2026-07-01 open 2026-08-12 00:50:21.792939+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: spaces; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.spaces (id, name, location, capacity, occupied, type, features, status, created_at) FROM stdin;
|
||
10 上海·市北高新 AI-DATA-OPC 孵化空间 上海市静安区市北高新园区(江场西路 218 号) 120 92 hybrid 共享办公 / 路演厅 / 数据沙盒 / 边缘 GPU 算力 / 区块链存证 open 2026-08-12 01:12:48.238271+00
|
||
11 青岛·城阳数据要素产业园 青岛市城阳区峪云谷数字经济产业园(春阳路 1 号) 80 56 hybrid 跨境数据沙盒 / 隐私计算 / 算力网络 / 工业互联网 SDK open 2026-08-12 01:12:48.238271+00
|
||
12 武汉·光谷 AI-DATA 创业孵化空间 武汉市东湖高新区光谷生物城(高新大道 666 号) 100 78 hybrid 生物医药数据 / 工业数据 / 区块链存证 / 路演中心 open 2026-08-12 01:12:48.238271+00
|
||
13 深圳·深投控南山智谷 深圳市南山区深投控创智天地(科苑南路 3331 号) 150 117 hybrid 共享办公 / 路演厅 / GPU 算力池 / 隐私计算 / 跨境数据实验室 open 2026-08-12 01:12:48.238271+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: team_members; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.team_members (id, project_id, name, role, bio, created_at) FROM stdin;
|
||
1 1 陈墨 创始人 前某大厂 CV 工程师,连续创业者 2026-08-11 15:18:16.540966+00
|
||
2 1 张博文 算法 硕博连读,多模态方向 2026-08-11 15:18:16.540966+00
|
||
3 2 苏婉 创始人 前社区医生,全栈工程师 2026-08-11 15:18:16.540966+00
|
||
4 3 王砚 创始人 注册会计师 + AI 双背景 2026-08-11 15:18:16.540966+00
|
||
5 3 赵明 产品 财税 SaaS 经验 2026-08-11 15:18:16.540966+00
|
||
6 4 周扬 创始人 原某无人机厂商产品总监 2026-08-11 15:18:16.540966+00
|
||
7 4 Echo 算法 CV 资深 2026-08-11 15:18:16.540966+00
|
||
8 5 李远 创始人 供应链金融背景 2026-08-11 15:18:16.540966+00
|
||
9 5 小蒋 技术 图数据库专家 2026-08-11 15:18:16.540966+00
|
||
10 6 林岚 创始人 前政府办公室 + NLP 工程师 2026-08-11 15:18:16.540966+00
|
||
11 7 Vivian 创始人 语音 AI 资深产品 2026-08-11 15:18:16.540966+00
|
||
12 8 Bryan 创始人 前 AI 团队 lead 2026-08-11 15:18:16.540966+00
|
||
13 8 Mia 法务 前律所合规 2026-08-11 15:18:16.540966+00
|
||
14 12 老郑 创始人 制造业 15 年 2026-08-11 15:18:16.540966+00
|
||
15 12 小于 算法 缺陷检测专家 2026-08-11 15:18:16.540966+00
|
||
16 13 赵磊 创始人 前海关报关员 + 跨境贸易 2026-08-12 00:50:21.788521+00
|
||
17 14 李娟 创始人 前翻译公司合伙人 2026-08-12 00:50:21.788521+00
|
||
18 14 Mia 顾问 语言学专家 2026-08-12 00:50:21.788521+00
|
||
19 15 小于 创始人 前阿里数据中台 2026-08-12 00:50:21.788521+00
|
||
20 15 小蒋 技术 实时计算 2026-08-12 00:50:21.788521+00
|
||
21 16 Aimee 创始人 前法务 + AI 工程师 2026-08-12 00:50:21.788521+00
|
||
22 17 老郑 创始人 前某财税软件合伙人 2026-08-12 00:50:21.788521+00
|
||
23 17 小于 产品 财税产品设计 2026-08-12 00:50:21.788521+00
|
||
24 18 Echo 创始人 前工业 AI 工程师 2026-08-12 00:50:21.788521+00
|
||
25 19 秦岚 创始人 跨境支付 2026-08-12 00:50:21.788521+00
|
||
26 20 老农 创始人 农业 IT + AI 2026-08-12 00:50:21.788521+00
|
||
27 21 苏婉 创始人 医疗 AI 资深 2026-08-12 00:50:21.788521+00
|
||
28 22 老李 创始人 PCB 行业 18 年 2026-08-12 00:50:21.788521+00
|
||
29 23 Vivian 创始人 AI 配音 2026-08-12 00:50:21.788521+00
|
||
30 24 唐清 创始人 政策研究 2026-08-12 00:50:21.788521+00
|
||
31 25 赵磊 创始人 前海关注册律师 2026-08-12 00:50:21.788521+00
|
||
32 25 小蒋 工程师 数据合规 2026-08-12 00:50:21.788521+00
|
||
33 26 周扬 创始人 园区安全 2026-08-12 00:50:21.788521+00
|
||
34 27 林岚 创始人 前律师 + AI 工程师 2026-08-12 00:50:21.788521+00
|
||
37 28 周小姐 创始人 16 年内衣行业全链路经验 / 15 年团队管理 / 主导 Momcozy 等品牌年销 3.6 亿 2026-08-12 01:18:22.82906+00
|
||
38 28 Emma 设计合伙人 欧美时尚设计学院背景 2026-08-12 01:18:22.82906+00
|
||
39 28 AI 数据助理 运营 AI 工具 + 数据看板负责人 2026-08-12 01:18:22.82906+00
|
||
40 29 易先生 创始人 中国政法大学法学硕士 / 12 年法律从业 / 8 年不良资产处置 2026-08-12 01:18:22.844378+00
|
||
41 29 老郑 法务助理 律所 5 年 / 协助尽调 2026-08-12 01:18:22.844378+00
|
||
42 29 Mia 兼职律师 争议解决方向 2026-08-12 01:18:22.844378+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: tool_runs; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.tool_runs (id, tool_id, user_name, input, output, score, duration_ms, created_at) FROM stdin;
|
||
1 8 demo@opc {"pi_count": 1500000, "data_type": "个人信息", "cumulative": "否", "pii_sensitive": "是", "import_country": "其他"} {"laws": ["《数据出境安全评估办法》", "《个人信息出境标准合同办法》", "《个人信息保护法》第 38 条"], "path": "安全评估", "risk": 50, "score": 50, "steps": ["数据出境风险自评估(依据《数据出境安全评估办法》)", "向省级网信办提交评估申报", "国家网信办组织评审(45 个工作日内)", "通过后签订补充协议,2 年有效"], "reasons": ["处理 100 万人以上个人信息 → 必须申报安全评估"], "timestamp": "2026-08-11T23:39:31+08:00"} 50.00 0 2026-08-11 15:39:31.766843+00
|
||
2 13 demo@opc {"pii_items": ["手机号", "邮箱", "位置"], "company_name": "数智科技有限公司", "jurisdiction": "中国+GDPR", "product_name": "数据宝", "business_type": "SaaS"} {"score": 88, "document": "# 数据宝 隐私政策(草案)\\n\\n**最后更新**:2026-08-11\\n**适用产品**:数据宝(SaaS)\\n**适用法律**:中国+GDPR\\n\\n## 1. 我们收集的信息\\n\\n我们作为 数智科技有限公司 的运营方,在您使用 数据宝 过程中可能收集以下信息:\\n\\n- **账户信息**:手机号、邮箱(用于账号注册和登录)\\n- **设备信息**:设备型号、操作系统版本、设备识别码\\n- **使用信息**:访问时间、浏览 / 操作记录、IP 地址\\n- **主动提供**:您在使用服务中提交的内容\\n\\n**敏感个人信息收集**:\\n手机号、邮箱、位置\\n\\n## 2. 我们如何使用信息\\n\\n- 提供、维护、改进 数据宝 服务\\n- 安全保障:账号安全、风控反欺诈\\n- 个性化推荐:在您授权范围内\\n- 客服与售后支持\\n\\n## 3. 信息共享与披露\\n\\n- 您的个人信息原则上不会与第三方共享\\n- 法律法规要求、或行政司法机关合法要求时,可能依法披露\\n- 我们委托第三方处理时,会签订数据处理协议并监督其合规\\n\\n## 4. 您的权利\\n\\n- 查阅、复制个人信息\\n- 更正、补充个人信息\\n- 删除个人信息\\n- 撤回授权\\n- 注销账号\\n\\n您可通过 [联系我们] 行使上述权利。\\n\\n## 5. 数据存储与跨境\\n\\n- 数据存储在中华人民共和国境内\\n- 如涉及跨境:按《标准合同》备案\\n- 存储期限:实现目的所需最短时间\\n\\n## 6. Cookie 与同类技术\\n\\n我们使用 Cookie 与同类技术用于:\\n- 保持登录状态\\n- 偏好记忆\\n- 数据统计\\n\\n您可在浏览器设置中关闭 Cookie,部分功能可能受影响。\\n\\n## 7. 未成年人保护\\n\\n我们不面向未满 14 周岁未成年人提供服务。如发现已收集,请联系我们删除。\\n\\n## 8. 联系我们\\n\\n- 公司:数智科技有限公司\\n- 邮箱:[email protected]\\n- 地址:xxx\\n\\n---\\n本政策根据 中国+GDPR 制定,将随法律法规或业务变化更新。\\n", "sections": ["信息收集", "使用目的", "共享披露", "用户权利", "数据存储", "Cookie", "未成年人", "联系方式"], "next_steps": ["法务复核(建议 1-2 个工作日)", "上线前在产品内放置入口", "建立用户同意记录", "每半年复审更新"], "word_count": 835, "download_url": "#/download/privacy-policy-数据宝.md"} 88.00 0 2026-08-11 15:39:31.788861+00
|
||
3 16 demo@opc {"tone": "专业可信", "palette": "蓝", "keywords": "合规,智能,法务", "product_name": "智审官"} {"fonts": "思源黑体 / Inter / 苹方", "score": 90, "colors": {"accent": "#67e8f9", "primary": "#0d4ed8", "secondary": "#06b6d4"}, "product": "智审官", "slogans": ["让 智审官 成为你的默认选择", "智审官 — 为一人公司而生", "数据 + AI + 一个产品 = 智审官", "用 智审官,让人人都是数据高手"], "keywords": "合规,智能,法务", "tone_desc": "建立在合规与精度之上,给人以'可审计、可信赖'的视觉印象", "applications": ["产品官网 Header", "App 启动屏", "名片 / PPT 模板", "名片 / 微信头像"], "logo_concept": ["图形 + 文字组合(推荐)", "几何符号 + 字体延展", "抽象数据流肌理", "中文 / 英文双版本"]} 90.00 0 2026-08-11 15:39:31.807677+00
|
||
4 8 demo@opc {"pi_count": 1500000, "data_type": "个人信息", "pii_sensitive": "是", "import_country": "其他"} {"laws": ["《数据出境安全评估办法》", "《个人信息出境标准合同办法》", "《个人信息保护法》第 38 条"], "path": "安全评估", "risk": 50, "score": 50, "steps": ["数据出境风险自评估(依据《数据出境安全评估办法》)", "向省级网信办提交评估申报", "国家网信办组织评审(45 个工作日内)", "通过后签订补充协议,2 年有效"], "reasons": ["处理 100 万人以上个人信息 → 必须申报安全评估"], "timestamp": "2026-08-12T02:03:07+08:00"} 50.00 0 2026-08-11 18:03:07.743833+00
|
||
5 19 demo@opc {"has_user": "否", "has_company": "是", "has_privacy": "否", "has_revenue": "否", "has_prototype": "是", "has_data_inventory": "否"} {"score": 0, "total": 9, "advice": ["⚠️ 严重不足:4 个以下板块完成,建议先验证问题假设"], "canvas": [{"key": "customer_segments", "name": "客户细分", "value": "", "filled": false}, {"key": "value_propositions", "name": "价值主张", "value": "", "filled": false}, {"key": "channels", "name": "渠道通路", "value": "", "filled": false}, {"key": "customer_relationships", "name": "客户关系", "value": "", "filled": false}, {"key": "revenue_streams", "name": "收入来源", "value": "", "filled": false}, {"key": "key_resources", "name": "核心资源", "value": "", "filled": false}, {"key": "key_activities", "name": "关键活动", "value": "", "filled": false}, {"key": "key_partnerships", "name": "重要伙伴", "value": "", "filled": false}, {"key": "cost_structure", "name": "成本结构", "value": "", "filled": false}], "filled": 0, "project": ""} 0.00 0 2026-08-11 18:03:13.506431+00
|
||
6 16 demo@opc {"tone": "专业可信", "palette": "蓝", "keywords": "合规,智能,法务", "product_name": "智审官"} {"fonts": "思源黑体 / Inter / 苹方", "score": 90, "colors": {"accent": "#67e8f9", "primary": "#0d4ed8", "secondary": "#06b6d4"}, "product": "智审官", "slogans": ["让 智审官 成为你的默认选择", "智审官 — 为一人公司而生", "数据 + AI + 一个产品 = 智审官", "用 智审官,让人人都是数据高手"], "keywords": "合规,智能,法务", "tone_desc": "建立在合规与精度之上,给人以'可审计、可信赖'的视觉印象", "applications": ["产品官网 Header", "App 启动屏", "名片 / PPT 模板", "名片 / 微信头像"], "logo_concept": ["图形 + 文字组合(推荐)", "几何符号 + 字体延展", "抽象数据流肌理", "中文 / 英文双版本"]} 90.00 0 2026-08-11 18:03:13.530433+00
|
||
7 13 demo@opc {"pii_items": ["手机号", "邮箱"], "company_name": "数智科技", "jurisdiction": "中国+GDPR", "product_name": "数据宝", "business_type": "SaaS"} {"score": 88, "document": "# 数据宝 隐私政策(草案)\\n\\n**最后更新**:2026-08-12\\n**适用产品**:数据宝(SaaS)\\n**适用法律**:中国+GDPR\\n\\n## 1. 我们收集的信息\\n\\n我们作为 数智科技 的运营方,在您使用 数据宝 过程中可能收集以下信息:\\n\\n- **账户信息**:手机号、邮箱(用于账号注册和登录)\\n- **设备信息**:设备型号、操作系统版本、设备识别码\\n- **使用信息**:访问时间、浏览 / 操作记录、IP 地址\\n- **主动提供**:您在使用服务中提交的内容\\n\\n**敏感个人信息收集**:\\n手机号、邮箱\\n\\n## 2. 我们如何使用信息\\n\\n- 提供、维护、改进 数据宝 服务\\n- 安全保障:账号安全、风控反欺诈\\n- 个性化推荐:在您授权范围内\\n- 客服与售后支持\\n\\n## 3. 信息共享与披露\\n\\n- 您的个人信息原则上不会与第三方共享\\n- 法律法规要求、或行政司法机关合法要求时,可能依法披露\\n- 我们委托第三方处理时,会签订数据处理协议并监督其合规\\n\\n## 4. 您的权利\\n\\n- 查阅、复制个人信息\\n- 更正、补充个人信息\\n- 删除个人信息\\n- 撤回授权\\n- 注销账号\\n\\n您可通过 [联系我们] 行使上述权利。\\n\\n## 5. 数据存储与跨境\\n\\n- 数据存储在中华人民共和国境内\\n- 如涉及跨境:按《标准合同》备案\\n- 存储期限:实现目的所需最短时间\\n\\n## 6. Cookie 与同类技术\\n\\n我们使用 Cookie 与同类技术用于:\\n- 保持登录状态\\n- 偏好记忆\\n- 数据统计\\n\\n您可在浏览器设置中关闭 Cookie,部分功能可能受影响。\\n\\n## 7. 未成年人保护\\n\\n我们不面向未满 14 周岁未成年人提供服务。如发现已收集,请联系我们删除。\\n\\n## 8. 联系我们\\n\\n- 公司:数智科技\\n- 邮箱:[email protected]\\n- 地址:xxx\\n\\n---\\n本政策根据 中国+GDPR 制定,将随法律法规或业务变化更新。\\n", "sections": ["信息收集", "使用目的", "共享披露", "用户权利", "数据存储", "Cookie", "未成年人", "联系方式"], "next_steps": ["法务复核(建议 1-2 个工作日)", "上线前在产品内放置入口", "建立用户同意记录", "每半年复审更新"], "word_count": 824, "download_url": "#/download/privacy-policy-数据宝.md"} 88.00 0 2026-08-11 18:03:13.55135+00
|
||
8 8 demo@opc {"pi_count": 1200000, "data_type": "个人信息", "cumulative": "否", "pii_sensitive": "是", "import_country": "其他"} {"path": "安全评估", "risk": 50, "score": 50, "reasons": ["处理 100 万人以上个人信息 → 必须申报安全评估"]} 50.00 18 2026-08-12 01:00:00+00
|
||
9 13 demo@opc {"pii_items": ["手机号", "邮箱"], "company_name": "数智科技", "jurisdiction": "中国+GDPR", "product_name": "数据宝", "business_type": "SaaS"} {"document": "# 数据宝 隐私政策", "sections": ["信息收集", "使用目的", "共享披露", "用户权利", "数据存储", "Cookie", "未成年人", "联系方式"]} 88.00 32 2026-08-12 01:05:00+00
|
||
10 16 demo@opc {"tone": "专业可信", "palette": "蓝", "keywords": "合规,智能,法务", "product_name": "智审官"} {"slogans": ["让 智审官 成为你的默认选择", "智审官 — 为一人公司而生"]} 90.00 24 2026-08-12 01:08:00+00
|
||
11 19 demo@opc {"has_user": "否", "has_company": "是", "has_privacy": "否", "has_revenue": "否", "has_prototype": "是", "has_data_inventory": "否"} {"level": "MVP 验证期", "score": 40, "advice": ["⚠️ 立即在产品内发布隐私政策", "⚠️ 寻找 10 个种子用户深度访谈"]} 40.00 15 2026-08-12 01:12:00+00
|
||
12 11 demo@opc {"pi_count": 500000, "data_type": "重要数据", "cumulative": "是", "pii_sensitive": "否", "import_country": "其他"} {"path": "安全评估", "risk": 75, "score": 25, "reasons": ["涉及重要数据 → 必须申报安全评估"]} 25.00 21 2026-08-12 01:15:00+00
|
||
13 15 demo@opc {"fields": {"pi_count": 50000, "data_type": "个人信息", "cumulative": "否", "pii_sensitive": "否", "import_country": "与中国签有数据协议"}, "tool_id": 15} {"path": "标准合同", "risk": 20, "score": 80, "reasons": ["与数据协议国家 → 走标准合同"]} 80.00 19 2026-08-12 01:20:00+00
|
||
14 12 demo@opc {"base_model": "开源", "content_kind": "图像", "is_commercial": "是", "uses_real_face": "是", "training_data_source": "公开爬取"} {"risks": [{"note": "公开爬取 → 需合规审查", "level": "中", "category": "训练数据合规"}], "score": 65, "overall": "中风险"} 65.00 28 2026-08-12 01:22:00+00
|
||
15 14 demo@opc {"industry": "医疗", "open_scope": "合作伙伴", "contains_pii": "是", "dataset_name": "医疗影像 CT", "contains_sensitive": "否"} {"tags": ["个人信息"], "level": "重要", "score": 85} 85.00 16 2026-08-12 01:25:00+00
|
||
16 20 demo@opc {"channels": "律师协会", "project_name": "智审官", "key_resources": "AI 模型", "cost_structure": "算力", "key_activities": "模型迭代", "revenue_streams": "订阅", "key_partnerships": "律所", "customer_segments": "律师事务所", "value_propositions": "智能合同审查"} {"score": 88} 88.00 22 2026-08-12 01:32:00+00
|
||
17 21 demo@opc {"ask": "500 万天使", "problem": "合同审查效率低", "industry": "法律", "solution": "AI 智能审查", "traction": "5 家律所签约", "project_name": "智审官"} {"slide_count": 10} 85.00 26 2026-08-12 01:35:00+00
|
||
18 8 陈墨 {"pi_count": 1500000, "data_type": "个人信息", "pii_sensitive": "是", "import_country": "其他"} {"path": "安全评估", "score": 50} 50.00 22 2026-08-10 09:15:00+00
|
||
19 13 苏婉 {"pii_items": ["手机号", "位置", "人脸"], "company_name": "医言通", "jurisdiction": "中国大陆", "product_name": "医言通", "business_type": "App"} {"score": 85, "sections": 8} 85.00 38 2026-08-10 10:30:00+00
|
||
20 20 林岚 {"project_name": "智审官", "customer_segments": "律所", "value_propositions": "AI 合同审查"} {"score": 88} 88.00 24 2026-08-10 11:00:00+00
|
||
21 19 王砚 {"has_user": "是", "has_company": "是", "has_privacy": "是", "has_revenue": "否", "has_prototype": "是"} {"level": "加速增长期", "score": 85} 85.00 18 2026-08-10 14:20:00+00
|
||
22 16 赵磊 {"tone": "专业可信", "palette": "蓝", "product_name": "数据出境合规 AI"} {"slogans": ["让数据合规成为你的默认选择"]} 92.00 28 2026-08-10 15:30:00+00
|
||
23 11 李娟 {"pi_count": 80000, "data_type": "个人信息", "pii_sensitive": "否", "import_country": "与中国签有数据协议"} {"path": "标准合同", "score": 80} 80.00 19 2026-08-11 09:00:00+00
|
||
24 14 周扬 {"industry": "城市治理", "open_scope": "内部", "contains_pii": "否", "dataset_name": "城市部件数据", "contains_sensitive": "否"} {"level": "一般", "score": 60} 60.00 16 2026-08-11 10:30:00+00
|
||
25 17 Vivian {"rows": 50, "market": 300, "size_gb": 120, "freshness": 3, "asset_name": "政务数据资产"} {"score": 95, "valuation_avg": "¥ 92.5 万元"} 95.00 22 2026-08-11 14:00:00+00
|
||
26 15 Aimee {"ask": "500 万", "problem": "合同审查效率低", "solution": "AI 智能审查", "traction": "5 家律所", "program_name": "法务 SaaS"} {"slide_count": 10} 85.00 32 2026-08-11 15:30:00+00
|
||
27 12 秦岚 {"base_model": "商用授权", "content_kind": "视频", "is_commercial": "是", "uses_real_face": "否", "training_data_source": "授权采购"} {"score": 90, "overall": "低风险"} 90.00 26 2026-08-12 08:00:00+00
|
||
28 13 小于 {"pii_items": ["手机号", "邮箱"], "company_name": "数据中台·小微版", "jurisdiction": "中国大陆", "product_name": "MiniDM", "business_type": "SaaS"} {"score": 88, "sections": 8} 88.00 28 2026-08-12 08:15:00+00
|
||
29 8 杨大头 {"pi_count": 300000, "data_type": "个人信息", "pii_sensitive": "否", "import_country": "其他"} {"path": "标准合同", "score": 75} 75.00 16 2026-08-12 08:30:00+00
|
||
30 16 老郑 {"tone": "极客硬核", "palette": "蓝", "product_name": "智检云"} {"slogans": ["让工业质检成为你的默认选择"]} 90.00 24 2026-08-12 08:42:00+00
|
||
31 18 Aimee {"audience": "投资方", "scenario": "驾驶舱", "dataset_type": "多维交叉"} {"recommendations": [{"type": "分组柱状图", "purpose": "多指标对比"}]} 85.00 16 2026-08-12 08:50:00+00
|
||
32 22 周扬 {"scope": "加工+使用", "source": "自有生产", "processor": "市城管局", "user_type": "政府", "data_title": "城市部件数据"} {"score": 90, "chain_length": 4} 90.00 26 2026-08-12 09:00:00+00
|
||
33 19 周小姐 {"has_user": "否", "has_company": "是", "has_privacy": "否", "has_revenue": "否", "has_prototype": "是", "has_data_inventory": "否"} {"level": "MVP 验证期", "score": 40, "advice": ["⚠️ 立即在产品内发布隐私政策", "⚠️ 建立跨境数据资产清单"]} 40.00 16 2026-07-25 10:00:00+00
|
||
34 13 周小姐 {"pii_items": ["手机号", "邮箱", "位置"], "company_name": "壹心品牌孵化", "jurisdiction": "中国+GDPR", "product_name": "壹心", "business_type": "SaaS"} {"score": 85, "sections": 8} 85.00 36 2026-07-30 14:00:00+00
|
||
35 16 周小姐 {"tone": "年轻活力", "palette": "橙", "keywords": "时尚,功能,内衣", "product_name": "壹心"} {"slogans": ["让 壹心 成为你的默认选择"]} 90.00 22 2026-08-02 16:00:00+00
|
||
36 8 周小姐 {"pi_count": 500000, "data_type": "个人信息", "pii_sensitive": "否", "import_country": "其他"} {"path": "标准合同", "score": 75} 75.00 18 2026-08-08 11:00:00+00
|
||
37 19 易先生 {"has_user": "是", "has_company": "是", "has_privacy": "是", "has_revenue": "是", "has_prototype": "是", "has_data_inventory": "否"} {"level": "加速增长期", "score": 85} 85.00 18 2026-05-15 10:00:00+00
|
||
38 13 易先生 {"pii_items": ["手机号", "身份证"], "company_name": "易法通", "jurisdiction": "中国大陆", "product_name": "易法通律师平台", "business_type": "SaaS"} {"score": 90, "sections": 8} 90.00 32 2026-06-10 14:00:00+00
|
||
39 15 易先生 {"ask": "1000 万天使", "problem": "不良资产处置效率低", "industry": "法律", "solution": "AI 尽调助手", "traction": "3000 万首单", "project_name": "易法通"} {"slide_count": 10} 85.00 28 2026-07-10 11:00:00+00
|
||
40 20 易先生 {"project_name": "易法通", "customer_segments": "银行 AMC 中小微企业", "value_propositions": "AI 尽调 + 全流程处置"} {"score": 88} 88.00 22 2026-07-15 15:00:00+00
|
||
41 12 易先生 {"base_model": "商用授权", "content_kind": "文本", "is_commercial": "是", "uses_real_face": "否", "training_data_source": "授权采购"} {"score": 95, "overall": "低风险"} 95.00 24 2026-08-05 10:00:00+00
|
||
42 19 周小姐 {"has_user": "否", "has_company": "是", "has_privacy": "否", "has_revenue": "否", "has_prototype": "是", "has_data_inventory": "否"} {"level": "MVP 验证期", "score": 40, "advice": ["⚠️ 立即在产品内发布隐私政策", "⚠️ 建立跨境数据资产清单"]} 40.00 16 2026-07-25 10:00:00+00
|
||
43 13 周小姐 {"pii_items": ["手机号", "邮箱", "位置"], "company_name": "壹心品牌孵化", "jurisdiction": "中国+GDPR", "product_name": "壹心", "business_type": "SaaS"} {"score": 85, "sections": 8} 85.00 36 2026-07-30 14:00:00+00
|
||
44 16 周小姐 {"tone": "年轻活力", "palette": "橙", "keywords": "时尚,功能,内衣", "product_name": "壹心"} {"slogans": ["让 壹心 成为你的默认选择"]} 90.00 22 2026-08-02 16:00:00+00
|
||
45 8 周小姐 {"pi_count": 500000, "data_type": "个人信息", "pii_sensitive": "否", "import_country": "其他"} {"path": "标准合同", "score": 75} 75.00 18 2026-08-08 11:00:00+00
|
||
46 19 易先生 {"has_user": "是", "has_company": "是", "has_privacy": "是", "has_revenue": "是", "has_prototype": "是", "has_data_inventory": "否"} {"level": "加速增长期", "score": 85} 85.00 18 2026-05-15 10:00:00+00
|
||
47 13 易先生 {"pii_items": ["手机号", "身份证"], "company_name": "易法通", "jurisdiction": "中国大陆", "product_name": "易法通律师平台", "business_type": "SaaS"} {"score": 90, "sections": 8} 90.00 32 2026-06-10 14:00:00+00
|
||
48 15 易先生 {"ask": "1000 万天使", "problem": "不良资产处置效率低", "industry": "法律", "solution": "AI 尽调助手", "traction": "3000 万首单", "project_name": "易法通"} {"slide_count": 10} 85.00 28 2026-07-10 11:00:00+00
|
||
49 20 易先生 {"project_name": "易法通", "customer_segments": "银行 AMC 中小微企业", "value_propositions": "AI 尽调 + 全流程处置"} {"score": 88} 88.00 22 2026-07-15 15:00:00+00
|
||
50 12 易先生 {"base_model": "商用授权", "content_kind": "文本", "is_commercial": "是", "uses_real_face": "否", "training_data_source": "授权采购"} {"score": 95, "overall": "低风险"} 95.00 24 2026-08-05 10:00:00+00
|
||
51 23 demo@opc {"rows": 3, "category": "lingerie", "platform": "Amazon"} {"rows": 3, "tips": ["建议勾选 '店铺等级' 字段以筛选优质卖家", "高频采集建议开启 '云采集' 模式", "如需 M8C 服务集成可使用八爪鱼 MCP Server"], "score": 92, "engine": "八爪鱼 跨境选品数据采集", "fields": ["商品标题", "价格", "评分"], "sample": [{"id": "Amazon_1191012223_0", "sku": "SKU-10001", "url": "https://www.Amazon.com/dp/REF10000", "price": "$19.99", "title": "lingerie Amazon 第 1 名", "rating": "4.2", "review_count": 200}, {"id": "Amazon_1191012223_1", "sku": "SKU-10002", "url": "https://www.Amazon.com/dp/REF10001", "price": "$25.49", "title": "lingerie Amazon 第 2 名", "rating": "4.4", "review_count": 250}, {"id": "Amazon_1191012223_2", "sku": "SKU-10003", "url": "https://www.Amazon.com/dp/REF10002", "price": "$30.99", "title": "lingerie Amazon 第 3 名", "rating": "4.6", "review_count": 300}], "category": "lingerie", "platform": "Amazon", "collected": 3, "compliance": "公开数据采集 · 符合 PIPL + GDPR 公开数据范围", "export_url": "https://www.bazhuayu.com/opc/export/Amazon_lingerie.xlsx", "duration_min": 0.03} 92.00 0 2026-08-12 01:23:47.839811+00
|
||
52 23 demo@opc {"rows": 3, "fields": ["商品标题", "价格", "评分"], "category": "lingerie", "platform": "Amazon"} {"rows": 3, "tips": ["建议勾选 '店铺等级' 字段以筛选优质卖家", "高频采集建议开启 '云采集' 模式", "如需 M8C 服务集成可使用八爪鱼 MCP Server"], "score": 92, "engine": "八爪鱼 跨境选品数据采集", "fields": ["商品标题", "价格", "评分"], "sample": [{"id": "Amazon_1191012223_0", "sku": "SKU-10001", "url": "https://www.Amazon.com/dp/REF10000", "price": "$19.99", "title": "lingerie Amazon 第 1 名", "rating": "4.2", "review_count": 200}, {"id": "Amazon_1191012223_1", "sku": "SKU-10002", "url": "https://www.Amazon.com/dp/REF10001", "price": "$25.49", "title": "lingerie Amazon 第 2 名", "rating": "4.4", "review_count": 250}, {"id": "Amazon_1191012223_2", "sku": "SKU-10003", "url": "https://www.Amazon.com/dp/REF10002", "price": "$30.99", "title": "lingerie Amazon 第 3 名", "rating": "4.6", "review_count": 300}], "category": "lingerie", "platform": "Amazon", "collected": 3, "compliance": "公开数据采集 · 符合 PIPL + GDPR 公开数据范围", "export_url": "https://www.bazhuayu.com/opc/export/Amazon_lingerie.xlsx", "duration_min": 0.03} 92.00 0 2026-08-12 01:24:54.051447+00
|
||
53 27 demo@opc {"question": "我是欧美中高端内衣品牌,应该怎么找美国本土分销商?", "scenario": "外贸获客"} {"score": 90, "action": "可一键导出《行动方案》", "answer": "基于 9Xin 全球商贸行业 AI 模型(嘉兴唯一入选工信部典型案例):\\n1. 用八爪鱼采集目标市场 KOL / 经销商公开信息\\n2. 通过 9Xin 内贸外贸一体化模型识别匹配度\\n3. 自动生成多语种邮件 + WhatsApp 跟进话术\\n4. RPA 自动化投递 + 状态追踪", "engine": "九鑫智能 9Xin 行业 AI 助手", "scenario": "外贸获客", "integrated": ["八爪鱼跨境数据采集", "九鑫 RPA 自动化", "尚数网 OPC 平台"], "references": ["9Xin 全球商贸行业 AI 模型", "工信部《人工智能赋能新型工业化典型应用案例》", "嘉兴市唯一入选项目"]} 90.00 0 2026-08-12 01:24:54.118096+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: tools; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.tools (id, name, category, description, version, homepage, free_quota, status, created_at, domain, template) FROM stdin;
|
||
1 OPC 低代码智能体平台 平台 面向 OPC 团队的智能体搭建平台,支持多模型路由、知识库、工作流 v2.4 https://shangshuwang.cn/opc/agent 首年免费 available 2026-08-11 15:18:16.525546+00 platform \N
|
||
2 数据沙盒 数据处理 可信数据开发环境,支持脱敏、动态授权、留痕 v1.8 https://shangshuwang.cn/opc/sandbox 100GB 免费额度 available 2026-08-11 15:18:16.525546+00 platform \N
|
||
3 多模态模型微调套件 模型 基于开源基座的行业模型微调套件 v1.2 https://shangshuwang.cn/opc/fine-tune 50 万 tokens 免费 available 2026-08-11 15:18:16.525546+00 platform \N
|
||
4 RAG 检索增强组件 低代码 支持 12 种向量库与混合检索策略 v3.0 https://shangshuwang.cn/opc/rag 永久免费 available 2026-08-11 15:18:16.525546+00 platform \N
|
||
5 合规审查 API 接口 基于规则+模型的数据合规审查接口 v1.5 https://shangshuwang.cn/opc/compliance 1000 次/天 免费 available 2026-08-11 15:18:16.525546+00 platform \N
|
||
6 场景模拟实验室 平台 城市治理/产业协同场景仿真平台 v0.9 https://shangshuwang.cn/opc/simlab 封闭测试 beta 2026-08-11 15:18:16.525546+00 platform \N
|
||
7 语音合成行业模型 模型 政务、金融客服场景语音合成 v2.0 https://shangshuwang.cn/opc/tts 即将上线 coming 2026-08-11 15:18:16.525546+00 platform \N
|
||
8 数据出境合规自检 合规 《数据出境安全评估办法》《标准合同办法》三条路径自动匹配:处理 100 万+个人信息 / 重要数据 / 跨境传输 → 评估 / 标准合同 / 认证 v2.0 #/tool/cross-border-check 不限次数 available 2026-08-11 15:35:18.618098+00 cross-border {"engine": "cross_border_check", "fields": [{"key": "data_type", "type": "select", "label": "数据主体类型", "options": ["个人信息", "重要数据", "一般数据"]}, {"key": "pi_count", "type": "number", "label": "个人信息主体数(人)"}, {"key": "import_country", "type": "select", "label": "接收方所在国家/地区", "options": ["非跨境", "与中国签有数据协议", "其他"]}, {"key": "cumulative", "type": "select", "label": "是否曾向境外提供", "options": ["是", "否"]}, {"key": "pii_sensitive", "type": "select", "label": "是否含敏感个人信息", "options": ["是", "否"]}]}
|
||
9 数据分类分级助手 合规 依据 GB/T 35273、GB/T 38667 等标准,自动识别资产敏感等级(核心/重要/一般),输出《数据分类分级清单》 v1.5 #/tool/data-classify 不限次数 available 2026-08-11 15:35:18.618098+00 cross-border {"engine": "data_classify", "fields": [{"key": "dataset_name", "type": "text", "label": "数据集名称"}, {"key": "industry", "type": "select", "label": "所属行业", "options": ["金融", "医疗", "政务", "制造", "文娱", "其他"]}, {"key": "contains_pii", "type": "select", "label": "是否含个人信息", "options": ["是", "否"]}, {"key": "contains_sensitive", "type": "select", "label": "是否含敏感信息", "options": ["是", "否"]}, {"key": "open_scope", "type": "select", "label": "对外开放范围", "options": ["内部", "合作伙伴", "公开发布"]}]}
|
||
10 数据资产价值评估 数据资产 基于成本法/市场法/收益法,给出数据资产估值区间与登记建议 v1.0 #/tool/data-valuation 50 次/月 available 2026-08-11 15:35:18.618098+00 cross-border {"engine": "data_valuation", "fields": [{"key": "asset_name", "type": "text", "label": "数据资产名称"}, {"key": "size_gb", "type": "number", "label": "数据规模(GB)"}, {"key": "rows", "type": "number", "label": "记录数(万)"}, {"key": "market", "type": "number", "label": "可交易市场规模(万元)"}, {"key": "freshness", "type": "number", "label": "数据新鲜度(月)"}]}
|
||
11 跨境数据合规顾问 AI 顾问 面向跨境数据业务的 AI 顾问:覆盖 PIPL / GDPR / 区域数据协议,可问答式生成合规草案 v0.9 #/tool/cross-border-ai 20 次/天 beta 2026-08-11 15:35:18.618098+00 cross-border {"engine": "qa_advisor", "fields": [{"key": "question", "type": "textarea", "label": "提问内容", "placeholder": "例如:我是 SaaS 公司,要把中国客户数据镜像到新加坡机房,应该怎么走?"}]}
|
||
12 AIGC 合规审查 合规 对 AIGC 生成内容做合规自检:著作权 / 肖像权 / 隐私 / 偏见 / 深度伪造五维扫描 v1.2 #/tool/aigc-check 不限次数 available 2026-08-11 15:35:18.618098+00 legal {"engine": "aigc_check", "fields": [{"key": "content_kind", "type": "select", "label": "内容类型", "options": ["图像", "视频", "文本", "音频"]}, {"key": "uses_real_face", "type": "select", "label": "是否含真实人脸", "options": ["是", "否"]}, {"key": "is_commercial", "type": "select", "label": "是否商用", "options": ["是", "否"]}, {"key": "base_model", "type": "select", "label": "基模型来源", "options": ["开源", "商用授权", "自研", "未明确"]}, {"key": "training_data_source", "type": "select", "label": "训练数据来源", "options": ["自有", "公开爬取", "授权采购", "未明确"]}]}
|
||
13 隐私政策生成器 生成器 一键生成符合《个人信息保护法》《App 隐私合规》的隐私政策 / 用户协议 + Cookie 声明 v3.0 #/tool/privacy-generator 不限次数 available 2026-08-11 15:35:18.618098+00 legal {"engine": "privacy_generator", "fields": [{"key": "company_name", "type": "text", "label": "公司/产品名称"}, {"key": "product_name", "type": "text", "label": "产品名称"}, {"key": "business_type", "type": "select", "label": "业务类型", "options": ["SaaS", "App", "小程序", "网站", "智能硬件"]}, {"key": "pii_items", "type": "multiselect", "label": "收集的个人信息(多选)", "options": ["手机号", "邮箱", "身份证", "位置", "通讯录", "人脸", "指纹", "行为日志"]}, {"key": "jurisdiction", "type": "select", "label": "适用法律", "options": ["中国大陆", "中国+GDPR", "中国+CCPA", "全球多法域"]}]}
|
||
14 数据授权链路生成器 生成器 上传数据资源 → 自动生成「数据来源 → 加工 → 授权 → 流通」全链路授权文件 v1.0 #/tool/license-chain 30 次/月 available 2026-08-11 15:35:18.618098+00 legal {"engine": "license_chain", "fields": [{"key": "data_title", "type": "text", "label": "数据资源名称"}, {"key": "source", "type": "select", "label": "数据来源", "options": ["自有生产", "公开爬取", "采购授权", "多方联合"]}, {"key": "processor", "type": "text", "label": "加工方"}, {"key": "user_type", "type": "select", "label": "使用方", "options": ["政府", "科研", "企业", "个人"]}, {"key": "scope", "type": "select", "label": "授权范围", "options": ["仅查阅", "加工+使用", "转授权", "其他"]}]}
|
||
15 法律咨询 AI 助手 AI 顾问 面向 OPC 团队的法律咨询 AI:股权 / 合同 / 知识产权 / 劳动 / 税务 v0.8 #/tool/legal-ai 20 次/天 beta 2026-08-11 15:35:18.618098+00 legal {"engine": "qa_advisor", "fields": [{"key": "topic", "type": "select", "label": "法律问题方向", "options": ["股权架构", "劳动用工", "合同条款", "知识产权", "税务合规", "数据合规"]}, {"key": "question", "type": "textarea", "label": "具体问题"}]}
|
||
16 Logo + Slogan 生成器 生成器 一键生成主视觉 Logo 思路 + Slogan + 色彩 + 字体推荐 v1.0 #/tool/brand-generator 不限次数 available 2026-08-11 15:35:18.618098+00 design {"engine": "brand_generator", "fields": [{"key": "product_name", "type": "text", "label": "产品名"}, {"key": "tone", "type": "select", "label": "品牌调性", "options": ["专业可信", "年轻活力", "高端商务", "极客硬核"]}, {"key": "keywords", "type": "text", "label": "关键关键词(英文逗号)"}, {"key": "palette", "type": "select", "label": "主色调偏好", "options": ["蓝", "绿", "紫", "橙", "黑白"]}]}
|
||
17 数据可视化模板生成 生成器 OPC 团队常用的 8 类数据看板模板(KPI / 趋势 / 漏斗 / 地理 / 桑基 / 雷达)直接套用 v2.0 #/tool/datav-template 不限次数 available 2026-08-11 15:35:18.618098+00 design {"engine": "chart_template", "fields": [{"key": "scenario", "type": "select", "label": "应用场景", "options": ["驾驶舱", "项目月报", "投资人 demo", "政策申报"]}, {"key": "dataset_type", "type": "select", "label": "数据类型", "options": ["指标型", "时间序列", "结构化表格", "多维交叉"]}, {"key": "audience", "type": "select", "label": "受众", "options": ["内部", "政府", "投资方", "客户"]}]}
|
||
18 数据产品封面生成 生成器 数据产品上架 / 数据登记 / 数据节海报封面,10 套高质量模板一键套用 v1.0 #/tool/data-cover 50 次/月 available 2026-08-11 15:35:18.618098+00 design {"engine": "cover_generator", "fields": [{"key": "title", "type": "text", "label": "封面标题"}, {"key": "subtitle", "type": "text", "label": "副标题"}, {"key": "theme", "type": "select", "label": "主题色", "options": ["蓝紫", "墨绿", "橙红", "黑白灰"]}, {"key": "aspect_ratio", "type": "select", "label": "比例", "options": ["16:9", "1:1", "9:16", "A4"]}]}
|
||
19 商业模式画布 战略 9 宫格画布:CSU / VP / CR / CH / KR / KA / KP / Cost / Revenue,一键生成结构化画布 v2.0 #/tool/bmc 不限次数 available 2026-08-11 15:35:18.618098+00 general {"engine": "bmc", "fields": [{"key": "project_name", "type": "text", "label": "项目名"}, {"key": "customer_segments", "type": "textarea", "label": "客户细分(CS)"}, {"key": "value_propositions", "type": "textarea", "label": "价值主张(VP)"}, {"key": "channels", "type": "textarea", "label": "渠道通路(CH)"}, {"key": "customer_relationships", "type": "textarea", "label": "客户关系(CR)"}, {"key": "revenue_streams", "type": "textarea", "label": "收入来源(R$)"}, {"key": "key_resources", "type": "textarea", "label": "核心资源(KR)"}, {"key": "key_activities", "type": "textarea", "label": "关键活动(KA)"}, {"key": "key_partnerships", "type": "textarea", "label": "重要伙伴(KP)"}, {"key": "cost_structure", "type": "textarea", "label": "成本结构(C$)"}]}
|
||
20 BP 商业计划书生成器 生成器 围绕问题/方案/市场/团队/财务五大要素,自动生成投资人 BP 大纲 v1.0 #/tool/bp-generator 30 次/月 available 2026-08-11 15:35:18.618098+00 general {"engine": "bp_generator", "fields": [{"key": "project_name", "type": "text", "label": "项目名"}, {"key": "industry", "type": "text", "label": "行业"}, {"key": "problem", "type": "textarea", "label": "解决的痛点"}, {"key": "solution", "type": "textarea", "label": "解决方案"}, {"key": "traction", "type": "textarea", "label": "目前进展"}, {"key": "ask", "type": "text", "label": "融资需求(如有)"}]}
|
||
21 创业自检清单 诊断 21 道题覆盖数据合规 / 公司治理 / 财税 / 团队 / 产品,输出 OPC 成熟度评分与改进建议 v2.0 #/tool/opc-check 不限次数 available 2026-08-11 15:35:18.618098+00 general {"engine": "opc_check", "fields": [{"key": "has_company", "type": "select", "label": "已完成工商注册", "options": ["是", "否"]}, {"key": "has_privacy", "type": "select", "label": "已发布隐私政策", "options": ["是", "否"]}, {"key": "has_data_inventory", "type": "select", "label": "已建立数据资产清单", "options": ["是", "否"]}, {"key": "has_prototype", "type": "select", "label": "已有产品原型", "options": ["是", "否"]}, {"key": "has_user", "type": "select", "label": "已有种子用户", "options": ["是", "否"]}, {"key": "has_revenue", "type": "select", "label": "已有收入", "options": ["是", "否"]}]}
|
||
22 AI 创业问答 AI 顾问 OPC 创业通用 AI 问答:商业模式、融资、客户、技术栈、团队组建 v1.0 #/tool/opc-ai 50 次/天 available 2026-08-11 15:35:18.618098+00 general {"engine": "qa_advisor", "fields": [{"key": "question", "type": "textarea", "label": "你的问题"}]}
|
||
23 跨境选品数据采集 数据采集 基于八爪鱼 450 万+ 用户的 5000 台云采集节点,跨境电商 SKU / 评论 / 价格实时采集 v2.0 https://www.bazhuayu.com/opc 1000 条免费 available 2026-08-12 01:19:56.043613+00 cross-border {"engine": "bazhuayu_crossborder", "fields": [{"key": "platform", "type": "select", "label": "目标平台", "options": ["Amazon", "Etsy", "Shopify", "eBay", "独立站", "TikTok Shop"]}, {"key": "category", "type": "text", "label": "商品类目", "placeholder": "如:lingerie / sports bra / shapewear"}, {"key": "rows", "type": "number", "label": "采集条数"}, {"key": "fields", "type": "multiselect", "label": "采集字段", "options": ["商品标题", "价格", "库存", "评论数", "评分", "图片", "SKU", "店铺等级"]}]}
|
||
24 招投标信息聚合 数据采集 八爪鱼 300+ 招投标模板:政府采购、央企、国企招标实时监控 v1.5 https://www.bazhuayu.com/opc 不限次数 available 2026-08-12 01:19:56.043613+00 general {"engine": "bazhuayu_tender", "fields": [{"key": "keyword", "type": "text", "label": "关键词", "placeholder": "如:AI 模型 / 隐私计算 / 政务数据"}, {"key": "region", "type": "select", "label": "区域", "options": ["全国", "北京", "上海", "深圳", "广州", "杭州", "成都", "武汉", "其他"]}, {"key": "days", "type": "number", "label": "回溯天数"}]}
|
||
25 竞品价格监控 数据采集 八爪鱼 RPA AI 写流程 3.0:实时监控竞品价格波动,支持预警推送 v1.0 https://www.bazhuayu.com/opc/rpa 50 SKU 免费 available 2026-08-12 01:19:56.043613+00 general {"engine": "bazhuayu_price", "fields": [{"key": "target_urls", "type": "text", "label": "监控链接(英文逗号)"}, {"key": "frequency", "type": "select", "label": "监控频率", "options": ["每 1 小时", "每 6 小时", "每天", "每周"]}, {"key": "alert_threshold", "type": "number", "label": "价格波动阈值 (%)"}]}
|
||
26 电商全流程 RPA RPA 九鑫智能超级自动化:订单 / 库存 / 客服 / 财务系统端到端自动化 v2.0 https://9xinai.com/opc 1000 流程免费 available 2026-08-12 01:19:56.043613+00 general {"engine": "jiuxin_rpa", "fields": [{"key": "scenario", "type": "select", "label": "场景", "options": ["订单同步", "库存监控", "客服自动回复", "财务对账", "多平台铺货", "自动退款"]}, {"key": "platforms", "type": "multiselect", "label": "覆盖平台", "options": ["淘宝", "京东", "拼多多", "抖音", "Shopify", "Amazon", "Lazada", "Shein"]}, {"key": "volume", "type": "number", "label": "日处理量"}]}
|
||
27 9Xin 行业 AI 助手 AI 助手 九鑫智能 9Xin 全球商贸行业 AI 模型(嘉兴唯一入选工信部典型案例):外贸获客 / 内外贸一体化 v1.0 https://9xinai.com/9xin 20 次/天 available 2026-08-12 01:19:56.043613+00 cross-border {"engine": "jiuxin_9xin", "fields": [{"key": "scenario", "type": "select", "label": "场景", "options": ["外贸获客", "内外贸一体化", "市场分析", "合规咨询", "客户画像"]}, {"key": "question", "type": "textarea", "label": "提问", "placeholder": "例如:我是欧美中高端内衣品牌,应该怎么找美国本土分销商?"}]}
|
||
28 商业智能分析 BI 九鑫智能商业智能:企业数据深度挖掘 + 风险预警 + 决策辅助 v1.0 https://9xinai.com/opc/bi 50 次/月 available 2026-08-12 01:19:56.043613+00 general {"engine": "jiuxin_bi", "fields": [{"key": "industry", "type": "select", "label": "行业", "options": ["跨境电商", "法律服务", "不良资产", "制造业", "金融", "医疗", "文娱", "其他"]}, {"key": "data_source", "type": "select", "label": "数据源", "options": ["业务系统", "ERP / WMS", "公开数据", "社交媒体", "电商平台", "其他"]}, {"key": "concern", "type": "textarea", "label": "关注指标", "placeholder": "如:客户复购率、获客成本、库存周转率"}]}
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: trainings; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.trainings (id, cohort_id, title, topic, speaker, speaker_org, train_date, location, attendees, format, summary, created_at) FROM stdin;
|
||
1 1 OPC 数据合规第一课 数据合规 林岚 尚数网法务研究院 2026-03-08 北京·中关村 28 hybrid 数据权属、授权边界、隐私保护实操 2026-08-11 15:18:16.530638+00
|
||
2 1 行业模型微调实战 模型训练 陈哲 清华 AI 研究院 2026-03-15 北京·中关村 26 offline 基于开源基座的行业模型微调流程 2026-08-11 15:18:16.530638+00
|
||
3 1 低代码智能体搭建 低代码 苏婉 尚数网平台 2026-03-22 线上 30 online 智能体平台 30 分钟搭建工作流 2026-08-11 15:18:16.530638+00
|
||
4 1 商业模式画布 商业模式 王砚 极客公园 2026-03-29 北京·中关村 24 offline 从场景到收入的商业模式闭环 2026-08-11 15:18:16.530638+00
|
||
5 2 Agent 评估与回归 模型训练 Bryan OSS 社区 2026-06-10 上海·杨浦 22 online 智能体评估指标体系与回归策略 2026-08-11 15:18:16.530638+00
|
||
6 2 Agent 商业化定价 商业模式 Vivian 一线 Agent 公司 2026-06-18 上海·杨浦 20 offline 订阅 / 调用 / 解决方案三种定价模型 2026-08-11 15:18:16.530638+00
|
||
7 2 Agent 场景适配 场景适配 周扬 某市级政务 2026-06-25 线上 25 hybrid 政务场景 Agent 适配要点 2026-08-11 15:18:16.530638+00
|
||
8 1 数据合规深度研讨 数据合规 林岚 尚数网法务研究院 2026-04-05 北京·中关村 18 offline 参训项目一对一合规答疑 2026-08-11 15:18:16.530638+00
|
||
9 5 PIPL 第 38 条深度解读 数据合规 林岚 尚数网法务研究院 2026-04-20 北京·中关村 30 hybrid PIPL 第 38 条跨境数据条款深度解读 2026-08-12 00:50:21.781806+00
|
||
10 5 数据资产入表操作实务 数据合规 Vivian Z. 数据交易所 2026-04-27 上海·杨浦 28 offline 财政部 8 号文 + 数据资产入表 5 步走 2026-08-12 00:50:21.781806+00
|
||
11 5 GDPR vs PIPL 实操对比 数据合规 赵磊 某律师事务所 2026-05-08 线上 25 online GDPR 与 PIPL 在数据出境、用户权利、罚则上的实操对比 2026-08-12 00:50:21.781806+00
|
||
12 5 东南亚数据合规地图 数据合规 李娟 东南亚法律服务团队 2026-05-15 深圳·南山 22 hybrid 新加坡 / 越南 / 印尼 / 泰国数据合规 2026-08-12 00:50:21.781806+00
|
||
13 6 智能体评估方法论 模型训练 Bryan OSS 社区 2026-07-08 上海·杨浦 28 hybrid 智能体任务级 / 能力级 / 元级评估 2026-08-12 00:50:21.781806+00
|
||
14 6 RAG 检索召回优化 模型训练 陈哲 清华 AI 研究院 2026-07-15 上海·杨浦 26 offline RAG 召回率提升 30% 的实战 2026-08-12 00:50:21.781806+00
|
||
15 6 Agent 工作流编排 低代码 苏婉 尚数网 2026-07-22 线上 30 online Agent Workflow 编排最佳实践 2026-08-12 00:50:21.781806+00
|
||
16 6 Agent 商业化定价策略 商业模式 Vivian 一线 AI 公司 2026-07-29 上海·杨浦 24 offline 订阅 / 调用 / 解决方案三种定价 2026-08-12 00:50:21.781806+00
|
||
17 6 Agent 评测数据策略 模型训练 Bryan OSS 社区 2026-08-05 线上 22 online 评测数据应该是产品资产 2026-08-12 00:50:21.781806+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: -
|
||
--
|
||
|
||
COPY public.users (id, username, password, name, role, phone, email, created_at) FROM stdin;
|
||
1 admin admin123 系统管理员 admin 13800000000 admin@shangshuwang.cn 2026-08-11 15:18:16.585375+00
|
||
2 linlan linlan123 林岚 mentor 13800000001 linlan@shangshuwang.cn 2026-08-11 15:18:16.585375+00
|
||
3 opc01 opc123 陈墨 opc 13800000001 chenmo@zhicheng.com 2026-08-11 15:18:16.585375+00
|
||
4 opc02 opc123 王砚 opc 13800000003 wangyan@dazhangfang.com 2026-08-11 15:18:16.585375+00
|
||
\.
|
||
|
||
|
||
--
|
||
-- Name: announcements_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.announcements_id_seq', 13, true);
|
||
|
||
|
||
--
|
||
-- Name: coachings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.coachings_id_seq', 39, true);
|
||
|
||
|
||
--
|
||
-- Name: cohorts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.cohorts_id_seq', 10, true);
|
||
|
||
|
||
--
|
||
-- Name: compliance_logs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.compliance_logs_id_seq', 28, true);
|
||
|
||
|
||
--
|
||
-- Name: data_resources_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.data_resources_id_seq', 19, true);
|
||
|
||
|
||
--
|
||
-- Name: events_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.events_id_seq', 12, true);
|
||
|
||
|
||
--
|
||
-- Name: kpi_snapshots_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.kpi_snapshots_id_seq', 21, true);
|
||
|
||
|
||
--
|
||
-- Name: mentors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.mentors_id_seq', 6, true);
|
||
|
||
|
||
--
|
||
-- Name: milestones_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.milestones_id_seq', 45, true);
|
||
|
||
|
||
--
|
||
-- Name: news_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.news_id_seq', 22, true);
|
||
|
||
|
||
--
|
||
-- Name: partners_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.partners_id_seq', 2, true);
|
||
|
||
|
||
--
|
||
-- Name: policies_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.policies_id_seq', 14, true);
|
||
|
||
|
||
--
|
||
-- Name: policy_applications_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.policy_applications_id_seq', 23, true);
|
||
|
||
|
||
--
|
||
-- Name: products_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.products_id_seq', 32, true);
|
||
|
||
|
||
--
|
||
-- Name: projects_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.projects_id_seq', 29, true);
|
||
|
||
|
||
--
|
||
-- Name: scenario_mappings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.scenario_mappings_id_seq', 28, true);
|
||
|
||
|
||
--
|
||
-- Name: scenarios_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.scenarios_id_seq', 18, true);
|
||
|
||
|
||
--
|
||
-- Name: spaces_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.spaces_id_seq', 13, true);
|
||
|
||
|
||
--
|
||
-- Name: team_members_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.team_members_id_seq', 42, true);
|
||
|
||
|
||
--
|
||
-- Name: tool_runs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.tool_runs_id_seq', 53, true);
|
||
|
||
|
||
--
|
||
-- Name: tools_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.tools_id_seq', 28, true);
|
||
|
||
|
||
--
|
||
-- Name: trainings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.trainings_id_seq', 17, true);
|
||
|
||
|
||
--
|
||
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
|
||
--
|
||
|
||
SELECT pg_catalog.setval('public.users_id_seq', 4, true);
|
||
|
||
|
||
--
|
||
-- Name: announcements announcements_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.announcements
|
||
ADD CONSTRAINT announcements_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: coachings coachings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.coachings
|
||
ADD CONSTRAINT coachings_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: cohorts cohorts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.cohorts
|
||
ADD CONSTRAINT cohorts_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: compliance_logs compliance_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.compliance_logs
|
||
ADD CONSTRAINT compliance_logs_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: data_resources data_resources_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.data_resources
|
||
ADD CONSTRAINT data_resources_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: events events_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.events
|
||
ADD CONSTRAINT events_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: kpi_snapshots kpi_snapshots_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.kpi_snapshots
|
||
ADD CONSTRAINT kpi_snapshots_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: mentors mentors_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.mentors
|
||
ADD CONSTRAINT mentors_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: milestones milestones_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.milestones
|
||
ADD CONSTRAINT milestones_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: news news_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.news
|
||
ADD CONSTRAINT news_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: partners partners_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.partners
|
||
ADD CONSTRAINT partners_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: policies policies_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.policies
|
||
ADD CONSTRAINT policies_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: policy_applications policy_applications_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.policy_applications
|
||
ADD CONSTRAINT policy_applications_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: products products_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.products
|
||
ADD CONSTRAINT products_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: projects projects_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.projects
|
||
ADD CONSTRAINT projects_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: projects projects_slug_key; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.projects
|
||
ADD CONSTRAINT projects_slug_key UNIQUE (slug);
|
||
|
||
|
||
--
|
||
-- Name: scenario_mappings scenario_mappings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.scenario_mappings
|
||
ADD CONSTRAINT scenario_mappings_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: scenario_mappings scenario_mappings_project_id_scenario_id_key; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.scenario_mappings
|
||
ADD CONSTRAINT scenario_mappings_project_id_scenario_id_key UNIQUE (project_id, scenario_id);
|
||
|
||
|
||
--
|
||
-- Name: scenarios scenarios_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.scenarios
|
||
ADD CONSTRAINT scenarios_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: spaces spaces_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.spaces
|
||
ADD CONSTRAINT spaces_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: team_members team_members_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.team_members
|
||
ADD CONSTRAINT team_members_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: tool_runs tool_runs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.tool_runs
|
||
ADD CONSTRAINT tool_runs_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: tools tools_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.tools
|
||
ADD CONSTRAINT tools_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: trainings trainings_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.trainings
|
||
ADD CONSTRAINT trainings_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.users
|
||
ADD CONSTRAINT users_pkey PRIMARY KEY (id);
|
||
|
||
|
||
--
|
||
-- Name: users users_username_key; Type: CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.users
|
||
ADD CONSTRAINT users_username_key UNIQUE (username);
|
||
|
||
|
||
--
|
||
-- Name: idx_data_resources_category; Type: INDEX; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE INDEX idx_data_resources_category ON public.data_resources USING btree (category);
|
||
|
||
|
||
--
|
||
-- Name: idx_kpi_snapshots_date; Type: INDEX; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE INDEX idx_kpi_snapshots_date ON public.kpi_snapshots USING btree (snap_date);
|
||
|
||
|
||
--
|
||
-- Name: idx_projects_direction; Type: INDEX; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE INDEX idx_projects_direction ON public.projects USING btree (direction);
|
||
|
||
|
||
--
|
||
-- Name: idx_projects_stage; Type: INDEX; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE INDEX idx_projects_stage ON public.projects USING btree (stage);
|
||
|
||
|
||
--
|
||
-- Name: idx_team_members_project; Type: INDEX; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE INDEX idx_team_members_project ON public.team_members USING btree (project_id);
|
||
|
||
|
||
--
|
||
-- Name: idx_tool_runs_created; Type: INDEX; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE INDEX idx_tool_runs_created ON public.tool_runs USING btree (created_at DESC);
|
||
|
||
|
||
--
|
||
-- Name: idx_tool_runs_tool; Type: INDEX; Schema: public; Owner: -
|
||
--
|
||
|
||
CREATE INDEX idx_tool_runs_tool ON public.tool_runs USING btree (tool_id);
|
||
|
||
|
||
--
|
||
-- Name: coachings coachings_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.coachings
|
||
ADD CONSTRAINT coachings_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
|
||
|
||
|
||
--
|
||
-- Name: compliance_logs compliance_logs_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.compliance_logs
|
||
ADD CONSTRAINT compliance_logs_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE SET NULL;
|
||
|
||
|
||
--
|
||
-- Name: compliance_logs compliance_logs_resource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.compliance_logs
|
||
ADD CONSTRAINT compliance_logs_resource_id_fkey FOREIGN KEY (resource_id) REFERENCES public.data_resources(id) ON DELETE SET NULL;
|
||
|
||
|
||
--
|
||
-- Name: milestones milestones_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.milestones
|
||
ADD CONSTRAINT milestones_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
|
||
|
||
|
||
--
|
||
-- Name: policy_applications policy_applications_policy_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.policy_applications
|
||
ADD CONSTRAINT policy_applications_policy_id_fkey FOREIGN KEY (policy_id) REFERENCES public.policies(id) ON DELETE CASCADE;
|
||
|
||
|
||
--
|
||
-- Name: policy_applications policy_applications_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.policy_applications
|
||
ADD CONSTRAINT policy_applications_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
|
||
|
||
|
||
--
|
||
-- Name: products products_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.products
|
||
ADD CONSTRAINT products_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
|
||
|
||
|
||
--
|
||
-- Name: scenario_mappings scenario_mappings_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.scenario_mappings
|
||
ADD CONSTRAINT scenario_mappings_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
|
||
|
||
|
||
--
|
||
-- Name: scenario_mappings scenario_mappings_scenario_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.scenario_mappings
|
||
ADD CONSTRAINT scenario_mappings_scenario_id_fkey FOREIGN KEY (scenario_id) REFERENCES public.scenarios(id) ON DELETE CASCADE;
|
||
|
||
|
||
--
|
||
-- Name: team_members team_members_project_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.team_members
|
||
ADD CONSTRAINT team_members_project_id_fkey FOREIGN KEY (project_id) REFERENCES public.projects(id) ON DELETE CASCADE;
|
||
|
||
|
||
--
|
||
-- Name: trainings trainings_cohort_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
||
--
|
||
|
||
ALTER TABLE ONLY public.trainings
|
||
ADD CONSTRAINT trainings_cohort_id_fkey FOREIGN KEY (cohort_id) REFERENCES public.cohorts(id) ON DELETE SET NULL;
|
||
|
||
|
||
--
|
||
-- PostgreSQL database dump complete
|
||
--
|
||
|
||
\unrestrict 0tjN1wfDpIxsfRbT4CdUTaSTVGi5StRuuWf7VhXTrIfjj6sIXObAW6eRep4DjlV
|
||
|