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)