modified diary

CREATE DATABASE diary;

USE diary;

CREATE TABLE memoryAll
(
    memoryID           INT PRIMARY KEY IDENTITY(1,1),
    memoryName         VARCHAR(MAX)
);

CREATE TABLE memoryMoment
(
memoryMomentID         INT PRIMARY KEY IDENTITY(1,1),
memoryMomentDate       VARCHAR(MAX),
memoryMomentTime       VARCHAR(MAX),
memoryID               INT ,
FOREIGN KEY (memoryID) REFERENCES memoryAll(memoryID)
                       ON DELETE SET NULL
                       ON UPDATE CASCADE
);

CREATE TABLE memoryPlace
(
memoryPlaceID         INT PRIMARY KEY IDENTITY(1,1),
memoryPlaceName       VARCHAR(MAX) NOT NULL,
memoryID              INT,
FOREIGN KEY(memoryID) REFERENCES memoryAll(memoryID)
                      ON DELETE SET NULL
                      ON UPDATE CASCADE
);

CREATE TABLE memoryDescription
(
memoryDescriptionID   INT PRIMARY KEY IDENTITY(1,1),
memoryDescriptionFull VARCHAR(MAX) NOT NULL,
memoryID              INT,
FOREIGN KEY(memoryID) REFERENCES memoryAll(memoryID)
                      ON DELETE SET NULL
                      ON UPDATE CASCADE
);

INSERT INTO memoryAll(memoryName)
VALUES('new pet');
INSERT INTO memoryAll(memoryName)
VALUES('gift received');
INSERT INTO memoryAll(memoryName)
VALUES('new mobile');

INSERT INTO memoryMoment(memoryMomentDate,memoryMomentTime,memoryID)
VALUES('2016-12-19','12:30:14',1);
INSERT INTO memoryMoment(memoryMomentDate,memoryMomentTime,memoryID)
VALUES('2017-1-1','2:30:14',2);
INSERT INTO memoryMoment(memoryMomentDate,memoryMomentTime,memoryID)
VALUES('2016-12-31','1:30:14',3);

INSERT INTO memoryPlace(memoryPlaceName,memoryID)
VALUES('DHAKA',1);
INSERT INTO memoryPlace(memoryPlaceName,memoryID)
VALUES('RANGPUR',2);
INSERT INTO memoryPlace(memoryPlaceName,memoryID)
VALUES('BARISHAL',3);

INSERT INTO memoryDescription(memoryDescriptionFull,memoryID)
VALUES('I have bought a new white cat',1);
INSERT INTO memoryDescription(memoryDescriptionFull,memoryID)
VALUES('one of my best friends have sent me a black whiteboard marker',2);
INSERT INTO memoryDescription(memoryDescriptionFull,memoryID)
VALUES('I have bought a new samsung galaxy note IV',3);