--简单来说,这个表设计用于存储测试数据,其中每条记录都有一个唯一的 id 标识符,该标识符自动递
--增,无需手动指定。
--创建一个从 1 开始,每次递增 1 的序列,没有设置最小值和最大值,并且缓存了 1 个值以提高性能。
CREATE SEQUENCE public.ats_testdata_raw1_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
--建表
CREATE TABLE public.ats_testdata_raw (
id bigint NOT NULL DEFAULT nextval('ats_testdata_raw1_id_seq'::regclass), --自增id
test_key varchar(512) NOT NULL,
line_name varchar(128) NOT NULL,
model_name varchar(64) NOT NULL,
mono varchar(64) NULL,
product_category varchar(128) NULL,
test_station varchar(64) NULL,
station_name varchar(64) NULL,
equipment_code varchar(128) NULL,
pallet varchar(128) NULL,
sn varchar(64) NOT NULL,
test_start_time timestamptz NULL,
test_end_time timestamptz NOT NULL DEFAULT now(),
test_result varchar(32) NOT NULL,
rework_result varchar(32) NULL,
rule_result varchar(32) NULL,
data_source varchar(128) NULL,
tester_id varchar(128) NULL,
fixture_id varchar(128) NULL,
op_id varchar(128) NULL,
tp_name varchar(128) NULL,
pc_name varchar(64) NULL,
param_num int8 NULL,
param_value jsonb NULL,
param_fail jsonb NULL,
reason varchar NULL,
createdate timestamptz NOT NULL DEFAULT now(),
updatedate timestamptz NOT NULL DEFAULT now(),
is_active bool NOT NULL DEFAULT true,
is_golden bool NOT NULL DEFAULT false,
is_check bool NULL DEFAULT false,
is_process bool NULL DEFAULT false,
CONSTRAINT ats_testdata_raw_pk PRIMARY KEY (id),
CONSTRAINT ats_testdata_raw_test_key UNIQUE (test_key),
CONSTRAINT ats_testdata_raw_test_result_check CHECK (((test_result)::text = ANY (ARRAY['PASS'::text, 'FAIL'::text]))),
CONSTRAINT ats_testdata_raw_test_result_ck CHECK (((test_result)::text = ANY (ARRAY['PASS'::text, 'FAIL'::text])))
);
CREATE INDEX ats_testdata_raw_idx_raw_is_active_test_end_time ON public.ats_testdata_raw USING btree (is_active, test_end_time);
CREATE INDEX ats_testdata_raw_idx_raw_line_model_station_time ON public.ats_testdata_raw USING btree (line_name, model_name, test_station, test_end_time);
CREATE INDEX ats_testdata_raw_idx_raw_line_model_test_end_time ON public.ats_testdata_raw USING btree (line_name, model_name, test_end_time);
CREATE INDEX ats_testdata_raw_idx_raw_sn ON public.ats_testdata_raw USING btree (sn);
CREATE INDEX ats_testdata_raw_idx_raw_test_station_test_end_time ON public.ats_testdata_raw USING btree (test_station, test_end_time);
06-01
546
