My Contacts

My Contacts ERD

Tables (8)

Contact Interest (contact_interest)

  • Contact Id (contact_id) — BIGINT(20) — Foreign key → My Contacts.Contact id — NOT NULL
  • Interest Id (interest_id) — BIGINT(20) — Foreign key → Interests.Interest Id — NOT NULL

Contact Seeking (contact_seeking)

  • Seeking Id (seeking_id) — BIGINT(20) — Foreign key → Seeking.Seeking Id — NOT NULL
  • Contact id (contact_id) — BIGINT(20) — Foreign key → My Contacts.Contact id — NOT NULL

Interests (interests)

  • Interest Id (interest_id) — BIGINT(20) — Primary key — NOT NULL
  • Interest (interest) — VARCHAR(255)

My Contacts (my_contacts)

  • Contact id (contact_id) — BIGINT(20) — Primary key — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Email (email) — VARCHAR(255)
  • Gender (gender) — CHAR(1)
  • Birthday (birthday) — CHAR(10)
  • Profession Id (prof_id) — BIGINT(20) — Foreign key → Profession.Profession Id — NOT NULL
  • Zip Code Id (zip_code) — BIGINT(20) — Foreign key → Zip Code.Zip Code Id — NOT NULL
  • Status Id (status_id) — BIGINT(20) — Foreign key → Status.Status Id — NOT NULL

Profession (profession)

  • Profession Id (prof_id) — BIGINT(20) — Primary key — NOT NULL
  • Profession (profession) — VARCHAR(255)

Seeking (seeking)

  • Seeking Id (seeking_id) — BIGINT(20) — Primary key — NOT NULL
  • Seeking (seeking) — VARCHAR(255)

Status (status)

  • Status Id (status_id) — BIGINT(20) — Primary key — NOT NULL
  • Status (status) — VARCHAR(255)

Zip Code (zip_code)

  • Zip Code Id (zip_code) — BIGINT(20) — Primary key — NOT NULL
  • City (city) — VARCHAR(255)
  • State (state) — VARCHAR(255)