project_test1

Sample Contacts ERD

Tables (6)

Contact Interest (contact_interest)

  • Contact_Id (contact_id) — BIGINT(11) — Foreign key → My Contacts.Contact_Id — NOT NULL
  • Interests (interests_id) — BIGINT(11) — Foreign key → Interests.Interests — NOT NULL

Interests (interests)

  • Interests (interests_id) — BIGINT(11) — Primary key — NOT NULL
  • Interests (interests) — VARCHAR(255)

My Contacts (my_contacts)

  • Contact_Id (contact_id) — BIGINT(11) — Primary key — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • Fisrt Name (first_name) — VARCHAR(255)
  • Phone (phone) — VARCHAR(20)
  • Email (email) — VARCHAR(100)
  • Gender (gender) — CHAR(1)
  • Birthday (birthday) — CHAR(8)
  • Zi Code Id (zip_code_id) — BIGINT(11) — Foreign key → ZipCode.Zi Code Id — NOT NULL
  • Status Id (status_id) — BIGINT(11) — Foreign key → Status.Status Id — NOT NULL

Status (status)

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

Untitled

  • Key — Primary key — NOT NULL
  • Key2 — Primary key — NOT NULL
  • Key3 — Primary key — NOT NULL
  • Key4 — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

ZipCode (zip_code)

  • Zi Code Id (zip_code_id) — BIGINT(11) — Primary key — NOT NULL
  • City (city) — VARCHAR(255)
  • State (state) — VARCHAR(255)
  • Field