Test ERD

Tables (3)

MyContacts (my_contacts)

  • Contact ID (contact_id) — INT(11) — Primary key — NOT NULL
  • Contact ID (contact_id2) — INT(11) — Foreign key → Zip Code.Contact ID — NOT NULL
  • LastName (last_name) — VARCHAR(255)
  • FirstName (first_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(255)

Untitled

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Zip Code (zip_code)

  • Contact ID (contact_id) — INT(11) — Primary key — NOT NULL