myProject.sql (nebeans)

CREATE TABLE NBUSER.memoryAll
(
    memoryID           INT NOT NULL
                       PRIMARY KEY GENERATED ALWAYS AS IDENTITY
                       (START WITH 1, INCREMENT BY 1),
    memoryName         VARCHAR(255)
);

CREATE TABLE NBUSER.memoryMoment
(
memoryMomentID         INT NOT NULL
                       PRIMARY KEY GENERATED ALWAYS AS IDENTITY
                       (START WITH 1, INCREMENT BY 1),
memoryMomentDate       DATE NOT NULL,
memoryMomentTime       TIME NOT NULL,
memoryID               INT ,
FOREIGN KEY (memoryID) REFERENCES memoryAll(memoryID)
                       ON DELETE SET NULL
);

CREATE TABLE NBUSER.memoryPlace
(
memoryPlaceID         INT NOT NULL
                      PRIMARY KEY GENERATED ALWAYS AS IDENTITY
                      (START WITH 1, INCREMENT BY 1),
memoryPlaceName       VARCHAR(255) NOT NULL,
memoryID              INT,
FOREIGN KEY(memoryID) REFERENCES memoryAll(memoryID)
                      ON DELETE SET NULL
);

CREATE TABLE NBUSER.memoryDescription
(
memoryDescriptionID   INT NOT NULL
                      PRIMARY KEY GENERATED ALWAYS AS IDENTITY
                      (START WITH 1, INCREMENT BY 1),
memoryDescriptionFull VARCHAR(255) NOT NULL,
memoryID              INT,
FOREIGN KEY(memoryID) REFERENCES memoryAll(memoryID)
                      ON DELETE SET NULL
);

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

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

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

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