My Comtacts

Tables (5)

Comuact Interest (conyact_interest)

  • id (co_id) — INT(11) — Foreign key → my Contacts.id — NOT NULL
  • Interest id (interest_id2) — INT(11) — Foreign key → Interest id.Interest id — NOT NULL

Interest id (interests)

  • Interest id (interest_id) — INT(11) — Primary key — NOT NULL
  • Interest (inrerest) — VARCHAR(255)

Status (status)

  • Status id (status_id) — INT(11) — Primary key — NOT NULL
  • Status (status) — VARCHAR(255)

Zip Code (zip_code)

  • Zip Coid id (zip_code_id) — INT(11) — Primary key — NOT NULL
  • City (city) — VARCHAR(255)
  • State (state) — VARCHAR(255)

my Contacts (my_contacts)

  • id (co_id) — INT(11) — Primary key — NOT NULL
  • ListName (list_name) — VARCHAR(255)
  • Fist Name (fist_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Email (enail) — VARCHAR(100)
  • Gender (gender) — CHAR(1)
  • Birthday (birthday) — CHAR(8)
  • Zip Coid id (zip_code_id) — INT(11) — Foreign key → Zip Code.Zip Coid id — NOT NULL
  • Status id (status_id) — INT(11) — Foreign key → Status.Status id — NOT NULL