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