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