« Back to History
activity_logs.sql
|
20260722_120325.php
Initial Domain Snapshot
Copy Code
CREATE TABLE IF NOT EXISTS activity_logs ( id BIGINT PRIMARY KEY AUTO_INCREMENT, company_id BIGINT NOT NULL DEFAULT 0, user_id BIGINT NOT NULL DEFAULT 0, module VARCHAR(100) NOT NULL, action_name VARCHAR(50) NOT NULL, entity_type VARCHAR(100) NOT NULL, entity_id VARCHAR(100) DEFAULT '', remarks TEXT, ip_address VARCHAR(100) DEFAULT '', user_agent VARCHAR(500) DEFAULT '', created_at DATETIME NOT NULL, KEY idx_company (company_id), KEY idx_user (user_id), KEY idx_action (action_name), KEY idx_entity (entity_type), KEY idx_created (created_at) );