코드스테이츠 부트캠프 - Software Engineering Bootcamp 39기 - 메인프로젝트 [WithPet]의 팀원 중 (2022.09~10, 5주), 백엔드개발자(박소영, 윤준영)들이 작성하였습니다.

(9.13)

• 엔티티 파일구조 설계
  • store + storeImage
  • review
  • user(o)
  • heart
  • thread + threadImage
  • reply
  • likes

(10.3 현재) DB테이블(화면캡처) 아래에 SQL 작성문이 있습니다.

CREATE TABLE user
(
    `user_id`        BIGINT          NOT NULL    AUTO_INCREMENT COMMENT 'user_id',
    `created_at`     TIMESTAMP       NOT NULL    DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
    `updated_at`     TIMESTAMP       NOT NULL    DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
    `status`         VARCHAR(45)     NOT NULL    COMMENT 'status',
    `nickname`       VARCHAR(45)     NOT NULL,
    `email`          VARCHAR(45)     NOT NULL,
    `password`       VARCHAR(100)    ,
    `longitude`      DOUBLE          ,
    `latitude`       DOUBLE          ,
    `user_role`      VARCHAR(45)     NOT NULL    DEFAULT 'ROLE_USER',
    `image`          TEXT            ,
    `social_login`  VARCHAR(45)    NOT NULL,
     PRIMARY KEY (user_id)
);

CREATE TABLE store_image
(
`store_image_id`  BIGINT         NOT NULL    AUTO_INCREMENT,
`created_at`      TIMESTAMP      NOT NULL    DEFAULT CURRENT_TIMESTAMP,
`updated_at`      TIMESTAMP      NOT NULL    DEFAULT CURRENT_TIMESTAMP,
`status`          VARCHAR(45)    NOT NULL,
`store_id`        BIGINT         NOT NULL,
`image`           TEXT           NOT NULL ,
PRIMARY KEY (store_image_id)
);

CREATE TABLE store
(
`store_id`      BIGINT          NOT NULL    AUTO_INCREMENT,
`created_at`    TIMESTAMP       NOT NULL    DEFAULT CURRENT_TIMESTAMP,
`updated_at`    TIMESTAMP       NOT NULL    DEFAULT CURRENT_TIMESTAMP,
`status`        VARCHAR(45)     NOT NULL,
`category`      VARCHAR(45)     NOT NULL,
`longitude`     DOUBLE          NOT NULL,
`latitude`      DOUBLE          NOT NULL,
`name`          VARCHAR(100)    NOT NULL,
`address_name`  TEXT            NOT NULL,
`body`          TEXT            NOT NULL,
`phone`         VARCHAR(14)     NOT NULL,
`homepage`      VARCHAR(200)   ,
`user_id`       BIGINT          NOT NULL,
PRIMARY KEY (store_id)
);

CREATE TABLE review
(
review_id   BIGINT         NOT NULL    AUTO_INCREMENT,
created_at  TIMESTAMP      NOT NULL    DEFAULT CURRENT_TIMESTAMP,
updated_at  TIMESTAMP      NOT NULL    DEFAULT CURRENT_TIMESTAMP,
status      VARCHAR(45)    NOT NULL,
user_id     BIGINT         NOT NULL,
store_id    BIGINT         NOT NULL,
body        TEXT           NOT NULL,
score       INT            NOT NULL,
PRIMARY KEY (review_id)
);

CREATE TABLE heart
(
heart_id    BIGINT         NOT NULL    AUTO_INCREMENT,
created_at  TIMESTAMP      NOT NULL    DEFAULT CURRENT_TIMESTAMP,
updated_at  TIMESTAMP      NOT NULL    DEFAULT CURRENT_TIMESTAMP,
status      VARCHAR(45)    NOT NULL,
user_id     BIGINT         NOT NULL,
store_id    BIGINT         NOT NULL,
PRIMARY KEY (heart_id)
);

CREATE TABLE thread_image
(
thread_image_id  BIGINT         NOT NULL    AUTO_INCREMENT,
created_at       TIMESTAMP      NOT NULL    DEFAULT CURRENT_TIMESTAMP,
updated_at       TIMESTAMP      NOT NULL    DEFAULT CURRENT_TIMESTAMP,
status           VARCHAR(45)    NOT NULL,
image            TEXT           NOT NULL,
thread_id        BIGINT         NOT NULL,
PRIMARY KEY (thread_image_id)
);