project_test1
Sample Contacts ERD
Tables (6)
Contact Interest (contact_interest)
- Contact_Id (contact_id) — BIGINT(11) — Foreign key → My Contacts.Contact_Id — NOT NULL
- Interests (interests_id) — BIGINT(11) — Foreign key → Interests.Interests — NOT NULL
Interests (interests)
- Interests (interests_id) — BIGINT(11) — Primary key — NOT NULL
- Interests (interests) — VARCHAR(255)
My Contacts (my_contacts)
- Contact_Id (contact_id) — BIGINT(11) — Primary key — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- Fisrt Name (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Email (email) — VARCHAR(100)
- Gender (gender) — CHAR(1)
- Birthday (birthday) — CHAR(8)
- Zi Code Id (zip_code_id) — BIGINT(11) — Foreign key → ZipCode.Zi Code Id — NOT NULL
- Status Id (status_id) — BIGINT(11) — Foreign key → Status.Status Id — NOT NULL
Status (status)
- Status Id (status_id) — BIGINT(11) — Primary key — NOT NULL
- Status — VARCHAR(255)
Untitled
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Key3 — Primary key — NOT NULL
- Key4 — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
ZipCode (zip_code)
- Zi Code Id (zip_code_id) — BIGINT(11) — Primary key — NOT NULL
- City (city) — VARCHAR(255)
- State (state) — VARCHAR(255)
- Field