test

Tables (5)

Bank

  • id — SERIAL
  • user_id — INT — NOT NULL
  • cash_balance — INT — NOT NULL
  • loan_amount — INT — NOT NULL
  • max_loan_limit — INT — NOT NULL
  • credit_grade — VARCHAR(20)
  • interest_rate — REAL
  • repayment_due — DATE
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

InterestStock

  • id — SERIAL
  • user_id — INT — NOT NULL
  • stock_code — VARCHAR(20) — NOT NULL
  • stock_name — VARCHAR(100) — NOT NULL
  • added_at — TIMESTAMP — NOT NULL

Portfolio

  • id — SERIAL
  • user_id — INT — NOT NULL
  • stock_code — VARCHAR(20) — NOT NULL
  • stock_name — VARCHAR(100) — NOT NULL
  • quantity — INT — NOT NULL
  • avg_price — INT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

StockOrder

  • id — SERIAL
  • user_id — INT — NOT NULL
  • stock_code — VARCHAR(20) — NOT NULL
  • stock_name — VARCHAR(100) — NOT NULL
  • order_type — order_type_enum — NOT NULL
  • quantity — INT — NOT NULL
  • price — INT — NOT NULL
  • status — order_status_enum — NOT NULL
  • ordered_at — TIMESTAMP — NOT NULL

User

  • id — SERIAL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20)
  • nickname — VARCHAR(50)
  • credit_score — INT
  • created_at — TIMESTAMP — NOT NULL