User_popups

CREATE TABLE user_popups ( id BIGINT PRIMARY KEY AUTO_INCREMENT, useridx BIGINT NOT NULL UNIQUE, free15 TINYINT(1) DEFAULT 1, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX idx_useridx (useridx) ); CREATE TABLE user_notify_logs ( id BIGINT PRIMARY KEY AUTO_INCREMENT, useridx BIGINT NOT NULL, free15_d7 TINYINT(1) DEFAULT 0 COMMENT '15일 무료체험 D-7 알림 전송 여부 (0: 미전송, 1: 전송완료)', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, UNIQUE KEY unique_useridx (useridx), INDEX idx_free15_d7 (free15_d7) );