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