teset
Tables (9)
BASE_ENTITY
- created_at — TIMESTAMP — NOT NULL
- is_valid — VARCHAR(10) — NOT NULL — ENUM(VALID, DELETED)
CATEGORY
- category_id — INT — Primary key — NOT NULL
- profile_id — INT — 이 카테고리를 만든 사람(DEFAULT가 아닌 경우)
- category_name — VARCHAR(20) — NOT NULL
- is_default — VARCHAR(10) — NOT NULL — ENUM(DEFAULT, CUSTOM)
- color — VARCHAR(15) — NOT NULL — ENUM, 컬러 코드는 노션 '프로젝트 산출물' 참고
CHALLENGE
- challenge_id — INT — Primary key — NOT NULL
- profile_id — INT — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- challenge_status — VARCHAR(10) — NOT NULL — ENUM(PROGRESS, SUCCEED, FAILED)
- target_amount — MEDIUMINT — NOT NULL
- used_amount — INT — NOT NULL
- leftover_amount — MEDIUMINT — NOT NULL
- is_viewed — VARCHAR — ENUM(VIEWED,NOT_VIEWED)
DEPOSIT
- deposit_id — INT — Primary key — NOT NULL
- profile_id — INT — NOT NULL
- bank — VARCHAR(15) — NOT NULL
- deposit_name — VARCHAR(25) — NOT NULL
- deposit_description — VARCHAR(255) — NOT NULL
- interest_rate — DECIMAL — NOT NULL
EXPENSE
- expense_id — INT — Primary key — NOT NULL
- challenge_id — INT — NOT NULL
- category_id — INT — NOT NULL
- pay_time — DATETIME — NOT NULL — 사용자 입력인 경우 현재 시간
- pay_amount — MEDIUMINT — NOT NULL
- content — VARCHAR(255) — NOT NULL
FILE
- file_id — INT — Primary key — NOT NULL
- dtype — VARCHAR(20) — NOT NULL — (ProfileImage)
- saved_filename — VARCHAR(255) — NOT NULL — UUID-원본파일
- saved_path — VARCHAR(255) — NOT NULL
MEMBER
- member_id — BINARY(16) — Primary key — NOT NULL — UUID
- member_name — VARCHAR(100)
- email — VARCHAR(320) — UNIQUE
- birth_date — DATETIME
- password — VARCHAR(255)
- oauth_server_id — VARCHAR(255)
- oauth_server_type — VARCHAR(10) — NOT NULL — ENUM(DEFAULT, KAKAO, GOOGLE)
PROFILE
- profile_id — INT — Primary key — NOT NULL
- member_id — BINARY(16) — NOT NULL — UUID
- nickname — VARCHAR(20) — NOT NULL
PROFILE_IMAGE
- file_id — INT — Foreign key → FILE.file_id — NOT NULL
- profile_id — INT — NOT NULL