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)