test

Tables (3)

Status (Untitled3)

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

Untitled

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

Zip Code (Untitled2)

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