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)