금융상품

테이블 (5)

ARTICLE (article)

  • article_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → USER.user_id — NOT NULL
  • title — VARCHAR
  • content — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME

COMMENT (comment)

  • comment_id — INT — 기본 키 — NOT NULL
  • article_id — INT — 외래 키 → ARTICLE.article_id — NOT NULL
  • user_id (user_id2) — INT — 외래 키 → USER.user_id — NOT NULL

DepositProducts (depositproducts)

  • dcls_month — TEXT
  • kor_co_nm — TEXT
  • fin_prdt_cd — TEXT
  • join_member — TEXT
  • fin_prdt_nm — TEXT
  • etc_note — TEXT
  • join_deny — INT
  • join_way — TEXT
  • spcl_cnd — TEXT

SavingProducts (savingproducts)

  • dcls_month — TEXT
  • kor_co_nm — TEXT
  • fin_prdt_cd — TEXT
  • join_member — TEXT
  • fin_prdt_nm — TEXT
  • etc_note — TEXT
  • join_deny — INT
  • join_way — TEXT
  • spcl_cnd — TEXT

USER (user)

  • user_id — INT — 기본 키 — NOT NULL
  • password — VARCHAR
  • email — VARCHAR
  • nickname — VARCHAR
  • age — INT
  • asset — INT
  • month_wage — INT