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)