obsidian-db

Tables (4)

File (파일)

  • id (Key) — integer — Primary key — NOT NULL
  • filePath (Field) — varchar(255)
  • urlPath (Field2) — varchar(255)
  • fileType (Field3) — varchar(255)
  • metadata (Field4) — jsonb

FileTag (파일 태그)

  • id (Key) — integer — Primary key — NOT NULL
  • fileId (FK1) — integer — Foreign key → File.id — NOT NULL
  • tagId (FK2) — integer — Foreign key → Tag.id — NOT NULL

Link (링크)

  • id (Key) — integer — Primary key — NOT NULL
  • sourceFileId (FK) — integer — Foreign key → File.id — NOT NULL
  • targetFileId (FK2) — integer — Foreign key → File.id — NOT NULL
  • type (Field) — text

Tag (태그)

  • id (Key) — integer — Primary key — NOT NULL
  • name (Field) — varchar(255)