testERD
Tables (5)
Contact_Interest (contact_interest)
- Contact_id (contact_id) — BIGINT(11) — Primary key — NOT NULL
- Interest_id (interest_id) — BIGINT(11) — Primary key — NOT NULL
Interests (interests)
- Interest_id (interest_id) — BIGINT(11) — Primary key — NOT NULL
- Interest (interest) — VARCHAR(255)
My_Contacts (my_contacts)
- Contact_id (contact_id) — BIGINT(11) — Primary key — NOT NULL
- ZipCode_id (zip_code_id) — BIGINT(11) — Foreign key → Zip Code.ZipCode_id — NOT NULL
- Status_id (status_id2) — BIGINT(11) — Foreign key → Status.Status_id — NOT NULL
- Last_Name (last_name) — VARCHAR(255)
- First_Name (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(255)
- Email (email) — VARCHAR(100)
- Gender (gender) — CHAR(1)
- Birthday (birthday) — CHAR(1)
- ZipCode_id (zipcode_id) — BIGINT(11) — NOT NULL
- Status_id (status_id) — BIGINT(11) — NOT NULL
Status (status)
- Status_id (status_id) — BIGINT(11) — Primary key — NOT NULL
- Status (status) — VARCHAR(255)
Zip Code (zip_code)
- ZipCode_id (zip_code_id) — BIGINT(11) — Primary key — NOT NULL
- City (city) — VARCHAR(255)
- State (state) — VARCHAR(255)