My Contacts

Tables (5)

Contact Interest (contact_interest)

  • Contact ID (contact_id2) — INT(12) — Foreign key → My Contacts.Contact ID — NOT NULL
  • Interest ID (interest_id2) — INT(12) — Foreign key → Interests.Interest ID — NOT NULL

Interests (interests)

  • Interest ID (interest_id) — INT(12) — Primary key — NOT NULL
  • Interest (interest) — VARCHAR(255)

My Contacts (my_contacts)

  • Contact ID (contact_id) — INT(12) — Primary key — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Gender (gender) — CHAR(1)
  • Birthday (birthday) — CHAR(8)
  • Zip Code ID (zip_code_id) — INT(12) — NOT NULL
  • Status ID (status_id) — INT(12) — NOT NULL
  • Zip Code ID (zip_code_id2) — INT(12) — Foreign key → Zip Code.Zip Code ID — NOT NULL
  • Status (status2) — VARCHAR(255) — Foreign key → Status ID.Status — NOT NULL
  • Email (email) — VARCHAR(100)

Status ID (status_id)

  • Status (status) — VARCHAR(255) — Primary key — NOT NULL

Zip Code (zip_code)

  • Zip Code ID (zip_code_id) — INT(12) — Primary key — NOT NULL
  • City (city) — VARCHAR(255)
  • State (state) — VARCHAR(255)