[sql] ыы
Viewer
- CREATE DATABASE `всав`;
- CREATE TABLE Technologist (
- id INT AUTO_INCREMENT PRIMARY KEY,
- name VARCHAR(50),
- specifications TEXT
- );
- CREATE TABLE Dispatcher (
- id INT AUTO_INCREMENT PRIMARY KEY,
- name VARCHAR(50),
- sales_plan TEXT
- );
- CREATE TABLE AssemblyMaster (
- id INT AUTO_INCREMENT PRIMARY KEY,
- name VARCHAR(50),
- order_status VARCHAR(50)
- );
- CREATE TABLE WorkshopMaster (
- id INT AUTO_INCREMENT PRIMARY KEY,
- name VARCHAR(50)
- );
- CREATE TABLE ORDER (
- id INT AUTO_INCREMENT PRIMARY KEY,
- NUMBER VARCHAR(50),
- STATUS VARCHAR(50),
- dispatcher_id INT,
- assembly_master_id INT,
- FOREIGN KEY (dispatcher_id) REFERENCES Dispatcher(id),
- FOREIGN KEY (assembly_master_id) REFERENCES AssemblyMaster(id)
- );
- CREATE TABLE Specification (
- id INT AUTO_INCREMENT PRIMARY KEY,
- name VARCHAR(50),
- description TEXT,
- technologist_id INT,
- FOREIGN KEY (technologist_id) REFERENCES Technologist(id)
- );
- CREATE TABLE SalesPlan (
- id INT AUTO_INCREMENT PRIMARY KEY,
- sales_data TEXT,
- dispatcher_id INT,
- FOREIGN KEY (dispatcher_id) REFERENCES Dispatcher(id)
- );
- CREATE TABLE Component (
- id INT AUTO_INCREMENT PRIMARY KEY,
- name VARCHAR(50),
- quantity INT
- );
- CREATE TABLE OrderComponent (
- order_id INT,
- component_id INT,
- quantity INT,
- PRIMARY KEY (order_id, component_id),
- FOREIGN KEY (order_id) REFERENCES ORDER(id),
- FOREIGN KEY (component_id) REFERENCES Component(id)
- );
Editor
You can edit this paste and save as new: