diff options
| author | Joe Chen <jc@unknwon.io> | 2023-05-14 20:15:47 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2023-05-14 20:15:47 -0400 |
| commit | 0721ef2399c7c0e7f01ee96530b99f883434c623 (patch) | |
| tree | 8ddb3e5002ab0b7402a6339c7781d91caebd96e7 /docs | |
| parent | 9ac93067f640ca228ff218de1686ff61e8747d05 (diff) | |
refactor(db): migrate off `user_email.go` to `users.go` (#7452)
Diffstat (limited to 'docs')
| -rw-r--r-- | docs/dev/database_schema.md | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/docs/dev/database_schema.md b/docs/dev/database_schema.md index ac4cd24e..e33321e3 100644 --- a/docs/dev/database_schema.md +++ b/docs/dev/database_schema.md @@ -55,6 +55,22 @@ Indexes: "idx_action_user_id" (user_id) ``` +# Table "email_address" + +``` + FIELD | COLUMN | POSTGRESQL | MYSQL | SQLITE3 +--------------+--------------+--------------------------------+--------------------------------+--------------------------------- + ID | id | BIGSERIAL | BIGINT AUTO_INCREMENT | INTEGER + UserID | uid | BIGINT NOT NULL | BIGINT NOT NULL | INTEGER NOT NULL + Email | email | VARCHAR(254) NOT NULL | VARCHAR(254) NOT NULL | TEXT NOT NULL + IsActivated | is_activated | BOOLEAN NOT NULL DEFAULT FALSE | BOOLEAN NOT NULL DEFAULT FALSE | NUMERIC NOT NULL DEFAULT FALSE + +Primary keys: id +Indexes: + "email_address_user_email_unique" UNIQUE (uid, email) + "idx_email_address_user_id" (uid) +``` + # Table "follow" ``` |