Member

Class Type Entity Type etc(auto_increment, Null…)
id String 아이디 id VARCHAR(10) PRIMARY KEY
password String 비밀번호 password VARCHAR(12) NOT NULL
nickname String 닉네임 nickname VARCHAR(10) NOT NULL
email String 이메일 email VARCHAR(30) NOT NULL
fileId Long 파일 아이디 file BIGINT FOREIGN KEY, ON DELETE SET NULL

SQL

CREATE TABLE member (
    id VARCHAR(10) primary key NOT NULL,
    password VARCHAR(12) NOT NULL,
    nickname VARCHAR(10) NOT NULL,
    email VARCHAR(30) NOT NULL,
    file_id BIGINT,
    
    FOREIGN KEY (file_id) REFERENCES file(id) ON DELETE SET NULL
)

Label

Class Type Entity Type etc(auto_increment, Null…)
id Long 라벨 아이디 id BIGINT PRIMARY KEY, AUTO_INCREMENT
name String 라벨 이름 name VARCHAR(10) UNIQUE KEY, NOT NULL
description String 라벨 설명 description VARCHAR(255)
bgColor String 배경색깔 background_color VARCHAR(7) NOT NULL
textColor String 글씨색깔 text_color VARCHAR(7) NOT NULL

SQL

CREATE TABLE label (
		id BIGINT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(10) UNIQUE KEY NOT NULL,
    description VARCHAR(255),
    background_color VARCHAR(7) NOT NULL
    text_color VARCHAR(7) NOT NULL
)

Milestone

Class Type Entity Type etc(auto_increment, Null…)
id Long 아이디 id BIGINT PRIMARY KEY, AUTO_INCREMENT
name String 이름 name VARCHAR(10) UNIQUE KEY, NOT NULL
description String 설명 description VARCHAR(255)
dueDate LocalDateTime 마감일 due_date TIMESTAMP
isClosed boolean 종료 여부 is_closed BOOLEAN NOT NULL

SQL

CREATE TABLE milestone (
		id BIGINT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(10) UNIQUE KEY NOT NULL,
    description VARCHAR(255),
		due_date TIMESTAMP,
		is_closed BOOLEAN NOT NULL
)