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