My Contacts
My Contacts ERD
Tables (8)
Contact Interest (contact_interest)
- Contact Id (contact_id) — BIGINT(20) — Foreign key → My Contacts.Contact id — NOT NULL
- Interest Id (interest_id) — BIGINT(20) — Foreign key → Interests.Interest Id — NOT NULL
Contact Seeking (contact_seeking)
- Seeking Id (seeking_id) — BIGINT(20) — Foreign key → Seeking.Seeking Id — NOT NULL
- Contact id (contact_id) — BIGINT(20) — Foreign key → My Contacts.Contact id — NOT NULL
Interests (interests)
- Interest Id (interest_id) — BIGINT(20) — Primary key — NOT NULL
- Interest (interest) — VARCHAR(255)
My Contacts (my_contacts)
- Contact id (contact_id) — BIGINT(20) — Primary key — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Email (email) — VARCHAR(255)
- Gender (gender) — CHAR(1)
- Birthday (birthday) — CHAR(10)
- Profession Id (prof_id) — BIGINT(20) — Foreign key → Profession.Profession Id — NOT NULL
- Zip Code Id (zip_code) — BIGINT(20) — Foreign key → Zip Code.Zip Code Id — NOT NULL
- Status Id (status_id) — BIGINT(20) — Foreign key → Status.Status Id — NOT NULL
Profession (profession)
- Profession Id (prof_id) — BIGINT(20) — Primary key — NOT NULL
- Profession (profession) — VARCHAR(255)
Seeking (seeking)
- Seeking Id (seeking_id) — BIGINT(20) — Primary key — NOT NULL
- Seeking (seeking) — VARCHAR(255)
Status (status)
- Status Id (status_id) — BIGINT(20) — Primary key — NOT NULL
- Status (status) — VARCHAR(255)
Zip Code (zip_code)
- Zip Code Id (zip_code) — BIGINT(20) — Primary key — NOT NULL
- City (city) — VARCHAR(255)
- State (state) — VARCHAR(255)