diff options
| author | Joe Chen <jc@unknwon.io> | 2022-06-25 18:07:39 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-06-25 18:07:39 +0800 |
| commit | 083c3ee659c6c5542687f3bafae68cbc24dbc90f (patch) | |
| tree | 0103bf3b5c5ebfccd368a7cb6a425a521fd669d9 /docs/dev | |
| parent | 9df4e3ae3c555a86f691f0d78a43834842e77d8b (diff) | |
db: refactor "action" table to use GORM (#7054)
Co-authored-by: deepsource-autofix[bot] <62050782+deepsource-autofix[bot]@users.noreply.github.com>
Diffstat (limited to 'docs/dev')
| -rw-r--r-- | docs/dev/database_schema.md | 24 |
1 files changed, 24 insertions, 0 deletions
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" ``` |