test
Tables (8)
bank_accounts
- id — SERIAL
- user_id — UUID — NOT NULL
- bank_code — VARCHAR(20) — NOT NULL
- account_number — VARCHAR(50) — NOT NULL
- account_alias — VARCHAR(50)
- balance — NUMERIC(18,2)
- created_at — TIMESTAMP
bank_transactions
- id — SERIAL
- account_id — INT — NOT NULL
- transaction_type — VARCHAR(20) — NOT NULL
- amount — NUMERIC(18,2) — NOT NULL
- transaction_time — TIMESTAMP
- description — TEXT
insurance_payments
- id — SERIAL
- insurance_user_id — INT — NOT NULL
- paid_amount — NUMERIC(18,2) — NOT NULL
- paid_at — DATE — NOT NULL
- payment_method — VARCHAR(20)
insurance_users
- id — SERIAL
- user_id — UUID — NOT NULL
- insurance_company_code — VARCHAR(20) — NOT NULL
- policy_number — VARCHAR(50) — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP
oauth_clients
- client_id — VARCHAR(128)
- client_secret — VARCHAR(256) — NOT NULL
- redirect_uri — TEXT — NOT NULL
- grant_types — TEXT
- scope — TEXT
- created_at — TIMESTAMP
oauth_tokens
- token_id — SERIAL
- access_token — TEXT — NOT NULL
- refresh_token — TEXT
- user_id — UUID — NOT NULL
- client_id — VARCHAR(128)
- expires_in — INTEGER
- scope — TEXT
- created_at — TIMESTAMP
user_connected_services
- id — SERIAL
- user_id — UUID — NOT NULL
- institution_code — VARCHAR(20) — NOT NULL
- service_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP
users
- id — UUID
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(150) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP