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)