Starting database check... Table: active_timer_sessions ---------------- Column: id, Type: int(11) Column: attorney_id, Type: int(11) Column: client_id, Type: int(11) Column: description, Type: text Column: start_time, Type: timestamp Column: elapsed_seconds, Type: int(11) Column: session_key, Type: varchar(100) Column: last_updated, Type: timestamp Column: entry_id, Type: int(11) Column: created_at, Type: timestamp Table: attorneys ---------------- Column: id, Type: int(11) Column: name, Type: varchar(100) Column: email, Type: varchar(100) Column: password_hash, Type: varchar(255) Column: hourly_rate, Type: decimal(10,2) Column: status, Type: enum('active','inactive') Column: created_at, Type: timestamp Column: updated_at, Type: timestamp Table: billing_records ---------------- Column: id, Type: int(11) Column: stripe_invoice_id, Type: varchar(255) Column: payment_intent, Type: varchar(255) Column: stripe_customer_id, Type: varchar(255) Column: client_id, Type: int(11) Column: total_amount, Type: decimal(10,2) Column: billed_amount, Type: decimal(10,2) Column: status, Type: enum('draft','sent','paid','void','payment_failed') Column: billing_date, Type: date Column: due_date, Type: date Column: notes, Type: text Column: created_at, Type: timestamp Column: updated_at, Type: timestamp Column: is_retainer_request, Type: tinyint(1) Column: deleted, Type: tinyint(1) Column: archived, Type: tinyint(1) Column: rolled_over_to, Type: int(11) Table: client_progress ---------------- Column: id, Type: int(11) Column: client_id, Type: int(11) Column: waiting_for, Type: enum('Albert','Katrina','Court','Client','OC') Column: task, Type: text Column: time_sensitive, Type: tinyint(1) Column: last_updated, Type: timestamp Column: notes, Type: text Table: clients ---------------- Column: id, Type: int(11) Column: first_name, Type: varchar(50) Column: last_name, Type: varchar(50) Column: url_name, Type: varchar(255) Column: email, Type: varchar(100) Column: phone, Type: varchar(20) Column: address, Type: text Column: hourly_rate, Type: decimal(10,2) Column: retainer_balance, Type: decimal(10,2) Column: standard_retainer_amount, Type: decimal(10,2) Column: notes, Type: text Column: created_at, Type: timestamp Column: updated_at, Type: timestamp Column: stripe_customer_id, Type: varchar(100) Column: billing_email, Type: varchar(255) Column: payment_method_id, Type: varchar(100) Column: last_invoice_date, Type: date Column: current_balance, Type: decimal(10,2) Column: archived, Type: tinyint(1) Column: last_billed_date, Type: date Column: auto_bill, Type: tinyint(1) Column: billing_threshold, Type: decimal(10,2) Table: deadlines ---------------- Column: id, Type: int(11) Column: client_id, Type: int(11) Column: title, Type: varchar(255) Column: due_date, Type: date Column: notes, Type: text Column: created_at, Type: datetime Column: updated_at, Type: datetime Column: deleted_at, Type: datetime Table: efile_links ---------------- Column: id, Type: int(11) Column: client_id, Type: int(11) Column: link_url, Type: varchar(255) Column: websurrogate_url, Type: varchar(255) Column: link_description, Type: varchar(100) Column: created_at, Type: timestamp Column: updated_at, Type: timestamp Table: email_log ---------------- Column: id, Type: int(11) Column: invoice_id, Type: varchar(50) Column: email_type, Type: enum('invoice_sent','payment_confirmation','reminder') Column: sent_at, Type: datetime Column: status, Type: varchar(50) Column: error_message, Type: text Table: expense_entries ---------------- Column: id, Type: int(11) Column: client_id, Type: int(11) Column: description, Type: text Column: amount, Type: decimal(10,2) Column: date, Type: date Column: status, Type: enum('active','billed','void') Column: billing_record_id, Type: int(11) Column: stripe_invoice_id, Type: varchar(255) Column: created_at, Type: timestamp Column: updated_at, Type: timestamp Table: expenses ---------------- Column: id, Type: int(11) Column: client_id, Type: int(11) Column: expense_date, Type: date Column: amount, Type: decimal(10,2) Column: description, Type: text Column: billing_record_id, Type: int(11) Column: status, Type: enum('active','billed','void') Column: created_at, Type: timestamp Column: updated_at, Type: timestamp Table: invoice_retainer_applications ---------------- Column: id, Type: int(11) Column: invoice_id, Type: int(11) Column: retainer_amount_applied, Type: decimal(10,2) Column: retainer_balance_before, Type: decimal(10,2) Column: retainer_balance_after, Type: decimal(10,2) Column: created_at, Type: timestamp Table: notes ---------------- Column: id, Type: int(11) Column: client_id, Type: int(11) Column: note_text, Type: text Column: created_at, Type: timestamp Column: updated_at, Type: timestamp Column: created_by, Type: int(11) Column: is_private, Type: tinyint(1) Table: progress_history ---------------- Column: id, Type: int(11) Column: progress_id, Type: int(11) Column: task, Type: text Column: date_added, Type: timestamp Table: progress_items ---------------- Column: id, Type: int(11) Column: client_id, Type: int(11) Column: waiting_for, Type: enum('Albert','Katrina','Court','Client','OC') Column: task, Type: text Column: time_sensitive, Type: tinyint(1) Column: date_added, Type: timestamp Column: status, Type: enum('active','completed') Column: notes, Type: text Table: retainer_balance_snapshots ---------------- Column: id, Type: int(11) Column: client_id, Type: int(11) Column: balance, Type: decimal(10,2) Column: as_of_date, Type: date Column: created_at, Type: timestamp Table: retainer_entries ---------------- Column: id, Type: int(11) Column: client_id, Type: int(11) Column: amount, Type: decimal(10,2) Column: date, Type: date Column: memo, Type: text Column: created_at, Type: timestamp Column: updated_at, Type: timestamp Table: time_entries ---------------- Column: id, Type: int(11) Column: client_id, Type: int(11) Column: attorney_id, Type: int(11) Column: description, Type: text Column: date, Type: date Column: end_time, Type: timestamp Column: duration, Type: decimal(10,2) Column: amount, Type: decimal(10,2) Column: billing_record_id, Type: int(11) Column: stripe_invoice_id, Type: varchar(255) Column: status, Type: enum('active','billed','void') Column: created_at, Type: timestamp Column: updated_at, Type: timestamp Detailed check of time_entries table: -------------------------------- Array ( [Field] => id [Type] => int(11) [Null] => NO [Key] => PRI [Default] => [Extra] => auto_increment ) Array ( [Field] => client_id [Type] => int(11) [Null] => NO [Key] => MUL [Default] => [Extra] => ) Array ( [Field] => attorney_id [Type] => int(11) [Null] => NO [Key] => MUL [Default] => [Extra] => ) Array ( [Field] => description [Type] => text [Null] => NO [Key] => [Default] => [Extra] => ) Array ( [Field] => date [Type] => date [Null] => NO [Key] => [Default] => [Extra] => ) Array ( [Field] => end_time [Type] => timestamp [Null] => YES [Key] => [Default] => [Extra] => ) Array ( [Field] => duration [Type] => decimal(10,2) [Null] => YES [Key] => [Default] => 0.00 [Extra] => ) Array ( [Field] => amount [Type] => decimal(10,2) [Null] => YES [Key] => [Default] => 0.00 [Extra] => ) Array ( [Field] => billing_record_id [Type] => int(11) [Null] => YES [Key] => MUL [Default] => [Extra] => ) Array ( [Field] => stripe_invoice_id [Type] => varchar(255) [Null] => YES [Key] => [Default] => [Extra] => ) Array ( [Field] => status [Type] => enum('active','billed','void') [Null] => YES [Key] => MUL [Default] => active [Extra] => ) Array ( [Field] => created_at [Type] => timestamp [Null] => NO [Key] => [Default] => current_timestamp() [Extra] => ) Array ( [Field] => updated_at [Type] => timestamp [Null] => NO [Key] => [Default] => current_timestamp() [Extra] => on update current_timestamp() )