timebank

Tables (12)

external_integrations

  • integration_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • integration_type — ENUM('GOOGLE', 'FACEBOOK', 'NAVER') — NOT NULL
  • external_account_id — BIGINT — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE') — NOT NULL

help_requests

  • request_id — BIGINT
  • requester_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • required_time — INT — NOT NULL
  • location — VARCHAR(255)
  • scheduled_datetime — DATETIME — NOT NULL
  • requested_points — INT — NOT NULL
  • status — ENUM('OPEN', 'IN_PROGRESS', 'COMPLETED', 'CANCELLED') — NOT NULL

help_trading

  • transaction_id — BIGINT
  • request_id — BIGINT — NOT NULL
  • requester_id — BIGINT — NOT NULL
  • provider_id — BIGINT — NOT NULL
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME
  • actual_points — INT — NOT NULL
  • requester_approval — BOOLEAN
  • provider_approval — BOOLEAN
  • status — ENUM('IN_PROGRESS', 'COMPLETED', 'DISPUTED', 'CANCELLED') — NOT NULL

helper

  • helper_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • help_requests_id — BIGINT — NOT NULL
  • status — ENUM('APPLIED', 'ACCEPTED', 'DECLINED', 'CANCELLED') — NOT NULL

notifications

  • notification_id — BIGINT
  • recipient_id — BIGINT — NOT NULL
  • sender_id — BIGINT
  • notification_type — ENUM('SERVICE_REQUEST', 'TRANSACTION_UPDATE', 'POINT_UPDATE', 'ADMIN_NOTICE') — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN

point_transactions

  • transaction_id — BIGINT
  • account_id — BIGINT — NOT NULL
  • transaction_type — ENUM('CREDIT', 'DEBIT', 'HOLD', 'RELEASE') — NOT NULL
  • amount — INT — NOT NULL
  • transaction_reason — VARCHAR(255)
  • related_transaction_id — BIGINT

reports

  • report_id — BIGINT
  • reporter_id — BIGINT — NOT NULL
  • reported_user_id — BIGINT — NOT NULL
  • transaction_id — BIGINT
  • report_reason — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — ENUM('REPORTED', 'INVESTIGATING', 'RESOLVED', 'REJECTED') — NOT NULL
  • resolved_at — DATETIME

reviews

  • review_id — BIGINT
  • transaction_id — BIGINT — NOT NULL
  • reviewer_id — BIGINT — NOT NULL
  • reviewee_id — BIGINT — NOT NULL
  • rating — TINYINT
  • comment — TEXT — EX

system_logs

  • log_id — BIGINT
  • user_id — BIGINT
  • log_type — ENUM('ERROR', 'INFO', 'WARNING') — NOT NULL
  • message — TEXT — NOT NULL
  • related_transaction_id — BIGINT

time_accounts

  • account_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • total_points — INT
  • available_points — INT
  • held_points — INT

user_profiles

  • profile_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • available_services — TEXT
  • needed_services — TEXT
  • location — VARCHAR(255)
  • introduction — TEXT

users

  • user_id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(20)
  • user_role — ENUM('ROLE_USER', 'ROLE_ADMIN') — NOT NULL
  • trust_score — FLOAT