DataOps-platform/database/create_calendar_info.sql

create table public.calendar_info
(
    id        serial
        primary key,
    yangli    date not null,
    yinli     text not null,
    wuxing    text,
    chongsha  text,
    baiji     text,
    jishen    text,
    yi        text,
    xiongshen text,
    ji        text,
    color     varchar(10)
);

comment on table public.calendar_info is '黄历信息表';

comment on column public.calendar_info.id is '主键ID';

comment on column public.calendar_info.yangli is '阳历日期';

comment on column public.calendar_info.yinli is '阴历日期';

comment on column public.calendar_info.wuxing is '五行';

comment on column public.calendar_info.chongsha is '冲煞';

comment on column public.calendar_info.baiji is '彭祖百忌';

comment on column public.calendar_info.jishen is '吉神宜趋';

comment on column public.calendar_info.yi is '宜';

comment on column public.calendar_info.xiongshen is '凶神宜忌';

comment on column public.calendar_info.ji is '忌';

comment on column public.calendar_info.color is '颜色';