final pjt

Tables (6)

Article (Untitled4)

  • article_id (Key) — Primary key — NOT NULL
  • author (FK) — text — Foreign key → User.user_id — NOT NULL
  • title (Field) — text
  • content (Field2) — text
  • create_at (Field3) — datetime
  • updated_at (Field4) — datetime

Commnet (Untitled5)

  • comment_id (Key) — Primary key — NOT NULL
  • article (FK) — text — Foreign key → Article.article_id — NOT NULL
  • author (FK2) — text — Foreign key → User.user_id — NOT NULL
  • content (Field) — text
  • created_at (Field2) — datetime
  • updated_at (Field3) — datetime

DepositOptions (Untitled3)

  • options_id (Key) — Primary key — NOT NULL
  • product (FK) — text — Foreign key → DepositProducts.deposit_id — NOT NULL
  • fin_prdt_cd (Field) — text
  • save_trm (Field2) — int
  • intr_rate (Field3) — float
  • Field4 — float

DepositProducts (Untitled2)

  • deposit_id (Key) — Primary key — NOT NULL
  • kor_co_nm (Field) — text
  • fin_prdt_nm (Field2) — text
  • dcls_month (Field4) — date
  • join_way (Field5) — text
  • fin_prdt_cd (Field3) — text
  • etc_note (Field6) — text
  • spcl_cnd (Field7) — text

User (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • username (Field2) — text
  • email (Field6) — text
  • userid (Field3) — text
  • password (Field4) — text
  • phonenumber (Field5) — int

UserDeposit (Untitled6)

  • list_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • deposit_id (Key3) — Foreign key → DepositProducts.deposit_id — NOT NULL
  • options_id (Key4) — Foreign key → DepositOptions.options_id — NOT NULL