diff options
author | Joe Chen <jc@unknwon.io> | 2022-10-23 16:17:53 +0800 |
---|---|---|
committer | GitHub <noreply@github.com> | 2022-10-23 16:17:53 +0800 |
commit | b1fefcbe5011a4a792808faaf26fae6881ecc1b0 (patch) | |
tree | 42c3d2922ea8460f6f5bf1ebb314039275c25ec2 /docs | |
parent | 8077360cf6370c9ddb026f2432ceb4f4f4ac31c4 (diff) |
refactor(db): migrate `Follow` off `user.go` (#7203)
Diffstat (limited to 'docs')
-rw-r--r-- | docs/dev/database_schema.md | 14 |
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" ``` |