yvEbhCac

1bookmakr_folder      sequence: 0
2  bookmark              sequence: 0
3  bookmark              sequence: 1
4bookmakr_folder      sequence: 1
5  bookmark              sequence: 0
6bookmark   (not in any folder)    sequence: 2
7bookmark   (not in any folder)    sequence: 3
8	
9CREATE TABLE IF NOT EXISTS "bookmark_folder"(
10  "id" SERIAL NOT NULL,
11  "sequence" integer NOT NULL,
12  "name" varchar DEFAULT NULL,
13  "description" varchar DEFAULT NULL,
14  PRIMARY KEY ("id"),
15  FOREIGN KEY ("create_by_user_id") REFERENCES "user" ("id") ON DELETE CASCADE ON UPDATE CASCADE
16);
17
18
19CREATE TABLE IF NOT EXISTS "bookmark"(
20  "id" SERIAL NOT NULL,
21  "sequence" integer NOT NULL,
22  "bookmark_folder_id" integer NOT NULL,
23  "url_id" integer NOT NULL,
24  PRIMARY KEY ("id"),
25  FOREIGN KEY ("bookmark_folder_id") REFERENCES "bookmark_folder" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
26  FOREIGN KEY ("url_id") REFERENCES "url" ("id") ON DELETE CASCADE ON UPDATE CASCADE
27);