CREATE TABLE IF NOT EXISTS mitra_pic (
    id_pic BIGINT AUTO_INCREMENT PRIMARY KEY,
    id_mitra BIGINT NOT NULL,
    nama_pic VARCHAR(150),
    jabatan VARCHAR(100),
    no_hp VARCHAR(50),
    email VARCHAR(150),
    is_primary TINYINT(1) DEFAULT 0,
    created_at TIMESTAMP NULL,
    updated_at TIMESTAMP NULL,
    INDEX idx_mitra_pic_id_mitra (id_mitra),
    INDEX idx_mitra_pic_primary (id_mitra, is_primary)
);
