Популярные варианты названий sql таблиц и их столбцов
Популярные варианты названий sql таблиц и их столбцов
Users
Products
Orders
Sections
Payments
Transactions
Tickets
Events
Subscriptions
Posts
Comments
Tags
Logs
Customers
Employees
Categories
Suppliers
Invoices
Shipments
Reviews
Inventory
## Столбцы
CREATE TABLE users (
id INT(11) AUTO_INCREMENT PRIMARY KEY,
groups CHAR(16) NULL,
family_name VARCHAR(128) NULL,
name VARCHAR(128) NULL,
middle_name VARCHAR(128) NULL,
birth_date DATE NULL,
phone CHAR(32) NULL,
email VARCHAR(64) NULL,
city CHAR(64) NULL,
password VARCHAR(128) NOT NULL,
key VARCHAR(255) NOT NULL,
code CHAR(32),
ip VARCHAR(32) NULL,
type_login CHAR(16),
last_login DATETIME
created_at DATETIME,
updated_at DATETIME,
deleted_at DATETIME NULL
);
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