oursecondlife
Tables (5)
Contact Interest (contact_interest)
- ContactID (contact_id) — INT(8) — Foreign key → MyContacts.ContactID — NOT NULL
- Interests Id (interest_id) — BIGINT(11) — Foreign key → Interests.Interests Id — NOT NULL
Interests (interests)
- Interests Id (interest_id) — BIGINT(11) — Primary key — NOT NULL
- interest — VARCHAR(255)
MyContacts (my_contacts)
- ContactID (contact_id) — INT(8) — Primary key — NOT NULL
- Zip Code Id (zip_code_id) — INT(11) — Foreign key → Zip Code.Zip Code Id — NOT NULL
- Status Id (status_id) — INT(11) — Foreign key → Satus.Status Id — NOT NULL
- Last Name (last_name) — VARCHAR(255)
- First Name (first_name) — VARCHAR(255)
- Phone (phone) — VARCHAR(20)
- Email (email) — VARCHAR(100)
- Gender (gender) — CHAR(1)
- Birthday (birthday) — CHAR(8)
Satus (status)
- Status Id (status_id) — INT(11) — Primary key — NOT NULL
- Status (status) — VARCHAR(255)\
Zip Code (zip_code)
- Zip Code Id (zip_code_id) — INT(11) — Primary key — NOT NULL
- City (city) — VARCHAR(255)
- State (state\) — VARCHAR(255)