BankScope
Tables (19)
account
- account_id — bigint
- user_id — int — NOT NULL
- product_id — int
- account_number — varchar(40) — NOT NULL
- identification_number — varchar(100)
- account_type — varchar(20) — NOT NULL
- balance — bigint — NOT NULL
- account_password — varchar(255) — NOT NULL
- status — varchar(20) — NOT NULL
- password_fail_count — int
- account_alias — varchar(20)
- interest_rate — decimal(5, 2)
- created_at — datetime
- last_transaction_at — datetime
- maturity_date — datetime
board
- board_id — int
- user_id — int — NOT NULL
- board_type — varchar(20) — NOT NULL
- title — varchar(200) — NOT NULL
- content — text — NOT NULL
- view_count — int — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
card
- card_id — bigint
- user_id — int — NOT NULL
- account_id — bigint
- card_name — varchar(50)
- card_number — varchar(20) — NOT NULL
- card_type — varchar(20) — NOT NULL
- cvc — varchar(3) — NOT NULL
- status — varchar(20) — NOT NULL
- valid_thru — varchar(5) — NOT NULL
- issued_at — datetime
- credit_limit — bigint
- used_amount — bigint
- payment_day — int
- card_color — varchar(20)
- is_activated — tinyint(1)
corporate_management
- corporate_manage_id — int
- user_id — int — NOT NULL
- loan_id — int — NOT NULL
- risk_grade — varchar(20) — NOT NULL
- default_date — date — NOT NULL
- reason — varchar(100) — NOT NULL
- description — text
- created_at — datetime
deposit_account
- account_id — bigint — NOT NULL
- linked_account_id — bigint — NOT NULL
- maturity_treatment — enum — NOT NULL
email_tokens
- email — varchar(50) — Primary key — NOT NULL
- code — varchar(12) — Primary key — NOT NULL
- is_verified — tinyint(1)
- is_used — tinyint(1)
- created_at — datetime
- expires_at — datetime
financial_product
- product_id — int
- product_category — enum — NOT NULL
- target_type — enum
- product_name — varchar(100) — NOT NULL
- base_interest_rate — decimal(5, 2) — NOT NULL
- max_interest_rate — decimal(5, 2)
- min_duration_months — int
- max_duration_months — int
- min_amount — bigint
- max_amount — bigint
- description — text
- is_active — tinyint(1)
- created_at — datetime
- updated_at — datetime
loan
- loan_id — int
- user_id — int — NOT NULL
- product_id — int — NOT NULL
- linked_account_id — bigint — NOT NULL
- principal_amount — bigint — NOT NULL
- outstanding_amount — bigint — NOT NULL
- interest_rate — decimal(5, 2) — NOT NULL
- payment_day — tinyint — NOT NULL
- info — varchar(255)
- status — varchar(20) — NOT NULL
- overdue_date — date
- overdue_amount — bigint — NOT NULL
- maturity_date — date — NOT NULL
- created_at — datetime
- updated_at — datetime
loan_schedule
- schedule_id — bigint
- loan_id — int — NOT NULL
- due_date — date — NOT NULL
- repay_amount — decimal(15, 2) — NOT NULL
- status — varchar(20)
- paid_at — datetime
- created_at — datetime
member
- id — int
- email — varchar(100) — NOT NULL
- password — varchar(255) — NOT NULL
- name — varchar(30) — NOT NULL
- level — int
- auth — varchar(20)
- team — varchar(50)
- status — tinyint(1)
- counter_number — int
- join_date — date
- last_login — datetime
- created_at — timestamp
product_subscription
- subscription_id — int
- user_id — int — NOT NULL
- product_id — int — NOT NULL
- task_id — bigint
- amount — bigint
- duration_months — int
- applied_interest_rate — decimal(5, 2)
- status — varchar(20)
- payment_day — int
- created_at — datetime
savings_account
- account_id — bigint — NOT NULL
- linked_account_id — bigint — NOT NULL
- installment_amount — bigint — NOT NULL
- term_months — int — NOT NULL
- payment_day — int — NOT NULL
- maturity_date — date — NOT NULL
savings_schedule
- schedule_id — bigint
- account_id — bigint — NOT NULL
- due_date — date — NOT NULL
- installment_amount — decimal(15, 2) — NOT NULL
- status — varchar(20)
- paid_at — datetime
- created_at — datetime
sms_auth
- phone_number — varchar(20) — NOT NULL
- auth_code — varchar(6) — NOT NULL
- is_verified — tinyint(1) — NOT NULL
- created_at — datetime — NOT NULL
- expires_at — datetime — NOT NULL
task
- task_id — bigint
- user_id — int — NOT NULL
- ticket_number — varchar(20) — NOT NULL
- task_type — varchar(50) — NOT NULL
- task_detail_type — varchar(50) — NOT NULL
- assigned_level — varchar(20)
- expected_waiting_time — int
- status — varchar(20)
- member_id — int
- ranking — int
- created_at — datetime
- updated_at — datetime
- is_ai — tinyint(1)
task_processing_log
- log_id — bigint
- task_id — bigint — NOT NULL
- member_id — int — NOT NULL
- action_type — varchar(50) — NOT NULL
- processing_note — text
- created_at — datetime — NOT NULL
transaction_history
- transaction_id — bigint
- account_id — bigint — NOT NULL
- user_id — int
- task_id — bigint
- transaction_type — varchar(50) — NOT NULL
- amount — bigint — NOT NULL
- balance_after — bigint — NOT NULL
- description — varchar(100)
- created_at — datetime
- updated_at — datetime
user
- id — int
- user_type — varchar(25)
- name — varchar(50) — NOT NULL
- email — varchar(50)
- resident_number — varchar(100) — NOT NULL
- identification_number — varchar(100)
- phone — varchar(20)
- password — varchar(100)
- gender — enum
- age — varchar(20)
- grade — varchar(20)
- is_terms_agreed — tinyint(1) — NOT NULL — 필수 약관 전체 동의 여부
user_pin
- pin_id — bigint
- user_id — int — NOT NULL
- pin_hash — varchar(255) — NOT NULL
- fail_count — int — NOT NULL
- locked_until — datetime
- updated_at — datetime