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