practice
Tables (15)
ACCOUNTS
- ACCOUNT_ID — NUMBER(10)
- LEDGER_ID — NUMBER(10)
- ACCOUNT_TYPE — VARCHAR(10)
- NAME — VARCHAR(100)
- CURRENT_BALANCE — NUMBER(15)
- ARCHIVED — CHAR(1)
- CREATED_DATE — DATE
BUDGETS
- BUDGET_ID — NUMBER(10)
- LEDGER_ID — NUMBER(10)
- CATEGORY_ID — NUMBER(10)
- YEAR_MONTH — VARCHAR(7)
- BUDGET_LIMIT — NUMBER(15)
- SPENT_AMOUNT — NUMBER(15)
- STATUS — CHAR(1)
- CREATED_DATE — DATE
CATEGORIES
- CATEGORY_ID — NUMBER(10)
- LEDGER_ID — NUMBER(10)
- NAME — VARCHAR(100)
- TRANSACTION_TYPE — CHAR(1)
- PARENT_CATEGORY_ID — NUMBER(10)
- ICON_CLASS — VARCHAR(50)
- STATUS — CHAR(1)
- CREATED_DATE — DATE
EVENTS
- EVENT_ID — NUMBER(10)
- CREATED_BY — VARCHAR(50)
- TITLE — VARCHAR(200)
- DESCRIPTION — CLOB
- EVENT_TYPE — VARCHAR(20)
- TARGET_AMOUNT — NUMBER(12)
- START_DATE — DATE
- END_DATE — DATE
- REWARD_POINTS — NUMBER(6)
- STATUS — CHAR(1)
- CREATED_DATE — DATE
EVENT_PARTICIPATIONS
- PARTICIPATION_ID — NUMBER(10)
- EVENT_ID — NUMBER(10)
- USER_ID — VARCHAR(50)
- JOIN_DATE — DATE
- STATUS — VARCHAR(20)
- CURRENT_PROGRESS — NUMBER(12)
- COMPLETED — CHAR(1)
- POINTS_EARNED — NUMBER(6)
EVENT_POSTS
- POST_ID — NUMBER(10)
- EVENT_ID — NUMBER(10)
- USER_ID — VARCHAR(50)
- TITLE — VARCHAR(200)
- CONTENT — CLOB
- PROOF_AMOUNT — NUMBER(12)
- IMAGE_URL — VARCHAR(300)
- LIKE_COUNT — NUMBER(8)
- COMMENT_COUNT — NUMBER(8)
- STATUS — CHAR(1)
- CREATED_DATE — DATE
- UPDATED_DATE — DATE
LEDGERS
- LEDGER_ID — NUMBER(10)
- OWNER_ID — VARCHAR(50)
- NAME — VARCHAR(100)
- LEDGER_TYPE — VARCHAR(20)
- DESCRIPTION — VARCHAR(300)
- IS_GROUP — CHAR(1)
- JOIN_CODE — VARCHAR(10)
- STATUS — CHAR(1)
- CREATED_DATE — DATE
- UPDATED_DATE — DATE
LEDGER_MEMBERS
- MEMBER_ID — NUMBER(10)
- LEDGER_ID — NUMBER(10)
- USER_ID — VARCHAR(50)
- ROLE — VARCHAR(20)
- NICKNAME — VARCHAR(50)
- JOIN_DATE — DATE
- STATUS — CHAR(1)
MEMBER_PERMISSIONS
- PERMISSION_ID — NUMBER(10)
- MEMBER_ID — NUMBER(10)
- PERMISSION_TYPE — VARCHAR(30)
- GRANTED — CHAR(1)
- GRANTED_BY — VARCHAR(50)
- GRANTED_DATE — DATE
POINT_HISTORY
- POINT_HISTORY_ID — NUMBER(10)
- USER_ID — VARCHAR(50)
- POINT_TYPE — VARCHAR(20)
- POINTS — NUMBER(8)
- SOURCE_TYPE — VARCHAR(20)
- SOURCE_ID — NUMBER(10)
- DESCRIPTION — VARCHAR(200)
- CREATED_DATE — DATE
POST_COMMENTS
- COMMENT_ID — NUMBER(10)
- POST_ID — NUMBER(10)
- USER_ID — VARCHAR(50)
- PARENT_COMMENT_ID — NUMBER(10)
- CONTENT — VARCHAR(500)
- LIKE_COUNT — NUMBER(6)
- STATUS — CHAR(1)
- CREATED_DATE — DATE
POST_LIKES
- LIKE_ID — NUMBER(10)
- USER_ID — VARCHAR(50)
- POST_ID — NUMBER(10)
- COMMENT_ID — NUMBER(10)
- LIKE_TYPE — VARCHAR(10)
- CREATED_DATE — DATE
TRANSACTIONS
- TRANSACTION_ID — NUMBER(15)
- LEDGER_ID — NUMBER(10)
- ACCOUNT_ID — NUMBER(10)
- CATEGORY_ID — NUMBER(10)
- TRANSACTION_DATE — DATE
- TRANSACTION_TYPE — CHAR(1)
- AMOUNT — NUMBER(15)
- MEMO — VARCHAR(200)
- POSTED — CHAR(1)
- CREATED_DATE — DATE
USERS
- USER_ID — VARCHAR(50)
- EMAIL — VARCHAR(100)
- PASSWORD — VARCHAR(100)
- USERNAME — VARCHAR(50)
- PHONE — VARCHAR(20)
- TOTAL_POINTS — NUMBER(8)
- STATUS — CHAR(1)
- ROLE — VARCHAR(20)
- CREATED_DATE — DATE
- UPDATED_DATE — DATE
USER_BADGES
- BADGE_ID — NUMBER(10)
- USER_ID — VARCHAR(50)
- BADGE_TYPE — VARCHAR(30)
- BADGE_NAME — VARCHAR(100)
- EVENT_ID — NUMBER(10)
- EARNED_DATE — DATE
- DESCRIPTION — VARCHAR(200)