selfproject

Tables (6)

AGE_CATEGORY_SUMMARY

  • SUMMARY_ID — NUMBER
  • AGE_GROUP — VARCHAR2(10) — NOT NULL
  • CATEGORY_ID — NUMBER — NOT NULL
  • TOTAL_SPENT — NUMBER(18, 2) — NOT NULL
  • RANKING_ORDER — NUMBER(2) — NOT NULL
  • REPORT_MONTH — CHAR(6) — NOT NULL

BUDGETS

  • BUDGET_ID — NUMBER
  • USER_ID — NUMBER — NOT NULL
  • CATEGORY_ID — NUMBER
  • BUDGET_MONTH — CHAR(6) — NOT NULL
  • BUDGET_AMOUNT — NUMBER(18, 2) — NOT NULL
  • USER_ID (USER_ID2) — NUMBER — Foreign key → USERS.USER_ID

CATEGORIES

  • CATEGORY_ID — NUMBER
  • CATEGORY_NAME — VARCHAR2(50) — NOT NULL
  • CATEGORY_TYPE — VARCHAR2(10) — NOT NULL

SETTINGS

  • SETTING_ID — NUMBER
  • USER_ID — NUMBER
  • SETTING_KEY — VARCHAR2(50) — NOT NULL
  • SETTING_VALUE — VARCHAR2(255)
  • USER_ID (USER_ID2) — NUMBER — Foreign key → USERS.USER_ID

TRANSACTIONS

  • TRANSACTION_ID — NUMBER
  • USER_ID — NUMBER — NOT NULL
  • CATEGORY_ID — NUMBER — NOT NULL
  • TRANSACTION_DATE — DATE — NOT NULL
  • AMOUNT — NUMBER(18, 2) — NOT NULL
  • DESCRIPTION — VARCHAR2(255)
  • TYPE — VARCHAR2(10) — NOT NULL
  • USER_ID (USER_ID2) — NUMBER — Foreign key → USERS.USER_ID

USERS

  • USER_ID — NUMBER — Primary key
  • USERNAME — VARCHAR2(50) — NOT NULL
  • PASSWORD_HASH — VARCHAR2(255) — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL
  • BIRTH_YEAR — NUMBER(4) — NOT NULL
  • JOIN_DATE — DATE — NOT NULL