19 lines
476 B
SQL
19 lines
476 B
SQL
drop table if exists b_anniversary;
|
|
|
|
create table b_anniversary (
|
|
id bigint primary key,
|
|
family_id bigint not null,
|
|
name varchar(64) not null,
|
|
month smallint not null,
|
|
day smallint not null,
|
|
type smallint not null default 0,
|
|
remind_before smallint default 0,
|
|
sort_number int not null default 0,
|
|
create_time timestamptz,
|
|
update_time timestamptz,
|
|
create_by bigint,
|
|
update_by bigint
|
|
);
|
|
|
|
create index idx_b_anniversary_family on b_anniversary (family_id);
|