My Contacts

테이블 (3)

My Contacts (my_contacts)

  • Contacted id (Contacted _id) — INT(11) — 기본 키 — NOT NULL
  • Last Name (last_Name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Email (email) — VARCHAR(100)
  • Gender (ender) — CHAR(1)
  • Birthday (birthday) — CHAR(8)
  • Status Id (zip_code_id) — INT(11) — NOT NULL
  • Zip Code Id (Zip Code_id) — INT(11) — NOT NULL
  • Status Id (status_id) — INT(11) — 외래 키 → Status.Status Id — NOT NULL
  • Zip Code id (Zip Code_id2) — INT(11) — 외래 키 → 우편번호.Zip Code id — NOT NULL

Status (status)

  • Status Id (status_id) — INT(11) — 기본 키 — NOT NULL
  • Status (status) — VARCHAR(255)

우편번호 (zip_code)

  • Zip Code id (Zip Code_id) — INT(11) — 기본 키 — NOT NULL
  • City (city) — VARCHAR(255)
  • Field