Skip to content

신규 테이블 엔티티 생성 및 기존 테이블 컬럼 추가 대응 #214

@mingeun0507

Description

@mingeun0507

📑 작업 사항

  • 대상 테이블
    • t_daily_summary, t_daily_summary_image, t_achievement
  • 테이블 스키마 수정사항 대응
-- t_achievement: 소확행 기록
alter table t_achievement
    add column emotion varchar(30),
    add created_date date null;

-- t_daily_summary: 오늘 하루 돌아보기
create table t_daily_summary (
    daily_summary_id bigint not null auto_increment,
    user_id bigint not null,
    created_date datetime not null,
    contents text,
    satisfaction enum('BAD', 'SO_SO', 'GOOD', 'GREAT', 'EXCELLENT'),
    primary key (daily_summary_id),
    foreign key (user_id) references t_user(user_id)
) engine=InnoDB default charset=utf8mb4;

-- t_daily_summary_image
create table t_daily_summary_image (
    image_id bigint not null auto_increment,
    daily_summary_id bigint not null,
    image_url text,
    created_at timestamp null,
    primary key (image_id),
    foreign key (daily_summary_id) references t_daily_summary(daily_summary_id)
) engine=InnoDB default charset=utf8mb4;

To-do

  • JPA Entity 및 Repository 생성
  • 기존 Entity 수정

ETC

기타 사항을 작성해 주세요.

Metadata

Metadata

Assignees

Labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions