CREATE TABLE IF NOT EXISTS water_box
(
    ID               VARCHAR(36) PRIMARY KEY DEFAULT gen_random_uuid()::text,
    MERCHANT_ID      VARCHAR(36)    NOT NULL,
    compose          VARCHAR(255)   NOT NULL,
    imei             VARCHAR(128)   NOT NULL,
    title            VARCHAR(255)   NOT NULL,
    current_level    NUMERIC(20, 2) NOT NULL,
    upper_level      NUMERIC(20, 2) NOT NULL,
    lower_level      NUMERIC(20, 2) NOT NULL,
    collect_datetime TIMESTAMP(0)
);
COMMENT ON TABLE water_box IS '水箱';
COMMENT ON COLUMN water_box.merchant_id IS '主体ID';
COMMENT ON COLUMN water_box.compose IS '设备组';
COMMENT ON COLUMN water_box.imei IS '编号';
COMMENT ON COLUMN water_box.title IS '名称';
COMMENT ON COLUMN water_box.current_level IS '当前水位';
COMMENT ON COLUMN water_box.upper_level IS '水位上限';
COMMENT ON COLUMN water_box.lower_level IS '水位下限';
COMMENT ON COLUMN water_box.collect_datetime IS '采集时间';




CREATE TABLE IF NOT EXISTS pressure_pump
(
    ID               VARCHAR(36) PRIMARY KEY DEFAULT gen_random_uuid()::text,
    MERCHANT_ID      VARCHAR(36)    NOT NULL,
    compose          VARCHAR(255)   NOT NULL,
    imei             VARCHAR(128)   NOT NULL,
    title            VARCHAR(255)   NOT NULL,
    current_level    NUMERIC(20, 2) NOT NULL,
    upper_level      NUMERIC(20, 2) NOT NULL,
    lower_level      NUMERIC(20, 2) NOT NULL,
    collect_datetime TIMESTAMP(0)
);
COMMENT ON TABLE pressure_pump IS '稳压泵';
COMMENT ON COLUMN water_box.merchant_id IS '主体ID';
COMMENT ON COLUMN water_box.compose IS '设备组';
COMMENT ON COLUMN water_box.imei IS '编号';
COMMENT ON COLUMN water_box.title IS '名称';
COMMENT ON COLUMN water_box.current_level IS '当前水位';
COMMENT ON COLUMN water_box.upper_level IS '上限';
COMMENT ON COLUMN water_box.lower_level IS '下限';
COMMENT ON COLUMN water_box.collect_datetime IS '采集时间';