Keti
My Contacts ERD
Tables (4)
Contact Interest (contact_interest)
- Group_id (group_id) — BIGINT(20) — Foreign key → Users.group_id — NOT NULL
Operation Log (operation)
- user_id — Primary key — NOT NULL
- Interest (interest) — VARCHAR(255)
Users (user)
- user_id — Primary key — NOT NULL
- group_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)
group
- Seeking Id (seeking_id) — BIGINT(20) — Primary key — NOT NULL
- Seeking (seeking) — VARCHAR(255)