My Contacts

Tables (3)

Status Id (Status_id)

  • Status id (status_id) — VARCHAR(225) — Primary key — NOT NULL

Zip code (Zip_code)

  • Zip code id (Zip_code_code) — INT(11) — Primary key — NOT NULL
  • State (state) — VARCHAR(225)
  • City (city) — VARCHAR(225)

myContacts (my_contacts)

  • Contant id (Contact_id) — INT(11) — Primary key — NOT NULL
  • Last Name (Last_Name) — VARCHAR(225)
  • First Name (First_Name) — VARCHAR(225)
  • Phone (phone) — VARCHAR(20)
  • Email (email) — VARCHAR(100)
  • Gender (gender) — CHAR(1)
  • Birthday (birthday) — CHAR(8)
  • Field
  • Status id (status_id) — VARCHAR(225) — Foreign key → Status Id.Status id — NOT NULL
  • Zip code id (Zip_code_code) — INT(11) — Foreign key → Zip code.Zip code id — NOT NULL