oursecondlife

Tables (5)

Contact Interest (contact_interest)

  • ContactID (contact_id) — INT(8) — Foreign key → MyContacts.ContactID — NOT NULL
  • Interests Id (interest_id) — BIGINT(11) — Foreign key → Interests.Interests Id — NOT NULL

Interests (interests)

  • Interests Id (interest_id) — BIGINT(11) — Primary key — NOT NULL
  • interest — VARCHAR(255)

MyContacts (my_contacts)

  • ContactID (contact_id) — INT(8) — Primary key — NOT NULL
  • 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 → Satus.Status Id — 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)

Satus (status)

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

Zip Code (zip_code)

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