| 12345678910111213141516171819 |
- -- Contact Persons Table
- CREATE TABLE IF NOT EXISTS contact_persons (
- id INT AUTO_INCREMENT PRIMARY KEY,
- client_id INT NOT NULL,
- first_name VARCHAR(100) NOT NULL,
- last_name VARCHAR(100) NOT NULL,
- email VARCHAR(255),
- phone VARCHAR(50),
- position VARCHAR(100),
- department VARCHAR(100),
- is_primary BOOLEAN DEFAULT FALSE,
- notes TEXT,
- created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
- updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- FOREIGN KEY (client_id) REFERENCES clients(id) ON DELETE CASCADE,
- INDEX idx_client_id (client_id),
- INDEX idx_name (first_name, last_name),
- INDEX idx_email (email)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
