test
Tables (10)
Admin
- admin_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- admin_level — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
AdminAction
- action_id — INT — Primary key — NOT NULL
- admin_id — INT — Foreign key → Admin.admin_id — NOT NULL
- project_id — INT — Foreign key → Project.project_id — NOT NULL
- action_type — VARCHAR(50) — NOT NULL
- reason — TEXT
- action_date — DATETIME — NOT NULL
Comment
- comment_id — INT — Primary key — NOT NULL
- project_id — INT — Foreign key → Project.project_id — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
Funding
- funding_id — INT — Primary key — NOT NULL
- sponsor_id — INT — Foreign key → User.user_id — NOT NULL
- project_id — INT — Foreign key → Project.project_id — NOT NULL
- reward_id — INT — Foreign key → Reward.reward_id
- amount — DECIMAL(10,2) — NOT NULL
- payment_method — VARCHAR(50) — NOT NULL
- payment_status — VARCHAR(20) — NOT NULL
- funded_at — DATETIME — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
Inquiry
- inquiry_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- category — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- admin_response — TEXT
- responded_by — INT — Foreign key → Admin.admin_id
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- responded_at — DATETIME
Project
- project_id — INT — Primary key — NOT NULL
- creator_id — INT — Foreign key → User.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- simple_description — TEXT
- banner_url — VARCHAR(500)
- description — TEXT
- funding_goal — DECIMAL(15,2) — NOT NULL
- current_funding — DECIMAL(15,2) — NOT NULL
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- image_url — VARCHAR(500)
- category — VARCHAR(100)
- project_url — VARCHAR(500)
- approval_status — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
Reward
- reward_id — INT — Primary key — NOT NULL
- project_id — INT — Foreign key → Project.project_id — NOT NULL
- description — TEXT — NOT NULL
- amount — DECIMAL(10,2) — NOT NULL
- quantity — INT — NOT NULL
- remaining_quantity — INT — NOT NULL
- delivery_date — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
Transaction
- transaction_id — INT — Primary key — NOT NULL
- sender_account_id — INT — Foreign key → VirtualAccount.account_id
- receiver_account_id — INT — Foreign key → VirtualAccount.account_id
- funding_id — INT — Foreign key → Funding.funding_id
- admin_id — INT — Foreign key → Admin.admin_id
- amount — DECIMAL(12,2) — NOT NULL
- transaction_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- transaction_date — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
User
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
VirtualAccount
- account_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id — NOT NULL
- balance — DECIMAL(12,2) — NOT NULL
- funding_block — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME