|
1
|
use socle;
|
|
2
|
|
|
3
|
CREATE TABLE delivery_note (
|
|
4
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
5
|
provider VARCHAR(255) NOT NULL,
|
|
6
|
airport VARCHAR(255) NOT NULL,
|
|
7
|
terminal VARCHAR(255) NOT NULL,
|
|
8
|
date DATETIME NOT NULL,
|
|
9
|
bagsNumber VARCHAR(255) NOT NULL,
|
|
10
|
fileId INT NULL,
|
|
11
|
createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
12
|
updatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
13
|
FOREIGN KEY (fileId) REFERENCES files(id) ON DELETE CASCADE ON UPDATE CASCADE
|
|
14
|
|
|
15
|
);
|
|
16
|
|
|
17
|
-- Create DeliveryBag table
|
|
18
|
CREATE TABLE delivery_bag (
|
|
19
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
20
|
ahl VARCHAR(255) NOT NULL,
|
|
21
|
passenger VARCHAR(255) NOT NULL,
|
|
22
|
address VARCHAR(255) NOT NULL,
|
|
23
|
mainPhone VARCHAR(255) NOT NULL,
|
|
24
|
secondPhone VARCHAR(255) NULL,
|
|
25
|
color VARCHAR(255) NULL,
|
|
26
|
route VARCHAR(255) NULL,
|
|
27
|
tag VARCHAR(255) NULL,
|
|
28
|
ld01 VARCHAR(255) NULL,
|
|
29
|
ld02 VARCHAR(255) NULL,
|
|
30
|
bagsNumber VARCHAR(255) NULL,
|
|
31
|
fileId INT NULL,
|
|
32
|
deliveryNotesId INT,
|
|
33
|
FOREIGN KEY (deliveryNotesId) REFERENCES delivery_note(id) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
34
|
FOREIGN KEY (fileId) REFERENCES files(id) ON DELETE CASCADE ON UPDATE CASCADE
|
|
35
|
);
|