SingleBangka

테이블 (5)

Copy Of Copy Of Untitled (insurinfo)

  • Key (insur_no) — int — 기본 키 — NOT NULL
  • Field (insur_name) — varchar(20) — NOT NULL
  • Field (company) — varchar(20) — NOT NULL
  • Field (premium) — int
  • Field2 (insur_url) — text — NOT NULL
  • Field3 (insur_contents) — text — NOT NULL
  • Field4 (insur_img) — mediumblob — NOT NULL

Copy Of Untitled (bankbook)

  • Key (book_no) — int — 기본 키 — NOT NULL
  • Field (book_name) — varchar(20) — NOT NULL
  • Field (book_bank) — varchar(20) — NOT NULL
  • Field2 (card_url) — text — NOT NULL
  • Field3 (card_contents) — text — NOT NULL
  • Field4 (card_img) — mediumblob — NOT NULL

Untitled (admin)

  • Key (admin_id) — varchar(20) — 기본 키 — NOT NULL
  • Field (admin_pw) — varchar(20) — NOT NULL
  • Field (admin_name) — varchar(10) — NOT NULL

Untitled (cardinfo)

  • Key (card_no) — int — 기본 키 — NOT NULL
  • Field (card_name) — varchar(20) — NOT NULL
  • Field (card_bank) — varchar(20) — NOT NULL
  • Field (annual_fee) — int — NOT NULL
  • Field2 (card_url) — text — NOT NULL
  • Field3 (card_contents) — text — NOT NULL
  • Field4 (card_img) — mediumblob — NOT NULL

회원 (user)

  • 회원 ID (user_id) — varchar(20) — 기본 키 — NOT NULL
  • Field (user_pw) — varchar(20) — NOT NULL
  • Field (user_name) — varchar(10) — NOT NULL
  • Field (user_date) — date — NOT NULL
  • Field2 (join_date) — datetime — NOT NULL