mutsa-ackathon

Tables (3)

EXPENSE (소비내역)

  • id (소비아이디) — Long — Primary key — NOT NULL
  • category (소비카테고리) — VARCHAR(255)
  • amount (소비액) — INT
  • expense_date (소비일) — DATE
  • memo (메모) — VARCHAR(255)
  • member_id (회원아이디) — Long — Foreign key → MEMBER.id — NOT NULL

MEMBER (회원)

  • id (회원아이디) — Long — Primary key — NOT NULL
  • email (이메일) — VARCHAR(255)
  • nickname (닉네임) — VARCHAR(255)
  • character_type (캐릭터 상태) — VARCHAR(255)
  • pay_day (월급일) — INT
  • monthly_budget (한달예산) — INT
  • password (비밀번호) — VARCHAR(255)

REGULAR_PAYMENT (정기구독)

  • id (정기구독아이디) — Long — Primary key — NOT NULL
  • payment_name (구독내역) — VARCHAR(255)
  • amount (구독액) — INT
  • billing_day (구독결제일) — INT
  • is_active (구독여부) — BOOLEAN
  • member_id (회원아이디) — Long — Foreign key → MEMBER.id — NOT NULL