ㅇ
Tables (11)
account
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- fin_co_no — VARCHAR(255) — NOT NULL
- fin_prdt_cd — VARCHAR(255)
- account_number — VARCHAR(255) — NOT NULL
- account_status — enum('IN_USE', 'UNREGISTERED_REQ' 'UNREGISTERED') — NOT NULL
- account_type — enum('CURRENT_ACCOUNT','TIME_DEPOSIT') — NOT NULL
- account_password — VARCHAR(255)
- balance — VARCHAR(255)
- account_reg_dt — DATETIME — NOT NULL
- account_un_reg_dt — DATETIME
- intr_rate_type — VARCHAR(255)
- intr_rate_type_nm — VARCHAR(255)
- save_trm — VARCHAR(255)
- intr_rate — VARCHAR(255)
- financial_instruments_apply_dt — VARCHAR(255)
- financial_instruments_id — VARCHAR(255)
- created_user_id — VARCHAR(255) — NOT NULL
- created_dt — DATETIME — NOT NULL
- updated_user_id — VARCHAR(255) — NOT NULL
- updated_dt — DATETIME — NOT NULL
bank
- fin_co_no — VARCHAR(255) — Primary key — NOT NULL
- kor_co_nm — VARCHAR(255) — NOT NULL
- ohter_bank_transaction_tax — INT — NOT NULL
- created_dt — DATETIME — NOT NULL
- updated_dt — DATETIME — NOT NULL
banner
- id — BIGINT — Primary key — NOT NULL
- alt_title — VARCHAR(255) — NOT NULL
- filename — VARCHAR(255) — NOT NULL
- url_filename — VARCHAR(255) — NOT NULL
- link_url — VARCHAR(255) — NOT NULL
- target — VARCHAR(50) — NOT NULL
- sort_value — INT — NOT NULL
- open_yn — BIT — NOT NULL
- reg_user_id — VARCHAR(255) — NOT NULL
- reg_dt — VARCHAR(255) — NOT NULL
- udt_user_id — VARCHAR(255) — NOT NULL
- udt_dt — VARCHAR(255) — NOT NULL
category
- id — BIGINT — Primary key — NOT NULL
- category_name — VARCHAER(255) — NOT NULL
- category_type — VARCHAR(255) — NOT NULL
- sort_value — INT — NOT NULL
- using_yn — BIT — NOT NULL
financial_instruments
- fin_prdt_cd — VARCHAR(255) — Primary key — NOT NULL
- fin_co_no — VARCHAR(255) — Foreign key → bank.fin_co_no — NOT NULL
- kor_co_nm — VARCHAR(255) — NOT NULL
- fin_prdt_nm — VARCHAR(255) — NOT NULL
- max_limit — BIGINT
- category_id — BIGINT — NOT NULL
- created_user_id — VARCHAR(255) — NOT NULL
- created_dt — DATETIME — NOT NULL
- updated_user_id — VARCHAR(255) — NOT NULL
- updated_dt — DATETIME — NOT NULL
member
- user_id — VARCHAR(255) — Primary key — NOT NULL
- user_name — VARCHAR(20) — NOT NULL
- user_password — VARCHAR(255) — NOT NULL
- user_phone — VARCHAR(12) — NOT NULL
- email_auth_key — VARCHAR(255) — NOT NULL
- email_auth_yn — BIT — NOT NULL
- email_auth_dt — DATETIME
- reset_password_key — VARCHAR(255)
- reset_password_limit_dt — DATETIME
- user_status — VARCHAR(20) — NOT NULL
- last_login_dt — DATETIME
- roles — VARCHAR(20) — NOT NULL
- created_dt — DATETIME — NOT NULL
- updated_dt — DATETIME — NOT NULL
member_login_history
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- ip_addr — VARCHAR(255) — NOT NULL
- user_agent — VARCHAR(255) — NOT NULL
- login_dt — DATETIME — NOT NULL
options
- id — BIGINT — Primary key — NOT NULL
- fin_prdt_cd — VARCHAR(255) — NOT NULL
- fin_co_no — VARCHAR(255) — NOT NULL
- intr_rate_type — VARCHAR(20) — NOT NULL
- intr_rate_type_nm — VARCHAR(20) — NOT NULL
- save_trm — INT — NOT NULL
- intr_rate — DOUBLE — NOT NULL
- created_user_id — VARCHAR(255) — NOT NULL
- created_dt — DATETIME — NOT NULL
- updated_user_id — VARCHAR(255) — NOT NULL
- updated_dt — DATETIME — NOT NULL
take_financial_instruments
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- fin_prdt_cd — VARCHAR(255) — NOT NULL
- fin_co_no — VARCHAR(255) — NOT NULL
- amout — BIGINT — NOT NULL
- status — enum('REQ','COMPLETE',"CANCEL_REQ",'CANCEL_COMPLETE') — NOT NULL
- intr_rate_type — VARCHAR(20) — NOT NULL
- intr_rate_type_nm — VARCHAR(20) — NOT NULL
- save_trm — INT — NOT NULL
- intr_rate — DOUBLE — NOT NULL
- transaction_id — VARCHAR(255) — NOT NULL
- account_number — VARCHAR(255) — NOT NULL
- financial_instruments_apply_dt — DATETIME
- financial_instruments_end_dt — VARCHAR(255)
- financial_instruments_id — INT — NOT NULL
- created_user_id — VARCHAR(255) — NOT NULL
- created_dt — DATETIME — NOT NULL
take_transaction
- id — BIGINT — Primary key — NOT NULL
- id2 — BIGINT — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- status — enum('REMIT_REQ, 'REMIT_COMPLETE','REMIT_CACNEL_REQ','REMIT_CANCEL_COMPLETE') — NOT NULL
transaction
- id — BIGINT — Primary key — NOT NULL
- id2 — BIGINT — NOT NULL
- transaction_type — enum('DEPOSIT, 'WITHDRAW','REMIT','CANCEL') — NOT NULL
- amout — BIGINT — NOT NULL
- balance_snapshot — BIGINT — NOT NULL
- transaction_id — VARCHAR(255) — NOT NULL
- take_account_number — VARCHAR(255)
- give_account_number — VARCHAR(255) — NOT NULL
- take_fin_co_no — VARCHAR(255)
- transacted_dt — DATETIME — NOT NULL
- created_user_id — VARCHAR(255) — NOT NULL
- created_dt — DATETIME — NOT NULL
- updated_user_id — VARCHAR(255) — NOT NULL
- updated_dt — DATETIME — NOT NULL