sss

Tables (5)

conInter (conInt)

  • contactid (contact_id) — int(11) — Foreign key → mycontacts.contactid — NOT NULL
  • zipId — int(11) — Foreign key → mycontacts.zipId — NOT NULL
  • statusId — int(11) — Foreign key → mycontacts.statusId — NOT NULL
  • InterId — int(11) — Foreign key → interests.InterId — NOT NULL

interests

  • InterId — int(11) — Primary key — NOT NULL
  • interest — varchar(255)

mycontacts (Untitled)

  • contactid (contact_id) — int(11) — Primary key — NOT NULL
  • zipId — int(11) — Foreign key → zip_code.zipId — NOT NULL
  • statusId — int(11) — Foreign key → status.statusId — NOT NULL
  • last_ Name (last_Name) — varchar(255)
  • first_Name — varchar(255)
  • phone — varchar(100)
  • e-mail — varchar(100)
  • gender — char(1)

status

  • statusId — int(11) — Primary key — NOT NULL
  • status — varchar(255)

zip_code

  • zipId — int(11) — Primary key — NOT NULL
  • city — varchar(255)
  • state — varchar(255)