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