project
Tables (9)
Accounts_User
- id — integer — Primary key — NOT NULL
- email — varchar(254) — Primary key — NOT NULL
- password — varchar(128) — NOT NULL
- last_login — datetime
- is_superuser — bool — NOT NULL
- birth — date
- phone — varchar(20) — NOT NULL
- address — varchar(100) — NOT NULL
- products — varchar(200) — NOT NULL
- money — integer
- salary — integer
- married — bool
- main_bank — varchar(20) — NOT NULL
- save_type — integer
- is_active — bool — NOT NULL
- is_staff — bool — NOT NULL
- username — varchar(30) — NOT NULL
Articles_Article
- id — integer — Primary key — NOT NULL
- category_id (id2) — integer — Foreign key → Articles_Category.id — NOT NULL
- user_id (id3) — integer — Foreign key → Accounts_User.id — NOT NULL
- title — varchar(50) — NOT NULL
- content — text — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
Articles_Category
- id — integer — Primary key — NOT NULL
- name — varchar(50) — NOT NULL
Articles_Comment
- id — integer — Primary key — NOT NULL
- user_id (id2) — integer — Foreign key → Accounts_User.id — NOT NULL
- article_id (id22) — integer — Foreign key → Articles_Article.category_id — NOT NULL
- content — varchar(200) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
Products_depositoption
- id — int — Primary key
- product_id (id2) — int — Foreign key → products_depositproduct.id
- dcls_month — varchar(30)
- intr_rate_type — varchar(30)
- intr_rate_type_nm — varchar(30)
- save_trm — varchar(30)
- intr_rate — double
- intr_rate2 — double
Products_integratedproduct
- id — int — Primary key
- code — varchar(30)
Products_savingoption
- id — int — Primary key
- product_id (id2) — int — Foreign key → Products_savingproduct.id
- dcls_month — varchar(30)
- intr_rate_type — varchar(30)
- intr_rate_type_nm — varchar(30)
- rsrv_type — varchar(30)
- rsrv_type_nm — varchar(30)
- save_trm — varchar(30)
- intr_rate — double
- intr_rate2 — double
Products_savingproduct
- id — int — Primary key
- dcls_month — varchar(30)
- fin_co_no — varchar(30)
- kor_co_nm — varchar(30)
- fin_prdt_cd — varchar(30)
- fin_prdt_nm — varchar(30)
- join_way — varchar(30)
- mtrt_int — varchar(100)
- spcl_cnd — varchar(100)
- join_deny — varchar(30)
- join_member — varchar(30)
- etc_note — varchar(100)
- max_limit — int
- dcls_strt_day — varchar(30)
- dcls_end_day — varchar(30)
- fin_co_subm_day — varchar(30)
products_depositproduct (Products_depositproduct)
- id — int — Primary key
- dcls_month — varchar(30)
- fin_co_no — varchar(30)
- kor_co_nm — varchar(30)
- fin_prdt_cd — varchar(30)
- fin_prdt_nm — varchar(30)
- join_way — varchar(30)
- mtrt_int — varchar(100)
- spcl_cnd — varchar(100)
- join_deny — varchar(30)
- join_member — varchar(30)
- etc_note — varchar(100)
- max_limit — int
- dcls_strt_day — varchar(30)
- dcls_end_day — varchar(30)
- fin_co_subm_day — varchar(30)