accountbook
Tables (5)
DAILY_CONSUMPTION
- DC_ID — LONG — Primary key — NOT NULL
- USER_ID — LONG — Foreign key → USER.USER_ID — NOT NULL
- AVAIL_SPENDING — LONG
- SPENDING — LONG
- DATE — TIMESTAMP
ESSENTIAL_SPENDING
- ES_ID — LONG — Primary key — NOT NULL
- GOAL_ID — LONG — Foreign key → GOAL.GOAL_ID — NOT NULL
- ICON — LONG
- CONTENT — VARCHAR(100)
- COST — LONG
EXPENDITURE
- EXP_ID — LONG — Primary key — NOT NULL
- DC_ID — LONG — Foreign key → DAILY_CONSUMPTION.DC_ID — NOT NULL
- ICON — LONG
- CONTENT — VARCHAR(100)
- COST — LONG
- MEMO — VARCHAR(100)
GOAL
- GOAL_ID — LONG — Primary key — NOT NULL
- USER_ID — LONG — Foreign key → USER.USER_ID — NOT NULL
- ICON — LONG
- TARGET_AMOUNT — LONG
- PERIOD_START — DATE
- PERIOD_END — DATE
- MEMO — VARCHAR(100)
- MONTHLY_INCOME — LONG
- DAILY_AVAIL_SPENDING — LONG
- REST_MONEY — LONG
USER
- USER_ID — LONG — Primary key — NOT NULL
- EMAIL — VARCHAR(100)
- NAME — VARCHAR(30)
- ROLE — VARCHAR(30)