-- Books Table DESCRIBE books; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra book_id int(11) NO PRI NULL auto_increment book_name varchar(255) NO NULL user_id int(11) NO MUL NULL business_id int(11) NO MUL NULL amount decimal(10,2) NO 0.00 created_date datetime NO NULL updated_date datetime YES NULL Query results operations Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation Your SQL query has been executed successfully. -- Book Members Table DESCRIBE book_members; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment book_id int(11) NO MUL NULL user_id int(11) NO MUL NULL role_id int(11) NO MUL NULL added_by int(11) NO MUL NULL added_date datetime NO current_timestamp() Query results operations Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation Your SQL query has been executed successfully. -- Businesses Table DESCRIBE businesses; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra business_id int(11) NO PRI NULL auto_increment business_name varchar(255) NO NULL user_id int(11) NO MUL NULL created_date datetime NO NULL updated_date datetime YES NULL is_default tinyint(1) YES 0 Query results operations Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation Your SQL query has been executed successfully. -- Business Members Table DESCRIBE business_members; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment business_id int(11) NO MUL NULL user_id int(11) NO MUL NULL role_id int(11) NO MUL NULL added_by int(11) NO MUL NULL added_date timestamp NO current_timestamp() status enum('active','pending','invited') YES active Query results operations Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation Your SQL query has been executed successfully. -- Invitations Table DESCRIBE invitations; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment business_id int(11) NO MUL NULL email varchar(255) YES NULL phone varchar(20) YES NULL role_id int(11) NO MUL NULL invited_by int(11) NO MUL NULL invited_date timestamp NO current_timestamp() status enum('pending','accepted','expired') YES pending token varchar(255) NO NULL expires_at timestamp YES NULL Query results operations Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation Your SQL query has been executed successfully. -- Member Roles Table DESCRIBE member_roles; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment role_name varchar(50) NO NULL permissions text YES NULL created_at timestamp NO current_timestamp() Query results operations Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation Your SQL query has been executed successfully. -- Pending Users Table DESCRIBE pending_users; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment full_name varchar(255) NO NULL email varchar(255) NO UNI NULL phone varchar(20) NO NULL password varchar(255) NO NULL verification_token varchar(100) NO NULL created_at timestamp NO current_timestamp() Query results operations Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation Your SQL query has been executed successfully. -- Shared Businesses Table DESCRIBE shared_businesses; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra shared_id int(11) NO PRI NULL auto_increment business_id int(11) NO MUL NULL user_id int(11) NO MUL NULL shared_date datetime YES current_timestamp() Query results operations Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation Your SQL query has been executed successfully. -- Subscription Plans Table DESCRIBE subscription_plans; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment name varchar(100) NO NULL price_monthly decimal(10,2) NO NULL price_yearly decimal(10,2) NO NULL allows_reports tinyint(1) YES 0 max_businesses int(11) YES 1 max_members int(11) YES 1 min_books int(11) YES 0 max_books int(11) YES NULL description text YES NULL created_at timestamp NO current_timestamp() allows_transactions tinyint(1) YES 1 Query results operations Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation Your SQL query has been executed successfully. -- Transactions Table DESCRIBE transactions; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment book_id int(11) NO MUL NULL user_id int(11) NO MUL NULL business_id int(11) NO MUL NULL amount decimal(15,2) NO NULL description text YES NULL type enum('cash_in','cash_out') NO NULL created_date datetime NO current_timestamp() Query results operations Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation Your SQL query has been executed successfully. -- Users Table DESCRIBE users; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment full_name varchar(150) YES NULL email varchar(100) NO UNI NULL phone varchar(20) YES NULL password varchar(255) NO NULL api_token varchar(255) YES NULL token_created datetime YES NULL verification_token varchar(100) NO NULL is_verified tinyint(1) NO 0 created_at timestamp NO current_timestamp() Query results operations Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation Your SQL query has been executed successfully. -- User Subscriptions Table DESCRIBE user_subscriptions; [ Edit inline ] [ Edit ] [ Create PHP code ] Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment user_id int(11) NO MUL NULL plan_id int(11) NO MUL NULL subscription_type enum('monthly','yearly') NO NULL start_date date NO NULL end_date date NO NULL status enum('active','canceled','expired') YES active stripe_subscription_id varchar(255) YES NULL created_at timestamp NO current_timestamp() transaction_id varchar(100) YES NULL payment_method varchar(50) YES NULL amount decimal(10,2) YES NULL period varchar(10) YES NULL updated_at timestamp NO current_timestamp() on update current_timestamp() Query results operations