Files
bio_backend/ddl/schema.sql

19 lines
579 B
MySQL
Raw Permalink Normal View History

2025-08-11 11:31:02 +09:00
create table st_member (
use_flag boolean not null,
2025-08-11 11:31:02 +09:00
created_at timestamp(6) not null,
created_oid bigint,
2025-08-11 11:31:02 +09:00
last_login_at timestamp(6),
2025-08-12 08:46:55 +09:00
oid bigint not null,
2025-08-11 11:31:02 +09:00
updated_at timestamp(6) not null,
updated_oid bigint,
role varchar(40) not null check (role in ('MEMBER','ADMIN','USER','SYSTEM_ADMIN')),
2025-08-11 11:31:02 +09:00
password varchar(100) not null,
user_id varchar(100) not null,
refresh_token varchar(200),
primary key (oid)
2025-08-11 11:31:02 +09:00
);
create index idx_member_user_id
on st_member (user_id);