Challenge
Tables (5)
Contatact Interest (contact_interest)
- ContactId (contact_Id) — INT(11) — Foreign key → My Contacts.ContactId — NOT NULL
- InterestId (interest_id2) — INT(11) — Foreign key → Interests.InterestId — NOT NULL
Interests (interests)
- InterestId (interest_id) — INT(11) — Primary key — NOT NULL
- Interest (interest) — VARCHAR(255)
My Contacts (my_contacts)
- ContactId (contact_Id) — INT(11) — Primary key — NOT NULL
- LastName (last_name) — VARCHAR(255)
- FirstName (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Email (email) — VARCHAR(100)
- Gender (gender) — CHAR(1)
- Birthday (birtgday) — CHAR(8)
- Field
- ZipCode Id (zip_code_Id) — INT(11) — Foreign key → Zip Code.ZipCode Id — NOT NULL
- Status Id (status_Id) — INT(11) — Foreign key → Status.Status Id — NOT NULL
Status (status)
- Status Id (status_Id) — INT(11) — Primary key — NOT NULL
- Status (status) — VARCHAR(255)
Zip Code (zip_code)
- ZipCode Id (zip_code_Id) — INT(11) — Primary key — NOT NULL
- City (city) — VARCHAR(255)
- State (state) — VARCHAR(255)