My Contacts
Tables (3)
Status Id (Status_id)
- Status id (status_id) — VARCHAR(225) — Primary key — NOT NULL
Zip code (Zip_code)
- Zip code id (Zip_code_code) — INT(11) — Primary key — NOT NULL
- State (state) — VARCHAR(225)
- City (city) — VARCHAR(225)
myContacts (my_contacts)
- Contant id (Contact_id) — INT(11) — Primary key — NOT NULL
- Last Name (Last_Name) — VARCHAR(225)
- First Name (First_Name) — VARCHAR(225)
- Phone (phone) — VARCHAR(20)
- Email (email) — VARCHAR(100)
- Gender (gender) — CHAR(1)
- Birthday (birthday) — CHAR(8)
- Field
- Status id (status_id) — VARCHAR(225) — Foreign key → Status Id.Status id — NOT NULL
- Zip code id (Zip_code_code) — INT(11) — Foreign key → Zip code.Zip code id — NOT NULL