aboutsummaryrefslogtreecommitdiff
path: root/docs
diff options
context:
space:
mode:
authorJoe Chen <jc@unknwon.io>2022-10-23 16:17:53 +0800
committerGitHub <noreply@github.com>2022-10-23 16:17:53 +0800
commitb1fefcbe5011a4a792808faaf26fae6881ecc1b0 (patch)
tree42c3d2922ea8460f6f5bf1ebb314039275c25ec2 /docs
parent8077360cf6370c9ddb026f2432ceb4f4f4ac31c4 (diff)
refactor(db): migrate `Follow` off `user.go` (#7203)
Diffstat (limited to 'docs')
-rw-r--r--docs/dev/database_schema.md14
1 files changed, 14 insertions, 0 deletions
diff --git a/docs/dev/database_schema.md b/docs/dev/database_schema.md
index 8de32a7e..ac4cd24e 100644
--- a/docs/dev/database_schema.md
+++ b/docs/dev/database_schema.md
@@ -55,6 +55,20 @@ Indexes:
"idx_action_user_id" (user_id)
```
+# Table "follow"
+
+```
+ FIELD | COLUMN | POSTGRESQL | MYSQL | SQLITE3
+-----------+-----------+-----------------+-----------------------+-------------------
+ ID | id | BIGSERIAL | BIGINT AUTO_INCREMENT | INTEGER
+ UserID | user_id | BIGINT NOT NULL | BIGINT NOT NULL | INTEGER NOT NULL
+ FollowID | follow_id | BIGINT NOT NULL | BIGINT NOT NULL | INTEGER NOT NULL
+
+Primary keys: id
+Indexes:
+ "follow_user_follow_unique" UNIQUE (user_id, follow_id)
+```
+
# Table "lfs_object"
```