관통PJT

테이블 (8)

Article (6)

  • Key — 기본 키 — NOT NULL
  • user (Key2) — 외래 키 → User.Key — NOT NULL
  • title (Field2)
  • content (Field3)
  • created_at (Field4)
  • updated_at (Field5)

Comment (7)

  • Key — 기본 키 — NOT NULL
  • user (Key2) — 외래 키 → User.Key — NOT NULL
  • article (Field2)
  • content (Field3)
  • created_at (Field4)
  • updated_at (Field5)

DepositOption (2)

  • Key — 기본 키 — NOT NULL
  • deposit (Key2) — 외래 키 → SavingProduct.Key — NOT NULL
  • intr_rate_type_nm (Field2)
  • save_trm (Field3)
  • intr_rate (Field4)
  • intr_rate2 (Field5)

DepositProduct (3)

  • Key — 기본 키 — NOT NULL
  • subscribe_user (Key2) — 외래 키 → User.Key — NOT NULL
  • dcls_month (Field)
  • fin_co_no (Field2)
  • fin_prdt_cd (Field3)
  • kor_co_nm (Field4)
  • fin_prdt_nm (Field5)
  • join_way (Field6)
  • mtrt_int (Field7)
  • spcl_cnd (Field8)
  • join_deny (Field9)
  • join_member (Field10)
  • etc_note (Field11)
  • max_limit (Field12)
  • dcls_strt_day (Field13)
  • dcls_end_day (Field14)
  • fin_co_subm_day (Field15)

Portfolio (8)

  • Key — 기본 키 — NOT NULL
  • user (Key2) — 외래 키 → User.Key — NOT NULL
  • saving_preference (Field2)
  • preferred_bank (Field3)

SavingOption (4)

  • Key — 기본 키 — NOT NULL
  • saving (Key2) — 외래 키 → DepositProduct.Key — NOT NULL
  • intr_rate_type_nm (Field2)
  • rsrv_type_nm (Field3)
  • save_trm (Field4)
  • intr_rate (Field5)
  • intr_rate2 (Field6)

SavingProduct (1)

  • Key — 기본 키 — NOT NULL
  • subscribe_user (Key2) — 외래 키 → User.Key — NOT NULL
  • fin_prdt_cd (Field) — CharField
  • kor_co_nm (Field2)
  • fin_prdt_cd (Field3)
  • join_way (Field4)
  • mtrt_int (Field5)
  • spcl_cnd (Field6)
  • join_deny (Field7)
  • join_member (Field8)
  • etc_note (Field9)
  • max_limit (Field10)
  • dcls_strt_day (Field11)
  • dcls_end_day (Field12)
  • fin_co_subm_day (Field13)

User (5)

  • Key — 기본 키 — NOT NULL
  • nickname (Field)
  • email (Field2)
  • username (Field3)
  • name (Field4)
  • age (Field5)
  • money (Field6)
  • salary (Field7)
  • financial_products (Field8)
  • profile_img (Field9)
  • is_active (Field10)
  • is_staff (Field11)
  • is_superuser (Field12)