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