Популярные варианты названий sql таблиц и их столбцов

Популярные варианты названий sql таблиц и их столбцов SHOW CREATE TABLE users Users Products Orders Sections Payments Transactions Tickets Events Subscriptions Posts Comments Tags Logs Customers Employees Categories Suppliers Invoices Shipments Reviews Inventory seo_title varchar(255) NULL seo_description varchar(255) NULL seo_h1 varchar(255) NULL ## Столбцы CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `family_name` varchar(128) DEFAULT NULL, `name` varchar(128) DEFAULT NULL, `middle_name` varchar(128) DEFAULT NULL, `description` text, `birth_date` date DEFAULT NULL, `phone` varchar(32) DEFAULT NULL, `email` varchar(64) DEFAULT NULL, `phone_verified_at` datetime DEFAULT NULL, `email_verified_at` datetime DEFAULT NULL, `token` varchar(64) DEFAULT NULL, `password_hash` varchar(64) DEFAULT NULL, `last_login_at` datetime DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `phone_unique` (`phone`), UNIQUE KEY `email_unique` (`email`), KEY `phone_index` (`phone`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE `knows` ( `id` int(11) NOT NULL AUTO_INCREMENT, `author_id` int(11) NOT NULL, `data` text NOT NULL, `format` varchar(16) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `author_id_created_at_unique` (`author_id`,`created_at`), KEY `author_id_created_at_index` (`author_id`,`created_at`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 CREATE TABLE news ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, content TEXT NOT NULL, author_id INT NOT NULL, is_published BIT DEFAULT 0, publication_at DATETIME, ip VARCHAR(32), category VARCHAR(64), tags VARCHAR(255), created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME ON UPDATE CURRENT_TIMESTAMP, deleted_at DATETIME NULL ); CREATE TABLE groups ( id INT PRIMARY KEY AUTO_INCREMENT, code VARCHAR(64) NOT NULL UNIQUE, name VARCHAR(64) NOT NULL, access VARCHAR(64) ); city char 64 address country chat_id char 255 user_id int status_id room event user_id code check_user_id date_check price image_url first_name last_name phone_number postal_code gender role status_id int statuses description price quantity category brand sku order_id product_id customer_id payment_method total_amount discount