My Comtacts
Tables (5)
Comuact Interest (conyact_interest)
- id (co_id) — INT(11) — Foreign key → my Contacts.id — NOT NULL
- Interest id (interest_id2) — INT(11) — Foreign key → Interest id.Interest id — NOT NULL
Interest id (interests)
- Interest id (interest_id) — INT(11) — Primary key — NOT NULL
- Interest (inrerest) — VARCHAR(255)
Status (status)
- Status id (status_id) — INT(11) — Primary key — NOT NULL
- Status (status) — VARCHAR(255)
Zip Code (zip_code)
- Zip Coid id (zip_code_id) — INT(11) — Primary key — NOT NULL
- City (city) — VARCHAR(255)
- State (state) — VARCHAR(255)
my Contacts (my_contacts)
- id (co_id) — INT(11) — Primary key — NOT NULL
- ListName (list_name) — VARCHAR(255)
- Fist Name (fist_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Email (enail) — VARCHAR(100)
- Gender (gender) — CHAR(1)
- Birthday (birthday) — CHAR(8)
- Zip Coid id (zip_code_id) — INT(11) — Foreign key → Zip Code.Zip Coid id — NOT NULL
- Status id (status_id) — INT(11) — Foreign key → Status.Status id — NOT NULL