DB

Tables (6)

Untitled (data_exchage_requests)

  • Key (request_id) — INT — Primary key — NOT NULL
  • Key2 (sender_id) — INT — Primary key — NOT NULL
  • Key3 (receiver_id) — INT — Primary key — NOT NULL
  • Key4 (card_id) — INT — Primary key — NOT NULL
  • Field (status) — ENUM
  • Field (sendAt) — DATETIME
  • Field (responseAt) — DATETIME
  • Field
  • id (id2) — int — Foreign key → user.id — NOT NULL

Untitled (contacts)

  • Key (contact_id) — INT — Primary key — NOT NULL
  • Key2 (user_id) — INT — Primary key — NOT NULL
  • Key3 (shared_card_id) — Primary key — NOT NULL
  • Field
  • Key (request_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key2 (sender_id) — INT — Foreign key → Untitled.Key2 — NOT NULL
  • Key3 (receiver_id) — INT — Foreign key → Untitled.Key3 — NOT NULL
  • Key4 (card_id2) — INT — Foreign key → Untitled.Key4 — NOT NULL

Untitled2 (member)

  • Key (id) — varchar(20) — Primary key — NOT NULL
  • Field (password) — varchar(20)
  • Field (passwordcheck) — varchar(20)
  • Field (name) — varchar(15)
  • Field (birthdate)
  • Field (gender) — char(1)
  • Field (email) — varchar(20)
  • Field (phone) — varchar(20)
  • Field

Untitled2 (user_session)

  • Key (session_id) — INT — Primary key — NOT NULL
  • Key2 (user_id) — INT — Primary key — NOT NULL
  • Field (session_token) — VARCHAR(255)
  • Field (createdAt) — DATETIME
  • Field (expiresAt) — DATETIME
  • Field (is_active) — BOOLEAN
  • Field

card

  • card_id — INT — Primary key — NOT NULL
  • FOREIGN Key (user_id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(50)
  • Field (company) — VARCHAR(100)
  • Field (position) — VARCHAR(100)
  • Field (email) — VARCHAR(100)
  • Field (phone) — VARCHAR(20)
  • Field (address) — VARCHAR(255)
  • Field (createdAt) — DATETIME
  • Field (updatedAt) — DATETIME
  • Field
  • id (id2) — int — Foreign key → user.id — NOT NULL

user

  • id — int — Primary key — NOT NULL
  • name (username) — VARCHAR(50)
  • age (email) — VARCHAR(100)
  • emial (password_hash) — VARCHAR(255)
  • Field (createdAt) — DATETIME
  • Field (updatedAt) — DATETIME
  • Field (is_active) — BOOLEAN
  • Field (role) — ENUM
  • Field