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