🚀 KALINK - Enterprise Level Specifications v2.0

// users table (Main) CREATE TABLE users ( id UUID PRIMARY KEY, email VARCHAR UNIQUE NOT NULL, password_hash VARCHAR, role ENUM('provider', 'business_partner', 'manager', 'assistant', 'admin'), status ENUM('active', 'pending_verification', 'inactive', 'suspended'), created_at TIMESTAMP, updated_at TIMESTAMP, last_login TIMESTAMP, sso_provider VARCHAR, // 'google', 'microsoft', null sso_id VARCHAR ); // user_profiles table CREATE TABLE user_profiles ( id UUID PRIMARY KEY, user_id UUID FOREIGN KEY, first_name VARCHAR, last_name VARCHAR, phone VARCHAR, location_state VARCHAR, location_city VARCHAR, location_zip VARCHAR, location_coordinates GEOMETRY, bio TEXT, profile_photo_url VARCHAR, verified_at TIMESTAMP, verified_by_admin_id UUID, version_number INT, created_at TIMESTAMP, updated_at TIMESTAMP ); // user_credentials table (License, Insurance, CEU) CREATE TABLE user_credentials ( id UUID PRIMARY KEY, user_id UUID FOREIGN KEY, credential_type ENUM('license', 'dea', 'insurance', 'ceu', 'business_license'), credential_value VARCHAR, issued_date DATE, expires_date DATE, issuing_authority VARCHAR, verified BOOLEAN, verification_source VARCHAR, reminder_sent_90_days BOOLEAN, reminder_sent_60_days BOOLEAN, reminder_sent_30_days BOOLEAN, created_at TIMESTAMP, updated_at TIMESTAMP ); // audit_log table (For all changes) CREATE TABLE audit_log ( id UUID PRIMARY KEY, user_id UUID FOREIGN KEY, changed_by_user_id UUID FOREIGN KEY, entity_type VARCHAR, // 'user_profile', 'credential', etc. entity_id UUID, field_name VARCHAR, old_value VARCHAR, new_value VARCHAR, change_reason VARCHAR, ip_address VARCHAR, user_agent VARCHAR, created_at TIMESTAMP ); // team_members table (Assistant delegation) CREATE TABLE team_members ( id UUID PRIMARY KEY, provider_user_id UUID FOREIGN KEY, assistant_user_id UUID FOREIGN KEY, permissions JSON, // {view, create, edit, delete} active BOOLEAN, invited_at TIMESTAMP, joined_at TIMESTAMP, revoked_at TIMESTAMP );