testERD

Tables (5)

Contact_Interest (contact_interest)

  • Contact_id (contact_id) — BIGINT(11) — Primary key — NOT NULL
  • Interest_id (interest_id) — BIGINT(11) — Primary key — NOT NULL

Interests (interests)

  • Interest_id (interest_id) — BIGINT(11) — Primary key — NOT NULL
  • Interest (interest) — VARCHAR(255)

My_Contacts (my_contacts)

  • Contact_id (contact_id) — BIGINT(11) — Primary key — NOT NULL
  • ZipCode_id (zip_code_id) — BIGINT(11) — Foreign key → Zip Code.ZipCode_id — NOT NULL
  • Status_id (status_id2) — BIGINT(11) — Foreign key → Status.Status_id — NOT NULL
  • Last_Name (last_name) — VARCHAR(255)
  • First_Name (first_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(255)
  • Email (email) — VARCHAR(100)
  • Gender (gender) — CHAR(1)
  • Birthday (birthday) — CHAR(1)
  • ZipCode_id (zipcode_id) — BIGINT(11) — NOT NULL
  • Status_id (status_id) — BIGINT(11) — NOT NULL

Status (status)

  • Status_id (status_id) — BIGINT(11) — Primary key — NOT NULL
  • Status (status) — VARCHAR(255)

Zip Code (zip_code)

  • ZipCode_id (zip_code_id) — BIGINT(11) — Primary key — NOT NULL
  • City (city) — VARCHAR(255)
  • State (state) — VARCHAR(255)