2023-03-15.sql

/*
 Navicat Premium Data Transfer

 Source Server         : Solar
 Source Server Type    : PostgreSQL
 Source Server Version : 160001 (160001)
 Source Host           : localhost:5432
 Source Catalog        : AFF
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 160001 (160001)
 File Encoding         : 65001

 Date: 15/03/2024 06:07:13
*/


-- ----------------------------
-- Type structure for week
-- ----------------------------
DROP TYPE IF EXISTS "public"."week";
CREATE TYPE "public"."week" AS ENUM (
  'Mon',
  'Tue',
  'Wed',
  'Thu',
  'Fri',
  'Sat',
  'Sun'
);
ALTER TYPE "public"."week" OWNER TO "postgres";

-- ----------------------------
-- Sequence structure for account_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."account_id_seq";
CREATE SEQUENCE "public"."account_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for account_kind_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."account_kind_id_seq";
CREATE SEQUENCE "public"."account_kind_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for account_state_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."account_state_id_seq";
CREATE SEQUENCE "public"."account_state_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for account_type_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."account_type_id_seq";
CREATE SEQUENCE "public"."account_type_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for alarm_check_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."alarm_check_id_seq";
CREATE SEQUENCE "public"."alarm_check_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for alarm_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."alarm_id_seq";
CREATE SEQUENCE "public"."alarm_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for article_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."article_id_seq";
CREATE SEQUENCE "public"."article_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for asset_kind_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."asset_kind_id_seq";
CREATE SEQUENCE "public"."asset_kind_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for client_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."client_id_seq";
CREATE SEQUENCE "public"."client_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for colleague_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."colleague_id_seq";
CREATE SEQUENCE "public"."colleague_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for income_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."income_id_seq";
CREATE SEQUENCE "public"."income_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for job_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."job_id_seq";
CREATE SEQUENCE "public"."job_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for job_state_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."job_state_id_seq";
CREATE SEQUENCE "public"."job_state_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for message_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."message_id_seq";
CREATE SEQUENCE "public"."message_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for plan_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."plan_id_seq";
CREATE SEQUENCE "public"."plan_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for qa_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."qa_id_seq";
CREATE SEQUENCE "public"."qa_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Sequence structure for users_id_seq
-- ----------------------------
DROP SEQUENCE IF EXISTS "public"."users_id_seq";
CREATE SEQUENCE "public"."users_id_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 9223372036854775807
START 1
CACHE 1;

-- ----------------------------
-- Table structure for ACCOUNT
-- ----------------------------
DROP TABLE IF EXISTS "public"."ACCOUNT";
CREATE TABLE "public"."ACCOUNT" (
  "ID" int4 NOT NULL DEFAULT nextval('account_id_seq'::regclass),
  "Kind" int2 NOT NULL,
  "State" int2 NOT NULL,
  "AccountID" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
  "Email" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "Nation" varchar(30) COLLATE "pg_catalog"."default",
  "URL" varchar(100) COLLATE "pg_catalog"."default",
  "Income" float8 NOT NULL DEFAULT 0,
  "From" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "To" varchar(16) COLLATE "pg_catalog"."default",
  "Description" text COLLATE "pg_catalog"."default",
  "Note" text[] COLLATE "pg_catalog"."default",
  "UserID" int4 NOT NULL
)
;

-- ----------------------------
-- Records of ACCOUNT
-- ----------------------------

-- ----------------------------
-- Table structure for ACCOUNT_KIND
-- ----------------------------
DROP TABLE IF EXISTS "public"."ACCOUNT_KIND";
CREATE TABLE "public"."ACCOUNT_KIND" (
  "ID" int2 NOT NULL DEFAULT nextval('account_kind_id_seq'::regclass),
  "Name" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
  "Type" int2 NOT NULL,
  "Description" varchar(1024) COLLATE "pg_catalog"."default",
  "Note" text[] COLLATE "pg_catalog"."default",
  "Icon" varchar(30) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of ACCOUNT_KIND
-- ----------------------------
INSERT INTO "public"."ACCOUNT_KIND" VALUES (6, 'Skype', 2, NULL, '{color-sky}', 'icon-skype');
INSERT INTO "public"."ACCOUNT_KIND" VALUES (5, 'Github', 3, NULL, NULL, 'icon-github-text');
INSERT INTO "public"."ACCOUNT_KIND" VALUES (2, 'Upwork', 4, NULL, '{"",./assets/icons/upwork.png}', NULL);
INSERT INTO "public"."ACCOUNT_KIND" VALUES (1, 'Gmail', 1, NULL, '{color-verdure}', 'icon-gplus-1');
INSERT INTO "public"."ACCOUNT_KIND" VALUES (3, 'Linkedin', 4, NULL, '{color-sea}', 'icon-linkedin-2');

-- ----------------------------
-- Table structure for ACCOUNT_STATE
-- ----------------------------
DROP TABLE IF EXISTS "public"."ACCOUNT_STATE";
CREATE TABLE "public"."ACCOUNT_STATE" (
  "ID" int2 NOT NULL DEFAULT nextval('account_state_id_seq'::regclass),
  "Name" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
  "Description" varchar(1024) COLLATE "pg_catalog"."default",
  "Note" text[][] COLLATE "pg_catalog"."default",
  "Icon" varchar(30) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of ACCOUNT_STATE
-- ----------------------------
INSERT INTO "public"."ACCOUNT_STATE" VALUES (11, '2nd video verified', NULL, '{color-sky}', 'icon-desktop-circled');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (12, 'Video verified', NULL, '{color-blue}', 'icon-desktop');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (9, 'Available', NULL, '{color-sea}', 'icon-laptop-circled');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (10, '1st video verified', NULL, '{color-water}', 'icon-laptop');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (13, 'ID verified', NULL, '{color-verdure}', 'fa fa-desktop');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (14, 'Rising Talent', NULL, '{color-moss}', 'icon-star-half');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (15, 'Top rate', NULL, '{color-grass}', 'icon-star-1');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (16, 'Worked more 100hs', NULL, '{color-grass}', 'icon-gauge');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (17, 'Worked more 500hs', NULL, '{color-green}', 'icon-gauge-1');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (18, 'Worked more 1000hs', NULL, '{color-gold}', 'icon-light-down');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (1, 'Removed', NULL, '{color-crimson}', 'icon-cancel-circled-2');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (2, 'Lost', NULL, '{color-scarlet}', 'icon-minus-circled-1');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (3, 'Suspended', NULL, '{color-pink}', 'icon-eye-off');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (4, '1st video verifying...', NULL, '{color-brown}', 'icon-camera');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (5, '2nd video verifying...', NULL, '{color-brown}', 'icon-camera-2');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (6, 'Video verifying...', NULL, '{color-brown}', 'icon-camera-3');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (7, 'ID verifying...', NULL, '{color-brown}', 'icon-vcard');
INSERT INTO "public"."ACCOUNT_STATE" VALUES (8, 'Created', NULL, '{color-sea}', 'icon-play-circled2');

-- ----------------------------
-- Table structure for ACCOUNT_TYPE
-- ----------------------------
DROP TABLE IF EXISTS "public"."ACCOUNT_TYPE";
CREATE TABLE "public"."ACCOUNT_TYPE" (
  "ID" int2 NOT NULL DEFAULT nextval('account_type_id_seq'::regclass),
  "Name" text COLLATE "pg_catalog"."default" NOT NULL,
  "Amount" float8,
  "Note" text[] COLLATE "pg_catalog"."default",
  "Icon" varchar(30) COLLATE "pg_catalog"."default",
  "Description" varchar(1024) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of ACCOUNT_TYPE
-- ----------------------------
INSERT INTO "public"."ACCOUNT_TYPE" VALUES (3, 'Workplace', NULL, '{color-brown}', 'icon-back-in-time', '');
INSERT INTO "public"."ACCOUNT_TYPE" VALUES (2, 'Social network', NULL, '{color-verdure}', 'icon-network-1', '');
INSERT INTO "public"."ACCOUNT_TYPE" VALUES (4, 'Job mediation', NULL, '{color-pink}', 'icon-vimeo-circled', '');
INSERT INTO "public"."ACCOUNT_TYPE" VALUES (1, 'Email', NULL, '{color-blue}', 'icon-mail-1', '');

-- ----------------------------
-- Table structure for ADMINS
-- ----------------------------
DROP TABLE IF EXISTS "public"."ADMINS";
CREATE TABLE "public"."ADMINS" (
  "ID" int4 NOT NULL,
  "Email" varchar(50) COLLATE "pg_catalog"."default",
  "Password" varchar(100) COLLATE "pg_catalog"."default",
  "Name" varchar(30) COLLATE "pg_catalog"."default",
  "Permission" int2
)
;

-- ----------------------------
-- Records of ADMINS
-- ----------------------------
INSERT INTO "public"."ADMINS" VALUES (1, 'admin', '$10$XQ.0aMi343o2f48iLlROp.mXecWhLCkP/fEa8FIxz2wrP6kYijvKq', 'admin', 1);

-- ----------------------------
-- Table structure for ALARM
-- ----------------------------
DROP TABLE IF EXISTS "public"."ALARM";
CREATE TABLE "public"."ALARM" (
  "ID" int4 NOT NULL DEFAULT nextval('alarm_id_seq'::regclass),
  "Type" int2 NOT NULL,
  "Contents" text COLLATE "pg_catalog"."default" NOT NULL,
  "Description" text COLLATE "pg_catalog"."default",
  "Since" varchar(20) COLLATE "pg_catalog"."default" NOT NULL,
  "Status" int2[] NOT NULL,
  "UsersID" int4[] NOT NULL,
  "Timezone" varchar(6) COLLATE "pg_catalog"."default" NOT NULL,
  "Date" int8,
  "Creater" int4 NOT NULL
)
;

-- ----------------------------
-- Records of ALARM
-- ----------------------------

-- ----------------------------
-- Table structure for ALARM_CHECK
-- ----------------------------
DROP TABLE IF EXISTS "public"."ALARM_CHECK";
CREATE TABLE "public"."ALARM_CHECK" (
  "ID" int4 NOT NULL DEFAULT nextval('alarm_check_id_seq'::regclass),
  "Monthly" varchar(16) COLLATE "pg_catalog"."default",
  "Weekly" varchar(16) COLLATE "pg_catalog"."default",
  "Daily" varchar(16) COLLATE "pg_catalog"."default",
  "Yearly" varchar(16) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of ALARM_CHECK
-- ----------------------------
INSERT INTO "public"."ALARM_CHECK" VALUES (4, '2024-03-06 17:58', '2024-03-10 17:49', '2024-03-15 00:00', '2024-03-06 17:58');

-- ----------------------------
-- Table structure for ARTICLE
-- ----------------------------
DROP TABLE IF EXISTS "public"."ARTICLE";
CREATE TABLE "public"."ARTICLE" (
  "ID" int4 NOT NULL DEFAULT nextval('article_id_seq'::regclass),
  "Title" varchar(256) COLLATE "pg_catalog"."default" NOT NULL,
  "Text" text COLLATE "pg_catalog"."default" NOT NULL,
  "Contents" json NOT NULL,
  "Note" text[] COLLATE "pg_catalog"."default",
  "Date" text COLLATE "pg_catalog"."default" NOT NULL,
  "UserID" int4 NOT NULL
)
;

-- ----------------------------
-- Records of ARTICLE
-- ----------------------------
INSERT INTO "public"."ARTICLE" VALUES (71, 'URLs to check Cryptocurrencies', '1) BITCOINhttps://www.cointracker.io/wallet/BTChttps://www.blockonomics.cohttps://blockchair.com', '{"blocks":[{"key":"2oebh","text":"1) BITCOIN","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"5bqls","text":"https://www.cointracker.io/wallet/BTC","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"860uu","text":"https://www.blockonomics.co","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"futn1","text":"https://blockchair.com","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}}],"entityMap":{}}', NULL, '2024-03-07 03:23', 15);
INSERT INTO "public"."ARTICLE" VALUES (75, 'Solana blockchain services', 'https://imintify.com (NFT marketplace)', '{"blocks":[{"key":"3etc3","text":"https://imintify.com (NFT marketplace)","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}}],"entityMap":{}}', NULL, '2024-03-09 09:12', 15);
INSERT INTO "public"."ARTICLE" VALUES (72, 'Sample URLs', '1) Vue:http://www.romwe.co.in (v3.2.41)2) Next + Nest + Typescripthttps://app.patientsinfluence.com', '{"blocks":[{"key":"ema0v","text":"1) Vue:","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"4l97d","text":"http://www.romwe.co.in (v3.2.41)","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"4lq37","text":"2) Next + Nest + Typescript","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"78oje","text":"https://app.patientsinfluence.com","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}}],"entityMap":{}}', NULL, '2024-03-07 14:40', 15);
INSERT INTO "public"."ARTICLE" VALUES (73, 'Blockchain URLs', 'NFT staking:https://stake.lido.fi/rewardsNFT service:https://www.metamaniacsnft.comhttps://www.wagmigame.io (game: src: https://etherscan.io/token/0x1e987df68cc13d271e621ec82e050a1bbd62c180)DeFi:http://gyro.moneyDEX & DeFi:https://www.thorchain.comDEX:https://shibatoken.com', '{"blocks":[{"key":"66ali","text":"NFT staking:","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":12,"style":"BOLD"}],"entityRanges":[],"data":{}},{"key":"a1h3l","text":"https://stake.lido.fi/rewards","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"dqs9a","text":"NFT service:","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":12,"style":"BOLD"}],"entityRanges":[],"data":{}},{"key":"bpe6l","text":"https://www.metamaniacsnft.com","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":30,"style":"fontsize-11pt"},{"offset":0,"length":30,"style":"fontfamily-Calibri, sans-serif"}],"entityRanges":[],"data":{}},{"key":"168sv","text":"https://www.wagmigame.io (game: src: https://etherscan.io/token/0x1e987df68cc13d271e621ec82e050a1bbd62c180)","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":107,"style":"fontsize-11pt"},{"offset":0,"length":107,"style":"fontfamily-Calibri, sans-serif"}],"entityRanges":[],"data":{}},{"key":"5s1c1","text":"DeFi:","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":5,"style":"BOLD"}],"entityRanges":[],"data":{}},{"key":"41anh","text":"http://gyro.money","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"7vj65","text":"DEX & DeFi:","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":11,"style":"BOLD"}],"entityRanges":[],"data":{}},{"key":"a1351","text":"https://www.thorchain.com","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"a6o94","text":"DEX:","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":4,"style":"BOLD"}],"entityRanges":[],"data":{}},{"key":"9rs8m","text":"https://shibatoken.com","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}}],"entityMap":{}}', NULL, '2024-03-09 01:31', 15);
INSERT INTO "public"."ARTICLE" VALUES (74, 'Web sample URLs', 'React:https://creepz.coSohpify + Vue + PayPal + Shop pay:https://nft.casetify.comNext:https://u-mts.comAngular12.2.1 + Laravel + Typescripthttps://1mlnnfts.com', '{"blocks":[{"key":"3pe3k","text":"React:","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":6,"style":"BOLD"}],"entityRanges":[],"data":{}},{"key":"1tj3a","text":"https://creepz.co","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"eck2v","text":"Sohpify + Vue + PayPal + Shop pay:","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":34,"style":"BOLD"}],"entityRanges":[],"data":{}},{"key":"3g7l7","text":"https://nft.casetify.com","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":24,"style":"fontsize-11pt"},{"offset":0,"length":24,"style":"fontfamily-Calibri, sans-serif"},{"offset":0,"length":24,"style":"UNDERLINE"}],"entityRanges":[{"offset":0,"length":24,"key":0}],"data":{}},{"key":"cau05","text":"Next:","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":5,"style":"fontsize-11pt"},{"offset":0,"length":5,"style":"fontfamily-Calibri, sans-serif"},{"offset":0,"length":5,"style":"BOLD"}],"entityRanges":[],"data":{}},{"key":"c6plr","text":"https://u-mts.com","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":17,"style":"fontsize-11pt"},{"offset":0,"length":17,"style":"fontfamily-Calibri, sans-serif"}],"entityRanges":[],"data":{}},{"key":"8vin0","text":"Angular12.2.1 + Laravel + Typescript","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":36,"style":"fontsize-11pt"},{"offset":0,"length":36,"style":"fontfamily-Calibri, sans-serif"},{"offset":0,"length":36,"style":"BOLD"}],"entityRanges":[],"data":{}},{"key":"74c1e","text":"https://1mlnnfts.com","type":"unstyled","depth":0,"inlineStyleRanges":[{"offset":0,"length":20,"style":"fontsize-11pt"},{"offset":0,"length":20,"style":"fontfamily-Calibri, sans-serif"}],"entityRanges":[{"offset":0,"length":20,"key":1}],"data":{}}],"entityMap":{"0":{"type":"LINK","mutability":"MUTABLE","data":{"url":"https://nft.casetify.com","title":"https://nft.casetify.com","targetOption":"","_map":{"type":"LINK","mutability":"MUTABLE","data":{"url":"https://nft.casetify.com","title":"https://nft.casetify.com","targetOption":""}}}},"1":{"type":"LINK","mutability":"MUTABLE","data":{"url":"https://1mlnnfts.com","title":"https://1mlnnfts.com","targetOption":"","_map":{"type":"LINK","mutability":"MUTABLE","data":{"url":"https://1mlnnfts.com","title":"https://1mlnnfts.com","targetOption":""}}}}}}', NULL, '2024-03-09 01:36', 15);
INSERT INTO "public"."ARTICLE" VALUES (70, 'Making USA information', 'SSN Number:https://www.ssn-verify.com/generatePhone number:https://zadarma.com/en/tariffs/numbers/united-states/mobile/https://www.bestrandoms.com/random-phone-numberhttps://codebeautify.org/random-phone-number', '{"blocks":[{"key":"dggf9","text":"SSN Number:","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"e90kk","text":"https://www.ssn-verify.com/generate","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"7dn2j","text":"Phone number:","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"54m0r","text":"https://zadarma.com/en/tariffs/numbers/united-states/mobile/","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"2bds4","text":"https://www.bestrandoms.com/random-phone-number","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}},{"key":"c045v","text":"https://codebeautify.org/random-phone-number","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}}],"entityMap":{}}', NULL, '2024-03-06 23:08', 15);
INSERT INTO "public"."ARTICLE" VALUES (76, 'Ukraine phone number generator', 'https://www.bestrandoms.com/random-ua-phone-number', '{"blocks":[{"key":"2tf7s","text":"https://www.bestrandoms.com/random-ua-phone-number","type":"unstyled","depth":0,"inlineStyleRanges":[],"entityRanges":[],"data":{}}],"entityMap":{}}', NULL, '2024-03-14 16:44', 15);

-- ----------------------------
-- Table structure for ASSET_KIND
-- ----------------------------
DROP TABLE IF EXISTS "public"."ASSET_KIND";
CREATE TABLE "public"."ASSET_KIND" (
  "ID" int4 NOT NULL DEFAULT nextval('asset_kind_id_seq'::regclass),
  "Name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "Description" text COLLATE "pg_catalog"."default",
  "Note" text[] COLLATE "pg_catalog"."default",
  "Icon" varchar(30) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of ASSET_KIND
-- ----------------------------
INSERT INTO "public"."ASSET_KIND" VALUES (4, 'Docs', NULL, '{color-yellow}', 'icon-publish');
INSERT INTO "public"."ASSET_KIND" VALUES (2, 'Book', NULL, '{color-white}', 'icon-book');
INSERT INTO "public"."ASSET_KIND" VALUES (1, 'Source', NULL, '{color-sky}', 'icon-database');
INSERT INTO "public"."ASSET_KIND" VALUES (3, 'Photo', NULL, '{color-yellow}', 'icon-picture');

-- ----------------------------
-- Table structure for CLIENT
-- ----------------------------
DROP TABLE IF EXISTS "public"."CLIENT";
CREATE TABLE "public"."CLIENT" (
  "ID" int4 NOT NULL DEFAULT nextval('client_id_seq'::regclass),
  "Nation" varchar(30) COLLATE "pg_catalog"."default",
  "Gender" bool NOT NULL DEFAULT true,
  "Name" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
  "Income" float8 NOT NULL DEFAULT 0,
  "Description" text COLLATE "pg_catalog"."default",
  "Contact" varchar(1024) COLLATE "pg_catalog"."default" NOT NULL,
  "Address" varchar(50) COLLATE "pg_catalog"."default",
  "Birthday" varchar(10) COLLATE "pg_catalog"."default",
  "History" text[] COLLATE "pg_catalog"."default",
  "Note" text[] COLLATE "pg_catalog"."default",
  "From" varchar(10) COLLATE "pg_catalog"."default" NOT NULL
)
;

-- ----------------------------
-- Records of CLIENT
-- ----------------------------

-- ----------------------------
-- Table structure for COLLEAGUE
-- ----------------------------
DROP TABLE IF EXISTS "public"."COLLEAGUE";
CREATE TABLE "public"."COLLEAGUE" (
  "ID" int4 NOT NULL DEFAULT nextval('colleague_id_seq'::regclass),
  "Name" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
  "Major" varchar(256) COLLATE "pg_catalog"."default" NOT NULL,
  "Nation" varchar(30) COLLATE "pg_catalog"."default",
  "Contact" varchar(1024) COLLATE "pg_catalog"."default" NOT NULL,
  "Gender" bool DEFAULT true,
  "Description" text COLLATE "pg_catalog"."default",
  "Note" text[] COLLATE "pg_catalog"."default",
  "Payment" float8 DEFAULT 0,
  "From" varchar(10) COLLATE "pg_catalog"."default" NOT NULL
)
;

-- ----------------------------
-- Records of COLLEAGUE
-- ----------------------------

-- ----------------------------
-- Table structure for INCOME
-- ----------------------------
DROP TABLE IF EXISTS "public"."INCOME";
CREATE TABLE "public"."INCOME" (
  "ID" int4 NOT NULL DEFAULT nextval('income_id_seq'::regclass),
  "Name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "Date" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "Job" int4,
  "Description" text COLLATE "pg_catalog"."default",
  "Amount" float8 NOT NULL,
  "UserID" int4 NOT NULL,
  "Colleague" int4
)
;

-- ----------------------------
-- Records of INCOME
-- ----------------------------

-- ----------------------------
-- Table structure for JOB
-- ----------------------------
DROP TABLE IF EXISTS "public"."JOB";
CREATE TABLE "public"."JOB" (
  "ID" int4 NOT NULL DEFAULT nextval('job_id_seq'::regclass),
  "Name" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "State" int2 NOT NULL,
  "Subject" varchar(256) COLLATE "pg_catalog"."default" NOT NULL,
  "Type" int2 NOT NULL,
  "Client" int4 NOT NULL,
  "Account" int4 NOT NULL,
  "Price" float8 NOT NULL,
  "From" varchar(10) COLLATE "pg_catalog"."default" NOT NULL,
  "To" varchar(10) COLLATE "pg_catalog"."default",
  "Description" text COLLATE "pg_catalog"."default",
  "Note" text[] COLLATE "pg_catalog"."default",
  "History" text[] COLLATE "pg_catalog"."default",
  "UserID" int2 NOT NULL,
  "Income" float8 NOT NULL DEFAULT 0
)
;

-- ----------------------------
-- Records of JOB
-- ----------------------------

-- ----------------------------
-- Table structure for JOB_STATE
-- ----------------------------
DROP TABLE IF EXISTS "public"."JOB_STATE";
CREATE TABLE "public"."JOB_STATE" (
  "ID" int4 NOT NULL DEFAULT nextval('job_state_id_seq'::regclass),
  "Name" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
  "Description" varchar(1024) COLLATE "pg_catalog"."default",
  "Note" text[] COLLATE "pg_catalog"."default",
  "Icon" varchar(30) COLLATE "pg_catalog"."default"
)
;

-- ----------------------------
-- Records of JOB_STATE
-- ----------------------------
INSERT INTO "public"."JOB_STATE" VALUES (1, 'Removed', NULL, '{color-crimson}', 'icon-trash');
INSERT INTO "public"."JOB_STATE" VALUES (2, 'Cheat', NULL, '{color-scarlet}', 'icon-warning');
INSERT INTO "public"."JOB_STATE" VALUES (3, 'Fired up', NULL, '{color-pink}', 'icon-block');
INSERT INTO "public"."JOB_STATE" VALUES (4, 'Stopped', NULL, '{color-yellow}', 'icon-stop-1');
INSERT INTO "public"."JOB_STATE" VALUES (5, 'Will start', NULL, '{color-sea}', 'icon-play-3');
INSERT INTO "public"."JOB_STATE" VALUES (6, 'On Going', NULL, '{color-blue}', 'icon-right-fat');
INSERT INTO "public"."JOB_STATE" VALUES (7, 'Ended', NULL, '{color-verdure}', 'icon-to-end-1');
INSERT INTO "public"."JOB_STATE" VALUES (8, 'Completed', NULL, '{color-green}', 'icon-ok-circled-1');

-- ----------------------------
-- Table structure for MSG
-- ----------------------------
DROP TABLE IF EXISTS "public"."MSG";
CREATE TABLE "public"."MSG" (
  "ID" int4 NOT NULL DEFAULT nextval('message_id_seq'::regclass),
  "Sender" int4 NOT NULL,
  "Receivers" int4[] NOT NULL,
  "Msg" text COLLATE "pg_catalog"."default" NOT NULL,
  "Reader" int4[] NOT NULL,
  "SendDate" timestamp(6) NOT NULL
)
;

-- ----------------------------
-- Records of MSG
-- ----------------------------
INSERT INTO "public"."MSG" VALUES (7, 14, '{16}', 'Hi, George, What are you doing now?', '{}', '2024-03-10 05:12:33');
INSERT INTO "public"."MSG" VALUES (8, 16, '{14}', 'Now?', '{14}', '2024-03-11 20:04:37');
INSERT INTO "public"."MSG" VALUES (9, 16, '{14}', '😩', '{14}', '2024-03-11 20:05:15');

-- ----------------------------
-- Table structure for PLAN
-- ----------------------------
DROP TABLE IF EXISTS "public"."PLAN";
CREATE TABLE "public"."PLAN" (
  "ID" int4 NOT NULL DEFAULT nextval('plan_id_seq'::regclass),
  "Date" varchar(10) COLLATE "pg_catalog"."default" NOT NULL,
  "Amount" int2 NOT NULL,
  "Income" float4 DEFAULT 0,
  "Note" text[] COLLATE "pg_catalog"."default",
  "UserID" int4 NOT NULL,
  "Outcome" float4
)
;

-- ----------------------------
-- Records of PLAN
-- ----------------------------

-- ----------------------------
-- Table structure for QA
-- ----------------------------
DROP TABLE IF EXISTS "public"."QA";
CREATE TABLE "public"."QA" (
  "ID" int4 NOT NULL DEFAULT nextval('qa_id_seq'::regclass),
  "CreaterID" int4,
  "AnswererID" int4,
  "Contents" text COLLATE "pg_catalog"."default" NOT NULL,
  "Date" varchar(16) COLLATE "pg_catalog"."default",
  "Title" varchar(256) COLLATE "pg_catalog"."default",
  "QuestionID" int4 DEFAULT 0
)
;

-- ----------------------------
-- Records of QA
-- ----------------------------
INSERT INTO "public"."QA" VALUES (29, 16, NULL, 'I am working on Django+react+postgresql project.
But I face crucial problem. It`s authentication. I `d like to use jwt, but it`s not work well.
I need a tactic.', '2024-03-12 14:35', 'Problem on using token in Django', 0);

-- ----------------------------
-- Table structure for USERS
-- ----------------------------
DROP TABLE IF EXISTS "public"."USERS";
CREATE TABLE "public"."USERS" (
  "ID" int4 NOT NULL DEFAULT nextval('users_id_seq'::regclass),
  "Email" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "Password" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "Name" varchar(30) COLLATE "pg_catalog"."default" NOT NULL,
  "Gender" bool NOT NULL DEFAULT true,
  "Birthday" varchar(10) COLLATE "pg_catalog"."default" NOT NULL,
  "Position" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "Address" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "TeamNo" int2 NOT NULL DEFAULT 0,
  "History" text[][] COLLATE "pg_catalog"."default",
  "Note" text[][] COLLATE "pg_catalog"."default",
  "Income" float8 DEFAULT 0
)
;

-- ----------------------------
-- Records of USERS
-- ----------------------------
INSERT INTO "public"."USERS" VALUES (15, 'apollo21century@gmail.com', '$2a$10$XQ.0aMi343o2f48iLlROp.mXecWhLCkP/fEa8FIxz2wrP6kYijvKq', 'Jiners', 't', '1987-07-02', 'Leader', '2955 Champion way Tustin CA USA', 2, NULL, NULL, 0);
INSERT INTO "public"."USERS" VALUES (16, 'erostry515@gmail.com', '$2a$10$65xPvkA0U6Uk0yquLoRpSO6QMJO5qO6LwV8jmkPjcGge6eW1Avg4a', 'George Moon', 't', '2000-05-15', 'US', '2960 Champion Way Apt 2407', 2, NULL, NULL, 0);
INSERT INTO "public"."USERS" VALUES (17, 'new1290star@hotmail.com', '$2a$10$Qh6SxQEXHVtiSF20EL3/D.83qyyBEcOPfQ/J13DoJLa76h/RaCTd.', 'Davies', 't', '1998-01-29', 'Software developer', 'Mexico', 2, NULL, NULL, 0);
INSERT INTO "public"."USERS" VALUES (18, 'beautifuldevsworld@gmail.com', '$2a$10$ex0Rrct1jSKxuv4rOKZKIuFMZR6Htu6eacW6A7u3EsyAzFiQKS5ai', 'DevWorld', 't', '2002-12-01', 'Developer', 'Canada', 0, NULL, NULL, 0);
INSERT INTO "public"."USERS" VALUES (14, 'paul@gmail.com', '$2a$10$K3MycjHe826e7aADshEtA./4PNdHtegEIC1Ee2ruHHGpRF.6EtkRW', 'GundersonPaul', 't', '2002-12-23', 'developer', 'Japan', 2, NULL, NULL, 0);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."account_id_seq"
OWNED BY "public"."ACCOUNT"."ID";
SELECT setval('"public"."account_id_seq"', 35, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."account_kind_id_seq"
OWNED BY "public"."ACCOUNT_KIND"."ID";
SELECT setval('"public"."account_kind_id_seq"', 9, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."account_state_id_seq"
OWNED BY "public"."ACCOUNT_STATE"."ID";
SELECT setval('"public"."account_state_id_seq"', 22, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."account_type_id_seq"
OWNED BY "public"."ACCOUNT_TYPE"."ID";
SELECT setval('"public"."account_type_id_seq"', 7, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."alarm_check_id_seq"
OWNED BY "public"."ALARM_CHECK"."ID";
SELECT setval('"public"."alarm_check_id_seq"', 4, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."alarm_id_seq"
OWNED BY "public"."ALARM"."ID";
SELECT setval('"public"."alarm_id_seq"', 33, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."article_id_seq"
OWNED BY "public"."ARTICLE"."ID";
SELECT setval('"public"."article_id_seq"', 76, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."asset_kind_id_seq"
OWNED BY "public"."ASSET_KIND"."ID";
SELECT setval('"public"."asset_kind_id_seq"', 7, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."client_id_seq"
OWNED BY "public"."CLIENT"."ID";
SELECT setval('"public"."client_id_seq"', 21, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."colleague_id_seq"
OWNED BY "public"."COLLEAGUE"."ID";
SELECT setval('"public"."colleague_id_seq"', 8, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."income_id_seq"
OWNED BY "public"."INCOME"."ID";
SELECT setval('"public"."income_id_seq"', 17, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."job_id_seq"
OWNED BY "public"."JOB"."ID";
SELECT setval('"public"."job_id_seq"', 12, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
SELECT setval('"public"."job_state_id_seq"', 4, false);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
SELECT setval('"public"."message_id_seq"', 9, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."plan_id_seq"
OWNED BY "public"."PLAN"."ID";
SELECT setval('"public"."plan_id_seq"', 5, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."qa_id_seq"
OWNED BY "public"."QA"."ID";
SELECT setval('"public"."qa_id_seq"', 29, true);

-- ----------------------------
-- Alter sequences owned by
-- ----------------------------
ALTER SEQUENCE "public"."users_id_seq"
OWNED BY "public"."USERS"."ID";
SELECT setval('"public"."users_id_seq"', 18, true);

-- ----------------------------
-- Primary Key structure for table ACCOUNT
-- ----------------------------
ALTER TABLE "public"."ACCOUNT" ADD CONSTRAINT "account_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table ACCOUNT_KIND
-- ----------------------------
ALTER TABLE "public"."ACCOUNT_KIND" ADD CONSTRAINT "account_kind_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table ACCOUNT_STATE
-- ----------------------------
ALTER TABLE "public"."ACCOUNT_STATE" ADD CONSTRAINT "account_state_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table ACCOUNT_TYPE
-- ----------------------------
ALTER TABLE "public"."ACCOUNT_TYPE" ADD CONSTRAINT "account_type_pkey" PRIMARY KEY ("ID", "Name");

-- ----------------------------
-- Primary Key structure for table ADMINS
-- ----------------------------
ALTER TABLE "public"."ADMINS" ADD CONSTRAINT "Admins_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table ALARM
-- ----------------------------
ALTER TABLE "public"."ALARM" ADD CONSTRAINT "alarm_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table ALARM_CHECK
-- ----------------------------
ALTER TABLE "public"."ALARM_CHECK" ADD CONSTRAINT "alarm_check_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table ARTICLE
-- ----------------------------
ALTER TABLE "public"."ARTICLE" ADD CONSTRAINT "article_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table ASSET_KIND
-- ----------------------------
ALTER TABLE "public"."ASSET_KIND" ADD CONSTRAINT "asset_kind_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table CLIENT
-- ----------------------------
ALTER TABLE "public"."CLIENT" ADD CONSTRAINT "client_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table COLLEAGUE
-- ----------------------------
ALTER TABLE "public"."COLLEAGUE" ADD CONSTRAINT "colleague_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table INCOME
-- ----------------------------
ALTER TABLE "public"."INCOME" ADD CONSTRAINT "income_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table JOB
-- ----------------------------
ALTER TABLE "public"."JOB" ADD CONSTRAINT "job_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table MSG
-- ----------------------------
ALTER TABLE "public"."MSG" ADD CONSTRAINT "message_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table PLAN
-- ----------------------------
ALTER TABLE "public"."PLAN" ADD CONSTRAINT "plan_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table QA
-- ----------------------------
ALTER TABLE "public"."QA" ADD CONSTRAINT "qa_pkey" PRIMARY KEY ("ID");

-- ----------------------------
-- Primary Key structure for table USERS
-- ----------------------------
ALTER TABLE "public"."USERS" ADD CONSTRAINT "users_pkey" PRIMARY KEY ("ID", "Email", "Address");