CREATE TABLE "aggregate_data"."alarm_data_all" (

  "id" int4 NOT NULL DEFAULT nextval('"aggregate_data".auto_id_seq'::regclass),

  "sid" varchar(32) COLLATE "pg_catalog"."default",

  "open_time" timestamp(0),

  "close_time" timestamp(0),

  "create_time" timestamp(0),

  "spec_code" varchar(32) COLLATE "pg_catalog"."default",

  "related_area_code" varchar(32) COLLATE "pg_catalog"."default",

  "user_label" varchar(256) COLLATE "pg_catalog"."default",

  "summary" varchar(512) COLLATE "pg_catalog"."default",

  "eqp_name" varchar(256) COLLATE "pg_catalog"."default",

  "eqp_spoffice" varchar(64) COLLATE "pg_catalog"."default",

  "eqp_place" varchar(192) COLLATE "pg_catalog"."default",

  "priority" int4,

  "cleared" int4 DEFAULT 0,

  "day_id" varchar(2) NOT NULL

) partition by list(day_id);

CREATE TABLE alarm_data_all_01  PARTITION OF alarm_data_all FOR VALUES in ('01');

CREATE TABLE alarm_data_all_02  PARTITION OF alarm_data_all FOR VALUES in ('02');

CREATE TABLE alarm_data_all_03  PARTITION OF alarm_data_all FOR VALUES in ('03');

CREATE TABLE alarm_data_all_04  PARTITION OF alarm_data_all FOR VALUES in ('04');

CREATE TABLE alarm_data_all_05  PARTITION OF alarm_data_all FOR VALUES in ('05');

CREATE TABLE alarm_data_all_06  PARTITION OF alarm_data_all FOR VALUES in ('06');

CREATE TABLE alarm_data_all_07  PARTITION OF alarm_data_all FOR VALUES in ('07');

CREATE TABLE alarm_data_all_08  PARTITION OF alarm_data_all FOR VALUES in ('08');

CREATE TABLE alarm_data_all_09  PARTITION OF alarm_data_all FOR VALUES in ('09');

CREATE TABLE alarm_data_all_10  PARTITION OF alarm_data_all FOR VALUES in ('10');

CREATE TABLE alarm_data_all_11  PARTITION OF alarm_data_all FOR VALUES in ('11');

CREATE TABLE alarm_data_all_12  PARTITION OF alarm_data_all FOR VALUES in ('12');

CREATE TABLE alarm_data_all_13  PARTITION OF alarm_data_all FOR VALUES in ('13');

CREATE TABLE alarm_data_all_14  PARTITION OF alarm_data_all FOR VALUES in ('14');

CREATE TABLE alarm_data_all_15  PARTITION OF alarm_data_all FOR VALUES in ('15');

CREATE TABLE alarm_data_all_16  PARTITION OF alarm_data_all FOR VALUES in ('16');

CREATE TABLE alarm_data_all_17  PARTITION OF alarm_data_all FOR VALUES in ('17');

CREATE TABLE alarm_data_all_18  PARTITION OF alarm_data_all FOR VALUES in ('18');

CREATE TABLE alarm_data_all_19  PARTITION OF alarm_data_all FOR VALUES in ('19');

CREATE TABLE alarm_data_all_20  PARTITION OF alarm_data_all FOR VALUES in ('20');

CREATE TABLE alarm_data_all_21  PARTITION OF alarm_data_all FOR VALUES in ('21');

CREATE TABLE alarm_data_all_22  PARTITION OF alarm_data_all FOR VALUES in ('22');

CREATE TABLE alarm_data_all_23  PARTITION OF alarm_data_all FOR VALUES in ('23');

CREATE TABLE alarm_data_all_24  PARTITION OF alarm_data_all FOR VALUES in ('24');

CREATE TABLE alarm_data_all_25  PARTITION OF alarm_data_all FOR VALUES in ('25');

CREATE TABLE alarm_data_all_26  PARTITION OF alarm_data_all FOR VALUES in ('26');

CREATE TABLE alarm_data_all_27  PARTITION OF alarm_data_all FOR VALUES in ('27');

CREATE TABLE alarm_data_all_28  PARTITION OF alarm_data_all FOR VALUES in ('28');

CREATE TABLE alarm_data_all_29  PARTITION OF alarm_data_all FOR VALUES in ('29');

CREATE TABLE alarm_data_all_30  PARTITION OF alarm_data_all FOR VALUES in ('30');

CREATE TABLE alarm_data_all_31  PARTITION OF alarm_data_all FOR VALUES in ('31');