From 083c3ee659c6c5542687f3bafae68cbc24dbc90f Mon Sep 17 00:00:00 2001 From: Joe Chen Date: Sat, 25 Jun 2022 18:07:39 +0800 Subject: db: refactor "action" table to use GORM (#7054) Co-authored-by: deepsource-autofix[bot] <62050782+deepsource-autofix[bot]@users.noreply.github.com> --- docs/dev/database_schema.md | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) (limited to 'docs/dev/database_schema.md') diff --git a/docs/dev/database_schema.md b/docs/dev/database_schema.md index a5d6641d..8de32a7e 100644 --- a/docs/dev/database_schema.md +++ b/docs/dev/database_schema.md @@ -31,6 +31,30 @@ Indexes: "idx_access_token_user_id" (uid) ``` +# Table "action" + +``` + FIELD | COLUMN | POSTGRESQL | MYSQL | SQLITE3 +---------------+----------------+--------------------------------+--------------------------------+--------------------------------- + ID | id | BIGSERIAL | BIGINT AUTO_INCREMENT | INTEGER + UserID | user_id | BIGINT | BIGINT | INTEGER + OpType | op_type | BIGINT | BIGINT | INTEGER + ActUserID | act_user_id | BIGINT | BIGINT | INTEGER + ActUserName | act_user_name | TEXT | LONGTEXT | TEXT + RepoID | repo_id | BIGINT | BIGINT | INTEGER + RepoUserName | repo_user_name | TEXT | LONGTEXT | TEXT + RepoName | repo_name | TEXT | LONGTEXT | TEXT + RefName | ref_name | TEXT | LONGTEXT | TEXT + IsPrivate | is_private | BOOLEAN NOT NULL DEFAULT FALSE | BOOLEAN NOT NULL DEFAULT FALSE | NUMERIC NOT NULL DEFAULT FALSE + Content | content | TEXT | LONGTEXT | TEXT + CreatedUnix | created_unix | BIGINT | BIGINT | INTEGER + +Primary keys: id +Indexes: + "idx_action_repo_id" (repo_id) + "idx_action_user_id" (user_id) +``` + # Table "lfs_object" ``` -- cgit v1.2.3