SQL_DUMP.sql

/*
 Navicat Premium Data Transfer

 Source Server         : Nahian
 Source Server Type    : Oracle
 Source Server Version : 190000
 Source Host           : localhost:1521
 Source Schema         : C##NAHIAN

 Target Server Type    : Oracle
 Target Server Version : 190000
 File Encoding         : 65001

 Date: 25/02/2022 20:32:59
*/


-- ----------------------------
-- Table structure for ACHIEVEMENT
-- ----------------------------
DROP TABLE "C##NAHIAN"."ACHIEVEMENT";
CREATE TABLE "C##NAHIAN"."ACHIEVEMENT" (
  "TITLE" VARCHAR2(30 BYTE) VISIBLE NOT NULL,
  "SUMMARY" VARCHAR2(50 BYTE) VISIBLE NOT NULL,
  "REWARD_POINTS" NUMBER VISIBLE NOT NULL,
  "TOTAL_STEPS" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of ACHIEVEMENT
-- ----------------------------
INSERT INTO "C##NAHIAN"."ACHIEVEMENT" VALUES ('Digital Dilemma', 'Buy 50 products from IC Category', '50000', '50');
INSERT INTO "C##NAHIAN"."ACHIEVEMENT" VALUES ('PC Master Race', 'Buy 1 Desktop Computer', '100000', '1');
INSERT INTO "C##NAHIAN"."ACHIEVEMENT" VALUES ('Rough Hands', 'Buy 5 Electrical Machines', '7500', '5');
INSERT INTO "C##NAHIAN"."ACHIEVEMENT" VALUES ('I,Robot', 'Purchase 10 Robotics supplies', '150000', '10');
INSERT INTO "C##NAHIAN"."ACHIEVEMENT" VALUES ('Metal Massacre', 'Buy a gun', '120000', '1');
INSERT INTO "C##NAHIAN"."ACHIEVEMENT" VALUES ('Social Butterfly', 'Make your first comment', '10000', '1');

-- ----------------------------
-- Table structure for ADMIN
-- ----------------------------
DROP TABLE "C##NAHIAN"."ADMIN";
CREATE TABLE "C##NAHIAN"."ADMIN" (
  "USER_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of ADMIN
-- ----------------------------
INSERT INTO "C##NAHIAN"."ADMIN" VALUES ('Nahian');
INSERT INTO "C##NAHIAN"."ADMIN" VALUES ('admin');

-- ----------------------------
-- Table structure for ASSEMBLER
-- ----------------------------
DROP TABLE "C##NAHIAN"."ASSEMBLER";
CREATE TABLE "C##NAHIAN"."ASSEMBLER" (
  "USER_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of ASSEMBLER
-- ----------------------------
INSERT INTO "C##NAHIAN"."ASSEMBLER" VALUES ('asmblr');
INSERT INTO "C##NAHIAN"."ASSEMBLER" VALUES ('assembler2');

-- ----------------------------
-- Table structure for CATEGORY
-- ----------------------------
DROP TABLE "C##NAHIAN"."CATEGORY";
CREATE TABLE "C##NAHIAN"."CATEGORY" (
  "CATEGORY_ID" NUMBER VISIBLE DEFAULT "C##NAHIAN"."ISEQ$$_77361".nextval NOT NULL,
  "CATEGORY_NAME" VARCHAR2(100 BYTE) VISIBLE NOT NULL,
  "DESCRIPTION" VARCHAR2(500 BYTE) VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of CATEGORY
-- ----------------------------
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('143', 'Processor', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('141', 'Tablet', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('142', 'Monitor', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('144', 'Graphics Card', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('145', 'SSD', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('146', 'RAM', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('147', 'Motherboard', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('148', 'Printer', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('149', 'Camera', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('150', 'Router', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('151', 'Keyboard', 'keyboards are a great way for input!');
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('152', 'Mouse', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('153', 'Television', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('154', 'Electrical Components', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('161', 'Electronics', 'everything related to electronics');
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('34', 'Electrical Machinery', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('32', 'IC', 'Integrated Circuit Chips');
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('33', 'Robotics', 'A robot is an automated machine');
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('35', 'Laptop', 'Modern portable computers');
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('121', 'Smartphone', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('37', 'Experimental Weapons', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('101', 'Desktop', 'Mounted Computer');
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('61', 'Wires', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('81', 'Microphone', NULL);
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('36', 'Microcontroller', 'A microcontroller (MCU for microcontroller unit) is a small computer on a single metal-oxide-semiconductor (MOS) integrated circuit (IC) chip');
INSERT INTO "C##NAHIAN"."CATEGORY" VALUES ('41', 'Software', '111101 1001 1111001 10011');

-- ----------------------------
-- Table structure for CLIENT
-- ----------------------------
DROP TABLE "C##NAHIAN"."CLIENT";
CREATE TABLE "C##NAHIAN"."CLIENT" (
  "USER_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
  "REWARD_POINTS" NUMBER VISIBLE DEFAULT 0 NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of CLIENT
-- ----------------------------
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('Walter', '220000');
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('Sherlock', '10000');
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('NahianShabab', '0');
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('parisha', '100000');
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('Gus', '10000');
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('NewUser', '0');
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('Fahad', '0');
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('Shabab', '27500');
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('Shihan', '0');
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('Watson', '0');
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('Nahian_Shabab', '100000');
INSERT INTO "C##NAHIAN"."CLIENT" VALUES ('ShihanDarkStar', '0');

-- ----------------------------
-- Table structure for CLIENT_ACHIEVEMENT
-- ----------------------------
DROP TABLE "C##NAHIAN"."CLIENT_ACHIEVEMENT";
CREATE TABLE "C##NAHIAN"."CLIENT_ACHIEVEMENT" (
  "TITLE" VARCHAR2(30 BYTE) VISIBLE NOT NULL,
  "CLIENT_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
  "CLAIMED" NUMBER VISIBLE DEFAULT 0 NOT NULL,
  "ACQUIRED_STEPS" NUMBER VISIBLE DEFAULT 0 NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of CLIENT_ACHIEVEMENT
-- ----------------------------
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Social Butterfly', 'parisha', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Digital Dilemma', 'Nahian_Shabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('I,Robot', 'Nahian_Shabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Metal Massacre', 'Nahian_Shabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('PC Master Race', 'Nahian_Shabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Rough Hands', 'Nahian_Shabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Digital Dilemma', 'NewUser', '0', '13');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('I,Robot', 'NewUser', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Metal Massacre', 'NewUser', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('PC Master Race', 'NewUser', '0', '1');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Rough Hands', 'NewUser', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Social Butterfly', 'NewUser', '0', '1');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('I,Robot', 'Shabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Metal Massacre', 'Shabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Rough Hands', 'Shabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Social Butterfly', 'Gus', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Social Butterfly', 'Watson', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Digital Dilemma', 'parisha', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('I,Robot', 'parisha', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Metal Massacre', 'parisha', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('PC Master Race', 'parisha', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Rough Hands', 'parisha', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Digital Dilemma', 'Shabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Social Butterfly', 'Walter', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Digital Dilemma', 'NahianShabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('I,Robot', 'NahianShabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Metal Massacre', 'NahianShabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('PC Master Race', 'NahianShabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Rough Hands', 'NahianShabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Social Butterfly', 'Shabab', '0', '1');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('PC Master Race', 'Shabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Digital Dilemma', 'Watson', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('I,Robot', 'Watson', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Metal Massacre', 'Watson', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('PC Master Race', 'Watson', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Rough Hands', 'Watson', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Digital Dilemma', 'Walter', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Metal Massacre', 'Walter', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Rough Hands', 'Walter', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('PC Master Race', 'Walter', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('I,Robot', 'Walter', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Social Butterfly', 'ShihanDarkStar', '0', '1');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Digital Dilemma', 'ShihanDarkStar', '0', '5');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('I,Robot', 'ShihanDarkStar', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Metal Massacre', 'ShihanDarkStar', '0', '1');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('PC Master Race', 'ShihanDarkStar', '0', '1');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Rough Hands', 'ShihanDarkStar', '0', '2');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Social Butterfly', 'Sherlock', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Digital Dilemma', 'Gus', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Metal Massacre', 'Gus', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('I,Robot', 'Gus', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('PC Master Race', 'Gus', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Rough Hands', 'Gus', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Social Butterfly', 'NahianShabab', '0', '0');
INSERT INTO "C##NAHIAN"."CLIENT_ACHIEVEMENT" VALUES ('Social Butterfly', 'Nahian_Shabab', '0', '0');

-- ----------------------------
-- Table structure for CLIENT_CART
-- ----------------------------
DROP TABLE "C##NAHIAN"."CLIENT_CART";
CREATE TABLE "C##NAHIAN"."CLIENT_CART" (
  "CLIENT_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
  "ITEM_ID" NUMBER VISIBLE NOT NULL,
  "QUANTITY" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of CLIENT_CART
-- ----------------------------
INSERT INTO "C##NAHIAN"."CLIENT_CART" VALUES ('Fahad', '151', '5');
INSERT INTO "C##NAHIAN"."CLIENT_CART" VALUES ('Shihan', '152', '5');
INSERT INTO "C##NAHIAN"."CLIENT_CART" VALUES ('Shabab', '144', '1');
INSERT INTO "C##NAHIAN"."CLIENT_CART" VALUES ('Shabab', '152', '6');
INSERT INTO "C##NAHIAN"."CLIENT_CART" VALUES ('Fahad', '143', '3');

-- ----------------------------
-- Table structure for COMMENT
-- ----------------------------
DROP TABLE "C##NAHIAN"."COMMENT";
CREATE TABLE "C##NAHIAN"."COMMENT" (
  "COMMENT_ID" NUMBER VISIBLE DEFAULT "C##NAHIAN"."ISEQ$$_78053".nextval NOT NULL,
  "COMMENT_DATE" NUMBER VISIBLE NOT NULL,
  "TEXT" VARCHAR2(500 BYTE) VISIBLE NOT NULL,
  "COMMENTOR" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
  "COMMENT_PRODUCT_ID" NUMBER VISIBLE NOT NULL,
  "PARENT_COMMENT" NUMBER VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of COMMENT
-- ----------------------------
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('61', '1644791990424', 'Haha', 'Shabab', '141', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('28', '1644653426345', 'Because im not a fanboy', 'Shabab', '138', '25');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('29', '1644653440654', 'ikr', 'Shabab', '138', '7');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('63', '1644830311546', 'bac', 'Shabab', '143', '56');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('141', '1645370007141', 'Stop this bs right now -_-', 'Shabab', '152', '102');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('252', '1645662381978', 'hello', 'NahianShabab', '152', '242');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('281', '1645720196359', 'hello', 'parisha', '153', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('282', '1645720909498', 'hello', 'parisha', '152', '261');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('323', '1645798639773', 'hello', 'ShihanDarkStar', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('306', '1645734181871', 'how are you today?', 'Nahian_Shabab', '152', '241');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('322', '1645798619995', 'hiiii', 'ShihanDarkStar', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('327', '1645799245380', 'hahahaha', 'Shabab', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('31', '1644656501308', 'i agree', 'Fahad', '138', '7');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('38', '1644659435984', 'Me too', 'Fahad', '138', '36');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('39', '1644659521111', 'Why apple price so high?', 'Fahad', '138', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('82', '1645023465737', 'ok', 'Shabab', '138', '52');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('104', '1645041449122', 'i got it', 'Shabab', '152', '102');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('108', '1645042489669', 'shut up idiot', 'Fahad', '138', '52');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('109', '1645043193325', 'i hate you', 'Fahad', '138', '52');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('202', '1645542019884', 'hello', 'Sherlock', '138', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('221', '1645586917868', 'Hello', 'Gus', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('222', '1645605490166', 'Hello', 'Shabab', '144', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('223', '1645605497803', 'Hello', 'Shabab', '144', '121');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('5', '1644603390812', 'What is this', 'Fahad', '136', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('6', '1644603399943', 'wdym?', 'Fahad', '136', '4');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('45', '1644659706506', 'haha', 'Fahad', '138', '38');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('36', '1644658186087', 'I love iphone', 'Fahad', '138', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('42', '1644659661041', 'Me neither ', 'Fahad', '138', '28');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('46', '1644659712820', 'Haha', 'Fahad', '138', '45');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('47', '1644659722484', 'Haha', 'Fahad', '138', '46');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('48', '1644659738341', 'Me too', 'Fahad', '138', '38');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('52', '1644662479372', 'I hate IPHONE!!!!', 'Shabab', '138', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('54', '1644735214439', 'How much low do you want?', 'Shabab', '136', '4');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('56', '1644743318095', 'abc', 'Shabab', '143', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('58', '1644743333582', 'abc', 'Shabab', '143', '56');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('206', '1645542804567', 'Hello', 'Walter', '138', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('105', '1645041527044', 'haha', 'Shabab', '152', '104');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('106', '1645041555762', 'ok', 'Shabab', '152', '102');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('225', '1645613898056', 'hello', 'Shabab', '142', '224');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('224', '1645613893461', 'hello', 'Shabab', '142', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('241', '1645653430615', 'hello', 'Shabab', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('242', '1645653440974', 'reply', 'Shabab', '152', '241');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('243', '1645653447334', 'reply', 'Shabab', '152', '242');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('254', '1645662936864', 'hello', 'NahianShabab', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('308', '1645789064419', 'Hello', 'Shabab', '151', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('309', '1645789228897', 'hello', 'Walter', '143', '56');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('321', '1645798609258', 'Hiii', 'ShihanDarkStar', '152', '221');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('329', '1645799440216', 'hello', 'NewUser', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('51', '1644660849594', 'Because they spend millions in R&D', 'Shabab', '138', '39');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('4', '1644601500713', 'Can you lower the price', 'Fahad', '136', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('101', '1645041226814', 'How much voltage can it handle?', 'Shabab', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('7', '1644608514191', 'It''s Overrated', 'Fahad', '138', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('102', '1645041255537', 'It literally says on the specs, 5v', 'Fahad', '152', '101');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('311', '1645790553819', 'Op amp is my favourite', 'ShihanDarkStar', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('261', '1645713391983', 'hello', 'Watson', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('310', '1645790465572', 'hello', 'ShihanDarkStar', '152', '303');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('326', '1645799057380', 'HELLO', 'ShihanDarkStar', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('328', '1645799418249', 'hahhahahha', 'NewUser', '152', '302');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('21', '1644652904633', 'It''s not overrated', 'Shabab', '138', '7');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('25', '1644653028433', 'How do you figure that?', 'Fahad', '138', '21');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('35', '1644657722360', 'I know', 'Fahad', '138', '29');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('107', '1645042419633', 'shut up', 'Fahad', '138', '52');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('85', '1645024572093', 'I know that you know', 'Shabab', '138', '35');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('161', '1645388289056', 'i don''t know', 'Fahad', '152', '101');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('121', '1645204010466', 'hello', 'Shabab', '144', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('162', '1645400627412', 'hello', 'Shabab', '138', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('248', '1645657199235', 'hello', 'NahianShabab', '143', '63');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('204', '1645542382779', 'HELLO', 'Sherlock', '138', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('302', '1645732440538', 'hello world', 'Nahian_Shabab', '152', NULL);
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('246', '1645656106805', 'hello shabab', 'NahianShabab', '152', '243');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('250', '1645661239053', 'hello', 'NahianShabab', '152', '241');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('303', '1645732451413', 'reply', 'Nahian_Shabab', '152', '221');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('305', '1645734116037', 'how are you', 'Nahian_Shabab', '152', '101');
INSERT INTO "C##NAHIAN"."COMMENT" VALUES ('307', '1645734265307', 'how are you today?', 'Nahian_Shabab', '152', '241');

-- ----------------------------
-- Table structure for COMMENT_NOTIFY
-- ----------------------------
DROP TABLE "C##NAHIAN"."COMMENT_NOTIFY";
CREATE TABLE "C##NAHIAN"."COMMENT_NOTIFY" (
  "NOTIFICATION_ID" NUMBER VISIBLE NOT NULL,
  "PRODUCT_ID" NUMBER VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of COMMENT_NOTIFY
-- ----------------------------
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('41', '152');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('188', '152');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('23', '152');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('27', '138');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('24', '152');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('211', '143');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('221', '152');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('212', '152');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('222', '152');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('61', '152');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('22', '152');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('25', '138');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('201', '152');
INSERT INTO "C##NAHIAN"."COMMENT_NOTIFY" VALUES ('210', '152');

-- ----------------------------
-- Table structure for COUNTRY
-- ----------------------------
DROP TABLE "C##NAHIAN"."COUNTRY";
CREATE TABLE "C##NAHIAN"."COUNTRY" (
  "COUNTRY_ID" NUMBER VISIBLE DEFAULT "C##NAHIAN"."ISEQ$$_77351".nextval NOT NULL,
  "COUNTRY_NAME" VARCHAR2(30 BYTE) VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of COUNTRY
-- ----------------------------
INSERT INTO "C##NAHIAN"."COUNTRY" VALUES ('1', 'Bangladesh');

-- ----------------------------
-- Table structure for DELIVERYMAN
-- ----------------------------
DROP TABLE "C##NAHIAN"."DELIVERYMAN";
CREATE TABLE "C##NAHIAN"."DELIVERYMAN" (
  "USER_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of DELIVERYMAN
-- ----------------------------
INSERT INTO "C##NAHIAN"."DELIVERYMAN" VALUES ('ABC');
INSERT INTO "C##NAHIAN"."DELIVERYMAN" VALUES ('delivery');

-- ----------------------------
-- Table structure for DESCRIPT_COMPONENT
-- ----------------------------
DROP TABLE "C##NAHIAN"."DESCRIPT_COMPONENT";
CREATE TABLE "C##NAHIAN"."DESCRIPT_COMPONENT" (
  "TITLE" VARCHAR2(30 BYTE) VISIBLE NOT NULL,
  "DETAILS" VARCHAR2(200 BYTE) VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of DESCRIPT_COMPONENT
-- ----------------------------
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Breakdown Voltage', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Gain', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Turns Ratio', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Rating', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Resolution', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Video Card', ' A video card is an expansion card which generates a feed of output images to a display device (such as a computer monitor).');
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Processor', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Display', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Operating System', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Audio', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Keyboard', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('WebCam', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Wi-Fi', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Bluetooth', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Memory', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('HDMI', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Storage', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Color(s)', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Camera', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Sensors', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('USB', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Aspect Ratio', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Inductance', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Conductance', NULL);
INSERT INTO "C##NAHIAN"."DESCRIPT_COMPONENT" VALUES ('Resistance', NULL);

-- ----------------------------
-- Table structure for DISTRICT
-- ----------------------------
DROP TABLE "C##NAHIAN"."DISTRICT";
CREATE TABLE "C##NAHIAN"."DISTRICT" (
  "DISTRICT_ID" NUMBER VISIBLE DEFAULT "C##NAHIAN"."ISEQ$$_77355".nextval NOT NULL,
  "DISTRICT_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
  "DELIVERY_COST" NUMBER VISIBLE,
  "COUNTRY_ID" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of DISTRICT
-- ----------------------------
INSERT INTO "C##NAHIAN"."DISTRICT" VALUES ('1', 'Dhaka', '60', '1');

-- ----------------------------
-- Table structure for GENERAL_USER
-- ----------------------------
DROP TABLE "C##NAHIAN"."GENERAL_USER";
CREATE TABLE "C##NAHIAN"."GENERAL_USER" (
  "USER_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
  "PASSWORD" VARCHAR2(128 BYTE) VISIBLE NOT NULL,
  "EMAIL" VARCHAR2(320 BYTE) VISIBLE NOT NULL,
  "ADDRESS_DESCRIPTION" VARCHAR2(500 BYTE) VISIBLE,
  "FIRST_NAME" VARCHAR2(15 BYTE) VISIBLE NOT NULL,
  "LAST_NAME" VARCHAR2(15 BYTE) VISIBLE NOT NULL,
  "PHONE_NUMBER" VARCHAR2(20 BYTE) VISIBLE,
  "USER_ROLE" VARCHAR2(15 BYTE) VISIBLE NOT NULL,
  "HAS_ACCOUNT" NUMBER VISIBLE DEFAULT 1 NOT NULL,
  "ACCOUNT_CREATE_DATE" NUMBER VISIBLE DEFAULT 0 NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of GENERAL_USER
-- ----------------------------
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('admin', '$2b$10$W5zErY5ttbqO4iM9bjJBsOPJDw4C1uetN5k3FgbWZnjSpo8XXIVRu', 'admin@gmail.com', NULL, 'admin', 'admin', NULL, 'ADMIN', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('Nahian', '$2b$10$W5zErY5ttbqO4iM9bjJBsOPJDw4C1uetN5k3FgbWZnjSpo8XXIVRu', 'nsnbd134@gmail.com', NULL, 'Nahian', 'Shabab', NULL, 'ADMIN', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('ABC', '$2b$10$EICiq2oWHjv6DWx9XJdhFuRQ9qZJ.9o/010l3e10L1raIQ.y/DfW6', 'abc@gmail.com', NULL, 'ABC', 'DEF', NULL, 'DELIVERY_MAN', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('Walter', '$2b$10$.bOePTaXwKB6/R3fOecabeeTUrM24emI5SaHXi872VY.L1C1PlgMe', 'walter@gmail.com', NULL, 'Walter', 'White', NULL, 'CLIENT', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('delivery', '$2b$10$W5zErY5ttbqO4iM9bjJBsOPJDw4C1uetN5k3FgbWZnjSpo8XXIVRu', 'delivery@gmail.com', NULL, 'DELIVERY', 'MAN', NULL, 'DELIVERY_MAN', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('Sherlock', '$2b$10$BGty9e2PwXyN3S9IpT3Xp.Zz8S74WJy41R/dNYXg9N1aLrRq4w6W.', 'sherlock@gmail.com', NULL, 'Sherlock', 'Holmes', '01333333333', 'CLIENT', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('NahianShabab', '$2b$10$iU1YWyId8.6OvPYpN1QEre17nqd5aBkwnFVazHucn/O7mVkOqW3DW', 'nahianshabab@gmail.com', NULL, 'Nahian', 'Shabab', '01654414841', 'CLIENT', '1', '1645655061236');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('parisha', '$2b$10$jbOD1waFusd6GRHYur4dl.BpFz3eviteNpyx0t5VopD36YCm.5Qrq', 'parisha@gmail.com', NULL, 'lubaba', 'safrin', '01784912811', 'CLIENT', '1', '1645720055718');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('Gus', '$2b$10$pa0PbsS3n4a.tTH4fT0Ho.fWCbfe.d/c4C.mXMZ8h3nIsJQgd4RVy', 'gus@gmail.com', 'Cantonment Stadium', 'Gus', 'Fring', '01795914831', 'CLIENT', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('NewUser', '$2b$10$hgfSq6ppCuF0atpXP/396.25avYB/TvBVfLTGfqXGabwHcqmjHH9a', 'new@gmail.com', NULL, 'New', 'User', '01572912711', 'CLIENT', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('Fahad', '$2b$10$/GLIKJja4AuO.AMFaS2HjOqS.So55y/jHl6pL07H7kL68TztMC1Fi', 'test@gmail.com', NULL, 'Abdullah', 'Fahad', NULL, 'CLIENT', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('Shabab', '$2b$10$SIWs8oMzwoXo0DDNQFVK3edhlSJy0xGfb0.dyLmOp3f2OmDTXXIhq', 'shabab@gmail.com', 'Motijheel City Center NYA Office, Room 234', 'Nahian', 'Shabab', '01784912811', 'CLIENT', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('Shihan', '$2b$10$1zP2LI58gccf.NhxAPRWVuejwgXcrjVLCJPKdZ9pNN.w5LVQx6LUm', 'Shihan@gmail.com', NULL, 'Shihan', 'Shabab', NULL, 'CLIENT', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('assembler2', '$2b$10$0lUwMF6XnEfRgu00un4ZxuGWr4cKK108WIjpcLv7xqb3uhJ1EzvJu', 'assembler2@gmail.com', NULL, 'Assembler', 'Two', NULL, 'ASSEMBLER', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('asmblr', '$2b$10$W5zErY5ttbqO4iM9bjJBsOPJDw4C1uetN5k3FgbWZnjSpo8XXIVRu', 'asmblr@gmail.com', NULL, 'ASM', 'BLR', NULL, 'ASSEMBLER', '1', '0');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('Watson', '$2b$10$TlVYSbaDBFrCgEDPXucXmO6h0wJ/dk4PhfKm9XInzAaGxWmNYZ46a', 'watson@gmail.com', NULL, 'John', 'Watson', '01583913811', 'CLIENT', '1', '1645663115132');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('Nahian_Shabab', '$2b$10$F8SgOEaQZbThFwWedwfnHury3cwjIi795Crxj/npvMR7KNovQziaS', 'nahian@gmail.com', 'Uttara', 'Nahian', 'Shabab', '01338327984', 'CLIENT', '1', '1645732234883');
INSERT INTO "C##NAHIAN"."GENERAL_USER" VALUES ('ShihanDarkStar', '$2b$10$001EEuU.87sEf9SGuqbjre4zKRiBMUdRo64gmLR0pAceFYlbssRV6', 'shohan@gmail.com', NULL, 'Shihan', 'DarkStar', '01573921711', 'CLIENT', '1', '1645790434392');

-- ----------------------------
-- Table structure for ITEM
-- ----------------------------
DROP TABLE "C##NAHIAN"."ITEM";
CREATE TABLE "C##NAHIAN"."ITEM" (
  "ITEM_ID" NUMBER VISIBLE DEFAULT "C##NAHIAN"."ISEQ$$_77376".nextval NOT NULL,
  "TITLE" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "PRICE" NUMBER VISIBLE NOT NULL,
  "MAIN_IMAGE" VARCHAR2(210 BYTE) VISIBLE,
  "SUMMARY" VARCHAR2(1000 BYTE) VISIBLE,
  "IS_FEATURED" NUMBER VISIBLE DEFAULT 0 NOT NULL,
  "TYPE" VARCHAR2(10 BYTE) VISIBLE NOT NULL,
  "UPDATED_BY" VARCHAR2(20 BYTE) VISIBLE,
  "IS_CONTINUED" NUMBER VISIBLE DEFAULT 1 NOT NULL,
  "UPDATE_DATE" NUMBER VISIBLE DEFAULT 0 NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of ITEM
-- ----------------------------
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('153', 'Asus Vivobook', '90000', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1644397368314');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('147', 'Copper Wire 100 cm', '20', NULL, NULL, '0', 'PRODUCT', 'Nahian', '1', '1644396451651');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('148', 'Copper Wire II 100 cm', '15', NULL, NULL, '0', 'PRODUCT', 'Nahian', '1', '1644396509914');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('154', 'Zenbook', '95000', NULL, NULL, '0', 'PRODUCT', 'admin', '1', '1645589214461');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('169', 'Arduino Starter Pack', '800', NULL, 'Buy 1 Arduino Uno and get 5 op amp and  555 timer each! ', '1', 'OFFER', 'admin', '1', '1644830582909');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('136', 'Samsung M10', '25000', NULL, NULL, '1', 'PRODUCT', 'Nahian', '1', '1644083440570');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('137', 'Lenovo S Pro', '17800', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1644393386770');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('143', 'Arduino Uno', '990', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1644395442076');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('144', 'Arduino Nano', '990', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1644395466524');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('145', 'DC Motor', '30', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1645599806151');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('146', 'AC Induction Motor', '25000', NULL, NULL, '0', 'PRODUCT', 'Nahian', '1', '1644396265300');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('149', '7404 Gate', '30', NULL, NULL, '0', 'PRODUCT', 'admin', '1', '1644397497982');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('150', '7408 Gate', '40', NULL, NULL, '0', 'PRODUCT', 'admin', '1', '1644397516513');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('151', '555 Timer', '34', NULL, NULL, '1', 'PRODUCT', 'Nahian', '1', '1644397008403');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('152', 'Op Amp', '25', NULL, NULL, '1', 'PRODUCT', 'Nahian', '1', '1644397045438');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('155', 'Macbook', '125000', NULL, NULL, '0', 'PRODUCT', 'admin', '1', '1644397796568');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('181', 'Buy 1 Laptop Get 1 Smartphone ', '99000', NULL, 'Buy Asus Vivo book and get 1 Samsung M10 free!', '1', 'OFFER', 'admin', '1', '1645603799729');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('242', '10 Ohm Resistor 30 pcs', '10', NULL, NULL, '0', 'PRODUCT', 'admin', '1', '1645589557719');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('244', '47 uF Capaitor 10 pcs', '4', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1645589830626');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('245', '1 uF capacitor 10 pcs', '3', NULL, NULL, '0', 'PRODUCT', 'admin', '1', '1645590164735');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('248', 'Inductor Coil 45 H 10 Pcs', '5', NULL, 'Inductors are one of the basic components found in every electronics circuit.', '1', 'PRODUCT', 'admin', '1', '1645650990539');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('249', 'Inductor Coil 55 H 10 Pcs', '5.5', NULL, 'Inductors are one of the basic components found in every electronics circuit.', '1', 'PRODUCT', 'admin', '1', '1645651034284');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('243', '1k Ohm Resistor 10 pcs', '10', NULL, NULL, '0', 'PRODUCT', 'admin', '1', '1645589681488');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('250', 'Step Down Transformer', '1200', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1645651703566');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('201', 'Winter Combo Pack', '800', NULL, NULL, '1', 'OFFER', 'admin', '1', '1645120185778');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('241', 'Cannon Flash', '35000', NULL, 'Cannon''s best camera', '1', 'PRODUCT', 'admin', '1', '1645589140455');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('247', 'HP Nitro', '23000', NULL, NULL, '0', 'PRODUCT', 'admin', '1', '1645604759014');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('263', 'Light Actuator', '250', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1645789496928');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('264', 'Heavy Actuator', '250', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1645789580341');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('138', 'Iphone 13', '50000', NULL, NULL, '0', 'PRODUCT', 'admin', '1', '1645589298868');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('141', 'Asus Professional PC', '45000', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1644394623677');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('156', 'Sten Gun', '23000', NULL, NULL, '0', 'PRODUCT', 'admin', '1', '1644397859643');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('157', 'Super Shotgun', '20000', NULL, NULL, '0', 'PRODUCT', 'admin', '1', '1644397884423');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('246', 'Dell Crystal', '45000', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1645597255362');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('261', 'Lenovo Desktop Ultra', '250000', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1645735434236');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('262', 'Travelers Offer', '2300', NULL, 'This is a offer for those who love to travel. One camera and one smartphone in a convenient package!', '1', 'OFFER', 'admin', '1', '1645736177965');
INSERT INTO "C##NAHIAN"."ITEM" VALUES ('142', 'Lenovo Professional PC', '57000', NULL, NULL, '1', 'PRODUCT', 'admin', '1', '1644394691834');

-- ----------------------------
-- Table structure for MANUFACTURER
-- ----------------------------
DROP TABLE "C##NAHIAN"."MANUFACTURER";
CREATE TABLE "C##NAHIAN"."MANUFACTURER" (
  "MANUFACTURER_ID" NUMBER VISIBLE DEFAULT "C##NAHIAN"."ISEQ$$_77372".nextval NOT NULL,
  "MANUFACTURER_NAME" VARCHAR2(100 BYTE) VISIBLE NOT NULL,
  "DESCRIPTION" VARCHAR2(500 BYTE) VISIBLE,
  "MOTTO" VARCHAR2(100 BYTE) VISIBLE,
  "LOGO_IMAGE" VARCHAR2(110 BYTE) VISIBLE,
  "IS_VALID" NUMBER VISIBLE DEFAULT 1 NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of MANUFACTURER
-- ----------------------------
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('82', 'NSN Softwares', NULL, 'Leader of The Future', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('161', 'Arduino Inc.', NULL, NULL, NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('182', 'Cannon', NULL, NULL, NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('183', 'HP', NULL, NULL, NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('45', 'Union Aerospace Corporation', NULL, NULL, NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('141', 'Apple', 'Apple Inc. is an American multinational technology company that specializes in consumer electronics, software and online services.', 'Think Different', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('44', 'Aperture Science', 'A company by Cave Johnson', 'When life gives you lemons, make lemonade', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('42', 'Asus', NULL, 'Inspiring Innovation , Persistent Perfection', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('43', 'TechShop Original', NULL, 'For all time, always', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('123', 'Lenovo', NULL, 'Tech and beyond', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('124', 'SAMSUNG', 'A South Korean Global Tech Giant', 'We are Not ONE', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('121', 'WALTER WHITE INDUSTRIES', 'A company in Albaquerque, New Mexico. It was formerly known as Los Pollos Hermanos,owned by Gustavo Fring.After he passed away in an explosion, a chemist named Walter white took over his empire.', 'Best Cooks Ever', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('122', 'ID Software', 'One of the most important video game developers in the world. They pioneered the FPS genre.', 'Innovation, Immersion,Intensity', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('184', 'Nvidia', NULL, NULL, NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('185', 'AMD', NULL, NULL, NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('201', 'Microsoft', NULL, 'For all time Always', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('64', 'DELL', NULL, 'Make Your Future', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('90', 'SS City State Engineering.', 'Sunken City''s own Engineering Workshop and Wholesaler ', 'Negative Second Differential', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('41', 'Nahian ElectroniX', NULL, 'Quality Products For Intelligent Tomorrow', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('61', 'NSN', 'BILLIONAIRE NAHIAN SHABAB''S PRIVATE COMPANY ', 'THE LIVING DAYLIGHTS!', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('101', 'UAC', 'Union Aerospace Company', 'One step towards heaven', NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('162', 'National Steel Corporation', NULL, NULL, NULL, '1');
INSERT INTO "C##NAHIAN"."MANUFACTURER" VALUES ('181', 'Global Electronics', NULL, NULL, NULL, '1');

-- ----------------------------
-- Table structure for NOTIFICATION
-- ----------------------------
DROP TABLE "C##NAHIAN"."NOTIFICATION";
CREATE TABLE "C##NAHIAN"."NOTIFICATION" (
  "NOTIFICATION_ID" NUMBER VISIBLE DEFAULT "C##NAHIAN"."ISEQ$$_80667".nextval NOT NULL,
  "USER_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
  "TEXT" VARCHAR2(200 BYTE) VISIBLE NOT NULL,
  "SEEN" NUMBER VISIBLE DEFAULT 0 NOT NULL,
  "TIME" NUMBER VISIBLE NOT NULL,
  "TYPE" VARCHAR2(20 BYTE) VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of NOTIFICATION
-- ----------------------------
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('41', 'Fahad', 'Shabab replied to your comment: "Stop this bs right now -_-"', '1', '1645370007369', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('65', 'Fahad', 'Your Order with ID "67" has been assembled and ready to be delivered! Thanks for staying with TechShop!', '1', '1645433256645', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('101', 'Shihan', 'Your Order with ID "101" has been assembled and ready to be delivered! Thanks for staying with TechShop!', '1', '1645536136545', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('188', 'Watson', 'parisha replied to your comment: "hello"', '0', '1645720909502', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('181', 'Watson', 'Your Order with ID "162" has been assembled and ready to be delivered! Thanks for staying with TechShop!', '0', '1645720748347', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('202', 'Nahian_Shabab', 'Your Order with ID "201" has been assembled and ready to be delivered! Thanks for staying with TechShop!', '0', '1645733797730', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('204', 'Nahian_Shabab', 'Your Order is currently at: Mirpur,Dhaka.', '1', '1645733924880', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('23', 'Fahad', 'Shabab replied to your comment: "i got it"', '1', '1645041449125', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('74', 'Fahad', 'Your Order with ID "70" is now on its way! Thanks for staying with TechShop!', '1', '1645452899983', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('27', 'Shabab', 'Fahad replied to your comment: "i hate you"', '1', '1645043193325', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('164', 'Gus', 'Your Order is currently at: Mirpur,Dhaka.', '0', '1645658200773', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('102', 'Shihan', 'Your Order with ID "101" is now on its way! Thanks for staying with TechShop!', '1', '1645536151558', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('103', 'Shihan', 'Your Order is currently at: Cantonment,Dhaka.', '1', '1645536164689', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('104', 'Shihan', 'Your Order is currently at: Motijheel,Dhaka.', '1', '1645536169254', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('105', 'Shihan', 'Your Order is currently at: Gulshan,Dhaka.', '1', '1645536173218', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('106', 'Shihan', 'Your Order is currently at: Cantonment,Dhaka.', '1', '1645536177622', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('107', 'Shihan', 'Your Order with ID "101" has been delivered! Thanks for staying with TechShop!', '1', '1645536178553', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('110', 'Walter', 'Your Order is currently at: Mirpur,Dhaka.', '1', '1645551151955', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('141', 'Gus', 'Your Order is currently at: Motijheel,Dhaka.', '0', '1645609383285', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('142', 'Gus', 'Your Order is currently at: Gulshan,Dhaka.', '0', '1645610167025', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('165', 'Gus', 'Your Order is currently at: Uttara,Dhaka.', '0', '1645658220298', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('166', 'Gus', 'Your Order with ID "121" has been delivered! Thanks for staying with TechShop!', '0', '1645658223620', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('24', 'Fahad', 'Shabab replied to your comment: "ok"', '1', '1645041555769', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('108', 'Walter', 'Your Order with ID "102" has been assembled and ready to be delivered! Thanks for staying with TechShop!', '1', '1645545724420', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('182', 'parisha', 'Your Order with ID "181" has been assembled and ready to be delivered! Thanks for staying with TechShop!', '0', '1645720756805', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('186', 'parisha', 'Your Order is currently at: Uttara,Dhaka.', '0', '1645720860233', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('187', 'parisha', 'Your Order with ID "181" has been delivered! Thanks for staying with TechShop!', '0', '1645720861720', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('211', 'Shabab', 'Walter replied to your comment: "hello"', '0', '1645789228970', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('130', 'Gus', 'Your Order with ID "118" is now on its way! Thanks for staying with TechShop!', '0', '1645587275698', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('131', 'Gus', 'Your Order is currently at: Cantonment,Dhaka.', '0', '1645587279924', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('132', 'Gus', 'Your Order with ID "118" has been delivered! Thanks for staying with TechShop!', '0', '1645587280760', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('221', 'Gus', 'ShihanDarkStar replied to your comment: "Hiii"', '0', '1645798609370', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('135', 'Gus', 'Your Order with ID "121" is now on its way! Thanks for staying with TechShop!', '0', '1645605823422', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('136', 'Gus', 'Your Order is currently at: Motijheel,Dhaka.', '0', '1645605831538', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('75', 'Fahad', 'Your Order with ID "70" has been delivered! Thanks for staying with TechShop!', '1', '1645452918193', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('169', 'Watson', 'Your Order with ID "161" has been assembled and ready to be delivered! Thanks for staying with TechShop!', '0', '1645713480692', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('170', 'Watson', 'Your Order with ID "161" is now on its way! Thanks for staying with TechShop!', '0', '1645713502086', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('127', 'Gus', 'Your Order with ID "118" has been assembled and ready to be delivered! Thanks for staying with TechShop!', '0', '1645587237279', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('171', 'Watson', 'Your Order is currently at: Gulshan,Dhaka.', '0', '1645713508875', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('172', 'Watson', 'Your Order is currently at: Mirpur,Dhaka.', '0', '1645713512122', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('173', 'Watson', 'Your Order is currently at: Motijheel,Dhaka.', '0', '1645713516247', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('174', 'Watson', 'Your Order with ID "161" has been delivered! Thanks for staying with TechShop!', '0', '1645713517178', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('212', 'Nahian_Shabab', 'ShihanDarkStar replied to your comment: "hello"', '0', '1645790465601', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('222', 'Nahian_Shabab', 'NewUser replied to your comment: "hahhahahha"', '0', '1645799418259', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('22', 'Fahad', 'Shabab replied to your comment: "okk"', '1', '1645041412938', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('25', 'Shabab', 'Fahad replied to your comment: "shut up"', '1', '1645042419635', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('61', 'Shabab', 'Fahad replied to your comment: "i don''t know"', '1', '1645388289238', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('73', 'Fahad', 'Your Order with ID "70" has been assembled and ready to be delivered! Thanks for staying with TechShop!', '1', '1645452889216', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('183', 'parisha', 'Your Order with ID "181" is now on its way! Thanks for staying with TechShop!', '0', '1645720810531', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('84', 'Shabab', 'Your Order is currently at: Cantonment,Dhaka.', '1', '1645471866475', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('85', 'Shabab', 'Your Order is currently at: Motijheel,Dhaka.', '1', '1645471875278', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('203', 'Nahian_Shabab', 'Your Order with ID "201" is now on its way! Thanks for staying with TechShop!', '0', '1645733880629', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('109', 'Walter', 'Your Order with ID "102" is now on its way! Thanks for staying with TechShop!', '1', '1645545753803', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('205', 'Nahian_Shabab', 'Your Order is currently at: Uttara,Dhaka.', '1', '1645733942303', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('184', 'parisha', 'Your Order is currently at: Gulshan,Dhaka.', '0', '1645720818551', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('185', 'parisha', 'Your Order is currently at: Mirpur,Dhaka.', '0', '1645720842144', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('201', 'Gus', 'Nahian_Shabab replied to your comment: "reply"', '0', '1645732451447', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('206', 'Nahian_Shabab', 'Your Order with ID "201" has been delivered! Thanks for staying with TechShop!', '1', '1645733957783', 'ORDER');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('210', 'Shabab', 'Nahian_Shabab replied to your comment: "how are you today?"', '1', '1645734265307', 'COMMENT');
INSERT INTO "C##NAHIAN"."NOTIFICATION" VALUES ('133', 'Gus', 'Your Order with ID "121" has been assembled and ready to be delivered! Thanks for staying with TechShop!', '0', '1645605781424', 'ORDER');

-- ----------------------------
-- Table structure for NUMERIC_COMPONENT
-- ----------------------------
DROP TABLE "C##NAHIAN"."NUMERIC_COMPONENT";
CREATE TABLE "C##NAHIAN"."NUMERIC_COMPONENT" (
  "TITLE" VARCHAR2(30 BYTE) VISIBLE NOT NULL,
  "DETAILS" VARCHAR2(200 BYTE) VISIBLE,
  "UNIT" VARCHAR2(20 BYTE) VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of NUMERIC_COMPONENT
-- ----------------------------
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Luminance', NULL, 'Cd/m^2');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Refresh Rate', NULL, 'Hz');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Camera Resolution', NULL, 'Mega Pixel');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('RAM', 'Random Access Memory', 'GB');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('HDD', NULL, 'TB');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Weight', NULL, 'gram');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Screen', NULL, 'inch');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Battery capacity', NULL, 'mAh');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Storage', NULL, 'GB');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Length', NULL, 'cm');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Width', NULL, 'cm');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Torque', NULL, 'N-m');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Max Voltage', NULL, 'V');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Bore', NULL, 'cm');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Conductance', NULL, 'Siemens');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Pins', NULL, 'Number');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Capacitance', NULL, 'micro Farad');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Inductance', NULL, 'Henry');
INSERT INTO "C##NAHIAN"."NUMERIC_COMPONENT" VALUES ('Resistance', NULL, 'Ohm');

-- ----------------------------
-- Table structure for OFFER
-- ----------------------------
DROP TABLE "C##NAHIAN"."OFFER";
CREATE TABLE "C##NAHIAN"."OFFER" (
  "ITEM_ID" NUMBER VISIBLE NOT NULL,
  "EXPIRE_DATE" NUMBER VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of OFFER
-- ----------------------------
INSERT INTO "C##NAHIAN"."OFFER" VALUES ('169', '1645984800000');
INSERT INTO "C##NAHIAN"."OFFER" VALUES ('181', '1645984800000');
INSERT INTO "C##NAHIAN"."OFFER" VALUES ('201', '1645984800000');
INSERT INTO "C##NAHIAN"."OFFER" VALUES ('262', '1649008800000');

-- ----------------------------
-- Table structure for OFFER_FREE_PRODUCTS
-- ----------------------------
DROP TABLE "C##NAHIAN"."OFFER_FREE_PRODUCTS";
CREATE TABLE "C##NAHIAN"."OFFER_FREE_PRODUCTS" (
  "OFFER_ID" NUMBER VISIBLE NOT NULL,
  "PRODUCT_ID" NUMBER VISIBLE NOT NULL,
  "COUNT" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of OFFER_FREE_PRODUCTS
-- ----------------------------
INSERT INTO "C##NAHIAN"."OFFER_FREE_PRODUCTS" VALUES ('169', '152', '6');
INSERT INTO "C##NAHIAN"."OFFER_FREE_PRODUCTS" VALUES ('181', '136', '1');
INSERT INTO "C##NAHIAN"."OFFER_FREE_PRODUCTS" VALUES ('169', '151', '5');
INSERT INTO "C##NAHIAN"."OFFER_FREE_PRODUCTS" VALUES ('201', '149', '5');
INSERT INTO "C##NAHIAN"."OFFER_FREE_PRODUCTS" VALUES ('201', '150', '6');
INSERT INTO "C##NAHIAN"."OFFER_FREE_PRODUCTS" VALUES ('201', '151', '3');
INSERT INTO "C##NAHIAN"."OFFER_FREE_PRODUCTS" VALUES ('169', '150', '6');
INSERT INTO "C##NAHIAN"."OFFER_FREE_PRODUCTS" VALUES ('262', '156', '1');

-- ----------------------------
-- Table structure for OFFER_PRODUCTS
-- ----------------------------
DROP TABLE "C##NAHIAN"."OFFER_PRODUCTS";
CREATE TABLE "C##NAHIAN"."OFFER_PRODUCTS" (
  "OFFER_ID" NUMBER VISIBLE NOT NULL,
  "PRODUCT_ID" NUMBER VISIBLE NOT NULL,
  "COUNT" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of OFFER_PRODUCTS
-- ----------------------------
INSERT INTO "C##NAHIAN"."OFFER_PRODUCTS" VALUES ('181', '153', '1');
INSERT INTO "C##NAHIAN"."OFFER_PRODUCTS" VALUES ('201', '149', '3');
INSERT INTO "C##NAHIAN"."OFFER_PRODUCTS" VALUES ('169', '143', '1');
INSERT INTO "C##NAHIAN"."OFFER_PRODUCTS" VALUES ('201', '151', '2');
INSERT INTO "C##NAHIAN"."OFFER_PRODUCTS" VALUES ('201', '152', '11');
INSERT INTO "C##NAHIAN"."OFFER_PRODUCTS" VALUES ('169', '149', '10');
INSERT INTO "C##NAHIAN"."OFFER_PRODUCTS" VALUES ('262', '241', '1');
INSERT INTO "C##NAHIAN"."OFFER_PRODUCTS" VALUES ('262', '137', '1');

-- ----------------------------
-- Table structure for ORDER
-- ----------------------------
DROP TABLE "C##NAHIAN"."ORDER";
CREATE TABLE "C##NAHIAN"."ORDER" (
  "ORDER_ID" NUMBER VISIBLE DEFAULT "C##NAHIAN"."ISEQ$$_78903".nextval NOT NULL,
  "TOTAL_PRICE" NUMBER VISIBLE NOT NULL,
  "DESTINATION_ADDRESS" VARCHAR2(500 BYTE) VISIBLE NOT NULL,
  "ORDER_DATE" NUMBER VISIBLE NOT NULL,
  "DELIVERY_DATE" NUMBER VISIBLE,
  "ORDER_STATUS" VARCHAR2(20 BYTE) VISIBLE,
  "CURRENT_SUB_DISTRICT" NUMBER VISIBLE,
  "DESTINATION_SUB_DISTRICT" NUMBER VISIBLE NOT NULL,
  "CLIENT_NAME" VARCHAR2(20 BYTE) VISIBLE,
  "ASSEMBLER_NAME" VARCHAR2(20 BYTE) VISIBLE,
  "DELIVERMAN_NAME" VARCHAR2(20 BYTE) VISIBLE,
  "PAYMENT_DATE" NUMBER VISIBLE,
  "DELIVERY_COST" NUMBER VISIBLE NOT NULL,
  "HAS_REDEEMED" NUMBER VISIBLE DEFAULT 0 NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of ORDER
-- ----------------------------
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('162', '272700', 'uttara market', '1645713582579', NULL, 'ASSEMBLED', NULL, '1', 'Watson', 'asmblr', NULL, '1645713598742', '60', '1');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('121', '154.85', 'Cantonment Stadium', '1645588049888', '1645658223607', 'DELIVERED', '1', '1', 'Gus', 'asmblr', 'delivery', '1645588086606', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('117', '19759.92', 'Motijheel City Center NYA Office, Room 234', '1645567520810', '1645587273923', 'DELIVERED', '24', '24', 'Shabab', 'asmblr', 'delivery', '1645567625817', '60', '1');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('122', '413.3', 'Motijheel City Center NYA Office, Room 234', '1645602265457', '1645605870832', 'DELIVERED', '1', '1', 'Shabab', 'asmblr', 'delivery', '1645602321772', '60', '1');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('125', '4114.85', 'Motijheel City Center NYA Office, Room 234', '1645613454224', NULL, 'ASSEMBLED', NULL, '26', 'Shabab', 'asmblr', NULL, '1645613507278', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('222', '135325', 'uttara', '1645799503682', NULL, 'PAY_CONFIRMED', NULL, '1', 'NewUser', NULL, NULL, '1645799506255', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('70', '3124.85', 'Uttara Market', '1645452674580', '1645452918184', 'DELIVERED', '1', '1', 'Fahad', 'asmblr', 'delivery', '1645452678366', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('102', '50', 'Mirpur 10', '1645545502497', '1645551152688', 'DELIVERED', '26', '26', 'Walter', 'asmblr', 'ABC', '1645545507202', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('124', '99000', 'Motijheel City Center NYA Office, Room 234', '1645608262669', '1645613427105', 'DELIVERED', '25', '25', 'Shabab', 'asmblr', 'delivery', '1645610366110', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('118', '50', 'Cantonment Stadium', '1645587031240', '1645587280758', 'DELIVERED', '24', '24', 'Gus', 'asmblr', 'delivery', '1645587040046', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('161', '205450', 'City Center', '1645713223751', '1645713517168', 'DELIVERED', '23', '23', 'Watson', 'asmblr', 'delivery', '1645713255880', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('221', '154208.05', 'uttara', '1645799320019', NULL, 'PAY_CONFIRMED', NULL, '1', 'ShihanDarkStar', NULL, NULL, '1645799323492', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('101', '125', 'Uttara Market', '1645536092639', '1645536178543', 'DELIVERED', '24', '24', 'Shihan', 'asmblr', 'delivery', '1645536098260', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('82', '99105', 'Motijheel City Center', '1645471732155', '1645471877961', 'DELIVERED', '23', '23', 'Shabab', 'asmblr', 'delivery', '1645471743628', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('114', '398.88', 'Motijheel City Center NYA Office, Room 234', '1645565001139', '1645565216839', 'DELIVERED', '23', '23', 'Shabab', 'asmblr', 'delivery', '1645565003579', '60', '0');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('115', '1197.44', 'Motijheel City Center NYA Office, Room 234', '1645565504225', '1645566425832', 'DELIVERED', '23', '23', 'Shabab', 'asmblr', 'delivery', '1645565637967', '60', '1');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('116', '56851.06', 'Motijheel City Center NYA Office, Room 234', '1645566449183', '1645567438861', 'DELIVERED', '1', '1', 'Shabab', 'asmblr', 'delivery', '1645566460688', '60', '1');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('181', '134900', 'uttara', '1645720658646', '1645720861716', 'DELIVERED', '1', '1', 'parisha', 'asmblr', 'delivery', '1645720724722', '60', '1');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('201', '51183.45', 'Uttara', '1645733266180', '1645733957774', 'DELIVERED', '1', '1', 'Nahian_Shabab', 'asmblr', 'delivery', '1645733337598', '60', '1');
INSERT INTO "C##NAHIAN"."ORDER" VALUES ('202', '419238.64', 'Cantonmnet Stadium', '1645789747607', NULL, 'PAY_CONFIRMED', NULL, '24', 'Walter', NULL, NULL, '1645789921632', '60', '1');

-- ----------------------------
-- Table structure for ORDER_ITEM
-- ----------------------------
DROP TABLE "C##NAHIAN"."ORDER_ITEM";
CREATE TABLE "C##NAHIAN"."ORDER_ITEM" (
  "ORDER_ID" NUMBER VISIBLE NOT NULL,
  "ITEM_ID" NUMBER VISIBLE NOT NULL,
  "QUANTITY" NUMBER VISIBLE NOT NULL,
  "UNIT_PRICE" NUMBER VISIBLE NOT NULL,
  "DISCOUNT" NUMBER VISIBLE
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of ORDER_ITEM
-- ----------------------------
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('162', '146', '11', '25000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('117', '145', '4', '26.6', '11.33');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('117', '157', '1', '20000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('121', '151', '5', '30.97', '8.9');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('122', '145', '1', '26.6', '11.33');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('122', '169', '1', '800', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('125', '144', '4', '990', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('125', '151', '5', '30.97', '8.9');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('222', '141', '3', '45000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('222', '152', '13', '25', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('102', '152', '2', '25', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('70', '143', '3', '990', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('70', '151', '5', '30.97', '8.9');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('124', '181', '1', '99000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('118', '152', '2', '25', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('161', '141', '2', '45000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('161', '146', '3', '25000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('161', '149', '7', '30', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('161', '150', '6', '40', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('161', '157', '2', '20000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('221', '142', '2', '57000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('221', '145', '2', '26.6', '11.33');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('221', '151', '5', '30.97', '8.9');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('221', '157', '2', '20000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('101', '152', '5', '25', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('114', '151', '4', '30.97', '8.9');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('114', '152', '11', '25', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('115', '151', '50', '30.97', '8.9');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('82', '148', '7', '15', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('82', '181', '1', '99000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('116', '142', '1', '57000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('181', '141', '1', '45000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('181', '153', '1', '90000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('201', '141', '1', '45000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('201', '143', '4', '990', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('201', '145', '3', '26.6', '11.33');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('201', '151', '45', '30.97', '8.9');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('201', '152', '2', '25', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('201', '169', '1', '800', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('202', '151', '6', '30.97', '8.9');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('202', '152', '13', '25', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('202', '157', '2', '20000', NULL);
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('202', '250', '3', '900', '25');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('202', '261', '2', '187500', '25');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('202', '263', '3', '230', '8');
INSERT INTO "C##NAHIAN"."ORDER_ITEM" VALUES ('202', '264', '2', '245', '2');

-- ----------------------------
-- Table structure for PRODUCT
-- ----------------------------
DROP TABLE "C##NAHIAN"."PRODUCT";
CREATE TABLE "C##NAHIAN"."PRODUCT" (
  "ITEM_ID" NUMBER VISIBLE NOT NULL,
  "STOCK" NUMBER VISIBLE DEFAULT 0 NOT NULL,
  "DISCOUNT" NUMBER VISIBLE,
  "DISCOUNT_EXPIRE_DATE" NUMBER VISIBLE,
  "CATEGORY" NUMBER VISIBLE NOT NULL,
  "MANUFACTURER" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of PRODUCT
-- ----------------------------
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('147', '200', '0', NULL, '61', '162');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('153', '6', NULL, NULL, '35', '42');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('148', '193', NULL, NULL, '61', '90');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('154', '31', NULL, '0', '35', '123');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('136', '7', NULL, '0', '121', '124');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('137', '23', '25', '0', '121', '123');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('143', '9', NULL, NULL, '36', '161');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('144', '3', NULL, NULL, '36', '161');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('145', '42', '11.33', '1645639200000', '34', '41');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('146', '6', NULL, '0', '34', '43');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('149', '0', NULL, '0', '32', '44');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('150', '15', NULL, '0', '32', '43');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('151', '11', '8.9', NULL, '32', '43');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('152', '0', NULL, NULL, '32', '161');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('155', '5', NULL, NULL, '35', '141');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('242', '40', NULL, NULL, '154', '181');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('244', '100', NULL, NULL, '154', '43');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('245', '34', '4.4', '0', '154', '44');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('248', '23', '3.5', '1645725600000', '154', '43');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('249', '12', '3.5', '1651082400000', '154', '41');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('243', '25', NULL, NULL, '154', '44');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('250', '25', '25', '1645984800000', '34', '43');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('241', '14', '25', '1645984800000', '149', '182');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('247', '10', '2.3', NULL, '149', '183');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('263', '23', '8', '1645898400000', '33', '90');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('264', '13', '2', '1645898400000', '33', '44');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('138', '7', '8', '2311200000', '121', '141');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('156', '4', NULL, NULL, '37', '44');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('157', '3', NULL, NULL, '37', '101');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('246', '5', '3.3', '1645898400000', '142', '64');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('261', '25', '25', '1648576800000', '101', '123');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('141', '16', NULL, NULL, '101', '42');
INSERT INTO "C##NAHIAN"."PRODUCT" VALUES ('142', '19', NULL, NULL, '101', '123');

-- ----------------------------
-- Table structure for PRODUCT_CONTAINS
-- ----------------------------
DROP TABLE "C##NAHIAN"."PRODUCT_CONTAINS";
CREATE TABLE "C##NAHIAN"."PRODUCT_CONTAINS" (
  "PARENT_PRODUCT" NUMBER VISIBLE NOT NULL,
  "CHILD_PRODUCT" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of PRODUCT_CONTAINS
-- ----------------------------

-- ----------------------------
-- Table structure for PROD_GEN_COMPONENT
-- ----------------------------
DROP TABLE "C##NAHIAN"."PROD_GEN_COMPONENT";
CREATE TABLE "C##NAHIAN"."PROD_GEN_COMPONENT" (
  "PRODUCT_ID" NUMBER VISIBLE NOT NULL,
  "COMPONENT_TITLE" VARCHAR2(30 BYTE) VISIBLE NOT NULL,
  "SPECIFICATION" VARCHAR2(100 BYTE) VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of PROD_GEN_COMPONENT
-- ----------------------------
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('153', 'Video Card', 'Nvidia Ultra');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('153', 'Processor', 'Intel Core i9');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('153', 'Operating System', 'Windows 11');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('153', 'USB', '4 slots');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('154', 'Video Card', 'Nvidia Nano');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('154', 'Processor', 'Intel Core i7');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('154', 'Operating System', 'Windows 10');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('154', 'USB', '2 slots');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('136', 'Operating System', 'Android');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('136', 'Sensors', 'Gyroscope');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('137', 'Processor', 'Snapdragon 650 1.8 GHz');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('137', 'Color(s)', 'Red, Black');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('137', 'Operating System', 'Android');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('137', 'Bluetooth', 'IEEE 3.8');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('155', 'Operating System', 'IOs');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('248', 'Rating', '220V-1A 2W');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('249', 'Rating', '220V-1A 2W');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('250', 'Turns Ratio', '0.10');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('247', 'Aspect Ratio', '16:9');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('247', 'Resolution', 'HD');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('263', 'Rating', '50V-0.1A');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('264', 'Rating', '50V-0.3A');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('138', 'Processor', 'Hexa-core Avalanche');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('138', 'Color(s)', 'Red, Green');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('141', 'Audio', 'Full HD Audio');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('141', 'Video Card', 'Nvidia GT150');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('141', 'Processor', 'Intel Core i7');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('141', 'WebCam', 'HD Webcam');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('141', 'USB', 'Four USB ports');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('142', 'Video Card', 'Nvidia GT150');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('142', 'Processor', 'Intel Core i5');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('142', 'Audio', 'Full HD Audio');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('142', 'WebCam', 'HD Webcam');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('142', 'USB', 'Two USB ports');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('246', 'Resolution', '4K');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('246', 'Aspect Ratio', '16:9');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('261', 'Video Card', 'AMD ULTRA');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('261', 'Wi-Fi', 'IEEE Standard');
INSERT INTO "C##NAHIAN"."PROD_GEN_COMPONENT" VALUES ('261', 'Audio', 'HD Sorround');

-- ----------------------------
-- Table structure for PROD_NUM_COMPONENT
-- ----------------------------
DROP TABLE "C##NAHIAN"."PROD_NUM_COMPONENT";
CREATE TABLE "C##NAHIAN"."PROD_NUM_COMPONENT" (
  "PRODUCT_ID" NUMBER VISIBLE NOT NULL,
  "COMPONENT_TITLE" VARCHAR2(30 BYTE) VISIBLE NOT NULL,
  "VALUE" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of PROD_NUM_COMPONENT
-- ----------------------------
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('147', 'Conductance', '150');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('147', 'Max Voltage', '220');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('147', 'Length', '100');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('148', 'Conductance', '250');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('148', 'Max Voltage', '220');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('148', 'Length', '100');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('153', 'RAM', '8');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('153', 'HDD', '1');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('153', 'Weight', '900');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('153', 'Battery capacity', '7000');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('153', 'Screen', '15');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('154', 'RAM', '4');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('154', 'HDD', '1.5');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('154', 'Weight', '800');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('154', 'Battery capacity', '6500');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('154', 'Screen', '15');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('136', 'RAM', '8');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('136', 'Camera Resolution', '48');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('136', 'Storage', '32');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('136', 'Battery capacity', '4000');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('136', 'Weight', '125');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('137', 'Camera Resolution', '15');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('137', 'RAM', '16');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('137', 'Weight', '125');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('137', 'Battery capacity', '2500');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('137', 'Screen', '6');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('143', 'Pins', '13');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('143', 'Max Voltage', '5');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('144', 'Pins', '13');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('144', 'Max Voltage', '3.2');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('145', 'Weight', '45');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('145', 'Torque', '500');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('145', 'Max Voltage', '60');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('146', 'Weight', '900');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('146', 'Torque', '1000');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('146', 'Max Voltage', '220');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('149', 'Max Voltage', '5');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('149', 'Pins', '8');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('150', 'Max Voltage', '5');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('150', 'Pins', '8');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('151', 'Max Voltage', '5');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('151', 'Pins', '6');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('152', 'Max Voltage', '5');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('152', 'Pins', '8');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('155', 'RAM', '8');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('155', 'HDD', '1');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('155', 'Weight', '950');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('242', 'Resistance', '10');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('242', 'Max Voltage', '270');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('244', 'Capacitance', '47');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('244', 'Max Voltage', '240');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('245', 'Capacitance', '1');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('245', 'Max Voltage', '250');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('248', 'Max Voltage', '260');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('248', 'Inductance', '45');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('249', 'Max Voltage', '260');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('249', 'Inductance', '55');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('243', 'Resistance', '1000');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('243', 'Max Voltage', '260');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('250', 'Max Voltage', '1200');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('241', 'Camera Resolution', '24');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('241', 'Storage', '6');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('138', 'Storage', '128');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('138', 'Battery capacity', '3240');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('247', 'Camera Resolution', '24');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('247', 'Weight', '600');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('263', 'Weight', '150');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('263', 'Torque', '120');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('263', 'Length', '2');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('264', 'Weight', '500');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('264', 'Torque', '450');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('264', 'Length', '3.5');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('138', 'Camera Resolution', '12');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('138', 'RAM', '4');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('141', 'Weight', '5000');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('141', 'Screen', '20');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('141', 'RAM', '16');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('141', 'HDD', '1');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('142', 'RAM', '24');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('142', 'HDD', '1.5');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('142', 'Weight', '4500');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('142', 'Screen', '20');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('156', 'Bore', '2');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('157', 'Bore', '2.5');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('246', 'Refresh Rate', '144');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('246', 'Screen', '25');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('246', 'Weight', '4500');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('261', 'RAM', '8');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('261', 'HDD', '2');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('261', 'Weight', '5000');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('261', 'Screen', '20');
INSERT INTO "C##NAHIAN"."PROD_NUM_COMPONENT" VALUES ('261', 'Refresh Rate', '144');

-- ----------------------------
-- Table structure for REVIEW
-- ----------------------------
DROP TABLE "C##NAHIAN"."REVIEW";
CREATE TABLE "C##NAHIAN"."REVIEW" (
  "USER_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
  "PRODUCT_ID" NUMBER VISIBLE NOT NULL,
  "TITLE" VARCHAR2(200 BYTE) VISIBLE,
  "DESCRIPTION" VARCHAR2(500 BYTE) VISIBLE,
  "RATING" NUMBER VISIBLE NOT NULL,
  "REVIEW_DATE" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of REVIEW
-- ----------------------------
INSERT INTO "C##NAHIAN"."REVIEW" VALUES ('Fahad', '138', 'Overpriced', 'It''s hugely overpriced', '2', '1644656942793');
INSERT INTO "C##NAHIAN"."REVIEW" VALUES ('Shabab', '141', 'Works great!!', 'ok', '4', '1645599008426');
INSERT INTO "C##NAHIAN"."REVIEW" VALUES ('NahianShabab', '152', 'good', 'good', '5', '1645661290743');
INSERT INTO "C##NAHIAN"."REVIEW" VALUES ('Shabab', '138', 'Bad', 'Overpriced', '3', '1645599342591');
INSERT INTO "C##NAHIAN"."REVIEW" VALUES ('Shabab', '152', 'Bad', 'h', '4', '1644741911034');
INSERT INTO "C##NAHIAN"."REVIEW" VALUES ('Shabab', '143', 'abc', 'abc', '3', '1644743309624');
INSERT INTO "C##NAHIAN"."REVIEW" VALUES ('Shabab', '241', 'Not bad', 'actually not that bad', '4', '1645598158569');
INSERT INTO "C##NAHIAN"."REVIEW" VALUES ('Fahad', '136', 'A good phone', 'very handy phone', '3', '1644593452538');
INSERT INTO "C##NAHIAN"."REVIEW" VALUES ('Shabab', '144', 'good', 'very good', '4', '1645204031544');
INSERT INTO "C##NAHIAN"."REVIEW" VALUES ('Nahian_Shabab', '152', 'good', 'very good', '4', '1645732489628');
INSERT INTO "C##NAHIAN"."REVIEW" VALUES ('NahianShabab', '143', 'bad', 'not good', '1', '1645657283204');

-- ----------------------------
-- Table structure for STOCK_REQUEST
-- ----------------------------
DROP TABLE "C##NAHIAN"."STOCK_REQUEST";
CREATE TABLE "C##NAHIAN"."STOCK_REQUEST" (
  "PRODUCT_ID" NUMBER VISIBLE NOT NULL,
  "QUANTITY" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of STOCK_REQUEST
-- ----------------------------

-- ----------------------------
-- Table structure for SUB_DISTRICT
-- ----------------------------
DROP TABLE "C##NAHIAN"."SUB_DISTRICT";
CREATE TABLE "C##NAHIAN"."SUB_DISTRICT" (
  "SUB_DISTRICT_ID" NUMBER VISIBLE DEFAULT "C##NAHIAN"."ISEQ$$_77358".nextval NOT NULL,
  "SUB_DISTRICT_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
  "DISTRICT_ID" NUMBER VISIBLE NOT NULL,
  "DELIVERY_SUPPORTED" NUMBER VISIBLE DEFAULT 1 NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of SUB_DISTRICT
-- ----------------------------
INSERT INTO "C##NAHIAN"."SUB_DISTRICT" VALUES ('1', 'Uttara', '1', '1');
INSERT INTO "C##NAHIAN"."SUB_DISTRICT" VALUES ('23', 'Motijheel', '1', '1');
INSERT INTO "C##NAHIAN"."SUB_DISTRICT" VALUES ('24', 'Cantonment', '1', '1');
INSERT INTO "C##NAHIAN"."SUB_DISTRICT" VALUES ('25', 'Gulshan', '1', '1');
INSERT INTO "C##NAHIAN"."SUB_DISTRICT" VALUES ('26', 'Mirpur', '1', '1');
INSERT INTO "C##NAHIAN"."SUB_DISTRICT" VALUES ('27', 'Lalbagh', '1', '1');

-- ----------------------------
-- Table structure for WISHLIST
-- ----------------------------
DROP TABLE "C##NAHIAN"."WISHLIST";
CREATE TABLE "C##NAHIAN"."WISHLIST" (
  "CLIENT_NAME" VARCHAR2(20 BYTE) VISIBLE NOT NULL,
  "ITEM_ID" NUMBER VISIBLE NOT NULL
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;

-- ----------------------------
-- Records of WISHLIST
-- ----------------------------
INSERT INTO "C##NAHIAN"."WISHLIST" VALUES ('Shabab', '138');
INSERT INTO "C##NAHIAN"."WISHLIST" VALUES ('Shabab', '143');
INSERT INTO "C##NAHIAN"."WISHLIST" VALUES ('Shabab', '144');
INSERT INTO "C##NAHIAN"."WISHLIST" VALUES ('Shabab', '151');
INSERT INTO "C##NAHIAN"."WISHLIST" VALUES ('Shabab', '152');
INSERT INTO "C##NAHIAN"."WISHLIST" VALUES ('Shabab', '154');

-- ----------------------------
-- Sequence structure for ISEQ$$_77044
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_77044";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_77044" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_77332
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_77332";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_77332" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_77335
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_77335";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_77335" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_77351
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_77351";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_77351" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_77355
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_77355";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_77355" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_77358
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_77358";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_77358" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_77361
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_77361";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_77361" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_77364
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_77364";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_77364" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_77372
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_77372";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_77372" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_77376
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_77376";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_77376" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_77643
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_77643";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_77643" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_78053
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_78053";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_78053" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_78903
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_78903";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_78903" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Sequence structure for ISEQ$$_80667
-- ----------------------------
DROP SEQUENCE "C##NAHIAN"."ISEQ$$_80667";
CREATE SEQUENCE "C##NAHIAN"."ISEQ$$_80667" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Primary Key structure for table ACHIEVEMENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ACHIEVEMENT" ADD CONSTRAINT "SYS_C008453" PRIMARY KEY ("TITLE");

-- ----------------------------
-- Checks structure for table ACHIEVEMENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ACHIEVEMENT" ADD CONSTRAINT "SYS_C008448" CHECK ("SUMMARY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ACHIEVEMENT" ADD CONSTRAINT "SYS_C008449" CHECK ("REWARD_POINTS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ACHIEVEMENT" ADD CONSTRAINT "SYS_C008450" CHECK ("TOTAL_STEPS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ACHIEVEMENT" ADD CONSTRAINT "SYS_C008451" CHECK ( REWARD_POINTS>0 ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ACHIEVEMENT" ADD CONSTRAINT "SYS_C008452" CHECK ( TOTAL_STEPS>0 ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table ADMIN
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ADMIN" ADD CONSTRAINT "ADMIN_PK" PRIMARY KEY ("USER_NAME");

-- ----------------------------
-- Primary Key structure for table ASSEMBLER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ASSEMBLER" ADD CONSTRAINT "ASSEMBLER_PK" PRIMARY KEY ("USER_NAME");

-- ----------------------------
-- Primary Key structure for table CATEGORY
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CATEGORY" ADD CONSTRAINT "CATEGORY_PK" PRIMARY KEY ("CATEGORY_ID");

-- ----------------------------
-- Uniques structure for table CATEGORY
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CATEGORY" ADD CONSTRAINT "CATEGORY_NAME_UNIQUE" UNIQUE ("CATEGORY_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table CATEGORY
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CATEGORY" ADD CONSTRAINT "SYS_C007991" CHECK ("CATEGORY_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."CATEGORY" ADD CONSTRAINT "SYS_C007992" CHECK ("CATEGORY_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table CLIENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CLIENT" ADD CONSTRAINT "CLIENT_PK" PRIMARY KEY ("USER_NAME");

-- ----------------------------
-- Checks structure for table CLIENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CLIENT" ADD CONSTRAINT "SYS_C008460" CHECK ("REWARD_POINTS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."CLIENT" ADD CONSTRAINT "SYS_C008461" CHECK ( REWARD_POINTS>=0 ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table CLIENT_ACHIEVEMENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CLIENT_ACHIEVEMENT" ADD CONSTRAINT "SYS_C008457" PRIMARY KEY ("TITLE", "CLIENT_NAME");

-- ----------------------------
-- Checks structure for table CLIENT_ACHIEVEMENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CLIENT_ACHIEVEMENT" ADD CONSTRAINT "SYS_C008454" CHECK ("CLAIMED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."CLIENT_ACHIEVEMENT" ADD CONSTRAINT "SYS_C008455" CHECK ("ACQUIRED_STEPS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."CLIENT_ACHIEVEMENT" ADD CONSTRAINT "SYS_C008456" CHECK ( CLAIMED=1 OR CLAIMED=0 ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table CLIENT_CART
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CLIENT_CART" ADD CONSTRAINT "CLIENT_CART_PK" PRIMARY KEY ("CLIENT_NAME", "ITEM_ID");

-- ----------------------------
-- Checks structure for table CLIENT_CART
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CLIENT_CART" ADD CONSTRAINT "SYS_C008132" CHECK ("QUANTITY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table COMMENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."COMMENT" ADD CONSTRAINT "COMMENT_PK" PRIMARY KEY ("COMMENT_ID");

-- ----------------------------
-- Checks structure for table COMMENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."COMMENT" ADD CONSTRAINT "SYS_C008119" CHECK ("COMMENT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."COMMENT" ADD CONSTRAINT "SYS_C008120" CHECK ("COMMENT_DATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."COMMENT" ADD CONSTRAINT "SYS_C008121" CHECK ("TEXT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."COMMENT" ADD CONSTRAINT "SYS_C008122" CHECK ("COMMENTOR" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."COMMENT" ADD CONSTRAINT "SYS_C008123" CHECK ("COMMENT_PRODUCT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table COMMENT
-- ----------------------------
CREATE TRIGGER "C##NAHIAN"."COMMENT_ACHIEVEMENT_TRIGGER" BEFORE INSERT ON "C##NAHIAN"."COMMENT" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE
    COMMENT_COUNT NUMBER;
    ACHIEVEMENT_EXIST NUMBER;
    CUR_ACQUIRED_STEPS NUMBER;
    CUR_TOTAL_STEPS NUMBER;
BEGIN
    IF :NEW.PARENT_COMMENT IS NOT NULL THEN
        RETURN ;
    end if;
    SELECT COUNT(*) INTO COMMENT_COUNT
    FROM "COMMENT" C
    WHERE C.COMMENTOR=:NEW.COMMENTOR AND C.PARENT_COMMENT IS NULL;
    SELECT COUNT(*) INTO ACHIEVEMENT_EXIST
        FROM CLIENT_ACHIEVEMENT CA
         WHERE CA.TITLE='Social Butterfly' AND CA.CLIENT_NAME=:NEW.COMMENTOR;
    IF ACHIEVEMENT_EXIST=1 THEN
        SELECT ACQUIRED_STEPS INTO CUR_ACQUIRED_STEPS FROM CLIENT_ACHIEVEMENT WHERE CLIENT_NAME=:NEW.COMMENTOR AND TITLE='Social Butterfly';
    ELSE
        CUR_ACQUIRED_STEPS:=0;
    end if;
    IF COMMENT_COUNT=0 OR ACHIEVEMENT_EXIST=0 OR(ACHIEVEMENT_EXIST=1 AND CUR_ACQUIRED_STEPS=0) THEN
        SELECT COUNT(*) INTO ACHIEVEMENT_EXIST
        FROM CLIENT_ACHIEVEMENT CA
        WHERE CA.TITLE='Social Butterfly' AND CA.CLIENT_NAME=:NEW.COMMENTOR;
        IF ACHIEVEMENT_EXIST=0 THEN
            INSERT INTO CLIENT_ACHIEVEMENT(TITLE, CLIENT_NAME,ACQUIRED_STEPS)
            VALUES ('Social Butterfly',:NEW.COMMENTOR,1);
        ELSE
            SELECT ACQUIRED_STEPS INTO CUR_ACQUIRED_STEPS FROM CLIENT_ACHIEVEMENT
                WHERE TITLE='Social Butterfly' AND CLIENT_NAME=:NEW.COMMENTOR;
            SELECT TOTAL_STEPS INTO CUR_TOTAL_STEPS FROM ACHIEVEMENT
                WHERE TITLE='Social Butterfly';
            IF CUR_ACQUIRED_STEPS<CUR_TOTAL_STEPS THEN
                UPDATE CLIENT_ACHIEVEMENT
                    SET ACQUIRED_STEPS=(ACQUIRED_STEPS+1)
                    WHERE TITLE='Social Butterfly' AND CLIENT_NAME=:NEW.COMMENTOR;
            end if;
        end if;
    end if;
END;
/
CREATE TRIGGER "C##NAHIAN"."COMMENT_NOTIFICATION_TRIGGER" BEFORE INSERT ON "C##NAHIAN"."COMMENT" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE
    PARENT_COMMENTOR VARCHAR2(20);
    COMMENT_TEXT VARCHAR2(120);
    N_USER_NAME VARCHAR2(20);
    N_TEXT VARCHAR2(200);
    N_SEEN NUMBER;
    N_TIME NUMBER;
    N_TYPE VARCHAR(20);
    N_ID NUMBER;
BEGIN
    IF :NEW.PARENT_COMMENT IS NULL THEN
        return;
    END IF;
    SELECT C1.COMMENTOR INTO PARENT_COMMENTOR
    FROM "COMMENT" C1 WHERE C1.COMMENT_ID= :NEW.PARENT_COMMENT;
    IF PARENT_COMMENTOR= :NEW.COMMENTOR THEN
        return ;
    END IF;
    N_USER_NAME:=PARENT_COMMENTOR;
    N_SEEN:=0;
    N_TIME:=extract(day from(sys_extract_utc(systimestamp) - to_timestamp('1970-01-01', 'YYYY-MM-DD'))) * 86400000
            + to_number(to_char(sys_extract_utc(systimestamp), 'SSSSSFF3'));
    N_TYPE:='COMMENT';
    IF (LENGTH(:NEW.TEXT)>110) THEN
        COMMENT_TEXT:=(SUBSTR(:NEW.TEXT,1,110)||'...');
    ELSE
        COMMENT_TEXT:=:NEW.TEXT;
    end if;
    N_TEXT:=(:NEW.COMMENTOR||' replied to your comment: "'||COMMENT_TEXT||'"');
    INSERT INTO NOTIFICATION(USER_NAME, TEXT, SEEN, TIME, TYPE)
    VALUES(N_USER_NAME,N_TEXT,N_SEEN,N_TIME,N_TYPE)
    RETURNING NOTIFICATION_ID INTO N_ID;

    INSERT INTO COMMENT_NOTIFY(NOTIFICATION_ID, PRODUCT_ID)
    VALUES (N_ID, :NEW.COMMENT_PRODUCT_ID);
END;
/

-- ----------------------------
-- Primary Key structure for table COMMENT_NOTIFY
-- ----------------------------
ALTER TABLE "C##NAHIAN"."COMMENT_NOTIFY" ADD CONSTRAINT "COMMENT_NOTIFY_PK" PRIMARY KEY ("NOTIFICATION_ID");

-- ----------------------------
-- Primary Key structure for table COUNTRY
-- ----------------------------
ALTER TABLE "C##NAHIAN"."COUNTRY" ADD CONSTRAINT "COUNTRY_PK" PRIMARY KEY ("COUNTRY_ID");

-- ----------------------------
-- Uniques structure for table COUNTRY
-- ----------------------------
ALTER TABLE "C##NAHIAN"."COUNTRY" ADD CONSTRAINT "SYS_C007977" UNIQUE ("COUNTRY_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table COUNTRY
-- ----------------------------
ALTER TABLE "C##NAHIAN"."COUNTRY" ADD CONSTRAINT "SYS_C007974" CHECK ("COUNTRY_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."COUNTRY" ADD CONSTRAINT "SYS_C007975" CHECK ("COUNTRY_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table DELIVERYMAN
-- ----------------------------
ALTER TABLE "C##NAHIAN"."DELIVERYMAN" ADD CONSTRAINT "DELIVERY_MAN_PK" PRIMARY KEY ("USER_NAME");

-- ----------------------------
-- Primary Key structure for table DESCRIPT_COMPONENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."DESCRIPT_COMPONENT" ADD CONSTRAINT "DESCRIPT_COMPONENT_PK" PRIMARY KEY ("TITLE");

-- ----------------------------
-- Primary Key structure for table DISTRICT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."DISTRICT" ADD CONSTRAINT "DISTRICT_PK" PRIMARY KEY ("DISTRICT_ID");

-- ----------------------------
-- Checks structure for table DISTRICT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."DISTRICT" ADD CONSTRAINT "DISTRICT_DELIVERY_COST_CHK" CHECK ( DELIVERY_COST>=0 ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."DISTRICT" ADD CONSTRAINT "SYS_C007978" CHECK ("DISTRICT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."DISTRICT" ADD CONSTRAINT "SYS_C007979" CHECK ("DISTRICT_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."DISTRICT" ADD CONSTRAINT "SYS_C007980" CHECK ("COUNTRY_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table GENERAL_USER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."GENERAL_USER" ADD CONSTRAINT "GENERAL_USER_PK" PRIMARY KEY ("USER_NAME");

-- ----------------------------
-- Uniques structure for table GENERAL_USER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."GENERAL_USER" ADD CONSTRAINT "SYS_C008011" UNIQUE ("EMAIL") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table GENERAL_USER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."GENERAL_USER" ADD CONSTRAINT "GENERAL_USER_HAS_ACCOUNT_CHK" CHECK (HAS_ACCOUNT=0 OR HAS_ACCOUNT=1) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."GENERAL_USER" ADD CONSTRAINT "GENERAL_USER_USER_ROLE_CHK" CHECK (USER_ROLE IN ('CLIENT','ADMIN','DELIVERY_MAN','ASSEMBLER')) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."GENERAL_USER" ADD CONSTRAINT "SYS_C007999" CHECK ("PASSWORD" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."GENERAL_USER" ADD CONSTRAINT "SYS_C008000" CHECK ("EMAIL" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."GENERAL_USER" ADD CONSTRAINT "SYS_C008001" CHECK ("FIRST_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."GENERAL_USER" ADD CONSTRAINT "SYS_C008002" CHECK ("LAST_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."GENERAL_USER" ADD CONSTRAINT "SYS_C008004" CHECK ("USER_ROLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."GENERAL_USER" ADD CONSTRAINT "SYS_C008005" CHECK ("HAS_ACCOUNT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."GENERAL_USER" ADD CONSTRAINT "SYS_C008098" CHECK ("ACCOUNT_CREATE_DATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table ITEM
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "ITEM_PK" PRIMARY KEY ("ITEM_ID");

-- ----------------------------
-- Uniques structure for table ITEM
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "SYS_C008033" UNIQUE ("TITLE") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table ITEM
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "ITEM_IS_CONTINUED_CHK" CHECK ( IS_CONTINUED=0 OR IS_CONTINUED=1) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "ITEM_IS_FEATURED_CHK" CHECK ( IS_FEATURED=0 OR IS_FEATURED=1) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "ITEM_PRICE_CHK" CHECK ( PRICE>=0) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "ITEM_TYPE_CHK" CHECK ( TYPE IN ('PRODUCT','OFFER')) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "SYS_C008021" CHECK ("ITEM_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "SYS_C008022" CHECK ("TITLE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "SYS_C008023" CHECK ("PRICE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "SYS_C008024" CHECK ("IS_FEATURED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "SYS_C008025" CHECK ("TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "SYS_C008027" CHECK ("IS_CONTINUED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "SYS_C008097" CHECK ("UPDATE_DATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table MANUFACTURER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."MANUFACTURER" ADD CONSTRAINT "MANUFACTURER_PK" PRIMARY KEY ("MANUFACTURER_ID");

-- ----------------------------
-- Uniques structure for table MANUFACTURER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."MANUFACTURER" ADD CONSTRAINT "SYS_C008020" UNIQUE ("MANUFACTURER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Checks structure for table MANUFACTURER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."MANUFACTURER" ADD CONSTRAINT "MANUFACTURER_IS_VALID_CHK" CHECK (  IS_VALID=1 OR IS_VALID=0) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."MANUFACTURER" ADD CONSTRAINT "SYS_C008015" CHECK ("MANUFACTURER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."MANUFACTURER" ADD CONSTRAINT "SYS_C008016" CHECK ("MANUFACTURER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."MANUFACTURER" ADD CONSTRAINT "SYS_C008017" CHECK ("IS_VALID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table NOTIFICATION
-- ----------------------------
ALTER TABLE "C##NAHIAN"."NOTIFICATION" ADD CONSTRAINT "NOTIFICATION_PK" PRIMARY KEY ("NOTIFICATION_ID");

-- ----------------------------
-- Checks structure for table NOTIFICATION
-- ----------------------------
ALTER TABLE "C##NAHIAN"."NOTIFICATION" ADD CONSTRAINT "NOTIFICATION_SEEN_CHK" CHECK ( SEEN=0 OR SEEN=1 ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."NOTIFICATION" ADD CONSTRAINT "NOTIFICATION_TYPE_CHK" CHECK ( TYPE IN ('ORDER','COMMENT') ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."NOTIFICATION" ADD CONSTRAINT "SYS_C008376" CHECK ("NOTIFICATION_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."NOTIFICATION" ADD CONSTRAINT "SYS_C008377" CHECK ("USER_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."NOTIFICATION" ADD CONSTRAINT "SYS_C008378" CHECK ("TEXT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."NOTIFICATION" ADD CONSTRAINT "SYS_C008379" CHECK ("SEEN" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."NOTIFICATION" ADD CONSTRAINT "SYS_C008380" CHECK ("TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."NOTIFICATION" ADD CONSTRAINT "SYS_C008381" CHECK ("TYPE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table NUMERIC_COMPONENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."NUMERIC_COMPONENT" ADD CONSTRAINT "NUMERIC_COMPONENT_PK" PRIMARY KEY ("TITLE");

-- ----------------------------
-- Checks structure for table NUMERIC_COMPONENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."NUMERIC_COMPONENT" ADD CONSTRAINT "SYS_C008264" CHECK ("UNIT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table OFFER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."OFFER" ADD CONSTRAINT "OFFER_PK" PRIMARY KEY ("ITEM_ID");

-- ----------------------------
-- Primary Key structure for table OFFER_FREE_PRODUCTS
-- ----------------------------
ALTER TABLE "C##NAHIAN"."OFFER_FREE_PRODUCTS" ADD CONSTRAINT "OFFER_FREE_PRODUCTS_PK" PRIMARY KEY ("OFFER_ID", "PRODUCT_ID");

-- ----------------------------
-- Checks structure for table OFFER_FREE_PRODUCTS
-- ----------------------------
ALTER TABLE "C##NAHIAN"."OFFER_FREE_PRODUCTS" ADD CONSTRAINT "OFFER_FREE_PRODUCTS_COUNT_CHK" CHECK ( COUNT>0) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."OFFER_FREE_PRODUCTS" ADD CONSTRAINT "SYS_C008051" CHECK ("COUNT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table OFFER_PRODUCTS
-- ----------------------------
ALTER TABLE "C##NAHIAN"."OFFER_PRODUCTS" ADD CONSTRAINT "OFFER_PRODUCTS_PK" PRIMARY KEY ("OFFER_ID", "PRODUCT_ID");

-- ----------------------------
-- Checks structure for table OFFER_PRODUCTS
-- ----------------------------
ALTER TABLE "C##NAHIAN"."OFFER_PRODUCTS" ADD CONSTRAINT "OFFER_PRODUCTS_COUNT_CHK" CHECK ( COUNT>0) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."OFFER_PRODUCTS" ADD CONSTRAINT "SYS_C008046" CHECK ("COUNT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table ORDER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "ORDER_PK" PRIMARY KEY ("ORDER_ID");

-- ----------------------------
-- Checks structure for table ORDER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "ORDER_STATUS_CHK" CHECK ( ORDER_STATUS IN('PLACED','PAY_CONFIRMED','ASSEMBLED','ON_DELIVERY','DELIVERED') ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "SYS_C008191" CHECK ("ORDER_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "SYS_C008192" CHECK ("TOTAL_PRICE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "SYS_C008193" CHECK ("DESTINATION_ADDRESS" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "SYS_C008194" CHECK ("ORDER_DATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "SYS_C008195" CHECK ("DESTINATION_SUB_DISTRICT" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "SYS_C008412" CHECK ("DELIVERY_COST" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "SYS_C008467" CHECK ("HAS_REDEEMED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "SYS_C008468" CHECK ( HAS_REDEEMED=0 OR HAS_REDEEMED=1 ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Triggers structure for table ORDER
-- ----------------------------
CREATE TRIGGER "C##NAHIAN"."CATEGORY_ACHIEVEMENT_TRIGGER" AFTER UPDATE OF "ORDER_STATUS" ON "C##NAHIAN"."ORDER" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE
    ITEM_CATEGORY VARCHAR2(100);
    ITEM_TYPE     VARCHAR2(10);
    ITEM_QUANTITY NUMBER;
    A_STEPS       NUMBER;
    T_STEPS       NUMBER;
    A_TITLE VARCHAR2(30);
    ACHIEVEMENT_EXISTS NUMBER;
BEGIN
    IF (:NEW.ORDER_STATUS != 'PAY_CONFIRMED') then
        return;
    end if;
    FOR R IN (SELECT OT.ITEM_ID IT_ID FROM ORDER_ITEM OT WHERE OT.ORDER_ID = :NEW.ORDER_ID )
        LOOP
            SELECT OT.QUANTITY
            INTO ITEM_QUANTITY
            FROM ORDER_ITEM OT
            WHERE OT.ORDER_ID = :NEW.ORDER_ID AND OT.ITEM_ID = R.IT_ID;
            SELECT I.TYPE INTO ITEM_TYPE FROM ITEM I WHERE I.ITEM_ID = R.IT_ID;
            IF ITEM_TYPE = 'PRODUCT' THEN
                SELECT C2.CATEGORY_NAME
                INTO ITEM_CATEGORY
                FROM PRODUCT P
                         JOIN CATEGORY C2
                              on C2.CATEGORY_ID = P.CATEGORY
                WHERE P.ITEM_ID = R.IT_ID;
                IF ITEM_CATEGORY = 'IC' THEN
                    A_TITLE:='Digital Dilemma';
                    SELECT COUNT(*) INTO ACHIEVEMENT_EXISTS FROM CLIENT_ACHIEVEMENT CA WHERE CA.CLIENT_NAME=:NEW.CLIENT_NAME AND CA.TITLE=A_TITLE;
                    IF ACHIEVEMENT_EXISTS>=1 THEN
                        SELECT CA.ACQUIRED_STEPS INTO A_STEPS FROM CLIENT_ACHIEVEMENT CA WHERE CA.CLIENT_NAME=:NEW.CLIENT_NAME AND CA.TITLE=A_TITLE;
                        SELECT TOTAL_STEPS INTO T_STEPS FROM ACHIEVEMENT WHERE TITLE=A_TITLE;
                        IF (T_STEPS >= (A_STEPS + ITEM_QUANTITY)) THEN
                            UPDATE CLIENT_ACHIEVEMENT
                            SET ACQUIRED_STEPS=A_STEPS +ITEM_QUANTITY WHERE TITLE=A_TITLE AND CLIENT_NAME=:NEW.CLIENT_NAME;
                        ELSIF (T_STEPS < (A_STEPS + ITEM_QUANTITY)) THEN
                            UPDATE CLIENT_ACHIEVEMENT
                            SET ACQUIRED_STEPS=T_STEPS WHERE TITLE=A_TITLE AND CLIENT_NAME=:NEW.CLIENT_NAME;
                        end if;
                    ELSE
                        SELECT TOTAL_STEPS INTO T_STEPS FROM ACHIEVEMENT WHERE TITLE=A_TITLE;
                        IF (T_STEPS >= ITEM_QUANTITY) THEN
                            INSERT INTO CLIENT_ACHIEVEMENT(TITLE, CLIENT_NAME,ACQUIRED_STEPS)
                            VALUES (A_TITLE,:NEW.CLIENT_NAME,ITEM_QUANTITY);
                        ELSE
                            INSERT INTO CLIENT_ACHIEVEMENT(TITLE, CLIENT_NAME,ACQUIRED_STEPS)
                            VALUES (A_TITLE,:NEW.CLIENT_NAME,T_STEPS);
                        END IF;
                    end if;
                    --
                ELSIF ITEM_CATEGORY = 'Desktop' THEN
                    A_TITLE:='PC Master Race';
                    SELECT COUNT(*) INTO ACHIEVEMENT_EXISTS FROM CLIENT_ACHIEVEMENT CA WHERE CA.CLIENT_NAME=:NEW.CLIENT_NAME AND CA.TITLE=A_TITLE;
                    IF ACHIEVEMENT_EXISTS>=1 THEN
                        SELECT CA.ACQUIRED_STEPS INTO A_STEPS FROM CLIENT_ACHIEVEMENT CA WHERE CA.CLIENT_NAME=:NEW.CLIENT_NAME AND CA.TITLE=A_TITLE;
                        SELECT TOTAL_STEPS INTO T_STEPS FROM ACHIEVEMENT WHERE TITLE=A_TITLE;
                        IF (T_STEPS >= (A_STEPS + ITEM_QUANTITY)) THEN
                            UPDATE CLIENT_ACHIEVEMENT
                            SET ACQUIRED_STEPS=A_STEPS +ITEM_QUANTITY WHERE TITLE=A_TITLE AND CLIENT_NAME=:NEW.CLIENT_NAME;
                        ELSIF (T_STEPS < (A_STEPS + ITEM_QUANTITY)) THEN
                            UPDATE CLIENT_ACHIEVEMENT
                            SET ACQUIRED_STEPS=T_STEPS WHERE TITLE=A_TITLE AND CLIENT_NAME=:NEW.CLIENT_NAME;
                        end if;
                    ELSE
                        SELECT TOTAL_STEPS INTO T_STEPS FROM ACHIEVEMENT WHERE TITLE=A_TITLE;
                        IF (T_STEPS >= ITEM_QUANTITY) THEN
                            INSERT INTO CLIENT_ACHIEVEMENT(TITLE, CLIENT_NAME,ACQUIRED_STEPS)
                            VALUES (A_TITLE,:NEW.CLIENT_NAME,ITEM_QUANTITY);
                        ELSE
                            INSERT INTO CLIENT_ACHIEVEMENT(TITLE, CLIENT_NAME,ACQUIRED_STEPS)
                            VALUES (A_TITLE,:NEW.CLIENT_NAME,T_STEPS);
                        END IF;
                    end if;
                ELSIF ITEM_CATEGORY = 'Electrical Machinery' THEN
                    A_TITLE:='Rough Hands';
                    SELECT COUNT(*) INTO ACHIEVEMENT_EXISTS FROM CLIENT_ACHIEVEMENT CA WHERE CA.CLIENT_NAME=:NEW.CLIENT_NAME AND CA.TITLE=A_TITLE;
                    IF ACHIEVEMENT_EXISTS>=1 THEN
                        SELECT CA.ACQUIRED_STEPS INTO A_STEPS FROM CLIENT_ACHIEVEMENT CA WHERE CA.CLIENT_NAME=:NEW.CLIENT_NAME AND CA.TITLE=A_TITLE;
                        SELECT TOTAL_STEPS INTO T_STEPS FROM ACHIEVEMENT WHERE TITLE=A_TITLE;
                        IF (T_STEPS >= (A_STEPS + ITEM_QUANTITY)) THEN
                            UPDATE CLIENT_ACHIEVEMENT
                            SET ACQUIRED_STEPS=A_STEPS +ITEM_QUANTITY WHERE TITLE=A_TITLE AND CLIENT_NAME=:NEW.CLIENT_NAME;
                        ELSIF (T_STEPS < (A_STEPS + ITEM_QUANTITY)) THEN
                            UPDATE CLIENT_ACHIEVEMENT
                            SET ACQUIRED_STEPS=T_STEPS WHERE TITLE=A_TITLE AND CLIENT_NAME=:NEW.CLIENT_NAME;
                        end if;
                    ELSE
                        SELECT TOTAL_STEPS INTO T_STEPS FROM ACHIEVEMENT WHERE TITLE=A_TITLE;
                        IF (T_STEPS >= ITEM_QUANTITY) THEN
                            INSERT INTO CLIENT_ACHIEVEMENT(TITLE, CLIENT_NAME,ACQUIRED_STEPS)
                            VALUES (A_TITLE,:NEW.CLIENT_NAME,ITEM_QUANTITY);
                        ELSE
                            INSERT INTO CLIENT_ACHIEVEMENT(TITLE, CLIENT_NAME,ACQUIRED_STEPS)
                            VALUES (A_TITLE,:NEW.CLIENT_NAME,T_STEPS);
                        END IF;
                    end if;
                ELSIF ITEM_CATEGORY = 'Robotics' THEN
                    A_TITLE:='I,Robot';
                    SELECT COUNT(*) INTO ACHIEVEMENT_EXISTS FROM CLIENT_ACHIEVEMENT CA WHERE CA.CLIENT_NAME=:NEW.CLIENT_NAME AND CA.TITLE=A_TITLE;
                    IF ACHIEVEMENT_EXISTS>=1 THEN
                        SELECT CA.ACQUIRED_STEPS INTO A_STEPS FROM CLIENT_ACHIEVEMENT CA WHERE CA.CLIENT_NAME=:NEW.CLIENT_NAME AND CA.TITLE=A_TITLE;
                        SELECT TOTAL_STEPS INTO T_STEPS FROM ACHIEVEMENT WHERE TITLE=A_TITLE;
                        IF (T_STEPS >= (A_STEPS + ITEM_QUANTITY)) THEN
                            UPDATE CLIENT_ACHIEVEMENT
                            SET ACQUIRED_STEPS=A_STEPS +ITEM_QUANTITY WHERE TITLE=A_TITLE AND CLIENT_NAME=:NEW.CLIENT_NAME;
                        ELSIF (T_STEPS < (A_STEPS + ITEM_QUANTITY)) THEN
                            UPDATE CLIENT_ACHIEVEMENT
                            SET ACQUIRED_STEPS=T_STEPS WHERE TITLE=A_TITLE AND CLIENT_NAME=:NEW.CLIENT_NAME;
                        end if;
                    ELSE
                        SELECT TOTAL_STEPS INTO T_STEPS FROM ACHIEVEMENT WHERE TITLE=A_TITLE;
                        IF (T_STEPS >= ITEM_QUANTITY) THEN
                            INSERT INTO CLIENT_ACHIEVEMENT(TITLE, CLIENT_NAME,ACQUIRED_STEPS)
                            VALUES (A_TITLE,:NEW.CLIENT_NAME,ITEM_QUANTITY);
                        ELSE
                            INSERT INTO CLIENT_ACHIEVEMENT(TITLE, CLIENT_NAME,ACQUIRED_STEPS)
                            VALUES (A_TITLE,:NEW.CLIENT_NAME,T_STEPS);
                        END IF;
                    end if;
                ELSIF ITEM_CATEGORY = 'Experimental Weapons' THEN
                    A_TITLE:='Metal Massacre';
                    SELECT COUNT(*) INTO ACHIEVEMENT_EXISTS FROM CLIENT_ACHIEVEMENT CA WHERE CA.CLIENT_NAME=:NEW.CLIENT_NAME AND CA.TITLE=A_TITLE;
                    IF ACHIEVEMENT_EXISTS>=1 THEN
                        SELECT CA.ACQUIRED_STEPS INTO A_STEPS FROM CLIENT_ACHIEVEMENT CA WHERE CA.CLIENT_NAME=:NEW.CLIENT_NAME AND CA.TITLE=A_TITLE;
                        SELECT TOTAL_STEPS INTO T_STEPS FROM ACHIEVEMENT WHERE TITLE=A_TITLE;
                        IF (T_STEPS >= (A_STEPS + ITEM_QUANTITY)) THEN
                            UPDATE CLIENT_ACHIEVEMENT
                            SET ACQUIRED_STEPS=A_STEPS +ITEM_QUANTITY WHERE TITLE=A_TITLE AND CLIENT_NAME=:NEW.CLIENT_NAME;
                        ELSIF (T_STEPS < (A_STEPS + ITEM_QUANTITY)) THEN
                            UPDATE CLIENT_ACHIEVEMENT
                            SET ACQUIRED_STEPS=T_STEPS WHERE TITLE=A_TITLE AND CLIENT_NAME=:NEW.CLIENT_NAME;
                        end if;
                    ELSE
                        SELECT TOTAL_STEPS INTO T_STEPS FROM ACHIEVEMENT WHERE TITLE=A_TITLE;
                        IF (T_STEPS >= ITEM_QUANTITY) THEN
                            INSERT INTO CLIENT_ACHIEVEMENT(TITLE, CLIENT_NAME,ACQUIRED_STEPS)
                            VALUES (A_TITLE,:NEW.CLIENT_NAME,ITEM_QUANTITY);
                        ELSE
                            INSERT INTO CLIENT_ACHIEVEMENT(TITLE, CLIENT_NAME,ACQUIRED_STEPS)
                            VALUES (A_TITLE,:NEW.CLIENT_NAME,T_STEPS);
                        END IF;
                    end if;
                end if;
            end if;
        end loop;
EXCEPTION
    WHEN OTHERS THEN
    RETURN ;
end;
/
CREATE TRIGGER "C##NAHIAN"."ORDER_LOCATION_NOTIFICATION_TRIGGER" AFTER INSERT OR UPDATE OF "CURRENT_SUB_DISTRICT" ON "C##NAHIAN"."ORDER" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE
    N_USER_NAME VARCHAR2(20);
    N_TEXT VARCHAR2(200);
    N_SEEN NUMBER;
    N_TIME NUMBER;
    N_TYPE VARCHAR(20);
    CUR_SUB_DISTRICT_NAME VARCHAR2(20);
    CUR_DISTRICT_NAME VARCHAR2(20);
BEGIN
    IF :NEW.CURRENT_SUB_DISTRICT IS NULL THEN
       RETURN;
    END IF;
    SELECT SUB_DISTRICT_NAME INTO CUR_SUB_DISTRICT_NAME
    FROM SUB_DISTRICT WHERE SUB_DISTRICT_ID= :NEW.CURRENT_SUB_DISTRICT;

    SELECT DISTRICT_NAME INTO CUR_DISTRICT_NAME
    FROM SUB_DISTRICT JOIN DISTRICT
    ON SUB_DISTRICT.DISTRICT_ID = DISTRICT.DISTRICT_ID
    WHERE SUB_DISTRICT_ID=:NEW.CURRENT_SUB_DISTRICT;

    N_TEXT:='Your Order is currently at: '||CUR_SUB_DISTRICT_NAME||','||CUR_DISTRICT_NAME||'.';

    N_USER_NAME:=:NEW.CLIENT_NAME;
    N_SEEN:=0;
    N_TIME:=extract(day from(sys_extract_utc(systimestamp) - to_timestamp('1970-01-01', 'YYYY-MM-DD'))) * 86400000
            + to_number(to_char(sys_extract_utc(systimestamp), 'SSSSSFF3'));
    N_TYPE:='ORDER';
    INSERT INTO NOTIFICATION(USER_NAME, TEXT, SEEN, TIME, TYPE)
    VALUES(N_USER_NAME,N_TEXT,N_SEEN,N_TIME,N_TYPE);
END;
/
CREATE TRIGGER "C##NAHIAN"."ORDER_NOTIFICATION_TRIGGER" AFTER UPDATE OF "ORDER_STATUS" ON "C##NAHIAN"."ORDER" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
DECLARE
    N_USER_NAME VARCHAR2(20);
    N_TEXT VARCHAR2(200);
    N_SEEN NUMBER;
    N_TIME NUMBER;
    N_TYPE VARCHAR(20);
BEGIN

    IF :NEW.ORDER_STATUS='ASSEMBLED' THEN
        N_TEXT:='Your Order with ID "'||:NEW.ORDER_ID||'" has been assembled and ready to be delivered!' ||
                ' Thanks for staying with TechShop!';

    ELSIF :NEW.ORDER_STATUS='ON_DELIVERY' THEN
         N_TEXT:='Your Order with ID "'||:NEW.ORDER_ID||'" is now on its way!' ||
                ' Thanks for staying with TechShop!';
    ELSIF :NEW.ORDER_STATUS='DELIVERED' THEN
         N_TEXT:='Your Order with ID "'||:NEW.ORDER_ID||'" has been delivered!' ||
                ' Thanks for staying with TechShop!';
    ELSE
        RETURN ;
    end if;
    N_USER_NAME:=:NEW.CLIENT_NAME;
    N_SEEN:=0;
    N_TIME:=extract(day from(sys_extract_utc(systimestamp) - to_timestamp('1970-01-01', 'YYYY-MM-DD'))) * 86400000
            + to_number(to_char(sys_extract_utc(systimestamp), 'SSSSSFF3'));
    N_TYPE:='ORDER';
    INSERT INTO NOTIFICATION(USER_NAME, TEXT, SEEN, TIME, TYPE)
    VALUES(N_USER_NAME,N_TEXT,N_SEEN,N_TIME,N_TYPE);
END;
/

-- ----------------------------
-- Primary Key structure for table ORDER_ITEM
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ORDER_ITEM" ADD CONSTRAINT "ORDER_ITEM_PK" PRIMARY KEY ("ORDER_ID", "ITEM_ID");

-- ----------------------------
-- Checks structure for table ORDER_ITEM
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ORDER_ITEM" ADD CONSTRAINT "ORDER_ITEM_QUANTITY_CHK" CHECK ( QUANTITY>0) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER_ITEM" ADD CONSTRAINT "SYS_C008215" CHECK ("QUANTITY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER_ITEM" ADD CONSTRAINT "SYS_C008411" CHECK ("UNIT_PRICE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table PRODUCT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."PRODUCT" ADD CONSTRAINT "PRODUCT_PK" PRIMARY KEY ("ITEM_ID");

-- ----------------------------
-- Checks structure for table PRODUCT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."PRODUCT" ADD CONSTRAINT "PRODUCT_DISCOUNT_CHK" CHECK ( DISCOUNT>=0 AND DISCOUNT<=100) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."PRODUCT" ADD CONSTRAINT "PRODUCT_STOCK_CHK" CHECK ( STOCK>=0) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."PRODUCT" ADD CONSTRAINT "SYS_C008035" CHECK ("STOCK" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."PRODUCT" ADD CONSTRAINT "SYS_C008036" CHECK ("CATEGORY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."PRODUCT" ADD CONSTRAINT "SYS_C008037" CHECK ("MANUFACTURER" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table PRODUCT_CONTAINS
-- ----------------------------
ALTER TABLE "C##NAHIAN"."PRODUCT_CONTAINS" ADD CONSTRAINT "PRODUCT_CONTAINS_PK" PRIMARY KEY ("PARENT_PRODUCT", "CHILD_PRODUCT");

-- ----------------------------
-- Primary Key structure for table PROD_GEN_COMPONENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."PROD_GEN_COMPONENT" ADD CONSTRAINT "PROD_GEN_COMPONENT_PK" PRIMARY KEY ("PRODUCT_ID", "COMPONENT_TITLE");

-- ----------------------------
-- Checks structure for table PROD_GEN_COMPONENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."PROD_GEN_COMPONENT" ADD CONSTRAINT "SYS_C008269" CHECK ("SPECIFICATION" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table PROD_NUM_COMPONENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."PROD_NUM_COMPONENT" ADD CONSTRAINT "PROD_NUM_COMPONENT_PK" PRIMARY KEY ("PRODUCT_ID", "COMPONENT_TITLE");

-- ----------------------------
-- Checks structure for table PROD_NUM_COMPONENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."PROD_NUM_COMPONENT" ADD CONSTRAINT "SYS_C008276" CHECK ("VALUE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table REVIEW
-- ----------------------------
ALTER TABLE "C##NAHIAN"."REVIEW" ADD CONSTRAINT "REVIEW_PK" PRIMARY KEY ("USER_NAME", "PRODUCT_ID");

-- ----------------------------
-- Checks structure for table REVIEW
-- ----------------------------
ALTER TABLE "C##NAHIAN"."REVIEW" ADD CONSTRAINT "REVIEW_CHK" CHECK ( RATING>=0.0 AND RATING<=5.0) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."REVIEW" ADD CONSTRAINT "REVIEW_TITLE_DESC_CHK" CHECK ( TITLE IS NOT NULL OR DESCRIPTION IS NULL ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."REVIEW" ADD CONSTRAINT "SYS_C008206" CHECK ("RATING" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."REVIEW" ADD CONSTRAINT "SYS_C008207" CHECK ("REVIEW_DATE" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table STOCK_REQUEST
-- ----------------------------
ALTER TABLE "C##NAHIAN"."STOCK_REQUEST" ADD CONSTRAINT "SYS_C008442" PRIMARY KEY ("PRODUCT_ID");

-- ----------------------------
-- Checks structure for table STOCK_REQUEST
-- ----------------------------
ALTER TABLE "C##NAHIAN"."STOCK_REQUEST" ADD CONSTRAINT "STOCK_REQUEST_QUANTITY_CHK" CHECK ( QUANTITY>0 ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."STOCK_REQUEST" ADD CONSTRAINT "SYS_C008438" CHECK ("QUANTITY" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table SUB_DISTRICT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."SUB_DISTRICT" ADD CONSTRAINT "SUB_DISTRICT_PK" PRIMARY KEY ("SUB_DISTRICT_ID");

-- ----------------------------
-- Checks structure for table SUB_DISTRICT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."SUB_DISTRICT" ADD CONSTRAINT "SUB_DISTRICT_DELIVERY_SUPPORTED_CHK" CHECK ( DELIVERY_SUPPORTED=0 OR DELIVERY_SUPPORTED=1 ) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."SUB_DISTRICT" ADD CONSTRAINT "SYS_C007984" CHECK ("SUB_DISTRICT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."SUB_DISTRICT" ADD CONSTRAINT "SYS_C007985" CHECK ("SUB_DISTRICT_NAME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."SUB_DISTRICT" ADD CONSTRAINT "SYS_C007986" CHECK ("DISTRICT_ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."SUB_DISTRICT" ADD CONSTRAINT "SYS_C007987" CHECK ("DELIVERY_SUPPORTED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Primary Key structure for table WISHLIST
-- ----------------------------
ALTER TABLE "C##NAHIAN"."WISHLIST" ADD CONSTRAINT "WISHLIST_PK" PRIMARY KEY ("CLIENT_NAME", "ITEM_ID");

-- ----------------------------
-- Foreign Keys structure for table ADMIN
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ADMIN" ADD CONSTRAINT "ADMIN_GENERAL_USER_FK" FOREIGN KEY ("USER_NAME") REFERENCES "C##NAHIAN"."GENERAL_USER" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table ASSEMBLER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ASSEMBLER" ADD CONSTRAINT "ASSEMBLER_GENERAL_USER_FK" FOREIGN KEY ("USER_NAME") REFERENCES "C##NAHIAN"."GENERAL_USER" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table CLIENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CLIENT" ADD CONSTRAINT "CLIENT_GENERAL_USER_FK" FOREIGN KEY ("USER_NAME") REFERENCES "C##NAHIAN"."GENERAL_USER" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table CLIENT_ACHIEVEMENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CLIENT_ACHIEVEMENT" ADD CONSTRAINT "SYS_C008458" FOREIGN KEY ("CLIENT_NAME") REFERENCES "C##NAHIAN"."CLIENT" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."CLIENT_ACHIEVEMENT" ADD CONSTRAINT "SYS_C008459" FOREIGN KEY ("TITLE") REFERENCES "C##NAHIAN"."ACHIEVEMENT" ("TITLE") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table CLIENT_CART
-- ----------------------------
ALTER TABLE "C##NAHIAN"."CLIENT_CART" ADD CONSTRAINT "CLIENT_CART_CLIENT_FK" FOREIGN KEY ("CLIENT_NAME") REFERENCES "C##NAHIAN"."CLIENT" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."CLIENT_CART" ADD CONSTRAINT "CLIENT_CART_ITEM_FK" FOREIGN KEY ("ITEM_ID") REFERENCES "C##NAHIAN"."ITEM" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table COMMENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."COMMENT" ADD CONSTRAINT "COMMENT_CLIENT_FK" FOREIGN KEY ("COMMENTOR") REFERENCES "C##NAHIAN"."CLIENT" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."COMMENT" ADD CONSTRAINT "COMMENT_PARENT_FK" FOREIGN KEY ("PARENT_COMMENT") REFERENCES "C##NAHIAN"."COMMENT" ("COMMENT_ID") ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."COMMENT" ADD CONSTRAINT "COMMENT_PRODUCT_FK" FOREIGN KEY ("COMMENT_PRODUCT_ID") REFERENCES "C##NAHIAN"."PRODUCT" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table COMMENT_NOTIFY
-- ----------------------------
ALTER TABLE "C##NAHIAN"."COMMENT_NOTIFY" ADD CONSTRAINT "COMMENT_NOTIFY_NOTIFICATION" FOREIGN KEY ("NOTIFICATION_ID") REFERENCES "C##NAHIAN"."NOTIFICATION" ("NOTIFICATION_ID") ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."COMMENT_NOTIFY" ADD CONSTRAINT "COMMENT_NOTIFY_PRODUCT_FK" FOREIGN KEY ("PRODUCT_ID") REFERENCES "C##NAHIAN"."PRODUCT" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table DELIVERYMAN
-- ----------------------------
ALTER TABLE "C##NAHIAN"."DELIVERYMAN" ADD CONSTRAINT "DELIVERY_MAN_GENERAL_USER_FK" FOREIGN KEY ("USER_NAME") REFERENCES "C##NAHIAN"."GENERAL_USER" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table DISTRICT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."DISTRICT" ADD CONSTRAINT "DISTRICT_COUNTRY_FK" FOREIGN KEY ("COUNTRY_ID") REFERENCES "C##NAHIAN"."COUNTRY" ("COUNTRY_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table ITEM
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ITEM" ADD CONSTRAINT "ITEM_UPDATE_BY_ADMIN_FK" FOREIGN KEY ("UPDATED_BY") REFERENCES "C##NAHIAN"."ADMIN" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table NOTIFICATION
-- ----------------------------
ALTER TABLE "C##NAHIAN"."NOTIFICATION" ADD CONSTRAINT "NOTIFICATION_USER_FK" FOREIGN KEY ("USER_NAME") REFERENCES "C##NAHIAN"."GENERAL_USER" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table OFFER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."OFFER" ADD CONSTRAINT "OFFER_ITEM_FK" FOREIGN KEY ("ITEM_ID") REFERENCES "C##NAHIAN"."ITEM" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table OFFER_FREE_PRODUCTS
-- ----------------------------
ALTER TABLE "C##NAHIAN"."OFFER_FREE_PRODUCTS" ADD CONSTRAINT "OFFER_FREE_PRODUCTS_OFFER_FK" FOREIGN KEY ("OFFER_ID") REFERENCES "C##NAHIAN"."OFFER" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."OFFER_FREE_PRODUCTS" ADD CONSTRAINT "OFFER_FREE_PRODUCTS_PRODUCT_FK" FOREIGN KEY ("PRODUCT_ID") REFERENCES "C##NAHIAN"."PRODUCT" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table OFFER_PRODUCTS
-- ----------------------------
ALTER TABLE "C##NAHIAN"."OFFER_PRODUCTS" ADD CONSTRAINT "OFFER_PRODUCTS_OFFER_FK" FOREIGN KEY ("OFFER_ID") REFERENCES "C##NAHIAN"."OFFER" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."OFFER_PRODUCTS" ADD CONSTRAINT "OFFER_PRODUCTS_PRODUCT_FK" FOREIGN KEY ("PRODUCT_ID") REFERENCES "C##NAHIAN"."PRODUCT" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table ORDER
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "ORDER_ASSEMBLER_FK" FOREIGN KEY ("ASSEMBLER_NAME") REFERENCES "C##NAHIAN"."ASSEMBLER" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "ORDER_CLIENT_FK" FOREIGN KEY ("CLIENT_NAME") REFERENCES "C##NAHIAN"."CLIENT" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "ORDER_CURRENT_SUB_DISTRICT_FK" FOREIGN KEY ("CURRENT_SUB_DISTRICT") REFERENCES "C##NAHIAN"."SUB_DISTRICT" ("SUB_DISTRICT_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "ORDER_DELIVERYMAN_FK" FOREIGN KEY ("DELIVERMAN_NAME") REFERENCES "C##NAHIAN"."DELIVERYMAN" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER" ADD CONSTRAINT "ORDER_DEST_SUB_DISTRICT_FK" FOREIGN KEY ("DESTINATION_SUB_DISTRICT") REFERENCES "C##NAHIAN"."SUB_DISTRICT" ("SUB_DISTRICT_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table ORDER_ITEM
-- ----------------------------
ALTER TABLE "C##NAHIAN"."ORDER_ITEM" ADD CONSTRAINT "ORDER_ITEM_ITEM_FK" FOREIGN KEY ("ITEM_ID") REFERENCES "C##NAHIAN"."ITEM" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."ORDER_ITEM" ADD CONSTRAINT "ORDER_ITEM_ORDER_FK" FOREIGN KEY ("ORDER_ID") REFERENCES "C##NAHIAN"."ORDER" ("ORDER_ID") ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table PRODUCT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."PRODUCT" ADD CONSTRAINT "PRODUCT_CATEGORY_FK" FOREIGN KEY ("CATEGORY") REFERENCES "C##NAHIAN"."CATEGORY" ("CATEGORY_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."PRODUCT" ADD CONSTRAINT "PRODUCT_ITEM_FK" FOREIGN KEY ("ITEM_ID") REFERENCES "C##NAHIAN"."ITEM" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."PRODUCT" ADD CONSTRAINT "PRODUCT_MANUFACTURER_FK" FOREIGN KEY ("MANUFACTURER") REFERENCES "C##NAHIAN"."MANUFACTURER" ("MANUFACTURER_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table PRODUCT_CONTAINS
-- ----------------------------
ALTER TABLE "C##NAHIAN"."PRODUCT_CONTAINS" ADD CONSTRAINT "PRODUCT_CONTAINS_CHILD_PRODUCT_FK" FOREIGN KEY ("CHILD_PRODUCT") REFERENCES "C##NAHIAN"."PRODUCT" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."PRODUCT_CONTAINS" ADD CONSTRAINT "PRODUCT_CONTAINS_PARENT_PRODUCT_FK" FOREIGN KEY ("PARENT_PRODUCT") REFERENCES "C##NAHIAN"."PRODUCT" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table PROD_GEN_COMPONENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."PROD_GEN_COMPONENT" ADD CONSTRAINT "PROD_GEN_COMPONENT_GEN_COMP_FK" FOREIGN KEY ("COMPONENT_TITLE") REFERENCES "C##NAHIAN"."DESCRIPT_COMPONENT" ("TITLE") ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."PROD_GEN_COMPONENT" ADD CONSTRAINT "PROD_GEN_COMPONENT_PROD_FK" FOREIGN KEY ("PRODUCT_ID") REFERENCES "C##NAHIAN"."PRODUCT" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table PROD_NUM_COMPONENT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."PROD_NUM_COMPONENT" ADD CONSTRAINT "PROD_NUM_COMPONENT_NUM_COMP_FK" FOREIGN KEY ("COMPONENT_TITLE") REFERENCES "C##NAHIAN"."NUMERIC_COMPONENT" ("TITLE") ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."PROD_NUM_COMPONENT" ADD CONSTRAINT "PROD_NUM_COMPONENT_PROD_FK" FOREIGN KEY ("PRODUCT_ID") REFERENCES "C##NAHIAN"."PRODUCT" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table REVIEW
-- ----------------------------
ALTER TABLE "C##NAHIAN"."REVIEW" ADD CONSTRAINT "REVIEW_CLIENT_FK" FOREIGN KEY ("USER_NAME") REFERENCES "C##NAHIAN"."CLIENT" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."REVIEW" ADD CONSTRAINT "REVIEW_PRODUCT_FK" FOREIGN KEY ("PRODUCT_ID") REFERENCES "C##NAHIAN"."PRODUCT" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table STOCK_REQUEST
-- ----------------------------
ALTER TABLE "C##NAHIAN"."STOCK_REQUEST" ADD CONSTRAINT "SYS_C008443" FOREIGN KEY ("PRODUCT_ID") REFERENCES "C##NAHIAN"."PRODUCT" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table SUB_DISTRICT
-- ----------------------------
ALTER TABLE "C##NAHIAN"."SUB_DISTRICT" ADD CONSTRAINT "SUB_DISTRICT_DISTRICT_FK" FOREIGN KEY ("DISTRICT_ID") REFERENCES "C##NAHIAN"."DISTRICT" ("DISTRICT_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- ----------------------------
-- Foreign Keys structure for table WISHLIST
-- ----------------------------
ALTER TABLE "C##NAHIAN"."WISHLIST" ADD CONSTRAINT "WISHLIST_CLIENT_FK" FOREIGN KEY ("CLIENT_NAME") REFERENCES "C##NAHIAN"."CLIENT" ("USER_NAME") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
ALTER TABLE "C##NAHIAN"."WISHLIST" ADD CONSTRAINT "WISHLIST_ITEM_FK" FOREIGN KEY ("ITEM_ID") REFERENCES "C##NAHIAN"."ITEM" ("ITEM_ID") NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;