My Test
Tables (4)
Contact Interest (contact_interest)
- Contact Id (contect_id) — INT(11)
- Field2
My Contacts (my_contacts)
- Key — Primary key — 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)
- Zip Code ld (zip_code_id) — INT(11)
- Status (status_id) — INT(11)
- Zip code ld (zip_code_id2) — INT(11) — Foreign key → Zip Code.Zip code ld — NOT NULL
- Status ld (status id) — INT(11) — Foreign key → Status.Status ld — NOT NULL
Status (status)
- Status ld (status id) — INT(11) — Primary key — NOT NULL
- Status (status) — VARCHAR(255)
Zip Code (zip code)
- Zip code ld (zip_code_id) — INT(11) — Primary key — NOT NULL
- City (city) — VARCHAR(255)
- State (state) — VARCHAR(255)